[sqlalchemy] Re: sessions and transaction

2006-12-02 Thread Manlio Perillo
Michael Bayer ha scritto: if the transaction fails, the session goes right back to the same state that existed before you called the flush(), as though nothing happened. With this example: trans = begin_transaction() session = ctx.current a = SomeObject(...) session.save(a) raise Exception()

[sqlalchemy] Re: self-referential table question

2006-12-02 Thread Steve Zatz
Works perfectly. Your responsiveness and the usefulness of SQLAlchemy continue to amaze. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to

[sqlalchemy] SA 0.3.x: performance issues

2006-12-02 Thread Daniel Miller
Michael Bayer wrote: you need to forward the *actual test program* which you are running. i have tests for performance which generally show very minute speed differences between 0.2 and 0.3. The logging statements can be sped up by making them conditional and maybe removing some. I've

[sqlalchemy] Re: SA 0.3.x: performance issues

2006-12-02 Thread Michael Bayer
what logging really needs is this: logging.debug(lambda: %s - %s % (_get_data(x),_get_other_data(y)) and the lambda: doesnt execute if logging is disabled; which accounts for a lot more than just doing the % operation or not, such as in my case where i make calls out to _instance_str() to

[sqlalchemy] pysqlite and time support

2006-12-02 Thread Manlio Perillo
Regards. From the code in qlalchemy.databases.sqlite.py it seems that SQLAlchemy does not support things like: 12:30:00.30 That is: seconds with a fractional part. Any reasons for doing this? Manlio Perillo --~--~-~--~~~---~--~~ You received this

[sqlalchemy] Re: self-referential table question

2006-12-02 Thread Steve Zatz
Works. Thanks. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For

[sqlalchemy] Re: SA 0.3.x: performance issues

2006-12-02 Thread Daniel Miller
Michael Bayer wrote: also, I challenge your assertion that saying x and y or z is a perlish thing (its a C and Java thing if anything); python 2.5 has just added the y if x else z syntax which is essentially an official version of the same thing. Well, I wasn't really talking about 'x and

[sqlalchemy] Re: SA 0.3.x: performance issues

2006-12-02 Thread Michael Bayer
it is flawed for that reason yes. fine for non-empty strings though. the new syntax is meant to do correctly what we *want* the x and y or z thing to do. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups sqlalchemy