工作目录: __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仓库目录则创建