Michael,
On Wed, Aug 27, 2008 at 1:18 PM, Michael Bayer <[EMAIL PROTECTED]>wrote:
>
>
> On Aug 27, 2008, at 2:25 AM, manuhack wrote:
>
> >
> > Hi,
> >
> > Using the example in the tutorial:
> >
> >>>> users = Table('users', metadata,
> > ... Column('id', Integer, primary_key=True),
> > ... Column('name', String),
> > ... Column('fullname', String),
> > ... )
> >
> > if I commit the following
> >
> >>>> ins = users.insert(values={'name':'jack', 'fullname':'Jack Jones'})
> >>>> conn = engine.connect()
> >>>> result = conn.execute(ins)
> >
> > is there a way to get the value of "id" without calling select? I'm
> > using MySQL if that matters. Thanks!
>
> yes, call result.last_inserted_ids() . This is independent of
> database backend and returns a list of primary key identifiers for a
> single row (usually a single element).
>
Thanks a lot, this is exactly what I was looking for!
manu
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
