def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('blacklist_tokens', sa.Column('id', sa.Integer(), autoincrement=True, nullable=False), sa.Column('token', sa.String(length=500), nullable=False), sa.Column('blacklisted_on', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_blacklist_tokens_token'), 'blacklist_tokens', ['token'], unique=True) op.create_table('movies', sa.Column('id', models.GUID(length=32), nullable=False), sa.Column('name', sa.String(length=80), nullable=False), sa.Column('director', sa.String(length=80), nullable=False), sa.Column('popularity', mysql.FLOAT(precision=10, scale=1), nullable=True), sa.Column('genre', sa.Text(), nullable=False), sa.Column('imdb_score', mysql.FLOAT(precision=10, scale=1), nullable=True), sa.Column('views', sa.Integer(), nullable=True), sa.Column('created_by', models.GUID(length=32), nullable=True), sa.Column('updated_by', models.GUID(length=32), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['created_by'], ['admin_users.id'], ), sa.ForeignKeyConstraint(['updated_by'], ['admin_users.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_index(op.f('ix_movies_director'), 'movies', ['director'], unique=False) op.create_index(op.f('ix_movies_name'), 'movies', ['name'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'crons', sa.Column('id', models.GUID(), nullable=False), sa.Column('webapp_id', models.GUID(), nullable=True), sa.Column('command', sa.String(length=256), nullable=False), sa.Column('hour', sa.String(length=256), nullable=True), sa.Column('minute', sa.String(length=256), nullable=True), sa.Column('month', sa.String(length=256), nullable=True), sa.Column('month_day', sa.String(length=256), nullable=True), sa.Column('week_day', sa.String(length=256), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['webapp_id'], ['webapps.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('users', sa.Column('id', sa.String(length=32), nullable=False), sa.Column('name', sa.String(length=255), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'), sa.UniqueConstraint('name') ) op.create_table('tosses', sa.Column('id', models.GUID(), nullable=False), sa.Column('elected', sa.String(length=32), nullable=True), sa.Column('excludes', sa.String(length=255), nullable=True), sa.Column('name', sa.String(length=255), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['elected'], ['users.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('capsules', sa.Column('delegate_fqdns', sa.Boolean(), nullable=False)) op.add_column('capsules', sa.Column('delegate_tls', sa.Boolean(), nullable=False)) op.add_column('capsules', sa.Column('tls_crt', sa.Text(), nullable=True)) op.add_column('capsules', sa.Column('tls_key', sa.Text(), nullable=True)) op.add_column( 'capsules', sa.Column('tls_redirect_https', sa.Boolean(), nullable=False)) op.drop_column('capsules', 'delegate_webapp_admin') op.add_column('fqdns', sa.Column('capsule_id', models.GUID(), nullable=True)) op.create_foreign_key(None, 'fqdns', 'capsules', ['capsule_id'], ['id']) # Replace webapp_ids by capsule_ids in fqdns table (look in capsules table for matching) op.execute( "UPDATE fqdns f, capsules c SET f.capsule_id = c.id WHERE c.webapp_id = f.webapp_id;" ) # # Migrate tls data from webapps to capsules op.execute("UPDATE capsules c, webapps w " "SET " "c.tls_redirect_https = w.tls_redirect_https, " "c.tls_key = w.tls_key, " "c.tls_crt = w.tls_crt " "WHERE w.id = c.webapp_id") op.drop_constraint('fqdns_ibfk_1', 'fqdns', type_='foreignkey') # Cleanup old column op.drop_column('fqdns', 'webapp_id') op.drop_column('webapps', 'tls_key') op.drop_column('webapps', 'tls_crt') op.drop_column('webapps', 'tls_redirect_https')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'runtimes', sa.Column('id', models.GUID(), nullable=False), sa.Column('name', sa.String(length=256), nullable=False), sa.Column('desc', sa.String(length=256), nullable=False), sa.Column('fam', sa.String(length=256), nullable=False), sa.Column('runtime_type', sa.Enum('webapp', 'addon', name='runtimetypeenum'), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table( 'users', sa.Column('id', models.GUID(), nullable=False), sa.Column('name', sa.String(length=32), nullable=False), sa.Column('role', sa.Enum('user', 'admin', 'superadmin', name='roleenum'), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'), sa.UniqueConstraint('name')) op.create_table('apptokens', sa.Column('id', models.GUID(), nullable=False), sa.Column('app', sa.String(length=256), nullable=False), sa.Column('owner_id', models.GUID(), nullable=True), sa.Column('token', sa.String(length=256), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['owner_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'), sa.UniqueConstraint('token')) op.create_table( 'available_options', sa.Column('id', models.GUID(), nullable=False), sa.Column('runtime_id', models.GUID(), nullable=True), sa.Column('access_level', sa.Enum('user', 'admin', 'superadmin', name='roleenum'), nullable=False), sa.Column('tag', sa.String(length=256), nullable=False), sa.Column('field_name', sa.String(length=256), nullable=False), sa.Column('field_description', sa.String(length=256), nullable=True), sa.Column('value_type', sa.Enum('integer', 'float', 'boolean', 'string', 'file', name='optionvaluetypeenum'), nullable=False), sa.Column('default_value', sa.String(length=256), nullable=True), sa.ForeignKeyConstraint( ['runtime_id'], ['runtimes.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table('sshkeys', sa.Column('id', models.GUID(), nullable=False), sa.Column('public_key', sa.Text(), nullable=False), sa.Column('user_id', models.GUID(), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table( 'webapps', sa.Column('id', models.GUID(), nullable=False), sa.Column('runtime_id', models.GUID(), nullable=True), sa.Column('tls_redirect_https', sa.Boolean(), nullable=True), sa.Column('tls_crt', sa.Text(), nullable=True), sa.Column('tls_key', sa.Text(), nullable=True), sa.Column('env', sa.Text(), nullable=True), sa.Column('quota_volume_size', sa.String(length=256), nullable=True), sa.Column('quota_memory_max', sa.String(length=256), nullable=True), sa.Column('quota_cpu_max', sa.String(length=256), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['runtime_id'], ['runtimes.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table( 'available_option_validation_rules', sa.Column('id', models.GUID(), nullable=False), sa.Column('available_option_id', models.GUID(), nullable=True), sa.Column('type', sa.Enum('regex', 'min', 'max', 'eq', 'neq', 'format', name='validationruleenum'), nullable=False), sa.Column('arg', sa.String(length=256), nullable=False), sa.ForeignKeyConstraint( ['available_option_id'], ['available_options.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table( 'capsules', sa.Column('id', models.GUID(), nullable=False), sa.Column('uid', sa.Integer(), autoincrement=True, nullable=False), sa.Column('name', sa.String(length=256), nullable=False), sa.Column('webapp_id', models.GUID(), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['webapp_id'], ['webapps.id'], ), sa.PrimaryKeyConstraint('uid'), sa.UniqueConstraint('id'), sa.UniqueConstraint('name'), sa.UniqueConstraint('uid')) op.create_table('fqdns', sa.Column('id', models.GUID(), nullable=False), sa.Column('webapp_id', models.GUID(), nullable=True), sa.Column('name', sa.String(length=256), nullable=False), sa.Column('alias', sa.Boolean(), nullable=False), sa.ForeignKeyConstraint( ['webapp_id'], ['webapps.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table( 'addons', sa.Column('id', models.GUID(), nullable=False), sa.Column('runtime_id', models.GUID(), nullable=True), sa.Column('capsule_id', models.GUID(), nullable=True), sa.Column('name', sa.String(length=256), nullable=False), sa.Column('description', sa.String(length=256), nullable=True), sa.Column('uri', sa.String(length=256), nullable=True), sa.Column('env', sa.Text(), nullable=True), sa.Column('quota_volume_size', sa.String(length=256), nullable=True), sa.Column('quota_memory_max', sa.String(length=256), nullable=True), sa.Column('quota_cpu_max', sa.String(length=256), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('updated_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['capsule_id'], ['capsules.id'], ), sa.ForeignKeyConstraint( ['runtime_id'], ['runtimes.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id')) op.create_table('capsules_sshkeys', sa.Column('capsule_id', models.GUID(), nullable=True), sa.Column('sshkey_id', models.GUID(), nullable=True), sa.ForeignKeyConstraint( ['capsule_id'], ['capsules.id'], ), sa.ForeignKeyConstraint( ['sshkey_id'], ['sshkeys.id'], )) op.create_table('capsules_users', sa.Column('capsule_id', models.GUID(), nullable=True), sa.Column('user_id', models.GUID(), nullable=True), sa.ForeignKeyConstraint( ['capsule_id'], ['capsules.id'], ), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], )) op.create_table( 'options', sa.Column('id', models.GUID(), nullable=False), sa.Column('webapp_id', models.GUID(), nullable=True), sa.Column('addon_id', models.GUID(), nullable=True), sa.Column('tag', sa.String(length=256), nullable=True), sa.Column('field_name', sa.String(length=256), nullable=True), sa.Column('value', sa.String(length=256), nullable=True), sa.ForeignKeyConstraint( ['addon_id'], ['addons.id'], ), sa.ForeignKeyConstraint( ['webapp_id'], ['webapps.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('id'))