python割引図の表示
2074 ワード
base.dbcomm db
json
com.business.common
com.business.common CommonUtil
matplotlib.pyplot plt
matplotlib.dates mdates
matplotlib.pylab pylab
pylab *
mpl.rcParams[] = [] mpl.rcParams[] = ProductInfo:
getProductByCategoryCode(, categoryCode):
getProductByCategoreCodeSQL = bigDict={};
result = CommonUtil.getExcludeItemKeys()
:
conn = db.getLocalConn();
conn.cursor() cur:
cur.execute(getProductByCategoreCodeSQL, (categoryCode))
row cur:
params=json.loads(row[])
itemKeyName params.keys():
(itemKeyName result):
;
(itemKeyName bigDict.keys()):
itemvalue=params[itemKeyName]
bigDict[itemKeyName]={itemvalue:}
:
dict=bigDict[itemKeyName];
(params[itemKeyName] dict.keys()):
count=dict[params[itemKeyName]]+dict[params[itemKeyName]]=count
bigDict[itemKeyName]=dict
:
dict[params[itemKeyName]]=bigDict[itemKeyName] = dict
bigDict
:
conn.close();
get_productinfocount_by_categorycode(,category_code):
get_product_info_by_category_code_sql = :
conn = db.getLocalConn();
conn.cursor() cur:
cur.execute(get_product_info_by_category_code_sql, (category_code,));
result = cur.fetchone()
:
conn.close();
result[];
productInfo = ProductInfo();
dict=productInfo.getProductByCategoryCode()
itemKeyName dict.keys():
dictChild=dict[itemKeyName]
point_xx=(dictChild.keys());
point_x=((dictChild.keys()))
point_y=(dictChild.values());
pylab.figure()
x = ()
pylab.xticks(point_x, point_xx)
pylab.plot(point_x, point_y, )
pylab.show()