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)
Esempio n. 3
0
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'))
Esempio n. 4
0
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'))
Esempio n. 6
0
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')
Esempio n. 7
0
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')
Esempio n. 9
0
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'
    }])
Esempio n. 10
0
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")
Esempio n. 11
0
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)
Esempio n. 13
0
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,
    )
Esempio n. 14
0
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'))
Esempio n. 16
0
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)
Esempio n. 18
0
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)),
    )
Esempio n. 23
0
    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)
Esempio n. 24
0
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'))
Esempio n. 25
0
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)
Esempio n. 27
0
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'))
Esempio n. 28
0
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'))
Esempio n. 29
0
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')
Esempio n. 30
0
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))