Testing for schemats runs in end-to-end fashion.

indexSpec.ts first loads SQL schema files into the databases defined by environment variables POSTGRES_URL and MYSQL_URL. Then typing definitions for each SQL schema is generated and placed in test/artifacts. These generated files are then compared against the expected output from test/expected in a line-by-line difference. The tests pass if there is no difference, and fails otherwise.

POSTGRES_URL="postgres://youruser@localhost/anyemptytestdatabase" MYSQL_URL="mysql://youruser@localhost/anyemptytestdatabase" npm test