Differences

This shows you the differences between two versions of the page.

--- ust:meeting_minutes_october_11_13_2022 [2022/10/14 00:14]
jchang
+++ ust:meeting_minutes_october_11_13_2022 [2022/10/14 00:50] (current)
jchang [Updates]
@@ Line 1: / Line 1: @@
 =====Firmware Team Meeting - October 11, 13, 2022=====
 **Attended: Jaeden, Jon, Lyon**\\
-===== Goals =====
-  * Gateway maintenance
-  * Setup tables
-===== Meeting =====
-  * Tuesday, Thursday: 1:00-3:30pm
 =====Updates=====
@@ Line 42: / Line 35: @@
 **October 13, 2022**
   * Set up discord on lab computer
-  * Ran "python3 fake_traffic.py" in one window and ran "python3 src/gateway_server.py ./src/ttyFakeTraffic" in another
+  * Ran "python3 fake_traffic.py" in one window and ran "python3 src/gateway_server.py ./src/ttyFakeTraffic" in another --> error
-    * Code error:
+    * {{:ust:screen_shot_2022-10-13_at_2.07.54_pm.png?400|}}
-      * {{:ust:screen_shot_2022-10-13_at_2.07.54_pm.png?400|}}
+  * Ran "python3 fake_traffic.py" in one window. Ran "python3 src/gateway_server.py ./src/ttyFakeTraffic" and export GATEWAY_DB_URI="postgresql : / / gateway@localhost/weatherbox" in same window --> different error
-  * Ran "python3 fake_traffic.py" and "python3 src/gateway_server.py ./src/ttyFakeTraffic" in same window
+    * {{:ust:screen_shot_2022-10-13_at_2.07.41_pm.png?400|}}
-    * Different code error:
+  * Changed gateway URI to "export GATEWAY_DB_URI="postgresql : / / gateway@localhost/weatherbox""
-      * {{:ust:screen_shot_2022-10-13_at_2.07.41_pm.png?400|}}
+  * Gave gateway role permission to login
-  * export GATEWAY_DB_URI="postgresql://postgres@localhost/weatherbox is CORRECT
+  * Found error in table labels
+    * Edited previous documentation
+    * Edited tables using two methods:
+      * Manually: alter table __NAME__ rename column __OLD COLUMN__ to __NEW COLUMN__
+      * Drop old tables and run setup commands from the script using "psql -d weatherbox -f multi-table.sql"
+  * Ran "python3 fake_traffic.py" in one window. Ran "python3 src/gateway_server.py ./src/ttyFakeTraffic" and export GATEWAY_DB_URI="postgresql : / / gateway@localhost/weatherbox" in same window
+    * **SUCCESS: FAKE DATA FLOODING DATABASE!!**
+  * Tested database with actual data from apple by using ./run_production.sh auto
+===== Goals =====
+  * Gateway maintenance
+  * Setup tables
+===== Meeting =====
+  * Tuesday, Thursday: 1:00-3:30pm