def upgrade(): op.create_table('event', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date', sa.Date(), nullable=False), sa.Column('price', postgresql.MONEY(), nullable=False), sa.Column('name', sa.String(length=128), nullable=False), sa.Column('created_on', sa.DateTime(), nullable=False), sa.Column('modified_on', sa.DateTime(), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_event_date'), 'event', ['date'], unique=False) op.create_index(op.f('ix_event_name'), 'event', ['name'], unique=False) conn = op.get_bind() date = str(datetime.now()) conn.execute(""" insert into event (name, date, price, created_on, modified_on) values ( 'Godsmack Concert', '09-25-2020', 129.99, '{0}', '{0}' ); """.format(date))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('individual_contributor', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('city', sa.String(length=30), nullable=True), sa.Column('state', sa.String(length=2), nullable=True), sa.Column('zip', sa.String(length=9), nullable=True), sa.Column('employer', sa.String(length=38), nullable=True), sa.Column('occupation', sa.String(length=38), nullable=True), sa.PrimaryKeyConstraint('id') ) op.create_table('individual_contribution', sa.Column('id', sa.Integer(), nullable=False), sa.Column('committee_id', sa.Integer(), nullable=False), sa.Column('contributor_id', sa.Integer(), nullable=False), sa.Column('amendment_indicator', postgresql.ENUM('N', 'A', 'T', name='amendment_indicator'), nullable=True), sa.Column('report_type', sa.String(length=3), nullable=True), sa.Column('primary_general_indicator', sa.String(length=5), nullable=True), sa.Column('fec_image_ref', sa.String(length=18), nullable=True), sa.Column('transaction_type', sa.String(length=3), nullable=True), sa.Column('entity_type', sa.String(length=3), nullable=True), sa.Column('date', sa.Date(), nullable=True), sa.Column('amount', postgresql.MONEY(), nullable=True), sa.Column('committee_fec_id', sa.String(length=9), nullable=True), sa.Column('other_fec_id', sa.String(length=9), nullable=True), sa.ForeignKeyConstraint(['committee_id'], ['committee.id'], ), sa.ForeignKeyConstraint(['contributor_id'], ['individual_contributor.id'], ), sa.PrimaryKeyConstraint('id') )
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('individual_contribution', 'amount', existing_type=sa.Numeric(precision=18, scale=2), type_=postgresql.MONEY(), existing_nullable=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'books', sa.Column('price', postgresql.MONEY(), autoincrement=False, nullable=True))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column( 'price', sa.Column('reported', postgresql.TIMESTAMP(timezone=True), autoincrement=False, nullable=True)) op.add_column( 'price', sa.Column('price', postgresql.MONEY(), autoincrement=False, nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'product', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.Text(), nullable=False), sa.Column('author', sa.Text(), nullable=False), sa.Column('category', sa.Text(), nullable=False), sa.Column('description', sa.Text(), nullable=True), sa.Column('image', postgresql.BYTEA(), nullable=True), sa.Column('price', postgresql.MONEY(), nullable=False), sa.Column('stock', sa.Integer(), server_default='0', nullable=False), sa.Column('rating', sa.Float(), nullable=True), sa.Column('reviews', sa.Integer(), server_default='0', nullable=False), sa.Column('created_at', sa.DateTime(timezone=True), server_default=sa.text('now()'), nullable=False), sa.Column('updated_at', sa.DateTime(timezone=True), server_default=sa.text('now()'), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_product_id'), 'product', ['id'], unique=False) op.create_index(op.f('ix_product_name'), 'product', ['name'], unique=True)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('diet', sa.Column('id_diet', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('diet_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_diet', name='diet_pkey'), postgresql_ignore_search_path=False) op.create_table('resident', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('gender', sa.VARCHAR(length=8), autoincrement=False, nullable=True), sa.Column('surname', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('patronymic', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('room_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('birthday', sa.DATE(), autoincrement=False, nullable=True), sa.Column('place_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('start_day', sa.DATE(), autoincrement=False, nullable=True), sa.Column('final_day', sa.DATE(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['place_number'], ['canteen_place.canteen_number'], name='place_number'), sa.ForeignKeyConstraint(['room_number'], ['living_room.room_number'], name='resident_room_number_fkey'), sa.PrimaryKeyConstraint('id_resident', name='resident_pkey'), postgresql_ignore_search_path=False) op.create_table( 'appointment', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_procedure', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_procedure'], ['medical_procedure.id_procedure'], name='appointment_id_procedure_fkey'), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='appointment_id_resident_fkey')) op.create_table('infrastructure', sa.Column('rent_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('description', sa.VARCHAR(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('rent_number', name='infrastructure_pkey'), postgresql_ignore_search_path=False) op.create_table('item', sa.Column('id_item', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('item_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_item', name='item_pkey'), postgresql_ignore_search_path=False) op.create_table( 'income', sa.Column('operation_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('operation_time', sa.DATE(), autoincrement=False, nullable=True), sa.Column('sum', postgresql.MONEY(), autoincrement=False, nullable=True), sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='id_resident'), sa.PrimaryKeyConstraint('operation_number', name='income_pkey')) op.create_table('living_room', sa.Column('room_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('floor', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('room_class', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('room_number', name='living_room_pkey'), postgresql_ignore_search_path=False) op.create_table( 'warehouse', sa.Column('id_warehouse', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('number', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_item', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_item'], ['item.id_item'], name='warehouse_id_item_fkey'), sa.PrimaryKeyConstraint('id_warehouse', name='warehouse_pkey')) op.create_table( 'consultation', sa.Column('id_consultation', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('consultation_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='consultation_id_resident_fkey'), sa.PrimaryKeyConstraint('id_consultation', name='consultation_pkey')) op.create_table('sport_group', sa.Column('id_group', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('group_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_group', name='sport_group_pkey'), postgresql_ignore_search_path=False) op.create_table('canteen_place', sa.Column('canteen_number', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('id_diet', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_diet'], ['diet.id_diet'], name='canteen_place_id_diet_fkey'), sa.PrimaryKeyConstraint('canteen_number', name='canteen_place_pkey'), postgresql_ignore_search_path=False) op.create_table( 'medical_procedure', sa.Column('id_procedure', sa.VARCHAR(length=40), autoincrement=False, nullable=False), sa.Column('procedure_name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('id_procedure', name='medical_procedure_pkey')) op.create_table( 'timetable', sa.Column('week_day', sa.VARCHAR(), autoincrement=False, nullable=False), sa.Column('start_time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('finish_time', postgresql.TIME(), autoincrement=False, nullable=True), sa.Column('staff_cadr', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['staff_cadr'], ['staff.staff_cadr'], name='staff_cadr'), sa.PrimaryKeyConstraint('week_day', name='timetable_pkey')) op.create_table( 'place_rent', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('rent_number', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='id_resident'), sa.ForeignKeyConstraint(['rent_number'], ['infrastructure.rent_number'], name='rent_number')) op.create_table( 'staff', sa.Column('staff_cadr', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('surname', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('name', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('patronymic', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('position', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('hours', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('salary', postgresql.MONEY(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('staff_cadr', name='staff_pkey')) op.create_table( 'sport_membership', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_group', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_group'], ['sport_group.id_group'], name='sport_membership_id_group_fkey'), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='sport_membership_id_resident_fkey')) op.create_table( 'parking', sa.Column('id_place', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('car_number', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['car_number'], ['car.car_number'], name='parking_car_number_fkey'), sa.PrimaryKeyConstraint('id_place', name='parking_pkey')) op.create_table( 'expenses', sa.Column('operation_num', sa.INTEGER(), autoincrement=False, nullable=False), sa.Column('operation_data', sa.DATE(), autoincrement=False, nullable=True), sa.Column('operation_sum', postgresql.MONEY(), autoincrement=False, nullable=True), sa.Column('description', sa.VARCHAR(), autoincrement=False, nullable=True), sa.PrimaryKeyConstraint('operation_num', name='expenses_pkey')) op.create_table( 'car', sa.Column('car_number', sa.VARCHAR(length=40), autoincrement=False, nullable=False), sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('model', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.Column('color', sa.VARCHAR(length=40), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='car_id_resident_fkey'), sa.PrimaryKeyConstraint('car_number', name='car_pkey')) op.create_table( 'item_rent', sa.Column('id_resident', sa.INTEGER(), autoincrement=False, nullable=True), sa.Column('id_item', sa.INTEGER(), autoincrement=False, nullable=True), sa.ForeignKeyConstraint(['id_item'], ['item.id_item'], name='item_rent_id_item_fkey'), sa.ForeignKeyConstraint(['id_resident'], ['resident.id_resident'], name='item_rent_id_resident_fkey'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('access', sa.Column('access_id', sa.Integer(), nullable=False), sa.PrimaryKeyConstraint('access_id')) op.create_table('badge', sa.Column('badge_id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=True), sa.Column('image_id', sa.BigInteger(), nullable=True), sa.PrimaryKeyConstraint('badge_id')) op.create_table('chain', sa.Column('chain_id', sa.Integer(), nullable=False), sa.PrimaryKeyConstraint('chain_id')) op.create_table('image', sa.Column('image_id', sa.Integer(), nullable=False), sa.Column('fspath', sa.String(), nullable=True), sa.Column('imgtype', sa.String(), nullable=True), sa.Column('width', sa.Integer(), nullable=True), sa.Column('height', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('image_id'), sa.UniqueConstraint('fspath')) op.create_table('location', sa.Column('location_id', sa.Integer(), nullable=False), sa.Column('lat', sa.Float(), nullable=True), sa.Column('long', sa.Float(), nullable=True), sa.PrimaryKeyConstraint('location_id')) op.create_table( 'appuser', sa.Column('appuser_id', sa.Integer(), nullable=False), sa.Column('username', sa.String(), nullable=True), sa.Column('password', sa.String(), nullable=True), sa.Column('home', sa.Integer(), nullable=True), sa.Column('karma', sa.Integer(), nullable=True), sa.Column('avatar', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['avatar'], ['image.image_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.ForeignKeyConstraint(['home'], ['location.location_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.PrimaryKeyConstraint('appuser_id'), sa.UniqueConstraint('username')) op.create_table( 'item', sa.Column('item_id', sa.Integer(), nullable=False), sa.Column('code', sa.String(), nullable=False), sa.Column('name', sa.String(), nullable=False), sa.Column('brand', sa.String(), nullable=True), sa.Column('weight', sa.Numeric(), nullable=False), sa.Column('weight_unit', sa.String(), server_default=FetchedValue(), nullable=True), sa.Column('image_id', sa.Integer(), nullable=True), sa.Column('description', sa.Text(), nullable=False), sa.ForeignKeyConstraint(['image_id'], ['image.image_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.PrimaryKeyConstraint('item_id'), sa.UniqueConstraint('code')) op.create_table( 'store', sa.Column('store_id', sa.Integer(), nullable=False), sa.Column('location_id', sa.Integer(), nullable=True), sa.Column('chain_id', sa.Integer(), nullable=True), sa.Column('name', sa.String(), nullable=True), sa.Column('image_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['chain_id'], ['chain.chain_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.ForeignKeyConstraint(['image_id'], ['image.image_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.ForeignKeyConstraint(['location_id'], ['location.location_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.PrimaryKeyConstraint('store_id')) op.create_table( 'badge_appuser', sa.Column('badge_id', sa.Integer(), nullable=False), sa.Column('appuser_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['appuser_id'], ['appuser.appuser_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.ForeignKeyConstraint(['badge_id'], ['badge.badge_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.PrimaryKeyConstraint('badge_id', 'appuser_id')) op.create_table( 'comment', sa.Column('object_id', sa.Integer(), nullable=False), sa.Column('appuser_id', sa.Integer(), nullable=False), sa.Column('rating', sa.Numeric(), nullable=True), sa.Column('content', sa.Text(), nullable=True), sa.Column('type', sa.Integer(), nullable=False), sa.CheckConstraint('(content IS NOT NULL) OR (rating IS NOT NULL)'), sa.ForeignKeyConstraint(['appuser_id'], ['appuser.appuser_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.PrimaryKeyConstraint('object_id', 'type')) op.create_table( 'list', sa.Column('list_id', sa.Integer(), nullable=False), sa.Column('owner', sa.Integer(), nullable=True), sa.Column('access_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['access_id'], ['access.access_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.ForeignKeyConstraint(['owner'], ['appuser.appuser_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.PrimaryKeyConstraint('list_id')) op.create_table( 'price', sa.Column('price_id', sa.Integer(), nullable=False), sa.Column('currency', sa.String(length=3), nullable=True), sa.Column('item_id', sa.Integer(), nullable=True), sa.Column('appuser_id', sa.Integer(), nullable=True), sa.Column('price', postgresql.MONEY(), nullable=True), sa.Column('reported', sa.DateTime(timezone=True), nullable=True), sa.Column('store_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['appuser_id'], ['appuser.appuser_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.ForeignKeyConstraint(['item_id'], ['item.item_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.ForeignKeyConstraint(['store_id'], ['store.store_id'], onupdate='CASCADE', ondelete='RESTRICT'), sa.PrimaryKeyConstraint('price_id')) op.create_table( 'list_item', sa.Column('item_id', sa.Integer(), nullable=False), sa.Column('list_id', sa.Integer(), nullable=False), sa.Column('quantity', sa.Integer(), server_default=FetchedValue(), nullable=True), sa.ForeignKeyConstraint(['item_id'], ['item.item_id'], onupdate='CASCADE', ondelete='RESTRICT', name='list_item_item_id_fkey'), sa.ForeignKeyConstraint(['list_id'], ['list.list_id'], onupdate='CASCADE', ondelete='RESTRICT', name='list_item_list_id_fkey'), sa.PrimaryKeyConstraint('item_id', 'list_id'))
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.alter_column('product', 'price', existing_type=sa.Numeric(precision=10, scale=2), type_=postgresql.MONEY(), existing_nullable=False)