def save_operate_log(self,request,msg,log_type=29): '''写操作日志 ''' try: Log._meta.db_table = 'log_operate' log = Log() log.log_type = log_type log.log_server = 0 log.log_channel = 0 log.log_user = request.admin.id log.log_data = 0 log.log_result = 0 log.f1 = msg[:100] log.f2 = request.get_full_path()[:100] log.f3 = request.real_ip post_params = unicode(json.dumps(dict(request.POST),ensure_ascii=False)) log.f4 = post_params[:100] log.f5 = post_params[100:200] log.f6 = post_params[300:400] log.log_time = datetime.datetime.now() log.save(using='write') except Exception,e: traceback.print_exc() create_table_sql = Log.get_create_table_sql('log_operate') conn = connection cur = conn.cursor() print create_table_sql cur.execute(create_table_sql)
def authenticate(username, password): user = storage.get_user_by_username(username) if user and safe_str_cmp(user.password.encode('utf-8'), hashlib.md5(password.encode()).hexdigest()): log = Log() log.user_id = user.id log.session_start = datetime.utcnow() log.save() return user
def write_hefu_log(log_user, master_id, sub_server, msg, log_result): try: Log._meta.db_table = 'log_merge_server' log = Log() log.log_user = log_user log.log_time = datetime.datetime.now() log.f1 = master_id log.f2 = sub_server log.f8 = msg log.log_result = log_result log.save(using='write') except BaseException as e: print "views --> server --> server --> write_merge_server_log error:%s" % e
def client_open(request, mobile_info): '''统计安装信息 ''' if mobile_info != '': try: Log._meta.db_table = 'log_open' log = Log() log.log_type = 9 log.log_user = 0 log.f5 = request.META.get('REMOTE_ADDR', '') log.f6 = '' post_status = 1 if request.method == 'POST' and mobile_info.find(',') == -1: channels = Channel.objects.using('read').filter( channel_key=mobile_info) if len(channels) > 0: log.log_channel = channels[0].id log.f1 = request.POST.get('imei', '') log.f3 = request.POST.get('dec', '') log.f2 = request.POST.get('ver', '') log.f4 = mobile_info log.f6 = request.POST.get('other', '') else: items = mobile_info.split(',') for item in items: key = item.split(':')[0] value = item.split(':')[1] if key == 'IMEI': mobile_key = value elif key == 'VER': log.f2 = value elif key == 'DEC': log.f3 = value elif key == 'QD': log.f4 = value if log.f4 != '': channels = Channel.objects.using('read').filter( channel_key=log.f4) if len(channels) > 0: log.log_channel = channels[0].id log.f1 = mobile_key post_status = 0 log.save(using='write') except Exception, ex: print 'client open error ', ex post_status = 1
def write_gm_log(log_user, log_type, protocol, server_id, role_id, role_name, log_result, params, return_params, remark1, remark2='', master_id=0): '''写GM日志 @param log_user:操作的管理员ID ''' log = Log() log.log_user = log_user # 操作管理员ID log.log_type = log_type # 操作类型 log.log_server = server_id # 服务器ID log.log_tag = master_id log.log_channel = protocol # 协议号 log.log_name = role_name # 角色名 try: role_id = int(role_id) log.log_data = role_id # 角色ID except: pass finally: log.log_relate = role_id log.log_result = log_result # 操作结果 remark1 = unicode(remark1) remark2 = unicode(remark2) log.log_previous = remark1[:200] # 赠送原因 log.log_now = remark2[:200] or remark1[200:] # 其他描述 return_params = unicode(return_params) # 返回参数 log.f1 = return_params[0:100] log.f2 = return_params[100:200] log.f3 = return_params[300:400] log.f4 = return_params[500:600] log.f5 = return_params[700:800] log.f6 = unicode(params) # 提交参数 log.log_time = datetime.datetime.now() Log._meta.db_table = 'log_gm' log.save(using='write')
def write_kuafu_log(log_user,log_type,server_id,sort,group,sub_group,msg,log_result): try: Log._meta.db_table = 'log_kuafu' log = Log() log.log_user = log_user log.f8 = log_type log.log_server = server_id log.log_time = datetime.datetime.now() log.f1 = sort # 大组 log.f2 = group # 分区 log.f3 = sub_group # 分组 log.f6 = msg log.log_result = log_result log.save(using='write') except BaseException as e: print "views --> server --> battle_server --> write_kuafu_log error:%s"%e
def save(self): from endless import db_session from sqlalchemy import inspect from models.log import Log logs = Log() user_history = inspect(self).attrs # Log full name changes first_name = (user_history.firstName.history[2] or user_history.firstName.history[1])[0] last_name = (user_history.lastName.history[2] or user_history.lastName.history[1])[0] if self.firstName != first_name or self.lastName != last_name: logs.add_action_log("Edit User: {0}".format(self.userId), "Name", first_name + ' ' + last_name, self.firstName + ' ' + self.lastName) db_session.commit() logs.save()
def player_history(request): """ 玩家采点信息记录 """ _r = {"code": -1} if request.method != 'POST': _r["msg"] = "method ERROR" return HttpResponse(json.dumps(_r)) log_tag = request.POST.get("log_tag", 0) if not log_tag: _r["msg"] = "log_tag ERROR" return HttpResponse(json.dumps(_r)) try: Log._meta.db_table = 'log_player_history' log = Log() log.log_tag = log_tag log.log_channel = request.POST.get("log_channel", 0) log.log_server = request.POST.get("log_server", 0) log.log_user = request.POST.get("log_user", 0) log.log_time = request.POST.get("log_time", "") if not log_time: log.log_time = datetime.datetime.now() if not log.log_channel or not log.log_server or not log.log_user: _r["msg"] = "BASE INFO ERROR" return HttpResponse(json.dumps(_r)) log.save(using='write') return HttpResponse(json.dumps({"code": 0, "msg": "success"})) except Exception as e: print 'log player_history error', e _r["msg"] = "save log ERROR" return HttpResponse(json.dumps(_r))
def save_log(log_name, log_type, log_server, log_channel, log_user, log_data, log_result, f1, f2, f3, f4, f5, f6): code = 1 try: Log._meta.db_table = 'log_%s' % log_name log = Log() log.log_type = log_type log.log_server = log_server log.log_channel = log_channel log.log_user = log_user log.log_data = log_data log.log_result = log_result log.f1 = f1 log.f2 = f2 log.f3 = f3 log.f4 = f4 log.f5 = f5 log.f6 = f6 log.log_time = datetime.datetime.now() log.save(using='write') code = 0 except Exception, ex: code = -1 print ex
p1.user_id = u1.id p1.description = 'this is description' p1.save() print(p1) c1 = Comment() c1.text = 'this is the first comment ever' c1.user_id = u1.id c1.post_id = p1.id c1.save() print(c1) lk1 = PostLike() lk1.post_id = p1.id lk1.user_id = u1.id lk1.save() print(lk1) lg = Log() lg.user_id = u1.id lg.save() print(lg) t1 = Topic() t1.title = 'hotel' t1.description = 'we love hotels' t1.posts.append(p1) t1.users.append(u1) t1.save() print(t1) print("THIS IS U1.TOPICS!!") print(u1.topics) print("THIS IS U1.posts!!") print(u1.posts)