def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('post', sa.Column('language', sa.String(length=5), nullable=True))
def upgrade():
op.create_table(
'infoblox_grids', sa.Column('grid_id', sa.Integer(), nullable=False),
sa.Column('grid_name', sa.String(length=128), nullable=True),
sa.Column('grid_connection', sa.String(length=1024), nullable=False),
sa.Column('grid_status', sa.String(length=6), nullable=False),
sa.PrimaryKeyConstraint('grid_id'))
op.create_table(
'infoblox_grid_members',
sa.Column('member_id', sa.String(length=32), nullable=False),
sa.Column('grid_id', sa.Integer(), nullable=False),
sa.Column('member_name', sa.String(length=255), nullable=False),
sa.Column('member_ip', sa.String(length=15), nullable=True),
sa.Column('member_ipv6', sa.String(length=64), nullable=True),
sa.Column('member_type', sa.String(length=12), nullable=False),
sa.Column('member_status', sa.String(length=16), nullable=False),
sa.ForeignKeyConstraint(['grid_id'], ['infoblox_grids.grid_id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('member_id'),
sa.UniqueConstraint(
'grid_id',
'member_name',
name='uniq_infoblox_grid_members_grid_id_member_name'),
sa.UniqueConstraint(
'member_id',
'grid_id',
'member_ip',
name='uniq_infoblox_grid_members_member_id_grid_id_member_ip'),
sa.UniqueConstraint(
'member_id',
'grid_id',
'member_ipv6',
name='uniq_infoblox_grid_members_member_id_grid_id_member_ipv6'),
sa.Index('ix_infoblox_grid_members_grid_id_member_status', 'grid_id',
'member_status'))
op.create_table(
'infoblox_operations',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('op_type', sa.String(length=48), nullable=False),
sa.Column('op_value', sa.String(length=255), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('op_type',
name='uniq_infoblox_operations_op_type'))
op.create_table(
'infoblox_network_views',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('network_view', sa.String(length=255), nullable=False),
sa.Column('grid_id', sa.Integer(), nullable=False),
sa.Column('authority_member_id', sa.String(length=32), nullable=False),
sa.Column('shared', sa.Boolean(), default=False, nullable=False),
sa.ForeignKeyConstraint(['authority_member_id'],
['infoblox_grid_members.member_id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint(
'network_view',
'grid_id',
name='uniq_infoblox_network_views_network_view_grid_id'),
sa.UniqueConstraint(
'network_view',
'authority_member_id',
name='uniq_infoblox_network_views_network_view_authority_member_id'
))
op.create_table(
'infoblox_network_view_mapping',
sa.Column('network_view_id', sa.String(length=36), nullable=False),
sa.Column('network_id', sa.String(length=36), nullable=False),
sa.Column('subnet_id', sa.String(length=36), nullable=False),
sa.ForeignKeyConstraint(['network_id'], ['networks.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['network_view_id'],
['infoblox_network_views.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('network_view_id', 'network_id', 'subnet_id'))
op.create_table(
'infoblox_mapping_conditions',
sa.Column('network_view_id', sa.String(length=36), nullable=False),
sa.Column('neutron_object_name', sa.String(length=48), nullable=False),
sa.Column('neutron_object_value',
sa.String(length=255),
nullable=False),
sa.ForeignKeyConstraint(['network_view_id'],
['infoblox_network_views.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('network_view_id', 'neutron_object_name',
'neutron_object_value'))
op.create_table(
'infoblox_mapping_members',
sa.Column('network_view_id', sa.String(length=36), nullable=False),
sa.Column('member_id', sa.String(length=32), nullable=False),
sa.Column('mapping_relation', sa.String(length=24), nullable=False),
sa.ForeignKeyConstraint(['network_view_id'],
['infoblox_network_views.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['member_id'],
['infoblox_grid_members.member_id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('network_view_id', 'member_id'))
op.create_table(
'infoblox_service_members',
sa.Column('network_view_id', sa.String(length=36), nullable=False),
sa.Column('member_id', sa.String(length=48), nullable=False),
sa.Column('service', sa.String(length=12), nullable=False),
sa.ForeignKeyConstraint(['network_view_id'],
['infoblox_network_views.id'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(['member_id'],
['infoblox_grid_members.member_id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('network_view_id', 'member_id', 'service'),
sa.UniqueConstraint(
'member_id',
'service',
name='uniq_infoblox_service_members_member_id_service'))
op.create_table(
'infoblox_tenants',
sa.Column('tenant_id', sa.String(64), nullable=False,
primary_key=True),
sa.Column('tenant_name', sa.String(64), nullable=False),
)
class ConfigEntry(BaseTable):
__tablename__ = 'config_entries'
id = sa.Column(sa.Integer(), primary_key=True)
key = sa.Column(sa.String(255))
value = sa.Column(sa.Text(), nullable=False)
public = sa.Column(sa.Boolean, default=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('users', sa.Column('fullname', sa.String(length=128), nullable=True))
op.drop_column('users', 'full_name')
def upgrade():
op.add_column(
'standardattributes',
sa.Column('description', sa.String(length=255), nullable=True))
"""Register an event listener on the attribute.
This event listener will validate the size every
time a 'set' occurs.
"""
for cls in utils.iter_subclasses(Execution):
if hasattr(cls, attr_name):
event.listen(
getattr(cls, attr_name), 'set',
lambda t, v, o, i: validate_long_type_length(
cls, attr_name, v))
# Many-to-one for 'Execution' and 'TaskExecution'.
Execution.task_execution_id = sa.Column(sa.String(36),
sa.ForeignKey(TaskExecution.id),
nullable=True)
TaskExecution.executions = relationship(
Execution,
backref=backref('task_execution', remote_side=[TaskExecution.id]),
cascade='all, delete-orphan',
foreign_keys=Execution.task_execution_id,
lazy='select')
sa.Index('%s_task_execution_id' % Execution.__tablename__,
Execution.task_execution_id)
# Many-to-one for 'TaskExecution' and 'WorkflowExecution'.
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column("user", sa.Column("full_name", sa.String(), nullable=False))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('images',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('type', sa.Enum('FRONT_COVER',
'BACK_COVER',
'MISC_COVER',
'LOGO',
'ARTIST',
'LIVE',
name='image_types'),
nullable=False),
sa.Column('mime_type',
sa.String(length=Image.MIMETYPE_LIMIT),
nullable=False),
sa.Column('md5', sa.String(length=Image.MD5_LIMIT),
nullable=False),
sa.Column('size', sa.Integer(), nullable=False),
sa.Column('description', sa.String(length=Image.DESC_LIMIT),
nullable=False),
sa.Column('data', sa.LargeBinary(), nullable=False),
sa.PrimaryKeyConstraint('id', name=op.f('pk_images'))
)
lib_t = op.create_table('libraries',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Unicode(length=Library.NAME_LIMIT),
nullable=False),
sa.Column('last_sync', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('id', name=op.f('pk_libraries')),
sa.UniqueConstraint('name', name=op.f('uq_libraries_name'))
)
op.bulk_insert(lib_t,
[
{"name": mishmash.orm.NULL_LIB_NAME},
{"name": mishmash.orm.MAIN_LIB_NAME},
])
meta_t = op.create_table('meta',
sa.Column('version',
sa.String(length=Meta.VERSION_LIMIT),
nullable=False),
sa.Column('last_sync', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('version', name=op.f('pk_meta'))
)
op.bulk_insert(meta_t, [{"version": mishmash.version}])
artists_t = op.create_table('artists',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Unicode(length=Artist.NAME_LIMIT),
nullable=False),
sa.Column('sort_name',
sa.Unicode(length=Artist.SORT_NAME_LIMIT),
nullable=False),
sa.Column('date_added', sa.DateTime(), nullable=False),
sa.Column('origin_city',
sa.Unicode(length=Artist.CITY_LIMIT),
nullable=True),
sa.Column('origin_state',
sa.Unicode(length=Artist.STATE_LIMIT),
nullable=True),
sa.Column('origin_country',
sa.String(length=Artist.COUNTRY_LIMIT),
nullable=True),
sa.Column('lib_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['lib_id'], ['libraries.id'],
name=op.f('fk_artists_lib_id_libraries')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_artists')),
sa.UniqueConstraint('name', 'origin_city', 'origin_state',
'origin_country', 'lib_id',
name=op.f('uq_artists_name'))
)
op.bulk_insert(artists_t,
[{"lib_id": mishmash.orm.NULL_LIB_ID,
"name": mishmash.orm.VARIOUS_ARTISTS_NAME,
"sort_name": mishmash.orm.getSortName(
mishmash.orm.VARIOUS_ARTISTS_NAME),
"date_added": datetime.datetime.now(),
}])
op.create_index(op.f('ix_artists_lib_id'), 'artists', ['lib_id'],
unique=False)
op.create_index(op.f('ix_artists_name'), 'artists', ['name'],
unique=False)
op.create_table('tags',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.Unicode(length=Tag.NAME_LIMIT),
nullable=False),
sa.Column('lib_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['lib_id'], ['libraries.id'],
name=op.f('fk_tags_lib_id_libraries')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tags')),
sa.UniqueConstraint('name', 'lib_id',
name=op.f('uq_tags_name'))
)
op.create_index(op.f('ix_tags_lib_id'), 'tags', ['lib_id'], unique=False)
op.create_table('albums',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('title', sa.Unicode(length=Album.TITLE_LIMIT),
nullable=False),
sa.Column('type', sa.Enum('lp', 'ep', 'compilation',
'live', 'various', 'demo',
'single',
name='album_types'),
nullable=False),
sa.Column('date_added', sa.DateTime(), nullable=False),
sa.Column('release_date',
AlbumDate(length=Album.DATE_LIMIT),
nullable=True),
sa.Column('original_release_date',
AlbumDate(length=Album.DATE_LIMIT),
nullable=True),
sa.Column('recording_date',
AlbumDate(length=Album.DATE_LIMIT),
nullable=True),
sa.Column('artist_id', sa.Integer(), nullable=False),
sa.Column('lib_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['artist_id'], ['artists.id'],
name=op.f('fk_albums_artist_id_artists')),
sa.ForeignKeyConstraint(
['lib_id'], ['libraries.id'],
name=op.f('fk_albums_lib_id_libraries')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_albums')),
sa.UniqueConstraint('title', 'artist_id', 'lib_id',
name=op.f('uq_albums_title'))
)
op.create_index(op.f('ix_albums_artist_id'), 'albums', ['artist_id'],
unique=False)
op.create_index(op.f('ix_albums_lib_id'), 'albums', ['lib_id'],
unique=False)
op.create_index(op.f('ix_albums_title'), 'albums', ['title'],
unique=False)
op.create_table('artist_images',
sa.Column('artist_id', sa.Integer(), nullable=True),
sa.Column('img_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['artist_id'], ['artists.id'],
name=op.f('fk_artist_images_artist_id_artists')),
sa.ForeignKeyConstraint(
['img_id'], ['images.id'],
name=op.f('fk_artist_images_img_id_images'))
)
op.create_table('artist_tags',
sa.Column('artist_id', sa.Integer(), nullable=True),
sa.Column('tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['artist_id'], ['artists.id'],
name=op.f('fk_artist_tags_artist_id_artists')),
sa.ForeignKeyConstraint(['tag_id'], ['tags.id'],
name=op.f('fk_artist_tags_tag_id_tags'))
)
op.create_table('album_images',
sa.Column('album_id', sa.Integer(), nullable=True),
sa.Column('img_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['album_id'], ['albums.id'],
name=op.f('fk_album_images_album_id_albums')),
sa.ForeignKeyConstraint(
['img_id'], ['images.id'],
name=op.f('fk_album_images_img_id_images'))
)
op.create_table('album_tags',
sa.Column('album_id', sa.Integer(), nullable=True),
sa.Column('tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['album_id'], ['albums.id'],
name=op.f('fk_album_tags_album_id_albums')),
sa.ForeignKeyConstraint(
['tag_id'], ['tags.id'],
name=op.f('fk_album_tags_tag_id_tags'))
)
op.create_table('tracks',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('path', sa.String(length=Track.PATH_LIMIT),
nullable=False),
sa.Column('size_bytes', sa.Integer(), nullable=False),
sa.Column('ctime', sa.DateTime(), nullable=False),
sa.Column('mtime', sa.DateTime(), nullable=False),
sa.Column('date_added', sa.DateTime(), nullable=False),
sa.Column('time_secs', sa.Integer(), nullable=False),
sa.Column('title', sa.Unicode(length=Track.TITLE_LIMIT),
nullable=False),
sa.Column('track_num', sa.SmallInteger(), nullable=True),
sa.Column('track_total', sa.SmallInteger(), nullable=True),
sa.Column('media_num', sa.SmallInteger(), nullable=True),
sa.Column('media_total', sa.SmallInteger(), nullable=True),
sa.Column('bit_rate', sa.SmallInteger(), nullable=True),
sa.Column('variable_bit_rate', sa.Boolean(name="vbr_bool"),
nullable=True),
sa.Column('artist_id', sa.Integer(), nullable=False),
sa.Column('album_id', sa.Integer(), nullable=True),
sa.Column('lib_id', sa.Integer(), nullable=False),
sa.Column('metadata_format',
sa.Enum(*['ID3v1.0', 'ID3v1.1', 'ID3v2.2',
'ID3v2.3', 'ID3v2.4'],
name='metadata_formats')),
sa.ForeignKeyConstraint(
['album_id'], ['albums.id'],
name=op.f('fk_tracks_album_id_albums')),
sa.ForeignKeyConstraint(
['artist_id'], ['artists.id'],
name=op.f('fk_tracks_artist_id_artists')),
sa.ForeignKeyConstraint(
['lib_id'], ['libraries.id'],
name=op.f('fk_tracks_lib_id_libraries')),
sa.PrimaryKeyConstraint('id', name=op.f('pk_tracks')),
sa.UniqueConstraint('path', 'lib_id',
name=op.f('uq_tracks_path'))
)
op.create_index(op.f('ix_tracks_album_id'), 'tracks', ['album_id'],
unique=False)
op.create_index(op.f('ix_tracks_artist_id'), 'tracks', ['artist_id'],
unique=False)
op.create_index(op.f('ix_tracks_lib_id'), 'tracks', ['lib_id'],
unique=False)
op.create_index(op.f('ix_tracks_path'), 'tracks', ['path'], unique=False)
op.create_index(op.f('ix_tracks_title'), 'tracks', ['title'], unique=False)
op.create_table('track_tags',
sa.Column('track_id', sa.Integer(), nullable=True),
sa.Column('tag_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(
['tag_id'], ['tags.id'],
name=op.f('fk_track_tags_tag_id_tags')),
sa.ForeignKeyConstraint(
['track_id'], ['tracks.id'],
name=op.f('fk_track_tags_track_id_tracks'))
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('order', sa.Column('destination', sa.String(length=50), nullable=False, server_default='n/a'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('subscribe', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=255), nullable=True),
sa.Column('email', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('id'))
class NetworkGatewayDevice(model_base.BASEV2):
id = sa.Column(sa.String(36), primary_key=True)
network_gateway_id = sa.Column(
sa.String(36), sa.ForeignKey('networkgateways.id', ondelete='CASCADE'))
interface_name = sa.Column(sa.String(64))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'odytraf', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('court_system', sa.String(), nullable=True),
sa.Column('location', sa.String(), nullable=True),
sa.Column('citation_number', sa.String(), nullable=True),
sa.Column('case_title', sa.String(), nullable=True),
sa.Column('case_type', sa.String(), nullable=True),
sa.Column('filing_date', sa.Date(), nullable=True),
sa.Column('filing_date_str', sa.String(), nullable=True),
sa.Column('violation_date', sa.Date(), nullable=True),
sa.Column('violation_date_str', sa.String(), nullable=True),
sa.Column('violation_time', sa.Time(), nullable=True),
sa.Column('violation_time_str', sa.String(), nullable=True),
sa.Column('violation_county', sa.String(), nullable=True),
sa.Column('agency_name', sa.String(), nullable=True),
sa.Column('officer_id', sa.String(), nullable=True),
sa.Column('officer_name', sa.String(), nullable=True),
sa.Column('case_status', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['cases.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_case_number'),
'odytraf', ['case_number'],
unique=True)
op.create_table(
'odytraf_bond_settings', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('bail_date', sa.Date(), nullable=True),
sa.Column('bail_date_str', sa.String(), nullable=True),
sa.Column('bail_setting_type', sa.String(), nullable=True),
sa.Column('bail_amount', sa.Numeric(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_bond_settings_case_number'),
'odytraf_bond_settings', ['case_number'],
unique=False)
op.create_table(
'odytraf_bondsmen', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('address', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_bondsmen_case_number'),
'odytraf_bondsmen', ['case_number'],
unique=False)
op.create_table(
'odytraf_charges', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('charge_number', sa.Integer(), nullable=True),
sa.Column('charge_description', sa.String(), nullable=True),
sa.Column('statute_code', sa.String(), nullable=True),
sa.Column('speed_limit', sa.Integer(), nullable=True),
sa.Column('recorded_speed', sa.Integer(), nullable=True),
sa.Column('location_stopped', sa.String(), nullable=True),
sa.Column('probable_cause_indicator', sa.Boolean(), nullable=True),
sa.Column('charge_contributed_to_accident',
sa.Boolean(),
nullable=True),
sa.Column('charge_personal_injury', sa.Boolean(), nullable=True),
sa.Column('property_damage', sa.Boolean(), nullable=True),
sa.Column('seat_belts', sa.Boolean(), nullable=True),
sa.Column('mandatory_court_appearance', sa.Boolean(), nullable=True),
sa.Column('fine_amount_owed', sa.Numeric(), nullable=True),
sa.Column('vehicle_tag', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('vehicle_description', sa.String(), nullable=True),
sa.Column('convicted_speed', sa.Integer(), nullable=True),
sa.Column('disposition_contributed_to_accident',
sa.Boolean(),
nullable=True),
sa.Column('disposition_personal_injury', sa.Boolean(), nullable=True),
sa.Column('plea', sa.String(), nullable=True),
sa.Column('plea_date', sa.Date(), nullable=True),
sa.Column('plea_date_str', sa.String(), nullable=True),
sa.Column('disposition', sa.String(), nullable=True),
sa.Column('disposition_date', sa.Date(), nullable=True),
sa.Column('disposition_date_str', sa.String(), nullable=True),
sa.Column('converted_disposition', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_charges_case_number'),
'odytraf_charges', ['case_number'],
unique=False)
op.create_table(
'odytraf_court_schedule', sa.Column('id', sa.Integer(),
nullable=False),
sa.Column('event_type', sa.String(), nullable=False),
sa.Column('date', sa.Date(), nullable=True),
sa.Column('date_str', sa.String(), nullable=True),
sa.Column('time', sa.Time(), nullable=True),
sa.Column('time_str', sa.String(), nullable=True),
sa.Column('location', sa.String(), nullable=True),
sa.Column('room', sa.String(), nullable=True),
sa.Column('result', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_court_schedule_case_number'),
'odytraf_court_schedule', ['case_number'],
unique=False)
op.create_table(
'odytraf_defendant_aliases',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('alias', sa.String(), nullable=False),
sa.Column('alias_type', sa.String(), nullable=False),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_defendant_aliases_case_number'),
'odytraf_defendant_aliases', ['case_number'],
unique=False)
op.create_table(
'odytraf_defendants', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('race', sa.String(), nullable=True),
sa.Column('sex', sa.String(), nullable=True),
sa.Column('weight', sa.Integer(), nullable=True),
sa.Column('DOB', sa.Date(), nullable=True),
sa.Column('DOB_str', sa.String(), nullable=True),
sa.Column('address_1', sa.String(), nullable=True),
sa.Column('address_2', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('height', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_defendants_case_number'),
'odytraf_defendants', ['case_number'],
unique=False)
op.create_table(
'odytraf_documents', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('file_date', sa.Date(), nullable=True),
sa.Column('file_date_str', sa.String(), nullable=True),
sa.Column('filed_by', sa.String(), nullable=True),
sa.Column('document_name', sa.String(), nullable=True),
sa.Column('comment', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_documents_case_number'),
'odytraf_documents', ['case_number'],
unique=False)
op.create_table(
'odytraf_interpreters', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('address', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_interpreters_case_number'),
'odytraf_interpreters', ['case_number'],
unique=False)
op.create_table(
'odytraf_officers', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=True),
sa.Column('agency_name', sa.String(), nullable=False),
sa.Column('address_1', sa.String(), nullable=True),
sa.Column('address_2', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('role', sa.String(), nullable=False),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_officers_case_number'),
'odytraf_officers', ['case_number'],
unique=False)
op.create_table(
'odytraf_plaintiffs', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_plaintiffs_case_number'),
'odytraf_plaintiffs', ['case_number'],
unique=False)
op.create_table(
'odytraf_probation_officers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('address', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_probation_officers_case_number'),
'odytraf_probation_officers', ['case_number'],
unique=False)
op.create_table(
'odytraf_reference_numbers',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('ref_num', sa.String(), nullable=False),
sa.Column('ref_num_type', sa.String(), nullable=False),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_reference_numbers_case_number'),
'odytraf_reference_numbers', ['case_number'],
unique=False)
op.create_table(
'odytraf_sureties', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('address', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_sureties_case_number'),
'odytraf_sureties', ['case_number'],
unique=False)
op.create_table(
'odytraf_warrants', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('warrant_type', sa.String(), nullable=True),
sa.Column('issue_date', sa.Date(), nullable=True),
sa.Column('issue_date_str', sa.String(), nullable=True),
sa.Column('last_status', sa.String(), nullable=True),
sa.Column('status_date', sa.Date(), nullable=True),
sa.Column('status_date_str', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_warrants_case_number'),
'odytraf_warrants', ['case_number'],
unique=False)
op.create_table(
'odytraf_attorneys', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('plaintiff_id', sa.Integer(), nullable=True),
sa.Column('defendant_id', sa.Integer(), nullable=True),
sa.Column('name', sa.String(), nullable=True),
sa.Column('address_1', sa.String(), nullable=True),
sa.Column('address_2', sa.String(), nullable=True),
sa.Column('address_3', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('state', sa.String(), nullable=True),
sa.Column('zip_code', sa.String(), nullable=True),
sa.Column('case_number', sa.String(), nullable=True),
sa.ForeignKeyConstraint(['case_number'], ['odytraf.case_number'],
ondelete='CASCADE'),
sa.ForeignKeyConstraint(
['defendant_id'],
['odytraf_defendants.id'],
),
sa.ForeignKeyConstraint(
['plaintiff_id'],
['odytraf_plaintiffs.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_odytraf_attorneys_case_number'),
'odytraf_attorneys', ['case_number'],
unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('entity',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('business_identifier', sa.String(length=75), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('business_identifier')
)
op.create_table('membership_type',
sa.Column('code', sa.String(length=15), nullable=False),
sa.Column('desc', sa.String(length=100), nullable=True),
sa.PrimaryKeyConstraint('code')
)
op.create_table('org_status',
sa.Column('code', sa.String(length=15), nullable=False),
sa.Column('desc', sa.String(length=100), nullable=True),
sa.PrimaryKeyConstraint('code')
)
op.create_table('org_type',
sa.Column('code', sa.String(length=15), nullable=False),
sa.Column('desc', sa.String(length=100), nullable=True),
sa.PrimaryKeyConstraint('code'),
sa.UniqueConstraint('code')
)
op.create_table('payment_type',
sa.Column('code', sa.String(length=15), nullable=False),
sa.Column('desc', sa.String(length=100), nullable=True),
sa.PrimaryKeyConstraint('code'),
sa.UniqueConstraint('code')
)
op.create_table('user',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('username', sa.String(length=100), nullable=True),
sa.Column('first_name', sa.String(length=200), nullable=True),
sa.Column('last_name', sa.String(length=200), nullable=True),
sa.Column('email', sa.String(length=200), nullable=True),
sa.Column('keycloak_guid', postgresql.UUID(as_uuid=True), nullable=False),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('modified', sa.DateTime(), nullable=True),
sa.Column('roles', sa.String(length=1000), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('keycloak_guid')
)
op.create_index(op.f('ix_user_email'), 'user', ['email'], unique=False)
op.create_index(op.f('ix_user_first_name'), 'user', ['first_name'], unique=False)
op.create_index(op.f('ix_user_last_name'), 'user', ['last_name'], unique=False)
op.create_index(op.f('ix_user_username'), 'user', ['username'], unique=False)
op.create_table('contact',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('street', sa.String(length=250), nullable=True),
sa.Column('street_additional', sa.String(length=250), nullable=True),
sa.Column('city', sa.String(length=100), nullable=True),
sa.Column('region', sa.String(length=100), nullable=True),
sa.Column('country', sa.String(length=2), nullable=True),
sa.Column('postal_code', sa.String(length=10), nullable=True),
sa.Column('delivery_instructions', sa.String(length=4096), nullable=True),
sa.Column('phone', sa.String(length=15), nullable=True),
sa.Column('phone_extension', sa.String(length=10), nullable=True),
sa.Column('email', sa.String(length=100), nullable=True),
sa.Column('entity_id', sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(['entity_id'], ['entity.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_contact_street'), 'contact', ['street'], unique=False)
op.create_table('org',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('created_by', sa.Integer(), nullable=False),
sa.Column('last_modified', sa.DateTime(), nullable=True),
sa.Column('last_modified_by', sa.Integer(), nullable=False),
sa.Column('type_code', sa.String(length=15), nullable=False),
sa.Column('status_code', sa.String(length=15), nullable=False),
sa.Column('name', sa.String(length=250), nullable=True),
sa.Column('contact1', sa.Integer(), nullable=True),
sa.Column('contact2', sa.Integer(), nullable=True),
sa.Column('preferred_payment', sa.String(length=15), nullable=False),
sa.ForeignKeyConstraint(['contact1'], ['contact.id'], ),
sa.ForeignKeyConstraint(['contact2'], ['contact.id'], ),
sa.ForeignKeyConstraint(['created_by'], ['user.id'], ),
sa.ForeignKeyConstraint(['last_modified_by'], ['user.id'], ),
sa.ForeignKeyConstraint(['preferred_payment'], ['payment_type.code'], ),
sa.ForeignKeyConstraint(['status_code'], ['org_status.code'], ),
sa.ForeignKeyConstraint(['type_code'], ['org_type.code'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_index(op.f('ix_org_name'), 'org', ['name'], unique=False)
op.create_table('affiliation',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('entity', sa.Integer(), nullable=False),
sa.Column('org', sa.Integer(), nullable=False),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('created_by', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['created_by'], ['user.id'], ),
sa.ForeignKeyConstraint(['entity'], ['entity.id'], ),
sa.ForeignKeyConstraint(['org'], ['org.id'], ),
sa.PrimaryKeyConstraint('id')
)
op.create_table('membership',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('user', sa.Integer(), nullable=False),
sa.Column('org', sa.Integer(), nullable=False),
sa.Column('membership_type', sa.String(length=15), nullable=False),
sa.ForeignKeyConstraint(['membership_type'], ['membership_type.code'], ),
sa.ForeignKeyConstraint(['org'], ['org.id'], ),
sa.ForeignKeyConstraint(['user'], ['user.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('phone_number_', sa.String(length=16), nullable=True))
op.create_unique_constraint(None, 'user', ['phone_number_'])
op.drop_column('user', 'phone_number')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('posts', sa.Column('thumb_url', sa.String(length=200), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'business_verification', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('authorising_user_id', sa.Integer(), nullable=True),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('updated', sa.DateTime(), nullable=True),
sa.Column('wyre_id', sa.String(), nullable=True),
sa.Column('kyc_status', sa.String(), nullable=True),
sa.Column('first_name', sa.String(), nullable=True),
sa.Column('last_name', sa.String(), nullable=True),
sa.Column('phone', sa.String(), nullable=True),
sa.Column('business_legal_name', sa.String(), nullable=True),
sa.Column('business_type', sa.String(), nullable=True),
sa.Column('tax_id', sa.String(), nullable=True),
sa.Column('website', sa.String(), nullable=True),
sa.Column('date_established', sa.String(), nullable=True),
sa.Column('country', sa.String(), nullable=True),
sa.Column('street_address', sa.String(), nullable=True),
sa.Column('street_address_2', sa.String(), nullable=True),
sa.Column('city', sa.String(), nullable=True),
sa.Column('region', sa.String(), nullable=True),
sa.Column('postal_code', sa.Integer(), nullable=True),
sa.Column('beneficial_owners',
postgresql.JSON(astext_type=sa.Text()),
nullable=True), sa.PrimaryKeyConstraint('id'))
op.create_table(
'bank_account', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('authorising_user_id', sa.Integer(), nullable=True),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('updated', sa.DateTime(), nullable=True),
sa.Column('business_verification_id', sa.Integer(), nullable=True),
sa.Column('bank_country', sa.String(), nullable=True),
sa.Column('routing_number', sa.String(), nullable=True),
sa.Column('account_number', sa.String(), nullable=True),
sa.Column('currency', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['business_verification_id'],
['business_verification.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'uploaded_document', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('authorising_user_id', sa.Integer(), nullable=True),
sa.Column('created', sa.DateTime(), nullable=True),
sa.Column('updated', sa.DateTime(), nullable=True),
sa.Column('business_verification_id', sa.Integer(), nullable=True),
sa.Column('filename', sa.String(), nullable=True),
sa.Column('file_type', sa.String(), nullable=True),
sa.Column('user_filename', sa.String(), nullable=True),
sa.Column('reference', sa.String(), nullable=True),
sa.ForeignKeyConstraint(
['business_verification_id'],
['business_verification.id'],
), sa.PrimaryKeyConstraint('id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('Mos', sa.Column('done_text', sa.String(), nullable=True))
op.add_column('Mos', sa.Column('use_latin_square', sa.Boolean(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('approved', sa.Integer(), nullable=True))
op.add_column('user', sa.Column('role', sa.String(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('about_me', sa.String(length=140), nullable=True))
op.add_column('user', sa.Column('last_seen', sa.DateTime(), nullable=True))
class SecurityGroup(model_base.BASEV2, models_v2.HasId, models_v2.HasTenant):
"""Represents a v2 quantum security group."""
name = sa.Column(sa.String(255))
description = sa.Column(sa.String(255))
external_id = sa.Column(sa.Integer, unique=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('ih_area_info',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table('ih_facility_info',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'ih_user_profile',
sa.Column('create_time', sa.DateTime(), nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=32), nullable=False),
sa.Column('password_hash', sa.String(length=128), nullable=False),
sa.Column('mobile', sa.String(length=11), nullable=False),
sa.Column('real_name', sa.String(length=32), nullable=True),
sa.Column('id_card', sa.String(length=20), nullable=True),
sa.Column('avatar_url', sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('mobile'),
sa.UniqueConstraint('name'))
op.create_table(
'ih_house_info', sa.Column('create_time', sa.DateTime(),
nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('area_id', sa.Integer(), nullable=False),
sa.Column('title', sa.String(length=64), nullable=False),
sa.Column('price', sa.Integer(), nullable=True),
sa.Column('address', sa.String(length=512), nullable=True),
sa.Column('room_count', sa.Integer(), nullable=True),
sa.Column('acreage', sa.Integer(), nullable=True),
sa.Column('unit', sa.String(length=32), nullable=True),
sa.Column('capacity', sa.Integer(), nullable=True),
sa.Column('beds', sa.String(length=64), nullable=True),
sa.Column('deposit', sa.Integer(), nullable=True),
sa.Column('min_days', sa.Integer(), nullable=True),
sa.Column('max_days', sa.Integer(), nullable=True),
sa.Column('order_count', sa.Integer(), nullable=True),
sa.Column('index_image_url', sa.String(length=256), nullable=True),
sa.ForeignKeyConstraint(
['area_id'],
['ih_area_info.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['ih_user_profile.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'ih_house_facility', sa.Column('house_id',
sa.Integer(),
nullable=False),
sa.Column('facility_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(
['facility_id'],
['ih_facility_info.id'],
), sa.ForeignKeyConstraint(
['house_id'],
['ih_house_info.id'],
), sa.PrimaryKeyConstraint('house_id', 'facility_id'))
op.create_table(
'ih_house_image', sa.Column('create_time',
sa.DateTime(),
nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('url', sa.String(length=256), nullable=False),
sa.ForeignKeyConstraint(
['house_id'],
['ih_house_info.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_table(
'ih_order_info', sa.Column('create_time', sa.DateTime(),
nullable=True),
sa.Column('update_time', sa.DateTime(), nullable=True),
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('house_id', sa.Integer(), nullable=False),
sa.Column('begin_date', sa.DateTime(), nullable=False),
sa.Column('end_date', sa.DateTime(), nullable=False),
sa.Column('days', sa.Integer(), nullable=False),
sa.Column('house_price', sa.Integer(), nullable=False),
sa.Column('amount', sa.Integer(), nullable=False),
sa.Column('status',
sa.Enum('WAIT_ACCEPT', 'WAIT_PAYMENT', 'PAID',
'WAIT_COMMENT', 'COMPLETE', 'CANCELED', 'REJECTED'),
nullable=True), sa.Column('comment',
sa.Text(),
nullable=True),
sa.ForeignKeyConstraint(
['house_id'],
['ih_house_info.id'],
), sa.ForeignKeyConstraint(
['user_id'],
['ih_user_profile.id'],
), sa.PrimaryKeyConstraint('id'))
op.create_index(op.f('ix_ih_order_info_status'),
'ih_order_info', ['status'],
unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('domain', sa.Column('name', sa.String(length=30), nullable=False))
op.drop_column('domain', 'domain')
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.add_column('task_instance',
sa.Column('operator', sa.String(length=1000), nullable=True))
op.add_column('task_instance',
sa.Column('queued_dttm', sa.DateTime(), nullable=True))
'KeyPair', 'KeyPairList',
'UserInfo',
'KeyPairInput',
'CreateKeyPair', 'ModifyKeyPair', 'DeleteKeyPair',
'Dotfile', 'MAXIMUM_DOTFILE_SIZE',
'query_owned_dotfiles',
'query_bootstrap_script',
'verify_dotfile_name'
)
MAXIMUM_DOTFILE_SIZE = 64 * 1024 # 61 KiB
keypairs = sa.Table(
'keypairs', metadata,
sa.Column('user_id', sa.String(length=256), index=True),
sa.Column('access_key', sa.String(length=20), primary_key=True),
sa.Column('secret_key', sa.String(length=40)),
sa.Column('is_active', sa.Boolean, index=True),
sa.Column('is_admin', sa.Boolean, index=True,
default=False, server_default=false()),
sa.Column('created_at', sa.DateTime(timezone=True),
server_default=sa.func.now()),
sa.Column('modified_at', sa.DateTime(timezone=True),
server_default=sa.func.now(), onupdate=sa.func.current_timestamp()),
sa.Column('last_used', sa.DateTime(timezone=True), nullable=True),
sa.Column('concurrency_used', sa.Integer),
sa.Column('rate_limit', sa.Integer),
sa.Column('num_queries', sa.Integer, server_default='0'),
# SSH Keypairs.
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('artist',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('city', sa.String(length=120), nullable=False),
sa.Column('state', sa.String(length=120), nullable=False),
sa.Column('phone', sa.String(length=120), nullable=False),
sa.Column('genres', sa.String(length=120), nullable=False),
sa.Column('image_link', sa.String(length=500), nullable=True),
sa.Column('facebook_link', sa.String(length=120), nullable=False),
sa.Column('website', sa.String(length=252), nullable=True),
sa.Column('seeking_venue', sa.Boolean(), nullable=False),
sa.Column('seeking_description', sa.String(length=252), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('venue',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(), nullable=False),
sa.Column('city', sa.String(length=120), nullable=False),
sa.Column('state', sa.String(length=120), nullable=False),
sa.Column('address', sa.String(length=120), nullable=False),
sa.Column('phone', sa.String(length=120), nullable=False),
sa.Column('image_link', sa.String(length=500), nullable=True),
sa.Column('facebook_link', sa.String(length=120), nullable=False),
sa.Column('genres', sa.String(length=120), nullable=False),
sa.Column('website', sa.String(length=252), nullable=True),
sa.Column('seeking_talent', sa.Boolean(), nullable=False),
sa.Column('seeking_description', sa.String(length=252), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('show',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('start_time', sa.DateTime(), nullable=False),
sa.Column('artist_id', sa.Integer(), nullable=False),
sa.Column('venue_id', sa.Integer(), nullable=False),
sa.ForeignKeyConstraint(['artist_id'], ['artist.id'], ),
sa.ForeignKeyConstraint(['venue_id'], ['venue.id'], ),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('user', sa.Column('edit_type', sa.String(length=50), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('db_status', sa.Column('status', sa.String(length=1), nullable=True))
def upgrade():
op.create_table(
'ml2_vlan_allocations',
sa.Column('physical_network', sa.String(length=64), nullable=False),
sa.Column('vlan_id', sa.Integer(), autoincrement=False,
nullable=False),
sa.Column('allocated', sa.Boolean(), nullable=False),
sa.PrimaryKeyConstraint('physical_network', 'vlan_id'),
sa.Index(op.f('ix_ml2_vlan_allocations_physical_network_allocated'),
'physical_network', 'allocated'))
op.create_table(
'ml2_vxlan_endpoints',
sa.Column('ip_address', sa.String(length=64), nullable=False),
sa.Column('udp_port', sa.Integer(), autoincrement=False,
nullable=False),
sa.Column('host', sa.String(length=255), nullable=True),
sa.UniqueConstraint('host', name='unique_ml2_vxlan_endpoints0host'),
sa.PrimaryKeyConstraint('ip_address'))
op.create_table(
'ml2_gre_endpoints',
sa.Column('ip_address', sa.String(length=64), nullable=False),
sa.Column('host', sa.String(length=255), nullable=True),
sa.UniqueConstraint('host', name='unique_ml2_gre_endpoints0host'),
sa.PrimaryKeyConstraint('ip_address'))
op.create_table(
'ml2_geneve_endpoints',
sa.Column('ip_address', sa.String(length=64), nullable=False),
sa.Column('host', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('ip_address'),
sa.UniqueConstraint('host', name='unique_ml2_geneve_endpoints0host'),
)
op.create_table(
'ml2_vxlan_allocations',
sa.Column('vxlan_vni', sa.Integer(), autoincrement=False,
nullable=False),
sa.Column('allocated', sa.Boolean(), nullable=False,
server_default=sa.sql.false(), index=True),
sa.PrimaryKeyConstraint('vxlan_vni'))
op.create_table(
'ml2_gre_allocations',
sa.Column('gre_id', sa.Integer(), autoincrement=False,
nullable=False),
sa.Column('allocated', sa.Boolean(), nullable=False,
server_default=sa.sql.false(), index=True),
sa.PrimaryKeyConstraint('gre_id'))
op.create_table(
'ml2_geneve_allocations',
sa.Column('geneve_vni', sa.Integer(),
autoincrement=False, nullable=False),
sa.Column('allocated', sa.Boolean(), nullable=False,
server_default=sa.sql.false(), index=True),
sa.PrimaryKeyConstraint('geneve_vni'),
)
op.create_table(
'ml2_flat_allocations',
sa.Column('physical_network', sa.String(length=64), nullable=False),
sa.PrimaryKeyConstraint('physical_network'))
op.create_table(
'ml2_network_segments',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('network_id', sa.String(length=36), nullable=False),
sa.Column('network_type', sa.String(length=32), nullable=False),
sa.Column('physical_network', sa.String(length=64), nullable=True),
sa.Column('segmentation_id', sa.Integer(), nullable=True),
sa.Column('is_dynamic', sa.Boolean(), nullable=False,
server_default=sa.sql.false()),
sa.Column('segment_index', sa.Integer(), nullable=False,
server_default='0'),
sa.ForeignKeyConstraint(['network_id'], ['networks.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'ml2_port_bindings',
sa.Column('port_id', sa.String(length=36), nullable=False),
sa.Column('host', sa.String(length=255), nullable=False,
server_default=''),
sa.Column('vif_type', sa.String(length=64), nullable=False),
sa.Column('vnic_type', sa.String(length=64), nullable=False,
server_default='normal'),
sa.Column('profile', sa.String(length=4095), nullable=False,
server_default=''),
sa.Column('vif_details', sa.String(length=4095), nullable=False,
server_default=''),
sa.ForeignKeyConstraint(['port_id'], ['ports.id'],
ondelete='CASCADE'),
sa.PrimaryKeyConstraint('port_id'))
op.create_table(
'ml2_port_binding_levels',
sa.Column('port_id', sa.String(length=36), nullable=False),
sa.Column('host', sa.String(length=255), nullable=False),
sa.Column('level', sa.Integer(), autoincrement=False, nullable=False),
sa.Column('driver', sa.String(length=64), nullable=True),
sa.Column('segment_id', sa.String(length=36), nullable=True),
sa.ForeignKeyConstraint(['port_id'], ['ports.id'], ondelete='CASCADE'),
sa.ForeignKeyConstraint(['segment_id'], ['ml2_network_segments.id'],
ondelete='SET NULL'),
sa.PrimaryKeyConstraint('port_id', 'host', 'level')
)
op.create_table(
'cisco_ml2_nexusport_bindings',
sa.Column('binding_id', sa.Integer(), nullable=False),
sa.Column('port_id', sa.String(length=255), nullable=True),
sa.Column('vlan_id', sa.Integer(), autoincrement=False,
nullable=False),
sa.Column('switch_ip', sa.String(length=255), nullable=True),
sa.Column('instance_id', sa.String(length=255), nullable=True),
sa.Column('vni', sa.Integer(), nullable=True),
sa.Column('is_provider_vlan', sa.Boolean(), nullable=False,
server_default=sa.sql.false()),
sa.PrimaryKeyConstraint('binding_id'),
)
op.create_table(
'arista_provisioned_nets',
sa.Column('tenant_id', sa.String(length=255), nullable=True,
index=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('network_id', sa.String(length=36), nullable=True),
sa.Column('segmentation_id', sa.Integer(),
autoincrement=False, nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'arista_provisioned_vms',
sa.Column('tenant_id', sa.String(length=255), nullable=True,
index=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('vm_id', sa.String(length=255), nullable=True),
sa.Column('host_id', sa.String(length=255), nullable=True),
sa.Column('port_id', sa.String(length=36), nullable=True),
sa.Column('network_id', sa.String(length=36), nullable=True),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'arista_provisioned_tenants',
sa.Column('tenant_id', sa.String(length=255), nullable=True,
index=True),
sa.Column('id', sa.String(length=36), nullable=False),
sa.PrimaryKeyConstraint('id'))
op.create_table(
'ml2_nexus_vxlan_allocations',
sa.Column('vxlan_vni', sa.Integer(), nullable=False,
autoincrement=False),
sa.Column('allocated', sa.Boolean(), nullable=False,
server_default=sa.sql.false()),
sa.PrimaryKeyConstraint('vxlan_vni')
)
op.create_table(
'ml2_nexus_vxlan_mcast_groups',
sa.Column('id', sa.String(length=36), nullable=False),
sa.Column('mcast_group', sa.String(length=64), nullable=False),
sa.Column('associated_vni', sa.Integer(), nullable=False),
sa.PrimaryKeyConstraint('id'),
sa.ForeignKeyConstraint(['associated_vni'],
['ml2_nexus_vxlan_allocations.vxlan_vni'],
ondelete='CASCADE')
)
op.create_table(
'cisco_ml2_nexus_nve',
sa.Column('vni', sa.Integer(), nullable=False),
sa.Column('switch_ip', sa.String(length=255), nullable=True),
sa.Column('device_id', sa.String(length=255), nullable=True),
sa.Column('mcast_group', sa.String(length=255), nullable=True),
sa.PrimaryKeyConstraint('vni', 'switch_ip', 'device_id'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'users',
sa.Column('profile_image', sa.String(length=64), nullable=False))
class Boudoir(base.TableBase):
"""Table de données des boudoirs sur le serveur.
Les instances de cette classe sont crées, modifiées et supprimées par
:meth:`\!boudoir <.chans.GestionChans.GestionChans.boudoir.callback>`.
"""
chan_id = autodoc_Column(sqlalchemy.BigInteger(), primary_key=True,
autoincrement=False, doc="ID Discord du salon")
nom = autodoc_Column(sqlalchemy.String(32), nullable=False,
doc="Nom du boudoir (demandé à la création)")
ts_created = autodoc_Column(sqlalchemy.DateTime(), nullable=False,
doc="Timestamp de la création")
# One-to-manys
bouderies = autodoc_OneToMany("Bouderie", back_populates="boudoir",
doc="Appartenances à ce boudoir")
def __repr__(self):
"""Return repr(self)."""
return f"<Boudoir #{self.chan_id} ({self.nom})>"
@property
def chan(self):
"""discord.TextChannel: Salon Discord correspondant à ce boudoir.
Raises:
ValueError: pas de membre correspondant
~ready_check.NotReadyError: bot non connecté
(:obj:`.config.guild` vaut ``None``)
"""
result = config.guild.get_channel(self.chan_id)
if not result:
raise ValueError(f"Boudoir.chan : pas de chan pour {self} !")
return result
@property
def joueurs(self):
"""Sequence[.Joueur]: Joueurs présents dans ce boudoir (read-only)"""
return [boud.joueur for boud in self.bouderies]
@property
def gerant(self):
""".bdd.Joueur: Membre du boudoir ayant les droits de gestion.
Raises:
ValueError: pas de membre avec les droits de gestion
"""
try:
return next(boud.joueur for boud in self.bouderies if boud.gerant)
except StopIteration:
raise ValueError(f"Pas de membre gérant le boudoir *{self.name}*")
async def add_joueur(self, joueur, gerant=False):
"""Ajoute un joueur sur le boudoir.
Crée la :class:`.Bouderie` correspondante et modifie les
permissions du salon.
Args:
joueur (.Joueur): Le joueur à ajouter.
gerant (bool): Si le joueur doit être ajouté avec les
permissions de gérant.
"""
now = datetime.datetime.now()
Bouderie(boudoir=self, joueur=joueur, gerant=gerant,
ts_added=now, ts_promu=now if gerant else None).add()
await self.chan.set_permissions(joueur.member, read_messages=True)
async def remove_joueur(self, joueur):
"""Retire un joueur du boudoir.
Supprime la :class:`.Bouderie` correspondante et modifie les
permissions du salon.
Args:
joueur (.Joueur): Le joueur à ajouter.
"""
Bouderie.query.filter_by(boudoir=self, joueur=joueur).one().delete()
await self.chan.set_permissions(joueur.member, overwrite=None)
@classmethod
def from_channel(cls, channel):
"""Récupère le Boudoir (instance de BDD) lié à un salon Discord.
Args:
channel (discord.TextChannel): le salon concerné
Returns:
.Boudoir: Le salon correspondant.
Raises:
ValueError: boudoir introuvable en base
~ready_check.NotReadyError: session non initialisée
(:obj:`.config.session` vaut ``None``)
"""
boudoir = cls.query.get(channel.id)
if not boudoir:
raise ValueError("Boudoir.from_channel : "
f"pas de boudoir en base pour `{channel.mention}` !")
return boudoir
