def checknewscomments(news): orm.sql_debug(False) if not news: with orm.db_session: first_newsitem = orm.select(orm.min(x.id) for x in NewsItem).first() last_newsitem = orm.select(orm.max(x.id) for x in NewsItem).first() newsitem_id = first_newsitem else: i = 0 while True: with orm.db_session: if not news: newsitem = NewsItem.select(lambda x: x.id >= newsitem_id and x.id <= last_newsitem).first() if not newsitem: break else: if i >= len(news): break if news[i].isdigit(): newsitem = NewsItem.get(id=int(news[i])) else: newsitem = NewsItem.get(name=news[i]) i += 1 if not newsitem: print('News item {} not found'.format(news[i - 1])) continue print('News item {} ({})'.format(newsitem.id, newsitem.name)) comments_list = newsitem.bl.select_comments().order_by('c.date, c.id') check_comments_for(newsitem, comments_list) newsitem_id = newsitem.id + 1
def parse_news_id(news_id): if not news_id.isdigit(): newsitem = NewsItem.get(name=news_id) if not newsitem: abort(404) return newsitem.id return int(news_id)
def parse_news_id(news_id): if not news_id.isdigit(): newsitem = NewsItem.get(name=news_id) if not newsitem: abort(404) return newsitem.id return int(news_id)
def shown_newsitem(): n = NewsItem.get(show=True) if not n: return last_id = request.cookies.get('last_newsitem') if last_id and last_id.isdigit() and int(last_id) == n.id: return return n
def show(name, comments_page): newsitem = NewsItem.get(name=name) if not newsitem: abort(404) if newsitem.is_template: template = current_app.jinja_env.from_string(newsitem.content) template.name = 'db/news/{}.html'.format(name) content = render_template(template, newsitem_name=newsitem.name, newsitem_title=newsitem.title) else: content = newsitem.content per_page = current_user.comments_per_page or current_app.config[ 'COMMENTS_COUNT']['page'] maxdepth = None if request.args.get('fulltree') == '1' else calc_maxdepth( current_user) comments_count, paged, comments_tree_list = newsitem.bl.paginate_comments( comments_page, per_page, maxdepth) paged.page_arg_name = 'comments_page' if not comments_tree_list and paged.number != 1: abort(404) comment_ids = [x[0].id for x in comments_tree_list] if current_user.is_authenticated: comment_votes_cache = newsitem.bl.select_comment_votes( current_user._get_current_object(), comment_ids) else: comment_votes_cache = {i: 0 for i in comment_ids} data = { 'page_title': newsitem.title, 'newsitem': newsitem, 'content': Markup(content), 'comments_count': comments_count, 'page_obj': paged, 'comments_tree_list': comments_tree_list, 'comment_form': CommentForm(), 'comment_votes_cache': comment_votes_cache, 'sub_comments': newsitem.bl.get_comments_subscription( current_user._get_current_object()), } return render_template('news/show.html', **data)
def add(news_id): newsitem = NewsItem.get(id=parse_news_id(news_id)) if not newsitem: abort(404) # Все проверки доступа там return common_comment.add( 'newsitem', newsitem, template='news/comment_work.html', )
def add(news_id): newsitem = NewsItem.get(id=parse_news_id(news_id)) if not newsitem: abort(404) # Все проверки доступа там return common_comment.add( 'newsitem', newsitem, template='news/comment_work.html', )
def index(page): objects = NewsItem.select().order_by(NewsItem.id.desc()) return paginate_view( 'admin/news/index.html', objects, count=objects.count(), page_title=gettext('News'), objlistname='news', per_page=100, )
def index(page): objects = NewsItem.select().order_by(NewsItem.id.desc()) return paginate_view( 'news/index.html', objects, count=objects.count(), page_title=gettext('News'), objlistname='news', per_page=100, )
def ajax_tree(news_id, local_id): newsitem = NewsItem.get(id=parse_news_id(news_id)) if not newsitem: abort(404) comment = newsitem.comments.select(lambda x: x.local_id == local_id).first() if not comment: abort(404) return common_comment.ajax_tree( 'newsitem', comment, target=newsitem, )
def checknewscomments(news): orm.sql_debug(False) if not news: with orm.db_session: first_newsitem = orm.select(orm.min(x.id) for x in NewsItem).first() last_newsitem = orm.select(orm.max(x.id) for x in NewsItem).first() newsitem_id = first_newsitem else: i = 0 while True: with orm.db_session: if not news: newsitem = NewsItem.select(lambda x: x.id >= newsitem_id and x. id <= last_newsitem).first() if not newsitem: break else: if i >= len(news): break if news[i].isdigit(): newsitem = NewsItem.get(id=int(news[i])) else: newsitem = NewsItem.get(name=news[i]) i += 1 if not newsitem: print('News item {} not found'.format(news[i - 1])) continue print('News item {} ({})'.format(newsitem.id, newsitem.name)) comments_list = newsitem.bl.select_comments().order_by( 'c.date, c.id') check_comments_for(newsitem, comments_list) newsitem_id = newsitem.id + 1
def comments_subscribe(name): user = current_user._get_current_object() newsitem = NewsItem.get(name=name) if not newsitem: abort(404) newsitem.bl.subscribe_to_comments( user, email=request.form.get('email') == '1', tracker=request.form.get('tracker') == '1', ) if request.form.get('short') == '1': return jsonify(success=True) return redirect(url_for('newsitem.show', name=newsitem.name))
def comments_subscribe(name): user = current_user._get_current_object() newsitem = NewsItem.get(name=name) if not newsitem: abort(404) newsitem.bl.subscribe_to_comments( user, email=request.form.get('email') == '1', tracker=request.form.get('tracker') == '1', ) if request.form.get('short') == '1': return jsonify(success=True) return redirect(url_for('newsitem.show', name=newsitem.name))
def ajax_tree(news_id, local_id): newsitem = NewsItem.get(id=parse_news_id(news_id)) if not newsitem: abort(404) comment = newsitem.comments.select( lambda x: x.local_id == local_id).first() if not comment: abort(404) return common_comment.ajax_tree( 'newsitem', comment, target=newsitem, )
def ajax(news_id, page): newsitem = NewsItem.get(id=parse_news_id(news_id)) if not newsitem: abort(404) per_page = current_user.comments_per_page or current_app.config['COMMENTS_COUNT']['page'] link = url_for('news.show', name=newsitem.name, comments_page=page) return common_comment.ajax( 'newsitem', newsitem, link, page, per_page, template_pagination='news/comments_pagination.html', )
def ajax(news_id, page): newsitem = NewsItem.get(id=parse_news_id(news_id)) if not newsitem: abort(404) per_page = current_user.comments_per_page or current_app.config[ 'COMMENTS_COUNT']['page'] link = url_for('news.show', name=newsitem.name, comments_page=page) return common_comment.ajax( 'newsitem', newsitem, link, page, per_page, template_pagination='news/comments_pagination.html', )
def update(self, author, data): from mini_fiction.models import AdminLog data = Validator(NEWS_ITEM).validated(data, update=True) newsitem = self.model if not author.is_superuser and (newsitem.is_template or data.get('is_template')): raise ValidationError( {'is_template': [lazy_gettext('Access denied')]}) if 'name' in data: from mini_fiction.models import NewsItem exist_newsitem = NewsItem.get(name=data['name']) if exist_newsitem and exist_newsitem.id != newsitem.id: raise ValidationError( {'name': [lazy_gettext('Page already exists')]}) if data.get('is_template', newsitem.is_template) and 'content' in data: self.check_renderability(author, data.get('name', newsitem.name), data['content']) if data.get('show') and not newsitem.show: self.hide_shown_newsitem() changed_fields = set() for key, value in data.items(): if getattr(newsitem, key) != value: setattr(newsitem, key, value) changed_fields |= { key, } if changed_fields: AdminLog.bl.create( user=author, obj=newsitem, action=AdminLog.CHANGE, fields=sorted(changed_fields), ) return newsitem
def delete(pk): newsitem = NewsItem.get(id=pk) if not newsitem: abort(404) if not current_user.is_superuser: if newsitem.is_template: abort(403) if request.method == 'POST': try: newsitem.bl.delete(current_user._get_current_object()) except ValidationError: abort(403) else: return redirect(url_for('admin_news.index')) return render_template( 'admin/news/delete.html', page_title=gettext('Delete'), newsitem=newsitem, )
def show(name, comments_page): newsitem = NewsItem.get(name=name) if not newsitem: abort(404) if newsitem.is_template: template = current_app.jinja_env.from_string(newsitem.content) template.name = 'db/news/{}.html'.format(name) content = render_template(template, newsitem_name=newsitem.name, newsitem_title=newsitem.title) else: content = newsitem.content per_page = current_user.comments_per_page or current_app.config['COMMENTS_COUNT']['page'] maxdepth = None if request.args.get('fulltree') == '1' else calc_maxdepth(current_user) comments_count, paged, comments_tree_list = newsitem.bl.paginate_comments(comments_page, per_page, maxdepth) paged.page_arg_name = 'comments_page' if not comments_tree_list and paged.number != 1: abort(404) comment_ids = [x[0].id for x in comments_tree_list] if current_user.is_authenticated: comment_votes_cache = newsitem.bl.select_comment_votes(current_user._get_current_object(), comment_ids) else: comment_votes_cache = {i: 0 for i in comment_ids} data = { 'page_title': newsitem.title, 'newsitem': newsitem, 'content': Markup(content), 'comments_count': comments_count, 'page_obj': paged, 'comments_tree_list': comments_tree_list, 'comment_form': CommentForm(), 'comment_votes_cache': comment_votes_cache, 'sub_comments': newsitem.bl.get_comments_subscription(current_user._get_current_object()), } return render_template('news/show.html', **data)
def update(pk): newsitem = NewsItem.get(id=pk) if not newsitem: abort(404) form = NewsItemForm( data={ 'name': newsitem.name, 'title': newsitem.title, 'is_template': newsitem.is_template, 'show': newsitem.show, 'content': newsitem.content, }) saved = False can_edit = True if not current_user.is_superuser: if newsitem.is_template: can_edit = False del form.is_template if can_edit and form.validate_on_submit(): try: newsitem.bl.update(current_user._get_current_object(), form.data) except ValidationError as exc: form.set_errors(exc.errors) else: saved = True return render_template( 'admin/news/work.html', page_title='{} — {}'.format(newsitem.name, newsitem.title or newsitem.name), newsitem=newsitem, form=form, can_edit=can_edit, edit=True, saved=saved, )
def delete(pk): newsitem = NewsItem.get(id=pk) if not newsitem: abort(404) if not current_user.is_superuser: if newsitem.is_template: abort(403) if request.method == 'POST': try: newsitem.bl.delete(current_user._get_current_object()) except ValidationError: abort(403) else: return redirect(url_for('admin_news.index')) return render_template( 'admin/news/delete.html', page_title=gettext('Delete'), newsitem=newsitem, )
def update(pk): newsitem = NewsItem.get(id=pk) if not newsitem: abort(404) form = NewsItemForm(data={ 'name': newsitem.name, 'title': newsitem.title, 'is_template': newsitem.is_template, 'show': newsitem.show, 'content': newsitem.content, }) saved = False can_edit = True if not current_user.is_superuser: if newsitem.is_template: can_edit = False del form.is_template if can_edit and form.validate_on_submit(): try: newsitem.bl.update(current_user._get_current_object(), form.data) except ValidationError as exc: form.set_errors(exc.errors) else: saved = True return render_template( 'admin/news/work.html', page_title='{} — {}'.format(newsitem.name, newsitem.title or newsitem.name), newsitem=newsitem, form=form, can_edit=can_edit, edit=True, saved=saved, )
def update(self, author, data): from mini_fiction.models import AdminLog data = Validator(NEWS_ITEM).validated(data, update=True) newsitem = self.model if not author.is_superuser and (newsitem.is_template or data.get('is_template')): raise ValidationError({'is_template': [lazy_gettext('Access denied')]}) if 'name' in data: from mini_fiction.models import NewsItem exist_newsitem = NewsItem.get(name=data['name']) if exist_newsitem and exist_newsitem.id != newsitem.id: raise ValidationError({'name': [lazy_gettext('Page already exists')]}) if data.get('is_template', newsitem.is_template) and 'content' in data: self.check_renderability(author, data.get('name', newsitem.name), data['content']) if data.get('show') and not newsitem.show: self.hide_shown_newsitem() changed_fields = set() for key, value in data.items(): if getattr(newsitem, key) != value: setattr(newsitem, key, value) changed_fields |= {key,} if changed_fields: AdminLog.bl.create( user=author, obj=newsitem, action=AdminLog.CHANGE, fields=sorted(changed_fields), ) return newsitem
def hide_shown_newsitem(self): from mini_fiction.models import NewsItem n = NewsItem.get(show=True) if n: n.show = False
def news(params): news_list = list(NewsItem.select().order_by(NewsItem.id.desc())[:3]) return render_template('sidebar/news.html', news=news_list)
def news(params): news_list = list(NewsItem.select().order_by(NewsItem.id.desc())[:3]) return render_template('sidebar/news.html', news=news_list)
def hide_shown_newsitem(self): from mini_fiction.models import NewsItem n = NewsItem.get(show=True) if n: n.show = False