Re: [sqlalchemy] engine_from_config and connect_args

2015-01-02 Thread Michael Bayer
vote on getting the actual pysqlite bug fixed, this is just a workaround for their bug! http://bugs.python.org/issue9924 Boris SABATIER wrote: > Thanks Michael, > > Even if it a "code side" solution, I think I will do it. > > 2014-12-31 1:07 GMT+01:00 Michael Bayer : >> Boris SABATIER wro

Re: [sqlalchemy] engine_from_config and connect_args

2015-01-02 Thread Boris SABATIER
Thanks Michael, Even if it a "code side" solution, I think I will do it. 2014-12-31 1:07 GMT+01:00 Michael Bayer : > > > Boris SABATIER wrote: > >> Thanks Michael for the explanation. >> >> The solution you link solve work but it doesn't satisfy me. >> I use sqlite in developement and postgre in

Re: [sqlalchemy] engine_from_config and connect_args

2014-12-30 Thread Michael Bayer
Boris SABATIER wrote: > Thanks Michael for the explanation. > > The solution you link solve work but it doesn't satisfy me. > I use sqlite in developement and postgre in production. That's why I'm > looking for a "configuration's solution". > > If you think it's isn't possible ti work, I will

Re: [sqlalchemy] engine_from_config and connect_args

2014-12-30 Thread Boris SABATIER
Thanks Michael for the explanation. The solution you link solve work but it doesn't satisfy me. I use sqlite in developement and postgre in production. That's why I'm looking for a "configuration's solution". If you think it's isn't possible ti work, I will use postgre in each environement. 201

Re: [sqlalchemy] engine_from_config and connect_args

2014-12-30 Thread Michael Bayer
Boris SABATIER wrote: > @Michael: > Are you sure the default value of isolation_level is None ? OK what I forgot to clarify in my other email is that you’re working with “connect_args” here, which with engine_from_config would not be a separate .ini value in any case; things that go into creat

Re: [sqlalchemy] engine_from_config and connect_args

2014-12-30 Thread Michael Bayer
Michael Bayer wrote: >> >> # ini file : >> sqlalchemy.connect_args = {'isolation_level':None} > > well if this were to be available in an .ini file, that’s not Python code in > an .ini file, it would have to be interpreted, such as: > > sqlalchemy.connect_args = none for those readi

Re: [sqlalchemy] engine_from_config and connect_args

2014-12-30 Thread Boris SABATIER
@Michael: Are you sure the default value of isolation_level is None ? Because when I didn't set to None, I can't use nested session with sqlite and when I set it to None it's works. 2014-12-30 19:42 GMT+01:00 Michael Bayer : > > > Boris Sabatier wrote: > > Hi, > > I need to pass connect_args={'i

Re: [sqlalchemy] engine_from_config and connect_args

2014-12-30 Thread Michael Bayer
Boris Sabatier wrote: > Hi, > > I need to pass connect_args={'isolation_level':None} when I create my engine. “None” is the default that’s used if isolation_level is not passed, and means to do nothing. So just don’t pass it, there’s no need to pass “None”. > With create_engine, it's wor

[sqlalchemy] engine_from_config and connect_args

2014-12-30 Thread Boris Sabatier
Hi, I need to pass connect_args={'isolation_level':None} when I create my engine. With create_engine, it's work well. But I would like to use engine_from_config instead of create_engine. This is what I tried and the errors : # ini file : sqlalchemy.connect_args = {'isolation_level':None} # Er