/
app.py
44 lines (31 loc) · 838 Bytes
/
app.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
# Librairies
from flask import Flask, jsonify
import pymysql
from dotenv import load_dotenv, find_dotenv
import os
# Variables
load_dotenv(find_dotenv())
app = Flask(__name__)
app.config['DEBUG'] = True
app.env = "dev"
# connection à la base de données
def connection():
return pymysql.connect(host = os.getenv("DB_HOST"),
user = os.getenv("DB_USER"),
password = os.getenv("DB_PASS"),
db = os.getenv("DB_NAME"),
charset = "utf8mb4",
cursorclass = pymysql.cursors.DictCursor)
# Routes disponibles
@app.route("/", methods=["GET"])
def home():
con = connection()
with con:
cur = con.cursor()
sql = 'SELECT * from users'
cur.execute(sql,())
result = cur.fetchall()
return jsonify(result), 200
# Lancement de l'application
if __name__ == "__main__":
app.run()