From ff50e1678d9307c870398803ed340dcaf02a9005 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 15 Oct 2015 11:27:45 -0400 Subject: [PATCH] sqitch config repairs and cleanup * Use verify mode of "change" so that sqitch only ever rolls back the most recently failed update. * Flesh out DB connection string to use 'evergreen' user by default * Remove unneeded comments; replace tabs. Signed-off-by: Bill Erickson --- Open-ILS/src/sql/schema/sqitch.conf | 20 +++++++++----------- Open-ILS/src/sql/test-data/sqitch.conf | 20 +++++++++----------- 2 files changed, 18 insertions(+), 22 deletions(-) diff --git a/Open-ILS/src/sql/schema/sqitch.conf b/Open-ILS/src/sql/schema/sqitch.conf index 68a5d365c2..f3ce0432dc 100644 --- a/Open-ILS/src/sql/schema/sqitch.conf +++ b/Open-ILS/src/sql/schema/sqitch.conf @@ -1,16 +1,14 @@ [core] - engine = pg - # plan_file = sqitch.plan - # top_dir = . - # deploy_dir = deploy - # revert_dir = revert - # verify_dir = verify - # extension = sql + engine = pg [target "evergreen"] - uri = db:pg:evergreen + # override at run time with --db-user and/or --db-host + uri = postgresql://evergreen@127.0.0.1/evergreen [engine "pg"] - target = evergreen + target = evergreen [deploy] - verify = true + verify = true + # only revert the last (failed) change by default. + # this helps avoid an unintended chain reaction of reverts. + mode = change [rebase] - verify = true + verify = true diff --git a/Open-ILS/src/sql/test-data/sqitch.conf b/Open-ILS/src/sql/test-data/sqitch.conf index 68a5d365c2..f3ce0432dc 100644 --- a/Open-ILS/src/sql/test-data/sqitch.conf +++ b/Open-ILS/src/sql/test-data/sqitch.conf @@ -1,16 +1,14 @@ [core] - engine = pg - # plan_file = sqitch.plan - # top_dir = . - # deploy_dir = deploy - # revert_dir = revert - # verify_dir = verify - # extension = sql + engine = pg [target "evergreen"] - uri = db:pg:evergreen + # override at run time with --db-user and/or --db-host + uri = postgresql://evergreen@127.0.0.1/evergreen [engine "pg"] - target = evergreen + target = evergreen [deploy] - verify = true + verify = true + # only revert the last (failed) change by default. + # this helps avoid an unintended chain reaction of reverts. + mode = change [rebase] - verify = true + verify = true -- 2.11.0