python - 如何使用 OpenERP 在 Postgresql 中获取最后插入的 ID

Question

我有一个插入查询，我想在 OpenERP 中获取最后插入的 ID。这是代码:

query = "INSERT INTO foo SELECT * FROM bar"
cr.execute(query) # cr => cursor

如何获取最后插入的 ID？插入为空时发生了什么？

Answer 1

查看RETURNING clause .

INSERT INTO table [ ( column [, ...] ) ]
    { DEFAULT VALUES | VALUES ( { expression | DEFAULT } [, ...] ) [, ...] | query }
    [ RETURNING * | output_expression [ AS output_name ] [, ...] ]

Insert a single row into table distributors, returning the sequence number generated by the DEFAULT clause:

INSERT INTO distributors (did, dname) VALUES (DEFAULT, 'XYZ Widgets')
   RETURNING did;