park-junha / GradPlanner

An automated four-year undergraduate degree scheduler.
http://gradplanner.us
GNU General Public License v3.0
2 stars 0 forks source link

Some alternate-year upper division courses are showing up on the wrong year #62

Closed park-junha closed 4 years ago

park-junha commented 4 years ago

While the database is correctly storing information on when classes should be offered, the application is placing them on wrong years.

The SQL file for the upper division classes can be found on data.sql here, inserted into the Classes table. The key that holds information on what quarters/years a particular class is offered is QuarterOffered, where F, W, and S represent Fall/Winter/Spring, O represents odd years (2019-20, 2021-22, etc) and E represents even years (2020-21, 2022-23, etc). The live database is currently identical to this file.

Observed on master at commit e6d28ac. Bug should be fixed on main.py (likely in the FourYearPlan class) and off of a new branch off master.

The screenshots below can be replicated by inputting CSCI Algorithms/Complexity emphasis and CSCI Security emphasis on the first questionnaire page and "Fall" and "2020-21" on the second page.

Screenshots

Screenshot of upper division course schedule: Screen Shot 2020-01-17 at 10 31 49 AM

Screenshot of schedule by web app (CSCI 181 is not offered spring 2022-23, but placed there by algorithm) Screen Shot 2020-01-17 at 10 30 26 AM

162 and 177 not offered winter 2023-24, but placed there by algorithm: Screen Shot 2020-01-17 at 10 31 05 AM

park-junha commented 4 years ago

@manpreetssokhi in the backend directory, run ./backend.sh -l to access the database (do NOT run with -r or -h flags)

park-junha commented 4 years ago

edit: problem is in main.py (originally wrote main.sql, sorry for confusion)

park-junha commented 4 years ago

@manpreetssokhi work on this after #84 but before #86