-
Notifications
You must be signed in to change notification settings - Fork 0
/
genEdServer.py
82 lines (67 loc) · 2.89 KB
/
genEdServer.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
from flask import Flask, render_template, request
from flask_bootstrap import Bootstrap
import psycopg2
import json
import os
app = Flask(__name__)
app.config['TEMPLATES_AUTO_RELOAD'] = True
#conn = psycopg2.connect(dbname="gened", user="conzty01")
conn = psycopg2.connect(os.environ["DATABASE_URL"])
@app.route("/")
def splash():
return render_template("splash.html")
@app.route("/index")
def index():
cur = conn.cursor()
cur.execute("SELECT name FROM requirement WHERE name != 'None';")
return render_template("index.html",requirement=cur.fetchall())
@app.route("/searchMult/", methods=["POST"])
def searchMult():
cur = conn.cursor()
queryList = []
searchStr = ""
genEdStr = ""
for i in request.form:
#print(i)
if i != "search":
queryList.append(i)
genEdStr += "'{}' = ANY(req) AND \n".format(i)
else:
searchTerms = str(request.form[i]).split(",")
if len(searchTerms) > 0 and searchTerms[0] != "":
for i in range(len(searchTerms)):
searchStr += "course.num LIKE "+"'%"+searchTerms[i]+"%'"+"OR \n"
searchStr += "course.title LIKE "+"'%"+searchTerms[i]+"%'"+"OR \n"
searchStr += "course.department LIKE "+"'%"+searchTerms[i]+"%'"+"OR \n"
searchStr += "course.description LIKE "+"'%"+searchTerms[i]+"%'"+"OR \n"
searchStr = searchStr[:-4]
if searchStr == "":
genEdStr = genEdStr[:-5]
else:
if len(queryList) > 0:
genEdStr = genEdStr[:len(genEdStr)-5] + " OR \n"
queryList += searchTerms
if (genEdStr == "") and (searchStr == ""): # Return all results
cur.execute("""
SELECT course.num, course.department, c.title, req
FROM (SELECT course.title, ARRAY_AGG(DISTINCT requirement.name) AS req
FROM course JOIN course_requirement ON(course.id = course_requirement.course)
JOIN requirement ON(course_requirement.requirement = requirement.id)
GROUP BY course.title) As c
JOIN course ON(c.title = course.title)
ORDER BY ARRAY_LENGTH(req,1) DESC, c.title ASC;
""")
else:
cur.execute("""
SELECT course.num, course.department, c.title, req
FROM (SELECT course.title, ARRAY_AGG(DISTINCT requirement.name) AS req
FROM course JOIN course_requirement ON(course.id = course_requirement.course)
JOIN requirement ON(course_requirement.requirement = requirement.id)
GROUP BY course.title) As c
JOIN course ON(c.title = course.title)
WHERE {} {}
ORDER BY ARRAY_LENGTH(req,1) DESC, c.title ASC;
""".format(genEdStr, searchStr))
return render_template("result.html",results=cur.fetchall(),ql=queryList)
if __name__ == "__main__":
app.run(debug=True)