[sqlalchemy] Re: Mapping and updating tables with no primary key

2007-08-12 Thread Andy Hird
you should be able to say: table = Table('account_stuff', metadata, Column('account_id', Integer, ForeignKey('account_ids.account_id'), primary_key=True), autoload=True) That doesn't appear to work unfortunately. When I load the db and create the two tables and then attempt to do a

[sqlalchemy] Re: Mapping and updating tables with no primary key

2007-08-12 Thread sdobrev
Looking at account_stuff_table.foreign_keys I have: OrderedSet([ForeignKey(u'account_ids.account_id'), ForeignKey('account_ids.account_id')]) i see one is unicode'd (the autoloaded), another one is not (yours). unicode!=str so they probably appear differently named. see if u can workaround

[sqlalchemy] Re: Mapping and updating tables with no primary key

2007-08-12 Thread Michael Bayer
On Aug 12, 2007, at 4:44 AM, [EMAIL PROTECTED] wrote: Looking at account_stuff_table.foreign_keys I have: OrderedSet([ForeignKey(u'account_ids.account_id'), ForeignKey('account_ids.account_id')]) i see one is unicode'd (the autoloaded), another one is not (yours). unicode!=str so they

[sqlalchemy] SQLAlchemy 0.4 beta1 **RELEASED**

2007-08-12 Thread Michael Bayer
SQLAlchemy version 0.4, the biggest release SQLAlchemy has ever had, is released in its first beta. If you haven't been following along, it's time to catch up ! An overview-in-progress of whats new is at http://www.sqlalchemy.org/trac/wiki/WhatsNewIn04 . This SQLAlchemy is different from the

[sqlalchemy] Re: MySQL LOAD DATA INFILE

2007-08-12 Thread jason kirtland
Martin Aspeli wrote: Hi all, I have a use case where I need to execute a MySQL LOAD DATA INFILE statement on an SQLAlchemy connection. I've tried this is with an engine using a threadlocal strategy, using engine.scalar() and passing a string that contains the (generated) LOAD DATA