def post(self): # should run at most 1/s try: # def txn(): # timestamp = self.request.get('timestamp') # queueinf = database.QueueInf(txtdesc = timestamp, instime = time.strftime('%Y%m%d%H%M%S')) # queueinf.put() # db.run_in_transaction(txn) pass except: logging.debug(traceback.format_exc())
def get(self): sqlstmt = 'select * from ClearRule' clearrule = db.GqlQuery(sqlstmt) for rule in clearrule: logging.debug(rule.tabname) today = datetime.date.today() whenday = today - datetime.timedelta(rule.reservedays) sqlstmt = 'select * from %s where %s <= %s and %s' \ % (rule.tabname, rule.datefld, whenday.strftime('%y%m%d%H%M%S'), rule.condtion) query = db.GqlQuery(sqlstmt) for result in query: result.delete()
def post(self): try: kind = self.request.get("kind") logging.debug(kind) if kind == "zhihuribao": insdate = self.request.get("insdate") result = GqlQuery("select * from zhihuribao where insdate = '%s'" % (insdate,)) ribao = u"\n\n".join([u"%s\n%s" % (r.title, r.href) for r in result]) subscribeusrs = GqlQuery("select * from subscription where rssid = 'zhihuribao'") for user in subscribeusrs: if user.email != "": logging.debug(user.email) mail.send_mail(sender='*****@*****.**', to=user.email, subject='知乎日报-%s' % insdate, body=ribao) else: logging.debug("something wrong") self.response.out.write("Ok") except: logging.error(format_exc())