forked from MadhavVats/Projectables
-
Notifications
You must be signed in to change notification settings - Fork 0
/
data.py
56 lines (41 loc) · 1.4 KB
/
data.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
import sqlite3
import pandas as pd
from flask import Flask, render_template, Response, request, redirect, url_for,Markup,request
app = Flask(__name__)
@app.route('/',methods=['GET','POST'])
def index():
search=""
try:
search=request.form['search']
except:
print("dd")
conn = sqlite3.connect('projectables.db')
c = conn.cursor()
q=str(f'''SELECT * FROM Project WHERE (TITLE LIKE "%{search}%") ORDER BY [S.NO.] DESC LIMIT 10''')
c.execute(q)
query=c.fetchall()
df = pd.DataFrame(query,columns=['PROJECT_ID','[S.NO.]','TITLE','CONTENT','OWNER_ID','COST','AUTHOR','RATING'])
print(df)
print(search)
return(render_template('/product_list.html',data=df))
@app.route('/<idX>', methods=['GET','POST'])
def onProductClick(idX):
print(idX)
return (render_template('/single-product.html'))
@app.route('/index',methods = ['GET','POST'])
def index_page():
return (render_template('/index.html'))
@app.route('/login', methods = ['GET','POST'])
def login():
return render_template('/login.html')
@app.route('/product_list',methods=['GET','POST'])
def getProductList():
return render_template('/product_list.html')
@app.route('/myCart',methods=['GET','POST'])
def mycart():
return render_template('/cart.html')
@app.route('/checkout', methods = ['Get','POST'])
def checkout():
return render_template('/checkout.html')
if __name__ == "__main__":
app.run(debug=True)