在sqlalchemy中获取刚插入的数据id?

Question

from sqlalchemy import text
conn=engine.connect();
s=text("insert into aws_rcsy(topic)values(:topic)");

q_insert=conn.execute(s,topic=topic);
conn.close();

如何获取刚插入数据的id?

ps:q_insert返回<sqlalchemy.engine.base.ResultProxy object at 0x...>
从q_insert中能否获取row数据?

Answer 1

q.lastrowid

Answer 2

复制过来的代码，没有验证过

rslt_id = conn.execute("INSERT INTO user (name, country_id) VALUES ('Homer', 123)
                        RETURNING id")

参考 stack-overflow

Answer 3

session.add(user)
session.flush()
print(user.id)