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})
