"colum" : "id,is_start,book_id,created" }, } #インストールデータを日別に取得する logdb = db_util.db_command("smartedu", "nakadama", db["user"]["server"], db["user"]["db_name"]) sql = "select id,created,platform_full from users where created >= '2013-06-01 00:00:00'" log = logdb.db_anyselect(sql) for v in log: created = dt.strptime(v["created"], '%Y-%m-%d %H:%M:%S') created = created.strftime('%Y%m%d') user_data.setdefault(v["id"], {}) user_data[v["id"]].setdefault("regdate", created) dev = dev_master.device_name(v["platform_full"]) user_data[v["id"]].setdefault("device", dev) user_data[v["id"]].setdefault("book_start", None) user_data[v["id"]].setdefault("book_end", None) user_data[v["id"]].setdefault("start", None) user_data[v["id"]].setdefault("end", None) #本読みデータを取得 logdb = db_util.db_command("smartedu", "nakadama", db["play"]["server"], db["play"]["db_name"]) start = datetime.datetime(2013, 6, 1, 0, 0, 0, 0) one_day = datetime.timedelta(days=1) end = start + one_day for i in range(159):
tables = server["table"] for table in tables: #access log #table control print app_id if app_id != "smartapps": tbl = table else: tbl = table + "_" + str(int(int(lower.replace("-", "")) / 100)) where = "created >= '" + lower + " 00:00:00' and created < '" + upper + " 00:00:00'" log = logdb.db_select(server["colum"], tbl, where, None) am = app_master.app_master() for v in log: if v.has_key("platform"): dev = dev_master.device_name(v["platform"]) else: dev = None if v.has_key("os"): os = v["os"] else: os = None if v.has_key("country"): country = v["country"] else: country = None if app_id != "smartapps": apps = app_id else: apps = am[v["application"]] if am.has_key(v["application"]) else "None" user_data.setdefault(v["user_id"] , {})