def delete(self): dayto = datetime.datetime.now() datefrom = DateUtils.getDate(dayto, constants.TIME_LIMIT) sql = "delete from mails where (state=%s or state<0) and finish_time < '%s'::timestamp" % ( constants.MAIL_SUCCESS, datefrom) #print sql return dbconn().delete(sql)
def isContinue(mail): dayto = datetime.datetime.now() datefrom = DateUtils.getDate(dayto, constants.TIME_LIMIT) sql = "select count(*) as count from mails where smtp_host='%s' and state=5 and finish_time between '%s'::timestamp and '%s'::timestamp" % (mail['smtp_host'], datefrom, dayto) result = dbconn().getOne(sql) if result['count'] >= constants.TIME_MAX_COUNT: return True else: return False
def isContinue(self, mail): dayto = datetime.datetime.now() datefrom = DateUtils.getDate(dayto, constants.TIME_LIMIT) sql = "select count(*) as count from mails where smtp_host='%s' and state=5 and finish_time between '%s'::timestamp and '%s'::timestamp" % ( mail['smtp_host'], datefrom, dayto) result = dbconn().getOne(sql) if result['count'] >= constants.TIME_MAX_COUNT: return True else: return False
def delete(self): dayto = datetime.datetime.now() datefrom = DateUtils.getDate(dayto, constants.TIME_LIMIT) sql = "delete from mails where (state=%s or state<0) and finish_time < '%s'::timestamp"% (constants.MAIL_SUCCESS, datefrom) #print sql return dbconn().delete(sql)