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