def insertMysqlset(self): if self.tup_value.has_key("OrderID"): orderid = self.tup_value["OrderID"] else: orderid = None uuid = self.tup_value["UUID"] amount = self.tup_value["Amount"] gameid = self.tup_value["GameID"] channelid = self.tup_value["ChannelID"] timestamp = self.timefield time_struct = time.strptime(timestamp, '%Y-%m-%d %H:%M:%S') timestamp = time.strftime("%Y%m%d%H%M%S", time_struct) if self.tup_value.has_key("OS"): os = self.tup_value["OS"] else: os = '' if not orderid: sql = """INSERT INTO settlement(uuid,amount,gameid,channelid,os,date) VALUES ("%s", "%s", "%s","%s","%s","%s")""" % ( uuid, amount, gameid, channelid, os, timestamp) else: sql = """INSERT INTO settlement(orderid,uuid,amount,gameid,channelid,os,date) VALUES ("%s","%s", "%s", "%s","%s","%s","%s")""" % ( orderid, uuid, amount, gameid, channelid, os, timestamp) log.debug("付费sql为:%s" % (sql)) mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.payset_insert(sql)
def behavior(self): ret = super(GameHandleLogic, self).behavior() be_type = 'game' strjson = str({'GameID': ret["game_id"], 'ChannelID': ret["channel"]}) sql = """INSERT INTO behavior(uuid,type, strjson, date) VALUES ("%s", "%s", "%s", "%s")""" % ( ret["uuid"], be_type, strjson, ret["timestamp"]) log.debug(u"佣金行为sql为:%s" % (sql)) mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)
def behavior(self): ret = super(PayHandleLogic, self).behavior() amount = self.tup_value['Amount'] be_type = 'pay' strjson = str({'GameID': ret["game_id"], 'ChannelID': ret["channel"], 'Amount': amount}) sql = """INSERT INTO behavior(uuid,type, strjson, date) VALUES ("%s", "%s", "%s", "%s")""" % (ret["uuid"], be_type, strjson, ret["timestamp"]) log.debug(u"付费行为sql为:%s" % (sql)) mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)
def insertpublic(table_name, values, column): newvalues = [] for value in values: newvalues.append('"%s"' % (value)) newvalue = ','.join(newvalues) insert_rbd = "INSERT INTO %s(%s) VALUES (%s)" % (table_name, column, newvalue) log.debug(insert_rbd) mysql_operation_rdb_obj = mysql_operation('loginput') mysql_operation_rdb_obj.mysql_insert(insert_rbd)
def logWriteMysql(self): ret = self.tup_value timestamp = self.timefield time_struct = time.strptime(timestamp, '%Y-%m-%d %H:%M:%S') timestamp = time.strftime("%Y%m%d%H%M%S", time_struct) sql = """INSERT INTO shortlink(ip,url,code,createTime,os,useragent) VALUES ("%s", "%s", "%s", "%s","%s","%s")""" % ( ret["ip"], ret["url"], ret["code"], timestamp, ret["os"], ret["useragent"]) log.debug("用户行为执行的sql语句为:%s" % (sql)) mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)
def proxylog(self): paymode = self.tup_value["PayMode"] log.debug(u"判断是否为代理充值") if paymode == "DLPAY": ret = self.behavior() ret['amount'] = self.tup_value["Amount"] ret['paymode'] = paymode sql = """INSERT INTO proxylog(uuid,amount, gameid, channelid,timestamp,paymode) VALUES ("%s", "%s", "%s", "%s","%s","%s")""" % (ret["uuid"], ret["amount"], ret["game_id"],ret["channel"],ret["timestamp"],ret["paymode"]) log.debug("用户行为执行的sql语句为:%s" % (sql)) #print sql mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)
def insertMysqlBindphone(self): uuid = self.tup_value["uuid"] phone = self.tup_value["phone"] channelid = self.tup_value["channelid"] gameid = self.tup_value["gameid"] timestamp = self.timefield time_struct = time.strptime(timestamp, '%Y-%m-%d %H:%M:%S') timestamp = time.strftime("%Y%m%d%H%M%S", time_struct) sql = """INSERT INTO bindphone(uuid,phone, channelid, gameid,date) VALUES ("%s", "%s", "%s", "%s","%s")""" % ( uuid, phone, channelid, gameid, timestamp) log.debug("绑定手机sql为:%s" % (sql)) mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)
def behavior(self): ret = super(LoginHandleLogic, self).behavior() account_key = self.handle_key_obj.account_key("LOGINACCOUNT") field = self.handle_field_obj.channel_type("UUID") be_type = 'login' if not self.redis_obj.hexists(account_key, field): be_type = 'register' strjson = str({'GameID': ret["game_id"], 'ChannelID': ret["channel"]}) sql = """INSERT INTO behavior(uuid,type, strjson, date) VALUES ("%s", "%s", "%s", "%s")""" % ( ret["uuid"], be_type, strjson, ret["timestamp"]) log.debug("用户行为执行的sql语句为:%s" % (sql)) #print sql mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)
def insertMysqlSysscore(self): if self.tup_value["androidFlag"] == 0: timestamp = self.timefield time_struct = time.strptime(timestamp, '%Y-%m-%d %H:%M:%S') timestamp = time.strftime("%Y%m%d%H%M%S", time_struct) game_id = "ENG-HJDWC-001" gamekindId = self.tup_value["gameKindId"] uuid = self.tup_value['uuid'] sysscore = -self.tup_value['addscore'] sql = """INSERT INTO sysscore(uuid,gameid, gamekindid, sysscore,timestamp) VALUES ("%s", "%s", "%s", "%s","%s")""" % ( uuid, game_id, gamekindId, sysscore, timestamp) log.debug(u"系统输赢sql为:%s" % (sql)) mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)
def insertMysqlRegister(self): '''gameid, channel, devicetype,IMEI, mac,IPv4,os, uuid, userid, timestamp, Latitude":"0.0","Longitude":"0.0"''' if self.tup_value["DeviceInfo"].has_key('GameID'): gameid = self.tup_value["DeviceInfo"]["GameID"] else: gameid = '' if self.tup_value["DeviceInfo"].has_key("Channel"): channel = self.tup_value["DeviceInfo"]["Channel"] else: channel = '' if self.tup_value["DeviceInfo"].has_key("DeviceType"): devicetype = self.tup_value["DeviceInfo"]["DeviceType"] else: devicetype = '' if self.tup_value["DeviceInfo"].has_key("IMEI"): imei = self.tup_value["DeviceInfo"]["IMEI"] else: imei = '' if self.tup_value["DeviceInfo"].has_key('MAC'): mac = self.tup_value["DeviceInfo"]["MAC"] else: mac = '' if self.tup_value["DeviceInfo"].has_key("IPv4"): ipv4 = self.tup_value["DeviceInfo"]["IPv4"] else: ipv4 = '' os = self.tup_value["DeviceInfo"]["OS"] uuid = self.tup_value["UUID"] if self.tup_value.has_key("Username"): username = self.tup_value["Username"] else: username = '' if self.tup_value["DeviceInfo"].has_key("Longitude"): latitude = self.tup_value["DeviceInfo"]["Longitude"] else: latitude = '' if self.tup_value["DeviceInfo"].has_key("Latitude"): longitude = self.tup_value["DeviceInfo"]["Latitude"] else: longitude = '' timestamp = self.timefield time_struct = time.strptime(timestamp, '%Y-%m-%d %H:%M:%S') timestamp = time.strftime("%Y%m%d%H%M%S", time_struct) sql = """INSERT INTO register(gameid,channel,devicetype,imei,mac,ipv4,os,uuid,username,latitude,longitude,timestamp) VALUES ("%s", "%s", "%s", "%s","%s","%s","%s","%s","%s","%s","%s","%s")""" % ( gameid, channel, devicetype, imei, mac, ipv4, os, uuid, username, latitude, longitude, timestamp) log.debug(sql) mysql_operation_obj = mysql_operation('logserver') mysql_operation_obj.mysql_insert(sql)