Re: [sqlalchemy] Re: SA and IBM DB2

2012-07-06 Thread Cornelius Kölbel
Hello, one year gone and I wonder if there might be any news on the question of sqlalchemy and DB2. The previous patches of ibm_db_sa (https://bitbucket.org/jazle/ibm_db_sa/downloads) do not exist anymore. But the current ibm_db_sa 0.1.6 produces an import error at from sqlalchemy import

[sqlalchemy] Memory Error on large table with no mem for new parser error message

2012-07-06 Thread Vathsala
Hi, I'm trying to load about 4 million odd records from a MSSQL Server table into my memory. The table takes about 1.5GB on my disk but I get a memory error when I load about 85 records. My RAM is about 32 GB, so I don't understand why it is complaining. I first tried loading all the 4

[sqlalchemy] dialect sensible declaration

2012-07-06 Thread alex bodnaru
hello friends, i need to define a foreign key differently for different dialects: ondelete='restrict' for most engines, but nothing (implied and not recognized) for mssql. could you help? thanks in advance, alex -- You received this message because you are subscribed to the Google Groups

Re: [sqlalchemy] Re: SA and IBM DB2

2012-07-06 Thread Michael Bayer
no news here ! we're still entirely open to someone willing to take the initiative on this one. On Jul 6, 2012, at 6:04 AM, Cornelius Kölbel wrote: Hello, one year gone and I wonder if there might be any news on the question of sqlalchemy and DB2. The previous patches of ibm_db_sa

Re: [sqlalchemy] Memory Error on large table with no mem for new parser error message

2012-07-06 Thread Michael Bayer
On Jul 6, 2012, at 6:20 AM, Vathsala wrote: Hi, I'm trying to load about 4 million odd records from a MSSQL Server table into my memory. The table takes about 1.5GB on my disk but I get a memory error when I load about 85 records. My RAM is about 32 GB, so I don't understand why it

Re: [sqlalchemy] dialect sensible declaration

2012-07-06 Thread Michael Bayer
you'd use ForeignKeyConstraint along with the AddConstraint directive, and limit it per-dialect using create/drop events as documented at http://docs.sqlalchemy.org/en/rel_0_7/core/schema.html#controlling-ddl-sequences . On Jul 6, 2012, at 1:30 PM, alex bodnaru wrote: hello friends, i

Re: [sqlalchemy] dialect sensible declaration

2012-07-06 Thread alex bodnaru
hello mike and thanks for your answer. no problem with ForeignKeyConstraint, but wouldn't AddConstraint go the alter way? in this case, it will be ignored by the sqlite dialect. what i was looking for was more like: from sqlalchemy... import get_dialect fk_parms = dict(.) if