python - 插入具有复合主键的模型时出现 IntegrityError

Question

我正在尝试使用复合主键创建一个表。它有一个整数和两个字符串字段作为键。当我提交 session 时，它会引发 IntegrityError .我在做什么有什么问题？

class Targets(db.Model):
    __tablename__ = 'Targets'
    id = db.Column(db.Integer, primary_key=True)
    Event_Name = db.Column(db.String, index=True, default='Single_Trigger', primary_key=True)
    Trigger_id = db.Column(db.String, index=True, unique=True, primary_key=True)

>>> from app import db, models
>>> target = models.Targets(Trigger_id='20150421_221942_ST_1')
>>> db.session.add(target)
>>> db.session.commit()

IntegrityError: (IntegrityError) NOT NULL constraint failed: Targets.id u'INSERT INTO "Targets" ("Event_Name", "Name", "Trigger_id", "Tile", "Status", "RA", "Dec", "Filter", "Exp_time", "No_Exp") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' ('Single_Trigger', '20150421_221942_ST_1', '20150421_221942_ST_1', 1, 0, 102.0, 231.25, 'V', 30, 5)

Answer 1

SQLAlchemy 不会在复合键上设置自动增量，您需要在 id 列上设置 autoincrement=True。

http://docs.sqlalchemy.org/en/latest/core/metadata.html#sqlalchemy.schema.Column.params.autoincrement

If the table has a composite primary key consisting of more than one integer column, set this flag to True only on the column that should be considered “autoincrement”.