sql _更新

def sql_cunchu(dict):
    conn = psycopg2.connect(database="mapwayonline", user="postgres", password="C02SP70YGF1J", host="47.92.116.107", port="5434")
    cur = conn.cursor()
    # cur.execute("select * from bjzs_big_data.baoji_company_top")
    # rows = cur.fetchall()
    # for row in rows:
    #     print(row[0])

    for key in dict.keys():
        #cur.execute("INSERT INTO bjzs_big_data.baoji_company_top (name,index) VALUES (%s,%s)",(key, dict[key]))

        #UPDATE 表名称 SET 列名称 = 新值 WHERE 列名称 = 某值
        cur.execute("UPDATE bjzs_big_data.baoji_company_top SET isworld = %s WHERE name = %s and index = %s", (1 ,key, dict[key]))
        conn.commit()
    cur.close()
    conn.close()