DiningDawgs

Provides an easy to use website to view the capacity of all the dining halls at UGA. Includes history!

By the by: Never ever run the setup script unless you want to delete everything in the database.

Github Pages link : https://evantich.github.io/DiningDawgs/ or http://diningdawgs.com (derelict)

How to make the website work

Use a Raspberry Pi to host the python file here and run it using Python 3.

Database structure and access

Note: unix_time is in seconds since the epoch and hall = bolton, summit, ohouse, snelling, or smith other stuff can go in data too (like stats) if needed

data: {
    last_update: {
        time: unix_time,
        url: string with the hall replaced with {}
    },
    next_update: unix_time,
    
    
    hall: { 
        year: {
            month: {
                day: {
                    hour: {
                        min: percent
                    }
                }
            }
        }
    }
}

Call https://dining-capacity.firebaseio.com/data/{hall}/{year}/{month}/{day}/{hour}.json to get every timestamp and percent. For example: https://dining-capacity.firebaseio.com/data/bolton/2019/2/22.json to get every timestamp and percent from that day.

Look at this for more ways of getting the data.

TODO

• Change the database to be good
  • /data/hall/year/month/day/hour/min.json = percent
  • Change the scripts to add correctly too.
  • Actually put on database
• Make the database "private" so you have to use an auth code
• Make the website server side to make sure people can't get to the underlying database (and auth keys)
  • locally store the latest version of the webpage (problems with updating the graph with this approach)
• Instead of listing the day when hovering over the line plot, list the hours and minutes
• Update the website's current capacity periodically (every 5 minutes)
• Fix the positioning of the selectors (sorta)
• Stop a user from choosing an invalid date
  • user can only choose actual dates, e.g. Feb 30 (doesn't exist)
• Option to show all dining hall lines on same graph
• Have a proper title, heading, and stuff below on the page
• Perhaps change from CanvasJS to a free alternative (that link in the bottom is stupid)
  • changed to ChartJS, it works well enough
• Asyncronous calls for getting the json data(sorta) and updating the graph
• Seperate the two tabs from one page to two pages
• Fix width of the graph being messed up when the page loads initially
  • fixed when moving over to ChartJS
• Remove bootstrap and jquery dependencies
• Find a way to get font dynamically when drawing floating labels
  • doesn't matter, looks good enough
• Fix the sudden jump for the floating labels when bar chart updates
  • Test with code snippet: var asda = 0; setInterval(() => {barChart.data.datasets[0].data[0] = (asda = asda % 100 + 5); barChart.update();}, 1500);
• asyncronous get request instead of the current option
• OR swap from XMLHttpRequest to fetch
• cache line graph when first loaded and only load the rest of the graph later
• ?just get the data straight from uga (will only call the database once instead of five times) this doesn't work