-- coding: utf-8 --
sqls = ''
number = 7
areas = ['nanhu', 'xiuzhou', 'jiashan', 'haiyan', 'haining', 'tongxiang', 'pinghu']
areas_chinese = ['南湖區(qū)', '秀洲區(qū)', '嘉善縣', '海鹽縣', '海寧市', '桐鄉(xiāng)市', '平湖市']
data_node_name_quarter = ['"最多跑一次"實現(xiàn)率', '"最多跑一次"滿意率', '對歐等發(fā)達經(jīng)濟體招商項目數(shù)', '對歐等發(fā)達經(jīng)濟體招商總額']
data_node_name_month = ['重大產(chǎn)業(yè)項目簽約數(shù)', '']
for data_node_name in data_node_name_quarter:
for i in range(0, number):
for year in range(2016, 2021):
for quarter in range(1,5):
sql = "INSERT INTO res_jx_data_node_quarter_" + areas[i] +
" (C_YEAR, C_QUARTER, C_AREA_NAME, C_DATA_NODE_NAME, C_PX) VALUES" +
" (" + str(year) + ", " + str(quarter) + ", '" + areas_chinese[i] + "', '" +
data_node_name + "', 1)" + "';\n"
sqls = sqls + sql
for data_node_name in data_node_name_month:
for i in range(0, number):
for year in range(2016, 2021):
for month in range(1,13):
sql = "INSERT INTO res_jx_data_node_month_" + areas[i] +
" (C_YEAR, C_MONTH, C_AREA_NAME, C_DATA_NODE_NAME, C_PX) VALUES" +
" (" + str(year) + ", " + str(month) + ", '" + areas_chinese[i] + "', '" +
data_node_name + "', 1)" + "';\n"
sqls = sqls + sql
print(sqls)
