search

qbitacademy / meteo

A weather station service
1 stars 0 forks source link

Check connection with project database #2

Closed cletomartin closed 4 years ago

cletomartin commented 4 years ago

As part of the onboarding, we need to check that we can write on the database using the credentials provided by the project.

cletomartin commented 4 years ago

Created a script for this (based on the arduino implementation): https://github.com/qbitacademy/meteo/blob/master/scripts/check-data-delivery.py

Result was successful:

Testing rain data delivery...
Reply: 
"INSERT INTO `lluvia` (`ID`, `Fecha`, `Vacum`) VALUES ('qbitacademy', '2020-2-7 15:15:15', 111.111 );"
Testing general data delivery...
Reply: 
"INSERT INTO `otros` (`ID`, `Fecha`, `Temp`, `Pres`, `Hum`, `RadUV`, `WindU`, `WindD`) VALUES ('qbitacademy', '2020-2-7 15:15:15', 22.22, 99999.99, 33.33, 0.888, 44.444, 55.555);"