def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'customizations',
sa.Column('id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('price', sa.Float(), nullable=True),
sa.Column('name', sa.String(), nullable=True),
sa.Column('created_at',
sa.DateTime(),
server_default=sa.text('now()'),
nullable=True),
sa.Column('updated_at',
sa.DateTime(),
server_default=sa.text('now()'),
nullable=True), sa.PrimaryKeyConstraint('id'))
op.create_table(
'products_customizations',
sa.Column('id', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('product_id', postgresql.UUID(as_uuid=True), nullable=True),
sa.Column('customization_id',
postgresql.UUID(as_uuid=True),
nullable=True),
sa.Column('created_at',
sa.DateTime(),
server_default=sa.text('now()'),
nullable=True),
sa.Column('updated_at',
sa.DateTime(),
server_default=sa.text('now()'),
nullable=True),
sa.ForeignKeyConstraint(
['customization_id'],
['customizations.id'],
), sa.ForeignKeyConstraint(
['product_id'],
['products.id'],
), sa.PrimaryKeyConstraint('id'))
op.add_column(
'orders_products',
sa.Column('customizations', sa.ARRAY(sa.Text()), nullable=True))
def upgrade():
create_partition_function()
table_name = "presigned_url"
print(f" Creating `{table_name}` table")
op.create_table(
table_name,
sa.Column("request_url", sa.String(), nullable=False),
sa.Column("status_code", sa.Integer(), nullable=False),
sa.Column("timestamp",
sa.DateTime,
nullable=False,
server_default=sa.func.now()),
sa.Column("username", sa.String(), nullable=False),
sa.Column("sub", sa.Integer(), nullable=True),
sa.Column("guid", sa.String(), nullable=False),
sa.Column("resource_paths", sa.ARRAY(sa.String()), nullable=False),
sa.Column("action", sa.String(), nullable=False),
sa.Column("protocol", sa.String(), nullable=True),
)
setup_table_partitioning(table_name)
table_name = "login"
print(f" Creating `{table_name}` table")
op.create_table(
table_name,
sa.Column("request_url", sa.String(), nullable=False),
sa.Column("status_code", sa.Integer(), nullable=False),
sa.Column("timestamp",
sa.DateTime,
nullable=False,
server_default=sa.func.now()),
sa.Column("username", sa.String(), nullable=False),
sa.Column("sub", sa.Integer(), nullable=True),
sa.Column("idp", sa.String(), nullable=False),
sa.Column("fence_idp", sa.String(), nullable=True),
sa.Column("shib_idp", sa.String(), nullable=True),
sa.Column("client_id", sa.String(), nullable=True),
)
setup_table_partitioning(table_name)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'person', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('login', sa.String(), nullable=True),
sa.Column('email', sa.String(), nullable=True),
sa.Column('password', sa.String(), nullable=True),
sa.Column('gender', sa.String(length=1), nullable=True),
sa.Column('user_agent', sa.String(), nullable=True),
sa.Column('cookies', sa.ARRAY(sa.JSON()), nullable=True),
sa.Column('last_activity', sa.DateTime(), nullable=True),
sa.Column('is_fake', sa.Boolean(), nullable=True),
sa.Column('is_dribbble_user', sa.Boolean(), nullable=True),
sa.Column('is_dribbble_email_confirm', sa.Boolean(), nullable=True),
sa.Column('is_dribbble_set_pic', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('task', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('url', sa.String(length=100), nullable=True),
sa.Column('counter', sa.Integer(), nullable=True),
sa.Column('is_liked_task', sa.Boolean(), nullable=True),
sa.Column('is_comment_task', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('association',
sa.Column('person_id', sa.Integer(), nullable=True),
sa.Column('task_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['person_id'],
['person.id'],
), sa.ForeignKeyConstraint(
['task_id'],
['task.id'],
))
op.create_table('dribbble_queue',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('person_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['person_id'],
['person.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'Artist', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('city', sa.String(length=120), nullable=True),
sa.Column('state', sa.String(length=120), nullable=True),
sa.Column('phone', sa.String(length=120), nullable=True),
sa.Column('genres', sa.String(length=120), nullable=False),
sa.Column('website', sa.String(length=120), nullable=True),
sa.Column('image_link', sa.String(length=500), nullable=True),
sa.Column('facebook_link', sa.String(length=120), nullable=True),
sa.Column('seeking_venue', sa.Boolean(), nullable=True),
sa.Column('seeking_description', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'Venue', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('city', sa.String(length=120), nullable=True),
sa.Column('state', sa.String(length=120), nullable=True),
sa.Column('address', sa.String(length=120), nullable=True),
sa.Column('phone', sa.String(length=120), nullable=True),
sa.Column('image_link', sa.String(length=500), nullable=True),
sa.Column('facebook_link', sa.String(length=120), nullable=True),
sa.Column('genres', sa.ARRAY(sa.String()), nullable=False),
sa.Column('website', sa.String(length=120), nullable=True),
sa.Column('seeking_talent', sa.Boolean(), nullable=True),
sa.Column('seeking_description', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table('Show', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('venue_id', sa.Integer(), nullable=False),
sa.Column('artist_id', sa.Integer(), nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=False),
sa.ForeignKeyConstraint(
['artist_id'],
['Artist.id'],
), sa.ForeignKeyConstraint(
['venue_id'],
['Venue.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
"""Upgrade this migration."""
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('activities',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('collection_id', sa.String(length=64), nullable=False),
sa.Column('warped_collection_id', sa.String(length=64), nullable=False),
sa.Column('activity_type', sa.String(length=64), nullable=False),
sa.Column('period', sa.String(length=64), nullable=False),
sa.Column('date', sa.Date(), nullable=False),
sa.Column('tile_id', sa.String(), nullable=False),
sa.Column('status', sa.String(length=64), nullable=False),
sa.Column('args', sa.JSON(), nullable=True),
sa.Column('tags', sa.ARRAY(sa.String()), nullable=True),
sa.Column('scene_type', sa.String(), nullable=True),
sa.Column('band', sa.String(length=64), nullable=False),
sa.Column('traceback', sa.Text(), nullable=True),
sa.Column('created', sa.TIMESTAMP(timezone=True), server_default=sa.text('now()'), nullable=False),
sa.Column('updated', sa.TIMESTAMP(timezone=True), server_default=sa.text('now()'), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('activities_pkey')),
schema='cube_builder'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
"users",
sa.Column(
"tags",
sa.ARRAY(sa.String()),
nullable=True,
),
)
op.add_column(
"users",
sa.Column("user_id", sa.Integer(), nullable=False),
)
op.drop_constraint("users_email_key", "users", type_="unique")
op.drop_constraint("users_username_key", "users", type_="unique")
op.drop_column("users", "api_refresh_token")
op.drop_column("users", "api_token")
op.drop_column("users", "password")
op.drop_column("users", "email")
op.drop_column("users", "username")
op.drop_column("users", "id")
def _to_sqla_type(itype, type_map=None):
if type_map is None:
type_map = _ibis_type_to_sqla
if isinstance(itype, dt.Decimal):
return sa.types.NUMERIC(itype.precision, itype.scale)
elif isinstance(itype, dt.Date):
return sa.Date()
elif isinstance(itype, dt.Timestamp):
# SQLAlchemy DateTimes do not store the timezone, just whether the db
# supports timezones.
return sa.TIMESTAMP(bool(itype.timezone))
elif isinstance(itype, dt.Array):
ibis_type = itype.value_type
if not isinstance(ibis_type, (dt.Primitive, dt.String)):
raise TypeError(
'Type {} is not a primitive type or string type'.format(
ibis_type
)
)
return sa.ARRAY(_to_sqla_type(ibis_type, type_map=type_map))
else:
return type_map[type(itype)]
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('Shows',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('time', sa.DateTime(timezone=True), nullable=False),
sa.Column('venue_id', sa.Integer(), nullable=True),
sa.Column('artist_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['artist_id'], ['Artist.id'], ),
sa.ForeignKeyConstraint(['venue_id'], ['Venue.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.add_column('Artist', sa.Column('past_shows_count', sa.Integer(), nullable=True))
op.add_column('Artist', sa.Column('seeking_description', sa.String(), nullable=True))
op.add_column('Artist', sa.Column('seeking_venue', sa.Boolean(), nullable=True))
op.add_column('Artist', sa.Column('upcoming_shows_count', sa.Integer(), nullable=True))
op.add_column('Artist', sa.Column('website_link', sa.String(length=120), nullable=True))
op.add_column('Venue', sa.Column('genres', sa.ARRAY(sa.String(length=120)), nullable=True))
op.add_column('Venue', sa.Column('past_shows_count', sa.Integer(), nullable=True))
op.add_column('Venue', sa.Column('seeking_description', sa.String(), nullable=True))
op.add_column('Venue', sa.Column('seeking_talent', sa.Boolean(), nullable=True))
op.add_column('Venue', sa.Column('upcoming_shows_count', sa.Integer(), nullable=True))
op.add_column('Venue', sa.Column('website_link', sa.String(length=120), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('shows', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('venue_id', sa.Integer(), nullable=True),
sa.Column('artist_id', sa.Integer(), nullable=True),
sa.Column('start_time', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(
['artist_id'],
['artists.id'],
), sa.ForeignKeyConstraint(
['venue_id'],
['venues.id'],
), sa.PrimaryKeyConstraint('id'))
op.add_column('venues',
sa.Column('genres', sa.ARRAY(sa.String()), nullable=True))
op.add_column(
'venues',
sa.Column('seeking_description', sa.String(length=500), nullable=True))
op.add_column('venues',
sa.Column('seeking_talent', sa.Boolean(), nullable=True))
op.add_column('venues',
sa.Column('website', sa.String(length=120), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sheet',
sa.Column('sheet_label', sa.String(), nullable=False),
sa.Column('iteration', sa.Integer(), nullable=True),
sa.Column('avgmoe', sa.DECIMAL(), nullable=True),
sa.Column('avgsg', sa.DECIMAL(), nullable=True),
sa.Column('avgmc', sa.DECIMAL(), nullable=True),
sa.Column('avgvel', sa.DECIMAL(), nullable=True),
sa.Column('avgupt', sa.DECIMAL(), nullable=True),
sa.Column('pkdensity', sa.DECIMAL(), nullable=True),
sa.Column('effvel', sa.ARRAY(sa.DECIMAL()), nullable=True),
sa.Column('lvel', sa.ARRAY(sa.DECIMAL()), nullable=True),
sa.Column('rvel', sa.ARRAY(sa.DECIMAL()), nullable=True),
sa.Column('lupt', sa.ARRAY(sa.DECIMAL()), nullable=True),
sa.Column('rupt', sa.ARRAY(sa.DECIMAL()), nullable=True),
sa.Column('sg', sa.ARRAY(sa.DECIMAL()), nullable=True),
sa.Column('mc', sa.ARRAY(sa.DECIMAL()), nullable=True),
sa.PrimaryKeyConstraint('sheet_label'),
sa.UniqueConstraint('iteration'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
"user_settings",
sa.Column("user_id", sa.Integer(), nullable=False),
sa.Column(
"tags",
sa.ARRAY(sa.String()),
nullable=True,
),
sa.Column(
"currency",
sa.String(length=3),
nullable=True,
),
sa.Column("rate", sa.Float(), nullable=True),
sa.ForeignKeyConstraint(["user_id"], ["users.user_id"]),
sa.PrimaryKeyConstraint("user_id"),
)
op.drop_column("users", "tags")
op.drop_column("users", "rate")
op.drop_column("users", "currency")
def downgrade():
op.drop_column('kernels', 'stdout_port')
op.drop_column('kernels', 'stdin_port')
op.drop_column('kernels', 'repl_out_port')
op.drop_column('kernels', 'repl_in_port')
op.drop_column('kernels', 'mem_slot')
op.drop_column('kernels', 'gpu_slot')
op.drop_column('kernels', 'cpu_slot')
op.drop_column('kernels', 'agent_addr')
op.drop_index(op.f('ix_agents_status'), table_name='agents')
op.drop_column('agents', 'status')
op.drop_column('agents', 'lost_at')
op.alter_column('kernels',
column_name='status',
type_=sa.String(length=64))
op.add_column(
'kernels',
sa.Column('allocated_cores', sa.ARRAY(sa.Integer), nullable=True))
op.drop_column('kernels', 'cpu_set')
op.drop_column('kernels', 'gpu_set')
agentstatus.drop(op.get_bind())
kernelstatus.drop(op.get_bind())
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('uuid', sa.String(length=128), nullable=False),
sa.Column('email', sa.String(length=128), nullable=False),
sa.Column('name', sa.String(length=128), nullable=False),
sa.Column('password', sa.String(length=128), nullable=False),
sa.Column('is_admin', sa.Boolean(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('uuid')
)
op.create_table('board',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('uuid', sa.String(length=128), nullable=False),
sa.Column('name', sa.String(length=128), nullable=False),
sa.Column('latest_article', sa.ARRAY(sa.String()), nullable=True),
sa.Column('latest_article_idx', sa.Integer(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid')
)
op.create_table('article',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('uuid', sa.String(length=128), nullable=True),
sa.Column('title', sa.String(length=128), nullable=False),
sa.Column('content', sa.Text(), nullable=False),
sa.Column('board_id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['board_id'], ['board.id'], ),
sa.ForeignKeyConstraint(['user_id'], ['user.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'Artist',
sa.Column('seeking_description', sa.String(length=256), nullable=True))
op.add_column('Artist',
sa.Column('seeking_venue', sa.Boolean(), nullable=False))
op.add_column('Artist',
sa.Column('website', sa.String(length=2048), nullable=True))
op.drop_column('Artist', 'genres')
op.add_column('Artist',
sa.Column('genres', sa.ARRAY(sa.String()), nullable=True))
op.alter_column('Artist',
'facebook_link',
existing_type=sa.VARCHAR(length=120),
type_=sa.String(length=2048),
existing_nullable=True)
op.alter_column('Artist',
'image_link',
existing_type=sa.VARCHAR(length=500),
type_=sa.String(length=2048),
existing_nullable=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'imports',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('date', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'citizens', sa.Column('import_id', sa.Integer(), nullable=False),
sa.Column('citizen_id', sa.Integer(), nullable=False),
sa.Column('town', sa.String(), nullable=False),
sa.Column('street', sa.String(), nullable=False),
sa.Column('building', sa.String(), nullable=False),
sa.Column('apartment', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('birth_date', sa.DateTime(), nullable=False),
sa.Column('gender', sa.String(length=128), nullable=False),
sa.Column('relatives', sa.ARRAY(sa.Integer()), nullable=False),
sa.ForeignKeyConstraint(
['import_id'],
['imports.id'],
), sa.PrimaryKeyConstraint('import_id', 'citizen_id'))
class UpdateInfo(Base):
'''
只有一条记录
content 是所有已经爬取过的页面的 URL 列表
'''
__tablename__ = 'update_info'
update_id = sa.Column(
sa.Integer,
primary_key=True,
)
content = sa.Column(sa.ARRAY(sa.String), )
last_update_time = sa.Column(
sa.DateTime,
default=datetime.datetime.now,
onupdate=datetime.datetime.now,
)
def __repr__(self):
return "<UpdateInfo(last_update_time='%s')>" % (
self.last_update_time.strftime('%Y-%m-%d %H:%M:%S'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'Artist', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('city', sa.String(length=120), nullable=True),
sa.Column('state', sa.String(length=120), nullable=True),
sa.Column('phone', sa.String(length=120), nullable=True),
sa.Column('genres', sa.ARRAY(sa.String(length=120)), nullable=True),
sa.Column('image_link', sa.String(length=500), nullable=True),
sa.Column('facebook_link', sa.String(length=120), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'Venue', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('city', sa.String(length=120), nullable=True),
sa.Column('state', sa.String(length=120), nullable=True),
sa.Column('address', sa.String(length=120), nullable=True),
sa.Column('phone', sa.String(length=120), nullable=True),
sa.Column('image_link', sa.String(length=500), nullable=True),
sa.Column('facebook_link', sa.String(length=120), nullable=True),
sa.PrimaryKeyConstraint('id'))
class GreatGOVUKExportOpportunitiesPipeline(_ActivityStreamPipeline):
name = "great-gov-uk-export-opportunitites"
index = "objects"
table_config = TableConfig(
schema="dit",
table_name="great_gov_uk__export_opportunities",
field_mapping=[
("id", sa.Column("id", sa.String, primary_key=True)),
("name", sa.Column("name", sa.String, nullable=False)),
("url", sa.Column("url", sa.String, nullable=False)),
("content", sa.Column("content", sa.Text)),
("summary", sa.Column("summary", sa.Text)),
("endTime", sa.Column("end_time", sa.DateTime)),
("dit:country", sa.Column("countries", sa.ARRAY(sa.String))),
(
"dit:exportOpportunities:Opportunity:id",
sa.Column("opportunity_id", UUID(as_uuid=True)),
),
],
)
query = {"bool": {"filter": [{"term": {"type": "dit:Opportunity"}}]}}
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'ockovaci_mista_detail',
sa.Column('ockovaci_misto_id', sa.Unicode(), nullable=False),
sa.Column('typ', sa.Unicode(), nullable=True),
sa.Column('deti', sa.Boolean(), nullable=True),
sa.Column('drive_in', sa.Boolean(), nullable=True),
sa.Column('upresneni_polohy', sa.Unicode(), nullable=True),
sa.Column('platba_karta', sa.Boolean(), nullable=True),
sa.Column('platba_hotovost', sa.Boolean(), nullable=True),
sa.Column('telefon', sa.Unicode(), nullable=True),
sa.Column('email', sa.Unicode(), nullable=True),
sa.Column('odkaz', sa.Unicode(), nullable=True),
sa.Column('poznamka', sa.Unicode(), nullable=True),
sa.Column('verejna_poznamka', sa.Unicode(), nullable=True),
sa.Column('vakciny', sa.ARRAY(sa.Unicode()), nullable=True),
sa.Column('presun_2davky_nepovolen', sa.Boolean(), nullable=True),
sa.Column('presun_2davky_linka', sa.Boolean(), nullable=True),
sa.Column('presun_2davky_centrum', sa.Boolean(), nullable=True),
sa.Column('presun_2davky_telefon', sa.Unicode(), nullable=True),
sa.Column('presun_2davky_email', sa.Unicode(), nullable=True),
sa.Column('presun_2davky_online', sa.Boolean(), nullable=True),
sa.Column('presun_2davky_poznamka', sa.Unicode(), nullable=True),
sa.ForeignKeyConstraint(
['ockovaci_misto_id'],
['ockovaci_mista.id'],
), sa.PrimaryKeyConstraint('ockovaci_misto_id'))
op.create_table(
'provozni_doba',
sa.Column('ockovaci_misto_id', sa.Unicode(), nullable=False),
sa.Column('den', sa.Integer(), nullable=True),
sa.Column('od', sa.Unicode(), nullable=True),
sa.Column('do', sa.Unicode(), nullable=True),
sa.ForeignKeyConstraint(
['ockovaci_misto_id'],
['ockovaci_mista.id'],
), sa.PrimaryKeyConstraint('ockovaci_misto_id', 'den', 'od', 'do'))
def downgrade():
op.add_column("bank_information",
sa.Column("idAtProviders", sa.String(70), unique=True))
op.add_column(
"bank_information",
sa.Column("fieldsUpdated",
sa.ARRAY(sa.String(100)),
nullable=False,
server_default="{}"))
op.add_column(
"bank_information",
sa.Column("lastProviderId",
sa.BigInteger,
ForeignKey("provider.id"),
nullable=True))
op.create_check_constraint(
constraint_name="check_providable_with_provider_has_idatproviders",
table_name="bank_information",
condition='"lastProviderId" IS NULL OR "idAtProviders" IS NOT NULL',
)
op.alter_column("bank_information",
"dateModified",
new_column_name="dateModifiedAtLastProvider")
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('expenses',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('description', sa.String(), nullable=True),
sa.Column('amount', sa.Float(), nullable=True),
sa.Column('payee', sa.Integer(), nullable=True),
sa.Column('list_of_receivers', sa.ARRAY(sa.Integer()), nullable=True),
sa.Column('date_time', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('userbalance',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user1', sa.Integer(), nullable=True),
sa.Column('user2', sa.Integer(), nullable=True),
sa.Column('balance', sa.Numeric(precision=10, scale=2), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
class Adsorption(Base):
__tablename__ = 'adsorption'
id = sqa.Column(sqa.Integer, primary_key=True)
connectivity = sqa.Column(sqa.ARRAY(sqa.Integer))
surface_id = sqa.Column(sqa.Integer,
sqa.ForeignKey('surface.id'),
nullable=False)
surface = sqa.orm.relationship('Surface',
uselist=False,
cascade="all, delete-orphan",
single_parent=True)
molecules = sqa.orm.relationship('AdsorptionMolecules')
structure_id = sqa.Column(sqa.Integer, sqa.ForeignKey('structure.id'))
structure = sqa.orm.relationship('Structure', uselist=False)
def __init__(self, surface, molecules, connectivity, structure=None):
self.surface = surface
self.molecules = molecules
self.connectivity = connectivity
self.structure = structure
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('activities',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('collection_id',
sa.String(length=64),
nullable=False),
sa.Column('warped_collection_id',
sa.String(length=64),
nullable=False),
sa.Column('activity_type',
sa.String(length=64),
nullable=False),
sa.Column('period', sa.String(length=64), nullable=False),
sa.Column('date', sa.Date(), nullable=False),
sa.Column('status', sa.String(length=64), nullable=False),
sa.Column('args', sa.JSON(), nullable=True),
sa.Column('tags', sa.ARRAY(sa.String()), nullable=True),
sa.Column('scene_type', sa.String(), nullable=True),
sa.Column('band', sa.String(length=64), nullable=False),
sa.Column('traceback', sa.Text(), nullable=True),
sa.PrimaryKeyConstraint('id'),
schema='cube_builder')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'receipts', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('description', sa.Text(), nullable=True),
sa.Column('calories', sa.Float(), nullable=True),
sa.Column('steps',
sa.ARRAY(sa.String()),
server_default='{}',
nullable=False), sa.PrimaryKeyConstraint('id'))
op.create_table(
'ingredients_receipts',
sa.Column('receipt_id', sa.Integer(), nullable=False),
sa.Column('ingredient_id', sa.Integer(), nullable=False),
sa.Column('extra_data', sa.String(length=50), nullable=True),
sa.ForeignKeyConstraint(
['ingredient_id'],
['ingredients.id'],
), sa.ForeignKeyConstraint(
['receipt_id'],
['receipts.id'],
), sa.PrimaryKeyConstraint('receipt_id', 'ingredient_id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('recipes',
sa.Column('recipe_id', sa.BigInteger(), nullable=False),
sa.Column('user_id', sa.BigInteger(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=False),
sa.Column('description', sa.String(length=5000), nullable=True),
sa.Column('tags', sa.ARRAY(sa.String(length=255)), nullable=True),
sa.Column('create_dttm', sa.DateTime(), nullable=False),
sa.Column('update_dttm', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('recipe_id'),
schema='cbschema'
)
op.create_table('steps',
sa.Column('recipe_id', sa.BigInteger(), nullable=False),
sa.Column('step_num', sa.BigInteger(), nullable=False),
sa.Column('info', sa.String(length=5000), nullable=True),
sa.Column('create_dttm', sa.DateTime(), nullable=False),
sa.Column('update_dttm', sa.DateTime(), nullable=True),
sa.ForeignKeyConstraint(['recipe_id'], ['cbschema.recipes.recipe_id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('recipe_id', 'step_num'),
schema='cbschema'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('notification_type',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('message', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'user_notification_feed', sa.Column('id', sa.Integer(),
nullable=False),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('modified', sa.DateTime(), nullable=True),
sa.Column('to_user_id', sa.Integer(), nullable=True),
sa.Column('notification_type_id', sa.Integer(), nullable=True),
sa.Column('from_user_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['from_user_id'], ['user_account.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['notification_type_id'],
['notification_type.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['to_user_id'], ['user_account.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'user_swipes', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('swipe_ids', sa.ARRAY(sa.String()), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['user_account.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.add_column('user_account', sa.Column('lat', sa.Numeric(),
nullable=True))
op.add_column('user_account', sa.Column('long',
sa.Numeric(),
nullable=True))
op.add_column('user_preference',
sa.Column('distance', sa.Integer(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
conn = op.get_bind()
# op.execute("CREATE EXTENSION pg_trgm")
op.create_table(
"writeups",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("author_id", sa.BigInteger(), nullable=False),
sa.Column("title", sa.Text(), nullable=False),
sa.Column("tags", sa.ARRAY(sa.Text()), nullable=False),
sa.Column("content", sa.Text(), nullable=False),
sa.Column(
"search_vector",
sqlalchemy_utils.types.ts_vector.TSVectorType("title",
"content",
weights={
"title": "A",
"content": "B"
}),
nullable=True,
),
sa.ForeignKeyConstraint(["author_id"], ["users.discord_id"]),
sa.PrimaryKeyConstraint("id"),
)
op.create_index(
"writeups_tags_array_idx",
"writeups",
["tags"],
unique=False,
postgresql_using="gin",
)
conn.execute(sql_expressions.statement)
sync_trigger(conn, "writeups", "search_vector", ["title", "content"])
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column("product_variants",
sa.Column("decorations", sa.JSON(), nullable=True))
op.add_column("product_variants",
sa.Column("description", sa.String(), nullable=True))
op.add_column("product_variants",
sa.Column("upcharges", sa.JSON(), nullable=True))
op.add_column("product_variants",
sa.Column("vendor_cost", sa.Float(), nullable=True))
op.add_column(
"product_variants",
sa.Column("vendor_cost_oversize_list",
sa.ARRAY(sa.String()),
nullable=True),
)
op.add_column(
"product_variants",
sa.Column("vendor_cost_oversize_price", sa.Float(), nullable=True))
op.add_column("product_variants",
sa.Column("vendor_item_number", sa.String(), nullable=True))
op.add_column("product_variants",
sa.Column("vendor_name", sa.String(), nullable=True))
op.drop_column("product_variants", "price")
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'Artist', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('genres', sa.ARRAY(sa.String()), nullable=True),
sa.Column('city', sa.String(length=120), nullable=True),
sa.Column('state', sa.String(length=120), nullable=True),
sa.Column('phone', sa.String(length=120), nullable=True),
sa.Column('image_link', sa.String(length=500), nullable=True),
sa.Column('facebook_link', sa.String(length=120), nullable=True),
sa.Column('website_link', sa.String(length=500), nullable=True),
sa.Column('seeking_venue', sa.Boolean(), nullable=True),
sa.Column('seeking_description', sa.String(), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.add_column('Show', sa.Column('artist_id', sa.Integer(), nullable=False))
op.add_column('Show', sa.Column('venue_id', sa.Integer(), nullable=False))
op.alter_column('Show',
'start_time',
existing_type=sa.DATE(),
nullable=False)
op.create_foreign_key(None, 'Show', 'Venue', ['venue_id'], ['id'])
op.create_foreign_key(None, 'Show', 'Artist', ['artist_id'], ['id'])
op.drop_constraint('venue_id', 'Venue', type_='foreignkey')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'activities',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('collection_id', sa.Integer(), nullable=False),
sa.Column('activity_type', sa.String(length=64), nullable=False),
sa.Column('args', sa.JSON(), nullable=True),
sa.Column('tags', sa.ARRAY(sa.String()), nullable=True),
sa.Column('scene_type', sa.String(), nullable=True),
sa.Column('sceneid', sa.String(length=64), nullable=False),
sa.Column('created', sa.TIMESTAMP(timezone=True), nullable=False),
sa.Column('updated', sa.TIMESTAMP(timezone=True), nullable=False),
sa.ForeignKeyConstraint(
['collection_id'], ['bdc.collections.id'],
name=op.f('activities_collection_id_collections_fkey')),
sa.PrimaryKeyConstraint('id', name=op.f('activities_pkey')),
schema='collection_builder')
op.create_table(
'activity_history',
sa.Column('activity_id', sa.Integer(), nullable=False),
sa.Column('task_id', sa.Integer(), nullable=False),
sa.Column('start', sa.DateTime(), nullable=True),
sa.Column('env', sa.JSON(), nullable=True),
sa.Column('created', sa.TIMESTAMP(timezone=True), nullable=False),
sa.Column('updated', sa.TIMESTAMP(timezone=True), nullable=False),
sa.ForeignKeyConstraint(
['activity_id'], ['collection_builder.activities.id'],
name=op.f('activity_history_activity_id_activities_fkey')),
sa.ForeignKeyConstraint(
['task_id'], ['collection_builder.celery_taskmeta.id'],
name=op.f('activity_history_task_id_celery_taskmeta_fkey')),
sa.PrimaryKeyConstraint('activity_id',
'task_id',
name=op.f('activity_history_pkey')),
schema='collection_builder')
