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