Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Linha que envia os sinais do sensor via Serial para gravar no BD
- sinais = String(temperatura) + "," + String(umidade) + "," + String(luminosidade) + "," + String(leituraSensorSolo);
- Serial.println(sinais);
- import serial
- comport = serial.Serial('/dev/ttyACM0', 9600)
- print ('Serial Iniciada...n')
- import mysql.connector
- cnx = mysql.connector.connect(user='root', password='', host='127.0.0.1', database='sinais')
- cursor = cnx.cursor()
- add_sinais = ("INSERT INTO sinais (sin_temp,sin_umid,sin_lum,sin_solo) VALUES (%s, %s, %s, %s)")
- while (True):
- serialValue = comport.readline()
- serialValue = str(serialValue)
- data_sinais = serialValue.split(",")
- print (data_sinais)
- cursor.execute(add_sinais, data_sinais)
- cnx.commit()
- cursor.close()
- cnx.close()
- comport.close()
- Serial Iniciada...
- ["b'22.80", '86.00', '1016', "0\r\n'"]
- ["b'22.70", '86.00', '1017', "0\r\n'"]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement