You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafficcontrol.apache.org by de...@apache.org on 2017/03/29 23:07:38 UTC
[3/4] incubator-trafficcontrol git commit: delete unneeded resultset
delete unneeded resultset
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/commit/2e274e19
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/tree/2e274e19
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/diff/2e274e19
Branch: refs/heads/master
Commit: 2e274e19e216dcc53b1b8595134b2177f78ebdfd
Parents: 6ea430e
Author: Derek Gelinas <de...@cable.comcast.com>
Authored: Mon Mar 20 14:25:34 2017 -0400
Committer: Dewayne Richardson <de...@apache.org>
Committed: Wed Mar 29 17:07:27 2017 -0600
----------------------------------------------------------------------
.../Result/DeliveryServiceInfoForCdnList.pm | 103 -------------------
1 file changed, 103 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafficcontrol/blob/2e274e19/traffic_ops/app/lib/Schema/Result/DeliveryServiceInfoForCdnList.pm
----------------------------------------------------------------------
diff --git a/traffic_ops/app/lib/Schema/Result/DeliveryServiceInfoForCdnList.pm b/traffic_ops/app/lib/Schema/Result/DeliveryServiceInfoForCdnList.pm
deleted file mode 100644
index 1e59d83..0000000
--- a/traffic_ops/app/lib/Schema/Result/DeliveryServiceInfoForCdnList.pm
+++ /dev/null
@@ -1,103 +0,0 @@
-use utf8;
-
-#
-#
-# 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.
-#
-#
-#
-
-package Schema::Result::DeliveryServiceInfoForCdnList;
-
-# this view returns the regexp set for a delivery services, ordered by type, set_number.
-# to use, do
-#
-# $rs = $self->db->resultset('DeliveryServiceInfoForDomainList')->search({}, { bind => [ $domain ]});
-#
-# where $id is the deliveryservice id.
-
-use strict;
-use warnings;
-
-use base 'DBIx::Class::Core';
-
-__PACKAGE__->table_class('DBIx::Class::ResultSource::View');
-
-__PACKAGE__->table("DeliveryServiceInfoForCdnList:");
-
-__PACKAGE__->result_source_instance->is_virtual(1);
-
-__PACKAGE__->result_source_instance->view_definition( "
-SELECT
- deliveryservice.xml_id,
- deliveryservice.id AS ds_id,
- deliveryservice.dscp,
- deliveryservice.signed,
- deliveryservice.qstring_ignore,
- deliveryservice.org_server_fqdn,
- deliveryservice.multi_site_origin,
- deliveryservice.range_request_handling,
- deliveryservice.origin_shield,
- regex.pattern,
- retype.name AS re_type,
- dstype.name AS ds_type,
- cdn.name AS domain_name,
- deliveryservice_regex.set_number,
- deliveryservice.edge_header_rewrite,
- deliveryservice.mid_header_rewrite,
- deliveryservice.regex_remap,
- deliveryservice.cacheurl,
- deliveryservice.remap_text,
- deliveryservice.protocol,
- deliveryservice.profile
-FROM
- deliveryservice
- JOIN deliveryservice_regex ON deliveryservice_regex.deliveryservice = deliveryservice.id
- JOIN regex ON deliveryservice_regex.regex = regex.id
- JOIN type as retype ON regex.type = retype.id
- JOIN type as dstype ON deliveryservice.type = dstype.id
- JOIN cdn ON cdn.id = deliveryservice.cdn_id
-WHERE
- deliveryservice.cdn_id = ?
- AND parameter.name = 'domain_name'
-ORDER BY
- ds_id,
- re_type,
- set_number"
-);
-
-__PACKAGE__->add_columns(
- "xml_id", { data_type => "varchar", is_nullable => 0, size => 45 },
- "org_server_fqdn", { data_type => "varchar", is_nullable => 0, size => 45 },
- "multi_site_origin", { data_type => "integer", is_nullable => 0 },
- "ds_id", { data_type => "integer", is_nullable => 0 },
- "dscp", { data_type => "integer", is_nullable => 0 },
- "signed", { data_type => "integer", is_nullable => 0 },
- "qstring_ignore", { data_type => "integer", is_nullable => 0 },
- "pattern", { data_type => "varchar", is_nullable => 0, size => 45 },
- "re_type", { data_type => "varchar", is_nullable => 0, size => 45 },
- "ds_type", { data_type => "varchar", is_nullable => 0, size => 45 },
- "set_number", { data_type => "integer", is_nullable => 0 },
- "domain_name", { data_type => "varchar", is_nullable => 0, size => 45 },
- "edge_header_rewrite", { data_type => "varchar", is_nullable => 0, size => 1024 },
- "mid_header_rewrite", { data_type => "varchar", is_nullable => 0, size => 1024 },
- "regex_remap", { data_type => "varchar", is_nullable => 0, size => 1024 },
- "cacheurl", { data_type => "varchar", is_nullable => 0, size => 1024 },
- "remap_text", { data_type => "varchar", is_nullable => 0, size => 2048 },
- "protocol", { data_type => "tinyint", is_nullable => 0, size => 4 },
- "range_request_handling", { data_type => "tinyint", is_nullable => 0, size => 4 },
- "origin_shield", { data_type => "varchar", is_nullable => 0, size => 1024 },
- "profile", { data_type => "integer", is_nullable => 1},
-);
-
-1;