Too bad :-)
Saves me a query.
Thanks
On Jul 8, 11:41 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> right. like ive been saying all along, this bug is fixed in trunk and
> will be out in 0.3.9.
>
> On Jul 8, 2007, at 11:52 AM, mc wrote:
>
> > from sqlalchemy import *
> > db=create_engine('mysql://user1:[EMAIL PROTECTED]/tests')
>
> > create_s = """
> > CREATE TABLE `users` (
> > `user_name` varchar(16) NOT NULL ,
> > `ID` int unsigned NOT NULL auto_increment,
> > PRIMARY KEY (`user_name`),
> > UNIQUE (`ID`)
> > ) ENGINE=InnoDB
> > """
>
> > db.execute("DROP TABLE IF EXISTS `users`")
> > db.execute(create_s)
>
> > md=BoundMetaData(db)
> > t=Table('users', md, autoload = True)
>
> > r = t.insert().execute(user_name='Jack')
> > print r.last_inserted_ids()
>
> > r = t.insert().execute(user_name='Jill')
> > print r.last_inserted_ids()
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
