def add_article(type): form = ArticlesForm(request.form) if request.method == 'POST': titleimage=create_embed_link(request.form['titleimage']) title=request.form['title'] description=request.form['description'] body=request.form['body'] cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) if 'name' in request.form: name=request.form['name'] batchof=request.form['batchof'] timetoread=request.form['timetoread'] cur.execute("INSERT INTO articles (name, batchof, titleimage,title, description,timetoread,body,type) values(%s,%s,%s,%s,%s,%s,%s,%s)", (name,batchof,titleimage,title,description,timetoread,body,type)); conn.commit() cur.close() return redirect(url_for('index')) else: cur.execute("INSERT INTO articles (name, batchof, titleimage,title, description,body,type) values('NULL','NULL',%s,%s,%s,%s,%s)", (titleimage,title,description,body,type)); conn.commit() cur.close() return redirect(url_for('alumni')) return render_template('add_article.html', form=form, type=type)
def add_cordi_secretaries(): form = HallCouncilForm(request.form) if request.method == 'POST': other_post=request.form['other_post'] title=request.form['title'] name=request.form['name'] mobile=request.form['mobile'] profilephoto=create_embed_link(request.form['profilephoto']) email=request.form['email'] fbprofile=request.form['fbprofile'] inprofile=request.form['inprofile'] # print(name + email) cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) # if warden_post != '': # cur.execute("UPDATE warden SET name=%s,profilephoto=%s,email=%s,fbprofile=%s,inprofile=%s where post=%s", (name,profilephoto,email,fbprofile,inprofile,warden_post)); # conn.commit() # else: cur.execute("INSERT INTO captains_secretaries(post, title, name, profilephoto,email, mobile, fbprofile,inprofile) values(%s,%s,%s,%s,%s,%s,%s,%s)", (other_post,title,name,profilephoto,email,mobile,fbprofile,inprofile)); conn.commit() # cur.close() return redirect(url_for('hallcouncil')) return render_template('add_cordi_secretaries.html', form=form)
def edit_cordi_secretaries(id): # Create cursor cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) result = cur.execute("SELECT * FROM captains_secretaries WHERE id = %s", [id]) captains_secretaries_data = cur.fetchone() form = HallCouncilForm(request.form) form.other_post.data = captains_secretaries_data['post'] form.title.data = captains_secretaries_data['title'] form.name.data = captains_secretaries_data['name'] form.mobile.data = captains_secretaries_data['mobile'] form.profilephoto.data = captains_secretaries_data['profilephoto'] form.email.data = captains_secretaries_data['email'] form.fbprofile.data = captains_secretaries_data['fbprofile'] form.inprofile.data = captains_secretaries_data['inprofile'] if request.method == 'POST': other_post=request.form['other_post'] title=request.form['title'] name=request.form['name'] mobile=request.form['mobile'] profilephoto=create_embed_link(request.form['profilephoto']) email=request.form['email'] fbprofile=request.form['fbprofile'] inprofile=request.form['inprofile'] # print(name + email) cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) # if warden_post != '': # cur.execute("UPDATE warden SET name=%s,profilephoto=%s,email=%s,fbprofile=%s,inprofile=%s where post=%s", (name,profilephoto,email,fbprofile,inprofile,warden_post)); # conn.commit() # else: cur.execute("UPDATE captains_secretaries SET post=%s, title=%s, name=%s, profilephoto=%s,email=%s, mobile=%s, fbprofile=%s,inprofile=%s where id=%s", (other_post, title, name,profilephoto,email,mobile,fbprofile,inprofile,id)); conn.commit() # cur.close() return redirect(url_for('hallcouncil')) return render_template('edit_cordi_secretaries.html', form=form, captains_secretaries_data=captains_secretaries_data)
def edit_article(id): # Create cursor cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) result = cur.execute("SELECT * FROM articles WHERE id = %s", [id]) article_data = cur.fetchone() form = ArticlesForm(request.form) form.name.data = article_data['name'] form.batchof.data = article_data['batchof'] form.titleimage.data = article_data['titleimage'] form.title.data = article_data['title'] form.description.data = article_data['description'] form.timetoread.data = article_data['timetoread'] form.body.data = article_data['body'] form.type.data = article_data['type'] if request.method == 'POST': name=request.form['name'] batchof=request.form['batchof'] titleimage=create_embed_link(request.form['titleimage']) title=request.form['title'] description=request.form['description'] timetoread=request.form['timetoread'] body=request.form['body'] type=request.form['type'] cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) # if warden_post != '': # cur.execute("UPDATE warden SET name=%s,profilephoto=%s,email=%s,fbprofile=%s,inprofile=%s where post=%s", (name,profilephoto,email,fbprofile,inprofile,warden_post)); # conn.commit() # else: cur.execute("UPDATE articles SET name=%s, batchof=%s, titleimage=%s, title=%s,description=%s, timetoread=%s,body=%s, type=%s where id=%s", (name, batchof, titleimage,title,description,timetoread,body,type,id)); conn.commit() # cur.close() return redirect(url_for('article',id=id)) return render_template('edit_article.html', form=form, article_data=article_data)
def edit_pages(id): cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) #cur = con.cursor() result = cur.execute("SELECT * FROM pages WHERE id = %s", (id)) page_data = cur.fetchone() form = PageForm(request.form) form.title.data = page_data['title'] form.videolink.data = page_data['videolink'] form.videobuttontext.data = page_data['videobuttontext'] form.backgroungimage.data = page_data['backgroungimage'] form.body.data=page_data['body'] if request.method == 'POST': title=request.form['title'] videolink=request.form['videolink'] videobuttontext=request.form['videobuttontext'] backgroungimage=create_embed_link(request.form['backgroungimage']) body=request.form['body'] cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) #cur = con.cursor() cur.execute("UPDATE pages SET title=%s, videolink=%s, videobuttontext=%s, backgroungimage=%s, body=%s where id=%s",(title,videolink,videobuttontext,backgroungimage,body,id)); conn.commit() # cur.close() if id == '1': return redirect(url_for('illu')) elif id == '2': return redirect(url_for('rangoli')) elif id == '3': return redirect(url_for('gc')) elif id == '4': return redirect(url_for('index')) elif id == '5': return redirect(url_for('alumni')) return render_template('edit_pages.html', form=form)
def add_photos(): form = PhotoForm(request.form) if request.method == 'POST': category=request.form['category'] title=request.form['title'] photolink= create_embed_link(request.form['photolink']) year=request.form['year'] # print(name + email) cur = conn.cursor(cursor_factory = psycopg2.extras.DictCursor) # if warden_post != '': # cur.execute("UPDATE warden SET name=%s,profilephoto=%s,email=%s,fbprofile=%s,inprofile=%s where post=%s", (name,profilephoto,email,fbprofile,inprofile,warden_post)); # conn.commit() # else: cur.execute("INSERT INTO photos(category,title, photolink,year) values(%s,%s,%s,%s)", (category,title,photolink,year)); conn.commit() # cur.close() return redirect(url_for('index')) return render_template('add_photos.html', form=form)