Create Test Data for DB

[MCoriale]

As a developer, I want to be able to populate a PostgreSQL database with mock data to use during development and testing of the Covid Tracer system.

Acceptance Criteria

• [ ] Generate data for students that includes ...

• Name (first, preferred, last)

• Student ID # (9 digit unique identifier)

• Cell Phone #

• Campus/Off-Campus Residence

• Quarantine/Isolation Location

• Start and End Date of Quarantine/Isolation

• Assigned Support Coordinator

• Meal Plan Info (hasMealPlan, meals wanted per day, ...)

• Greek Life (if part, which fraternity/sorority)

• Athletics

• Roommates and Suitemates

• Permanent Home Address

• Symptom Information (what symptoms, which day symptoms began)

• Test Collection Date

• Transportation Status (do they need transportation to quarantine?)

• [ ] Generate data for quarantine location that includes ...

• Address

• Assigned Student

• [ ] Generate data for support coordinator that includes ...

• Name

• Assigned Students

• [ ] Be able to insert the generated data into a local copy of the PostgreSQL database for use.

[MCoriale]

Current status-- I am updating the test script, which currently populates the person table with randomly-generated values for students, their phone numbers, etc. so that it can also include a few attributes we learned of later and also make people students, contact tracers, or part of a positive case. Once we have a working script, I can run it and populate my database, and export the data to Spring JPA's data.sql file so when the application runs everyone can have the same data in their database. That way it would be easier to do unit testing and make sure everything is running as it should be.