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/21 19:09:41 UTC
[1/2] incubator-trafficcontrol git commit: pgloader takes care of
converting double to numeric so this file is now specific to converting
certain smallints to bool
Repository: incubator-trafficcontrol
Updated Branches:
refs/heads/psql-rebase 8fed76abc -> 427b99efd
pgloader takes care of converting double to numeric so this file is now specific to converting certain smallints to bool
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/324134b0
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/324134b0
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/324134b0
Branch: refs/heads/psql-rebase
Commit: 324134b091585f00038413e9ca0da1ba7546f677
Parents: 8fed76a
Author: Jeremy Mitchell <mi...@gmail.com>
Authored: Mon Nov 21 10:17:21 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Mon Nov 21 12:07:46 2016 -0700
----------------------------------------------------------------------
traffic_ops/app/db/convert_bools.sql | 95 +++++++++++++++++++++++
traffic_ops/app/db/convert_data_types.sql | 101 -------------------------
2 files changed, 95 insertions(+), 101 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/324134b0/traffic_ops/app/db/convert_bools.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/convert_bools.sql b/traffic_ops/app/db/convert_bools.sql
new file mode 100644
index 0000000..ae605e6
--- /dev/null
+++ b/traffic_ops/app/db/convert_bools.sql
@@ -0,0 +1,95 @@
+ALTER TABLE cdn
+ ALTER COLUMN dnssec_enabled DROP DEFAULT,
+ ALTER COLUMN dnssec_enabled TYPE boolean
+ USING CASE WHEN dnssec_enabled = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN dnssec_enabled SET DEFAULT FALSE;
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN active DROP DEFAULT,
+ ALTER COLUMN active TYPE boolean
+ USING CASE WHEN active = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN active SET DEFAULT FALSE;
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN signed DROP DEFAULT,
+ ALTER COLUMN signed TYPE boolean
+ USING CASE WHEN signed = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN signed SET DEFAULT FALSE;
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN ipv6_routing_enabled DROP DEFAULT,
+ ALTER COLUMN ipv6_routing_enabled TYPE boolean
+ USING CASE WHEN ipv6_routing_enabled = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN ipv6_routing_enabled SET DEFAULT FALSE;
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN multi_site_origin DROP DEFAULT,
+ ALTER COLUMN multi_site_origin TYPE boolean
+ USING CASE WHEN multi_site_origin = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN multi_site_origin SET DEFAULT FALSE;
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN regional_geo_blocking DROP DEFAULT,
+ ALTER COLUMN regional_geo_blocking TYPE boolean
+ USING CASE WHEN regional_geo_blocking = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN regional_geo_blocking SET DEFAULT FALSE;
+
+ALTER TABLE deliveryservice
+ ALTER COLUMN logs_enabled DROP DEFAULT,
+ ALTER COLUMN logs_enabled TYPE boolean
+ USING CASE WHEN logs_enabled = 1 THEN TRUE
+ ELSE FALSE
+ 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 = 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
+ USING CASE WHEN secure = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN secure SET DEFAULT FALSE;
+
+ALTER TABLE server
+ ALTER COLUMN upd_pending DROP DEFAULT,
+ ALTER COLUMN upd_pending TYPE boolean
+ USING CASE WHEN upd_pending = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN upd_pending SET DEFAULT FALSE;
+
+ALTER TABLE tm_user
+ ALTER COLUMN new_user DROP DEFAULT,
+ ALTER COLUMN new_user TYPE boolean
+ USING CASE WHEN new_user = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN new_user SET DEFAULT FALSE;
+
+ALTER TABLE to_extension
+ ALTER COLUMN isactive DROP DEFAULT,
+ ALTER COLUMN isactive TYPE boolean
+ USING CASE WHEN isactive = 1 THEN TRUE
+ ELSE FALSE
+ END,
+ ALTER COLUMN isactive SET DEFAULT FALSE;
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/324134b0/traffic_ops/app/db/convert_data_types.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/convert_data_types.sql b/traffic_ops/app/db/convert_data_types.sql
deleted file mode 100644
index 58ef32e..0000000
--- a/traffic_ops/app/db/convert_data_types.sql
+++ /dev/null
@@ -1,101 +0,0 @@
-ALTER TABLE cachegroup ALTER COLUMN latitude TYPE numeric;
-ALTER TABLE cachegroup ALTER COLUMN longitude TYPE numeric;
-
-ALTER TABLE cdn
- ALTER COLUMN dnssec_enabled DROP DEFAULT,
- ALTER COLUMN dnssec_enabled TYPE boolean
- USING CASE WHEN dnssec_enabled = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN dnssec_enabled SET DEFAULT FALSE;
-
-ALTER TABLE deliveryservice ALTER COLUMN miss_lat TYPE numeric;
-ALTER TABLE deliveryservice ALTER COLUMN miss_long TYPE numeric;
-
-ALTER TABLE deliveryservice
- ALTER COLUMN active DROP DEFAULT,
- ALTER COLUMN active TYPE boolean
- USING CASE WHEN active = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN active SET DEFAULT FALSE;
-
-ALTER TABLE deliveryservice
- ALTER COLUMN signed DROP DEFAULT,
- ALTER COLUMN signed TYPE boolean
- USING CASE WHEN signed = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN signed SET DEFAULT FALSE;
-
-ALTER TABLE deliveryservice
- ALTER COLUMN ipv6_routing_enabled DROP DEFAULT,
- ALTER COLUMN ipv6_routing_enabled TYPE boolean
- USING CASE WHEN ipv6_routing_enabled = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN ipv6_routing_enabled SET DEFAULT FALSE;
-
-ALTER TABLE deliveryservice
- ALTER COLUMN multi_site_origin DROP DEFAULT,
- ALTER COLUMN multi_site_origin TYPE boolean
- USING CASE WHEN multi_site_origin = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN multi_site_origin SET DEFAULT FALSE;
-
-ALTER TABLE deliveryservice
- ALTER COLUMN regional_geo_blocking DROP DEFAULT,
- ALTER COLUMN regional_geo_blocking TYPE boolean
- USING CASE WHEN regional_geo_blocking = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN regional_geo_blocking SET DEFAULT FALSE;
-
-ALTER TABLE deliveryservice
- ALTER COLUMN logs_enabled DROP DEFAULT,
- ALTER COLUMN logs_enabled TYPE boolean
- USING CASE WHEN logs_enabled = 1 THEN TRUE
- ELSE FALSE
- 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 = 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
- USING CASE WHEN secure = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN secure SET DEFAULT FALSE;
-
-ALTER TABLE server
- ALTER COLUMN upd_pending DROP DEFAULT,
- ALTER COLUMN upd_pending TYPE boolean
- USING CASE WHEN upd_pending = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN upd_pending SET DEFAULT FALSE;
-
-ALTER TABLE tm_user
- ALTER COLUMN new_user DROP DEFAULT,
- ALTER COLUMN new_user TYPE boolean
- USING CASE WHEN new_user = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN new_user SET DEFAULT FALSE;
-
-ALTER TABLE to_extension
- ALTER COLUMN isactive DROP DEFAULT,
- ALTER COLUMN isactive TYPE boolean
- USING CASE WHEN isactive = 1 THEN TRUE
- ELSE FALSE
- END,
- ALTER COLUMN isactive SET DEFAULT FALSE;
[2/2] incubator-trafficcontrol git commit: This closes #98.
Posted by da...@apache.org.
This closes #98.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/427b99ef
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/427b99ef
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/427b99ef
Branch: refs/heads/psql-rebase
Commit: 427b99efd779ba8fbd68c8d0be0a049813703610
Parents: 324134b
Author: Dan Kirkwood <da...@gmail.com>
Authored: Mon Nov 21 12:09:21 2016 -0700
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Mon Nov 21 12:09:21 2016 -0700
----------------------------------------------------------------------
----------------------------------------------------------------------