def upgrade(): op.create_table( 'notification_user', sa.Column('objectid', sa.CHAR(32), nullable=False), sa.Column('email', NVARCHAR2(255), nullable=False), sa.Column('full_name', NVARCHAR2(255), nullable=True), sa.PrimaryKeyConstraint('objectid'), )
def upgrade(): op.execute('DELETE FROM comment_replies') op.drop_column('comment_replies', 'parent') op.add_column( 'comment_replies', sa.Column('parent_table', NVARCHAR2(255), nullable=True), ) op.add_column( 'comment_replies', sa.Column('parent_id', NVARCHAR2(255), nullable=True), )
def upgrade(): op.execute("CREATE SEQUENCE DATASETS_SEQ") op.create_table( 'datasets', sa.Column('OBJECTID', sa.Integer, nullable=False), sa.Column('USER_ID', NVARCHAR2(255), nullable=True), sa.Column('DATE', sa.DateTime, nullable=True), sa.Column('COMMENT', NCLOB, nullable=True), sa.PrimaryKeyConstraint('OBJECTID'), ) op.add_column( 'data_habitattype_reg', sa.Column('cons_dataset_id', sa.Integer, nullable=True), ) op.add_column( 'data_species_regions', sa.Column('cons_dataset_id', sa.Integer, nullable=True), ) op.execute(u"INSERT INTO DATASETS(OBJECTID, \"DATE\", \"COMMENT\") " u"VALUES (" u"DATASETS_SEQ.nextval, " u"TO_DATE('2013-10-01 13:30:00', 'YYYY-MM-DD HH24:MI:SS'), " u"'Consultare publica'" u") ") op.execute("UPDATE data_habitattype_reg SET cons_dataset_id = 1") op.execute("UPDATE data_species_regions SET cons_dataset_id = 1")
def upgrade(): op.create_table( 'LU_GRUP_SPECIE', sa.Column('OID', sa.Integer(), nullable=False), sa.Column('CODE', NVARCHAR2(255), nullable=True), sa.Column('DESCRIPTION', NVARCHAR2(255), nullable=True), ) lu_grup_specie = table( 'lu_grup_specie', column('oid', sa.Integer), column('code', NVARCHAR2), column('description', NVARCHAR2), ) op.bulk_insert(lu_grup_specie, [ { 'oid': 1, 'code': "A", 'description': "Amfibieni" }, { 'oid': 2, 'code': "F", 'description': "Pesti" }, { 'oid': 3, 'code': "M", 'description': "Mamifere" }, { 'oid': 4, 'code': "P", 'description': "Plante" }, { 'oid': 5, 'code': "R", 'description': "Reptile" }, { 'oid': 6, 'code': "I", 'description': "Nevertebrate" }, ])
def upgrade(): op.create_table( 'datasets', sa.Column('id', sa.Integer, nullable=False), sa.Column('name', NVARCHAR2(255), nullable=True), sa.PrimaryKeyConstraint('id'), ) for tbl in period_tables: op.add_column( tbl, sa.Column('ext_dataset_id', sa.Integer, nullable=True), )
def upgrade(): op.add_column( 'LU_BIOGEOREG', sa.Column('NUME', NVARCHAR2(50), nullable=True), ) lu_biogeoreg = table( 'lu_biogeoreg', column('objectid', sa.Integer), column('nume', NVARCHAR2), ) for objectid, nume in DATA: op.execute(lu_biogeoreg.update().where( lu_biogeoreg.c.objectid == op.inline_literal(objectid)).values( {'nume': op.inline_literal(nume)}))
def upgrade(): op.add_column( 'data_habitattype_reg', sa.Column('cons_role', NVARCHAR2(255), nullable=True), ) op.add_column( 'data_habitattype_reg', sa.Column('cons_date', sa.DateTime, nullable=True), ) op.add_column( 'data_habitattype_reg', sa.Column('cons_user_id', NVARCHAR2(255), nullable=True), ) op.add_column( 'data_habitattype_reg', sa.Column('cons_status', NVARCHAR2(255), nullable=True), ) op.add_column( 'data_habitattype_reg', sa.Column('cons_deleted', sa.Boolean, nullable=True), ) op.add_column( 'data_species_regions', sa.Column('cons_role', NVARCHAR2(255), nullable=True), ) op.add_column( 'data_species_regions', sa.Column('cons_date', sa.DateTime, nullable=True), ) op.add_column( 'data_species_regions', sa.Column('cons_user_id', NVARCHAR2(255), nullable=True), ) op.add_column( 'data_species_regions', sa.Column('cons_status', NVARCHAR2(255), nullable=True), ) op.add_column( 'data_species_regions', sa.Column('cons_deleted', sa.Boolean, nullable=True), ) op.execute("UPDATE data_habitattype_reg SET cons_role = 'assessment'") op.execute("UPDATE data_species_regions SET cons_role = 'assessment'")
def upgrade(): op.add_column( 'data_species_regions', sa.Column('cons_generalstatus', NVARCHAR2(255), nullable=True), ) op.execute("update data_species_regions set cons_generalstatus = '1'")
def upgrade(): op.add_column( 'data_habitattype_reg', sa.Column('cons_generalstatus', NVARCHAR2(255), nullable=True), ) op.execute("update data_habitattype_reg set cons_generalstatus = '1'")
tdf['qid'] = df['questionnaire_name'].map(lambda x: d[x]) tdf['tid'] = df['test_questions_id'].astype('int') tdf['p_type'] = df['type'].astype('int8') tdf['origin_options'] = df['options'].astype(str) tdf['options'] = df.apply(func, axis=1).astype(str) tdf['organ_name'] = df['organ_name'].astype(str) tdf['organ_level'] = df['organ_level'].astype(str) tdf['gather_level'] = df['gather_level'] tdf['province'] = df['province_name'].astype(str) tdf['area'] = df['area'].astype(str) print(tdf.dtypes) print(len(tdf)) print(tdf.head(1)) tdf.to_pickle('tdf.pkl') d_type = { 'qid': NVARCHAR2(64), 'tid': NUMBER(4), 'p_type': NUMBER(4), 'origin_options': NVARCHAR2(1024), 'options': NVARCHAR2(1024), 'organ_name': NVARCHAR2(64), 'organ_level': NVARCHAR2(24), 'gather_level': NVARCHAR2(24), 'province': NVARCHAR2(24), 'area': NVARCHAR2(24) } tdf.to_sql("DEV_OPTION", con=conn, if_exists='replace', index_label='id',