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()