問題描述

from sqlalchemy import textconn=engine.connect();s=text('insert into aws_rcsy(topic)values(:topic)');q_insert=conn.execute(s,topic=topic);conn.close();

如何獲取剛插入數(shù)據(jù)的id?

ps:q_insert返回<sqlalchemy.engine.base.ResultProxy object at 0x...> 從q_insert中能否獲取row數(shù)據(jù)?

問題解答

q.lastrowid

復(fù)制過來的代碼，沒有驗(yàn)證過

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

參考 stack-overflow