Flask数据库迁移时保留数据库原有表及数据

Cloud10℃

于 2022-10-18 15:03:16 发布

阅读量524

点赞数 1

分类专栏：学习文章标签： flask 数据库 python

本文链接：https://blog.csdn.net/a1026472254/article/details/127388825

版权

在flask db init生成migrations文件后，修改里面的env.py文件
在run_migrations_offline和run_migrations_online函数中各添加一个钩子函数include_object，之后在context.configure(）添加一行参数 include_object=include_object使其忽略已有的数据库，代码如下

from __future__ import with_statement

import logging
from logging.config import fileConfig

from flask import current_app

from alembic import context

# this is the Alembic Config object, which provides
# access to the values within the .ini file in use.
config = context.config

# Interpret the config file for Python logging.
# This line sets up loggers basically.
fileConfig(config.config_file_name)
logger = logging.getLogger('alembic.env')

# add your model's MetaData object here
# for 'autogenerate' support
# from myapp import mymodel
# target_metadata = mymodel.Base.metadata
config.set_main_option(
    'sqlalchemy.url',
    str(current_app.extensions['migrate'].db.get_engine(