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_11_13_2022 [2022/10/14 00:15] jchang |
ust:meeting_minutes_october_11_13_2022 [2022/10/14 00:50] (current) jchang [Updates] |
||
|---|---|---|---|
| Line 35: | Line 35: | ||
| **October 13, 2022** | **October 13, 2022** | ||
| * Set up discord on lab computer | * 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 ===== | ===== Goals ===== | ||