,Over the weekend, I worked on and completed a skeletal version of the weekly report, which produced the number of too-warm, too-cold, and too-much-carbon intervals for each room logged as having problems.
Now, I'm working on a more complex version, with a few more steps and a database. This new version will log all the data to a SQL database every 15 minutes, rather than four times per day (using SQLAlchemy and SQLite). Whenever data is logged, it will read in and analyze problem rooms, saving that somewhere else. Each day, the system will take the problem data from the 15-minute intervals and aggregate it by room number into a set of "daily" data. Finally, once a week, the system will take seven days' worth of daily data and turn it into a cohesive weekly report. As Mr. Navkal explained to me, this version allows for more flexibility, as all the raw data is being saved in addition to the summary displayed to the user. During class yesterday, I mainly started learning how to use a database with SQLAlchemy and SQLite. (We read from the databases using SQLAlchemy, and write to them using SQLite.) It was pretty interesting to learn about in general! Comments are closed.
|
AuthorI'm a high school senior and programming enthusiast. Archives
March 2022
Categories |