On Oct 6, 2009, at 3:07 PM, Nick Murphy wrote:
> > Hi Mike, > > I'm using SQLite, and I'm tracking svn trunk (I'm at revision 6390). > Is the newer sqlite backend you mentioned somewhere else? the sqlite3 included with Python 2.6 handles DEFAULT VALUES, so that would be a place to start. Any recent sqlite from the sqlite.org website supports it too. > > Thanks, > Nick > > On Oct 6, 8:49 am, "Michael Bayer" <mike...@zzzcomputing.com> wrote: >> Nick Murphy wrote: >> >>> Hi, >> >>> A class of mine has no attributes besides its primary key. This key >>> is a surrogate, so I'd like to assign values automatically via >>> autoincrement. Unfortunately, it's not possible to persist >>> objects of >>> this class to the database, as the SQL compiler complains about >>> empty >>> inserts. Is there a common workaround for this? >> >> empty inserts are supported at least by mysql, pg, oracle, and newer >> versions of SQLite (via INSERT...DEFAULT VALUES which SQLA invokes >> automatically). Its a database dependent issue so let us know >> what DB >> you're using. >> >> >> >>> Thanks, >>> Nick > > --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---