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