[sqlalchemy] ColumnProperty object has no attribute key

2008-05-31 Thread sniffer
hi all, first of all thank u guys for all ur help on my previous posts. This time around i again have a table in an mssql db, the table has just 2 fields one int field(PK) and the other a varchar field. the table object for the table in question is auto generated, the problem is that when i save

[sqlalchemy] Re: sqlite PK autoincrement not working when you do a composite PK?

2008-05-31 Thread Michael Bayer
On May 31, 2008, at 12:38 AM, Russell Warren wrote: I've tried sifting through the sqlite dialect to figure out what is going on and have even tried forcing supports_pk_autoincrement to be true, but it rapidly became clear I hadn't a clue what I was doing in the sqlalchemy guts. Does

[sqlalchemy] Re: ColumnProperty object has no attribute key

2008-05-31 Thread Michael Bayer
On May 31, 2008, at 4:09 AM, sniffer wrote: hi all, first of all thank u guys for all ur help on my previous posts. This time around i again have a table in an mssql db, the table has just 2 fields one int field(PK) and the other a varchar field. the table object for the table in

[sqlalchemy] Re: ColumnProperty object has no attribute key

2008-05-31 Thread sniffer
Hi michael, thanks for the reply i am trying it in an extremly small script the code is mentioned below def logsync(self): entity=testq self.__sqlorm__dblogger.info(Current Entity - + entity) importcmd=from dbmod.%s import %s as entitymodule % (entity,entity+class)

[sqlalchemy] Re: ColumnProperty object has no attribute key

2008-05-31 Thread Michael Bayer
OK, the usage pattern there is incorrect. Create a Table/Mapper at the module level at the same level in which you create your classes. To make this easier, look into using the declarative extension: http://www.sqlalchemy.org/docs/04/plugins.html#plugins_declarative ...that way there's