def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('comhealth_containers', sa.Column('id', sa.Integer(), nullable=False), sa.Column('code', sa.String(length=64), nullable=True), sa.Column('name', sa.String(length=64), nullable=True), sa.Column('desc', sa.Text(), nullable=True), sa.Column('volume', sa.Numeric(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_comhealth_containers_code'), 'comhealth_containers', ['code'], unique=False) op.create_index(op.f('ix_comhealth_containers_name'), 'comhealth_containers', ['name'], unique=False) op.add_column(u'comhealth_tests', sa.Column('container_id', sa.Integer(), nullable=True)) op.create_foreign_key(None, 'comhealth_tests', 'comhealth_containers', ['container_id'], ['id'])
def upgrade(): # Grant # op.create_table( 'grants', sa.Column('id', sa.Integer(), nullable=False), sa.Column('neutral_id', sa.String(length=32), nullable=False), sa.Column('reference', sa.Text(), nullable=False), sa.Column('title', sa.Text(), nullable=False), sa.Column('abstract', sa.Text(), nullable=True), sa.Column('website', sa.Text(), nullable=True), sa.Column('publications', postgresql.ARRAY(sa.Text(), dimensions=1, zero_indexes=True), nullable=True), sa.Column('duration', postgresql.DATERANGE(), nullable=False), sa.Column('status', sa.Enum(*grant_status, name='grant_status'), nullable=False), sa.Column('total_funds', sa.Numeric(24, 2), nullable=True), sa.Column('total_funds_currency', postgresql.ENUM(*grant_currency, name='grant_currency'), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('reference')) op.create_index(op.f('ix_grants_neutral_id'), 'grants', ['neutral_id'], unique=True) # Allocation # op.create_table( 'allocations', sa.Column('id', sa.Integer(), nullable=False), sa.Column('neutral_id', sa.String(length=32), nullable=False), sa.Column('project_id', sa.Integer(), nullable=False), sa.Column('grant_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ('grant_id', ), ['grants.id'], ), sa.ForeignKeyConstraint( ('project_id', ), ['projects.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_allocations_neutral_id'), 'allocations', ['neutral_id'], unique=True)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('category', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=20), nullable=False), sa.Column('description', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_table('role', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=40), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_table( 'user', sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=40), nullable=False), sa.Column('email', sa.String(length=120), nullable=False), sa.Column('password', sa.String(length=80), nullable=False), sa.Column('date_created', sa.DateTime(timezone=6), nullable=False), sa.Column('last_update', sa.DateTime(timezone=6), nullable=True), sa.Column('recovery_code', sa.String(length=200), nullable=True), sa.Column('active', sa.Boolean(), nullable=True), sa.Column('role', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['role'], ['role.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('username')) op.create_table( 'product', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=20), nullable=False), sa.Column('description', sa.Text(), nullable=False), sa.Column('qtd', sa.Integer(), nullable=True), sa.Column('image', sa.Text(), nullable=True), sa.Column('price', sa.Numeric(precision=10, scale=2), nullable=False), sa.Column('date_created', sa.DateTime(timezone=6), nullable=False), sa.Column('last_update', sa.DateTime(timezone=6), nullable=True), sa.Column('status', sa.Integer(), nullable=True), sa.Column('user_created', sa.Integer(), nullable=False), sa.Column('category', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['category'], ['category.id'], ), sa.ForeignKeyConstraint( ['user_created'], ['user.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name'))
def upgrade(): op.create_table('ghybrid_dataframes', sa.Column('id', sa.Integer(), nullable=False), sa.Column('begin', sa.DateTime(), nullable=False), sa.Column('end', sa.DateTime(), nullable=False), sa.Column('res_type', sa.String(length=255), nullable=False), sa.Column('rate', sa.Numeric(precision=20, scale=8), nullable=False), sa.Column('resource_ref', sa.String(length=32), nullable=False), sa.Column('tenant_id', sa.String(length=32), nullable=True), sa.PrimaryKeyConstraint('id'), mysql_charset='utf8', mysql_engine='InnoDB')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'lis_result_child', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created_at', sa.DateTime(), nullable=True), sa.Column('reported_by', sa.Integer(), nullable=False), sa.Column('quant_value', sa.Numeric(), nullable=True), sa.Column('qual_value', sa.String(), nullable=True), sa.Column('revision', sa.Integer(), nullable=False), sa.Column('order_id', sa.Integer(), nullable=True), sa.Column('comment', sa.String(), nullable=True), sa.Column('commenter_id', sa.String(), nullable=True), sa.ForeignKeyConstraint( ['commenter_id'], ['students.id'], ), sa.ForeignKeyConstraint( ['order_id'], ['lis_orders.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'tipo_quantidade', sa.Column('id', sa.Integer(), nullable=False), sa.Column('descricao', sa.String(length=64), nullable=True), sa.Column('sigla', sa.String(length=2), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'produto', sa.Column('id', sa.Integer(), nullable=False), sa.Column('descricao', sa.String(length=64), nullable=True), sa.Column('quantidade', sa.Integer(), nullable=True), sa.Column('tipo_quantidade_id', sa.Integer(), nullable=True), sa.Column('preco', sa.Numeric(precision=10, scale=2), nullable=True), sa.Column('observacao', sa.String(length=256), nullable=True), sa.ForeignKeyConstraint( ['tipo_quantidade_id'], ['tipo_quantidade.id'], ), sa.PrimaryKeyConstraint('id')) op.drop_table('tipo__quantidade')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( "issue_snapshots", sa.Column("id", sa.Integer(), nullable=False), sa.Column("jira_project_id", sa.Integer(), nullable=True), sa.Column("sprint_id", sa.Integer(), nullable=True), sa.Column("issue_id", sa.Integer(), nullable=False), sa.Column("snapshot_date", sa.DateTime(), nullable=False), sa.Column("status", sa.String(), nullable=False), sa.Column("story_points", sa.Numeric(precision=5, scale=2), nullable=False), sa.ForeignKeyConstraint( ["jira_project_id"], ["jira_projects.id"], name=op.f("fk_issue_snapshots_jira_project_id_jira_projects"), ), sa.ForeignKeyConstraint( ["sprint_id"], ["sprints.sprint_id"], name=op.f("fk_issues_sprint_id_sprints"), ), sa.PrimaryKeyConstraint("id", name=op.f("pk_issues")), ) op.execute("DELETE FROM sprints") op.add_column("sprints", sa.Column("last_updated", sa.DateTime(), nullable=False)) op.add_column("sprints", sa.Column("state", sa.String(), nullable=False)) op.add_column("sprints", sa.Column("complete_date", sa.DateTime(), nullable=True)) op.add_column("sprints", sa.Column("jira_sprint_id", sa.Integer(), nullable=True)) op.alter_column("sprints", "end_date", existing_type=postgresql.TIMESTAMP(), nullable=True) op.alter_column("sprints", "start_date", existing_type=postgresql.TIMESTAMP(), nullable=True) op.create_unique_constraint(op.f("uq_sprints_jira_sprint_id"), "sprints", ["jira_sprint_id"])
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('news', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('site_title', sa.UnicodeText(length=200), nullable=True), sa.Column('site_url', sa.String(length=2048), nullable=True), sa.Column('description', sa.UnicodeText(length=2048), nullable=True), sa.Column('vote_up', sa.Integer(), nullable=True), sa.Column('vote_down', sa.Integer(), nullable=True), sa.Column('comments', sa.Integer(), nullable=True), sa.Column('rank', sa.Numeric(precision=12, scale=2), nullable=True), sa.Column('created_at', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint(['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id') ) op.drop_table('pages') op.add_column('comments', sa.Column('news_id', sa.Integer(), nullable=False)) op.drop_column('comments', 'page_id')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### status_table = op.create_table( 'trainee_status', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=20), nullable=True), sa.Column('archived', sa.Integer(), server_default=sa.text(u"'0'"), nullable=True), sa.Column('readonly', sa.Integer(), server_default=sa.text(u"'0'"), nullable=True), sa.Column('country', sa.String(length=20), nullable=False), sa.Column('client_time', sa.Numeric(), nullable=True), sa.Column('created_by', sa.Integer(), nullable=True), sa.Column('date_created', sa.DateTime(), nullable=True), sa.ForeignKeyConstraint( ['created_by'], [u'users.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_trainee_status_created_by'), 'trainee_status', ['created_by'], unique=False) op.add_column(u'trainees', sa.Column('trainee_status', sa.Integer(), nullable=True)) op.create_foreign_key(None, 'trainees', 'trainee_status', ['trainee_status'], ['id']) ## Some seed data: op.bulk_insert(status_table, [{ 'id': 1, 'name': 'Graduate', 'archived': 0, 'readonly': 1, 'country': 'KE' }, { 'id': 2, 'name': 'Dropped', 'archived': 0, 'readonly': 1, 'country': 'KE' }])
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( "account_balance", sa.Column("id", sa.BigInteger(), nullable=False), sa.Column("balance", sa.Numeric(), nullable=False), sa.CheckConstraint( "balance > 0", name=op.f("ch_account_balance__balance_is_positive")), sa.ForeignKeyConstraint(["id"], ["account.id"], name=op.f("fk_account_balance__id_account")), sa.PrimaryKeyConstraint("id", name=op.f("pk_account_balance")), ) op.create_unique_constraint(op.f("uq_user__name_fullname"), "user", ["name", "fullname"]) op.create_unique_constraint(op.f("uq_user__nickname"), "user", ["nickname"]) op.drop_constraint("uq_user_name_fullname", "user", type_="unique") op.drop_constraint("uq_user_nickname", "user", type_="unique")
def upgrade(): op.add_column('mandate', sa.Column('address', sa.Text(), nullable=True)) op.add_column('mandate', sa.Column('college', sa.Integer(), nullable=True)) op.add_column('mandate', sa.Column('constituency', sa.Integer(), nullable=True)) op.add_column('mandate', sa.Column('phone', sa.Text(), nullable=True)) op.add_column('mandate', sa.Column('votes', sa.Integer(), nullable=True)) op.add_column('mandate', sa.Column('votes_percent', sa.Numeric(), nullable=True)) op.add_column('person', sa.Column('blog_url', sa.Text(), nullable=True)) op.add_column('person', sa.Column('education', sa.Text(), nullable=True)) op.add_column('person', sa.Column('email_value', sa.Text(), nullable=True)) op.add_column('person', sa.Column('facebook_url', sa.Text(), nullable=True)) op.add_column('person', sa.Column('twitter_url', sa.Text(), nullable=True)) op.add_column('person', sa.Column('website_url', sa.Text(), nullable=True)) op.add_column('person', sa.Column('year_born', sa.Integer(), nullable=True))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'membership', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=255), nullable=False), sa.Column('price', sa.Numeric(precision=8, asdecimal=False), nullable=True), sa.Column('post_limit', sa.Integer(), nullable=False), sa.Column('active', sa.Boolean(), nullable=False), sa.Column('created_date', sa.DateTime(), nullable=True), sa.Column('updated_date', sa.DateTime(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_membership_created_date'), 'membership', ['created_date'], unique=False) op.create_index(op.f('ix_membership_updated_date'), 'membership', ['updated_date'], unique=False)
def upgrade(): op.create_table( # pylint: disable=no-member "cookies", sa.Column("cookie_id", sa.Integer(), nullable=False), sa.Column("cookie_name", sa.String(length=50), nullable=True), sa.Column("cookie_recipe_url", sa.String(length=255), nullable=True), sa.Column("cookie_sku", sa.String(length=55), nullable=True), sa.Column("quantity", sa.Integer(), nullable=True), sa.Column("unit_cost", sa.Numeric(precision=12, scale=2), nullable=True), sa.PrimaryKeyConstraint("cookie_id"), ) op.create_index( # pylint: disable=no-member op.f("ix_cookies_cookie_name"), # pylint: disable=no-member "cookies", ["cookie_name"], unique=False, )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'clients', sa.Column('id', sa.Integer(), nullable=False), sa.Column('cid', sa.String(length=50), nullable=False), sa.Column('secret', sa.String(length=255), nullable=False), sa.Column('name', sa.String(length=255), nullable=False), sa.Column('application_type', sqlalchemy_utils.types.choice.ChoiceType(ApplicationType, impl=sa.Integer()), nullable=False), sa.Column('active', sa.Boolean(), nullable=False), sa.Column('refresh_token_time', sa.Numeric(precision=8, scale=0), nullable=False), sa.Column('allowed_origin', sa.String(length=255), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('application_type'), sa.UniqueConstraint('name'), sa.UniqueConstraint('secret')) op.create_index(op.f('ix_clients_cid'), 'clients', ['cid'], unique=True)
def upgrade(): op.create_table( 'debit_note_date', sa.Column('id', sa.Integer(), nullable=False), sa.Column('state', sa.Boolean(), nullable=False), sa.Column('date', sa.DateTime(), nullable=False), sa.Column('vas_name', sa.VARCHAR(length=32), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_table( 'debit_note_detail', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('sn', sa.CHAR(length=32), nullable=False), sa.Column('vas_name', sa.VARCHAR(length=32), nullable=False), sa.Column('amount', sa.Numeric(precision=16, scale=2), nullable=False), sa.Column('order_id', sa.VARCHAR(length=64), nullable=False), sa.Column('state', sa.Boolean(), nullable=False), sa.Column('valid', sa.Boolean(), nullable=False), sa.Column('type', sa.Enum(u'PAYMENT', u'REFUND'), nullable=False), sa.Column('created_on', sa.DateTime(), nullable=False), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'comment', sa.Column('comment_id', sa.Integer(), nullable=False), sa.Column('item_id', sa.Integer(), nullable=False), sa.Column('store_id', sa.Integer(), nullable=False), sa.Column('appuser_id', sa.Integer(), nullable=False), sa.Column('rating', sa.Numeric(), nullable=False), sa.Column('content', sa.Text(), 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('comment_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('bad_model', sa.Column('id', sa.Integer(), nullable=False), sa.Column('value', sa.String(length=30), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'setting', sa.Column('id', sa.Integer(), nullable=False), sa.Column('setting_type', sa.String(length=120), nullable=True), sa.Column('key', sa.String(length=120), nullable=True), sa.Column('value', sa.String(length=3000), nullable=True), sa.Column('number', sa.Integer(), nullable=True), sa.Column('active', sa.String(length=1), nullable=True), sa.Column('created', sa.DateTime(), nullable=True), sa.Column('updated', sa.DateTime(), nullable=True), sa.Column('scheduled', sa.DateTime(), nullable=True), sa.Column('user', sa.String(length=10), nullable=True), sa.Column('floaty', sa.Float(), nullable=True), sa.Column('deci', sa.Numeric(precision=2), nullable=True), sa.Column('splitter', sa.String(length=122), nullable=True), sa.Column('zero', sa.String(length=123), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_setting_key'), 'setting', ['key'], unique=False) op.create_index(op.f('ix_setting_setting_type'), 'setting', ['setting_type'], unique=False) op.create_index(op.f('ix_setting_splitter'), 'setting', ['splitter'], unique=False) op.create_table('sub_setting', sa.Column('id', sa.Integer(), nullable=False), sa.Column('created', sa.DateTime(), nullable=True), sa.Column('sub_updated', sa.DateTime(), nullable=True), sa.Column('setting_id', sa.Integer(), nullable=True), sa.Column('flong', sa.String(length=120), nullable=True), sa.Column('boolean', sa.Boolean(), nullable=True), sa.ForeignKeyConstraint( ['setting_id'], ['setting.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_sub_setting_flong'), 'sub_setting', ['flong'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('rating', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date_created', sa.DateTime(), nullable=True), sa.Column('date_modified', sa.DateTime(), nullable=True), sa.Column('deleted', sa.Integer(), nullable=True), sa.Column('point', sa.Numeric(precision=2, scale=1), nullable=True), sa.Column('object_id', sa.Integer(), nullable=True), sa.Column('question_id', sa.Integer(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('modified_user_id', sa.Integer(), nullable=True), sa.Column('created_user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['created_user_id'], ['user.id'], ), sa.ForeignKeyConstraint(['modified_user_id'], ['user.id'], ), sa.ForeignKeyConstraint(['question_id'], ['question.id'], ), sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id') )
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table( 'cheque_record', sa.Column('id', sa.BigInteger(), nullable=False), sa.Column('tx_id', sa.BigInteger(), nullable=False), sa.Column('sn', sa.CHAR(length=32), nullable=False), sa.Column('type', sa.Enum('INSTANT', 'LAZY'), nullable=False), sa.Column('signature', sa.CHAR(length=32), nullable=True), sa.Column('from_id', sa.Integer(), nullable=False), sa.Column('to_id', sa.Integer(), nullable=True), sa.Column('amount', sa.Numeric(precision=16, scale=2), nullable=False), sa.Column('valid_minutes', sa.Integer(), nullable=False), sa.Column('client_notify_url', sa.VARCHAR(length=128), nullable=True), sa.Column('created_on', sa.DateTime(), nullable=False), sa.Column('updated_on', sa.DateTime(), nullable=False), sa.ForeignKeyConstraint( ['tx_id'], ['transaction.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### op.create_table('role', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(length=80), nullable=False), sa.Column('description', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name') ) op.create_table('user', sa.Column('id', sa.Integer(), nullable=False), sa.Column('yodlee_user_id', sa.Integer(), nullable=True), sa.Column('email', sa.String(length=255), nullable=False), sa.Column('_username', sa.String(length=255), nullable=True), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('_username'), sa.UniqueConstraint('email') ) op.create_table('recurring_transaction', sa.Column('id', sa.Integer(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id') ) op.create_table('roles_users', sa.Column('user_id', sa.Integer(), nullable=True), sa.Column('role_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['role_id'], ['role.id'], ), sa.ForeignKeyConstraint(['user_id'], ['user.id'], ) ) op.create_table('transaction', sa.Column('id', sa.Integer(), nullable=False), sa.Column('date', sa.DateTime(), nullable=False), sa.Column('description', sa.Text(), nullable=False), sa.Column('account_id', sa.Integer(), nullable=False), sa.Column('amount', sa.Numeric(precision=10, scale=2), nullable=False), sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('yodlee_transaction_id', sa.Integer(), nullable=False), sa.Column('recurring_transaction_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint(['recurring_transaction_id'], ['recurring_transaction.id'], ), sa.ForeignKeyConstraint(['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id') )
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.add_column('evaluations', sa.Column('best_value', sa.Numeric(), nullable=True), schema='train_results') op.add_column('evaluations', sa.Column('worst_value', sa.Numeric(), nullable=True), schema='train_results') op.add_column('evaluations', sa.Column('stochastic_value', sa.Numeric(), nullable=True), schema='train_results') op.add_column('evaluations', sa.Column('num_sort_trials', sa.Integer(), nullable=True), schema='train_results') op.add_column('evaluations', sa.Column('standard_deviation', sa.Numeric(), nullable=True), schema='train_results') op.add_column('evaluations', sa.Column('best_value', sa.Numeric(), nullable=True), schema='test_results') op.add_column('evaluations', sa.Column('worst_value', sa.Numeric(), nullable=True), schema='test_results') op.add_column('evaluations', sa.Column('stochastic_value', sa.Numeric(), nullable=True), schema='test_results') op.add_column('evaluations', sa.Column('num_sort_trials', sa.Integer(), nullable=True), schema='test_results') op.add_column('evaluations', sa.Column('standard_deviation', sa.Numeric(), nullable=True), schema='test_results') op.execute( "update train_results.evaluations set stochastic_value = value, num_sort_trials = 1" ) op.execute( "update test_results.evaluations set stochastic_value = value, num_sort_trials = 1" ) op.drop_column('evaluations', 'value', schema='train_results') op.drop_column('evaluations', 'value', schema='test_results')
def upgrade(): op.create_table( "statistics", sa.Column("account_id", sa.Integer, primary_key=True), sa.Column("battles_on_stunning_vehicles", sa.Integer), sa.Column("spotted", sa.Integer), sa.Column("avg_damage_blocked", sa.Float), sa.Column("direct_hits_received", sa.Integer), sa.Column("explosion_hits", sa.Integer), sa.Column("piercings", sa.Integer), sa.Column("xp", sa.Integer), sa.Column("avg_damage_assisted", sa.Float), sa.Column("dropped_capture_points", sa.Integer), sa.Column("piercings_received", sa.Integer), sa.Column("hits_percents", sa.Integer), sa.Column("draws", sa.Integer), sa.Column("battles", sa.Integer), sa.Column("damage_received", sa.Integer), sa.Column("survived_battles", sa.Integer), sa.Column("avg_damage_assisted_track", sa.Float), sa.Column("frags", sa.Integer), sa.Column("stun_number", sa.Integer), sa.Column("avg_damage_assisted_radio", sa.Float), sa.Column("capture_points", sa.Integer), sa.Column("stun_assisted_damage", sa.Integer), sa.Column("hits", sa.Integer), sa.Column("battle_avg_xp", sa.Integer), sa.Column("wins", sa.Integer), sa.Column("losses", sa.Integer), sa.Column("damage_dealt", sa.Integer), sa.Column("no_damage_direct_hits_received", sa.Integer), sa.Column("shots", sa.Integer), sa.Column("explosion_hits_received", sa.Integer), sa.Column("tanking_factor", sa.Numeric(2)), sa.Column("trees_cut", sa.Integer), sa.Column("last_battle_time", sa.DateTime(timezone=True)), sa.Column("updated_at", sa.DateTime(timezone=True), primary_key=True), sa.Column("global_rating", sa.Integer), sa.Column("clan_id", sa.Integer), sa.Column("nickname", sa.String), sa.Column("logout_at", sa.DateTime(timezone=True)), )
def setUp(self): super(ModelsMigrationSyncMixin, self).setUp() self.metadata = sa.MetaData() self.metadata_migrations = sa.MetaData() sa.Table( 'testtbl', self.metadata_migrations, sa.Column('id', sa.Integer, primary_key=True), sa.Column('spam', sa.String(10), nullable=False), sa.Column('eggs', sa.DateTime), sa.Column('foo', sa.Boolean, server_default=sa.sql.expression.true()), sa.Column('bool_wo_default', sa.Boolean), sa.Column('bar', sa.Numeric(10, 5)), sa.UniqueConstraint('spam', 'eggs', name='uniq_cons'), ) BASE = sa_decl.declarative_base(metadata=self.metadata) class TestModel(BASE): __tablename__ = 'testtbl' __table_args__ = (sa.UniqueConstraint('spam', 'eggs', name='uniq_cons'), ) id = sa.Column('id', sa.Integer, primary_key=True) spam = sa.Column('spam', sa.String(10), nullable=False) eggs = sa.Column('eggs', sa.DateTime) foo = sa.Column('foo', sa.Boolean, server_default=sa.sql.expression.true()) bool_wo_default = sa.Column('bool_wo_default', sa.Boolean) bar = sa.Column('bar', sa.Numeric(10, 5)) class ModelThatShouldNotBeCompared(BASE): __tablename__ = 'testtbl2' id = sa.Column('id', sa.Integer, primary_key=True) spam = sa.Column('spam', sa.String(10), nullable=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('ingredients', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.Text(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('name')) op.create_table('recipes', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.Text(), nullable=False), sa.Column('description', sa.Text(), nullable=True), sa.Column('prep_time', sa.Integer(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('revoked_jwt_tokens', sa.Column('id', sa.Integer(), nullable=False), sa.Column('jti', sa.String(length=120), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table('units', sa.Column('id', sa.Integer(), nullable=False), sa.Column('description', sa.Text(), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_table( 'users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=100), nullable=False), sa.Column('email', sa.String(length=100), nullable=True), sa.Column('password', sa.String(length=120), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('email'), sa.UniqueConstraint('username')) op.create_table( 'recipes_ingredients', sa.Column('id', sa.Integer(), nullable=False), sa.Column('recipe_id', sa.Integer(), nullable=False), sa.Column('ingredient_id', sa.Integer(), nullable=False), sa.Column('unit_id', sa.Integer(), nullable=True), sa.Column('quantity', sa.Numeric(), nullable=False), sa.ForeignKeyConstraint( ['ingredient_id'], ['ingredients.id'], ), sa.ForeignKeyConstraint( ['recipe_id'], ['recipes.id'], ), sa.ForeignKeyConstraint( ['unit_id'], ['units.id'], ), sa.PrimaryKeyConstraint('id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('food_categories', sa.Column('id', sa.String(), nullable=False), sa.Column('title', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id')) op.create_table('users', sa.Column('id', sa.Integer(), nullable=False), sa.Column('name', sa.String(), nullable=False), sa.Column('mail', sa.String(), nullable=False), sa.Column('_password_hash', sa.String(), nullable=False), sa.Column('address', sa.String(), nullable=False), sa.Column('phone', sa.String(), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('mail')) op.create_table( 'meals', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(), nullable=False), sa.Column('price', sa.Numeric(), nullable=False), sa.Column('description', sa.String(), nullable=True), sa.Column('picture', sa.String(), nullable=True), sa.Column('category_id', sa.String(), nullable=True), sa.ForeignKeyConstraint( ['category_id'], ['food_categories.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('orders', sa.Column('id', sa.Integer(), nullable=False), sa.Column('data', sa.DateTime(), nullable=False), sa.Column('user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['users.id'], ), sa.PrimaryKeyConstraint('id')) op.create_table('order_meal_associations', sa.Column('meals_id', sa.Integer(), nullable=False), sa.Column('order_id', sa.Integer(), nullable=False), sa.Column('amount', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['meals_id'], ['meals.id'], ), sa.ForeignKeyConstraint( ['order_id'], ['orders.id'], ), sa.PrimaryKeyConstraint('meals_id', 'order_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('categoria', sa.Column('id', sa.Integer(), nullable=False), sa.Column('nombre', sa.String(length=64), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_categoria_nombre'), 'categoria', ['nombre'], unique=False) op.create_table( 'user', sa.Column('id', sa.Integer(), nullable=False), sa.Column('username', sa.String(length=64), nullable=True), sa.Column('email', sa.String(length=120), nullable=True), sa.Column('password_hash', sa.String(length=120), nullable=True), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=True) op.create_index(op.f('ix_user_username'), 'user', ['username'], unique=True) op.create_table('post', sa.Column('id', sa.Integer(), nullable=False), sa.Column('body', sa.String(length=140), nullable=True), sa.Column('timestamp', sa.DateTime(), nullable=True), sa.Column('user_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['user_id'], ['user.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_post_timestamp'), 'post', ['timestamp'], unique=False) op.create_table( 'producto', sa.Column('id', sa.Integer(), nullable=False), sa.Column('nombre', sa.String(length=100), nullable=True), sa.Column('stock', sa.Integer(), nullable=True), sa.Column('precio', sa.Numeric(precision=10, scale=2), nullable=True), sa.Column('categoria_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['categoria_id'], ['categoria.id'], ), sa.PrimaryKeyConstraint('id')) op.create_index(op.f('ix_producto_nombre'), 'producto', ['nombre'], unique=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'menuitem', sa.Column('item_id', sa.Integer(), nullable=False), sa.Column('name', sa.VARCHAR(length=30), nullable=False), sa.Column('category', sa.VARCHAR(length=15), nullable=False), sa.Column('description', sa.TEXT(), nullable=False), sa.Column('price', sa.Numeric(precision=5, scale=2), nullable=False), sa.Column('restaurantid', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['restaurantid'], ['restaurant.restaurantid'], ), sa.PrimaryKeyConstraint('item_id')) op.create_table( 'rating', sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('date', sa.Date(), nullable=False), sa.Column('price', sa.Integer(), nullable=False), sa.Column('food', sa.Integer(), nullable=False), sa.Column('mood', sa.Integer(), nullable=False), sa.Column('staff', sa.Integer(), nullable=False), sa.Column('comments', sa.TEXT(), nullable=True), sa.Column('restaurantid', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['restaurantid'], ['restaurant.restaurantid'], ), sa.ForeignKeyConstraint( ['user_id'], ['rater.user_id'], ), sa.PrimaryKeyConstraint('user_id', 'date')) op.create_table( 'ratingitem', sa.Column('user_id', sa.Integer(), nullable=False), sa.Column('date', sa.Date(), nullable=False), sa.Column('item_id', sa.Integer(), nullable=False), sa.Column('rating', sa.Integer(), nullable=False), sa.Column('comment', sa.Text(), nullable=False), sa.ForeignKeyConstraint( ['item_id'], ['menuitem.item_id'], ), sa.ForeignKeyConstraint( ['user_id'], ['rater.user_id'], ), sa.PrimaryKeyConstraint('user_id', 'date', 'item_id'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'exchange', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(length=255), nullable=False), sa.Column('exchange_symbol', sa.String(length=255), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('exchange_symbol', name='_exch_symbol_uc')) op.create_table('industry_sector', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(length=255), nullable=False), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('title', name='_sector_title_uc')) op.create_table( 'stock', sa.Column('id', sa.Integer(), nullable=False), sa.Column('title', sa.String(length=255), nullable=False), sa.Column('ticker_symbol', sa.String(length=255), nullable=False), sa.Column('exchange_id', sa.Integer(), nullable=False), sa.Column('industry_sector_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['exchange_id'], ['exchange.id'], ), sa.ForeignKeyConstraint( ['industry_sector_id'], ['industry_sector.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('exchange_id', 'ticker_symbol', name='_stock_eid_symbol_uc')) op.create_table( 'stock_yearly_price', sa.Column('id', sa.Integer(), nullable=False), sa.Column('close_at', sa.Date(), nullable=False), sa.Column('close_price', sa.Numeric(precision=12, scale=4), nullable=False), sa.Column('stock_id', sa.Integer(), nullable=False), sa.ForeignKeyConstraint( ['stock_id'], ['stock.id'], ), sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('stock_id', 'close_at', name='_syp_sid_price_uc'))
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table('category', sa.Column('CategoryID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=10), nullable=False), sa.PrimaryKeyConstraint('CategoryID'), sa.UniqueConstraint('Name')) op.create_table('ordertype', sa.Column('OrderTypeID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=15), nullable=False), sa.PrimaryKeyConstraint('OrderTypeID'), sa.UniqueConstraint('Name')) op.create_table('usertypes', sa.Column('TypeID', sa.Integer(), nullable=False), sa.Column('Name', sa.String(length=10), nullable=False), sa.PrimaryKeyConstraint('TypeID'), sa.UniqueConstraint('Name')) op.create_table( 'product', sa.Column('ProductID', sa.Integer(), nullable=False), sa.Column('CategoryID', sa.Integer(), nullable=True), sa.Column('Name', sa.String(length=100), nullable=False), sa.Column('Price', sa.Numeric(precision=18, scale=2), nullable=False), sa.Column('Description', sa.String(length=300), nullable=True), sa.Column('ImageURL', sa.String(length=500), nullable=True), sa.Column('Available', sa.Boolean(), nullable=False), sa.ForeignKeyConstraint( ['CategoryID'], ['category.CategoryID'], ), sa.PrimaryKeyConstraint('ProductID')) op.add_column('user', sa.Column('Name', sa.String(length=100), nullable=False)) op.add_column('user', sa.Column('Password', sa.String(length=25), nullable=False)) op.add_column('user', sa.Column('TypeID', sa.Integer(), nullable=False)) op.add_column('user', sa.Column('UserID', sa.Integer(), nullable=False)) op.drop_constraint('user_email_key', 'user', type_='unique') op.create_unique_constraint(None, 'user', ['Name']) op.create_foreign_key(None, 'user', 'usertypes', ['TypeID'], ['TypeID']) op.drop_column('user', 'password') op.drop_column('user', 'id') op.drop_column('user', 'email') op.drop_column('user', 'is_active')
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### op.create_table( 'invoice_payments', sa.Column('id', sa.Integer(), nullable=False), sa.Column('amount', sa.Numeric(precision=10, scale=2), nullable=True), sa.Column('payment_date', sa.DateTime(), server_default=sa.text(u'CURRENT_TIMESTAMP'), nullable=True), sa.Column('invoice_id', sa.Integer(), nullable=True), sa.ForeignKeyConstraint( ['invoice_id'], [u'invoices.id'], ), sa.PrimaryKeyConstraint('id')) op.add_column( u'invoices', sa.Column('status', sa.Integer(), server_default=sa.text(u'1'), nullable=False))