def update_hos():
    sql1 = "select id,yiyuan from doc_msg3 "
    sql4 = "update doc_msg3 set yiyuan = %s where id = %s"
    db = cdb.DatabaseConnection()
    cur,con = db.dbConnect('lyqystj')
    cur.execute(sql1)
    all_hos = cur.fetchall()
    hos = []
    for i in all_hos:
        temp = []
        # print "type:",type(i[1])
        t = i[1].encode('utf-8').replace(' ','')
        print "t:",t
        temp.append(t)#yiyuan
        temp.append(i[0])#id
        hos.append(temp)
    cur.executemany(sql4,hos)
    con.commit()
    cur.close()
    print '插入完成'
def update_university_latlng():
    sql1 = "select id,university from university_list where id > '234' "
    sql4 = "update university_list set latlng = %s where id = %s"
    db = cdb.DatabaseConnection()
    cur,con = db.dbConnect('lyq_sy_db')
    cur.execute(sql1)
    all_university = cur.fetchall()
    univer = []
    for i in all_university:
        temp = []
        # print "type:",type(i[1])
        # university_id = i[0]
        name = i[1].encode('utf-8')
        latlng = map.getlnglat(name)
        temp.append(latlng)#坐标
        temp.append(i[0])#id
        univer.append(temp)
    cur.executemany(sql4,univer)
    con.commit()
    cur.close()
    print '插入完成'
def update():
    sql1 = "select id,yiyuan from doc_msg3 "
    sql4 = "update doc_msg3 set city = %s,lnglat = %s where id = %s"
    db = cdb.DatabaseConnection()
    cur,con = db.dbConnect('lyqystj')
    cur.execute(sql1)
    all_hos = cur.fetchall()
    hos = []
    for i in all_hos:
        temp = []
        print 'hos:',i[1]
        print 'hos_type:',type(i[1].encode('utf-8'))
        lnglat = map.getlnglat(i[1].encode('utf-8'))
        if(lnglat != 'false'):
            city = map.getReverse_lnglat(lnglat)
            temp.append(city)  # city
            temp.append(lnglat)  # lnglat
            temp.append(i[0])
            hos.append(temp)
    cur.executemany(sql4,hos)
    con.commit()
    cur.close()
    print '插入完成'
def update_university_hos_duration():
    # log = lg.Log('D://yiyuan.txt')
    # f = log.get_log()
    sql1 = "select university,latlng from university_list where id = '253' or id = '254'"
    sql2 = "select yiyuan,lnglat from doctor_hos"
    sql3 = "insert into people_hospital_duration(school_name,hos_name,duration) values(%s, %s, %s)"
    db = cdb.DatabaseConnection()
    cur, con = db.dbConnect('lyq_sy_db')
    cur.execute(sql1)
    all_university = cur.fetchall()
    cur.execute(sql2)
    all_hospital = cur.fetchall()
    number = 1
    for university in all_university:
        durations = []
        print "university:%s 第%s个:" % (university[0].encode('utf-8'),number)
        for hospital in all_hospital:
            duration = map.getDuration(university[1],hospital[1])
            temp = []
            # print "type:",type(i[1])
            # university_id = i[0]
            temp.append(university[0])  # 学校名
            temp.append(hospital[0])  # 医院名
            temp.append(duration)  # 车程
            durations.append(temp)
        number += 1
        time.sleep(180)
        cur.executemany(sql3, durations)
        con.commit()
    # temp = []
    # temp.append('中国')  # 医院名
    # temp.append('死者')  # 学校名
    # temp.append(555)  # 车程
    # durations.append(temp)
    cur.close()
    print '插入完成'