WSU Triangle Exam Bank

Inspiration

With our organization being new to the fraternity scene, getting started on a test bank for all previous exams is crucial for our future members. Since we all take every similar classes as engineers, if I could simply type "calc 1 final" and see every years calc 1 final, I have a great way to study.

What it does

Simply query for a piece of homework from a class, or an exam, and you'll get it! Alternatively, upload your work to the database.

How we built it

Our test bank is based on Azure Blob Storage. We directly upload all blobs to azure, and then provide a NoSQL MongoDB database for text matching and keeping track of all posts. We used barebones Flask to accomplish the backend, and Pytest for our unit testing solutions. Our database is portable via Docker.

Finally, we cobbled together the front in in Svelte.

Challenges we ran into

We had a hard time setting up the project, as we originally were stuck in environment hell with a ASP.NET setup that simply wouldn't allow one of our members Mac to connect to the MySQL environment (windows has SQL Server studio, but Mac doesn't, so a docker solution was attempted).

This failed, so we pivoted to a different stack.

Accomplishments that we're proud of

Getting this entire project to run on Azure was intimidating, but we are proud we got it working.

What we learned

Most of our members hadn't used Flask, Pytest, Azure, etc, so the stack was new for everyone.

What's next for WSU Triangle Exam Bank

We will add some authentication, and make it public!

Built With

• azure
• flask
• javascript
• pytest
• python
• svelte