Bcitflex

Chore

* chore(deps-dev): bump gitpython from 3.1.37 to 3.1.41

Bumps [gitpython](https://github.com/gitpython-developers/GitPython) from 3.1.37 to 3.1.41.
- [Release notes](https://github.com/gitpython-developers/GitPython/releases)
- [Changelog](https://github.com/gitpython-developers/GitPython/blob/main/CHANGES)
- [Commits](https://github.com/gitpython-developers/GitPython/compare/3.1.37...3.1.41)

---
updated-dependencies:
- dependency-name: gitpython
dependency-type: indirect
...

Signed-off-by: dependabot[bot] <supportgithub.com> ([`408b0fe`](https://github.com/jonbiemond/BCIT-Flex/commit/408b0feb6b671668b99f3704105b0a8d49086c2b))

* chore(deps): bump jinja2 from 3.1.2 to 3.1.3

Bumps [jinja2](https://github.com/pallets/jinja) from 3.1.2 to 3.1.3.
- [Release notes](https://github.com/pallets/jinja/releases)
- [Changelog](https://github.com/pallets/jinja/blob/main/CHANGES.rst)
- [Commits](https://github.com/pallets/jinja/compare/3.1.2...3.1.3)

---
updated-dependencies:
- dependency-name: jinja2
dependency-type: indirect
...

Signed-off-by: dependabot[bot] <supportgithub.com> ([`e91b2f6`](https://github.com/jonbiemond/BCIT-Flex/commit/e91b2f669bf221e9b900c4d9f8e7b8f131683cf8))

Feature

* feat(app): add prereq table to course page

Add a table listing prerequisite courses to the course page.

Closes 86 ([`7488e79`](https://github.com/jonbiemond/BCIT-Flex/commit/7488e793db37ba5d6e0a2e8f2bf7d4d654e5806f))

* feat(scraper): parse prerequisites into db objects

Add function to parse Course prerequisite string into database objects.

Closes 84 ([`3e6d2a8`](https://github.com/jonbiemond/BCIT-Flex/commit/3e6d2a8a5bd83111b2d4c1a2d548c76bf26e59a0))

* feat(model): add Prerequisite model

- Update parsing tests to be regex based. ([`bae9f63`](https://github.com/jonbiemond/BCIT-Flex/commit/bae9f63aac6675219fb11759185168d89f93a034))

Chore

* chore(deps): bump werkzeug from 2.3.7 to 2.3.8

Bumps [werkzeug](https://github.com/pallets/werkzeug) from 2.3.7 to 2.3.8.
- [Release notes](https://github.com/pallets/werkzeug/releases)
- [Changelog](https://github.com/pallets/werkzeug/blob/main/CHANGES.rst)
- [Commits](https://github.com/pallets/werkzeug/compare/2.3.7...2.3.8)

---
updated-dependencies:
- dependency-name: werkzeug
dependency-type: indirect
...

Signed-off-by: dependabot[bot] <supportgithub.com> ([`b6f9ff4`](https://github.com/jonbiemond/BCIT-Flex/commit/b6f9ff44814a0356c34b35545c90529335401022))

Feature

* feat(app): filter courses by favourite programs

Resolves 64, resolves 71 ([`777011b`](https://github.com/jonbiemond/BCIT-Flex/commit/777011b6da16315fd174f780a6078b2ce1b83526))

* feat(backend): support relation properties as links in ModelFilter ([`c8394ca`](https://github.com/jonbiemond/BCIT-Flex/commit/c8394ca9d9d88eaae063842d64b67b52ad94e48d))

* feat(app): mark program as favourite

Add the ability for user to mark a program as favourite.
Display favourite programs on account page.

Refactor session fixture to db_session,
to avoid name conflict with Flask session. ([`cb69bc8`](https://github.com/jonbiemond/BCIT-Flex/commit/cb69bc822c818965c753fa95359a134c1ac90d94))

* feat(app): redirect to the requested page after login ([`5b38f62`](https://github.com/jonbiemond/BCIT-Flex/commit/5b38f621dcaac04ba2c035924cc6a6ee155847ca))

* feat(app): add account page ([`61d1558`](https://github.com/jonbiemond/BCIT-Flex/commit/61d15584d52f31d5fdc1df29f6b3fc5ee2c28739))

* feat(model): add UserPreference model ([`f1047b5`](https://github.com/jonbiemond/BCIT-Flex/commit/f1047b5207cea239681ffdf69bf53523c2a1b4e9))

* feat(app): rebuild course route to include subject and code ([`0b05b44`](https://github.com/jonbiemond/BCIT-Flex/commit/0b05b44d5ad233f82dd3925a03df5a34ac93983b))

Test

* test: improve test coverage (79)

Add tests for authorization and `create_db` command. ([`182f19f`](https://github.com/jonbiemond/BCIT-Flex/commit/182f19f25c4d62eae07e3c9c7db608e3852673ab))

* test: improve test coverage (78)

Improve coverage of scrape and db tests.

---------

Co-authored-by: Dominik Imrich <dominik.imrichstudent.tuke.sk> ([`fc1e2d0`](https://github.com/jonbiemond/BCIT-Flex/commit/fc1e2d0561c519dad200e0f7498cb97d481238b2))

Feature

* feat(app): paginate course index

Closes 36 ([`8999ee8`](https://github.com/jonbiemond/BCIT-Flex/commit/8999ee8ca4f1ca2fff1859a96f3dd9902ab071f3))

* feat(app): implement course filters as SQL

Apply course filters via SQL instead of in state.
It is more efficient to filter courses at the database level. ([`85b62bd`](https://github.com/jonbiemond/BCIT-Flex/commit/85b62bd2affc64fdddea81250b9a60d9f4b191df))

* feat(app): add course search

Closes 61 ([`b844873`](https://github.com/jonbiemond/BCIT-Flex/commit/b844873095b61b44f57c8f4ca89e0303e64ce0d4))

Fix

* fix(app): handle adding already included table to ModelFilter ([`a982e5e`](https://github.com/jonbiemond/BCIT-Flex/commit/a982e5e4a96816620efbb2ba33a76f1d5f9c043e))

Feature

* feat(app): add subject and campus select elements ([`50e1af2`](https://github.com/jonbiemond/BCIT-Flex/commit/50e1af2ef4fc11281901ab4383969114cc374384))

* feat(app): add course filter interface ([`0675fd9`](https://github.com/jonbiemond/BCIT-Flex/commit/0675fd94211cb00476f6e09f28aea76ed4db3aa9))

Feature

* feat(model): make course.set_id() generic and move to base

Make the set_id() method of Course more general and add it to the Base model, so it can be used on other models. ([`53565cd`](https://github.com/jonbiemond/BCIT-Flex/commit/53565cd33ac6e813c50a741b4ca59355fe329321))

Fix

* fix(model): add offering surrogate key

Replace Offering CRN with offering_id as the primary key.
CRN is not unique beyond terms.

Fixes 60 ([`fcdaf9d`](https://github.com/jonbiemond/BCIT-Flex/commit/fcdaf9ddad8a6ec925a4153ca1d6427956afd3e0))

* fix(db): include all columns in unique constraint name ([`29c6cb0`](https://github.com/jonbiemond/BCIT-Flex/commit/29c6cb0337355643e7fb35639b3c547f78084055))

Chore

* chore: drop unused db_config.py ([`ba2e110`](https://github.com/jonbiemond/BCIT-Flex/commit/ba2e110d3c9f5ff345d0db26e8322de70cade44d))

Ci

* ci: add dev to on ci ([`c54e97e`](https://github.com/jonbiemond/BCIT-Flex/commit/c54e97e7463d5949b665a84586b0b03a19cd7b87))

Documentation

* docs: instruct to target dev branch ([`5aa5d35`](https://github.com/jonbiemond/BCIT-Flex/commit/5aa5d359792c6ec69fc2a3331ede36eff7c9ea13))

Feature

* feat(app): add lower navbar ([`fc9fb65`](https://github.com/jonbiemond/BCIT-Flex/commit/fc9fb65e7eb3294ffd469168537f278e63688b73))

* feat(app): add program index and program page ([`dd30eaf`](https://github.com/jonbiemond/BCIT-Flex/commit/dd30eaf5b27861d34d97cb24b5557c558c310c5f))

* feat(script): add load_programs script and command ([`6cc397b`](https://github.com/jonbiemond/BCIT-Flex/commit/6cc397ba3208d4d7a7cb8d4530c6489c8ff1f595))

* feat(model): add Program model ([`15edaa7`](https://github.com/jonbiemond/BCIT-Flex/commit/15edaa73221631e72910c9e1f3c8d236c2114e77))

* feat(db): add programs.json ([`5c92b84`](https://github.com/jonbiemond/BCIT-Flex/commit/5c92b84e678169140752e979e9c29b0276932551))

Fix

* fix(scraper): undelete objects on merge

On merge of an object set `deleted_at` to None, so it is un-deleted. ([`35ba339`](https://github.com/jonbiemond/BCIT-Flex/commit/35ba339cc538ab15a356fbf63d4e8f307af50e3f))

Style

* style: fix table style in light mode

Fixes 55 ([`5e2d1f9`](https://github.com/jonbiemond/BCIT-Flex/commit/5e2d1f9676c69dd4f2a763cedd99828bbe2178f4))