我正在尝试创建一个具有复合主键的表。它有一个整数和两个字符串字段作为关键字。当我提交会话时,它会引发一个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)发布于 2015-05-27 16:49:12
SQLAlchemy没有在组合键上设置自动增量,您需要在id列上设置autoincrement=True。
如果表具有由多个整数列组成的复合主键,则仅在应被视为“自动增量”的列上将此标志设置为True。
发布于 2020-07-16 12:11:43
你必须在主键中设置autoincrement=True,explicit:
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)重要的部分是,你必须降级到以前的迁移,删除迁移并创建新的迁移,然后升级到它。
https://stackoverflow.com/questions/30232915
复制相似问题