sql python
2020.07.01 07:51
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
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1774 | 음란전화.... | 윤재원 | 2000.07.10 | 3917 |
1773 | 재원님이 퍼온 심리테스트...하하하 읽어봐라 | 재원님~ | 2000.07.12 | 3636 |
1772 | 의욕상실 | 채영광 | 2000.07.13 | 3975 |
1771 | Re: 의욕상실 | 한승석 | 2000.07.13 | 3436 |
1770 | Re: 사진 더 추가해줘잉 | 한승석 | 2000.07.13 | 3239 |
1769 | 비천무는 잼있다! | 채영광 | 2000.07.16 | 4119 |
1768 | 음악 니가 다 정리한 거야? | 채영광 | 2000.07.18 | 4505 |
1767 | 아주아주 멋진 시...한편..꼭 읽어봐랑~ | 재원님~ | 2000.07.18 | 3673 |
1766 | 승석아 오늘 오스키는 잘 보았니? | 채영광 | 2000.07.23 | 3629 |
1765 | Re: 비천무는 잼없다! | 헬로우멤 | 2000.07.24 | 3497 |
1764 | 비천무...말이지~~~ | 윤재원 | 2000.07.26 | 3647 |
1763 | 승석아 다다음주 말이야. | 채영광 | 2000.07.31 | 3487 |
1762 | 똑똑똑~~ | 조각가 | 2000.08.01 | 3646 |
1761 | 승석이오빠아...ㅜ.ㅜ 설가면 맛난거 사주우.ㅠ.ㅠ | 김승욱 | 2000.08.06 | 4356 |
1760 | 승석 X-ray는 많이 찍었니? | 정석원 | 2000.08.07 | 3861 |