直接更新 SQLalchemy 类并获取实例

Question

我想直接更新我的 sqlalchemy 类，然后将更改插入数据库并返回最近插入的 id。下面是我正在努力工作的代码。

Series.is_forfeited = is_forfeited

Series.start_date_time =date_time

Series.is_finished = is_finished

Series.is_live = is_live

instance = 'Convert newly updated object to instance'

session.add(instance)

session.commit()

id = instance.id

Answer 1

看起来您没有初始化您的实例。试试这个：instance = Series()instance.is_forfeited = is_forfeitedinstance.start_date_time =date_timeinstance.is_finished = is_finishedinstance.is_live = is_livesession.add(instance)# optional: flush before you commit to get the ID without# closing the transactionsession.flush()# also, don't use the variable name `id` as # id is a builtin function and you're overriding it.my_id = instance.id# when you're ready, you can commit your transactionsession.commit()