-
Notifications
You must be signed in to change notification settings - Fork 0
/
app.py
114 lines (91 loc) · 2.88 KB
/
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
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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
import json
import time
import mysql.connector
import RPi.GPIO as GPIO
from flask import Flask, jsonify, render_template, request
import temp
cnx = ""
cursor = ""
GPIO.setmode(GPIO.BOARD)
app = Flask(__name__)
app.config["JSONIFY_PRETTYPRINT_REGULAR"] = True
porta_rele = 29
id_sensor1 = 1
id_sensor2 = 2
def conecta_BD():
global cnx
global cursor
cnx = mysql.connector.connect(host="***", user="***", passwd="***", database="***")
cursor = cnx.cursor()
@app.route("/desconectar-banco", methods=["PSOT", "GET"])
def desconecta_BD():
global cnx
global cursor
if cnx != "":
print("ta saindo")
cursor.close()
cnx.commit()
cnx.close()
return jsonify({"response": "execuado"})
# ---------------MAIN---------------------------
@app.route("/", methods=["POST", "GET"])
def index():
if request.method == "POST":
aquecida = False # panelaAqueceu()
if request.form["aquecida"] != "":
aquecida = True
nomeReceita = request.form["string"]
receita = pegaReceita(nomeReceita)
# Faça algo com a string recebida, por exemplo, retornar ela como uma resposta
return render_template("receitas.html", receita=receita, aquecida=aquecida)
if cnx == "":
conecta_BD()
receita = receitas()
return render_template("index.html", receitas=receita)
@app.route("/receitas", methods=["PSOT", "GET"])
def receitas():
if cnx == "":
conecta_BD()
cursor.execute("SELECT * FROM Tabela_coccção")
receitas = cursor.fetchall()
print(receitas)
return receitas # jsonify({"receitas": receitas})
def pegaReceita(rec):
if cnx == "":
conecta_BD()
cursor.execute(f"SELECT * FROM Tabela_coccção where Nome = '{rec}';")
receita = cursor.fetchone()
print(receita)
return receita # jsonify({"receitas": receitas})
@app.route("/salva-temperatura", methods=["GET"])
def salva_temperatura():
global cnx
global cursor
if cnx == "":
conecta_BD()
cursor.execute(
f"insert into Teste (id, temocelcius) values ({id_sensor1}, {temp.read_temp_sens1()});"
)
cursor.execute(
f"insert into Teste (id, temocelcius) values ({id_sensor2}, {temp.read_temp_sens2()});"
)
cnx.commit()
return jsonify({"response": "execuado"})
@app.route("/desligar", methods=["GET"])
def desligar():
GPIO.setup(porta_rele, GPIO.IN)
return jsonify({"response": "execuado"})
@app.route("/ligar", methods=["GET"])
def ligar():
GPIO.setup(porta_rele, GPIO.OUT)
GPIO.output(porta_rele, 1)
return jsonify({"response": "execuado"})
@app.route("/temperatura", methods=["GET"])
def getTemp():
return jsonify(
{
"temperatura_sensor_1": temp.read_temp_sens1(),
"temperatura_sensor_2": temp.read_temp_sens2(),
}
)
app.run(host="192.168.146.57") # hostname="192.168.146.57", port="8080"