Python OracleOperation.get_data Beispiele

Beispiel #1

# coding:utf-8
from tools.shujuku_conn.oracle_conn import OracleOperation
import re

db = OracleOperation()
DATA = db.execute_sql(
    "SELECT case_id,clear_about_patent FROM jugement_table_0728_re_qx where identify='专利号'"
)
data = db.get_data()
num = 0
#57687
for concent in data:
    case_id = concent[0]
    try:
        fmt_content_n = concent[1]
        data_num = []
        num_1_1 = re.findall(
            '[ZＺzｚCＣｃc][LＬlｌNＮｎn](8[5-9][1-3]\d{5})\.?[\dＸｘXx×]?',
            fmt_content_n)
        num_1_2 = re.findall(
            '专利号为?是?\s?:?[ZＺzｚCＣｃc]?[LＬlｌNＮｎn]?(8[5-9][1-3]\d{5})\.?[\dＸｘXx×]?',
            fmt_content_n)
        num_1_3 = re.findall(
            '申请号为?是?\s?:?[ZＺzｚCＣｃc]?[LＬlｌNＮｎn]?(8[5-9][1-3]\d{5})\.?[\dＸｘXx×]?',
            fmt_content_n)
        num_1_4 = re.findall(
            '[ZＺzｚCＣｃc][LＬlｌNＮｎn](9[0-9][1-3]\d{5})\.?[\dＸｘXx×]?',
            fmt_content_n)
        num_1_5 = re.findall(
            '专利号为?是?\s?:?[ZＺzｚCＣｃc]?[LＬlｌNＮｎn]?(9[0-9][1-3]\d{5})\.?[\dＸｘXx×]?',
            fmt_content_n)

Beispiel #2

Datei: 如下：.py Projekt: 463563466/demo_test

from tools.shujuku_conn.oracle_conn import OracleOperation
import re

db = OracleOperation()
sql ="select case_id from jugement_table_0807_re_qxxx "
db.execute_sql(sql)
data = db.get_data()


for datas in data:
    case_id = datas[0]
    sql1 = "select clear_two from jugement_table_0807_re_qxxx where case_id='{}' and identify='专利名称'".format(case_id)
    db.execute_sql(sql)
    clear_two  = db.get_data()
    num = 0
    for i in name: