There is a mechanism that ensures that the schema log always contains entries for the current schema version (two cases: I create the database from scratch; I update an existing database)

Write a test case that checks that the current schema version is equal to the expected version. The expected version is the target version of the latest upgrade SQL script for the specific database.

Get expected version:

1. Which DB is used?
2. Scan files with DB specific prefix
   1. Get target schema version
   2. find latest schema version

We must validate that:

• there are only files that have a prefix that corresponds to one of the databases
• there are no files that don't match one of the two file patterns

file pattern examples:
postgres_engine_7.3_patch_7.3.5_to_7.3.6_2.sql
postgres_engine_7.3_to_7.4.sql