예제 #1
0
    def run(self):
        server_list = self.get_server_list()
        self.log("StatServerDate start %s" % get_time())

        if self.server_id is None:
            statServerDatas = StatServerDataCountry.query(
                condition="stat_date ='%s'" % self.date)
        else:
            statServerDatas = StatServerDataCountry.query(
                condition="stat_date ='%s' and server_id = '%s' " %
                (self.date, self.server_id))
        if not statServerDatas:
            for server in server_list:
                try:
                    if server.server_status == 100:
                        continue
                    countries = self.getServerCountryCode(server)
                    if countries:
                        for country in countries:
                            self.stat(server, self.date, country['idfa'])
                except Exception, ex:
                    self.log("server_name[%s] error" % server.server_name)
                    self.log(ex)

            self.log("StatServerDate end %s" % get_time())
 def run(self):
     server_list = self.get_server_list()
     self.log("StatServerDate start %s" % get_time())
     
     if self.server_id is None:
         statServerDatas = StatServerDataCountry.query(condition="stat_date ='%s'" % self.date)
     else:
         statServerDatas = StatServerDataCountry.query(condition="stat_date ='%s' and server_id = '%s' " % (self.date, self.server_id))
     if not statServerDatas:
         for server in server_list:
             try:
                 if server.server_status==100:
                     continue
                 countries = self.getServerCountryCode(server)
                 if countries :
                     for country in countries:
                         self.stat(server, self.date, country['idfa'])
             except Exception,ex:
                 self.log("server_name[%s] error" % server.server_name)
                 self.log(ex)
             
         self.log("StatServerDate end %s" % get_time())
예제 #3
0
            try:
                cursor = connection.cursor()
                sql = "select COALESCE(max(online),0) as max_online from stat_online where date(stat_time) = '%s' and server_id = '%s'" % (
                    date, values['server_id'])
                data = cursor.fetchone(sql)
                if not data and data['max_online'] is None:
                    values['max_online'] = 0
                else:
                    values['max_online'] = int(data['max_online'])
            except Exception, ex:
                self.log(ex)
            finally:
                if cursor is not None:
                    cursor.close()

            statServerData = StatServerDataCountry()
            statServerData.country_code = country
            for k, v in values.iteritems():
                setattr(statServerData, k, v)
            statServerData.stat_date = date
            if self.isInsert:
                statServerData.persist()
                #print ''
            else:
                self.statServerDatass.append(statServerData)

            date = get_date_str_by_day(date, 1, '%Y-%m-%d')
            #             if self.is_input:
            #                 break
            if string_to_datetime(date, '%Y-%m-%d') >= string_to_datetime(
                    get_date(), '%Y-%m-%d'):
            cursor = None
            try:
                cursor = connection.cursor()
                sql = "select COALESCE(max(online),0) as max_online from stat_online where date(stat_time) = '%s' and server_id = '%s'" % (date,values['server_id'])
                data = cursor.fetchone(sql)
                if not data and data['max_online'] is None:
                    values['max_online'] = 0
                else:
                    values['max_online'] = int(data['max_online'])
            except Exception,ex:
                self.log(ex)
            finally:
                if cursor is not None:
                    cursor.close()  
            
            statServerData = StatServerDataCountry()
            statServerData.country_code=country
            for k, v in values.iteritems():
                setattr(statServerData, k, v)
            statServerData.stat_date = date
            if self.isInsert:
                statServerData.persist()
                #print ''
            else:
                self.statServerDatass.append(statServerData)
            
            
            date = get_date_str_by_day(date,1,'%Y-%m-%d')
#             if self.is_input:
#                 break
            if string_to_datetime(date,'%Y-%m-%d') >= string_to_datetime(get_date(),'%Y-%m-%d') :