Tip /p1mon/mnt/ramdisk/p1msg.txt

1. query

sqlite3 /p1mon/mnt/ramdisk/04_faseinformatie.db ".tables"
faseinformatie
sqlite3 /p1mon/mnt/ramdisk/04_faseinformatie.db "pragma table_info('faseinformatie')"
0|TIMESTAMP|TEXT|1||1
1|VERBR_L1_KW|REAL|0|0|0
2|VERBR_L2_KW|REAL|0|0|0
3|VERBR_L3_KW|REAL|0|0|0
4|GELVR_L1_KW|REAL|0|0|0
5|GELVR_L2_KW|REAL|0|0|0
6|GELVR_L3_KW|REAL|0|0|0
7|L1_V|REAL|0|0|0
8|L2_V|REAL|0|0|0
9|L3_V|REAL|0|0|0
10|L1_A|REAL|0|0|0
11|L2_A|REAL|0|0|0
12|L3_A|REAL|0|0|0

2. 3 phases

sqlite3 /p1mon/mnt/ramdisk/04_faseinformatie.db "select * from faseinformatie order by timestamp desc limit 1"
2022-02-08 20:55:17|0.456|0.125|0.048|0.0|0.0|0.0|229.3|229.5|230.3|2.04|0.86|0.31
                      |    |     |                 |     |     |       |    |    |
                      +----+-----+-> wat           |     |     |       |    |    |
                                                   +-----+-----+-> vlt |    |    |
                                                                       +----+----+-> amp