def update_entry(main): query=Entry.all() query.filter("illust_reply =",1) total_cnt=0 update_cnt=0 offset=0 if(main.request.get("from")): offset=int(main.request.get("from")) offset_to=10000 if(main.request.get("to")): offset_to=int(main.request.get("to")) while(offset<offset_to): list=query.fetch(limit=1000,offset=offset) for entry in list: total_cnt=total_cnt+1 if(entry.illust_reply_image_key):#not entry.illust_reply_image_key and entry.illust_reply_image): #entry.illust_reply_image_key=db.get(entry.illust_reply_image) entry.date=entry.create_date entry.put() update_cnt=update_cnt+1 if(update_cnt>=500): break offset=offset+1000 if(update_cnt>=500): break main.response.out.write("total"+str(total_cnt)+" update"+str(update_cnt))
def generate_feed(bbs, bbs_key): url = MappingId.get_usr_url("http://www.illustbook.net/", bbs) feed = feedgenerator.Rss201rev2Feed( title=bbs.bbs_name, link=url, feed_url=url, description=bbs.summary, language="ja" ) if bbs.bbs_mode == BbsConst.BBS_MODE_NO_IMAGE: entry_query = Entry.all().filter("bbs_key =", bbs) entry_query.order("-date") all_entry = entry_query.fetch(limit=20) for entry in all_entry: try: thread = entry.thread_key except: continue url2 = url + str(thread.key()) + ".html" txt = "" + entry.editor + "(" + str(entry.date) + ")<BR>" if entry.illust_reply: txt += "<IMG SRC='http://www.illustbook.net/img?img_id='" txt += str(entry.illust_reply_image_key.key()) + "'><BR>" txt += entry.content for res in entry.res_list: response = db.get(res) txt += "<BR><BR>" + response.editor + "(" + str(response.date) + ")<BR>" txt += "" + response.content + "<BR>" feed.add_item( title=thread.title, link=url2, description=txt, author_email="", author_name=entry.editor, author_link=entry.homepage_addr, pubdate=entry.date, ) else: thread_query = MesThread.all().filter("bbs_key =", bbs) thread_query.order("-create_date") all_threads = thread_query.fetch(limit=20) for thread in all_threads: url2 = url + str(thread.key()) + ".html" if thread.image_key: thumbnail = "http://www.illustbook.net/img?img_id=" + str(thread.image_key.key()) feed.add_item( title=thread.title, link=url2, description="<IMG SRC=" + thumbnail + "><BR>" + thread.summary, author_email="", author_name=thread.author, author_link=thread.homepage_addr, pubdate=thread.create_date, ) result = feed.writeString("utf-8") return result
def get_illust_reply(bbs,page,col_num): all_entries = None entries_num = 0 try: entry_query = Entry.all().filter("bbs_key =", bbs) entry_query.filter("illust_reply =",1) entry_query.filter("del_flag =",1) entry_query.order("-date") entries_num=entry_query.count() all_entries=entry_query.fetch(limit=col_num, offset=(page-1)*col_num) except: None return {"entry":all_entries,"count":entries_num}
def get(self): SetUtf8.set() user = users.get_current_user() is_admin=0 if(user): if(OwnerCheck.is_admin(user)): is_admin=1 if(not is_admin): Alert.alert_msg_with_write(self,"管理者権限が必要です。"); return message="" new_code=self.request.get('code') if(new_code): if(len(new_code)>=8): memcache.set("spamcheck",new_code) message="updated check code to "+new_code else: message="too short check code" checkcode=SpamCheck.get_check_code() query=Entry.all() thread=None try: thread=db.get(checkcode) except: thread=None if(thread): query.filter("thread_key =",thread) entrys=query.fetch(limit=1000) ret="" spam_detected=0 for entry in entrys: if(SpamCheck.check_with_thread(entry,checkcode)): ret+=entry.content+"<BR>" spam_detected=1 if(not spam_detected): ret="SpamNotFound" form="code:"+checkcode+"<BR>"+message+"<BR>" form+="<form method='GET' action='spam_check'>thread_key:<input type='text' name='code' size=40><input type='submit' value='UPDATE'></form>"; Alert.alert_msg_with_write(self,"<H2>SPAM CHECKER</H2><H3>CHECK CODE</H3>"+form+"<H3>SPAM LIST</H3>"+ret+"<BR><BR><A HREF='./spam_delete'>DELETE ALL</A>")
def get(self): SetUtf8.set() #ランキング更新 rank=Ranking.get_or_insert(BbsConst.THREAD_RANKING_KEY_NAME) rank.create_rank(self) ApiFeed.invalidate_cache(); #キャッシュ取得 cache=SiteAnalyzer.get_cache_from_db(); #1日単位で習得 #force=False #if(self.request.get("force")): # force=True if(cache.date and len(cache.day_list)>=1):# and not force): day1_str=NicoTracker.get_day_string(cache.date) day2_str=NicoTracker.get_day_string(datetime.datetime.today()) if(day1_str==day2_str): Alert.alert_msg_with_write(self,"ランキングを更新しました。統計情報はまだ1日が経過していないので計測していません。") return #コメント数と再生数を取得 bbs_cnt=Bbs.all().count(limit=100000) illust_cnt=MesThread.all().count(limit=100000) entry_cnt=Entry.all().count(limit=100000) user_cnt=Bookmark.all().count(limit=100000) #書き込み day_str=NicoTracker.get_day_string(datetime.datetime.today()) cache.entry_cnt_list.insert(0,entry_cnt) cache.illust_cnt_list.insert(0,illust_cnt) cache.bbs_cnt_list.insert(0,bbs_cnt) cache.user_cnt_list.insert(0,user_cnt) cache.day_list.insert(0,day_str) cache.bbs_n=bbs_cnt cache.illust_n=illust_cnt cache.put() Alert.alert_msg_with_write(self,"ランキングを更新しました。")
def delete_thread_core(thread): #イラストの総数の更新リクエスト thread.bbs_key.cached_threads_num=None thread.bbs_key.put() if(thread.user_id): ApiUser.invalidate_thread_count(thread.user_id) #レスの削除 entry_query=Entry.all().filter("thread_key =",thread) for entry in entry_query: if(entry.illust_reply_image_key): entry.illust_reply_image_key.delete() #画像の削除 if(thread.image_key): if(thread.image_key.chunk_list_key): for key in thread.image_key.chunk_list_key: db.get(key).delete() thread.image_key.delete() thread.delete()
def get(self): SetUtf8.set() user = users.get_current_user() is_admin=0 if(user): if(OwnerCheck.is_admin(user)): is_admin=1 if(not is_admin): self.response.out.write(Alert.alert_msg("管理者権限が必要です。",self.request.host)); return checkcode=SpamCheck.get_check_code() query=Entry.all() thread=None try: thread=db.get(checkcode) except: thread=None if(thread): query.filter("thread_key =",thread) entrys=query.fetch(limit=1000) ret=0 aborted="" for entry in entrys: if(SpamCheck.check_with_thread(entry,checkcode)): entry.delete() ret=ret+1 if(ret>=250): aborted="ABORTED" break; RecentCommentCache.invalidate(None); self.response.out.write(Alert.alert_msg("<H2>SPAM DELETE RESULT</H2>"+aborted+"<H2>TOTAL</H2>DELETE CNT:"+str(ret),self.request.host))
def get(self): user = users.get_current_user() is_admin=0 is_high_admin=0 account="ログインしていない状態" if(user): account="アカウント"+user.email() is_admin=1 if(OwnerCheck.is_admin(user)): is_high_admin=1 SetUtf8.set() thread_query = MesThread.all().order('-create_date') cnt=thread_query.count(10000) thread_page_unit=12 thread_page=1 if self.request.get("page"): thread_page = int(self.request.get("page")) thread_page_list=PageGenerate.generate_page(thread_page,cnt,thread_page_unit) comment_page=1 only_comment=0 if self.request.get("comment_page"): comment_page = int(self.request.get("comment_page")) only_comment=1 if(not only_comment): thread_query.filter("illust_mode =",1) thread=thread_query.fetch(limit=thread_page_unit,offset=(thread_page-1)*thread_page_unit) new_moper_query=MesThread.all().order("-create_date") new_moper_query.filter("illust_mode =",2) new_moper=new_moper_query.fetch(limit=12) entry=None try: entry_query = Entry.all().order('-create_date') entry_query.filter("illust_reply =",1) entry=entry_query.fetch(limit=thread_page_unit,offset=(thread_page-1)*thread_page_unit) except: None else: thread=None new_moper=None entry=None comment=None try: comment_unit=7 comment_query = Entry.all().order('-create_date') comment_query.filter("del_flag =", 1) comment=comment_query.fetch(limit=comment_unit,offset=comment_unit*(comment_page-1)) except: None if(not only_comment): new_bbs_count=SiteAnalyzer.create_graph(self,0); new_illust_count=SiteAnalyzer.create_graph(self,1); new_entry_count=SiteAnalyzer.create_graph(self,2); new_user_count=SiteAnalyzer.create_graph(self,3); today_start = datetime.datetime.today() week_start = today_start - datetime.timedelta(days=7) month1_start = today_start - datetime.timedelta(days=31) weekly=Bbs.all().filter("date >=",week_start).count(limit=10000) monthly=Bbs.all().filter("date >=",month1_start).count(limit=10000) else: new_bbs_count=0 new_illust_count=0 new_entry_count=0 new_user_count=0 weekly=0 monthly=0 if os.environ["SERVER_SOFTWARE"].find("Development")!=-1: new_moper=[] host_url ="./" template_values = { 'host': host_url, 'threads':thread, 'moper_threads':new_moper, 'entries':entry, 'comment':comment, 'new_bbs_count':new_bbs_count, 'new_entry_count':new_entry_count, 'new_illust_count':new_illust_count, 'new_user_count':new_user_count, 'is_admin':is_admin, 'is_high_admin': is_high_admin, 'account':account, 'url_logout':users.create_logout_url("./admin"), 'url_login':users.create_login_url("./admin"), 'page_list':thread_page_list, 'page_url_base':"./admin?page=", 'page':thread_page, 'weekly':weekly, 'monthly':monthly, 'comment_page':comment_page, 'only_comment': only_comment } path = '/html/admin.html' render=template_select.render(path, template_values) self.response.out.write(render)