You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by da...@apache.org on 2016/11/14 17:07:51 UTC
[48/53] [abbrv] incubator-trafficcontrol git commit: adds bool
migration for goose_db_version.is_applied field
adds bool migration for goose_db_version.is_applied field
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/57baf3aa
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/57baf3aa
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/57baf3aa
Branch: refs/heads/psql-rebase
Commit: 57baf3aa54fc679b3a2fc90fc9e4ee136878f607
Parents: 5c1cbc4
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Wed Nov 9 14:57:02 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Fri Nov 11 14:43:13 2016 -0700
----------------------------------------------------------------------
.../migrations/20160910092026_fix_column_types.sql | 17 ++++++++++++++++-
1 file changed, 16 insertions(+), 1 deletion(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/57baf3aa/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql b/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
index 7afe1bf..dd84a7a 100644
--- a/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
+++ b/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
@@ -10,7 +10,7 @@ ALTER TABLE cdn
ALTER COLUMN dnssec_enabled TYPE boolean
USING CASE WHEN dnssec_enabled = 0 THEN FALSE
WHEN dnssec_enabled = 1 THEN TRUE
- ELSE FALSE
+ ELSE NULL
END,
ALTER COLUMN dnssec_enabled SET DEFAULT FALSE;
@@ -71,6 +71,15 @@ ALTER TABLE deliveryservice
END,
ALTER COLUMN logs_enabled SET DEFAULT FALSE;
+ALTER TABLE goose_db_version
+ ALTER COLUMN is_applied DROP DEFAULT,
+ ALTER COLUMN is_applied TYPE boolean
+ USING CASE WHEN is_applied = 0 THEN FALSE
+ WHEN is_applied = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN is_applied SET DEFAULT FALSE;
+
ALTER TABLE parameter
ALTER COLUMN secure DROP DEFAULT,
ALTER COLUMN secure TYPE boolean
@@ -158,6 +167,12 @@ ALTER TABLE deliveryservice
USING CASE WHEN logs_enabled THEN 1 ELSE 0 END,
ALTER COLUMN logs_enabled SET DEFAULT 0;
+ALTER TABLE goose_db_version
+ ALTER COLUMN is_applied DROP DEFAULT,
+ ALTER COLUMN is_applied TYPE SMALLINT
+ USING CASE WHEN is_applied THEN 1 ELSE 0 END,
+ ALTER COLUMN is_applied SET DEFAULT 0;
+
ALTER TABLE parameter
ALTER COLUMN secure DROP DEFAULT,
ALTER COLUMN secure TYPE SMALLINT