Boris SABATIER <[email protected]> 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 <[email protected]>:
>> Boris SABATIER <[email protected]> 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 <[email protected]>:
>>>> Boris Sabatier <[email protected]> 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
>>>> [email protected].
>>>> To post to this group, send email to [email protected].
>>>> 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 [email protected].
>>> To post to this group, send email to [email protected].
>>> 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
>> [email protected].
>> To post to this group, send email to [email protected].
>> 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 [email protected].
> To post to this group, send email to [email protected].
> 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
