for c in db["colum"]:
sql += c + ","
sql = sql[:-1]
sql += " from " + db["table"] + " where yyyymmdd = " + str(yyyymmdd)
log = logdb.db_anyselect(sql)
gdb = gutil.google_db()
for v in log:
if name == "ltv" or name == 'playcountdau':
gdb_name = v["app_id"] + " " + name
sheet_name = v["os_type"]
record = {}
for key, value in v.items():
key = key.replace("_", "")
if key == "yyyymmdd":
value = date_func.num2yyyy_mm_dd(int(value))
record.setdefault(key, value)
colum = []
primary = []
for value in db["colum"]:
if value != "app_id" and value != "os_type":
colum.append(value)
for value in db["primary"]:
if value != "app_id" and value != "os_type":
primary.append(value)
del record["appid"]
del record["ostype"]
gdb.update_record(gdb_name, sheet_name, record, primary, colum)
else:
gdb_name = v["app_id"] + " " + name
sheet_name = v["os_type"] + " " + v["subscription_type"]
words = [u"赤ちゃん".encode('utf-8'),
u"赤ちゃん アプリ".encode('utf-8'),
u"子供向けのアプリ".encode('utf-8'),
u"子供 向け ゲーム 無料".encode('utf-8'),
u"太鼓の達人".encode('utf-8'),
]
gdb = gutil.google_db()
for name, db in dbs.items():
logdb = db_util.db_command("takagi", "7TgYiaI9", db["server"], db["db_name"])
for word in words:
sql = "select "
for c in db["colum"]:
sql += c + ","
sql = sql[:-1]
sql += " from " + db["table"] + " where date = " + str(yyyymmdd)
sql += " and keyword = '" + word + "'"
log = logdb.db_anyselect(sql)
record = {}
record.setdefault("date", date_func.num2yyyy_mm_dd(int(yyyymmdd)))
colum = []
colum.append("date")
apps = app_master.app_name_en()
for k, v in sorted(apps.items()):
colum.append(v)
record.setdefault(v, str(0))
for v in log:
record[apps[v["title"]]] = v["rank"]
gdb_name = "aso_ranking"
sheet_name = word
gdb.update_record(gdb_name, sheet_name, record, db["primary"], colum)
