我正在尝试将新列添加到现有表,但是在删除server_default时出现错误。
from alembic import op
import sqlalchemy as sa
# revision identifiers, used by Alembic.
revision = 'a29663449f3c'
down_revision = 'e42f9a7ca3d2'
branch_labels = None
depends_on = None
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('register_code', sa.Column('interest', sa.Integer(), nullable=False, server_default='0'))
op.alter_column('register_code', 'interest', server_default=None)
# ### end Alembic commands ###
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('register_code', 'interest')
# ### end Alembic commands ###
执行时出现下一个错误 flask db migrate
sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "ALTER": syntax error
[SQL: ALTER TABLE register_code ALTER COLUMN interest DROP DEFAULT]
(Background on this error at: http://sqlalche.me/e/e3q8)
也许SQLLite不支持删除server_default?
SQLLite不支持删除server_default
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句