Due to the querying and manipulation of JSON columns, using the in-memory SQLite db, the tests cannot check certain methods/models. So, this PR updates the testing DB to MySQL.
Passing Tests
macbook@Matthews-MacBook-Air PennState-Class-Scheduler % php artisan test
PASS Tests\Feature\CourseTest
✓ auth user can visit courses index
✓ auth user sees correct courses on courses index
✓ guest can not visit courses index
✓ dev auth user can visit create course
✓ non dev auth user can not visit create course
✓ guest can not visit create course
✓ dev auth user can visit edit course
✓ non dev auth user can not visit edit course
✓ guest can not visit edit course
✓ dev auth user can create a course
✓ dev auth user can create a course with prerequisites
✓ dev auth user can create a course with concurrents
✓ dev auth user can create a course with prerequisites and concurrents
✓ dev auth user can not create a course with a course title already taken
✓ dev auth user can not create a course with a course abbreviation already taken
✓ dev auth user can not create a course with no description
✓ dev auth user can not create a course with invalid number of credits
✓ dev auth user can not create a course with invalid semester choice
✓ dev auth user can not create a course with invalid concurrents choice
✓ dev auth user can not create a course with invalid prerequisites choice
✓ regular auth user can not create a course
✓ guest can not create a course
✓ dev auth user can update a course
✓ dev auth user can update a course with prerequisites
✓ dev auth user can update a course with concurrents and prerequisites
✓ dev auth user can not update a course with a course title already taken
✓ dev auth user can not update a course with a course abbreviation already taken
✓ dev auth user can not update a course with no description
✓ dev auth user can not update a course with invalid number of credits
✓ dev auth user can not update a course with invalid semester choice
✓ dev auth user can not update a course with invalid concurrents choice
✓ dev auth user can not update a course with invalid prerequisites choice
✓ regular auth user can not update a course
✓ guest can not update a course
✓ dev auth user can delete a course
✓ when dev auth user deletes a course it is removed as a prerequisite from other courses
✓ regular auth user can not delete a course
✓ guest can not delete a course
PASS Tests\Feature\RegisterTest
✓ guest can register for the site
✓ guest can not register with out a penn state email address
Tests: 40 passed
Time: 3.53s
Closes #18
Purpose
Due to the querying and manipulation of JSON columns, using the in-memory SQLite db, the tests cannot check certain methods/models. So, this PR updates the testing DB to MySQL.
Passing Tests