/
pizza.py
38 lines (29 loc) · 923 Bytes
/
pizza.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
from flask import Flask, request, jsonify
import MysqlConnect as connect
import GenerateResponse as res
import Error as err
app = Flask(__name__)
@app.route("/fetch", methods=["get", "post"])
def fetch():
conn = connect.ConnectMySql()
print(f"Connection status : {conn}")
if conn is False:
return err.ReturnConnectionError()
else:
try:
cur = conn.cursor()
print(f"Cursor object : {cur}")
query = "select * from pizza"
cur.execute(query)
msg = "Data fetched succesfully"
return res.generateResponse(cur,msg)
except Exception as e:
print(e)
return err.ReturnFetchError()
finally:
conn.close()
@app.route("/insert", methods=["post"])
def insertData():
pass
if __name__ == "__main__":
app.run(debug=True, port=3000)