设置SQLAlchemy自动增量起始值 [英] Setting SQLAlchemy autoincrement start value
问题描述
SQLAlchemy中的autoincrement
参数似乎只有True
和False
,但是我想设置下一个插入操作时通过自动递增aid = 1002
的预定义值aid = 1001
./p>
在SQL中,可以像这样更改:
ALTER TABLE article AUTO_INCREMENT = 1001;
我正在使用MySQL
,并且我尝试了以下操作,但不起作用:
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class Article(Base):
__tablename__ = 'article'
aid = Column(INTEGER(unsigned=True, zerofill=True),
autoincrement=1001, primary_key=True)
那么,我该怎么办呢?预先感谢!
您可以通过使用 The In SQL, can be changed like: I'm using So, how can I get that? Thanks in advance! You can achieve this by using
这篇关于设置SQLAlchemy自动增量起始值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!autoincrement
argument in SQLAlchemy seems to be only True
and False
, but I want to set the pre-defined value aid = 1001
, the via autoincrement aid = 1002
when the next insert is done.ALTER TABLE article AUTO_INCREMENT = 1001;
MySQL
and I have tried following, but it doesn't work:from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class Article(Base):
__tablename__ = 'article'
aid = Column(INTEGER(unsigned=True, zerofill=True),
autoincrement=1001, primary_key=True)
DDLEvents
. This will allow you to run additional SQL statements just after the CREATE TABLE
ran. Look at the examples in the link, but I am guessing your code will look similar to below:from sqlalchemy import event
from sqlalchemy import DDL
event.listen(
Article.__table__,
"after_create",
DDL("ALTER TABLE %(table)s AUTO_INCREMENT = 1001;")
)