Hello,

Currently we have (GMT +0200) Europe (Eastern) Timezone which follows DST. But SAST doesn't follow DST. Thus there is a need to add SAST to spacewalk (and satellite). Attached the proposed patch to add SAST timezone.

Appreciate your feedback on it.

Paresh
>From 55efaa2b55b8eea6dec12baaeec9701b9ed3fc0c Mon Sep 17 00:00:00 2001
From: Paresh Mutha <pmu...@redhat.com>
Date: Tue, 30 Oct 2012 14:02:01 +0530
Subject: [PATCH] Add SAST timezone Signed-off-by: Paresh Mutha
 <pmu...@redhat.com>

---
 .../redhat/rhn/frontend/strings/database/StringResource_en_US.xml  | 7 +++++++
 schema/spacewalk/common/data/rhnTimezone.sql                       | 5 +++++
 .../144-rhnTimezone-data.sql                                       | 3 +++
 3 files changed, 15 insertions(+)
 create mode 100644 schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql

diff --git a/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml b/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml
index 019fca4..8b0b795 100644
--- a/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml
+++ b/java/code/src/com/redhat/rhn/frontend/strings/database/StringResource_en_US.xml
@@ -140,6 +140,13 @@ http://www.oasis-open.org/committees/xliff/documents/xliff-core-1.1.xsd";
         </context-group>
     </trans-unit>
 
+    <trans-unit id="Africa/Johannesburg">
+<source>(GMT+0200) South Africa (Johannesburg)</source>
+        <context-group name="ctx">
+          <context context-type="sourcefile">/rhn/account/UserDetails</context>
+        </context-group>
+    </trans-unit>
+   
     <trans-unit id="Europe/Bucharest">
 <source>(GMT+0200) Europe (Eastern)</source>
         <context-group name="ctx">
diff --git a/schema/spacewalk/common/data/rhnTimezone.sql b/schema/spacewalk/common/data/rhnTimezone.sql
index a9c1269..8304d6d 100644
--- a/schema/spacewalk/common/data/rhnTimezone.sql
+++ b/schema/spacewalk/common/data/rhnTimezone.sql
@@ -262,5 +262,10 @@ values
   (sequence_nextval('rhn_timezone_id_seq'),
    'GB-Eire', 'Ireland');
 
+insert into rhnTimezone
+  (id, olson_name, display_name)
+values
+  (sequence_nextval('rhn_timezone_id_seq'),
+   'Africa/Johannesburg', 'South Africa (Johannesburg)');
 
 commit;
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql
new file mode 100644
index 0000000..2f0894e
--- /dev/null
+++ b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/144-rhnTimezone-data.sql
@@ -0,0 +1,3 @@
+INSERT INTO rhnTimezone (id, olson_name, display_name)
+VALUES (rhn_timezone_id_seq.nextval,
+        'Africa/Johannesburg', 'South Africa (Johannesburg)');
-- 
1.7.11.7

_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel

Reply via email to