直接更新 SQLalchemy 类并获取实例

Question

我想直接更新我的 sqlalchemy 类，然后将更改插入数据库并返回最近插入的 id。下面是我正在努力工作的代码。Series.is_forfeited = is_forfeitedSeries.start_date_time =date_timeSeries.is_finished = is_finishedSeries.is_live = is_liveinstance = 'Convert newly updated object to instance'session.add(instance)session.commit()id = instance.id

Answer 1

看起来您没有初始化您的实例。试试这个：

instance = Series()

instance.is_forfeited = is_forfeited

instance.start_date_time =date_time

instance.is_finished = is_finished

instance.is_live = is_live

session.add(instance)

# optional: flush before you commit to get the ID without

# closing the transaction

session.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 transaction

session.commit()