def deletepage():
form = iDnumForm(request.form)
con = sql.connect("studentdb.db")
cur = con.cursor()
if request.method == 'POST':
idnumNew = form.idnumNew.data
cur.execute("SELECT * FROM students WHERE idnum = ?", (idnumNew, ))
if cur.fetchone() is None and form.validate():
flash('Student not found', 'error')
return render_template("delete.html", form=form)
elif form.validate() and cur.fetchone is not None:
student = models.Student(idnum=idnumNew,
fname="",
mname="",
lname="",
sex="",
courseid="")
student.delete()
flash('Student Successfully deleted', 'success')
return render_template("delete.html", form=form)
elif not form.validate():
flash('error in delete operation', 'error')
return render_template("delete.html", form=form)
else:
return render_template("delete.html", form=form)
def updateGet():
form = iDnumForm(request.form)
if request.method == 'POST':
con = sql.connect("studentdb.db")
cur = con.cursor()
idnumNew = form.idnumNew.data
cur.execute("SELECT * FROM students WHERE idnum = ?", (idnumNew, ))
if cur.fetchone() is None:
flash('Student Not in record', 'error')
return render_template("updateGet.html", form=form)
else:
session['idnumNew'] = request.form['idnumNew']
return redirect(url_for('updateImp'))
else:
return render_template("updateGet.html", form=form)