Python sqlalchemy.PrimaryKeyConstraint() Examples
The following are 30
code examples of sqlalchemy.PrimaryKeyConstraint().
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example.
You may also want to check out all available functions/classes of the module
sqlalchemy
, or try the search function
.
.
Example #1
| Source File: 20bcb4b2673c_.py From gitlab-tools with GNU General Public License v3.0 | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('task_result',
sa.Column('updated', sa.DateTime(), nullable=True),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('pull_mirror_id', sa.Integer(), nullable=True),
sa.Column('push_mirror_id', sa.Integer(), nullable=True),
sa.Column('task_id', sa.String(length=155), nullable=True),
sa.Column('status', sa.String(length=50), nullable=True),
sa.Column('task_name', sa.String(length=255), nullable=True),
sa.Column('invoked_by', sa.Integer(), nullable=True),
sa.Column('result', sa.PickleType(), nullable=True),
sa.Column('date_done', sa.DateTime(), nullable=True),
sa.Column('traceback', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['pull_mirror_id'], ['pull_mirror.id'], ),
sa.ForeignKeyConstraint(['push_mirror_id'], ['push_mirror.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('task_id')
)
op.create_index(op.f('ix_task_result_pull_mirror_id'), 'task_result', ['pull_mirror_id'], unique=False)
op.create_index(op.f('ix_task_result_push_mirror_id'), 'task_result', ['push_mirror_id'], unique=False)
# ### end Alembic commands ###
Example #2
| Source File: d295f8dcfa64_initial_revision.py From maubot with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('client',
sa.Column('id', sa.String(length=255), nullable=False),
sa.Column('homeserver', sa.String(length=255), nullable=False),
sa.Column('access_token', sa.Text(), nullable=False),
sa.Column('enabled', sa.Boolean(), nullable=False),
sa.Column('next_batch', sa.String(length=255), nullable=False),
sa.Column('filter_id', sa.String(length=255), nullable=False),
sa.Column('sync', sa.Boolean(), nullable=False),
sa.Column('autojoin', sa.Boolean(), nullable=False),
sa.Column('displayname', sa.String(length=255), nullable=False),
sa.Column('avatar_url', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id')
)
op.create_table('plugin',
sa.Column('id', sa.String(length=255), nullable=False),
sa.Column('type', sa.String(length=255), nullable=False),
sa.Column('enabled', sa.Boolean(), nullable=False),
sa.Column('primary_user', sa.String(length=255), nullable=False),
sa.Column('config', sa.Text(), nullable=False),
sa.ForeignKeyConstraint(['primary_user'], ['client.id'], onupdate='CASCADE', ondelete='RESTRICT'),
sa.PrimaryKeyConstraint('id')
)
# ### end Alembic commands ###
Example #3
| Source File: 2020_052419_f680032cc361_.py From app with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('fido',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('credential_id', sa.String(), nullable=False),
sa.Column('uuid', sa.String(), nullable=False),
sa.Column('public_key', sa.String(), nullable=False),
sa.Column('sign_count', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=128), nullable=False),
sa.ForeignKeyConstraint(['uuid'], ['users.fido_uuid'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('public_key')
)
op.create_index(op.f('ix_fido_credential_id'), 'fido', ['credential_id'], unique=True)
op.drop_constraint('users_fido_credential_id_key', 'users', type_='unique')
op.drop_constraint('users_fido_pk_key', 'users', type_='unique')
op.drop_column('users', 'fido_sign_count')
op.drop_column('users', 'fido_pk')
op.drop_column('users', 'fido_credential_id')
# ### end Alembic commands ###
Example #4
| Source File: fa75d46a7f11_add_port_pair_group_params.py From networking-sfc with Apache License 2.0 | 6 votes |
|
def upgrade():
op.create_table('sfc_port_pair_group_params',
sa.Column('keyword', sa.String(length=255),
nullable=False),
sa.Column('value', sa.String(length=255),
nullable=True),
sa.Column('pair_group_id', sa.String(length=36),
nullable=False),
sa.ForeignKeyConstraint(['pair_group_id'],
['sfc_port_pair_groups.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('keyword', 'pair_group_id'),
mysql_engine='InnoDB'
)
op.add_column('sfc_port_chains', sa.Column('chain_id',
sa.Integer(), nullable=False))
op.create_unique_constraint(None, 'sfc_port_chains', ['chain_id'])
op.add_column('sfc_port_pair_groups', sa.Column('group_id',
sa.Integer(), nullable=False))
op.create_unique_constraint(None, 'sfc_port_pair_groups', ['group_id'])
Example #5
| Source File: 875c52a485_.py From comport with BSD 3-Clause "New" or "Revised" License | 6 votes |
|
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('months',
sa.Column('id', sa.INTEGER(), server_default=sa.text("nextval('months_id_seq'::regclass)"), nullable=False),
sa.Column('month', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('year', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('department_id', sa.INTEGER(), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['department_id'], ['departments.id'], name='months_department_id_fkey'),
sa.PrimaryKeyConstraint('id', name='months_pkey'),
postgresql_ignore_search_path=False
)
op.create_table('serviceTypes',
sa.Column('id', sa.INTEGER(), server_default=sa.text('nextval(\'"serviceTypes_id_seq"\'::regclass)'), nullable=False),
sa.Column('month_id', sa.INTEGER(), autoincrement=False, nullable=True),
sa.Column('service_type', sa.VARCHAR(length=36), autoincrement=False, nullable=False),
sa.Column('count', sa.INTEGER(), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['month_id'], ['months.id'], name='serviceTypes_month_id_fkey'),
sa.PrimaryKeyConstraint('id', name='serviceTypes_pkey')
)
op.drop_table('use_of_force_incidents')
### end Alembic commands ###
Example #6
| Source File: 2020_021023_6664d75ce3d4_.py From app with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('mailbox',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=256), nullable=False),
sa.Column('verified', sa.Boolean(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email')
)
op.add_column('gen_email', sa.Column('mailbox_id', sa.Integer(), nullable=True))
op.create_foreign_key(None, 'gen_email', 'mailbox', ['mailbox_id'], ['id'], ondelete='cascade')
# ### end Alembic commands ###
Example #7
| Source File: da5890c2fa1d_.py From recruit with Apache License 2.0 | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('cms_user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('username', sa.String(length=50), nullable=False),
sa.Column('_password', sa.String(length=150), nullable=False),
sa.Column('email', sa.String(length=50), nullable=False),
sa.Column('join_time', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email')
)
op.create_table('user',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('username', sa.String(length=50), nullable=False),
sa.Column('_password', sa.String(length=150), nullable=False),
sa.Column('email', sa.String(length=50), nullable=False),
sa.Column('join_time', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email')
)
# ### end Alembic commands ###
Example #8
| Source File: 2020_041911_dd911f880b75_.py From app with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('apple_subscription',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('expires_date', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('original_transaction_id', sa.String(length=256), nullable=False),
sa.Column('receipt_data', sa.Text(), nullable=False),
sa.Column('plan', sa.Enum('monthly', 'yearly', name='planenum_apple'), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('user_id')
)
op.alter_column('file', 'user_id',
existing_type=sa.INTEGER(),
nullable=True)
# ### end Alembic commands ###
Example #9
| Source File: 551c4e6d4a8b_.py From app with MIT License | 6 votes |
|
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('client_scope',
sa.Column('client_id', sa.INTEGER(), autoincrement=False, nullable=False),
sa.Column('scope_id', sa.INTEGER(), autoincrement=False, nullable=False),
sa.ForeignKeyConstraint(['client_id'], ['client.id'], name='client_scope_client_id_fkey', ondelete='CASCADE'),
sa.ForeignKeyConstraint(['scope_id'], ['scope.id'], name='client_scope_scope_id_fkey', ondelete='CASCADE'),
sa.PrimaryKeyConstraint('client_id', 'scope_id', name='client_scope_pkey')
)
op.create_table('scope',
sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
sa.Column('created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
sa.Column('updated_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('name', sa.VARCHAR(length=128), autoincrement=False, nullable=False),
sa.PrimaryKeyConstraint('id', name='scope_pkey'),
sa.UniqueConstraint('name', name='scope_name_key')
)
# ### end Alembic commands ###
Example #10
| Source File: 2020_022722_75093e7ded27_.py From app with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('social_auth',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('social', sa.String(length=128), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('user_id', 'social', name='uq_social_auth')
)
op.alter_column('users', 'password',
existing_type=sa.VARCHAR(length=128),
nullable=True)
op.alter_column('users', 'salt',
existing_type=sa.VARCHAR(length=128),
nullable=True)
# ### end Alembic commands ###
Example #11
| Source File: 3ebfbaeb76c0_.py From app with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('email_change',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('new_email', sa.String(length=128), nullable=False),
sa.Column('code', sa.String(length=128), nullable=False),
sa.Column('expired', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('code'),
sa.UniqueConstraint('new_email')
)
op.create_index(op.f('ix_email_change_user_id'), 'email_change', ['user_id'], unique=True)
# ### end Alembic commands ###
Example #12
| Source File: 2020_051016_bf11ab2f0a7a_.py From app with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('alias_mailbox',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('alias_id', sa.Integer(), nullable=False),
sa.Column('mailbox_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['alias_id'], ['alias.id'], ondelete='cascade'),
sa.ForeignKeyConstraint(['mailbox_id'], ['mailbox.id'], ondelete='cascade'),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('alias_id', 'mailbox_id', name='uq_alias_mailbox')
)
# ### end Alembic commands ###
Example #13
| Source File: cf46a28f46bc_add_container_actions_table.py From zun with Apache License 2.0 | 6 votes |
|
def upgrade():
op.create_table(
'container_actions',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('action', sa.String(length=255), nullable=True),
sa.Column('container_uuid', sa.String(length=36), nullable=False),
sa.Column('request_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('start_time', sa.DateTime(), nullable=True),
sa.Column('finish_time', sa.DateTime(), nullable=True),
sa.Column('message', sa.String(length=255), nullable=True),
sa.Index('container_uuid_idx', 'container_uuid'),
sa.Index('request_id_idx', 'request_id'),
sa.ForeignKeyConstraint(['container_uuid'], ['container.uuid'], ),
sa.PrimaryKeyConstraint('id')
)
Example #14
| Source File: a251f1f61217_create_capsule_table.py From zun with Apache License 2.0 | 6 votes |
|
def upgrade():
op.create_table(
'capsule',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('capsule_version', sa.String(length=255), nullable=True),
sa.Column('kind', sa.String(length=36), nullable=True),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('restart_policy', sa.String(length=255), nullable=True),
sa.Column('host_selector', sa.String(length=255), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(length=36), nullable=False),
sa.Column('status', sa.String(length=255), nullable=True),
sa.Column('status_reason', sa.Text(), nullable=True),
sa.Column('message', models.JSONEncodedDict(), nullable=True),
sa.Column('spec', models.JSONEncodedDict(), nullable=True),
sa.Column('cpu', sa.Float(), nullable=True),
sa.Column('memory', sa.String(length=255), nullable=True),
sa.Column('meta_name', sa.String(length=255), nullable=True),
sa.Column('meta_labels', models.JSONEncodedList(), nullable=True),
sa.Column('containers_uuids', models.JSONEncodedList(), nullable=True),
sa.PrimaryKeyConstraint('id'),
)
Example #15
| Source File: 9fe371393a24_create_table_container.py From zun with Apache License 2.0 | 6 votes |
|
def upgrade():
op.create_table(
'container',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('uuid', sa.String(length=36), nullable=True),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('image', sa.String(length=255), nullable=True),
sa.Column('command', sa.String(length=255), nullable=True),
sa.Column('status', sa.String(length=20), nullable=True),
sa.Column('environment', zun.db.sqlalchemy.models.JSONEncodedDict(),
nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid', name='uniq_container0uuid')
)
Example #16
| Source File: 2020_031416_11a35b448f83_.py From app with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('refused_email',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('full_report_path', sa.String(length=128), nullable=False),
sa.Column('path', sa.String(length=128), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('delete_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('full_report_path'),
sa.UniqueConstraint('path')
)
op.add_column('forward_email_log', sa.Column('refused_email_id', sa.Integer(), nullable=True))
op.create_foreign_key(None, 'forward_email_log', 'refused_email', ['refused_email_id'], ['id'], ondelete='SET NULL')
# ### end Alembic commands ###
Example #17
| Source File: 33cdd98bb9b2_split_volume_mapping_table.py From zun with Apache License 2.0 | 6 votes |
|
def create_volume_table():
op.create_table(
'volume',
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('uuid', sa.String(36), nullable=False),
sa.Column('project_id', sa.String(length=255), nullable=True),
sa.Column('user_id', sa.String(length=255), nullable=True),
sa.Column('cinder_volume_id', sa.String(36), nullable=True),
sa.Column('volume_provider', sa.String(36), nullable=False),
sa.Column('connection_info', MediumText(), nullable=True),
sa.Column('host', sa.String(length=255), nullable=True),
sa.Column('auto_remove', sa.Boolean(), default=False, nullable=True),
sa.Column('contents', MediumText(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('uuid', name='uniq_volume0uuid'),
)
Example #18
| Source File: d68a2d971b70_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('deleted_alias',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('email', sa.String(length=128), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('user_id')
)
# ### end Alembic commands ###
Example #19
| Source File: a8d8aa307b8b_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('custom_domain',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('domain', sa.String(length=128), nullable=False),
sa.Column('verified', sa.Boolean(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('domain')
)
# ### end Alembic commands ###
Example #20
| Source File: 6bbda4685999_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('forward_email_log',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('forward_id', sa.Integer(), nullable=False),
sa.Column('is_reply', sa.Boolean(), nullable=False),
sa.Column('blocked', sa.Boolean(), nullable=False),
sa.ForeignKeyConstraint(['forward_id'], ['forward_email.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id')
)
# ### end Alembic commands ###
Example #21
| Source File: 2020_050920_a5e3c6693dc6_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sent_alert',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('to_email', sa.String(length=256), nullable=False),
sa.Column('alert_type', sa.String(length=256), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id')
)
# ### end Alembic commands ###
Example #22
| Source File: 2e2b53afd819_.py From app with MIT License | 5 votes |
|
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('partner',
sa.Column('id', sa.INTEGER(), autoincrement=True, nullable=False),
sa.Column('created_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=False),
sa.Column('updated_at', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.Column('email', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
sa.Column('name', sa.VARCHAR(length=128), autoincrement=False, nullable=True),
sa.Column('website', sa.VARCHAR(length=1024), autoincrement=False, nullable=True),
sa.Column('additional_information', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('user_id', sa.INTEGER(), autoincrement=False, nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], name='partner_user_id_fkey', ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id', name='partner_pkey')
)
# ### end Alembic commands ###
Example #23
| Source File: d03e433dc248_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('reset_password_code',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('code', sa.String(length=128), nullable=False),
sa.Column('expired', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('code')
)
# ### end Alembic commands ###
Example #24
| Source File: 2020_010120_d29cca963221_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('lifetime_coupon',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('code', sa.String(length=128), nullable=False),
sa.Column('nb_used', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('code')
)
op.add_column('users', sa.Column('lifetime', sa.Boolean(), server_default='0', nullable=False))
# ### end Alembic commands ###
Example #25
| Source File: 2020_022316_e3cb44b953f2_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('manual_subscription',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('end_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('comment', sa.Text(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('user_id')
)
# ### end Alembic commands ###
Example #26
| Source File: 9768e6a66c9_flowclassifier_data_model.py From networking-sfc with Apache License 2.0 | 5 votes |
|
def upgrade():
op.create_table(
'sfc_flow_classifiers',
sa.Column('tenant_id', sa.String(length=255),
nullable=True, index=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('ethertype', sa.String(length=40), nullable=True),
sa.Column('protocol', sa.String(length=40), nullable=True),
sa.Column('description', sa.String(length=255),
nullable=True),
sa.Column('source_port_range_min', sa.Integer(), nullable=True),
sa.Column('source_port_range_max', sa.Integer(), nullable=True),
sa.Column('destination_port_range_min', sa.Integer(), nullable=True),
sa.Column('destination_port_range_max', sa.Integer(), nullable=True),
sa.Column('source_ip_prefix', sa.String(length=255), nullable=True),
sa.Column('destination_ip_prefix', sa.String(length=255),
nullable=True),
sa.Column('logical_source_port', sa.String(length=36),
nullable=False),
sa.Column('logical_destination_port', sa.String(length=36),
nullable=True),
sa.ForeignKeyConstraint(['logical_source_port'], ['ports.id'],
ondelete='RESTRICT'),
sa.ForeignKeyConstraint(['logical_destination_port'], ['ports.id'],
ondelete='RESTRICT'),
sa.PrimaryKeyConstraint('id')
)
op.create_table(
'sfc_flow_classifier_l7_parameters',
sa.Column('keyword', sa.String(length=255), nullable=False),
sa.Column('value', sa.String(length=255), nullable=True),
sa.Column('classifier_id', sa.String(length=36), nullable=False),
sa.ForeignKeyConstraint(['classifier_id'],
['sfc_flow_classifiers.id'], ),
sa.PrimaryKeyConstraint('keyword', 'classifier_id')
)
Example #27
| Source File: sql.py From recruit with Apache License 2.0 | 5 votes |
|
def _create_table_setup(self):
from sqlalchemy import Table, Column, PrimaryKeyConstraint
column_names_and_types = self._get_column_names_and_types(
self._sqlalchemy_type
)
columns = [Column(name, typ, index=is_index)
for name, typ, is_index in column_names_and_types]
if self.keys is not None:
if not is_list_like(self.keys):
keys = [self.keys]
else:
keys = self.keys
pkc = PrimaryKeyConstraint(*keys, name=self.name + '_pk')
columns.append(pkc)
schema = self.schema or self.pd_sql.meta.schema
# At this point, attach to new metadata, only attach to self.meta
# once table is created.
from sqlalchemy.schema import MetaData
meta = MetaData(self.pd_sql, schema=schema)
return Table(self.name, meta, *columns, schema=schema)
Example #28
| Source File: 2020_052419_10a7947fda6b_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('mfa_browser',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('token', sa.String(length=64), nullable=False),
sa.Column('expires', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('token')
)
op.add_column('users', sa.Column('last_otp', sa.String(length=12), nullable=True))
# ### end Alembic commands ###
Example #29
| Source File: 0de6730e3d41_create_wpd_complaints_table.py From comport with BSD 3-Clause "New" or "Revised" License | 5 votes |
|
def upgrade():
op.create_table(
'citizen_complaints_wpd',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('department_id', sa.Integer(), sa.ForeignKey('departments.id'), nullable=False),
sa.Column('opaque_id', sa.String(255), unique=False, nullable=True),
sa.Column('received_date', sa.DateTime, unique=False, nullable=True),
sa.Column('division', sa.String(255), unique=False, nullable=True),
sa.Column('bureau', sa.String(255), unique=False, nullable=True),
sa.Column('shift', sa.String(255), unique=False, nullable=True),
sa.Column('service_type', sa.String(255), unique=False, nullable=True),
sa.Column('source', sa.String(255), unique=False, nullable=True),
sa.Column('incident_type', sa.String(255), unique=False, nullable=True),
sa.Column('allegation', sa.String(255), unique=False, nullable=True),
sa.Column('finding', sa.String(255), unique=False, nullable=True),
sa.Column('disposition', sa.String(255), unique=False, nullable=True),
sa.Column('citizen_id', sa.String(255), unique=False, nullable=True),
sa.Column('citizen_race', sa.String(255), unique=False, nullable=True),
sa.Column('citizen_sex', sa.String(255), unique=False, nullable=True),
sa.Column('citizen_age', sa.String(255), unique=False, nullable=True),
sa.Column('officer_id', sa.String(255), unique=False, nullable=True),
sa.Column('officer_race', sa.String(255), unique=False, nullable=True),
sa.Column('officer_sex', sa.String(255), unique=False, nullable=True),
sa.Column('officer_age', sa.String(255), unique=False, nullable=True),
sa.Column('officer_years_of_service', sa.String(255), unique=False, nullable=True),
sa.ForeignKeyConstraint(['department_id'], ['departments.id']),
sa.PrimaryKeyConstraint('id')
)
Example #30
| Source File: e505cb517589_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('api_key',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('code', sa.String(length=128), nullable=False),
sa.Column('name', sa.String(length=128), nullable=False),
sa.Column('last_used', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('times', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('code')
)
op.create_table('alias_used_on',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('created_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=False),
sa.Column('updated_at', sqlalchemy_utils.types.arrow.ArrowType(), nullable=True),
sa.Column('gen_email_id', sa.Integer(), nullable=False),
sa.Column('hostname', sa.String(length=1024), nullable=False),
sa.ForeignKeyConstraint(['gen_email_id'], ['gen_email.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('gen_email_id', 'hostname', name='uq_alias_used')
)
# ### end Alembic commands ###
