schema/spacewalk/oracle/packages/packages.deps
| 2
schema/spacewalk/oracle/packages/rhn_package.pkb
| 63 ----------
schema/spacewalk/oracle/packages/rhn_package.pks
| 45 -------
schema/spacewalk/postgres/packages/packages.deps
| 2
schema/spacewalk/postgres/packages/rhn_package.pkb
| 56 --------
schema/spacewalk/postgres/packages/rhn_package.pks
| 44 ------
schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/005-rhn_package-drop.sql
| 4
spacewalk/setup/lib/Spacewalk/Setup.pm
| 1
8 files changed, 4 insertions(+), 213 deletions(-)
New commits:
commit 45c4f03e9efcabebbe8e63510657c7c2acbdeded
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Dec 23 13:52:35 2010 +0100
The rhn_package package (schema in PostgreSQL) is now gone.
diff --git a/spacewalk/setup/lib/Spacewalk/Setup.pm
b/spacewalk/setup/lib/Spacewalk/Setup.pm
index ab46c89..467b245 100644
--- a/spacewalk/setup/lib/Spacewalk/Setup.pm
+++ b/spacewalk/setup/lib/Spacewalk/Setup.pm
@@ -867,7 +867,6 @@ my $POSTGRESQL_CLEAR_SCHEMA = <<EOS;
drop schema rhn_channel cascade ;
drop schema rhn_config_channel cascade ;
drop schema rhn_org cascade ;
- drop schema rhn_package cascade ;
drop schema rhn_user cascade ;
drop schema public cascade ;
create schema public authorization postgres ;
commit ee9d553078ab707393636437305e2ea75c52c16b
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Thu Dec 23 13:51:11 2010 +0100
The rhn_package database package is not used, removing.
It was last used by rhnOrgPackageOverview whic we dropped for
Spacewalk 1.2.
diff --git a/schema/spacewalk/oracle/packages/packages.deps
b/schema/spacewalk/oracle/packages/packages.deps
index d8c619a..c519192 100644
--- a/schema/spacewalk/oracle/packages/packages.deps
+++ b/schema/spacewalk/oracle/packages/packages.deps
@@ -57,8 +57,6 @@ rhn_org.pkb :: rhn_entitlements.pks \
rhn_probe rhn_redirects rhn_sat_cluster \
web_contact web_customer
rhn_org.pks :: rhnServerGroupType rhnServerGroup
-rhn_package.pkb :: rhnChannel rhnChannelPackage
-rhn_package.pks :: rhnChannel rhnChannelPackage
rhn_quota.pkb :: rhnConfigContent rhnConfigRevision rhnConfigFile \
rhnConfigChannel rhnOrgQuota rhn_config.pks
rhn_server.pkb :: rhnServerChannel rhnConfigFileName \
diff --git a/schema/spacewalk/oracle/packages/rhn_package.pkb
b/schema/spacewalk/oracle/packages/rhn_package.pkb
deleted file mode 100644
index 1f38e1d..0000000
--- a/schema/spacewalk/oracle/packages/rhn_package.pkb
+++ /dev/null
@@ -1,63 +0,0 @@
---
--- Copyright (c) 2008 Red Hat, Inc.
---
--- This software is licensed to you under the GNU General Public License,
--- version 2 (GPLv2). There is NO WARRANTY for this software, express or
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
---
---
---
-
-CREATE OR REPLACE
-PACKAGE BODY rhn_package
-IS
- FUNCTION canonical_name(name_in IN VARCHAR2, evr_in IN EVR_T,
- arch_in IN VARCHAR2)
- RETURN VARCHAR2
- IS
- name_out VARCHAR2(256);
- BEGIN
- name_out := name_in || '-' || evr_in.as_vre_simple();
-
- IF arch_in IS NOT NULL
- THEN
- name_out := name_out || '-' || arch_in;
- END IF;
-
- RETURN name_out;
- END canonical_name;
-
- FUNCTION channel_occupancy_string(package_id_in IN NUMBER, separator_in VARCHAR2 :=
', ')
- RETURN VARCHAR2
- IS
- list_out VARCHAR2(4000);
- BEGIN
- FOR channel IN channel_occupancy_cursor(package_id_in)
- LOOP
- IF list_out IS NULL
- THEN
- list_out := channel.channel_name;
- ELSE
- list_out := channel.channel_name || separator_in || list_out;
- END IF;
- END LOOP;
-
- RETURN list_out;
- END channel_occupancy_string;
-
-END rhn_package;
-/
-SHOW ERRORS
-
---
--- Revision 1.3 2002/05/10 22:08:23 pjones
--- id/log
---
diff --git a/schema/spacewalk/oracle/packages/rhn_package.pks
b/schema/spacewalk/oracle/packages/rhn_package.pks
deleted file mode 100644
index d47ce8c..0000000
--- a/schema/spacewalk/oracle/packages/rhn_package.pks
+++ /dev/null
@@ -1,45 +0,0 @@
---
--- Copyright (c) 2008 Red Hat, Inc.
---
--- This software is licensed to you under the GNU General Public License,
--- version 2 (GPLv2). There is NO WARRANTY for this software, express or
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
---
---
---
---
-
-CREATE OR REPLACE
-PACKAGE rhn_package
-IS
- CURSOR channel_occupancy_cursor(package_id_in IN NUMBER) IS
- SELECT C.id channel_id, C.name channel_name
- FROM rhnChannel C,
- rhnChannelPackage CP
- WHERE C.id = CP.channel_id
- AND CP.package_id = package_id_in
- ORDER BY C.name DESC;
-
- FUNCTION canonical_name(name_in IN VARCHAR2, evr_in IN EVR_T,
- arch_in IN VARCHAR2 := NULL)
- RETURN VARCHAR2
- DETERMINISTIC;
-
- FUNCTION channel_occupancy_string(package_id_in IN NUMBER, separator_in VARCHAR2 :=
', ')
- RETURN VARCHAR2;
-
-END rhn_package;
-/
-SHOW ERRORS
-
---
--- Revision 1.3 2002/05/10 22:08:23 pjones
--- id/log
---
diff --git a/schema/spacewalk/postgres/packages/packages.deps
b/schema/spacewalk/postgres/packages/packages.deps
index 40d3401..59f9820 100644
--- a/schema/spacewalk/postgres/packages/packages.deps
+++ b/schema/spacewalk/postgres/packages/packages.deps
@@ -55,8 +55,6 @@ rhn_org.pkb :: rhn_entitlements.pks \
rhn_probe rhn_redirects rhn_sat_cluster \
web_contact web_customer
rhn_org.pks :: rhnServerGroupType rhnServerGroup
-rhn_package.pkb :: rhnChannel rhnChannelPackage
-rhn_package.pks :: rhnChannel rhnChannelPackage
rhn_quota.pkb :: rhnConfigContent rhnConfigRevision rhnConfigFile \
rhnConfigChannel rhnOrgQuota rhn_config.pks
rhn_server.pkb :: rhnServerChannel rhnConfigFileName \
diff --git a/schema/spacewalk/postgres/packages/rhn_package.pkb
b/schema/spacewalk/postgres/packages/rhn_package.pkb
deleted file mode 100644
index ce110bd..0000000
--- a/schema/spacewalk/postgres/packages/rhn_package.pkb
+++ /dev/null
@@ -1,56 +0,0 @@
-
--- create schema rhn_package;
-
---update pg_setting
-update pg_settings set setting = 'rhn_package,' || setting where name =
'search_path';
-
-
-create or replace FUNCTION canonical_name(name_in IN VARCHAR, evr_in IN EVR_T,
- arch_in IN VARCHAR DEFAULT NULL)
- RETURNS VARCHAR as $$
- declare
- name_out VARCHAR(256);
-
- BEGIN
- name_out := name_in || '-' || evr_t_as_vre_simple(evr_in);
-
- IF arch_in <> ''
- THEN
- name_out := name_out || '-' || arch_in;
- END IF;
-
- RETURN name_out;
- END ;
- $$ language 'plpgsql';
-
-
-create or replace FUNCTION channel_occupancy_string(package_id_in IN NUMERIC,
separator_in VARCHAR DEFAULT ', ')
- RETURNS VARCHAR as $$
- declare
- list_out VARCHAR(4000);
- channel_occupancy_cursor CURSOR (package_id_in numeric) for
- SELECT C.id AS channel_id, C.name AS channel_name
- FROM rhnChannel C,
- rhnChannelPackage CP
- WHERE C.id = CP.channel_id
- AND CP.package_id = package_id_in
- ORDER BY C.name DESC;
- BEGIN
- FOR channel IN channel_occupancy_cursor(package_id_in)
- LOOP
- IF list_out IS NULL
- THEN
- list_out := channel.channel_name;
- ELSE
- list_out := channel.channel_name || separator_in || list_out;
- END IF;
- END LOOP;
-
- RETURN list_out;
- END ;
- $$ language 'plpgsql';
-
--- restore the original setting
-update pg_settings set setting = overlay( setting placing '' from 1 for
(length('rhn_package')+1) ) where name = 'search_path';
-
-
diff --git a/schema/spacewalk/postgres/packages/rhn_package.pks
b/schema/spacewalk/postgres/packages/rhn_package.pks
deleted file mode 100644
index 7676c7f..0000000
--- a/schema/spacewalk/postgres/packages/rhn_package.pks
+++ /dev/null
@@ -1,44 +0,0 @@
---
--- Copyright (c) 2008 Red Hat, Inc.
---
--- This software is licensed to you under the GNU General Public License,
--- version 2 (GPLv2). There is NO WARRANTY for this software, express or
--- implied, including the implied warranties of MERCHANTABILITY or FITNESS
--- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
--- along with this software; if not, see
---
http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
---
--- Red Hat trademarks are not licensed under GPLv2. No permission is
--- granted to use or replicate Red Hat trademarks that are incorporated
--- in this software or its documentation.
-
-create schema rhn_package;
-
---update pg_setting
-update pg_settings set setting = 'rhn_package,' || setting where name =
'search_path';
-
-create or replace FUNCTION canonical_name
-(
- name_in IN VARCHAR,
- evr_in IN EVR_T,
- arch_in IN VARCHAR DEFAULT NULL
-)
-RETURNS VARCHAR
-AS $$
-BEGIN
- RAISE EXCEPTION 'Stub called, must be replaced by .pkb';
-END;
-$$
-language 'plpgsql';
-
-
-create or replace FUNCTION channel_occupancy_string(package_id_in IN NUMERIC,
separator_in VARCHAR DEFAULT ', ')
-RETURNS VARCHAR
-AS $$
-BEGIN
- RAISE EXCEPTION 'Stub called, must be replaced by .pkb';
-END;
-$$ language 'plpgsql';
-
--- restore the original setting
-update pg_settings set setting = overlay( setting placing '' from 1 for
(length('rhn_package')+1) ) where name = 'search_path';
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/005-rhn_package-drop.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/005-rhn_package-drop.sql
new file mode 100644
index 0000000..1b73dd5
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.2-to-spacewalk-schema-1.3/005-rhn_package-drop.sql
@@ -0,0 +1,4 @@
+
+drop package body rhn_package;
+drop package rhn_package;
+