Python sqlalchemy.UniqueConstraint() Examples
The following are 30
code examples of sqlalchemy.UniqueConstraint().
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: 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 #2
| Source File: 449903fb6e35_.py From privacyidea with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
try:
op.create_table('radiusserver',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('identifier', sa.Unicode(length=255), nullable=False),
sa.Column('server', sa.Unicode(length=255), nullable=False),
sa.Column('port', sa.Integer(), nullable=True),
sa.Column('secret', sa.Unicode(length=255), nullable=True),
sa.Column('description', sa.Unicode(length=2000), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('identifier')
)
except (OperationalError, ProgrammingError, InternalError) as exx:
if "duplicate column name" in str(exx.orig).lower():
print("Good. Table 'radiusserver' already exists.")
else:
print(exx)
except Exception as exx:
print ("Could not add table 'radiusserver'")
print (exx)
Example #3
| Source File: 3c6e9dd7fbac_.py From privacyidea with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
try:
op.create_table('clientapplication',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('ip', sa.Unicode(length=255), nullable=False),
sa.Column('hostname', sa.Unicode(length=255), nullable=True),
sa.Column('clienttype', sa.Unicode(length=255), nullable=False),
sa.Column('lastseen', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('ip', 'clienttype', name='caix')
)
op.create_index(op.f('ix_clientapplication_clienttype'), 'clientapplication', ['clienttype'], unique=False)
op.create_index(op.f('ix_clientapplication_id'), 'clientapplication', ['id'], unique=False)
op.create_index(op.f('ix_clientapplication_ip'), 'clientapplication', ['ip'], unique=False)
except (OperationalError, ProgrammingError, InternalError) as exx:
if "duplicate column name" in str(exx.orig).lower():
print("Good. Table clientapplication already exists.")
else:
print("Table already exists")
print(exx)
except Exception as exx:
print("Could not add Table clientapplication")
print (exx)
Example #4
| Source File: 3ae3c668f444_.py From privacyidea with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
try:
op.create_table('eventhandlercondition',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('eventhandler_id', sa.Integer(), nullable=True),
sa.Column('Key', sa.Unicode(length=255), nullable=False),
sa.Column('Value', sa.Unicode(length=2000), nullable=True),
sa.Column('comparator', sa.Unicode(length=255), nullable=True),
sa.ForeignKeyConstraint(['eventhandler_id'], ['eventhandler.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('eventhandler_id', 'Key', name='ehcix_1')
)
except (OperationalError, ProgrammingError, InternalError) as exx:
if "duplicate column name" in str(exx.orig).lower():
print("Good. Table eventhandlercondition already exists.")
else:
print("Table already exists")
print(exx)
except Exception as exx:
print("Could not add Table eventhandlercondition")
print (exx)
Example #5
| Source File: a65bdadbae2f_.py From zou with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('metadata_descriptor',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('project_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('entity_type', sa.String(length=60), nullable=False),
sa.Column('name', sa.String(length=120), nullable=False),
sa.Column('field_name', sa.String(length=120), nullable=False),
sa.Column('choices', postgresql.JSONB(astext_type=sa.Text()), nullable=True),
sa.ForeignKeyConstraint(['project_id'], ['project.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('project_id', 'entity_type', 'name', name='metadata_descriptor_uc')
)
op.create_index(op.f('ix_metadata_descriptor_entity_type'), 'metadata_descriptor', ['entity_type'], unique=False)
op.create_index(op.f('ix_metadata_descriptor_project_id'), 'metadata_descriptor', ['project_id'], unique=False)
# ### end Alembic commands ###
Example #6
| 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 #7
| 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 #8
| Source File: 0ec3762a745d_add_attachment_table.py From zou with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('attachment_file',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('name', sa.String(length=250), nullable=True),
sa.Column('size', sa.Integer(), nullable=True),
sa.Column('extension', sa.String(length=6), nullable=True),
sa.Column('comment_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=True),
sa.ForeignKeyConstraint(['comment_id'], ['comment.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name', 'comment_id', name='attachment_uc')
)
op.create_index(op.f('ix_attachment_file_comment_id'), 'attachment_file', ['comment_id'], unique=False)
# ### end Alembic commands ###
Example #9
| Source File: 6bd3b102d61b_.py From zou with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('subscription',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('person_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('task_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=True),
sa.Column('entity_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=True),
sa.Column('task_type_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=True),
sa.ForeignKeyConstraint(['entity_id'], ['entity.id'], ),
sa.ForeignKeyConstraint(['person_id'], ['person.id'], ),
sa.ForeignKeyConstraint(['task_id'], ['task.id'], ),
sa.ForeignKeyConstraint(['task_type_id'], ['task_type.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('person_id', 'task_id', name='subscription_task_uc'),
sa.UniqueConstraint('person_id', 'task_type_id', 'entity_id', name='subscription_entity_uc')
)
op.create_index(op.f('ix_subscription_entity_id'), 'subscription', ['entity_id'], unique=False)
op.create_index(op.f('ix_subscription_person_id'), 'subscription', ['person_id'], unique=False)
op.create_index(op.f('ix_subscription_task_id'), 'subscription', ['task_id'], unique=False)
op.create_index(op.f('ix_subscription_task_type_id'), 'subscription', ['task_type_id'], unique=False)
# ### end Alembic commands ###
Example #10
| Source File: 99825b9cc778_.py From zou with GNU Affero General Public License v3.0 | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('notification',
sa.Column('id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.Column('updated_at', sa.DateTime(), nullable=True),
sa.Column('read', sa.Boolean(), nullable=False),
sa.Column('change', sa.Boolean(), nullable=False),
sa.Column('person_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('author_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('comment_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.Column('task_id', sqlalchemy_utils.types.uuid.UUIDType(binary=False), default=uuid.uuid4, nullable=False),
sa.ForeignKeyConstraint(['author_id'], ['person.id'], ),
sa.ForeignKeyConstraint(['comment_id'], ['comment.id'], ),
sa.ForeignKeyConstraint(['person_id'], ['person.id'], ),
sa.ForeignKeyConstraint(['task_id'], ['task.id'], ),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('person_id', 'author_id', 'comment_id', name='notification_uc')
)
op.create_index(op.f('ix_notification_author_id'), 'notification', ['author_id'], unique=False)
op.create_index(op.f('ix_notification_comment_id'), 'notification', ['comment_id'], unique=False)
op.create_index(op.f('ix_notification_person_id'), 'notification', ['person_id'], unique=False)
op.create_index(op.f('ix_notification_task_id'), 'notification', ['task_id'], unique=False)
# ### end Alembic commands ###
Example #11
| Source File: b9c703669314_add_flavor_and_flavor_profile_table.py From octavia with Apache License 2.0 | 6 votes |
|
def upgrade():
op.create_table(
u'flavor_profile',
sa.Column(u'id', sa.String(36), nullable=False),
sa.Column(u'name', sa.String(255), nullable=False),
sa.Column(u'provider_name', sa.String(255), nullable=False),
sa.Column(u'flavor_data', sa.String(4096), nullable=False),
sa.PrimaryKeyConstraint(u'id'))
op.create_table(
u'flavor',
sa.Column(u'id', sa.String(36), nullable=False),
sa.Column(u'name', sa.String(255), nullable=False),
sa.Column(u'description', sa.String(255), nullable=True),
sa.Column(u'enabled', sa.Boolean(), nullable=False),
sa.Column(u'flavor_profile_id', sa.String(36), nullable=False),
sa.ForeignKeyConstraint([u'flavor_profile_id'],
[u'flavor_profile.id'],
name=u'fk_flavor_flavor_profile_id'),
sa.PrimaryKeyConstraint(u'id'),
sa.UniqueConstraint(u'name',
name=u'uq_flavor_name'),)
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: 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 #14
| 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 #15
| 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 #16
| Source File: 00030_be0687950ece_actually_dropping_unused_columns_now.py From ReadableWebProxy with BSD 3-Clause "New" or "Revised" License | 6 votes |
|
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('feed_pages', sa.Column('feedurl', sa.TEXT(), autoincrement=False, nullable=True))
op.add_column('feed_pages', sa.Column('srcname', sa.TEXT(), autoincrement=False, nullable=True))
op.create_table('nu_outbound_wrappers',
sa.Column('id', sa.BIGINT(), nullable=False),
sa.Column('actual_target', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('client_id', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('client_key', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('groupinfo', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('outbound_wrapper', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('referrer', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('releaseinfo', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('seriesname', sa.TEXT(), autoincrement=False, nullable=True),
sa.Column('validated', sa.BOOLEAN(), autoincrement=False, nullable=True),
sa.Column('released_on', postgresql.TIMESTAMP(), autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id', name='nu_outbound_wrappers_pkey'),
sa.UniqueConstraint('client_id', 'client_key', 'seriesname', 'releaseinfo', 'groupinfo', 'actual_target', name='nu_outbound_wrappers_client_id_client_key_seriesname_releas_key')
)
### end Alembic commands ###
Example #17
| Source File: 1f540eb8fd5e_.py From FXTest with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('sceness',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=252), nullable=True),
sa.Column('order', sa.Integer(), nullable=True),
sa.Column('parame', sa.String(length=252), nullable=True),
sa.Column('assertparame', sa.String(length=252), nullable=True),
sa.Column('center', sa.String(length=128), nullable=True),
sa.Column('createtime', sa.DateTime(), nullable=True),
sa.Column('desc', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('testgroup',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=252), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
# ### end Alembic commands ###
Example #18
| 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 #19
| Source File: 30810118794d_第一次初始化.py From Python24 with MIT License | 6 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('roles',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=64), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('name')
)
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=64), nullable=True),
sa.Column('role_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['role_id'], ['roles.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_user_username'), 'user', ['username'], unique=True)
# ### end Alembic commands ###
Example #20
| 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 #21
| 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 #22
| Source File: codegen.py From safrs with GNU General Public License v3.0 | 6 votes |
|
def render_constraint(self, constraint):
def render_fk_options(*opts):
opts = [repr(opt) for opt in opts]
for attr in "ondelete", "onupdate", "deferrable", "initially", "match":
value = getattr(constraint, attr, None)
if value:
opts.append("{0}={1!r}".format(attr, value))
return ", ".join(opts)
if isinstance(constraint, ForeignKey):
remote_column = "{0}.{1}".format(constraint.column.table.fullname, constraint.column.name)
return "ForeignKey({0})".format(render_fk_options(remote_column))
elif isinstance(constraint, ForeignKeyConstraint):
local_columns = _get_column_names(constraint)
remote_columns = ["{0}.{1}".format(fk.column.table.fullname, fk.column.name) for fk in constraint.elements]
return "ForeignKeyConstraint({0})".format(render_fk_options(local_columns, remote_columns))
elif isinstance(constraint, CheckConstraint):
return "CheckConstraint({0!r})".format(self._get_compiled_expression(constraint.sqltext))
elif isinstance(constraint, UniqueConstraint):
columns = [repr(col.name) for col in constraint.columns]
return "UniqueConstraint({0})".format(", ".join(columns))
Example #23
| Source File: 002_ara_record_data.py From ara-archive with GNU General Public License v3.0 | 5 votes |
|
def upgrade():
op.create_table('data',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('playbook_id', sa.String(length=36), nullable=True),
sa.Column('key', sa.String(length=255), nullable=True),
sa.Column('value', models.CompressedData((2 ** 32) - 1), nullable=True),
sa.ForeignKeyConstraint(['playbook_id'], ['playbooks.id'], ondelete='RESTRICT'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('playbook_id', 'key')
)
### end Alembic commands ###
Example #24
| Source File: 5fa68bafae72_.py From app with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('forward_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('gen_email_id', sa.Integer(), nullable=False),
sa.Column('website_email', sa.String(length=128), nullable=False),
sa.Column('reply_email', sa.String(length=128), nullable=False),
sa.ForeignKeyConstraint(['gen_email_id'], ['gen_email.id'], ondelete='cascade'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('gen_email_id', 'website_email', name='uq_forward_email')
)
# ### end Alembic commands ###
Example #25
| Source File: codegen.py From safrs with GNU General Public License v3.0 | 5 votes |
|
def __init__(self, source_cls, target_cls, constraint, inflect_engine):
super(ManyToOneRelationship, self).__init__(source_cls, target_cls)
column_names = _get_column_names(constraint)
colname = column_names[0]
tablename = constraint.elements[0].column.table.name
if not colname.endswith("_id"):
self.preferred_name = inflect_engine.singular_noun(tablename) or tablename
else:
self.preferred_name = colname[:-3]
# Add uselist=False to One-to-One relationships
if any(
isinstance(c, (PrimaryKeyConstraint, UniqueConstraint)) and set(col.name for col in c.columns) == set(column_names)
for c in constraint.table.constraints
):
self.kwargs["uselist"] = "False"
# Handle self referential relationships
if source_cls == target_cls:
self.preferred_name = "parent" if not colname.endswith("_id") else colname[:-3]
pk_col_names = [col.name for col in constraint.table.primary_key]
self.kwargs["remote_side"] = "[{0}]".format(", ".join(pk_col_names))
# If the two tables share more than one foreign key constraint,
# SQLAlchemy needs an explicit primaryjoin to figure out which column(s) to join with
common_fk_constraints = self.get_common_fk_constraints(constraint.table, constraint.elements[0].column.table)
if len(common_fk_constraints) > 1:
self.kwargs["primaryjoin"] = "'{0}.{1} == {2}.{3}'".format(
source_cls, column_names[0], target_cls, constraint.elements[0].column.name
)
Example #26
| Source File: b25a55525161_increase_length_of_pool_name.py From airflow with Apache License 2.0 | 5 votes |
|
def downgrade():
"""Revert Increased length of pool name from 256 to 50 characters"""
# use batch_alter_table to support SQLite workaround
with op.batch_alter_table('slot_pool', table_args=sa.UniqueConstraint('pool')) as batch_op:
batch_op.alter_column('pool', type_=sa.String(50))
Example #27
| Source File: b25a55525161_increase_length_of_pool_name.py From airflow with Apache License 2.0 | 5 votes |
|
def upgrade():
"""Increase column length of pool name from 50 to 256 characters"""
# use batch_alter_table to support SQLite workaround
with op.batch_alter_table('slot_pool', table_args=sa.UniqueConstraint('pool')) as batch_op:
batch_op.alter_column('pool', type_=sa.String(256))
Example #28
| Source File: 9b46e2a7df2b_.py From flask-microservices-users with MIT License | 5 votes |
|
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('users',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=128), nullable=False),
sa.Column('email', sa.String(length=128), nullable=False),
sa.Column('active', sa.Boolean(), nullable=False),
sa.Column('created_at', sa.DateTime(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('username')
)
# ### end Alembic commands ###
Example #29
| Source File: 20150101130345_3d8f34e83d23_add_user_model.py From learning-python with MIT License | 5 votes |
|
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=50), nullable=True),
sa.Column('email', sa.String(length=50), nullable=True),
sa.Column('avatar', sa.String(length=200), nullable=True),
sa.Column('password', sa.String(length=200), nullable=True),
sa.Column('is_admin', sa.Boolean(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('email'),
sa.UniqueConstraint('name')
)
### end Alembic commands ###
Example #30
| Source File: 1b38cef5b76e_add_dagrun.py From airflow with Apache License 2.0 | 5 votes |
|
def upgrade(): # noqa: D103
op.create_table('dag_run',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('dag_id', sa.String(length=250), nullable=True),
sa.Column('execution_date', sa.DateTime(), nullable=True),
sa.Column('state', sa.String(length=50), nullable=True),
sa.Column('run_id', sa.String(length=250), nullable=True),
sa.Column('external_trigger', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('dag_id', 'execution_date'),
sa.UniqueConstraint('dag_id', 'run_id'))
