java/code
by Tomáš Kašpárek
java/code/src/com/redhat/rhn/frontend/taglibs/list/CSVTag.java | 6 ++++++
1 file changed, 6 insertions(+)
New commits:
commit 525a33b8b1a6957d5fe754d85f9a8cbbdaa6fc5e
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Tue May 28 12:59:48 2013 +0200
960885 - add list elaborator into session for CSV export
in some cases list for CSV export was missing an elaborator for restarting query
that caused that the exported was done without elaborated data
diff --git a/java/code/src/com/redhat/rhn/frontend/taglibs/list/CSVTag.java b/java/code/src/com/redhat/rhn/frontend/taglibs/list/CSVTag.java
index eeeb50f..fca7225 100644
--- a/java/code/src/com/redhat/rhn/frontend/taglibs/list/CSVTag.java
+++ b/java/code/src/com/redhat/rhn/frontend/taglibs/list/CSVTag.java
@@ -243,6 +243,12 @@ public class CSVTag extends BodyTagSupport {
*/
String paramQuery = "query_" + getUniqueName();
session.setAttribute(paramQuery, ((DataResult)pageData).getMode().getQuery());
+ /* in some cases session does not contain elabotor for actual tag
+ * so it's better to add it into session so we can elaborate for data
+ * bug: 960885
+ */
+ session.setAttribute("list_" + getUniqueName() + TagHelper.ELAB_TAG,
+ ((DataResult)pageData).getElaborator());
return CSVDownloadAction.QUERY_DATA + "=" + paramQuery;
}
String paramPageList = "pageList_" + getUniqueName();
10 years, 11 months
Changes to 'refs/tags/spacewalk-backend-1.10.38-1'
by Michael Mraka
Tag 'spacewalk-backend-1.10.38-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2013-05-27 13:51 +0000
Tagging package [spacewalk-backend] version [1.10.38-1] in directory [backend/].
Changes since spacewalk-schema-1.10.39-1:
Michael Mraka (2):
pack backend_checker into rpm
Automatic commit of package [spacewalk-backend] release [1.10.38-1].
---
backend/server/importlib/Makefile | 2 +-
backend/spacewalk-backend.spec | 5 ++++-
rel-eng/packages/spacewalk-backend | 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
---
10 years, 11 months
2 commits - backend/server backend/spacewalk-backend.spec rel-eng/packages
by Michael Mraka
backend/server/importlib/Makefile | 2 +-
backend/spacewalk-backend.spec | 5 ++++-
rel-eng/packages/spacewalk-backend | 2 +-
3 files changed, 6 insertions(+), 3 deletions(-)
New commits:
commit 1ac8c394aef93df5a9f76db437ff23862fe80603
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 15:51:06 2013 +0200
Automatic commit of package [spacewalk-backend] release [1.10.38-1].
diff --git a/backend/spacewalk-backend.spec b/backend/spacewalk-backend.spec
index 3fcc7a7..58912a6 100644
--- a/backend/spacewalk-backend.spec
+++ b/backend/spacewalk-backend.spec
@@ -12,7 +12,7 @@ Name: spacewalk-backend
Summary: Common programs needed to be installed on the Spacewalk servers/proxies
Group: Applications/Internet
License: GPLv2
-Version: 1.10.37
+Version: 1.10.38
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -638,6 +638,9 @@ rm -f %{rhnconf}/rhnSecret.py*
# $Id$
%changelog
+* Mon May 27 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.38-1
+- pack backend_checker into rpm
+
* Mon May 27 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.37-1
- update copyright column length
- script to backendOracle.py definitions vs. database
diff --git a/rel-eng/packages/spacewalk-backend b/rel-eng/packages/spacewalk-backend
index 1b2bfd9..ff17021 100644
--- a/rel-eng/packages/spacewalk-backend
+++ b/rel-eng/packages/spacewalk-backend
@@ -1 +1 @@
-1.10.37-1 backend/
+1.10.38-1 backend/
commit a17e1e2818a89f01c7fb00dfa8bf3f7bc24e4dab
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 15:48:32 2013 +0200
pack backend_checker into rpm
diff --git a/backend/server/importlib/Makefile b/backend/server/importlib/Makefile
index f6e110d..865b278 100644
--- a/backend/server/importlib/Makefile
+++ b/backend/server/importlib/Makefile
@@ -6,7 +6,7 @@ TOP = ../..
SUBDIR = server/importlib
-SPACEWALK_FILES = __init__ archImport backendLib backendOracle backend \
+SPACEWALK_FILES = __init__ archImport backendLib backendOracle backend backend_checker \
channelImport debPackage errataCache errataImport headerSource importLib \
kickstartImport mpmSource \
packageImport productNamesImport packageUpload userAuth
10 years, 11 months
Changes to 'refs/tags/spacewalk-schema-1.10.39-1'
by Michael Mraka
Tag 'spacewalk-schema-1.10.39-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2013-05-27 13:25 +0000
Tagging package [spacewalk-schema] version [1.10.39-1] in directory [schema/spacewalk/].
Changes since spacewalk-backend-1.10.37-1:
Michael Mraka (1):
Automatic commit of package [spacewalk-schema] release [1.10.39-1].
---
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
2 files changed, 5 insertions(+), 2 deletions(-)
---
10 years, 11 months
rel-eng/packages schema/spacewalk
by Michael Mraka
rel-eng/packages/spacewalk-schema | 2 +-
schema/spacewalk/spacewalk-schema.spec | 5 ++++-
2 files changed, 5 insertions(+), 2 deletions(-)
New commits:
commit 080dc9a73fdf19b9085d3bf00b3c28af2086cf2b
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 15:25:05 2013 +0200
Automatic commit of package [spacewalk-schema] release [1.10.39-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index 2678efb..82c2d6f 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.10.38-1 schema/spacewalk/
+1.10.39-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index 52b3f2a..5ac46ec 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -4,7 +4,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.10.38
+Version: 1.10.39
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Mon May 27 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.39-1
+- show data_length for varchar columns
+
* Mon May 27 2013 Milan Zazrivec <mzazrivec(a)redhat.com> 1.10.38-1
- split the upgrade script for oracle and postgresql
10 years, 11 months
Changes to 'refs/tags/spacewalk-backend-1.10.37-1'
by Michael Mraka
Tag 'spacewalk-backend-1.10.37-1' created by Michael Mraka <michael.mraka(a)redhat.com> at 2013-05-27 13:21 +0000
Tagging package [spacewalk-backend] version [1.10.37-1] in directory [backend/].
Changes since spacewalk-schema-1.10.38-1:
Michael Mraka (6):
962683 - don't truncate channel name to 64 chars
show data_length for varchar columns
script to backendOracle.py definitions vs. database
update copyright column length
added backend_checker to spec
Automatic commit of package [spacewalk-backend] release [1.10.37-1].
---
backend/server/importlib/backendOracle.py | 4 -
backend/server/importlib/backend_checker.py | 32 ++++++++++
backend/spacewalk-backend.spec | 10 ++-
rel-eng/packages/spacewalk-backend | 2
schema/spacewalk/postgres/views/all_tab_columns.sql | 1
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.postgresql | 15 ++++
7 files changed, 61 insertions(+), 4 deletions(-)
---
10 years, 11 months
6 commits - backend/server backend/spacewalk-backend.spec rel-eng/packages schema/spacewalk
by Michael Mraka
backend/server/importlib/backendOracle.py | 4 -
backend/server/importlib/backend_checker.py | 32 ++++++++++
backend/spacewalk-backend.spec | 10 ++-
rel-eng/packages/spacewalk-backend | 2
schema/spacewalk/postgres/views/all_tab_columns.sql | 1
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.oracle | 1
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.postgresql | 15 ++++
7 files changed, 61 insertions(+), 4 deletions(-)
New commits:
commit 2a5a32c2c4c34e54df8df0ef8ff9128072e09cf9
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 15:21:06 2013 +0200
Automatic commit of package [spacewalk-backend] release [1.10.37-1].
diff --git a/backend/spacewalk-backend.spec b/backend/spacewalk-backend.spec
index 6a36847..3fcc7a7 100644
--- a/backend/spacewalk-backend.spec
+++ b/backend/spacewalk-backend.spec
@@ -12,7 +12,7 @@ Name: spacewalk-backend
Summary: Common programs needed to be installed on the Spacewalk servers/proxies
Group: Applications/Internet
License: GPLv2
-Version: 1.10.36
+Version: 1.10.37
Release: 1%{?dist}
URL: https://fedorahosted.org/spacewalk
Source0: https://fedorahosted.org/releases/s/p/spacewalk/%{name}-%{version}.tar.gz
@@ -638,6 +638,13 @@ rm -f %{rhnconf}/rhnSecret.py*
# $Id$
%changelog
+* Mon May 27 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.37-1
+- update copyright column length
+- script to backendOracle.py definitions vs. database
+- 962683 - don't truncate channel name to 64 chars
+- Backend handlers for receiving full SCAP results
+- Challenge clients to upload result files from the audit
+
* Wed May 22 2013 Michael Mraka <michael.mraka(a)redhat.com> 1.10.36-1
- 950198 - make API compatible with old RHEL5 clients
- man pages branding cleanup + misc branding fixes
diff --git a/rel-eng/packages/spacewalk-backend b/rel-eng/packages/spacewalk-backend
index f47390a..1b2bfd9 100644
--- a/rel-eng/packages/spacewalk-backend
+++ b/rel-eng/packages/spacewalk-backend
@@ -1 +1 @@
-1.10.36-1 backend/
+1.10.37-1 backend/
commit f92c9693cd3ab3e3b6ff39302c84250cbe37619a
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 15:20:29 2013 +0200
added backend_checker to spec
diff --git a/backend/spacewalk-backend.spec b/backend/spacewalk-backend.spec
index 0dfd6f9..6a36847 100644
--- a/backend/spacewalk-backend.spec
+++ b/backend/spacewalk-backend.spec
@@ -409,6 +409,7 @@ rm -f %{rhnconf}/rhnSecret.py*
%{pythonrhnroot}/server/importlib/backend.py*
%{pythonrhnroot}/server/importlib/backendLib.py*
%{pythonrhnroot}/server/importlib/backendOracle.py*
+%{pythonrhnroot}/server/importlib/backend_checker.py*
%{pythonrhnroot}/server/importlib/channelImport.py*
%{pythonrhnroot}/server/importlib/debPackage.py*
%{pythonrhnroot}/server/importlib/errataCache.py*
commit d3fb4672dd72abea97a0eb1f6281f44d8a746e7b
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 15:18:42 2013 +0200
update copyright column length
diff --git a/backend/server/importlib/backendOracle.py b/backend/server/importlib/backendOracle.py
index b011feb..96be1e1 100644
--- a/backend/server/importlib/backendOracle.py
+++ b/backend/server/importlib/backendOracle.py
@@ -164,7 +164,7 @@ class OracleBackend(Backend):
'vendor' : DBstring(64),
'payload_format': DBstring(32),
'path' : DBstring(1000),
- 'copyright' : DBstring(64),
+ 'copyright' : DBstring(128),
'cookie' : DBstring(128),
'header_start' : DBint(),
'header_end' : DBint(),
commit fb19552c344e543357f00ee88853de886f97b6f9
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 15:16:52 2013 +0200
script to backendOracle.py definitions vs. database
diff --git a/backend/server/importlib/backend_checker.py b/backend/server/importlib/backend_checker.py
new file mode 100755
index 0000000..e17d75a
--- /dev/null
+++ b/backend/server/importlib/backend_checker.py
@@ -0,0 +1,32 @@
+#!/usr/bin/python
+
+import sys
+from spacewalk.server import rhnSQL
+from spacewalk.server.importlib import backendOracle
+from spacewalk.server.importlib.backendLib import DBint, DBstring, DBdateTime, DBblob, Table, TableCollection
+
+exitval = 0
+
+rhnSQL.initDB()
+q = rhnSQL.prepare("""select data_length
+ from all_tab_columns
+ where upper(table_name) = upper(:tname)
+ and upper(column_name) = upper(:cname)""")
+
+backend = backendOracle.PostgresqlBackend()
+
+for tn, tc in backend.tables.items():
+ for cn, cv in tc.getFields().items():
+ if isinstance(cv, DBstring):
+ q.execute(tname=tn, cname=cn)
+ row = q.fetchone_dict()
+ if not row or row['data_length'] != cv.limit:
+ print ("ERROR: database column %s.%s is %s chars long "
+ + "but defined as %s chars in backendOracle.py") % (
+ tn, cn, row['data_length'], cv.limit)
+ exitval = 1
+ else:
+ print "%s.%s = %d" % (tn, cn, row['data_length'])
+
+sys.exit(exitval);
+
commit b92a2f55a32f984b34b72dfca4c1222c2e44a4a9
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 14:25:30 2013 +0200
show data_length for varchar columns
diff --git a/schema/spacewalk/postgres/views/all_tab_columns.sql b/schema/spacewalk/postgres/views/all_tab_columns.sql
index cac3b37..8a26fd2 100644
--- a/schema/spacewalk/postgres/views/all_tab_columns.sql
+++ b/schema/spacewalk/postgres/views/all_tab_columns.sql
@@ -8,5 +8,6 @@ select
ordinal_position as column_id,
data_type as data_type,
numeric_precision as data_precision,
+ character_maximum_length as data_length,
substr(is_nullable,1,1) as nullable
from information_schema.columns;
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.postgresql
new file mode 100644
index 0000000..e768123
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/018-all_tab_columns.sql.postgresql
@@ -0,0 +1,15 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+drop view all_tab_columns;
+
+create or replace view all_tab_columns
+as
+select
+ table_name as table_name,
+ column_name as column_name,
+ ordinal_position as column_id,
+ data_type as data_type,
+ numeric_precision as data_precision,
+ character_maximum_length as data_length,
+ substr(is_nullable,1,1) as nullable
+from information_schema.columns;
commit a0aa3f1e3ff9666e41cf97045050a5088cc3cfd5
Author: Michael Mraka <michael.mraka(a)redhat.com>
Date: Mon May 27 14:17:16 2013 +0200
962683 - don't truncate channel name to 64 chars
diff --git a/backend/server/importlib/backendOracle.py b/backend/server/importlib/backendOracle.py
index 5ec52ae..b011feb 100644
--- a/backend/server/importlib/backendOracle.py
+++ b/backend/server/importlib/backendOracle.py
@@ -314,7 +314,7 @@ class OracleBackend(Backend):
'channel_arch_id': DBint(),
'label' : DBstring(128),
'basedir' : DBstring(256),
- 'name' : DBstring(64),
+ 'name' : DBstring(256),
'summary' : DBstring(500),
'description' : DBstring(4000),
'product_name_id' : DBint(),
10 years, 11 months
Changes to 'refs/tags/spacewalk-schema-1.10.38-1'
by Milan Zazrivec
Tag 'spacewalk-schema-1.10.38-1' created by Milan Zazrivec <mzazrivec(a)redhat.com> at 2013-05-27 09:49 +0000
Tagging package [spacewalk-schema] version [1.10.38-1] in directory [schema/spacewalk/].
Changes since spacewalk-reports-1.10.6-1:
Milan Zazrivec (2):
split the upgrade script for oracle and postgresql
Automatic commit of package [spacewalk-schema] release [1.10.38-1].
---
rel-eng/packages/spacewalk-schema | 2
schema/spacewalk/spacewalk-schema.spec | 5 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql | 29 ----------
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle | 29 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql | 9 +++
5 files changed, 43 insertions(+), 31 deletions(-)
---
10 years, 11 months
2 commits - rel-eng/packages schema/spacewalk
by Milan Zazrivec
rel-eng/packages/spacewalk-schema | 2
schema/spacewalk/spacewalk-schema.spec | 5 +
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql | 29 ----------
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle | 29 ++++++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql | 9 +++
5 files changed, 43 insertions(+), 31 deletions(-)
New commits:
commit 5feb47a4a936ac85a78500650897e3070fcb4f13
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Mon May 27 11:49:40 2013 +0200
Automatic commit of package [spacewalk-schema] release [1.10.38-1].
diff --git a/rel-eng/packages/spacewalk-schema b/rel-eng/packages/spacewalk-schema
index d32a1e2..2678efb 100644
--- a/rel-eng/packages/spacewalk-schema
+++ b/rel-eng/packages/spacewalk-schema
@@ -1 +1 @@
-1.10.37-1 schema/spacewalk/
+1.10.38-1 schema/spacewalk/
diff --git a/schema/spacewalk/spacewalk-schema.spec b/schema/spacewalk/spacewalk-schema.spec
index fc85653..52b3f2a 100644
--- a/schema/spacewalk/spacewalk-schema.spec
+++ b/schema/spacewalk/spacewalk-schema.spec
@@ -4,7 +4,7 @@ Name: spacewalk-schema
Group: Applications/Internet
Summary: Oracle SQL schema for Spacewalk server
-Version: 1.10.37
+Version: 1.10.38
Release: 1%{?dist}
Source0: %{name}-%{version}.tar.gz
@@ -71,6 +71,9 @@ rm -rf $RPM_BUILD_ROOT
%{_mandir}/man1/spacewalk-sql*
%changelog
+* Mon May 27 2013 Milan Zazrivec <mzazrivec(a)redhat.com> 1.10.38-1
+- split the upgrade script for oracle and postgresql
+
* Thu May 23 2013 Milan Zazrivec <mzazrivec(a)redhat.com> 1.10.37-1
- Don't create index if it already exists
- Don't drop rhn_ram_sid_idx if it does not exist.
commit 0652cdbbd31e4f7224a6f962ff232dea2a409180
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Mon May 27 11:45:48 2013 +0200
split the upgrade script for oracle and postgresql
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql
deleted file mode 100644
index 18a9522..0000000
--- a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-delete from rhnram X
- where server_id in (select server_id from rhnram group by server_id having count(server_id)>1)
- and id<(select max(id) from rhnram Y where X.server_id=Y.server_id group by server_id having count(server_id)>1);
-
-set serverout on;
-
-declare
- non_existent_index exception;
- pragma exception_init(non_existent_index, -01418);
-begin
- execute immediate 'drop index rhn_ram_sid_idx';
- dbms_output.put_line('Index rhn_ram_sid_idx successfully dropped.');
-exception
- when non_existent_index then
- null;
-end;
-/
-
-declare
- name_already_used exception;
- pragma exception_init(name_already_used, -00955);
-begin
- execute immediate 'create unique index rhn_ram_sid_uq on rhnRam(server_id) tablespace [[4m_tbs]] nologging';
- dbms_output.put_line('Index rhn_ram_sid_uq successfully created.');
-exception
- when name_already_used then
- dbms_output.put_line('Index rhn_ram_sid_uq already exists.');
-end;
-/
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle
new file mode 100644
index 0000000..18a9522
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle
@@ -0,0 +1,29 @@
+delete from rhnram X
+ where server_id in (select server_id from rhnram group by server_id having count(server_id)>1)
+ and id<(select max(id) from rhnram Y where X.server_id=Y.server_id group by server_id having count(server_id)>1);
+
+set serverout on;
+
+declare
+ non_existent_index exception;
+ pragma exception_init(non_existent_index, -01418);
+begin
+ execute immediate 'drop index rhn_ram_sid_idx';
+ dbms_output.put_line('Index rhn_ram_sid_idx successfully dropped.');
+exception
+ when non_existent_index then
+ null;
+end;
+/
+
+declare
+ name_already_used exception;
+ pragma exception_init(name_already_used, -00955);
+begin
+ execute immediate 'create unique index rhn_ram_sid_uq on rhnRam(server_id) tablespace [[4m_tbs]] nologging';
+ dbms_output.put_line('Index rhn_ram_sid_uq successfully created.');
+exception
+ when name_already_used then
+ dbms_output.put_line('Index rhn_ram_sid_uq already exists.');
+end;
+/
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql
new file mode 100644
index 0000000..3018a09
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql
@@ -0,0 +1,9 @@
+-- oracle equivalent source sha1 5382865750405facc547315329a739b8ee1fe238
+
+delete from rhnram X
+ where server_id in (select server_id from rhnram group by server_id having count(server_id)>1)
+ and id<(select max(id) from rhnram Y where X.server_id=Y.server_id group by server_id having count(server_id)>1);
+
+drop index rhn_ram_sid_idx;
+
+create unique index rhn_ram_sid_uq on rhnRam(server_id);
10 years, 11 months
Changes to 'refs/tags/spacewalk-reports-1.10.6-1'
by StephenHerr
Tag 'spacewalk-reports-1.10.6-1' created by Stephen Herr <sherr(a)redhat.com> at 2013-05-24 19:25 +0000
Tagging package [spacewalk-reports] version [1.10.6-1] in directory [reporting/].
Changes since spacewalk-java-1.10.81-1:
Christopher Duryee (1):
Report for host-guest mappings for splice integration
James Slagle (1):
Reports to support enhanced reporting
Stephen Herr (1):
Automatic commit of package [spacewalk-reports] release [1.10.6-1].
---
rel-eng/packages/spacewalk-reports | 2
reporting/reports/data/cloned-channels | 27 +++++++
reporting/reports/data/host-guests | 26 ++++++
reporting/reports/data/splice-export | 124 +++++++++++++++++++++++++++++++++
reporting/spacewalk-reports.spec | 6 +
5 files changed, 183 insertions(+), 2 deletions(-)
---
10 years, 11 months