Integration with testing about goose

[VojtechVitek]

Hey there,
I do the following in our CI tests:

Given I have

• schema.sql file with latest DB schema
• and schema-pre-migration.sql file matching the DB schema state before the first available migration is run (this is how we clean-up old migrations)

DB schema + Goose migration test:

1. DROP database_goose
2. CREATE database_goose
3. psql database_goose < schema-pre-migration.sql
4. goose up
5. goose reset
6. goose up
7. pg_dump database_goose --schema-only | grep -v -e '^--' -e '^COMMENT ON' -e '^REVOKE' -e '^GRANT' -e '^SET' -e 'ALTER DEFAULT PRIVILEGES' -e 'OWNER TO' | cat -s > schema.sql
8. git diff the schema.sql against "latest" schema.sql that is checked-into our git codebase and error out if it differs

Application tests:

1. DROP database_app
2. CREATE database_app
3. psql database_app < schema.sql
4. Run application tests against latest schema only

[yoesoff]

solved by removing "\ from command arguments