bcitflex 3.1.4

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

pip install bcitflex

Prerequisites

• A PostgreSQL instance is required for the database.
• Dependency psycopg2 requires libpq-dev to be installed for Ubuntu/Debian systems.

sudo apt install libpq-dev python3-dev

For more details see the pycopg2 documentation and StackOverflow.

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:

flask --app bcitflex upgrade-db

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 dev 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