Raspberry-Pi-Weather-Logger/sqlite3_db_sequence.txt at master · simonqq21/Raspberry-Pi-Weather-Logger · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
.open weather_days.db
CREATE TABLE dates (id INTEGER NOT NULL PRIMARY KEY,date TEXT NOT NULL);
CREATE TABLE temperature (id INTEGER NOT NULL PRIMARY KEY, mean REAL, std REAL, min REAL, max REAL, FOREIGN KEY(id) REFERENCES dates(id));
CREATE TABLE bmp_temperature (id INTEGER NOT NULL PRIMARY KEY, mean REAL, std REAL, min REAL, max REAL, FOREIGN KEY(id) REFERENCES dates(id));
CREATE TABLE humidity (id INTEGER NOT NULL PRIMARY KEY, mean REAL, std REAL, min REAL, max REAL, FOREIGN KEY(id) REFERENCES dates(id));
CREATE TABLE pressure (id INTEGER NOT NULL PRIMARY KEY, mean REAL, std REAL, min REAL, max REAL, FOREIGN KEY(id) REFERENCES dates(id));

insert into dates(date) VALUES('2021-03-20');
INSERT INTO temperature(id, mean, std, min, max) VALUES(2, 28.3333333333333, 1, 26, 30);

.tables
SELECT * FROM sqlite_master;
SELECT * FROM dates;
SELECT * FROM temperature;
SELECT * FROM pressure;
SELECT * FROM humidity;
SELECT * FROM bmp_temperature;

SELECT * FROM temperature WHERE temperature.id = (SELECT id FROM dates WHERE dates.date = '2021-02-13');

delete from temperature; delete from pressure; delete from bmp_temperature; delete from humidity;delete from dates;