"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)