Bcitflex

Fix

* fix(app): resolve alembic script path ([`10fea34`](https://github.com/jonbiemond/BCIT-Flex/commit/10fea34a2ab0fec4e7b95d8eed0f0244ed21862f))

Feature

* feat(app): add cli command to upgrade database ([`defda96`](https://github.com/jonbiemond/BCIT-Flex/commit/defda96d4fa665f4227bb4579d528c69c209c285))

* feat(app): add cli command to create database ([`ec24183`](https://github.com/jonbiemond/BCIT-Flex/commit/ec24183d4875c26d86a6a29d56712e63f296b4bc))

* feat: refactor migrations into package

Move migration files inside of package, so they can be run by the user to set up a database. ([`8f6015f`](https://github.com/jonbiemond/BCIT-Flex/commit/8f6015f9009b34b38c73b21211642b22a540b6ae))

Fix

* fix(app): add metadata to app db context ([`bf64aad`](https://github.com/jonbiemond/BCIT-Flex/commit/bf64aadfa7eae8b0198c0a8bd2824bfeb9b8b100))

Test

* test: omit alembic files from coverage report ([`15df256`](https://github.com/jonbiemond/BCIT-Flex/commit/15df2563bb3059c78121bbfa36c02eec8a7aae24))

Fix

* fix(db): increase course.url allowed length ([`8406190`](https://github.com/jonbiemond/BCIT-Flex/commit/8406190d318273af0da85357ef86b792408f11c3))

Chore

* chore: switch db url config variables ([`7cbf342`](https://github.com/jonbiemond/BCIT-Flex/commit/7cbf3420e84cf118c558dd6ffb36798f3598e03c))

Ci

* ci: apply missing dbtest marker to necessary tests ([`c974827`](https://github.com/jonbiemond/BCIT-Flex/commit/c9748277f2f3285f9cc9850cf341975acc916d6a))

Documentation

* docs: add the run instruction ([`7c581ab`](https://github.com/jonbiemond/BCIT-Flex/commit/7c581abc81f7ead0f230576664d4d935c3183bf1))

Feature

* feat(app): add index and course page to app factory ([`3333f80`](https://github.com/jonbiemond/BCIT-Flex/commit/3333f80d896881e1ee57544c9cd660b7eb2d5aaa))

* feat(app): add stylesheet ([`b9f9403`](https://github.com/jonbiemond/BCIT-Flex/commit/b9f94034eda1919dc03aea0fb7f9ecfc08d08b93))

* feat(app): add html templates for register and login ([`ba3ca49`](https://github.com/jonbiemond/BCIT-Flex/commit/ba3ca49b52331c6b9cf840c56e0c527a53e99b07))

* feat(app): add auth Blueprint ([`ccd9b6a`](https://github.com/jonbiemond/BCIT-Flex/commit/ccd9b6af5b3f4c297c5e6e9498cef67b922636ba))

* feat(model): add get_by_unique method

Add method with similar signature to session.get(),
but that returns an object by its unique constraint fields. ([`d96c04c`](https://github.com/jonbiemond/BCIT-Flex/commit/d96c04ce4f83cdece0c7be47bbdce92a952e19b8))

* feat(app): connect app to db

Extend Flask-SQLAlchemy to use SQLAlchemy Base class as Model. ([`81f65e9`](https://github.com/jonbiemond/BCIT-Flex/commit/81f65e91b79c1297a1b20964f6d127be8a5b0576))

* feat(model): add User model

- Declare User model
- Add migration for user table
- Add tests ([`ab917ab`](https://github.com/jonbiemond/BCIT-Flex/commit/ab917ab0b95e39388806f705d0cb1ef835643599))

* feat(app): configure app database connection

- Add cli command to run bcit_to_sql. ([`9f88652`](https://github.com/jonbiemond/BCIT-Flex/commit/9f88652deeccc5bda9a27035b12e0eb2a282b137))

* feat(app): add flask application factory ([`b6f0eff`](https://github.com/jonbiemond/BCIT-Flex/commit/b6f0eff21465d4643b344268543a93bf1477c9d5))

* feat(app): add courses, course and query page ([`c8009cd`](https://github.com/jonbiemond/BCIT-Flex/commit/c8009cddeda357f2ad26c1bda98c85de99f1f358))

* feat(app): add filter_courses function ([`bc81dee`](https://github.com/jonbiemond/BCIT-Flex/commit/bc81dee22e063c14f4905594c7c8059145f0dc04))

Fix

* fix(model): make User object subscriptable

Extend MappedAsDataclass with __getitem__ and mixin to the User model. ([`506e9a2`](https://github.com/jonbiemond/BCIT-Flex/commit/506e9a237e395d3ee14200115933f24e1161c043))

Refactor

* refactor: drop interface.py ([`6a277ca`](https://github.com/jonbiemond/BCIT-Flex/commit/6a277caebd79e88041f0bdddafd8724ab7a0ee9c))

* refactor: drop test util clone function

Replace usages of the test utility clone function with the clone method on Base. ([`354fdaa`](https://github.com/jonbiemond/BCIT-Flex/commit/354fdaadc74484ac9f60deadc49c119444f9156e))

Test

* test(app): add app tests ([`bf736f4`](https://github.com/jonbiemond/BCIT-Flex/commit/bf736f4e15da6f92dc5947ffd9a2b478685db043))

Fix

* fix(model): change Course.credits to type REAL

Type FLOAT(2) is automatically converted to REAL by postgres.
Consequently, the model and database fall out of sync, and `alembic check` will fail.
Explicitly declare credits as datatype REAL to avoid pre-commit failing. ([`7c993ef`](https://github.com/jonbiemond/BCIT-Flex/commit/7c993efd4fe3452c7cf363648e8522d6142fcd7e))

Refactor

* refactor: drop legacy modules ([`9030b10`](https://github.com/jonbiemond/BCIT-Flex/commit/9030b10f8004379c1ee6206b382bb7430e3cd6f1))

Fix

* fix(model): leave primary key validation to the database

Do not validate that new object&39;s PKs will not result in an integrity error. ([`2db074e`](https://github.com/jonbiemond/BCIT-Flex/commit/2db074e63c819ac603488b527f430ec35ebee104))