def __init__(self,
q,
mydate=MyDate(Util.get_yesterday()),
conn_report_params=None):
OracleWrap.__init__(self, conn_report_params)
self.mydate = mydate
self.q = q
def __init__(self,
conn_params,
q=None,
mydate=MyDate(Util.get_yesterday())):
MysqlWrap.__init__(self, conn_params)
self.q = q
self.mydate = mydate
self.table_name = "video_report_%d" % int(
self.mydate.get_now(format='ym'))
class ReportMysqlFlask(MysqlWrap):
conn_test_params = {
"host": "10.16.15.178",
"user": "******",
"db": "test",
"passwd": "root",
"charset": "gbk",
"port": 3306,
}
conn_space_params = {
"host": "10.10.77.47",
"user": "******",
"db": "wemedia_sharing",
"passwd": "20!21@14",
"charset": "gbk",
"port": 3307,
}
conn_formal_params = {
"host": "10.10.57.125",
"user": "******",
"db": "my_sharing",
"passwd": "jdfcbw73Kru",
"charset": "gbk",
"port": 3306,
}
conn_mobile_params = {
"host": "10.10.12.48",
"user": "******",
"db": "ad_mobile",
"passwd": "7NpabDEoafCMvHH",
"charset": "utf8",
"port": 3306,
}
def __init__(self, conn_params, date_param):
MysqlWrap.__init__(self, conn_params)
self.mydate = MyDate(date_param)
def select_mobile_file(self):
table_name = "video_report_%d" % int(self.mydate.get_now(format="ym"))
sql_body = "select video_id,is56,ifnull(w_vv,0),ifnull(play_time,0), ifnull(w_fuv_playcount,0), ifnull(down_load_bytes,0), ifnull(w_cdn_uv,0) ,ifnull(suggest_rate_lv1,0) "
sql_where = (
" from "
+ table_name
+ " where play_plat=2 and is_user_share=1 and is_video_share=1 and dtime="
+ str(self.mydate.get_now())
)
sql = sql_body + sql_where
rows = self.mysql_select(sql)
self.save_rows(rows, str(self.mydate.get_now()))
def save_rows(self, rows, path):
module_path = dirname(__file__)
file_write = open(join(module_path, "data", path), "w")
val = []
for row in rows:
for i in range(8):
val.append(str(row[i]))
file_write.write(" ".join(val) + "\n")
val = []
file_write.close()
def update_suggest_rate(self, darray):
table_name = "video_report_%d" % int(self.mydate.get_now(format="ym"))
sql = (
"update "
+ table_name
+ " v set v.suggest_rate_lv1= %s where v.dtime=%s and v.play_plat=2 and video_id=%s and is56=%s"
)
datalist = []
for row in darray:
datalist.append((row[7] / 10000.0, int(self.mydate.get_now()), row[0], row[1]))
self.mysql_executemany(sql, datalist)
self.update_report_patch()
def update_report_patch(self):
table = "video_report_%d" % int(self.mydate.get_now(format="ym"))
sql1 = " update %s set suggest_rate_lv1= (suggest_rate_lv1*100+20)/300 where play_plat=2 and dtime=%s and is_user_share=1 and is_video_share=1 and suggest_rate_lv1>0.1"
sql2 = "update %s set suggest_rate_lv1= (suggest_rate_lv1*100+10)/200 where play_plat=2 and dtime= %s and is_user_share=1 and is_video_share=1 and suggest_rate_lv1<0.1 "
sql3 = "update %s set suggest_rate_lv1=1 where play_plat=2 and dtime= %s and is_user_share=1 and is_video_share=1 and (js_original_data =null or js_original_data =0 ) "
sql = (sql1, sql2, sql3)
self.mysql_execute(sql, (table, self.mydate.get_now()))
def __init__(self, conn_params, date_param):
MysqlWrap.__init__(self, conn_params)
self.mydate = MyDate(date_param)
def __init__(self, conn_params, date_param):
MysqlWrap.__init__(self, conn_params)
self.mydate = MyDate(date_param)