search

jonbiemond / BCIT-Flex

A website for easily navigating BCIT courses and offerings.
https://www.bcitflex.tech
MIT License
10 stars 8 forks source link

Implement course filters as SQL #75

Closed jonbiemond closed 8 months ago

jonbiemond commented 8 months ago

Apply course filters via SQL instead of in state. It is more efficient to filter courses at the database level. Allows us to utilize Flask-SQLAlchemy's paginate function for #36.

Replaces #74

jonbiemond commented 8 months ago

@MikeVarchola I went a different route then SQL views. I think this should easily allow you to implement the paginate feature. Do you mind giving it a quick review to see if it's compatible?

MikeVarchola commented 8 months ago

@jonbiemond but yes, this solution will work with paginate() from SQLAlchemy