QA - "As a lake developer, I want migrations run when I run make dev"

[kevin-kline]

This is a QA test case for #979

Here is the test procedure I conducted. Changes have been pushed to migrations-v2

QA Flow - Dev

• Clone repo
• Switch to migration branch
• Copy .env file
• Run make compose (mysql, Grafana)
• DBs get created without tables from running docker-compose-startup.sql script

• unexpected: Where are the schema migrations tables?
• Trying again by dropping tables manually
• Same result
• Creating tables manually with mysql -u root --protocol=tcp -padmin -h localhost -e "USE lake; CREATE TABLE IF NOT EXISTS schema_migrations (version bigint NOT NULL DEFAULT 1,dirty tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (version)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;”

• Running make dev to see migrations
• Received 2 errors on migrations:

• Paths are wrong:
  • /Users/kevinkline/Merico/test/devlake/bin/lake/db/migration/.
  • /Users/kevinkline/Merico/test/devlake/plugins/compound/migration/.
• Changed MIGRATIONS_PATH to fix
• Now 2 errors:

• 2nd one is caused by the fact there IS no migration folder for compound

• Fix added to check if path exists
• Only error now:

• However, all tables are migrated:

• This satisfies the following condition:
 “As a lake developer, I want migrations run when I run make dev”

[klesh]

Resolved by #1057