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))
