You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

33 lines
882 B

#!/usr/bin/env python3
Create the initial database schema and stamp the `head` revision.
The target database needs to exist, as defined in the config file.
Idempotent. If the tables already exist, they will not be re-created.
import hubsrht.alembic
import hubsrht.types
import srht.alembic
from alembic import command
from alembic.config import Config
from srht.config import cfg
from srht.database import DbSession
connection_string = cfg("", "connection-string")
alembic_path = list(hubsrht.alembic.__path__)[0]
db = DbSession(connection_string)
config = Config()
config.set_main_option("sqlalchemy.url", connection_string)
config.set_main_option("script_location", alembic_path)
command.stamp(config, "head")
alembic_path = list(srht.alembic.__path__)[0]
config.set_main_option("script_location", alembic_path)
command.stamp(config, "head")