Python NVARCHAR2示例

示例#1

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'),
    )

示例#2

文件： 38218110d368_reply.py 项目： eaudeweb/art17-consultation

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),
    )

示例#3

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")

示例#4

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"
        },
    ])

示例#5

文件： 2de9ca3db59d_period.py 项目： costinbusioc/art17-consultation

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),
        )

示例#6

文件： 44fc139f3b69_habitattype_ro.py 项目： eaudeweb/art17-consultation

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)}))

示例#7

文件： d3da3cf76e7_cons_record_meta.py 项目： eaudeweb/art17-consultation

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'")

示例#8

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'")

示例#9

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'")

示例#10

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',