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 2017/05/09 18:30:57 UTC
[22/27] incubator-trafficcontrol git commit: removed demo seeds as
the data/profiles supplants it
removed demo seeds as the data/profiles supplants it
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/4c6db492
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/4c6db492
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/4c6db492
Branch: refs/heads/master
Commit: 4c6db492b8621843610735a4042563b104486b6e
Parents: 9788eab
Author: Dewayne Richardson <de...@apache.org>
Authored: Tue May 9 08:54:01 2017 -0600
Committer: Dan Kirkwood <da...@gmail.com>
Committed: Tue May 9 18:28:59 2017 +0000
----------------------------------------------------------------------
traffic_ops/app/db/admin.pl | 4 ----
traffic_ops/app/db/seeds_demo.sql | 39 ----------------------------------
2 files changed, 43 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/4c6db492/traffic_ops/app/db/admin.pl
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/admin.pl b/traffic_ops/app/db/admin.pl
index 0a3d8bb..bf6093e 100755
--- a/traffic_ops/app/db/admin.pl
+++ b/traffic_ops/app/db/admin.pl
@@ -65,7 +65,6 @@ my $usage = "\n"
. "redo - Roll back the most recently applied migration, then run it again.\n"
. "reset - Execute db 'dropdb', 'createdb', load_schema, migrate on the database for the current environment.\n"
. "reverse_schema - Reverse engineer the lib/Schema/Result files from the environment database.\n"
- . "seed_demo - Execute sql from db/seeds_demo.sql for loading static demo data.\n"
. "seed - Execute sql from db/seeds.sql for loading static data.\n"
. "show_users - Execute sql to show all of the user for the current environment.\n"
. "status - Print the status of all migrations.\n"
@@ -134,9 +133,6 @@ if ( defined($argument) ) {
elsif ( $argument eq 'seed' ) {
seed();
}
- elsif ( $argument eq 'seed_demo' ) {
- seed_demo();
- }
elsif ( $argument eq 'load_schema' ) {
load_schema();
}
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/4c6db492/traffic_ops/app/db/seeds_demo.sql
----------------------------------------------------------------------
diff --git a/traffic_ops/app/db/seeds_demo.sql b/traffic_ops/app/db/seeds_demo.sql
deleted file mode 100644
index 4849a3c..0000000
--- a/traffic_ops/app/db/seeds_demo.sql
+++ /dev/null
@@ -1,39 +0,0 @@
-/*
-
- Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License.
- You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
- Unless required by applicable law or agreed to in writing, software
- distributed under the License is distributed on an "AS IS" BASIS,
- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- See the License for the specific language governing permissions and
- limitations under the License.
-*/
-
--- THIS FILE INCLUDES DEMO DATA. IT BUILDS UPON THE RECORDS INSERTED IN SEEDS.SQL
-
--- parameters (demo)
-insert into parameter (name, config_file, value) values ('tm.toolname', 'global', 'Traffic Ops') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('tm.infourl', 'global', 'http://docs.cdnl.kabletown.net/traffic_control/html/') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('tm.logourl', 'global', '/images/tc_logo.png') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('tm.instance_name', 'global', 'kabletown CDN') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('geolocation.polling.url', 'CRConfig.json', 'http://cdn-tools.cdnl.kabletown.net/cdn/MaxMind/GeoLiteCity.dat.gz') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('geolocation6.polling.url', 'CRConfig.json', 'http://cdn-tools.cdnl.kabletown.net/cdn/MaxMind/GeoLiteCityv6.dat.gz') ON CONFLICT (name, config_file, value) DO NOTHING;
-
-insert into parameter (name, config_file, value) values ('tld.soa.admin', 'CRConfig.json', 'traffic_ops') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('health.polling.interval', 'rascal-config.txt', '8000') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('health.threshold.loadavg', 'rascal.properties', '25.0') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('health.connection.timeout', 'rascal.properties', '25.0') ON CONFLICT (name, config_file, value) DO NOTHING;
-insert into parameter (name, config_file, value) values ('health.threshold.availableBandwidthInKbps', 'rascal.properties', '>1750000') ON CONFLICT (name, config_file, value) DO NOTHING;
-
--- profile_parameters (demo)
-insert into profile_parameter (profile, parameter) values ( (select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'tm.url' and config_file = 'global' and value = 'https://tm.kabletown.net/') ) ON CONFLICT (profile, parameter) DO NOTHING;
-insert into profile_parameter (profile, parameter) values ( (select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'tm.toolname' and config_file = 'global' and value = 'Traffic Ops') ) ON CONFLICT (profile, parameter) DO NOTHING;
-insert into profile_parameter (profile, parameter) values ( (select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'tm.infourl' and config_file = 'global' and value = 'http://docs.cdnl.kabletown.net/traffic_control/html/') ) ON CONFLICT (profile, parameter) DO NOTHING;
-insert into profile_parameter (profile, parameter) values ( (select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'tm.logourl' and config_file = 'global' and value = '/images/tc_logo.png') ) ON CONFLICT (profile, parameter) DO NOTHING;
-insert into profile_parameter (profile, parameter) values ( (select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'tm.instance_name' and config_file = 'global' and value = 'kabletown CDN') ) ON CONFLICT (profile, parameter) DO NOTHING;
-insert into profile_parameter (profile, parameter) values ( (select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'geolocation.polling.url' and config_file = 'CRConfig.json' and value = 'http://cdn-tools.cdnl.kabletown.net/cdn/MaxMind/GeoLiteCity.dat.gz') ) ON CONFLICT (profile, parameter) DO NOTHING;
-insert into profile_parameter (profile, parameter) values ( (select id from profile where name = 'GLOBAL'), (select id from parameter where name = 'geolocation6.polling.url' and config_file = 'CRConfig.json' and value = 'http://cdn-tools.cdnl.kabletown.net/cdn/MaxMind/GeoLiteCityv6.dat.gz') ) ON CONFLICT (profile, parameter) DO NOTHING;