@author: leason
@time: 2017/11/14 14:35
"""
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine, exc
from sqlalchemy.pool import QueuePool
from lib.utils import logging, package_import
from conf import mysql_pool_configs, switch
def engine():
db_pool = None
try:
db_pool = create_engine(mysql_pool_configs['url'], poolclass=QueuePool,
pool_size=mysql_pool_configs['pool_size'],
max_overflow=mysql_pool_configs['max_overflow'],
pool_recycle=mysql_pool_configs['pool_recycle'],
echo=False
)
except exc.OperationalError as e:
logging.debug("create pool err:", e)
return db_pool
mysql_engine = engine()
ModelBase = declarative_base()
if switch['create_table']:
package_import("app.models")
ModelBase.metadata.create_all(bind=mysql_engine)
#!/usr/bin/env python
# encoding: utf-8
"""
@author: leason
@time: 2017/11/14 9:59
"""
from app import app
from lib.utils import package_import
package_import("app.views")
package_import("lib.errors")
package_import("intercept")
package_import("intercept.before_request")
# encoding: utf-8 """ @version: 1.0 @author: dawning @contact: [email protected] @time: 2017/4/1 8:59 """ from app import app from lib.utils import package_import package_import("app.views") package_import("lib.flask.errors") package_import("lib.flask.intercept") package_import("app.intercept")
# encoding: utf-8 """ @version: 1.0 @author: dawning @contact: [email protected] @time: 2017/3/29 15:20 """ from app_config import schema_config as app_schema_config from app_request import schema_config as app_schema_request from lib.utils import package_import package_import("app.schemas", excludes=["example_schema"])
#!/usr/bin/env python
# encoding: utf-8
"""
@author: WL
@time: 2017/10/11 16:58
"""
from lib.utils import package_import
from app.services.untils import ModelBase
from app.db.db_api import Engine
from app.conf import msg
package_import("app.Tables")
def create_all_table():
ModelBase.metadata.create_all(bind=Engine)
return True, msg.SUCCESS
def drop_all_table():
ModelBase.metadata.drop_all(bind=Engine)
return True, msg.SUCCESS