Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. //Linha que envia os sinais do sensor via Serial para gravar no BD
  2. sinais = String(temperatura) + "," + String(umidade) + "," + String(luminosidade) + "," + String(leituraSensorSolo);
  3. Serial.println(sinais);
  4.  
  5. import serial
  6. comport = serial.Serial('/dev/ttyACM0', 9600)
  7. print ('Serial Iniciada...n')
  8.  
  9. import mysql.connector
  10. cnx = mysql.connector.connect(user='root', password='', host='127.0.0.1', database='sinais')
  11. cursor = cnx.cursor()
  12. add_sinais = ("INSERT INTO sinais (sin_temp,sin_umid,sin_lum,sin_solo) VALUES (%s, %s, %s, %s)")
  13.  
  14. while (True):
  15. serialValue = comport.readline()
  16. serialValue = str(serialValue)
  17. data_sinais = serialValue.split(",")
  18. print (data_sinais)
  19. cursor.execute(add_sinais, data_sinais)
  20. cnx.commit()
  21.  
  22. cursor.close()
  23. cnx.close()
  24. comport.close()
  25.  
  26. Serial Iniciada...
  27.  
  28. ["b'22.80", '86.00', '1016', "0\r\n'"]
  29. ["b'22.70", '86.00', '1017', "0\r\n'"]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement