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.os_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"] , {})
"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.os_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)
user_data[v["id"]].setdefault("book_num", 0)
#本読みデータを取得
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
