def category():
form = CategoryForm()
if request.method == 'GET':
categorys = Category.query.all()
return render_template('back/category.html',
categorys=categorys,
form=form)
if request.method == 'POST':
if form.validate_on_submit():
category = Category()
category.c_name = form.data.get('name')
category.nickname = form.data.get('nickname')
category.keywords = form.data.get('keywords')
category.save()
categorys = Category.query.all()
return render_template('back/category.html',
message='添加成功',
categorys=categorys,
form=form)
# errors = form.errors
categorys = Category.query.all()
return render_template('back/category.html',
message='添加有误',
categorys=categorys,
form=form)
def category_change(id):
form = CategoryForm()
if request.method == 'GET':
# 获取对象，渲染页面
category = Category.query.filter(Category.id == id).first()
return render_template('back/category2.html',
category2=category,
form=form)
if request.method == 'POST':
# 修改数据
if form.validate_on_submit():
category = Category.query.filter(Category.id == id).first()
category.c_name = form.data.get('name')
category.nickname = form.data.get('nickname')
category.keywords = form.data.get('keywords')
category.save()
categorys = Category.query.all()
return render_template('back/category.html',
categorys=categorys,
message='修改成功',
form=form)
# errors = form.errors
return render_template('back/category2.html',
message='添加有误',
form=form)
if request.method == 'DELETE':
# 实现删除栏目
category = Category.query.filter(Category.id == id).first()
category.delete()
# categorys = Category.query.all()
data = {'code': 200, 'msg': '删除成功'}
return jsonify(data)
def index(request):
if request.method == 'POST':
form = BrandForm(request.POST)
if form.is_valid():
form.save()
return HttpResponseRedirect('/')
form = BrandForm()
if request.method == 'POST':
category_form = CategoryForm(request.POST)
if form.is_valid():
form.save()
return HttpResponseRedirect('/')
category_form = CategoryForm()
if request.method == 'POST':
item_form = ItemForm(request.POST)
if item_form.is_valid():
item_form.save()
return HttpResponseRedirect('/')
item_form = ItemForm()
return render(request, 'index.html', {
'form': form,
'item_form': item_form,
'category_form': category_form
})
def submit_category(self):
storage = request.form
form = CategoryForm(storage)
is_valid = form.validate()
is_new = int(storage['category_id']) < 0
if not is_valid:
return render_template('forms/category.html',
form=form,
new=is_new)
if is_new: # Adding a new category
result = add_category(storage['category_html'],
storage['category_human'])
if result:
message = 'Category successfully added!'
else:
message = 'Category failed to be added; please try again.'
else: # Editing an existing category
result = edit_category(storage['category_id'],
storage['category_html'],
storage['category_human'])
if result:
message = 'Category successfully edited!'
else:
message = 'Category failed to be edited; please try again.'
if result:
return render_template('confirmation_page.html', message=message)
else:
return render_template('error_page.html', error=message)
def add_category(user_id, book_id):
rating_form = RatingForm()
comment_form = CommentForm()
category_form = CategoryForm()
book = Book.query.get(book_id)
if category_form.validate_on_submit():
ub = User_Book.query.filter_by(user_id=user_id,
book_id=book_id).first()
if ub:
ub.category = category_form.category.data
else:
ub = User_Book(user_id=user_id,
book_id=book_id,
category=category_form.category.data)
db.session.add(ub)
db.session.commit()
return redirect(url_for('book', book_id=book_id))
return render_template('book.html',
title=book.title,
GENRES=GENRES,
book=book,
rating_form=rating_form,
comment_form=comment_form,
category_form=category_form)
def add():
form = CategoryForm()
if form.validate():
c = Category(form.category_name.data, form.description.data)
db.session.add(c)
db.session.commit()
return redirect(url_for('category.index'))
def index():
userform = AddUserForm()
categoryform = CategoryForm()
if userform.validate_on_submit():
user = User(name=userform.name.data, email=userform.email.data)
user.set_password(userform.password.data)
db.session.add(user)
db.session.commit()
flash('User registration successful')
return redirect(url_for('index'))
if categoryform.validate_on_submit():
cat = Category(title=categoryform.title.data)
db.session.add(cat)
db.session.commit()
flash('New Category added successful')
return redirect(url_for('index'))
totalusers = db.session.query(User).count()
totalcategory = db.session.query(Category).count()
totalposts = db.session.query(Post).count()
return render_template('Adminindex.html',
title='Admin Panel',
admin='admin',
userform=userform,
categoryform=categoryform,
totalusers=totalusers,
totalcategory=totalcategory,
totalposts=totalposts)
def new_category():
form = CategoryForm()
if form.validate_on_submit():
with db.auto_commit():
name = form.name.data
db.session.add(Category(name=name))
flash('分类创建成功', 'success')
return redirect(url_for('web.manage_categories'))
return render_template('admin/new_category.html', form=form)
def new_category():
form = CategoryForm()
if form.validate_on_submit():
category = Category(cname=form.name.data)
db.session.add(category)
db.session.commit()
flash('Category newed.', 'success')
return redirect(url_for('.manage_post'))
return render_template('admin/new_category.html', form=form)
def edit_category(category_id):
form = CategoryForm()
category = Category.query.get_or_404(category_id)
if form.validate_on_submit():
category.name=form.name.data
db.session.commit()
flash('修改分类成功')
return redirect(url_for('.manage_category'))
form.name.data = category.name
return render_template('admin/edit_category.html', form=form)
def new_category():
form = CategoryForm(request.form)
if request.method == 'POST' and form.validate():
new = Categories(name=request.form['name'],
user_id=login_session['user_id'])
db_session.add(new)
db_session.commit()
flash('Category {} has been successfully created!'.format(new.name))
return redirect(url_for('home.index'))
return render_template('/newcategory.html', form=form)
def createCategory():
category_form = CategoryForm()
if request.method == 'POST' and category_form.validate_on_submit():
category = Category(name=category_form.data['category_name'],
user_id=session.get('user_id'))
db.session.add(category)
db.session.commit()
flash('Category created successfully', 'success')
return redirect(
url_for('catalog.viewCategory', category_name=category.name))
return render_template('create_category.html', category_form=category_form)
def add_category():
form = CategoryForm()
if not form.validate_on_submit():
flash(list(form.errors.values())[0])
return redirect(url_for('admin.categories'))
if Category().check_category(request.form.get('category')):
flash('Category already exists. Please try again')
return redirect(url_for('admin.categories'))
Category(cat=request.form.get('category')).add()
return redirect(url_for('admin.categories'))
def edit(category_id):
form = CategoryForm()
if form.validate():
c = Category.query.filter(Category.category_name==category_id).first()
sc = Category.query.filter(Category.category_name==form.category_name.data).count()
if sc > 0:
return redirect(url_for('category.index'))
c.category_name = form.category_name.data
c.description = form.description.data
db.session.add(c)
db.session.commit()
return redirect(url_for('category.index'))
def edit_category(category_id):
form = CategoryForm()
category = Category.query.get_or_404(category_id)
if category.id == 1:
flash('默认分类不能修改！', 'warning')
return redirect(url_for('web.index'))
if form.validate_on_submit():
with db.auto_commit():
category.name = form.name.data
flash('分类更新成功', 'success')
return redirect(url_for('web.manage_categories'))
form.name.data = category.name
return render_template('admin/edit_category.html', form=form)
def admin_categories():
category_form = CategoryForm()
if request.method == 'POST' and category_form.validate_on_submit():
category = Category(name=request.form['category_name'])
db.session.add(category)
db.session.commit()
db.session.flush()
flask.flash('Your category has been created', 'success')
return flask.render_template(Theme.get_template(page='admin_categories'),
manager=ModelManager, form=category_form)
def edit_category(category_id):
form = CategoryForm()
category = Category.query.get_or_404(category_id)
if category.id == 1:
flash('You can not edit the default category.', 'warning')
return redirect(url_for('web.index'))
if form.validate_on_submit():
category.name = form.name.data
db.session.commit()
flash('Category updated.', 'success')
return redirect(url_for('.manage_category'))
form.name.data = category.name
return render_template('admin/edit_category.html', form=form)
def process_category_form(request):
category_form = CategoryForm(prefix="category_form")
# Check whether the category form is for a project or subproject
project_id = category_form.project_id.data
subproject_id = 0
if category_form.subproject_id.data:
subproject_id = category_form.subproject_id.data
# Remove category
if category_form.remove.data:
Category.query.filter_by(id=category_form.id.data).delete()
db.session.commit()
flash(
'<span class="text-default-green">Categorie "%s" is verwijderd</span>'
% (category_form.name.data))
return return_redirect(project_id, subproject_id)
# Update or save category
if category_form.validate_on_submit():
category = Category.query.filter_by(id=category_form.id.data)
if len(category.all()):
category.update({'name': category_form.name.data})
db.session.commit()
flash(
'<span class="text-default-green">Categorie is bijgewerkt</span>'
)
else:
try:
if subproject_id:
category = Category(name=category_form.name.data,
subproject_id=subproject_id)
else:
category = Category(name=category_form.name.data,
project_id=project_id)
db.session.add(category)
db.session.commit()
flash('<span class="text-default-green">Categorie '
f'{category_form.name.data} is toegevoegd</span>')
except IntegrityError as e:
db.session().rollback()
app.logger.error(repr(e))
flash(
'<span class="text-default-red">Categorie toevoegen mislukt: naam '
f'"{category_form.name.data}" bestaat al, kies een '
'andere naam<span>')
# Redirect back to clear form data
return return_redirect(project_id, subproject_id)
else:
flash_form_errors(category_form, request)
def editCategory(category_name, **kwds):
category = kwds['category']
category_form = CategoryForm()
if request.method == 'POST' and category_form.validate_on_submit():
category.name = category_form.data['category_name']
db.session.add(category)
db.session.commit()
flash('Category edited successfully', 'success')
return redirect(
url_for('catalog.viewCategory', category_name=category.name))
category_form.category_name.data = category.name
return render_template('edit_category.html',
category_form=category_form,
category=category)
def category():
form = CategoryForm()
if form.validate_on_submit():
category_slug = slugify(form.category.data)
category = Category(category=form.category.data,
timestamp=datetime.utcnow(),
author=g.user,
category_slug=category_slug)
db.session.add(category)
db.session.commit()
flash("Category created!")
else:
flash("Nothing happened.")
return redirect(url_for("index"))
def deleteCategory(category_name, **kwds):
category = kwds['category']
category_form = CategoryForm()
category_form.category_name.data = category.name
if request.method == 'POST' and category_form.validate_on_submit():
for item in category.items:
db.session.delete(item)
db.session.delete(category)
db.session.commit()
flash('Category deleted successfully', 'success')
return redirect(url_for('catalog.recentItems'))
return render_template('delete_category.html',
category_form=category_form,
category=category)
def edit_category(category_id):
form = CategoryForm()
category = Category.query.get_or_404(category_id)
if category.id == 1:
flash('您无法编辑默认分类。', 'warning')
return redirect(url_for('blog.index'))
if form.validate_on_submit():
category.name = form.name.data
db.session.commit()
flash('类别已更新。', 'success')
return redirect(url_for('.manage_category'))
form.name.data = category.name
return render_template('admin/edit_category.html', form=form)
def new_category():
if g.user.permission >= 1:
return redirect(url_for('admin.index'))
form = CategoryForm()
if form.validate_on_submit():
name = form.name.data
cat = Category()
cat.name = name
db.session.add(cat)
db.session.commit()
return redirect(url_for('admin.index'))
return render_template('admin/category.html', form=form)
def add_category():
form=CategoryForm()
if form.validate_on_submit():
category=Category(
category=((form.category.data).lower()).capitalize(),
user_id=current_user.id
)
# category=(category.lower()).capitalize()
db.session.add(category)
sb.session.commit()
flash('Category added!', 'info')
return redirect(url_for('categories'))
return render_template('categories.html', categories=categories, form=form)
def category():
c = []
for value in Question.query.distinct(Question.category):
v = (str(value.category),str(value.category))
if v in c:
continue
else:
tup = tuple(v)
c.append(tup)
form = CategoryForm()
form.categories.choices = c
result = form.categories.data
if form.is_submitted():
if result != None:
flash(result)
x = Question.query.filter_by(category = result).order_by(func.random()).limit(10)
q = []
full_request = []
t =[]
answers = []
correct =[]
for i in x:
q.append(str(i.question))
ans = QuestionAnswer.query.filter_by(question_id = i.id)
answers = []
for j in ans:
sel = Answer.query.filter_by(id = j.answer_id).all()
if(j.correct == True):
correct.append(sel[0].answer)
answers.append(sel[0].answer)
full_request.append(answers)
y = {
"username": str(current_user.username),
"category": str(result),
"questions": q,
"answers": full_request,
"correct answer": correct
}
session['request'] = y
return(redirect(url_for('quiz')))
else:
flash(result)
return(render_template('category.html', form=form))
return(render_template('category.html', form=form))
def book(book_id):
book = Book.query.get(int(book_id))
if not book:
return redirect(url_for('index'))
page = request.args.get('page', 1, type=int)
comments = book.comments.order_by(Comment.datetime.desc()).paginate(
page, app.config['POSTS_PER_PAGE'], False)
next_url = url_for('book', book_id=book_id, page=comments.next_num) \
if comments.has_next else None
prev_url = url_for('book', book_id=book_id, page=comments.prev_num) \
if comments.has_prev else None
if current_user.is_anonymous:
return render_template('book.html',
title=book.title,
book=book,
comments=comments.items,
GENRES=GENRES,
next_url=next_url,
prev_url=prev_url)
rating_form = RatingForm()
comment_form = CommentForm()
category_form = CategoryForm()
return render_template('book.html',
title=book.title,
book=book,
comments=comments.items,
rating_form=rating_form,
comment_form=comment_form,
category_form=category_form,
GENRES=GENRES,
next_url=next_url,
prev_url=prev_url)
def edit_category(id):
form = CategoryForm.AddForm()
if form.validate_on_submit():
category = Category()
if (category.is_exist(id) != True):
flash('Sorry,That category doesn\'t exist',
category='errorMessage')
return redirect(redirect_back())
if category.exist_twice(request.form['name']):
flash('Sorry,There is another category with the same name',
category='errorMessage')
return redirect(redirect_back())
save_category = category.update(request.form['name'], id)
if (save_category):
flash(' Category \'{0}\' has been successfully updated'.format(
category.name),
category='successMessage')
return redirect(redirect_back())
flash('Unable to save category', category='errorMessage')
flash(request.form, category='input')
return redirect(redirect_back())
error = form.errors
flash(error, category='error')
flash(request.form, category='input')
return redirect(redirect_back())
def add_category(request):
if request.method == "POST":
form = CategoryForm(request.POST)
if form.is_valid():
# Crear un nuevo category
category = Category.objects.create(
name = form.cleaned_data['name'],
slug = form.cleaned_data['slug'],
)
# Siempre que cree el dato correctamente redireccionar
return HttpResponseRedirect('/categories/%s/' % category.slug)
else:
form = CategoryForm()
context = Context({'title':'Creación de categorias', 'form': form})
return render_to_response('add-category.html', context, context_instance=RequestContext(request))
def db_headings():
"""
Просмотр и добавление категорий и типов.
"""
if not current_user.isadmin:
redirect(url_for('index'))
category = Category.manager.get_all()
types = Types.manager.get_all()
form_c = CategoryForm(request.form or None, prefix='category')
form_t = TypesForm(request.form or None, prefix='types')
if request.method == 'POST':
if request.form.get('category-name', False) \
and form_c.validate_on_submit():
try:
Category.manager.add(name=form_c.name.data,
f_name=form_c.fname.data)
except SQLAlchemyError as err:
flash(f'Ошибка сохранения категории: {err}', category='danger')
else:
flash('Категория успешно добавлена!', category='success')
return redirect(url_for('db_headings'))
if request.form.get('types-name', False) \
and form_t.validate_on_submit():
try:
Types.manager.add(name=form_t.name.data,
f_name=form_t.fname.data)
except SQLAlchemyError as err:
flash(f'Ошибка сохранения типа данных: {err}',
category='danger')
else:
flash('Новый тип успешно добавлен!', category='success')
return redirect(url_for('db_headings'))
return render_template('dbpanel/db_headings.html',
category=category,
types=types,
form_c=form_c,
form_t=form_t)
def edit_category(category_id):
edit = db_session.query(Categories).filter_by(id=category_id).one()
form = CategoryForm(request.form)
if edit.user_id != login_session['user_id']:
flash('Unauthorized to edit this category')
return redirect(
url_for('category_owner.showCategory', category_id=category_id))
if request.method == 'POST' and form.validate():
edit.name = request.form['name']
db_session.add(edit)
db_session.commit()
flash('Category {} has been successfully edited!'.format(edit.name))
return redirect(
url_for('category_owner.show_categories', category_id=category_id))
else:
return render_template('/editcategory.html', category=edit, form=form)
def addCategory():
if current_user.is_authenticated:
form = CategoryForm()
hasCategory = Category.query.filter_by(name=form.name.data).first()
if hasCategory is not None:
flash('Category is already exists.')
return render_template('category/addCategory.html', title='Add Category', form=form)
if form.validate_on_submit():
category = Category(name=form.name.data, description=form.description.data)
db.session.add(category)
db.session.commit()
flash('Successfully Added the Category!')
return redirect(url_for('category'))
elif form.cancel.data == True:
return redirect(url_for('category'))
return render_template('category/addCategory.html', title='Add Category', form=form)
def edit_category(request, slug):
category = get_object_or_404(Category, slug=slug)
if request.method == "POST":
form = CategoryForm(request.POST)
if form.is_valid():
category.name = form.cleaned_data['name']
category.slug = form.cleaned_data['slug']
category.save()
# Siempre que cree el dato correctamente redireccionar
return HttpResponseRedirect('/categories/%s/' % category.slug)
else:
category_data = {
'name' : category.name,
'slug' : category.slug
}
form = CategoryForm(initial=category_data)
context = Context({'title' : 'Editar la categoria', 'form' : form})
return render_to_response('add-category.html', context, context_instance=RequestContext(request))
def add_new_category(self):
if contact_exists_in_db(session['username']):
if not contact_is_admin(session['username']):
return abort(404)
return render_template('forms/category.html',
form=CategoryForm(get_category_form_data()),
new=True)
else:
error_message = "You don't exist in the contacts database yet, and as such you cannot add a category."
return render_template('error_page.html', error=error_message)
def category_new():
"""Nuova categoria"""
form = CategoryForm()
error = None
descr = ''
if form.validate_on_submit():
descr = form.descr.data.lower()
cat = Category.query.filter_by(descr=descr).first()
if cat:
error = 'Categoria già presente!'
else:
db.session.add(Category(descr))
db.session.commit()
return redirect(url_for('main.category'))
return render_template("category_new.html",
form=form,
error=error,
titolo='Nuova Categoria',
descr=descr)
def edit_category(request, slug):
category = get_object_or_404(Category, slug=slug)
if request.method == "POST":
form = CategoryForm(request.POST)
if form.is_valid():
category.name = form.cleaned_data['name']
category.slug = form.cleaned_data['slug']
category.save()
return HttpResponseRedirect('/app/categories/%s/' % category.slug)
else:
category_data = {
'name' : category.name,
'slug' : category.slug
}
form = CategoryForm(initial=category_data)
context = Context({'title' : 'Editar la Categoria', 'form' : form, 'info_button' : 'Actualizar Categoria'})
return render_to_response('app/add-category.html', context, context_instance=RequestContext(request))
def update_category(transaction_id):
transaction = Transaction.query.filter_by(id=transaction_id).first()
form = CategoryForm()
if form.validate_on_submit():
category = form.category.data
transaction.category = category
transaction.customized = True
db.session.commit()
flash("Updated transaction category to {}".format(category))
return redirect(url_for('overview'))
return render_template('category.html',
form=form,
categories=categories,
transaction=transaction)
def recipes():
categories = Category().user_categories()
categories_list = []
for category in categories:
cat = (category['id'], category['name'])
categories_list.append(cat)
form = RecipeForm.editRecipe(categories_list) #Edit Recipe form
addCategory = CategoryForm.AddForm() #Addcategory form
categories = Store().get_user_categories(session['user_id'])
recipes = Recipe().user_recipes()
return render_template("recipes.html",
form=form,
categoryForm=addCategory,
categories=categories,
recipes=recipes)
def add_category(request):
context = RequestContext(request)
if request.method == 'POST':
form = CategoryForm(request.POST, request.FILES)
if form.is_valid() and form.is_multipart():
save_files(request.FILES['image'])
form.save(commit=True)
return index(request)
else:
print form.errors
else:
form = CategoryForm()
return render_to_response('app/add_category.html', {'form': form}, context)
def addCategory(request):
f = CategoryForm(request)
f.save()
return True
