Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. =====Firmware Team Meeting - October 11, 13, 2022===== **Attended: Jaeden, Jon, Lyon**\\ =====Updates===== **October 11, 2022** * Used git clone for the control-tower repository * Locate new sql table files * Trouble shooting table issue * Learned that we created the tables using the gateway role (or user... postgres is weird about that name), BUT we created the tables within the postgres database * When we log into the weatherbox database shows nothing * Switch databases and create tables AGAIN * Get straight into the database: psql -d weatherbox * For files: psql -d weatherbox -f filename.sql * Clean up the original postgres database, those tables don't belong there * finding sql files * cd /etc/postgresql/13/main * ls * Create table using sql file: psql -d weatherbox -f multi-table.sql * Write data to the tables * run INSERT commands manually * run the gateway * Fake traffic script: fake_xr.py --> Added "encoding='utf8'" in line 31 * write fake data to postgres * cd into control-tower, gateway * source env/bin/activate * cd into control-tower, gateway, src * in one window: * python3 fake_traffic.py * in another window: * export GATEWAY_DB_URI="postgresql://gateway@localhost/weatherbox * more generically: postgresql://user:secret@host/mydb * python gateway_server.py ./fakexbee * Program keeps breaking, so unsure of what the problem is. May be issue within the python code **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 --> error * {{: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 * {{: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 ===== * Gateway maintenance * Setup tables ===== Meeting ===== * Tuesday, Thursday: 1:00-3:30pm ust/meeting_minutes_october_11_13_2022.txt Last modified: 2022/10/14 00:50by jchang