Skip to content

sql python

조회 수 11 추천 수 0 2020.07.01 07:51:21

def setmd5_net(img_path,md5value):
    return ""

def getdxid_net(dx_):
    sql = "SELECT id FROM diagnosis WHERE dx = %s;" % (db.escape(dx_))
    #print(sql)
    try:
        cursor = db.cursor()
        cursor.execute(sql)
        results = cursor.fetchall()
        if len(results)==0:return -1
        return int(results[0][0])
    except Exception as e:
        print (e)
        print ("Error: unable to fetch data : getdxlist_net")
        f_sqllog.write(e+'\n')
        f_sqllog.write(sql+'\n')
        sys.exit(1)
    return -1

def setdxid_net(dx_,dx_full="",dx_alias=json.dumps([])):
    if dx_full=="":dx_full=dx_
    sql="INSERT INTO diagnosis(dx,fulldx,alias) VALUES (%s,%s,%s);" % (db.escape(dx_),db.escape(dx_full),db.escape(dx_alias))
    print(sql)
    try:
        cursor = db.cursor()
        cursor.execute(sql)
        db.commit()
    except Exception as e:
        print (e)
        print ("Error: unable to fetch data : setdxlist_net")
        f_sqllog.write(e+'\n')
        f_sqllog.write(sql+'\n')
        sys.exit(1)
    return True

def updatedxid_net(dx_,dx_full,dx_alias):
    sql="UPDATE diagnosis SET fulldx=%s,alias=%s WHERE dx=%s;" % (db.escape(dx_full),db.escape(dx_alias),db.escape(dx_))
    try:
        cursor = db.cursor()
        cursor.execute(sql)
        db.commit()
    except Exception as e:
        print (e)
        print ("Error: unable to fetch data : updatedxlist_net")
        f_sqllog.write(e+'\n')
        f_sqllog.write(sql+'\n')
        sys.exit(1)
    return True

def setdxlist_net(list_dx):
    for dx_ in list_dx:
        if getdxid_net(dx_)==-1:
            print("Not Found, and Create",dx_)
            setdxid_net(dx_)

    list_dx_net={}
    for i,dx_ in enumerate(list_dx):
        list_dx_net[i]=getdxid_net(dx_)

    return list_dx_net

def getid_engine_net(engine):
    sql = "SELECT id FROM engine WHERE name = %s;" % (db.escape(engine))
    #print(sql)
    try:
        cursor = db.cursor()
        cursor.execute(sql)
        results = cursor.fetchall()
        if len(results)==0:
            return -1
        else:
            return int(results[0][0])
    except Exception as e:
        print (e)
        print ("Error: unable to fetch data : setengine_net")
        f_sqllog.write(e+'\n')
        f_sqllog.write(sql+'\n')
        sys.exit(1)
    return -1

def setengine_net(engine,list_dx):
    engine_id=getid_engine_net(engine)
    if engine_id!=-1:return engine_id

    list_dx_json=json.dumps(list_dx)
    sql="INSERT INTO engine(name,list_dx) VALUES (%s,%s);" % (db.escape(engine),db.escape(list_dx_json))
    #print(sql)
    try:
        cursor = db.cursor()
        cursor.execute(sql)
        db.commit()
    except Exception as e:
        print (e)
        print ("Error: unable to fetch data : setengine_net")
        f_sqllog.write(e+'\n')
        f_sqllog.write(sql+'\n')
        sys.exit(1)

    return getid_engine_net(engine)

def getmd5_net(img_path):
    sql = "SELECT md5value FROM file WHERE img_path = %s;" % (db.escape(img_path))
    #print(sql)
    try:
        cursor = db.cursor()
        cursor.execute(sql)
        results = cursor.fetchall()
        return results[0][0]
    except Exception as e:
        print (e)
        print ("Error: unable to fetch data : getmd5_net")
        f_sqllog.write(e+'\n')
        f_sqllog.write(sql+'\n')
    return ""

def get_rcnn_net_from_md5(md5value,threshold_fine=0.1):
    if md5value=="":return []
    result_list=[]
    sql = "SELECT `md5unique`,`fine1`,`fine2`,`fine3`,`fine4`,`id` FROM `cropinfo` WHERE md5unique LIKE %s AND fine1 > %f ORDER BY fine1 DESC;" % (db.escape(md5value+'%'),threshold_fine)
    #print(sql)
    try:
         cursor = db.cursor()
         cursor.execute(sql)
         results = cursor.fetchall()
    except Exception as e:
        print (e)
        print ("Error: unable to fetch data : get_rcnn_net_from_md5")
        print(sql)
        f_sqllog.write(e+'\n')
        f_sqllog.write(sql+'\n')

    for row in results:
        result_list+=[[list(map(int,row[0].replace(md5value+'_','').split('_')))]+ [[row[1],row[2],row[3],row[4]],row[5]]]  #row[5]=id
    return result_list

List of Articles
번호 제목 글쓴이 날짜 조회 수
» sql python WHRIA 2020-07-01 11
1668 modprobe WHRIA 2020-06-29 11
1667 tab 구조 html WHRIA 2020-06-28 11
1666 imagenet classification SOTA WHRIA 2020-06-27 718
1665 할일 WHRIA 2020-06-24 15
1664 caffe hdf5 error WHRIA 2020-06-22 8
1663 resnest50 caffe WHRIA 2020-06-21 14
1662 reddit downloader WHRIA 2020-06-21 9
1661 바이두 WHRIA 2020-06-20 12
1660 regression model [6] WHRIA 2020-06-18 15
1659 MS bot framework [3] WHRIA 2020-06-13 6
1658 BERT WHRIA 2020-06-10 5
1657 영어로 숫자 표현 WHRIA 2020-05-28 27
1656 single file encrypt decrypt WHRIA 2020-05-17 487
1655 encfs WHRIA 2020-05-17 24

Powered by Xpress Engine / Designed by Sketchbook

sketchbook5, 스케치북5

sketchbook5, 스케치북5

나눔글꼴 설치 안내


이 PC에는 나눔글꼴이 설치되어 있지 않습니다.

이 사이트를 나눔글꼴로 보기 위해서는
나눔글꼴을 설치해야 합니다.

설치 취소