sqlalchemy-migrate

工作目录: __init__.py

#!/usr/bin/env python
# -*- coding=utf8 -*-
import os
import sys

CUR_DIR = os.path.dirname(os.path.abspath(__file__))
PROJECT_DIR = os.path.dirname(CUR_DIR)
sys.path.insert(0, PROJECT_DIR)
sys.path.insert(0, CUR_DIR)

# db仓库地址
REPO_PATH = os.path.join(PROJECT_DIR, "db_repository")
# 迁移版本管理表
MIGRATE_VERSION_TABLE = "migrate_version"

生成db管理仓库

#!/usr/bin/env python
# -*- coding=utf8 -*-
import os
from migrate.versioning import api
# from importlib import import_module
from __init__ import REPO_PATH, MIGRATE_VERSION_TABLE

from utils.orm import DB
from common import logger
from models import BaseModel


async def main():
    engine = DB.get_instance()
    db_url = DB.create_url(sync=False)
    async with engine.begin() as conn:
        # 创建所有表
        await conn.run_sync(BaseModel.metadata.create_all)
    # 如果没有db仓库目录则创建