def upgrade():
session = sa.orm.Session(bind=op.get_bind())
op.add_column(
'citation_target',
sa.Column('curated_metadata',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True))
op.add_column(
'citation_target_version',
sa.Column('curated_metadata',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True))
op.add_column('citation_target',
sa.Column('bibcode', sa.Text(), nullable=True))
op.add_column('citation_target_version',
sa.Column('bibcode', sa.Text(), nullable=True))
pgrsql_populate_bibcode_column = "UPDATE public.citation_target \
SET bibcode = parsed_cited_metadata->>'bibcode' \
WHERE parsed_cited_metadata->>'bibcode' is not NULL"
op.execute(pgrsql_populate_bibcode_column)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'tile_servers', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(), nullable=False),
sa.Column('type', sa.String(), nullable=False),
sa.Column('url', sa.String(), nullable=False),
sa.Column('attribution', sa.String(), nullable=False),
sa.Column('tileOptions',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
sa.Column('uiOptions',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
sa.ForeignKeyConstraint(['project_id'], ['projects.id'],
onupdate='CASCADE',
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_tile_servers_project_id'),
'tile_servers', ['project_id'],
unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'design', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(), nullable=False),
sa.Column('model_id', sa.Integer(), nullable=False),
sa.Column('design',
postgresql.JSONB(astext_type=sa.Text()),
nullable=False), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_design_project_id'),
'design', ['project_id'],
unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'users',
sa.Column('user_uuid',
postgresql.UUID(as_uuid=True),
server_default=sa.text(u'uuid_generate_v4()'),
nullable=False),
sa.Column('user_type', sa.String(), nullable=True),
sa.Column('data',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True), sa.PrimaryKeyConstraint('user_uuid'))
op.create_table(
'oauth', sa.Column('oauth_id', sa.String(), nullable=False),
sa.Column('user_uuid', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('access_token', sa.String(), nullable=True),
sa.Column('provider', sa.String(), nullable=False),
sa.Column('scopes',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
sa.Column('data',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
sa.ForeignKeyConstraint(
['user_uuid'],
['users.user_uuid'],
), sa.PrimaryKeyConstraint('oauth_id'))
op.create_table(
'sessions', sa.Column('uid', sa.String(), nullable=False),
sa.Column('created', sa.DateTime(), nullable=False),
sa.Column('user_uuid', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('active', sa.Boolean(), nullable=False),
sa.Column('data',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
sa.ForeignKeyConstraint(
['user_uuid'],
['users.user_uuid'],
), sa.PrimaryKeyConstraint('uid'))
def downgrade():
op.create_table(
'event', sa.Column('id', sa.BIGINT(), nullable=False),
sa.Column('origin', sa.VARCHAR(), autoincrement=False, nullable=True),
sa.Column('data',
postgresql.JSONB(),
autoincrement=False,
nullable=True),
sa.Column('created_at',
postgresql.TIMESTAMP(),
autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('id', name='event_pkey'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_table('irma_fileAgent')
op.drop_table('irma_submission')
op.add_column(
'irma_probeResult',
sa.Column('doc',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True))
op.drop_column('irma_probeResult', 'nosql_id')
op.create_unique_constraint('u_tag_file', 'irma_tag_file',
['id_tag', 'id_file'])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('iiif_image',
sa.Column('surrogate_id', sa.Integer(), nullable=False),
sa.Column('id', sa.String(), nullable=True),
sa.Column('info', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.PrimaryKeyConstraint('surrogate_id'),
sa.UniqueConstraint('id')
)
op.create_table('manifest',
sa.Column('surrogate_id', sa.Integer(), nullable=False),
sa.Column('id', sa.String(), nullable=True),
sa.Column('origin', sa.String(), nullable=True),
sa.Column('manifest', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.Column('label', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('surrogate_id'),
sa.UniqueConstraint('id'),
sa.UniqueConstraint('origin')
)
op.create_table('identifier',
sa.Column('surrogate_id', sa.Integer(), nullable=False),
sa.Column('id', sa.String(), nullable=True),
sa.Column('type', sa.String(), nullable=True),
sa.Column('manifest_id', sa.String(), nullable=False),
sa.ForeignKeyConstraint(['manifest_id'], ['manifest.id'], ),
sa.PrimaryKeyConstraint('surrogate_id'),
sa.UniqueConstraint('id')
)
op.create_table('image',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('url', sa.String(), nullable=True),
sa.Column('width', sa.Integer(), nullable=True),
sa.Column('height', sa.Integer(), nullable=True),
sa.Column('format', sa.Text(), nullable=True),
sa.Column('iiif_id', sa.String(length=22), nullable=True),
sa.ForeignKeyConstraint(['iiif_id'], ['iiif_image.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('url')
)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
"manifest_uploads",
sa.Column(
"manifest_patch",
postgresql.JSONB(astext_type=sa.Text()),
autoincrement=False,
nullable=False,
),
)
op.drop_column("manifest_uploads", "metadata_patch")
op.drop_column("manifest_uploads", "manifest_type")
def upgrade():
#with app.app_context() as c:
# db.session.add(Model())
# db.session.commit()
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('documents',
sa.Column('bibcode', sa.String(), nullable=False),
sa.Column('identifier', postgresql.ARRAY(sa.String()), nullable=False, index=True),
sa.Column('links', postgresql.JSONB(), nullable=False),
sa.PrimaryKeyConstraint('bibcode')
)
op.create_index(op.f('identifier_index'), 'documents', [sa.text('identifier')], unique=True)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint('tag_alias_id_key', 'tag_alias', type_='unique')
op.create_table(
'setting', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('value',
postgresql.JSONB(astext_type=sa.Text()),
nullable=False),
sa.Column('guild_id', sa.BigInteger(), nullable=False),
sa.ForeignKeyConstraint(['guild_id'], ['guild.id'],
name='setting_guild_id_fkey'),
sa.PrimaryKeyConstraint('id', name='setting_pkey'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'brk_tenaamstellingen',
sa.Column('gebaseerd_op',
postgresql.JSONB(astext_type=sa.Text()),
autoincrement=False,
nullable=True))
op.drop_column('brk_tenaamstellingen', 'volgnummer')
op.drop_column('brk_tenaamstellingen', 'registratiedatum')
op.drop_column('brk_tenaamstellingen', 'gebaseerd_op_stukdeel')
op.drop_column('brk_tenaamstellingen', 'eind_geldigheid')
op.drop_column('brk_tenaamstellingen', 'begin_geldigheid')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.alter_column('setting',
'value',
existing_type=postgresql.JSONB(astext_type=sa.Text()),
type_=postgresql.JSON(astext_type=sa.Text()),
existing_nullable=False)
op.alter_column('setting',
'updated_at',
existing_type=sa.TIMESTAMP(timezone=True),
type_=postgresql.TIMESTAMP(),
existing_nullable=False)
op.alter_column('setting',
'created_at',
existing_type=sa.TIMESTAMP(timezone=True),
type_=postgresql.TIMESTAMP(),
existing_nullable=False)
op.alter_column('job',
'job_metadata',
existing_type=postgresql.JSONB(astext_type=sa.Text()),
type_=postgresql.JSON(astext_type=sa.Text()),
existing_nullable=True)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('task_runtime_settings',
sa.Column('id', postgresql.UUID(as_uuid=True), server_default=sa.text('gen_random_uuid()'), nullable=False),
sa.Column('settings', postgresql.JSONB(), nullable=False),
sa.Column('machine_id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('code_id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('test_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['code_id'], ['code.id'], ),
sa.ForeignKeyConstraint(['machine_id'], ['machine.id'], ),
sa.ForeignKeyConstraint(['test_id'], ['test.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
op.create_table(
'notification_history',
sa.Column('id', sa.Integer(), nullable=False, primary_key=True),
sa.Column('account_id', sa.String(length=50), nullable=False),
sa.Column('endpoint_id', postgresql.UUID(), nullable=False),
sa.Column('created', sa.DateTime(timezone=True), server_default=sa.text('now()'), nullable=False),
sa.Column('invocation_time', sa.Integer(), nullable=False),
sa.Column('invocation_result', sa.Boolean(), nullable=False),
sa.Column('details', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.ForeignKeyConstraint(['endpoint_id'], ['endpoints.id'], ondelete='CASCADE')
)
op.create_index('IX_account_endpoint_search', 'notification_history', ['account_id', 'endpoint_id'], unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
'access_strategies', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Text(), nullable=False),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('intervention_id', sa.Integer(), nullable=True),
sa.Column('rank', sa.Integer(), nullable=True),
sa.Column('function_details', postgresql.JSONB(), nullable=False),
sa.ForeignKeyConstraint(
['intervention_id'],
['interventions.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
op.add_column('logs',
sa.Column('meta',
postgresql.JSONB(),
nullable=False,
server_default='{}'),
schema='events')
op.alter_column('logs', 'meta', server_default=None, schema='events')
op.create_index(None,
'logs', ['meta'],
unique=False,
schema='events',
postgresql_using='gin')
def upgrade():
op.create_table(
"venue_contact",
sa.Column("id", sa.BigInteger(), nullable=False),
sa.Column("venueId", sa.BigInteger(), nullable=False),
sa.Column("email", sa.String(length=256), nullable=True),
sa.Column("website", sa.String(length=256), nullable=True),
sa.Column("phone_number", sa.String(length=64), nullable=True),
sa.Column("social_medias", postgresql.JSONB(astext_type=sa.Text()), server_default="{}", nullable=False),
sa.ForeignKeyConstraint(["venueId"], ["venue.id"], ondelete="CASCADE"),
sa.PrimaryKeyConstraint("id"),
)
op.create_index(op.f("ix_venue_contact_venueId"), "venue_contact", ["venueId"], unique=True)
def upgrade():
op.create_table(
"secapproval_requests",
sa.Column("id", sa.Integer(), primary_key=True),
sa.Column("revision_id", sa.Integer(), nullable=False, index=True),
sa.Column("diff_phid", sa.Text(), nullable=False),
sa.Column("created_at", sa.DateTime(timezone=True), nullable=False),
sa.Column(
"comment_candidates",
postgresql.JSONB(astext_type=sa.Text()),
nullable=False,
),
)
def upgrade():
"""Upgrade database."""
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('oarepo_oai_provider',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('code', sa.String(length=16), nullable=False),
sa.Column('description', sa.String(length=2048), nullable=True),
sa.Column('oai_endpoint', sa.String(length=2048), nullable=False),
sa.Column('metadata_prefix', sa.String(length=32), nullable=True),
sa.Column('constant_fields', sa.JSON().with_variant(
sqlalchemy_utils.types.json.JSONType(), 'mysql').with_variant(
postgresql.JSONB(none_as_null=True, astext_type=sa.Text()),
'postgresql').with_variant(sqlalchemy_utils.types.json.JSONType(),
'sqlite'), nullable=True),
sa.PrimaryKeyConstraint('id', name=op.f('pk_oarepo_oai_provider')),
sa.UniqueConstraint('code', name=op.f('uq_oarepo_oai_provider_code'))
)
op.create_table('oarepo_oai_sync',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('provider_id', sa.Integer(), nullable=True),
sa.Column('sync_start', sa.TIMESTAMP(), nullable=True),
sa.Column('sync_end', sa.TIMESTAMP(), nullable=True),
sa.Column('status', sa.String(length=32), nullable=True),
sa.Column('logs', sa.String(length=2048), nullable=True),
sa.Column('rec_created', sa.Integer(), nullable=True),
sa.Column('rec_modified', sa.Integer(), nullable=True),
sa.Column('rec_deleted', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['provider_id'], ['oarepo_oai_provider.id'], name=op.f(
'fk_oarepo_oai_sync_provider_id_oarepo_oai_provider')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_oarepo_oai_sync'))
)
op.create_table('oarepo_oai_record',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(), nullable=False),
sa.Column('oai_identifier', sa.String(length=2048), nullable=False),
sa.Column('last_sync_id', sa.INTEGER(), nullable=True),
sa.Column('modification_sync_id', sa.INTEGER(), nullable=True),
sa.Column('creation_sync_id', sa.INTEGER(), nullable=True),
sa.Column('timestamp', sa.TIMESTAMP(), nullable=False),
sa.ForeignKeyConstraint(['creation_sync_id'], ['oarepo_oai_sync.id'], name=op.f(
'fk_oarepo_oai_record_creation_sync_id_oarepo_oai_sync')),
sa.ForeignKeyConstraint(['id'], ['records_metadata.id'],
name=op.f('fk_oarepo_oai_record_id_records_metadata')),
sa.ForeignKeyConstraint(['last_sync_id'], ['oarepo_oai_sync.id'], name=op.f(
'fk_oarepo_oai_record_last_sync_id_oarepo_oai_sync')),
sa.ForeignKeyConstraint(['modification_sync_id'], ['oarepo_oai_sync.id'],
name=op.f(
'fk_oarepo_oai_record_modification_sync_id_oarepo_oai_sync')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_oarepo_oai_record')),
sa.UniqueConstraint('oai_identifier',
name=op.f('uq_oarepo_oai_record_oai_identifier'))
)
def upgrade():
op.add_column('experiment_runs',
sa.Column('run_type', sa.Text(), nullable=True),
schema='triage_metadata')
op.execute(
"UPDATE triage_metadata.experiment_runs SET run_type='experiment' WHERE run_type IS NULL"
)
op.alter_column('experiment_runs',
'experiment_hash',
nullable=True,
new_column_name='run_hash',
schema='triage_metadata')
op.drop_constraint('experiment_runs_experiment_hash_fkey',
'experiment_runs',
type_='foreignkey',
schema='triage_metadata')
op.execute(
"ALTER TABLE triage_metadata.experiment_runs RENAME TO triage_runs")
op.create_table(
'retrain',
sa.Column('retrain_hash', sa.Text(), nullable=False),
sa.Column('config',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
sa.Column('prediction_date', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('retrain_hash'),
schema='triage_metadata',
)
op.alter_column('models',
'built_in_experiment_run',
nullable=False,
new_column_name='built_in_triage_run',
schema='triage_metadata')
op.execute(
"CREATE TABLE triage_metadata.deprecated_models_built_by_experiment AS SELECT model_id, model_hash, built_by_experiment FROM triage_metadata.models"
)
op.drop_column('models', 'built_by_experiment', schema='triage_metadata')
op.create_table('retrain_models',
sa.Column('retrain_hash', sa.String(), nullable=False),
sa.Column('model_hash', sa.String(), nullable=False),
sa.ForeignKeyConstraint(
['retrain_hash'],
['triage_metadata.retrain.retrain_hash'],
),
sa.PrimaryKeyConstraint('retrain_hash', 'model_hash'),
schema='triage_metadata')
def downgrade():
op.add_column(
"interactive_sessions",
sa.Column(
"notebook_server_info",
postgresql.JSONB(astext_type=sa.Text()),
autoincrement=False,
nullable=True,
),
)
op.add_column(
"interactive_sessions",
sa.Column(
"container_ids",
postgresql.JSONB(astext_type=sa.Text()),
autoincrement=False,
nullable=True,
),
)
op.add_column(
"interactive_sessions",
sa.Column(
"jupyter_server_ip",
sa.VARCHAR(length=15),
autoincrement=False,
nullable=True,
),
)
op.create_unique_constraint(
"uq_interactive_sessions_notebook_server_info",
"interactive_sessions",
["notebook_server_info"],
)
op.create_unique_constraint(
"uq_interactive_sessions_jupyter_server_ip",
"interactive_sessions",
["jupyter_server_ip"],
)
def upgrade():
op.create_table('map',
sa.Column('uuid', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('secret', sa.Unicode(), nullable=True),
sa.Column('name', sa.Unicode(), nullable=True),
sa.Column('description', sa.Unicode(), nullable=True),
sa.Column('place', sa.Unicode(), nullable=True),
sa.Column('_datetime', sa.DateTime(timezone=True), nullable=True),
sa.Column('_bbox', gsa.Geometry(geometry_type='POLYGON', from_text='ST_GeomFromEWKT', name='geometry'), nullable=True),
sa.Column('attributes', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.Column('published', sa.Boolean(), nullable=True),
sa.Column('lifespan', sa.Interval(), nullable=True),
sa.Column('theme', sa.Unicode(), nullable=True),
sa.PrimaryKeyConstraint('uuid')
)
op.create_table('feature',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('map_uuid', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('_geo', gsa.Geometry(from_text='ST_GeomFromEWKT', name='geometry'), nullable=True),
sa.Column('style', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.ForeignKeyConstraint(['map_uuid'], ['map.uuid'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'submission',
sa.Column('verified_fields',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True))
connection = op.get_bind()
query = sa.sql.text('''
UPDATE submission
SET verified_fields = '[]'::jsonb
WHERE verified_fields IS NULL;
''')
connection.execute(query)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('ads',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('file', sa.String(), nullable=False),
sa.Column('schedule', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('advertisers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('file', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'seen_netloc_tracker', sa.Column('id', sa.BigInteger(),
nullable=False),
sa.Column('netloc', citext.CIText(), nullable=False),
sa.Column('ignore', sa.Boolean(), nullable=True),
sa.Column('have', sa.Boolean(), nullable=True),
sa.Column('extra',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_seen_netloc_tracker_netloc'),
'seen_netloc_tracker', ['netloc'],
unique=True)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('events',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('eb_name_html', sa.String(length=255), nullable=False),
sa.Column('eb_description_html', sa.Text()),
sa.Column('eb_id', sa.String(length=90), nullable=False),
sa.Column('eb_url', sa.String(length=255), nullable=False),
sa.Column('eb_start_utc', sa.String(length=90), nullable=True),
sa.Column('eb_end_utc', sa.String(length=90), nullable=True),
sa.Column('eb_capacity', sa.Integer(), nullable=True),
sa.Column('eb_venue', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
op.add_column(
"tracks",
sa.Column("is_unlisted",
sa.Boolean(),
server_default="false",
nullable=False),
)
op.add_column(
"tracks",
sa.Column("field_visibility",
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('api_event',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('name', sa.String(length=80), nullable=False),
sa.Column('user_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=True),
sa.Column('data', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['person.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_api_event_name'), 'api_event', ['name'], unique=False)
op.create_index(op.f('ix_api_event_user_id'), 'api_event', ['user_id'], unique=False)
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('chargebee_webhook_log',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('data', postgresql.JSONB(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'chargebee_subscription_cache',
sa.Column('id', sa.String(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.Column('company_id', sa.Integer(), nullable=False),
sa.Column('data', postgresql.JSONB(), nullable=False),
sa.ForeignKeyConstraint(
['company_id'],
['companies.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_chargebee_subscription_cache_company_id'),
'chargebee_subscription_cache', ['company_id'],
unique=False)
op.drop_table('stripe_cards')
op.drop_table('stripe_subscriptions')
op.drop_table('stripe_customer')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('monitored_upstreams',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('package_id', sa.Integer(), nullable=True),
sa.Column('url', sa.String(length=255), nullable=False),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('added_at', sa.DateTime(), nullable=False),
sa.Column('deactivated_at', sa.DateTime(), nullable=True),
sa.Column('active', sa.Boolean(), nullable=False),
sa.ForeignKeyConstraint(
['package_id'],
['packages.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_monitored_upstreams_package_id'),
'monitored_upstreams', ['package_id'],
unique=False)
op.create_table('package_analyses',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('package_id', sa.Integer(), nullable=True),
sa.Column('started_at', sa.DateTime(), nullable=True),
sa.Column('finished_at', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['package_id'],
['packages.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_package_analyses_package_id'),
'package_analyses', ['package_id'],
unique=False)
op.create_table(
'package_worker_results', sa.Column('id', sa.Integer(),
nullable=False),
sa.Column('package_analysis_id', sa.Integer(), nullable=True),
sa.Column('worker', sa.String(length=255), nullable=True),
sa.Column('worker_id', sa.String(length=64), nullable=True),
sa.Column('external_request_id', sa.String(length=64), nullable=True),
sa.Column('task_result',
postgresql.JSONB(astext_type=sa.Text()),
nullable=True),
sa.Column('error', sa.Boolean(), nullable=False),
sa.ForeignKeyConstraint(
['package_analysis_id'],
['package_analyses.id'],
), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('worker_id'))
op.create_index(op.f('ix_package_worker_results_package_analysis_id'),
'package_worker_results', ['package_analysis_id'],
unique=False)
op.create_index(op.f('ix_package_worker_results_worker'),
'package_worker_results', ['worker'],
unique=False)
