That's unfortunate because our database is built around MS GUIDs and not integer PKs, but good to know.
I am just using pythoncom.CreateGuid() to generate the object ids before insert and that is working great. thanks for all the help On Jan 11, 2:45 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote: > MSSQL ID generation is limited to integer PKs of the IDENTITY type, and they > work fine in 0.4 series. That wiki page should be updated. > > It's most likely a case of the Table not knowing that the PK should be an > auto-increment type. Are you defining the table via an SA Table() > definition, or trying to autoload the definition via table reflection? > > On Jan 11, 2008 5:23 PM, Dean Halford <[EMAIL PROTECTED]> wrote: > > > > > thanks micheal - the only reason we went with 3.11 was the following > > statement on the wiki: > > "Currently (Aug 2007) the 0.4 branch has a number of problems with MS- > > SQL." > >http://www.sqlalchemy.org/trac/wiki/DatabaseNotes#MS-SQL > > > I checked the logs and it does have to do with the MS-SQL ID > > generation, so I'll readup on that. > > -------------------------------------------------------- > > 2008-01-11 14:19:31,292 INFO sqlalchemy.engine.base.Engine.0x..30 > > SELECT shot.[skuId], shot.number, shot.name, shot.description, shot. > > [teamCategory], shot.comments, shot.props, shot.time, shot.talent, > > shot.source, shot.id, shot.now, shot.[rowNumber] > > FROM shot > > WHERE shot.id IS NULL > > --------------------------------------------------------- > > > cheers > > > On Jan 11, 1:46 pm, Michael Bayer <[EMAIL PROTECTED]> wrote: > > > On Jan 11, 2008, at 4:37 PM, Dean Halford wrote: > > > > > Thanks for the responses guys. The PassiveDefault("") parameter did > > > > exactly what I wanted it to do - which was to exclude that column from > > > > the generated insert query so that MS SQL could handle those on it's > > > > own. > > > > > ... now to figure out why I am getting an unsubscriptable object type > > > > error from the operation: > > > > ----------------------------------- > > > > ... > > > > File "c:\python24\lib\site-packages\sqlalchemy-0.3.11-py2.4.egg > > > > \sqlalchemy\orm\mapper.py", line 1255, in _postfetch > > > > self.set_attr_by_column(obj, c, row[c]) > > > > TypeError: unsubscriptable object > > > > ----------------------------------- > > > > > the comments for the _postfetch method indicate that it is checking to > > > > see if 'PassiveDefaults' were fired off on the insert. It looks the > > > > row[c] operation is breaking as the row object doesn't support [] > > > > subscripting... could be a bug? > > > > rows are subscriptable so that means its getting None back. so its a > > > bug that its not handling that more gracefully...but also, should be > > > getting a row back. you should see in your SQL logs that a SELECT > > > is being issued right after a series of INSERT/UPDATE statements for > > > that table - if the SELECT queries for a primary key of NULL that may > > > mean that the default-id-generation scheme in use is not working > > > (either not genning an ID or not telling the result about it > > > correctly)....i know on MS-SQL the default ID generation schemes are > > > quite complex. we'll see what Rick says but its possible things would > > > work a whole lot better if you were using sqlalchemy 0.4. --~--~---------~--~----~------------~-------~--~----~ 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 this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---