def create_schemas(*args, **kwargs):
try:
from app.db.models import get_schemas
except ImportError:
schemas = ['admin']
else:
schemas = get_schemas()
for schema in schemas:
_sa.engine.execute(DDL(f'CREATE SCHEMA IF NOT EXISTS "{schema}"'))
_sa.session.commit()
def create_schemas():
conn = op.get_bind()
for schema_name in get_schemas():
if not conn.dialect.has_schema(conn, schema_name):
conn.execute(sa.schema.CreateSchema(schema_name))
def create_schemas():
schemas = get_schemas()
for schema in schemas:
app.dbi.create_schema(schema)
def drop_schemas():
schemas = get_schemas()
for schema in schemas:
app.dbi.drop_schema(schema)