Create SQLite DB for local test - Githubissues

danieltsoukup / noise-dashboard

Noise monitoring application built as part of a CivicTechTO initiative.

MIT License

3 stars 3 forks source link

Create SQLite DB for local test #2

Open danieltsoukup opened 6 months ago

danieltsoukup commented 6 months ago

Is your feature request related to a problem? Please describe. All testing currently is dependent on the WebCommand API and network connection. We should have a small dummy DB locally that can be used to test the SQL queries.

Describe the solution you'd like

save a snapshot of the data and initialize a SQLite db
create SQLlite data loader
decouple the SQL testing from the WebCommand dataloader testing into separate files