Currently it's difficult to set up a local DB that has all of the tables created and loaded with seed data: you have to run the .sql files manually and there's still a lot of errors. The work here is to:
have the docker-compose.yml file automatically run the .sql files under wtt_db/tables in the correct order, accounting for tables that need to be created before others because of foreign keys.
fix any errors that appear when running docker-compose.yml.
confirm that you can login as the "trees" user with the correct password (this requires setting up an .env file, reach out to @zoobot or me on this).
Problem Description
Currently it's difficult to set up a local DB that has all of the tables created and loaded with seed data: you have to run the .sql files manually and there's still a lot of errors. The work here is to: