Python DBHandler.insert_batch_record Beispiele

Beispiel #1

Datei: DistrictHisStatisDataHandler.py Projekt: WIndyGirl/WebCrawler

def insert_district_his_statistics_data(conn, values):
	sql = 'insert into district_his_statistics_data(insert_date, district, district_avarage_price, deal_in_last_month, deal_compare_last_month, deal_compare_last_year, on_sale, deal_in_90_days, deal_in_yesterday, daikan_in_yesterday) values (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)'
	
	dbHandler = DBHandler()
	dbHandler.insert_batch_record(conn, sql, values)

Beispiel #2

Datei: VillageHisStatisDataHandler.py Projekt: WIndyGirl/WebCrawler

def insert_village_his_statistics_data(conn, values):
	sql = 'insert into village_his_statistics_data(insert_date, village_name, village_avarage_price, on_sale, deal_in_90_days, deal_in_30_days, daikan_in_30_days) values (%s, %s, %s, %s, %s, %s, %s)'
	
	dbHandler = DBHandler()
	dbHandler.insert_batch_record(conn, sql, values)