Reconfigure Databases

[ethanjweiner]

Task Title

Task: Reconfigure Databases

Task Description

This Task will...

• Reconfigure the databases into one "points" database
• Tables: points (all ip addresses + landing points), paths (possible paths to take)
• For user-specific routers: Either store in a temporary in-memory database (not on the server), OR store directly in the Flask app as some sort of global variable
• Overall result: IP address database is deleted, points database is updated w/ all points, and routers are randomly chosen from the database locally

Epic Parent

Feature: Awesome Feature Title

[ethanjweiner]

Solution: Randomly select the routers, retrieve the router ids, and store in a session variable. Then query those routers whenever access is needed. If the querying is slow, just query once and condense the route requests into a singular request with a loop (so that the routers must only be queried once).

[ethanjweiner]

Better solution: Recreate the routers database such that the routers are randomly ordered. Then, to "randomly select" the routers for a given session, all that is needed to do is to generate a singular router id, and the rest can be derived from that router id (by simple addition). This solves the problem of needing to store multiple router ids in one session variable.