def get(self,key): uri = self.request.uri request = {} pin = Pin() pin_keys = pin.getByKeyValues("board",key) pin_count = len(pin_keys) query = {} query['q'] = "board:%s" % key query['start'] = "0" query['rows'] = globalSetting['max_index_pin_rows'] query['sort'] = "createTime" if "page" in uri: request = urldecode(uri) page = int(request['page']) query['start'] = query['rows']*page if pin_count < query['rows']*page: return '' pin_data = pin.solr(query) print len(pin_data) marks_dict = pin.formatPins(pin_data) if request: #print request['callback'] #print request['page'] callback_result = { 'filter':'pin:index', 'pins':marks_dict } callback_response = "%s(%s)" % (request['callback'],json.dumps(callback_result)) self.set_header("Content-Type", "text/html; charset=utf-8") return self.write(callback_response) else: marks = '' for _mark_t in marks_dict: marks = self.render_string('mark.html',mark=_mark_t)+marks board = Board() user = User() category = Category() board_data = board.get(key) b_user = user.getDetail(board_data['user']) b_category = category.get(board_data['category']) b_keys = board.getByKeyValues("user", board_data['user']) if key in b_keys: b_keys.remove(key) b_boards = board.all(b_keys) self.render('board_pins_list.html',f_board = self.formatFollowBoardData(key), b_boards= b_boards,b_category = b_category,b_user=b_user,user=self.currentUserInfo(),board = board.get(key),marks=marks)
def create_events_categories(self, cat_titles: list, event_id: int): ''' Associates a category with an event ''' cats = [{ 'category': Category.get(Category.title == title).id, 'event': event_id } for title in cat_titles] EventsCategory.insert_many(cats).execute()
def get_blog_detail(cls, blog_id): blog = cls.get(cls.id == blog_id) blogtags = BlogTags.get(BlogTags.blog_id == blog.id) tag = Tags.get(Tags.id == blogtags.tags_id).tag blogcategory = BlogCategory.get(BlogCategory.blog_id == blog_id) category = Category.get(Category.id == blogcategory.category_id).category return blog, tag, category
def put(self, cat_id): form = ApiCategoryForm(request.form) if form.validate(): c = Category.get(cat_id) if c.user_id != session['user_id']: return jsonify({'code': 2, 'message': 'has no permission to modify the category'}) else: form.fill_data_to_instance(c) return jsonify(code=0, data=c.json) return jsonify({'code': 1, 'message': form.errors})
def get(self, cid): if not cid or not Category.get(cid): abort(404) if cid == 1: return redirect(url_for('main.home')) news_header = News.get_by_category(cid, order='create_time desc', start=0, limit=7) news_latest = News.get_by_category(cid, order='create_time desc', start=7) news_popular = News.get_by_category(cid, order='read_count desc', start=0) loginform = LoginForm() regform = RegisterForm() return render_template('index.html', **locals())
def category_retrieve(): id = request.args.get('id', 0) if id: category = Category.get(id) if not category: return error(404, 'category not exist') return category # start = request.args.get('start', 0) # limit = int(request.args.get('limit', PAGE_LIMIT)) # category还要start??, data = {} data['start'] = 0 data['data'] = Category.get_all() data['count'] = len(data['data']) return data
def get(self): id = self.get_argument("id", "") if not id: return self.write("农产品id为空") try: product = Agricultural_Product.select().where( Agricultural_Product.id == id).get() except: product = Agricultural_Product() print(product.name) category_id = product.category_id try: category = Category.get(Category.id == category_id) except: category = Category() print(category.name) self.write("ok")
def get_category(cls, blog_id): category_id = cls.get(cls.blog_id == blog_id).category_id return Category.get(Category.id == category_id).category
def get_blog_by_category(cls, category): category_id = Category.get(Category.category == category).id blogs_categorys = BlogCategory.select(BlogCategory.blog_id).where(BlogCategory.category_id == category_id) return cls.select().filter(cls.id << blogs_categorys)
def delete(self, cat_id): c = Category.get(cat_id) if c: c.delete() return jsonify({'code': 0}) return jsonify({'code': 1, 'message': 'category not exist'})
def get(self, cat_id): return jsonify({'code': 0, 'data':Category.get(cat_id).json})