"server": "inhousedb.smartsrv.in",
"db_name": "statistics",
"table": "aso_keyword_title_ranking",
"colum": ["date", "keyword", "title", "install", "rank"],
"primary": ["date"],
}
}
gdb = gutil.google_db()
record = '<table border="3" rules="all"><tr><th>アプリ名</th><th>キーワード</th><th>出現日数</th><th>インストール数</th><th>最高ランク</th><th>最低ランク</th></tr>'
for name, db in dbs.items():
logdb = db_util.db_command("takagi", "7TgYiaI9", db["server"], db["db_name"])
sql = "select title, keyword, count(distinct(date)) as days, sum(install) as install, max(rank) as min_rank, min(rank) "
sql += " as max_rank from aso_keyword_title_ranking where rank != 0 and install >= 1 "
sql += " and date >= " + str(lower) + " and date <= " + str(upper)
sql += " group by title, keyword order by title, install desc"
log = logdb.db_anyselect(sql)
for v in log:
if float(v["install"]) / float(v["days"]) >= 1.0:
record += "<tr>"
record += "<td>" + str(v["title"]) + "</td><td>" + str(v["keyword"]) + "</td>"
record += "<td>" + str(v["days"]) + "</td><td>" + str(v["install"]) + "</td>"
record += "<td>" + str(v["max_rank"]) + "</td><td>" + str(v["min_rank"]) + "</td>"
record += "</tr>"
record += "</tr></table>"
title = u"google play 注目キーワード" + "( " + str(lower) + " ~ " + str(upper) + " )"
for to_addr in to_addrs:
msg = mail_util.create_message_jp_html(from_addr, to_addr, title, record, "UTF-8")
mail_util.send_via_gmail(from_addr, to_addr, msg)
uu += 1
if len(apps["install"]) == 0:
leave += 1
for app, title in apps["install"].items():
print app, title
summary.setdefault(app, {})
summary[app].setdefault("num", 0)
summary[app].setdefault("uu", 0)
summary[app]["num"] += title
summary[app]["uu"] += 1
label = ["ビデオ名", "インストールUU"]
d = []
for k, v in sorted(summary.items(), key=lambda x: x[1]["uu"], reverse=True):
rec = [str(k), str(v["uu"])]
d.append(rec)
table2 = html_table.table(label, d)
print "#############ビデオテーブルデータ取得################"
print table2
content = "<div>アプリ起動</div>" + table + "<div>ビデオインストール</div>" + table2
print "#############テーブルデータ取得################"
print content
title = u"こどもモードアプリ内行動レポート" + "( " + str(argvs[1]) + " ~ " + str(argvs[2]) + ")"
for to_addr in to_addrs:
msg = mail_util.create_message_jp_html(from_addr, to_addr, title, content, "UTF-8")
mail_util.send_via_gmail(from_addr, to_addr, msg)
def send_mail(self):
doc = self.get_doc()
for to_addr in self.to_addrs:
msg = mail_util.create_message_jp_html(self.from_addr, to_addr, self.title, doc, "ISO-2022-JP")
mail_util.send_via_gmail(self.from_addr, to_addr, msg)
