Skip to content

Fixed it

Fixed it #1022

GitHub Actions / Test report PostgreSQL succeeded Aug 13, 2023 in 0s

Test report PostgreSQL ✅

Tests passed successfully

✅ test-results-PostgreSQL.xml

72 tests were completed in 52s with 72 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
grate.unittests.PostgreSQL.Database 6✅ 2s
grate.unittests.PostgreSQL.DockerContainer 1✅ 14ms
grate.unittests.PostgreSQL.MigrationTables 16✅ 5s
grate.unittests.PostgreSQL.Running_MigrationScripts.Anytime_scripts 5✅ 2s
grate.unittests.PostgreSQL.Running_MigrationScripts.DropDatabase 1✅ 2s
grate.unittests.PostgreSQL.Running_MigrationScripts.Environment_scripts 4✅ 1s
grate.unittests.PostgreSQL.Running_MigrationScripts.Everytime_scripts 5✅ 2s
grate.unittests.PostgreSQL.Running_MigrationScripts.Failing_Scripts 20✅ 8s
grate.unittests.PostgreSQL.Running_MigrationScripts.One_time_scripts 4✅ 2s
grate.unittests.PostgreSQL.Running_MigrationScripts.Order_Of_Scripts 1✅ 369ms
grate.unittests.PostgreSQL.Running_MigrationScripts.ScriptsRun_Table 4✅ 1s
grate.unittests.PostgreSQL.Running_MigrationScripts.TokenScripts 2✅ 556ms
grate.unittests.PostgreSQL.Running_MigrationScripts.Versioning_The_Database 3✅ 831ms

✅ grate.unittests.PostgreSQL.Database

✅ Does_not_error_if_confed_to_create_but_already_exists
✅ Does_not_need_admin_connection_if_database_already_exists("Invalid stuff")
✅ Does_not_need_admin_connection_if_database_already_exists(null)
✅ Is_created_if_confed_and_it_does_not_exist
✅ Is_created_with_custom_script_if_custom_create_database_folder_exists
✅ Is_not_created_if_not_confed

✅ grate.unittests.PostgreSQL.DockerContainer

✅ IsUpAndRunning

✅ grate.unittests.PostgreSQL.MigrationTables

✅ Does_not_create_ScriptsRun_table_if_it_exists_with_another_casing("scriptsrun")
✅ Does_not_create_ScriptsRun_table_if_it_exists_with_another_casing("SCRiptSrUN")
✅ Does_not_create_ScriptsRunErrors_table_if_it_exists_with_another_casing("scriptsrunerrors")
✅ Does_not_create_ScriptsRunErrors_table_if_it_exists_with_another_casing("ScripTSRunErrors")
✅ Does_not_create_Version_table_if_it_exists_with_another_casing("version")
✅ Does_not_create_Version_table_if_it_exists_with_another_casing("vErSiON")
✅ Inserts_version_in_version_table
✅ Is_created_even_if_scripts_fail("ScriptsRun")
✅ Is_created_even_if_scripts_fail("ScriptsRunErrors")
✅ Is_created_even_if_scripts_fail("Version")
✅ Is_created_if_it_does_not_exist("ScriptsRun")
✅ Is_created_if_it_does_not_exist("ScriptsRunErrors")
✅ Is_created_if_it_does_not_exist("Version")
✅ Migration_does_not_fail_if_table_already_exists("ScriptsRun")
✅ Migration_does_not_fail_if_table_already_exists("ScriptsRunErrors")
✅ Migration_does_not_fail_if_table_already_exists("Version")

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.Anytime_scripts

✅ Are_not_run_more_than_once_when_unchanged
✅ Are_run_again_if_changed_between_runs
✅ Are_run_more_than_once_when_unchanged_but_flag_set
✅ Do_have_text_logged_by_default
✅ Do_not_have_text_logged_if_flag_set

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.DropDatabase

✅ Ensure_database_gets_dropped

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.Environment_scripts

✅ Are_not_run_by_default
✅ Are_not_run_if_not_in_environment
✅ Are_run_if_in_environment
✅ Non_environment_scripts_are_always_run

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.Everytime_scripts

✅ Are_not_run_in_baseline
✅ Are_not_run_in_dryrun
✅ Are_recognized_by_script_name
✅ Are_run_every_time_even_when_unchanged
✅ Create_index_concurrently_works

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.Failing_Scripts

✅ Aborts_the_run_giving_an_error_message
✅ Create_a_version_in_error_if_ran_without_transaction
✅ Ensure_AdminCommand_Timeout_Fires
✅ Ensure_Command_Timeout_Fires
✅ Inserts_Failed_Scripts_Into_ScriptRunErrors_Table
✅ Inserts_Large_Failed_Scripts_Into_ScriptRunErrors_Table
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[Functions])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[Indexes])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[RunAfterCreateDatabase])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[RunAfterOtherAnyTimeScripts])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[RunBeforeUp])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[RunFirstAfterUp])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[Sprocs])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[Triggers])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[Up])
✅ Rolls_Back_Runs_Of_Scripts_In(Folders[Views])
✅ Still_Runs_The_Scripts_In(Folders[AfterMigration])
✅ Still_Runs_The_Scripts_In(Folders[AlterDatabase])
✅ Still_Runs_The_Scripts_In(Folders[BeforeMigration])
✅ Still_Runs_The_Scripts_In(Folders[Permissions])

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.One_time_scripts

✅ Are_not_run_more_than_once_when_unchanged
✅ Fails_if_changed_between_runs
✅ Ignores_and_warns_if_changed_between_runs_and_flag_set
✅ Runs_and_warns_if_changed_between_runs_and_flag_set

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.Order_Of_Scripts

✅ Is_as_expected

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.ScriptsRun_Table

✅ Can_handle_large_scripts
✅ Does_not_include_the_folder_name_in_the_script_name_if_no_subfolders
✅ Does_not_overwrite_scripts_from_different_folders_with_last_content
✅ Includes_the_folder_name_in_the_script_name_if_subfolders

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.TokenScripts

✅ EnsureTokensAreReplaced
✅ EnsureUserTokensAreReplaced

✅ grate.unittests.PostgreSQL.Running_MigrationScripts.Versioning_The_Database

✅ Creates_A_New_Version_In_Progress
✅ Does_Not_Create_Versions_When_Dryrun
✅ Returns_The_New_Version_Id