def main(): data_warehosue = anjuke_data_extract_in_multiprocess() d = MySql(host='121.42.188.55', port=3306, username='******', password='******', charset="utf8") d.connect_to_database_server() d.change_database('AnJuKe') # sql = "INSERT INTO AnJuKe_New_House(loupan_name, loupan_name_detail, address, price) VALUES(%s, %s, %s, %s);" # sql = "INSERT INTO AnJuKe_Second_House(loupan_name, loupan_name_detail, area, allocation, address, per_price, " \ # "price) VALUES(%s, %s, %s, %s, %s, %s, %s);" sql = "INSERT INTO AnJuKe_Renting_House(loupan_name, loupan_name_detail, allocation, renting_type, finish_type, " \ "floor, address, price) VALUES(%s, %s, %s, %s, %s, %s, %s, %s);" d.commit_to_database(sql, data_warehosue) d.disconnect_from_database_server()
def main(): data_warehosue = soufangwang_data_extract_in_multiprocess() d = MySql(host='121.42.188.55', port=3306, username='******', password='******', charset="utf8") d.connect_to_database_server() d.change_database('SouFangWang') # sql = "INSERT INTO SouFangWang_New_House(loupan_name, loupan_name_detail, address, price) VALUES(%s, %s, %s, %s);" # sql = "INSERT INTO SouFangWang_Second_House(loupan_name, loupan_name_detail, area, allocation, address, per_price, " \ # "price) VALUES(%s, %s, %s, %s, %s, %s, %s);" sql = "INSERT INTO SouFangWang_Renting_House(loupan_name, loupan_name_detail, allocation, renting_type, floor, " \ "address, price) VALUES(%s, %s, %s, %s, %s, %s, %s);" d.commit_to_database(sql, data_warehosue) d.disconnect_from_database_server()