This project conatins all needed files for the rest server that collects data.
Requirements (tested with version):
-
Flask==1.1.2
-
requests==2.21.0
-
SQLAlchemy==1.3.22
-
systemd==0.16.1
-
pyzbar==0.1.8
-
seaborn==0.11.1
-
matplotlib==3.3.3
-
pandas==1.2.0
-
numpy==1.19.4
-
Pillow==8.0.1
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| sensor_id | bigint(16) unsigned | NO | NULL | ||
| temperature | float | NO | NULL | ||
| eCO2 | int(5) | NO | NULL | ||
| raw_Ethanol | int(5) | NO | NULL | ||
| raw_H2 | int(5) | NO | NULL | ||
| pressure | float | NO | NULL | ||
| humidity | float | NO | NULL | ||
| TVOC | int(5) | NO | NULL | ||
| timestamp | varchar(45) | NO | NULL |
For the sgp_30_db.service you need a databse URI. Please refer: Engine Configuration
For the gunicorn config please refer: Running Gunicorn — Gunicorn 20.0.4 documentation