def performance_pic():
cate_para_dict = config.get_config("../file/mysql_common.conf")
category_db = mysql.MysqlCommon(cate_para_dict['host'], cate_para_dict['port'], cate_para_dict['user'],
cate_para_dict['pwd'],
cate_para_dict['databases'])
categories = category_db.fetch_data("select id,name from category where parent_id<>0")
dp_para_dict = config.get_config("../file/mysql_dp.conf")
dp = mysql.MysqlCommon(dp_para_dict['host'], dp_para_dict['port'], dp_para_dict['user'], dp_para_dict['pwd'],
dp_para_dict['databases'])
for category in categories:
sql = "select loaddate,sum(cert_count) from dp_deal_detail_performance_day_v1 where loaddate>=20160801 and loaddate<=20160814 and category_id_2=" + \
str(category[0]) + " GROUP BY loaddate ORDER BY loaddate asc"
results = dp.fetch_data(sql)
dict = {}
for result in results:
dict[result[0]] = result[1]
for i, key in enumerate(dict): # Circulate both index and value(Here is key)
plt.bar(i, dict[key], color='r', width=0.2)
plt.xticks(np.arange(len(dict)) + 0.1, dict.keys()) # Translation
plt.yticks(dict.values())
plt.grid(True)
fig = plt.gcf()
fig.set_size_inches(18.5, 10.5)
print category[1].encode("utf-8")
fig.savefig('d:\\del\\pic\\' + category[1].replace("/", "") + '.png', dpi=100)
fig.clear()
def performance_pic():
dp_para_dict = config.get_config("../file/mysql_online.conf")
dp = mysql.MysqlCommon(dp_para_dict['host'], dp_para_dict['port'], dp_para_dict['user'], dp_para_dict['pwd'],
dp_para_dict['databases'])
while (True):
category = input("category:")
sql = "select loaddate,sum(cert_count) from dp_deal_detail_performance_day_v1 where loaddate>=20160801 and loaddate<=20160814 and category_id_2=" + category + " GROUP BY loaddate ORDER BY loaddate asc"
results = dp.fetch_data(sql)
data = {}
for result in results:
data[result[0]] = data[result[1]]
plt.bar(result[0], result[1], color='r', width=0.2)
plt.xticks(np.arange(len(data)) + 0.1, data.keys()) # Translation
plt.yticks(data.values())
plt.grid(True)
plt.show()
def export_firm_name_address():
para_dict = config.get_config("../file/mysql_online.conf")
mysql = database.MysqlCommon(para_dict['host'], para_dict['port'], para_dict['user'], para_dict['pwd'],
para_dict['db'])
count = mysql.fetch_count("select count(*) from npc_poi")
file_name = open("D:\\tmp\\name", "w")
file_address = open("D:\\tmp\\address", "w")
for index in range(0, count[0], 1000):
print index
name_address = mysql.fetch_data(
"select poi_name,address from npc_poi limit " + str(index) + "," + str(index + 1000))
for data in name_address:
file_name.write(data[0].encode("utf-8") + "\n")
file_address.write(data[1] + "\n")
file_name.close()
file_address.close()
