在model.py
:中
class Robot(Base):
__tablename__ = "robot"
id = Column('id', Integer, autoincrement=True, primary_key=True)
qq = Column('id', Integer, default=0)
count = Column('id', Integer, default=0)
在另一个文件中,我使用了它,它抛出了异常:
sqlalchemy.exc.ArgumentError: Trying to redefine primary-key column 'id' as a non-primary-key column on table 'robot'
如何解决?
您将所有列命名为'id'
:
id = Column('id', ...
qq = Column('id', ...
count = Column('id', ...
修复:
id = Column('id', Integer, autoincrement=True, primary_key=True)
qq = Column('qq', Integer, default=0)
count = Column('count', Integer, default=0)