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 <mike...@zzzcomputing.com>: > > > Boris SABATIER <sabatier.bo...@gmail.com> 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 use postgre in each >> environement. > > > just check the engine name: > > if engine.dialect.name == ‘sqlite’: > # set up events > > > > >> >> >> 2014-12-30 21:12 GMT+01:00 Michael Bayer <mike...@zzzcomputing.com>: >>> Boris SABATIER <sabatier.bo...@gmail.com> 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 create_engine()->connect_args >>> are supposed to be in the query string. So the isolation_level you’re >>> talking about here isn’t SQLAlchemy’s version of this, it’s the one that’s >>> specific to the pysqlite DBAPI. >>> >>> However, none of that matters, because you’re trying to use SAVEPOINT and >>> you definitely don’t just want to turn on pysqlite’s autocommit and do >>> nothing else. >>> >>> Your use case here is specifically addressed here: >>> >>> http://docs.sqlalchemy.org/en/rel_0_9/dialects/sqlite.html#pysqlite-serializable >>> >>> You will need to implement the events given there in order to use SAVEPOINT >>> transactions, which does include the “isolation_level=None” but also >>> critically re-implements the fact that you need to emit BEGIN at transaction >>> start. >>> >>> >>> >>> >>> >>>> 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 <mike...@zzzcomputing.com>: >>>>> Boris Sabatier <sabatier.bo...@gmail.com> 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 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} >>>>> >>>>> >>>>> 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 >>>>> >>>>> there’s a system by which these values are interpreted on a case-by-case >>>>> basis that’s stated in each dialect class, if the type is something other >>>>> than string. But this parameter isn’t part of that, since it’s just a >>>>> string type, and there’s no “None” handling. You’d just omit the >>>>> argument >>>>> to use the default value. >>>>> >>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "sqlalchemy" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/sqlalchemy/ZVhiJa7QZOQ/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> sqlalchemy+unsubscr...@googlegroups.com. >>>>> To post to this group, send email to sqlalchemy@googlegroups.com. >>>>> Visit this group at http://groups.google.com/group/sqlalchemy. >>>>> For more options, visit https://groups.google.com/d/optout. >>>> >>>> -- >>>> You received this message because you are subscribed to the Google Groups >>>> "sqlalchemy" group. >>>> To unsubscribe from this group and stop receiving emails from it, send an >>>> email to sqlalchemy+unsubscr...@googlegroups.com. >>>> To post to this group, send email to sqlalchemy@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/sqlalchemy. >>>> For more options, visit https://groups.google.com/d/optout. >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "sqlalchemy" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/sqlalchemy/ZVhiJa7QZOQ/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> sqlalchemy+unsubscr...@googlegroups.com. >>> To post to this group, send email to sqlalchemy@googlegroups.com. >>> Visit this group at http://groups.google.com/group/sqlalchemy. >>> For more options, visit https://groups.google.com/d/optout. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To post to this group, send email to sqlalchemy@googlegroups.com. >> Visit this group at http://groups.google.com/group/sqlalchemy. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to a topic in the Google > Groups "sqlalchemy" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/sqlalchemy/ZVhiJa7QZOQ/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at http://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.