Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
ust:meeting_minutes_october_4_6_2022 [2022/10/07 00:58] jchang |
ust:meeting_minutes_october_4_6_2022 [2022/10/14 00:37] (current) jchang |
||
---|---|---|---|
Line 30: | Line 30: | ||
* checked version: psql --version --> psql (PostgreSQL) 13.8 (Debian 13.8-0+debllu1) | * checked version: psql --version --> psql (PostgreSQL) 13.8 (Debian 13.8-0+debllu1) | ||
* created a user called "psql" | * created a user called "psql" | ||
- | * Commands ran (can tell something is happening based on changing between =# and -#) | + | |
+ | * Commands ran to make database(can tell something is happening based on changing between =# and -#) | ||
* set role postgres; | * set role postgres; | ||
* create role gateway superuser; | * create role gateway superuser; | ||
Line 36: | Line 37: | ||
* create database weatherbox; | * create database weatherbox; | ||
* set search_path to public; | * set search_path to public; | ||
- | * create table apple(time_received TIMESTAMP NOT NULL, schema INTEGER, node_addr INTEGER, uptime_ms BIGINT, batt_mv INTEGER, panel_mv INTEGER, press_pa INTEGER, temp_c INTEGER, humidity_centi_pct INTEGER, apogee_w_m2 FLOAT); | + | * create table apple(time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,press_pa INTEGER,temp_c INTEGER,humidity_centi_pct INTEGER,apogee_w_m2 FLOAT); |
- | * create table dragonfruit(time_received TIMESTAMP NOT NULL, schema INTEGER, node_addr INTEGER, uptime_ms BIGINT, batt_mv INTEGER, panel_mv INTEGER, press_pa INTEGER, temp_c INTEGER, humidity_centi_pct INTEGER, apogee_w_m2 FLOAT); | + | * CREATE TABLE cranberry (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,apogee_w_m2 FLOAT,temp_cK INTEGER,humidity_pct INTEGER,press_pa INTEGER); |
- | * create table cranberry(time_received TIMESTAMP NOT NULL, schema INTEGER, node_addr INTEGER, uptime_ms BIGINT, batt_mv INTEGER, panel_mv INTEGER, press_pa INTEGER, temp_c INTEGER, humidity_centi_pct INTEGER, apogee_w_m2 FLOAT); | + | * CREATE TABLE dragonfruit (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER,panel_mv INTEGER,apogee_w_m2 FLOAT,temp_cK INTEGER,humidity_pct INTEGER,press_pa INTEGER); |
- | * create table heartbeat(time_received TIMESTAMP NOT NULL, schema INTEGER, node_addr INTEGER, uptime_ms BIGINT, batt_mv INTEGER); | + | * CREATE TABLE heartbeat (time_received TIMESTAMP NOT NULL,schema INTEGER,node_addr INTEGER,uptime_ms BIGINT,batt_mv INTEGER); |
* \d public.apple (shows apple table) | * \d public.apple (shows apple table) | ||
* \dt public.* (shows all tables using public schema) | * \dt public.* (shows all tables using public schema) | ||
+ | * To switch between databases: psql -d DATABASE | ||
+ | |||
+ | * Testing to see if database files are found or if we need to find database files and write it into the code | ||
+ | * source env/bin/activate | ||
+ | * sudo chmod 666 PORT (starts with /dev) | ||
+ | * Need to find tables after running production, since collects data but then errors | ||
+ | |||
+ | REMINDER FOR NEXT WEEK | ||
+ | * git clone repository | ||
+ | * need to make a general scel git account | ||
+ | * key gen | ||
== Goals === | == Goals === |