def add_confirm():
query_type = "A"
temp_row = []
temp_row.append(str(request.form['input_id']))
temp_row.append(str(request.form['input_lname']))
temp_row.append(str(request.form['input_fname']))
temp_row.append(str(request.form['input_mname']))
temp_row.append(str(request.form['input_gender']))
temp_course = int(str(request.form['input_course']))
temp_college = courseList[temp_course][1]
temp_row.append(temp_college)
temp_row.append(temp_course)
temp_row.append(str(request.form['input_year_lvl']))
temp_row.append(str(request.form['input_house_num']))
temp_row.append(str(request.form['input_street']))
temp_row.append(str(request.form['input_brgy']))
temp_row.append(str(request.form['input_city']))
temp_row.append(str(request.form['input_bdate']))
temp_student = Student(temp_row)
temp_student._addAccount()
student_list.append(temp_student)
return render_template("confirm.html",
student=temp_student,
college=collegeList,
course=courseList,
query_type=query_type)
def search():
added_stmt = str
if str(request.form['input_type']) == "ID":
added_stmt = "idnum = " + str(request.form['search_input'])
else:
print "Here"
added_stmt = "(name).l_name = '" + str(
request.form['search_input']) + "'"
cur.execute(
"SELECT idnum, (name).l_name AS l_name, (name).f_name AS f_name, (name).m_name AS m_name, "
+
"gender, college_id, course_id, year_lvl, (address).house_num AS h_num, (address).street AS street, (address).brgy AS brgy, "
+ "(address).city AS city, bdate FROM student where " + added_stmt)
t_rows = cur.fetchall()
t_student_list = list()
for student in t_rows:
info = Student(student)
t_student_list.append(info)
if len(t_student_list) != 0:
return render_template("search_results.html",
student_list=t_student_list,
isEmpty=True,
search_key=request.form['search_input'])
else:
return render_template("search_results.html",
student_list=t_student_list,
isEmpty=False,
search_key=request.form['search_input'])
def profile(idnum):
if _checkIfExists(idnum):
student = Student(None, idnum)
return render_template("profile.html",
student=student,
course=courseList,
college=collegeList)
else:
return "Account does not exist!!"
def delete(idnum):
student = Student(None, idnum)
return render_template("deleteinfo.html", student=student)
def update(idnum):
student = Student(None, idnum)
return render_template("updateinfo.html",
student=student,
college=collegeList,
course=courseList)
app = Flask(__name__)
conn = psycopg2.connect(host="localhost",
database="student_db",
user="******",
password="******")
cur = conn.cursor()
cur.execute(
"SELECT idnum, (name).l_name AS l_name, (name).f_name AS f_name, (name).m_name AS m_name, "
+
"gender, college_id, course_id, year_lvl, (address).house_num AS h_num, (address).street AS street, (address).brgy AS brgy, "
+ "(address).city AS city, bdate FROM student")
rows = cur.fetchall()
student_list = list()
for student in rows:
info = Student(student)
student_list.append(info)
courseList = {}
collegeList = {}
temp_student = Student()
temp_cur = conn.cursor()
temp_cur.execute("SELECT idnum, name from college")
college_row = temp_cur.fetchall()
for r in college_row:
collegeList[r[0]] = (r[1], r[0])
temp_cur = conn.cursor()
temp_cur.execute("SELECT idnum, name, college_id from course")
course_row = temp_cur.fetchall()