[sqlalchemy] Re: Python logging with sqlalchemy

2010-07-18 Thread dusans
This is my working version. Its a modification of the DBHandler found here: http://stackoverflow.com/questions/935930/creating-a-logging-handler-to-connect-to-oracle/ class SqlAlchemyHandler(logging.Handler): def __init__(self, session): logging.Handler.__init__(self)

Re: [sqlalchemy] lockmode

2010-07-18 Thread Michael Bayer
What does your SQL output say? Do you see FOR UPDATE in the log? Sent from my iPhone On Jul 17, 2010, at 8:47 PM, Michael Mileusnich justmike2...@gmail.com wrote: Hello, I am running Python 2.6 SQL Alchemy 0.5.8 against MS SQL Server Express 2008 with pyODBC. When I issue something

[sqlalchemy] Re: delete attributes of last flush or commit in a MapperExtension already executed

2010-07-18 Thread Michael Bayer
On Jul 14, 4:56 am, sacabuche sacabu...@gmail.com wrote: In fact i was only querying, but when i add many items in the same flush, all items(of same category)get the same value, and i don't know how to include the sku number already calculated to the query, that's the reason because i tried

[sqlalchemy] Re: checking for C extensions at runtime

2010-07-18 Thread Michael Bayer
On Jul 16, 11:56 am, David Gardner dgard...@creatureshop.com wrote: I'm actually not sure, I did a bit of googling and couldn't really find much. Pep 386 talks about version comparison in distutils:http://www.python.org/dev/peps/pep-0386/#id10 As for scratching my itch it wouldn't have to

Re: [sqlalchemy] problem with multi-table mapping - how to configure merge/cascade behaviour on mappers based on join/select?

2010-07-18 Thread Michael Bayer
On Jul 15, 2010, at 5:11 PM, Harry Percival wrote: thanks Michael. I really appreciate your help. How should use .merge()? I've tried both: another_new = MoviesAndDirectorsAndGenres() #init another_new as blank row another_new = session.merge(new) #attempt to merge with my 'new' object

[sqlalchemy] sqlite+zxjdbc

2010-07-18 Thread Celil
JDBC already has an sqlite backend, see these examples: http://wiki.python.org/jython/DatabaseExamples How difficult would be to add support for that in sqlachemy under jython, so that one can do something like this from sqlalchemy import create_engine engine =

Re: [sqlalchemy] sqlite+zxjdbc

2010-07-18 Thread Michael Bayer
On Jul 18, 2010, at 9:45 PM, Celil wrote: JDBC already has an sqlite backend, see these examples: http://wiki.python.org/jython/DatabaseExamples How difficult would be to add support for that in sqlachemy under jython, so that one can do something like this from sqlalchemy import

Re: [sqlalchemy] lockmode

2010-07-18 Thread Michael Mileusnich
It's just a basic select statement I do not see any other parms. Thanks Michael Mileusnich On Sun, Jul 18, 2010 at 5:05 PM, Michael Bayer mike...@zzzcomputing.comwrote: What does your SQL output say? Do you see FOR UPDATE in the log? Sent from my iPhone On Jul 17, 2010, at 8:47 PM,