def submit_topic(request):
if request.method == 'GET':
form = ArticleForm()
form.fields['in_event'].queryset = Event.objects.upcoming_events()
context = {
'form': form,
'tab': 'topic',
}
return render_to_response('core/submit_topic.html',
context,
context_instance=RequestContext(request))
if request.method == 'POST':
form = ArticleForm(request.POST)
context = {
'form': form,
'save_success': False,
}
if form.is_valid():
topic = form.save(commit=False)
if request.POST['captcha'] == '':
topic = form.save(commit=False)
topic.set_author(request.user)
topic.save()
topic.send_notification_mail('created')
context['save_success'] = True
else:
return HttpResponseForbidden()
return render_to_response('core/submit_topic.html',
context,
context_instance=RequestContext(request))
def edit(id):
if request.method == "GET":
form = ArticleForm(request.form)
baslik = "Makale Güncelleme"
btntext = "Güncelle"
con = sqlite3.connect("blog.db")
con.row_factory = dict_factory
cursor = con.cursor()
sorgu = 'select * from articles where id = ?'
article = cursor.execute(sorgu, (id, )).fetchone()
form.content.data = article["content"]
form.title.data = article["title"]
con.close()
return render_template("/article/edit.html",
form=form,
baslik=baslik,
btntext=btntext)
else:
form = ArticleForm(request.form)
content = form.content.data
title = form.title.data
con = sqlite3.connect("blog.db")
cursor = con.cursor()
sorgu = "update articles set title = ? , content = ? where id = ?"
cursor.execute(sorgu, (title, content, id))
con.commit()
flash("Güncelleme Başarılı", "success")
con.close()
return redirect(url_for("dashboard"))
def index(request):
latest_article_list = Article.objects.all().order_by('-post_date')[:5]
form = ArticleForm()
template = loader.get_template('index.html')
# user = User.objects.get(pk=User.pk)
if request.user.is_active:
# if user is not None:
return render_to_response('index.html', { 'form': form, 'posts': latest_article_list })
elif request.user.is_active != False and latest_article_list is not None:
return render_to_response('index.html', { 'posts': latest_article_list })
else:
return render_to_response('index.html', { }, context_instance=RequestContext(request))
if request.method == 'POST':
if form.is_valid():
postedArticle = Article()
postedArticle.post_date = timezone.now()
postedArticle.title = request.POST.getlist('title')
postedArticle.article = request.POST.getlist('article')
postedArticle.save()
else:
form = ArticleForm(instance=article)
return render_to_response('index.html', { 'form': form, 'posts': latest_article_list }, context_instance=RequestContext(request))
def edit_topic(request, id):
this_topic = get_object_or_404(Topic, pk=id)
if this_topic.author.user != request.user:
return HttpResponseRedirect(reverse('topic', args=[this_topic.id]))
if request.method == 'GET':
context = {
'form': ArticleForm(instance=this_topic),
'topic': this_topic,
'tab': 'topic',
}
return render_to_response('core/edit_topic.html',
context,
context_instance=RequestContext(request))
if request.method == 'POST':
form = ArticleForm(request.POST, instance=this_topic)
topic = form.save(commit=False)
topic.set_author(request.user)
topic.save()
topic.send_notification_mail('updated')
context = {
'form': form,
'topic': topic,
'edit_success': True,
'tab': 'topic',
}
return render_to_response('core/edit_topic.html',
context,
context_instance=RequestContext(request))
def delete(id):
if request.method == "GET":
form = ArticleForm(request.form)
baslik = "Makale Silinecek Eminmisiniz"
btntext = "Sil"
con = sqlite3.connect("blog.db")
con.row_factory = dict_factory
cursor = con.cursor()
sorgu = 'select * from articles where id = ?'
article = cursor.execute(sorgu, (id, )).fetchone()
print(article)
form.content.data = article["content"]
form.title.data = article["title"]
con.close()
return render_template("/article/edit.html",
form=form,
baslik=baslik,
btntext=btntext)
else:
form = ArticleForm(request.form)
con = sqlite3.connect("blog.db")
cursor = con.cursor()
sorgu = " delete from articles where id = ?"
cursor.execute(sorgu, (id, ))
con.commit()
flash("Silme İşlemi Başarılı ", "success")
con.close()
return redirect(url_for("dashboard"))
def article(request, name=None):
context = get_context(request)
new = (name is None)
if new:
art = None
title = u'Nowy artykuł'
has_perm = request.user.has_perm('wwwapp.add_article')
else:
art = Article.objects.get(name=name)
title = art.title
has_perm = request.user.has_perm('wwwapp.change_article')
if has_perm:
if request.method == 'POST':
form = ArticleForm(request.user, request.POST, instance=art)
if form.is_valid():
article = form.save(commit=False)
article.modified_by = request.user
article.save()
form.save_m2m()
return redirect('article', form.instance.name)
else:
form = ArticleForm(request.user, instance=art)
else:
form = None
context['addArticle'] = new
context['title'] = title
context['article'] = art
context['form'] = form
return render(request, 'article.html', context)
def nouveau(request):
form = ArticleForm(request.POST)
if form.is_valid():
form.save()
envoi = True
else:
form = ArticleForm()
return render(request, 'nouveau.html', locals())
def create(request):
if request.POST:
form = ArticleForm(request.POST, request.FILES)
if form.is_valid():
form.save(commit=True)
return HttpResponseRedirect('/articles/all')
else:
form = ArticleForm()
return render(request, 'create_article.html', {'form': form})
def article_new(request):
if request.method == "POST":
form = ArticleForm(request.POST)
if form.is_valid():
post = form.save(commit=False)
post.save()
return redirect('article')
else:
form = ArticleForm()
return render(request, 'new_article.html', {'form': form})
def article_name(request):
if request.method == 'POST':
form = ArticleForm(request.POST)
if form.is_valid():
print form.cleaned_data
form.save()
return HttpResponseRedirect('redirect/')
else:
form = ArticleForm()
return render(request, 'article.html', {'form': form})
def article_add(request):
if request.method == 'POST':
formset = ArticleForm(request.POST)
if formset.is_valid():
instance = formset.save()
Article.get(instance.key())
return redirect(article_list)
else:
formset = ArticleForm()
return render_to_response("articles_add.html", {
"formset": formset,
}, context_instance=RequestContext(request))
def create(request):
if request.method == 'POST':
form = ArticleForm(request.POST)
if form.is_valid():
article = form.save(commit=False)
article.author = request.user
article.article_date = timezone.now()
article.save()
return redirect('/author/%s/' % article.author_id)
else:
form = ArticleForm()
return render(request, 'blogs/post_edit.html', {'form': form})
def create_article(request):
values = {}
values.update(csrf(request))
values['form'] = ArticleForm()
page = render_to_response("create_article.html", values)
if request.POST:
form = ArticleForm(request.POST, request.FILES)
if form.is_valid():
form.save()
page = HttpResponseRedirect('/articles/all')
return page
def modifier(request, id, slug):
article = get_object_or_404(Article, id=id, slug=slug)
form = ArticleForm(request.POST, instance=article)
if form.is_valid():
form.save()
article = form.save()
article.save()
envoi = True
else:
form = ArticleForm(instance=article)
return render(request, 'modifier.html', locals())
def create(request):
if request.method == "POST":
form = ArticleForm(request.POST)
if form.is_valid():
form.save()
return render_to_response('index.html')
else:
form = ArticleForm(request.POST)
con = {}
con.update(csrf(request))
con['form'] = form
return render_to_response("form.html", con)
def create(request):
if request.POST:
form = ArticleForm(request.POST)
if form.is_valid():
form.save()
return HttpResponseRedirect('/articles/all')
else:
form = ArticleForm()
args = {}
args['form'] = form
return render(request, 'login_reg/create_article.html', args)
def add_article(request):
if request.method == 'POST':
raw_data = ArticleForm(request.POST)
if raw_data.is_valid():
data = raw_data.cleaned_data
Articles.objects.create(**data)
return redirect(view_articles)
context = {'articles_form': raw_data}
return render(request, 'homework6_add_article.html', context)
else:
articles = Articles.objects.filter()
context = {'articles_form': ArticleForm(), 'articles': articles}
return render(request, 'homework6_add_article.html', context)
def article_form(request):
if request.method == 'POST':
form = ArticleForm(request.POST, request.FILES)
if form.is_valid():
form.save()
# form_class = ArticleForm
# return render(request, 'article_form.html', {'form': form})
else:
form = ArticleForm()
return render(request, 'article_form.html', {'form': form})
def create(request):
if request.POST:
form = ArticleForm(request.POST, request.FILES)
if form.is_valid():
form.save()
return HttpResponseRedirect('/articles/all')
else:
form = ArticleForm()
args = {}
args.update(csrf(request))
args['form'] = form
return render_to_response('create_article.html', args)
def post_edit(request, article_id):
article = get_object_or_404(Article, id=article_id)
if request.method == 'POST':
form = ArticleForm(request.POST, instance=article)
if form.is_valid():
article = form.save(commit=False)
article.author = request.user
article.article_date = timezone.now()
article.save()
return redirect('/articles/get/%s/' % article_id)
else:
form = ArticleForm(instance=article)
return render(request, 'blogs/post_edit.html', {'form': form})
def create(request):
if request.POST:
form = ArticleForm(request.POST, request.FILES)
if form.is_valid():
form.save()
return HttpResponseRedirect('/articles/all/')
else:
form = ArticleForm()
context = {}
context.update(csrf(request))
context['form'] = form
return render(request, 'create_article.html', context)
def create(request):
if request.POST:
form = ArticleForm(request.POST)
if form.is_valid():
form.save()
return HttpResponseRedirect("/")
else:
form = ArticleForm()
args = {}
args.update(csrf(request))
args['form'] = form
return render_to_response("create_article.html", args)
def article_post(request):
if request.method == 'POST':
form = ArticleForm(request.POST, )
if form.is_valid():
postedArticle = Article()
postedArticle.post_date = timezone.now()
postedArticle.title = request.POST.getlist('title')
postedArticle.article = request.POST.getlist('article')
postedArticle.save()
# return redirect('index')
else:
form = ArticleForm(instance=article)
return render_to_response('post_article.html', dict(form=form), context_instance=RequestContext(request))
def edit_article(id):
cur = mysql.connection.cursor()
result = cur.execute("SELECT * FROM articles WHERE id = %s", [id])
article = cur.fetchone()
cur.close()
form = ArticleForm(request.form)
form.title.data = article['title']
form.body.data = article['body']
if request.method == 'POST' and form.validate():
title = request.form['title']
body = request.form['body']
app.logger.info(title)
cur = mysql.connection.cursor()
cur.execute("UPDATE articles SET title=%s, body=%s WHERE id=%s",
(title, body, id))
mysql.connection.commit()
cur.close()
flash('Article Updated', 'success')
return redirect(url_for('dashboard'))
return render_template('article/edit_article.html', form=form)
def update(blog_id):
if not session.get('logged_in'):
abort(404)
else:
form = ArticleForm()
if request.method == 'POST':
if form.validate() == False:
return render_template('add.html', form=form)
else:
g.db = connect_db()
cur = g.db.execute('UPDATE fblog SET title =' +
form.title.data + ', content =' +
form.content.data + ' WHERE blog_id=' +
str(blog_id))
g.db.commit()
g.db.close()
flash('Article updated successfully')
return redirect(url_for('admin'))
elif request.method == 'GET':
g.db = connect_db()
article = query_db(
'SELECT blog_id, title, content FROM fblog WHERE blog_id = ?',
[blog_id],
one=True)
form.title.data = article['title']
form.content.data = article['content']
return render_template('edit.html', form=form, article=article)
def article_update(article_id):
cur = mysql.connection.cursor()
query = "SELECT * FROM articles WHERE id=%s"
result = cur.execute(query, [article_id])
article = {}
if result > 0:
article = cur.fetchone()
cur.close()
form = ArticleForm(request.form)
if request.method == 'GET':
form.title.data = article['title']
form.body.data = article['body']
elif request.method == 'POST' and form.validate():
cur = mysql.connection.cursor()
mysql.connection.autocommit(on=True)
query = """ UPDATE articles
SET title=%s, body=%s
WHERE id=%s """
params = (form.title.data, form.body.data, article_id)
cur.execute(query, params)
cur.close()
flash('Статья обновлена', 'success')
return redirect(url_for('dashboard'))
return render_template('article-create.html',
form=form,
header='Редактирование')
def add_article():
form = ArticleForm(request.form)
if request.method == 'POST' and form.validate():
title = form.title.data
body = form.body.data
# Create cursor
cur = mysql.connection.cursor()
# Insert article
cur.execute(
"INSERT INTO articles(title, body, author, user_id) VALUES (%s, %s, %s, %s)",
(title, body, session['username'], session['user_id']))
mysql.connection.commit()
# Close connection
cur.close()
# Let user know of success
flash('Article created', 'success')
# Return corresponding page
return redirect(url_for('dashboard'))
return render_template('add_article.html', form=form)
def art_add():
articleform=ArticleForm()
if articleform.validate_on_submit():
data=articleform.data
#update picture
datas=secure_filename(articleform.logo.data.filename)
logo=change_filename(datas)
if not os.path.exists(app.config["UP"]):
os.makedirs(app.config["UP"])
#save file
articleform.logo.data.save(app.config["UP"]+"/"+logo)
#get userID
user=User.query.filter_by(username=session["user"]).first()
user_id=user.id
#save data
articale =Article(
title=data["title"],
category=data["category"],
user_id=user_id,
logo=logo,
content=data["content"],
addTime=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
)
db.session.add(articale)
db.session.commit()
flash(u"Add review successfully!","ok")
return render_template("artadd.html",form=articleform)
def create_article():
"""
Create an article object and store on db.
Return article object in JSON response.
Data: title, content, url, source, summary, img_url
"""
data = request.json
form = ArticleForm(**data, meta={'csrf': False})
if form.validate():
if not newsmart.isUrlValid(form.url.data):
return (jsonify({"errors": {"url": ["Not a valid url."]}}), 400)
article = Article.query.filter(
Article.url == form.url.data).one_or_none()
if article:
# article object has been created already
return (jsonify({"article": article.serialize()}), 200)
else:
# create new article object and save
new_article = Article.new(**form.data)
return (jsonify({"article": new_article.serialize()}), 201)
errors = {"errors": form.errors}
return (jsonify(errors), 400)
def edit_article(id):
#Create Cursor
cur = mysql.connection.cursor()
# get article by id
result = cur.execute("SELECT * FROM articles WHERE id = %s", [id])
article = cur.fetchone()
form = ArticleForm()
form.title.data = article['title']
form.body.data = article['body']
if request.method == 'POST':
title = request.form['title']
body = request.form['body']
#create cursor
cur = mysql.connection.cursor()
app.logger.info(title)
#Execute
cur.execute("UPDATE articles SET title=%s, body=%s WHERE id=%s",
(title, body, id))
#commit to DB
mysql.connection.commit()
#close connection
cur.close()
flash('Feedback updated', 'success')
return redirect(url_for('dashboard'))
return render_template('edit_article.html', form=form)
