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
-~----------~----~----~----~------~----~------~--~---
