bcitflex 3.1.1

Browse BCIT Flex course offerings.

BCIT Flex

Webscrape BCIT available courses, quickly view course offerings and write the information to a text file

Please feel free to report any issues, bugs or suggestions. Pull requests are welcome.

The information is

• Code
• Name
• Prerequisites
• Credits
• URL
• Offerings
  • Instructor
  • Price
  • Duration
  • Meeting Times
  • Status
  • Rate My Professor URLs

Installation

• Clone the repository
• Install the requirements poetry install

Note: Additionally a PostgreSQL instance is required for the database.

DB Setup

PostgreSQL is used as the DBMS. To create and initialize the database:

1. Create a database using the cli command. Pass --help for more information.

flask --app bcitflex create-db

2. Build schema using alembic:

poetry run alembic upgrade head

3. Populate the database with subjects from psql:

\i bcitflex/scripts/populate_subject.sql

Usage

To run the webscraper and populate the database with the latest course offerings:

poetry run flask --app bcitflex load-db

To run the webserver:

poetry run flask --app bcitflex run

Supports

• Displaying all course offerings for specific course
• Saving all courses to a text file for a specific subject

TODO

• Filter by prerequisites
• Individual Course Offerings
• Rate My Professors
• Web app
• GUI
• Return RMP rating

Contributors

• Sam - 0x53616D75656C
• Jonathan - jonbiemond