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/09 22:44:36 UTC
[1/2] incubator-trafficcontrol git commit: adds bool migration for
goose_db_version.is_applied field
Repository: incubator-trafficcontrol
Updated Branches:
refs/heads/psql d9f54d4d6 -> 10641c453
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/c4963a88
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/c4963a88
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/c4963a88
Branch: refs/heads/psql
Commit: c4963a88dc13d63e45c446c088ca8642c4d86788
Parents: d9f54d4
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Wed Nov 9 14:57:02 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Wed Nov 9 15:22:01 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/c4963a88/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 523645a..0e0223e 100644
--- a/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
+++ b/traffic_ops/app/db/migrations/20160910092026_fix_column_types.sql
@@ -25,7 +25,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;
@@ -86,6 +86,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
@@ -173,6 +182,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
[2/2] incubator-trafficcontrol git commit: This closes #67.
Posted by da...@apache.org.
This closes #67.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/10641c45
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/10641c45
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/10641c45
Branch: refs/heads/psql
Commit: 10641c45352300324adc4b5bda1c52381db5c3fa
Parents: c4963a8
Author: Dan Kirkwood <da...@gmail.com>
Authored: Wed Nov 9 15:44:23 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Wed Nov 9 15:44:23 2016 -0700
----------------------------------------------------------------------
----------------------------------------------------------------------