Willmish / comp0016-farmbeats

Raspberry Pi based IoT project on smart farming with @Avanade
http://students.cs.ucl.ac.uk/2021/group28/
MIT License
2 stars 1 forks source link

PC-Iot hub-SQL DB connection #29

Closed Willmish closed 2 years ago

Willmish commented 2 years ago

Description

This PR adds integration with the now in-place Azure IoT Hub, allowing for data streaming to it (as one of the registered devices - e.g. Rpi). It also restructures the SQL queries to work with the modified Azure SQL DB (Timestamp is now a datetime type value, as there were some rounding errors with using floats and repeating primary keys). Additionally reformats keys usage so they aren't public, using dotenv library. (Pushed is a .env.template file, which should be modified with the existing keys, from Azure directly). Finally, adds a (yet incomplete) requirements.txt file.

Type of change

Issues

Closes #25 Closes #24