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)