[sqlalchemy] Re: autocommit on for DDL

You might be interested to know that the situation is more like If you are not using MySQL, you probably have transactional DDL. Even SQLite has it. According to http://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis - PostgreSQL - yes - MySQL -

[sqlalchemy] pickling an engine onject

Hi, I saw that there is a way to serialize a query object is there a way to serialize an engine object? 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

Re: [sqlalchemy] pickling an engine onject

assuming you saw : http://www.sqlalchemy.org/docs/core/serializer.html for serializing queries. engines can't be serialized since TCP connections don't support it.You can only do memoization tricks like those in the serializer extension to create/locate a new engine on the other side. On

[sqlalchemy] Re: Compound Join

Michael, Thanks for the quick reply. The one thing I hadn't tried was doing a separate join for each of the primary table joins and once I did that it worked. It dawned on me this morning that I forgot to mention I was using ORM syntax, but you got the answer out before I had a chance to update

[sqlalchemy] how to build up an or_ clause programmatically?

Hi, I would like to build an or_ statement using a for cycle, something like the following: employeetask_or = or_(False) # to exclude everything not satisfied by later appended criteria, is this needed or empty or_() is fine? for period in periods.all():

[sqlalchemy] Re: how to build up an or_ clause programmatically?

I've just found http://www.mail-archive.com/sqlalchemy@googlegroups.com/msg14672.html what answers my question. sorry for bothering you On Fri, Jan 28, 2011 at 9:36 PM, Viktor Nagy viktor.n...@toolpart.huwrote: Hi, I would like to build an or_ statement using a for cycle, something like the

[sqlalchemy] Sqlite3 auto

Hi, [] I'm trying to create tables in SQLITE, with a composite PK (id, eid), I want the id have the auto increment. I've read this, http://www.sqlalchemy.org/docs/dialects/sqlite.html#auto-incrementing-behavior, and following your instructions, added __table_args__ = {'sqlite_autoincrement':True}

Re: [sqlalchemy] Sqlite3 auto

On Jan 28, 2011, at 8:07 AM, slothy Rulez a lot wrote: Hi, [] I'm trying to create tables in SQLITE, with a composite PK (id, eid), I want the id have the auto increment. I've read this, http://www.sqlalchemy.org/docs/dialects/sqlite.html#auto-incrementing-behavior, and following your