def main(): one_day = time.strftime("%Y%m%d", time.localtime(time.time() - 246060)) opts, args = getopt.getopt(sys.argv[1:], 'd:') for op, value in opts: if op == '-d': m = re.search('[0-9]{8}', value) if m: one_day = value else: print "請(qǐng)輸入8位日期(比如：20130215)" return 'no' print "正在統(tǒng)計(jì)會(huì)員鮮花庫(kù)存(%s)..." %one_day
db_conn = MySQLdb.connect(user=optmap['dbuser'], passwd=optmap['dbpass'], host=optmap['dbhost'], port=optmap['dbport'], db=optmap['dbname'])db_conn.query("use %s" %optmap['dbname'])db_cursor = db_conn.cursor()vip_user_list = {}for i in range(10):sql = "select USERID, VIPSTATE from VIPUSER%s" %iprint sqldb_cursor.execute(sql)db_rows = db_cursor.fetchall()for USERID, VIPSTATE in db_rows:vip_user_list[USERID] = VIPSTATEvip_user_flower_list = {}for i in range(10):sql = "select USERID, FLOWER from VIPUSERFLOWER%s" %iprint sqldb_cursor.execute(sql)db_rows = db_cursor.fetchall()for USERID, FLOWER in db_rows:vip_user_flower_list[USERID] = FLOWERvip_state_flower_list = {}vip_state_flower_list[1] = 0;vip_state_flower_list[2] = 0;vip_state_flower_list[3] = 0;for key in vip_user_list:if key in vip_user_flower_list:if vip_user_list[key] in vip_state_flower_list:vip_state_flower_list[vip_user_list[key]] += vip_user_flower_list[key]for key in vip_state_flower_list:print key, vip_state_flower_list[key]db_cursor.close()db_conn.close()db_conn = MySQLdb.connect(user=optmap['dbuser'], passwd=optmap['dbpass'], host=optmap['dbhost_gm'], port=optmap['dbport'], db=optmap['dbname_gm'])db_conn.query("use %s" %optmap['dbname_gm'])db_cursor = db_conn.cursor()dword_time = time.mktime(time.strptime(one_day, '%Y%m%d'))sql = "update VIPUSERFLOWERMONTHLY set year_flower_left_num=%d, month_flower_left_num=%d, week_flower_left_num=%d where count_time='%d'" %(vip_state_flower_list[3], vip_state_flower_list[2], vip_state_flower_list[1], dword_time)print sqldb_conn.query(sql)db_conn.commit()db_cursor.close()db_conn.close()
main() #if?name?== "main":
main()
? ? ?? ? ? ?? ?#!/usr/bin/env python #--coding:utf-8-- #會(huì)員信息統(tǒng)計(jì) import MySQLdb import os, sys, re, string import time, getopt
def get_files(dir, pattern): print dir, pattern match_file_list = [] if os.path.exists(dir): cur_file_list = os.listdir(dir) for file_name in cur_file_list: if re.search(pattern, file_name): match_file_list.append(file_name) return match_file_list else: return 'no'
def main(): one_day = time.strftime("%Y%m%d", time.localtime(time.time() - 246060)) #默認(rèn)日期為腳本運(yùn)行的上一天 opts, args = getopt.getopt(sys.argv[1:], 'd:') for op, value in opts: if op == '-d': m = re.search('[0-9]{8}', value) if m: one_day = value else: print "請(qǐng)輸入8位日期(比如：20130215)" return 'no'
