class Data(db.Model): """ Attribute metadata. Gives some informations about the data columns """ __tablename__ = 'tjs_data' pkid = db.Column(db.Integer, primary_key=True) dataset = db.relationship( 'Dataset', backref=db.backref('datas', lazy='dynamic') ) dataset_id = db.Column(db.Integer, db.ForeignKey('tjs_datasets.pkid')) isframeworkkey = db.Column(db.Boolean) name = db.Column(db.String, nullable=False) type = db.Column(xmldtypes, default="string") length = db.Column(db.Integer, default=0) purpose = db.Column(db.String, default="Attribute") title = db.Column(db.String) abstract = db.Column(db.Text) values = db.Column( ENUM('count', 'measure', 'nominal', 'ordinal', name='tjs_valuetype'), default='ordinal') # extensions curves = db.Column(emp_chart_rules) jointoframeworkkey = db.Column(db.Integer, db.ForeignKey('tjs_frameworkkey.pkid')) bars = db.Column(emp_chart_rules) tabular = db.Column(emp_chart_rules) brush = db.Column(emp_chart_rules) map = db.Column(emp_chart_rules) map_mode = db.Column(ENUM('flow-source', 'flow-dest', 'standard', name='emp_mapmodes')) def __repr__(self): return '{} : {}'.format(self.dataset.dataseturi, self.name)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_table('manga_tags_link') op.drop_index('manga_releases_source_site_id_idx', table_name='manga_releases') op.drop_index(op.f('ix_manga_releases_state'), table_name='manga_releases') op.drop_index(op.f('ix_manga_releases_source_site'), table_name='manga_releases') op.drop_index(op.f('ix_manga_releases_source_id'), table_name='manga_releases') op.drop_table('manga_releases') op.drop_table('hentai_tags_link') op.drop_index(op.f('ix_hentai_releases_state'), table_name='hentai_releases') op.drop_index(op.f('ix_hentai_releases_source_site'), table_name='hentai_releases') op.drop_index(op.f('ix_hentai_releases_source_id'), table_name='hentai_releases') op.drop_index('hentai_releases_source_site_id_idx', table_name='hentai_releases') op.drop_table('hentai_releases') op.drop_table('release_files') op.drop_index(op.f('ix_manga_tags_tag'), table_name='manga_tags') op.drop_table('manga_tags') op.drop_index(op.f('ix_hentai_tags_tag'), table_name='hentai_tags') op.drop_table('hentai_tags') ENUM(name='filetype_enum').drop(op.get_bind(), checkfirst=False) ENUM(name='dlstate_enum').drop(op.get_bind(), checkfirst=False) ENUM(name='dirtype_enum').drop(op.get_bind(), checkfirst=False)
def upgrade(): context = op.get_context() # Upgrading to this revision WILL clear your directmedia values. if context.bind.dialect.name == 'sqlite': with op.batch_alter_table('sippeers') as batch_op: batch_op.alter_column('directmedia', type_=new_type) elif context.bind.dialect.name != 'postgresql': op.alter_column('sippeers', 'directmedia', type_=new_type, existing_type=old_type) else: enum = ENUM("yes", "no", "nonat", "update", "outgoing", name="sip_directmedia_values_v2") enum.create(op.get_bind(), checkfirst=False) op.execute('ALTER TABLE sippeers ALTER COLUMN directmedia TYPE' ' sip_directmedia_values_v2 USING' ' directmedia::text::sip_directmedia_values_v2') ENUM(name="sip_directmedia_values").drop(op.get_bind(), checkfirst=False)
def upgrade(): enum = ENUM(u'289', u'619', u'679', u'889', u'789', u'998', u'589', u'380', u'798', u'689', u'89', u'498', u'489', u'389', u'189', u'298', name="ck_region", create_type=False) enum.create(op.get_bind(), checkfirst=False) op.create_table( 'region_percentage', sa.Column('id', sa.Integer(), nullable=False), sa.Column('percentage', sa.Integer(), nullable=True), sa.Column('region', enum, nullable=False), sa.Column('activity_id', sa.Unicode(), nullable=False), sa.ForeignKeyConstraint(['activity_id'], ['activity.iati_identifier'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id'))
class Candidacy(Base): __tablename__ = 'candidacies' id = sa.Column(sa.Integer, primary_key=True) candidate_id = sa.Column(sa.Integer) candidate = sa.orm.relationship( 'Candidate', primaryjoin='Candidacy.candidate_id==Candidate.id', foreign_keys='Candidacy.candidate_id', remote_side='Candidate.id', backref='candidacies') election_type = sa.Column(sa.String) election_year = sa.Column(sa.Integer) # Incumbent, challenger, open seat race_type = sa.Column( ENUM('incumbent', 'challenger', 'open seat', 'retired', name='candidacy_race_type')) outcome = sa.Column(ENUM('won', 'lost', name='candidacy_outcome')) fair_campaign = sa.Column(sa.Boolean) limits_off = sa.Column(sa.Boolean) limits_off_reason = sa.Column(sa.String) def __repr__(self): return '<Candidacy %r %r, (%r %r)>' % ( self.candidate.first_name, self.candidate.last_name, self.election_year, self.election_type) def as_dict(self): return {c.name: getattr(self, c.name) for c in self.__table__.columns}
def upgrade(): ENUM(u'gcc', u'g++', u'java', name=u'user_program_language_enum').create(op.get_bind(), checkfirst=False) op.alter_column('user', 'program_language', existing_type=sa.Enum(u'gcc', u'g++', u'java', name=u'user_program_language_enum'), nullable=True) op.alter_column('user_deleted', 'program_language', existing_type=sa.Enum(u'male', u'female', name='user_gender'), nullable=True) ENUM(u'gcc', u'g++', u'java', name=u'solution_program_language_enum').create(op.get_bind(), checkfirst=False) op.alter_column('solution', 'program_language', existing_type=sa.Enum(u'gcc', u'g++', u'java', name=u'solution_program_language_enum'), nullable=False)
def upgrade(): # If we don't do this, Alembic won't create the type automatically enum_type = ENUM('yahoo', 'google', 'kofia', name='asset_value_source') enum_type.create(op.get_bind()) op.add_column('asset_value', sa.Column('source', enum_type, nullable=False))
class SubOrder(Model): __tablename__ = 'sub_order' title = Column(String, nullable=True) order_id = Column(UUIDType(binary=False), ForeignKey('order.id'), nullable=False) total_price = Column(Float) receiver_id = Column(UUIDType(binary=False), ForeignKey('receivers.id')) address_id = Column(UUIDType(binary=False), ForeignKey('addresses.id')) delivery_type = Column(ENUM('fast', 'scheduled', name='delivery_typess')) delivery_date = Column(DateTime) delivery_time = Column(String) message = Column(String) order_status = Column( ENUM('pending', 'ongoing', 'done', name='sub_order_status')) is_cart = Column(Boolean, unique=False, default=True) @hybrid_property def product(self): return Product.query.filter_by(id=str(self.product_id)).first() @hybrid_property def address(self): return Address.query.filter_by(id=str(self.address_id)).first() @hybrid_property def receiver(self): return Receiver.query.filter_by(id=str(self.receiver_id)).first() @hybrid_property def extra_orders(self): return ExtraOrder.query.filter_by(suborder_id=str(self.id)).all()
def upgrade(): # If we don't do this, Alembic won't create the type automatically enum_type = ENUM("yahoo", "google", "kofia", name="asset_value_source") enum_type.create(op.get_bind()) op.add_column("asset_value", sa.Column("source", enum_type, nullable=False))
class Pickup(Base): __tablename__ = "pickups" id = sa.Column("id", sa.Integer, primary_key=True) firebase_id = sa.Column("firebase_id", sa.String, nullable=False) firebase_run_id = sa.Column("firebase_run_id", sa.String, nullable=False) centerline_id =\ sa.Column("centerline_id", sa.Integer, sa.ForeignKey("centerlines.id"), nullable=False) type = sa.Column("type", ENUM(*RUBBISH_TYPES, name="rubbish_type"), nullable=False) timestamp = sa.Column("timestamp", sa.DateTime, nullable=False) geometry = sa.Column("geometry", Geometry("POINT"), nullable=False) snapped_geometry = sa.Column("snapped_geometry", Geometry("POINT"), nullable=False) linear_reference = sa.Column("linear_reference", sa.Float(precision=3), nullable=False) curb = sa.Column("curb", ENUM('left', 'right', 'middle', name='curb'), nullable=False) centerline = relationship("Centerline", back_populates="pickups") def __repr__(self): return ( f"""<Pickup id={self.id} """ f"""geometry={self.geometry} snapped_geometry={self.snapped_geometry} """ f"""centerline_id={self.centerline_id} firebase_id={self.firebase_id} """ f"""firebase_run_id={self.firebase_run_id} """ f"""type={self.type} timestamp={self.timestamp} """ f"""linear_reference={self.linear_reference} curb={self.curb}>""")
def downgrade(): context = op.get_context() op.execute(tcr.update().where(tcr.c.directmedia == u'outgoing').values( directmedia=None)) if context.bind.dialect.name != 'postgresql': op.alter_column('sippeers', 'directmedia', type_=old_type, existing_type=new_type) else: enum = ENUM("yes", "no", "nonat", "update", name="sip_directmedia_values") enum.create(op.get_bind(), checkfirst=False) op.execute('ALTER TABLE sippeers ALTER COLUMN directmedia TYPE' ' sip_directmedia_values USING' ' directmedia::text::sip_directmedia_values') ENUM(name="sip_directmedia_values_v2").drop(op.get_bind(), checkfirst=False)
def downgrade(): # ### commands auto generated by Alembic - please adjust! ### op.drop_constraint('alert_affected_services_alert_id_fkey', 'alert_affected_services', type_='foreignkey') op.drop_constraint('alert_affected_services_route_id_fkey', 'alert_affected_services', type_='foreignkey') op.drop_constraint('alert_effect_period_alert_id_fkey', 'alert_effect_period', type_='foreignkey') op.drop_constraint('alert_events_routes_fkey', 'alert_events', type_='foreignkey') op.drop_constraint('alert_events_day_check', 'alert_events', type_='check') op.drop_table('alert_events') op.drop_table('alert_affected_services') op.drop_table('alert_effect_period') op.drop_table('alerts') op.drop_table('stops') op.drop_table('routes') ENUM(name="delayaccuracy").drop(op.get_bind(), checkfirst=False) ENUM(name="direction").drop(op.get_bind(), checkfirst=False)
def upgrade(): ### commands auto generated by Alembic - please adjust! ### enum = ENUM('unverified', 'valid', 'rejected', name='nu_item_enum', create_type=False) enum.create(op.get_bind(), checkfirst=True) op.execute( "ALTER TABLE nu_release_item ALTER COLUMN reviewed DROP DEFAULT") op.alter_column( 'nu_release_item', 'reviewed', existing_type=sa.BOOLEAN(), type_=enum, existing_nullable=False, nullable=False, server_default=sa.text("'unverified'"), existing_server_default=sa.text('false'), postgresql_using= "CASE WHEN reviewed = false THEN 'unverified'::nu_item_enum ELSE 'valid'::nu_item_enum END" ) op.execute( "ALTER TABLE nu_release_item ALTER COLUMN reviewed SET DEFAULT 'unverified'" )
def downgrade(): context = op.get_context() op.drop_column('ps_endpoints', 'dtls_fingerprint') if context.bind.dialect.name == 'postgresql': enum = ENUM(*SHA_HASH_VALUES, name=SHA_HASH_NAME) enum.drop(op.get_bind(), checkfirst=False)
def upgrade(): # If we don't do this, Alembic won't create the type automatically enum_type = ENUM('yahoo', 'google', 'kofia', name='asset_value_source') enum_type.create(op.get_bind()) op.add_column( 'asset_value', sa.Column('source', enum_type, nullable=False))
def upgrade(): enum = ENUM( u'10', u'15', u'21', u'22', u'23', u'30', u'40', u'60', u'70', u'80', name="ck_organisation_type", create_type=False ) enum.create(op.get_bind(), checkfirst=False) op.add_column('organisation', sa.Column('type', enum, nullable=True))
def downgrade(): if op.get_context().bind.dialect.name == 'mssql': op.drop_constraint('ck_ps_globals_taskprocessor_overload_trigger_pjsip_taskprocessor_overload_trigger_values', 'ps_globals') op.drop_column('ps_globals', 'taskprocessor_overload_trigger') if context.bind.dialect.name == 'postgresql': enum = ENUM(*PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_VALUES, name=PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_NAME) enum.drop(op.get_bind(), checkfirst=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### trialoutcome = ENUM( "BOTH_SAME", "FIRST_SAME", "SECOND_SAME", "NONE_SAME", name="trialoutcome" ) trialoutcome.create(op.get_bind()) op.add_column( "drug_categorizations", sa.Column("categorization", trialoutcome, nullable=True) )
class Committee(Base): __tablename__ = 'committees' id = sa.Column(sa.Integer, primary_key=True) type = sa.Column(sa.String) state_committee = sa.Column(sa.Boolean) state_id = sa.Column(sa.Integer) local_committee = sa.Column(sa.Boolean) local_id = sa.Column(sa.Integer) refer_name = sa.Column(sa.String) name = sa.Column(sa.String) address1 = sa.Column(sa.String) address2 = sa.Column(sa.String) address3 = sa.Column(sa.String) city = sa.Column(sa.String) state = sa.Column(sa.String) zipcode = sa.Column(sa.String) active = sa.Column(sa.Boolean) status_date = sa.Column(sa.DateTime) creation_date = sa.Column(sa.DateTime) creation_amount = sa.Column(DOUBLE_PRECISION) disp_funds_return = sa.Column(sa.Boolean) disp_funds_political_committee = sa.Column(sa.Boolean) disp_funds_charity = sa.Column(sa.Boolean) disp_funds_95 = sa.Column(sa.Boolean) disp_funds_description = sa.Column(sa.Text) # These use the same ENUM. Need to create it separately candidate_position = sa.Column( ENUM('support', 'oppose', name='committee_position', create_type=False)) policy_position = sa.Column( ENUM('support', 'oppose', name='committee_position', create_type=False)) party = sa.Column(sa.String) purpose = sa.Column(sa.Text) candidates = sa.orm.relationship( 'Candidate', primaryjoin='Committee.id==candidate_committees.c.committee_id', secondaryjoin='candidate_committees.c.candidate_id==Candidate.id', secondary=candidate_committees, backref='committees') officers = sa.orm.relationship( 'Officer', primaryjoin='Committee.id==officer_committees.c.committee_id', secondaryjoin='officer_committees.c.officer_id==Officer.id', secondary=officer_committees, backref='committees') def __repr__(self): return '<Committee %r>' % self.name def as_dict(self): d = {c.name: getattr(self, c.name) for c in self.__table__.columns} d['officers'] = [o.as_dict() for o in self.officers]
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### enum = ENUM('plain_text', 'markdown', name='commentreplytype') enum.create(op.get_bind(), checkfirst=True) op.add_column( 'comment_reply', sa.Column('reply_type', enum, server_default='plain_text', nullable=False))
def downgrade(): yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=False) if op.get_context().bind.dialect.name != 'mssql': op.alter_column('ps_transports', 'verify_server', type_=yesno_values, new_column_name='verifiy_server') else: op.alter_column('ps_transports', 'verify_server', existing_type=yesno_values, type_=sa.String(3), new_column_name='verifiy_server') yesno_values = ENUM(*YESNO_VALUES, name=YESNO_NAME, create_type=True) op.alter_column('ps_transports', 'verifiy_server', existing_type=sa.String(3), type_=yesno_values)
def upgrade(): ''' Add the column merge_status to the table pull_requests. ''' enum = ENUM('NO_CHANGE', 'FFORWARD', 'CONFLICTS', 'MERGE', name='merge_status_enum', create_type=False) enum.create(op.get_bind(), checkfirst=False) op.add_column( 'pull_requests', sa.Column('merge_status', enum, nullable=True) )
def upgrade(): context = op.get_context() if context.bind.dialect.name == 'postgresql': enum = ENUM(*SHA_HASH_VALUES, name=SHA_HASH_NAME) enum.create(op.get_bind(), checkfirst=False) op.add_column('ps_endpoints', sa.Column('dtls_fingerprint', ENUM(*SHA_HASH_VALUES, name=SHA_HASH_NAME, create_type=False)))
def upgrade(): op.create_table( 'activity_log', sa.Column('id', sa.Integer, primary_key=True, autoincrement=True), sa.Column('box_code', sa.Integer(), nullable=False), sa.Column('worker_id', sa.Integer, sa.ForeignKey('worker.id')), sa.Column('payload', sa.Integer()), sa.Column('type', ENUM(ActivityType, name="type")), sa.Column('status', ENUM(ActivityStatus, name="status")), sa.Column('local_time', sa.DateTime()), sa.Column('server_time', sa.DateTime(), default=dt.now))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### gender_column = sa.Column( 'gender', sa.Enum('male', 'female', 'unspecified')) if DATABASE_URL[:8] == 'postgres': gender_enum = ENUM( 'male', 'female', 'unspecified', name='alert_gender') gender_enum.create(op.get_bind(), checkfirst=False) gender_column = sa.Column('gender', gender_enum) op.add_column('alerts', sa.Column('age', sa.Integer())) op.add_column('alerts', gender_column)
def downgrade(): if op.get_context().bind.dialect.name == 'mssql': op.drop_constraint( 'ck_ps_globals_taskprocessor_overload_trigger_pjsip_taskprocessor_overload_trigger_values', 'ps_globals') op.drop_column('ps_globals', 'taskprocessor_overload_trigger') if context.bind.dialect.name == 'postgresql': enum = ENUM(*PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_VALUES, name=PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_NAME) enum.drop(op.get_bind(), checkfirst=False)
def downgrade(): context = op.get_context() if op.get_context().bind.dialect.name == 'mssql': op.drop_constraint('ck_ps_endpoints_dtls_fingerprint_sha_hash_values', 'ps_endpoints') op.drop_column('ps_endpoints', 'dtls_fingerprint') if context.bind.dialect.name == 'postgresql': enum = ENUM(*SHA_HASH_VALUES, name=SHA_HASH_NAME) enum.drop(op.get_bind(), checkfirst=False)
def upgrade(): ''' Add the column merge_status to the table pull_requests. ''' enum = ENUM('NO_CHANGE', 'FFORWARD', 'CONFLICTS', 'MERGE', name='merge_status_enum', create_type=False) enum.create(op.get_bind(), checkfirst=False) op.add_column('pull_requests', sa.Column('merge_status', enum, nullable=True))
def upgrade(): # Create the new enum ast_bool_values = ENUM(*AST_BOOL_VALUES, name=AST_BOOL_NAME, create_type=False) if op.get_context().bind.dialect.name == 'postgresql': ast_bool_values.create(op.get_bind(), checkfirst=False) # There is no direct way to convert from Integer to ENUM that is # not database specific so we transition through a string type. op.alter_column('ps_endpoints', 'mwi_subscribe_replaces_unsolicited', type_=sa.String(5)) op.alter_column('ps_endpoints', 'mwi_subscribe_replaces_unsolicited', type_=ast_bool_values)
def upgrade(): context = op.get_context() if context.bind.dialect.name == 'postgresql': enum = ENUM(*PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_VALUES, name=PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_NAME) enum.create(op.get_bind(), checkfirst=False) op.add_column('ps_globals', sa.Column('taskprocessor_overload_trigger', sa.Enum(*PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_VALUES, name=PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_NAME)))
def upgrade(): # Create the new enum ast_bool_values = ENUM(*AST_BOOL_VALUES, name=AST_BOOL_NAME, create_type=False) if op.get_context().bind.dialect.name == 'postgresql': ast_bool_values.create(op.get_bind(), checkfirst=False) # There is no direct way to convert from Integer to ENUM that is # not database specific so we transition through a string type. op.alter_column('ps_endpoints', 'mwi_subscribe_replaces_unsolicited', type_=sa.String(5)) op.alter_column('ps_endpoints', 'mwi_subscribe_replaces_unsolicited', type_=ast_bool_values, postgresql_using='mwi_subscribe_replaces_unsolicited::{0}'.format(AST_BOOL_NAME))
def upgrade(): context = op.get_context() if context.bind.dialect.name == 'postgresql': enum = ENUM(*SHA_HASH_VALUES, name=SHA_HASH_NAME) enum.create(op.get_bind(), checkfirst=False) op.add_column( 'ps_endpoints', sa.Column( 'dtls_fingerprint', ENUM(*SHA_HASH_VALUES, name=SHA_HASH_NAME, create_type=False)))
def downgrade(): op.alter_column('user', 'program_language', existing_type=sa.VARCHAR(length=64), nullable=True) op.alter_column('user_deleted', 'program_language', existing_type=sa.VARCHAR(length=64), nullable=True) op.alter_column('solution', 'program_language', existing_type=sa.VARCHAR(length=64), nullable=False) ENUM(name=u'user_program_language_enum').drop(op.get_bind(), checkfirst=False) ENUM(name=u'solution_program_language_enum').drop(op.get_bind(), checkfirst=False)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### enum = ENUM("unknown", "incoming_text", "incoming_call", "outgoing_call", name='contact_types') enum.create(op.get_bind(), checkfirst=False) op.add_column( 'calls', sa.Column('contact_type', sa.Enum(name='contact_types'), nullable=True))
def upgrade(): ### commands auto generated by Alembic - please adjust! ### gender_column = sa.Column('gender', sa.Enum('male', 'female', 'unspecified')) if DATABASE_URL[:8] == 'postgres': gender_enum = ENUM('male', 'female', 'unspecified', name='alert_gender') gender_enum.create(op.get_bind(), checkfirst=False) gender_column = sa.Column('gender', gender_enum) op.add_column('alerts', sa.Column('age', sa.Integer())) op.add_column('alerts', gender_column)
class Candidate(BaseModelWithTimestamps): fec_id = db.Column(db.String(9), unique=True, nullable=False) name = db.Column(db.String) party_affiliation = db.Column(db.String(3)) election_year = db.Column(db.SmallInteger, nullable=False) office = db.Column(ENUM("H", "S", name="office"), nullable=False) office_state = db.Column(db.String(2), nullable=False) office_district = db.Column(db.String(2)) incumbent_challenger_status = db.Column( ENUM("C", "I", "O", name="incumbent_challenger_status") ) principal_campaign_committee_fec_id = db.Column(db.String(9)) pledge_date = db.Column(db.Date)
def upgrade(): # ### commands auto generated by Alembic - please adjust! ### enum = ENUM('visible', 'archived', 'deleted', name='coursestate') enum.create(op.get_bind(), checkfirst=True) op.add_column( 'Course', sa.Column('state', enum, server_default='visible', nullable=False)) op.add_column( 'Course', sa.Column('updated_at', sa.TIMESTAMP(timezone=True), nullable=False, server_default='NOW()'))
def upgrade(): context = op.get_context() if context.bind.dialect.name == 'postgresql': enum = ENUM(*PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_VALUES, name=PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_NAME) enum.create(op.get_bind(), checkfirst=False) op.add_column( 'ps_globals', sa.Column( 'taskprocessor_overload_trigger', sa.Enum(*PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_VALUES, name=PJSIP_TASKPROCESSOR_OVERLOAD_TRIGGER_NAME)))
def destroy_db(): metadata = MetaData() metadata.bind = db.engine metadata.reflect() tables = list(metadata.sorted_tables) while len(tables): for table in tables: try: table.drop(checkfirst=True) tables.remove(table) except InternalError: pass for enum in inspect(db.engine).get_enums(): enum = ENUM(name=enum['name']) enum.drop(bind=db.engine, checkfirst=True)
def evilshit(): """EVIL: Delete all data and recreate the database.""" delete_index() db.drop_all() from sqlalchemy import MetaData, inspect from sqlalchemy.dialects.postgresql import ENUM metadata = MetaData() metadata.bind = db.engine metadata.reflect() for table in metadata.sorted_tables: table.drop(checkfirst=True) for enum in inspect(db.engine).get_enums(): enum = ENUM(name=enum['name']) enum.drop(bind=db.engine, checkfirst=True) init()
def upgrade(): enum = ENUM( u'289', u'619', u'679', u'889', u'789', u'998', u'589', u'380', u'798', u'689', u'89', u'498', u'489', u'389', u'189', u'298', name="ck_region", create_type=False ) enum.create(op.get_bind(), checkfirst=False) op.create_table( 'region_percentage', sa.Column('id', sa.Integer(), nullable=False), sa.Column('percentage', sa.Integer(), nullable=True), sa.Column('region', enum, nullable=False), sa.Column('activity_id', sa.Unicode(), nullable=False), sa.ForeignKeyConstraint(['activity_id'], ['activity.iati_identifier'], ondelete='CASCADE'), sa.PrimaryKeyConstraint('id') )
def upgrade(): package_type = ENUM( "bdist_dmg", "bdist_dumb", "bdist_egg", "bdist_msi", "bdist_rpm", "bdist_wheel", "bdist_wininst", "sdist", name="package_type", create_type=False, ) package_type.create(op.get_bind(), checkfirst=False) op.execute( """ ALTER TABLE release_files ALTER COLUMN packagetype TYPE package_type USING packagetype::package_type """ )
def upgrade(): context = op.get_context() # Upgrading to this revision WILL clear your directmedia values. if context.bind.dialect.name != "postgresql": op.alter_column("sippeers", "directmedia", type_=new_type, existing_type=old_type) else: enum = ENUM("yes", "no", "nonat", "update", "outgoing", name="sip_directmedia_values_v2") enum.create(op.get_bind(), checkfirst=False) op.execute( "ALTER TABLE sippeers ALTER COLUMN directmedia TYPE" " sip_directmedia_values_v2 USING" " directmedia::text::sip_directmedia_values_v2" ) ENUM(name="sip_directmedia_values").drop(op.get_bind(), checkfirst=False)
def downgrade(): context = op.get_context() if context.bind.dialect.name != 'postgresql': op.alter_column('ps_endpoints', 'dtmf_mode', type_=old_type, existing_type=new_type) else: enum = ENUM('rfc4733', 'inband', 'info', name='pjsip_dtmf_mode_values') enum.create(op.get_bind(), checkfirst=False) op.execute('ALTER TABLE ps_endpoints ALTER COLUMN dtmf_mode TYPE' ' pjsip_dtmf_mode_values USING' ' dtmf_mode::text::pjsip_dtmf_mode_values') ENUM(name="pjsip_dtmf_mode_values_v2").drop(op.get_bind(), checkfirst=False)
def upgrade(): context = op.get_context() # Upgrading to this revision WILL clear your directmedia values. if context.bind.dialect.name != 'postgresql': op.alter_column('ps_endpoints', 'dtmf_mode', type_=new_type, existing_type=old_type) else: enum = ENUM('rfc4733', 'inband', 'info', 'auto', name='pjsip_dtmf_mode_values_v2') enum.create(op.get_bind(), checkfirst=False) op.execute('ALTER TABLE ps_endpoints ALTER COLUMN dtmf_mode TYPE' ' pjsip_dtmf_mode_values_v2 USING' ' dtmf_mode::text::pjsip_dtmf_mode_values_v2') ENUM(name="pjsip_dtmf_mode_values").drop(op.get_bind(), checkfirst=False)
def upgrade(): ### commands auto generated by Alembic - please adjust! ### enum = ENUM('unverified', 'valid', 'rejected', name='nu_item_enum', create_type=False) enum.create(op.get_bind(), checkfirst=True) op.execute("ALTER TABLE nu_release_item ALTER COLUMN reviewed DROP DEFAULT") op.alter_column('nu_release_item', 'reviewed', existing_type=sa.BOOLEAN(), type_=enum, existing_nullable=False, nullable=False, server_default=sa.text("'unverified'"), existing_server_default=sa.text('false'), postgresql_using="CASE WHEN reviewed = false THEN 'unverified'::nu_item_enum ELSE 'valid'::nu_item_enum END" ) op.execute("ALTER TABLE nu_release_item ALTER COLUMN reviewed SET DEFAULT 'unverified'")
def downgrade(): context = op.get_context() op.execute(tcr.update().where(tcr.c.directmedia == u"outgoing").values(directmedia=None)) if context.bind.dialect.name != "postgresql": op.alter_column("sippeers", "directmedia", type_=old_type, existing_type=new_type) else: enum = ENUM("yes", "no", "nonat", "update", name="sip_directmedia_values") enum.create(op.get_bind(), checkfirst=False) op.execute( "ALTER TABLE sippeers ALTER COLUMN directmedia TYPE" " sip_directmedia_values USING" " directmedia::text::sip_directmedia_values" ) ENUM(name="sip_directmedia_values_v2").drop(op.get_bind(), checkfirst=False)
def downgrade(): provider_enum = ENUM("loadtesting", "firetext", "mmg", "ses", "twilio", name="providers", create_type=True) provider_enum.create(op.get_bind(), checkfirst=False) op.add_column("provider_statistics", sa.Column("provider", provider_enum, autoincrement=False, nullable=True)) op.alter_column("provider_statistics", "provider_id", existing_type=postgresql.UUID(), nullable=True) op.add_column("provider_rates", sa.Column("provider", provider_enum, autoincrement=False, nullable=True)) op.alter_column("provider_rates", "provider_id", existing_type=postgresql.UUID(), nullable=True) op.execute( "UPDATE provider_rates set provider = 'mmg' where provider_id = (select id from provider_details where identifier = 'mmg')" ) op.execute( "UPDATE provider_rates set provider = 'firetext' where provider_id = (select id from provider_details where identifier = 'firetext')" ) op.execute( "UPDATE provider_rates set provider = 'ses' where provider_id = (select id from provider_details where identifier = 'ses')" ) op.execute( "UPDATE provider_rates set provider = 'loadtesting' where provider_id = (select id from provider_details where identifier = 'loadtesting')" ) op.execute( "UPDATE provider_statistics set provider = 'mmg' where provider_id = (select id from provider_details where identifier = 'mmg')" ) op.execute( "UPDATE provider_statistics set provider = 'firetext' where provider_id = (select id from provider_details where identifier = 'firetext')" ) op.execute( "UPDATE provider_statistics set provider = 'ses' where provider_id = (select id from provider_details where identifier = 'ses')" ) op.execute( "UPDATE provider_statistics set provider = 'loadtesting' where provider_id = (select id from provider_details where identifier = 'loadtesting')" ) op.alter_column("provider_rates", "provider", existing_type=postgresql.UUID(), nullable=False) op.alter_column("provider_statistics", "provider", existing_type=postgresql.UUID(), nullable=False)
def downgrade(): context = op.get_context() op.execute(tcr.update().where(tcr.c.directmedia==u'outgoing') .values(directmedia=None)) if context.bind.dialect.name == 'sqlite': with op.batch_alter_table('sippeers') as batch_op: batch_op.alter_column('directmedia', type_=old_type) elif context.bind.dialect.name != 'postgresql': op.alter_column('sippeers', 'directmedia', type_=old_type, existing_type=new_type) else: enum = ENUM("yes", "no", "nonat", "update", name="sip_directmedia_values") enum.create(op.get_bind(), checkfirst=False) op.execute('ALTER TABLE sippeers ALTER COLUMN directmedia TYPE' ' sip_directmedia_values USING' ' directmedia::text::sip_directmedia_values') ENUM(name="sip_directmedia_values_v2").drop(op.get_bind(), checkfirst=False)