python - 获取 flask 中最后插入的 id 时出现问题

Question

我正在 flask 中插入数据，但无法获取最后插入的 id

mdeals = Deals(
                merchand_id = session['userid'],
                deal_name=request.form['dealname'],
                deal_desc=request.form['dealdescription'],
                .
                            .
                            .
                )
        mdeals.save()

我的型号是:

class Deals(db.Model):
    __tablename__ = 'deals'
    dealid = db.Column('id', Integer, primary_key=False)
    deal_name = db.Column('deal_name', String(50), unique=False)
    deal_desc = db.Column(db.Text, unique=False)
    deal_price = db.Column('deal_price', String(50), unique=False)
    deal_savings = db.Column(db.Float, unique=False)
    deal_qty = db.Column(db.Integer(), unique=False)
    start_time = db.Column(db.DateTime, unique=False)
    end_time = db.Column(db.DateTime, unique=False)
    created_on = db.Column(db.DateTime, unique=False)
    updated_on = db.Column(db.DateTime, unique=False)
    merchand_id = db.Column(db.Integer(), db.ForeignKey(Merchant.id))
    merchand = db.relationship(Merchant , backref='posts')
    def __init__(self, deal_name=None,deal_price=None ):
        self.deal_name = deal_name
        self.deal_desc = deal_price

但是当我尝试获取 mdeals.id 时，它会给我 None ，如果我尝试获取 mdeals.dealid 那么它给出错误 AttributeError: 'Deals' object has no attribute 'dealid',

我很困惑，我怎样才能得到最后插入的id？

谢谢

Answer 1

from yourapp import Deals
de = Deals(merchand_id = session['userid'],
            deal_name=request.form['dealname'],
            deal_desc=request.form['dealdescription']...)
db.session.add(de)
db.session.commit()

然后你就可以看到id

print de.dealid