chainqueue/scripts/migrate.py

82 lines
3.1 KiB
Python
Raw Permalink Normal View History

2021-06-02 12:59:04 +02:00
#!/usr/bin/python
import os
import argparse
import logging
# external imports
import alembic
from alembic.config import Config as AlembicConfig
import confini
from xdg.BaseDirectory import (
2021-06-03 10:17:02 +02:00
xdg_data_dirs,
2021-06-02 12:59:04 +02:00
load_first_config,
)
# local imports
from chainqueue.db import dsn_from_config
logging.basicConfig(level=logging.WARNING)
logg = logging.getLogger()
rootdir = os.path.dirname(os.path.dirname(os.path.realpath(__file__)))
dbdir = os.path.join(rootdir, 'chainqueue', 'db')
2021-06-03 10:17:02 +02:00
default_migrations_dir = os.path.join(dbdir, 'migrations')
default_data_dir = os.path.join(xdg_data_dirs[0], 'chainqueue')
2021-06-02 12:59:04 +02:00
default_config_dir = load_first_config('chainqueue')
config_dir = os.environ.get('CONFINI_DIR', default_config_dir)
argparser = argparse.ArgumentParser("Database migration tool for chainqueue")
2021-06-02 12:59:04 +02:00
argparser.add_argument('-c', type=str, default=config_dir, help='config file')
argparser.add_argument('--env-prefix', default=os.environ.get('CONFINI_ENV_PREFIX'), dest='env_prefix', type=str, help='environment prefix for variables to overwrite configuration')
2021-06-03 10:17:02 +02:00
argparser.add_argument('--data-dir', dest='data_dir', type=str, default=default_data_dir, help='data directory')
argparser.add_argument('--migrations-dir', dest='migrations_dir', default=default_migrations_dir, type=str, help='path to alembic migrations directory')
argparser.add_argument('--reset', action='store_true', help='reset exsting database')
2021-06-02 12:59:04 +02:00
argparser.add_argument('-v', action='store_true', help='be verbose')
argparser.add_argument('-vv', action='store_true', help='be more verbose')
args = argparser.parse_args()
if args.vv:
logging.getLogger().setLevel(logging.DEBUG)
elif args.v:
logging.getLogger().setLevel(logging.INFO)
2021-06-03 10:17:02 +02:00
# process config
2021-06-02 12:59:04 +02:00
config = confini.Config(args.c, args.env_prefix)
config.process()
2021-06-03 10:17:02 +02:00
args_override = {
'PATH_DATA': getattr(args, 'data_dir'),
}
config.dict_override(args_override, 'cli args')
if config.get('DATABASE_ENGINE') == 'sqlite':
config.add(os.path.join(config.get('PATH_DATA'), config.get('DATABASE_NAME')), 'DATABASE_NAME', True)
2021-06-02 12:59:04 +02:00
config.censor('PASSWORD', 'DATABASE')
2021-06-03 10:17:02 +02:00
config.add(os.path.join(args.migrations_dir, config.get('DATABASE_ENGINE')), '_MIGRATIONS_DIR', True)
if not os.path.isdir(config.get('_MIGRATIONS_DIR')):
2021-06-02 12:59:04 +02:00
logg.debug('migrations dir for engine {} not found, reverting to default'.format(config.get('DATABASE_ENGINE')))
2021-06-03 10:17:02 +02:00
config.add(os.path.join(args.migrations_dir, 'default'), '_MIGRATIONS_DIR', True)
logg.debug('config loaded:\n{}'.format(config))
os.makedirs(config.get('PATH_DATA'), exist_ok=True)
2021-06-02 12:59:04 +02:00
dsn = dsn_from_config(config)
2021-06-03 10:17:02 +02:00
def main():
logg.info('using migrations dir {}'.format(config.get('_MIGRATIONS_DIR')))
logg.info('using db {}'.format(dsn))
ac = AlembicConfig(os.path.join(config.get('_MIGRATIONS_DIR'), 'alembic.ini'))
ac.set_main_option('sqlalchemy.url', dsn)
ac.set_main_option('script_location', config.get('_MIGRATIONS_DIR'))
if args.reset:
logg.debug('reset is set, purging existing content')
alembic.command.downgrade(ac, 'base')
2021-06-02 12:59:04 +02:00
2021-06-03 10:17:02 +02:00
alembic.command.upgrade(ac, 'head')
2021-06-02 12:59:04 +02:00
2021-06-03 10:17:02 +02:00
if __name__ == '__main__':
main()