Attachment 902169 Details for Bug 1103813 – db schema extension for armhf packages and armv6l-debian-linux architecture

[patch] db schema extension for armhf packages and armv6l-debian-linux architecture

add_debian_armhf_support_v2.patch (text/plain), 10.21 KB, created by Carsten Menzel on 2014-06-04 12:56:53 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Carsten Menzel

Created: 2014-06-04 12:56:53 UTC

Size: 10.21 KB

patch

obsolete

>From 8530c1794653d3d89d36eec3d1bde716eee32c57 Mon Sep 17 00:00:00 2001
>From: Carsten Menzel <carsten.menzel@bechtle.com>
>Date: Mon, 2 Jun 2014 17:28:49 +0200
>Subject: [PATCH 1/2] Add armhf support for "arm Debian" channel (needed for
> Raspbian for example)
>
>---
> schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql | 3 +++
> schema/spacewalk/common/data/rhnPackageArch.sql              | 2 ++
> schema/spacewalk/common/data/rhnPackageUpgradeArchCompat.sql | 3 +++
> 3 files changed, 8 insertions(+)
>
>diff --git a/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql b/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
>index 684cd64..beb3e4b 100644
>--- a/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
>+++ b/schema/spacewalk/common/data/rhnChannelPackageArchCompat.sql
>@@ -289,6 +289,9 @@ insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
> values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('arm-deb'));
> 
> insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
>+values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('armhf-deb'));
>+
>+insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
> values (LOOKUP_CHANNEL_ARCH('channel-arm-deb'), LOOKUP_PACKAGE_ARCH('src-deb'));
> 
> insert into rhnChannelPackageArchCompat (channel_arch_id, package_arch_id)
>diff --git a/schema/spacewalk/common/data/rhnPackageArch.sql b/schema/spacewalk/common/data/rhnPackageArch.sql
>index d36fc1c..2be4d76 100644
>--- a/schema/spacewalk/common/data/rhnPackageArch.sql
>+++ b/schema/spacewalk/common/data/rhnPackageArch.sql
>@@ -126,6 +126,8 @@ insert into rhnPackageArch (id, label, name, arch_type_id) values
> insert into rhnPackageArch (id, label, name, arch_type_id) values
> (sequence_nextval('rhn_package_arch_id_seq'), 'arm-deb', 'arm-deb', lookup_arch_type('deb'));
> insert into rhnPackageArch (id, label, name, arch_type_id) values
>+(sequence_nextval('rhn_package_arch_id_seq'), 'armhf-deb', 'armhf-deb', lookup_arch_type('deb'));
>+insert into rhnPackageArch (id, label, name, arch_type_id) values
> (sequence_nextval('rhn_package_arch_id_seq'), 'mips-deb', 'mips-deb', lookup_arch_type('deb'));
> insert into rhnPackageArch (id, label, name, arch_type_id) values
> (sequence_nextval('rhn_package_arch_id_seq'), 'amd64-deb', 'AMD64-deb', lookup_arch_type('deb'));
>diff --git a/schema/spacewalk/common/data/rhnPackageUpgradeArchCompat.sql b/schema/spacewalk/common/data/rhnPackageUpgradeArchCompat.sql
>index 9da33a8..9035f90 100644
>--- a/schema/spacewalk/common/data/rhnPackageUpgradeArchCompat.sql
>+++ b/schema/spacewalk/common/data/rhnPackageUpgradeArchCompat.sql
>@@ -161,6 +161,9 @@ insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_i
> insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('arm-deb'), LOOKUP_PACKAGE_ARCH('all-deb'), current_timestamp, current_timestamp);
> insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('arm-deb'), LOOKUP_PACKAGE_ARCH('arm-deb'), current_timestamp, current_timestamp);
> insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('all-deb'), LOOKUP_PACKAGE_ARCH('arm-deb'), current_timestamp, current_timestamp);
>+insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('armhf-deb'), LOOKUP_PACKAGE_ARCH('all-deb'), current_timestamp, current_timestamp);
>+insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('all-deb'), LOOKUP_PACKAGE_ARCH('armhf-deb'), current_timestamp, current_timestamp);
>+insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('armhf-deb'), LOOKUP_PACKAGE_ARCH('armhf-deb'), current_timestamp, current_timestamp);
> insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('mips-deb'), LOOKUP_PACKAGE_ARCH('all-deb'), current_timestamp, current_timestamp);
> insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('mips-deb'), LOOKUP_PACKAGE_ARCH('mips-deb'), current_timestamp, current_timestamp);
> insert into rhnPackageUpgradeArchCompat (package_arch_id, package_upgrade_arch_id, created, modified) values (LOOKUP_PACKAGE_ARCH('all-deb'), LOOKUP_PACKAGE_ARCH('mips-deb'), current_timestamp, current_timestamp);
>-- 
>1.9.3
>
>
>From 6eaba1df39d37a4c8fd9c746efe385e237568c56 Mon Sep 17 00:00:00 2001
>From: Carsten Menzel <carsten.menzel@bechtle.com>
>Date: Wed, 4 Jun 2014 14:42:35 +0200
>Subject: [PATCH 2/2] add server architecture "armv6l-debian-linux" to sql
> schema, so that raspbian machines can be registered at a spacewalk server
>
>---
> schema/spacewalk/common/data/rhnServerArch.sql           |  3 +++
> .../spacewalk/common/data/rhnServerChannelArchCompat.sql |  3 +++
> .../spacewalk/common/data/rhnServerPackageArchCompat.sql |  8 ++++++++
> .../common/data/rhnServerServerGroupArchCompat.sql       | 16 ++++++++++++++++
> 4 files changed, 30 insertions(+)
>
>diff --git a/schema/spacewalk/common/data/rhnServerArch.sql b/schema/spacewalk/common/data/rhnServerArch.sql
>index de56229..0452ab1 100644
>--- a/schema/spacewalk/common/data/rhnServerArch.sql
>+++ b/schema/spacewalk/common/data/rhnServerArch.sql
>@@ -122,6 +122,9 @@ insert into rhnServerArch (id, label, name, arch_type_id) values
> (sequence_nextval('rhn_server_arch_id_seq'), 'arm-debian-linux', 'arm Debian', lookup_arch_type('deb'));
> 
> insert into rhnServerArch (id, label, name, arch_type_id) values
>+(sequence_nextval('rhn_server_arch_id_seq'), 'armv6l-debian-linux', 'arm Debian', lookup_arch_type('deb'));
>+
>+insert into rhnServerArch (id, label, name, arch_type_id) values
> (sequence_nextval('rhn_server_arch_id_seq'), 'mips-debian-linux', 'mips Debian', lookup_arch_type('deb'));
> 
> commit;
>diff --git a/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql b/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql
>index 9762e18..26fc754 100644
>--- a/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql
>+++ b/schema/spacewalk/common/data/rhnServerChannelArchCompat.sql
>@@ -127,6 +127,9 @@ insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
> (LOOKUP_SERVER_ARCH('arm-debian-linux'), LOOKUP_CHANNEL_ARCH('channel-arm-deb'));
> 
> insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
>+(LOOKUP_SERVER_ARCH('armv6l-debian-linux'), LOOKUP_CHANNEL_ARCH('channel-arm-deb'));
>+
>+insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
> (LOOKUP_SERVER_ARCH('mips-debian-linux'), LOOKUP_CHANNEL_ARCH('channel-mips-deb'));
> 
> insert into rhnServerChannelArchCompat (server_arch_id, channel_arch_id) values
>diff --git a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
>index 8a27e1b..7d1ffa7 100644
>--- a/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
>+++ b/schema/spacewalk/common/data/rhnServerPackageArchCompat.sql
>@@ -337,6 +337,14 @@ insert into rhnServerPackageArchCompat
> 
> insert into rhnServerPackageArchCompat
> (server_arch_id, package_arch_id, preference) values
>+(LOOKUP_SERVER_ARCH('armv6l-debian-linux'), LOOKUP_PACKAGE_ARCH('armhf-deb'), 0);
>+
>+insert into rhnServerPackageArchCompat
>+(server_arch_id, package_arch_id, preference) values
>+(LOOKUP_SERVER_ARCH('armv6l-debian-linux'), LOOKUP_PACKAGE_ARCH('all-deb'), 1000);
>+
>+insert into rhnServerPackageArchCompat
>+(server_arch_id, package_arch_id, preference) values
> (LOOKUP_SERVER_ARCH('mips-debian-linux'), LOOKUP_PACKAGE_ARCH('mips-deb'), 0);
> 
> insert into rhnServerPackageArchCompat
>diff --git a/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql b/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
>index 4abc44d..03e0176 100644
>--- a/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
>+++ b/schema/spacewalk/common/data/rhnServerServerGroupArchCompat.sql
>@@ -157,6 +157,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>             lookup_sg_type('sw_mgr_entitled'));
> 
> insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>+	values (lookup_server_arch('armv6l-debian-linux'),
>+            lookup_sg_type('sw_mgr_entitled'));
>+
>+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
> 	values (lookup_server_arch('mips-debian-linux'),
>             lookup_sg_type('sw_mgr_entitled'));
> 
>@@ -297,6 +301,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>             lookup_sg_type('enterprise_entitled'));
> 
> insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>+	values (lookup_server_arch('armv6l-debian-linux'),
>+            lookup_sg_type('enterprise_entitled'));
>+
>+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
> 	values (lookup_server_arch('mips-debian-linux'),
>             lookup_sg_type('enterprise_entitled'));
> 
>@@ -453,6 +461,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>            lookup_sg_type('provisioning_entitled'));
> 
> insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>+   values (lookup_server_arch('armv6l-debian-linux'),
>+           lookup_sg_type('provisioning_entitled'));
>+
>+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>    values (lookup_server_arch('mips-debian-linux'),
>            lookup_sg_type('provisioning_entitled'));
> 
>@@ -593,6 +605,10 @@ insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>            lookup_sg_type('monitoring_entitled'));
> 
> insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>+   values (lookup_server_arch('armv6l-debian-linux'),
>+           lookup_sg_type('monitoring_entitled'));
>+
>+insert into rhnServerServerGroupArchCompat ( server_arch_id, server_group_type )
>    values (lookup_server_arch('mips-debian-linux'),
>            lookup_sg_type('monitoring_entitled'));
> 
>-- 
>1.9.3
>

Actions: View | Diff

Attachments on bug 1103813: 901486 | 902169