Differences

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

--- ust:meeting_minutes_october_11_13_2022 [2022/10/14 00:20]
jchang
+++ ust:meeting_minutes_october_11_13_2022 [2022/10/14 00:50] (current)
jchang [Updates]
@@ Line 37: / Line 37: @@
   * Ran "python3 fake_traffic.py" in one window and ran "python3 src/gateway_server.py ./src/ttyFakeTraffic" in another --> error
     * {{:ust:screen_shot_2022-10-13_at_2.07.54_pm.png?400|}}
-  * Ran "python3 fake_traffic.py" and "python3 src/gateway_server.py ./src/ttyFakeTraffic" in same window --> different error
+  * 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
     * {{:ust:screen_shot_2022-10-13_at_2.07.41_pm.png?400|}}
   * Changed gateway URI to "export GATEWAY_DB_URI="postgresql : / / gateway@localhost/weatherbox""
+  * Gave gateway role permission to login
+  * 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 =====