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(),