在 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)
