Re: [SQLObject] Unique ID Number question

[Luke O. <lu...@me...>]

>
> Where does it learn that the new Person has an ID of 1?
>
> I tried the same commands manually and the insert doesn't return the ID.
> How does SQLObject know what the ID is?

Depends on the database/dbdriver. You'll find the implementation in
SQlObject/DBConnection.py, _queryInsertID() for each DBConnection-class. Some
Python db interfaces provide a non-standard option for getting this from the
cursor (MySQL, SQLite), some require a second query of the database (Postgres
using OIDs, for instance).

- Luke