notice.last_send_time = now
notice.persist()
def send_notice_to_server(self, server_id, content):
info = {}
timestamp = int(time.time() * 1000)
info["timestamp"] = timestamp
info["sign"] = md5mgr.mkmd5fromstr("%s%s%s" % (content, timestamp, "gCvKaE0tTcWtHsPkbRdE"))
info["partnerIds"] = "all"
info["content"] = content
server = server_business.get_server(server_id=server_id)
url = "http://" + server.server_host + ":8088//gameApi/sendSysMsg.do"
success, ret_val = http_util.request(url, info)
if success:
result = json.loads(ret_val)
return result.get("rt") == 1000
def get_notice_list(self):
return notice_business.get_effect_notice_list()
if __name__ == "__main__":
s = single_process.SingleProcess("notice_sender")
s.check()
executor = NoticeSender()
executor.start()
#executor.send_notice_to_server("t2", "中文走马灯")
line = line.strip()
if temp_sql:
temp_sql = "%s %s" % (temp_sql, line)
else:
temp_sql = line
if not line:
continue
if line.endswith(";"):
sql_list.append(temp_sql)
temp_sql = ""
finally:
f.close()
return sql_list
if __name__ == "__main__":
s = single_process.SingleProcess("script_executor")
s.check()
import sys
batch_count = 10000
if len(sys.argv) == 2:
batch_count = int(sys.argv[1])
executor = ScriptExecutor(batch_count=batch_count)
executor.start()
# executor.get_sql_list("C:\\Users\\jacky\\Desktop\\update\\update_table_ad_hall.sql");
cmds.extend(params)
self.log("execute[%s]" % " ".join(cmds))
p = Popen(cmds, stdout=PIPE)
while True:
line = p.stdout.readline()
output = "%s%s" % (output, line)
if not line:
break
self.log(line.replace("\n", ""))
if p.wait() == 0:
self.log("call %s success" % cmd)
return 1, output
self.log("call %s failure" % cmd)
return 0, output
except:
self.log(traceback.format_exc())
return 0, traceback.format_exc()
if __name__ == "__main__":
s = single_process.SingleProcess("server_updator")
s.check()
if len(sys.argv) > 1:
server_ids = sys.argv[1].split(",")
else:
server_ids = ["t2"]
executor = ServerUpdator(server_ids)
executor.start()
self.log("old[%s], new[%s]" % (partner_user_id_old, partner_user_id_new))
f_sql_1.write("update user_mapper set partner_user_id='%s' where partner_user_id='%s' and partner_id=%s limit 1;\n" % (partner_user_id_new, partner_user_id_old, partner_id))
f_sql_1.write("update payment_log set partner_user_id='%s' where partner_user_id='%s' and partner_id=%s limit 1;\n" % (partner_user_id_new, partner_user_id_old, partner_id))
f_sql_2.write("update payment_order set partner_user_id='%s' where partner_user_id='%s' and partner_id=%s limit 1;\n" % (partner_user_id_new, partner_user_id_old, partner_id))
finally:
cursor.close()
finally:
f_sql_1.close()
f_sql_2.close()
def get_partner_user_id(self, username):
url = "http://42.62.4.167:9015/web/api/sdk/third/1/queryuidbyloginname"
success, ret_val = http_util.request(url, {"param": username})
if success:
try:
_ = json.loads(ret_val)
return None
except:
return ret_val
if __name__ == "__main__":
s = single_process.SingleProcess("an_zhi_id_handle")
s.check()
executor = AnZhiIdHandle()
executor.start()
servers = []
# servers = []
# s1 = Server()
# s1.db_connect = "server=118.244.198.81,3306;database=ldsg_h10;user=ldsg_h10_op;pwd=3e454ss3kd40e24;"
# s1.server_id = 1
# s2 = Server()
# s2.db_connect = "server=118.244.198.86,3306;database=ldsg_h11;user=ldsg_h11_rd;pwd=e727484b3251bc;"
# s2.server_id = 2
# servers.append(s1)
# servers.append(s2)
if self.server_id:
server = Server.load(server_id=self.server_id)
servers.append(server)
return servers
else:
return server_business.get_all_server_list()
if __name__ == "__main__":
if len(sys.argv) == 2:
server_id = sys.argv[1]
s = single_process.SingleProcess("liucun_server_data")
s.check()
executor = LiuCunServerData(server_id=server_id)
executor.start()
else:
s = single_process.SingleProcess("liucun_server_data")
s.check()
executor = LiuCunServerData()
executor.start()
if not infos:
break
self.log("size:[%s], start_time[%s]" %
(len(infos), start_time))
start_time = infos[-1]["reg_time"]
for info in infos:
level = info["level"]
total = level_map.get(level, 0)
total += 1
level_map[level] = total
finally:
cursor.close()
stat_user_level = StatUserLevel()
stat_user_level.server_id = server.server_id
stat_user_level.data = json.dumps(level_map)
stat_user_level.date = datetime.now().strftime("%Y-%m-%d")
stat_user_level.persist()
def get_server_list(self):
return server_business.get_all_server_list()
if __name__ == "__main__":
s = single_process.SingleProcess("user_level_stat")
s.check()
executor = UserLevelStat()
executor.start()
# s2.db_connect = "server=118.244.198.86,3306;database=ldsg_h11;user=ldsg_h11_rd;pwd=e727484b3251bc;"
# s2.server_id = 2
# servers.append(s1)
# servers.append(s2)
if self.server_id is not None:
server = Server.load(server_id=self.server_id)
servers.append(server)
return servers
else:
return server_business.get_all_server_list()
if __name__ == "__main__":
if len(sys.argv) == 2:
date = sys.argv[1]
s = single_process.SingleProcess("stat_server_data_country")
s.check()
executor = StatServerDateCountry(date=date)
executor.start()
elif len(sys.argv) == 3:
date = sys.argv[1]
server_id = sys.argv[2]
s = single_process.SingleProcess("stat_server_data_country")
s.check()
executor = StatServerDateCountry(date=date, server_id=server_id)
executor.start()
else:
s = single_process.SingleProcess("stat_server_data_country")
s.check()
executor = StatServerDateCountry()
executor.start()
tool_use_log.persist()
def get_server_list(self):
servers = []
if self.server_id is not None:
server = Server.load(server_id=self.server_id)
servers.append(server)
return servers
else:
return server_business.get_all_server_list()
if __name__ == "__main__":
if len(sys.argv) == 2:
date = sys.argv[1]
s = single_process.SingleProcess("use_tool_log")
s.check()
executor = UseToolLogStat(date=date)
executor.start()
elif len(sys.argv) == 3:
date = sys.argv[1]
if not date:
server_id = sys.argv[2]
s = single_process.SingleProcess("use_tool_log")
s.check()
executor = UseToolLogStat(server_id=server_id)
executor.start()
else:
date = sys.argv[1]
server_id = sys.argv[2]
s = single_process.SingleProcess("use_tool_log")
break
def get_server_list(self):
servers = []
if self.server_id is not None:
server = Server.load(server_id=self.server_id)
servers.append(server)
return servers
else:
return server_business.get_all_server_list()
if __name__ == "__main__":
if len(sys.argv) == 2:
date = sys.argv[1]
s = single_process.SingleProcess("stat_server_data")
s.check()
executor = StatServerDate(date=date)
executor.start()
elif len(sys.argv) == 3:
date = sys.argv[1]
server_id = sys.argv[2]
s = single_process.SingleProcess("stat_server_data")
s.check()
executor = StatServerDate(date=date, server_id=server_id)
executor.start()
else:
s = single_process.SingleProcess("stat_server_data")
s.check()
executor = StatServerDate()
executor.start()
