merged 1.1 branch into head

[mir.git] / source / mir / storage / DatabaseHelper.java

diff --git a/source/mir/storage/DatabaseHelper.java b/source/mir/storage/DatabaseHelper.java
new file mode 100755 (executable)
index 0000000..d77466c
--- /dev/null
+++ b/source/mir/storage/DatabaseHelper.java
@@ -0,0 +1,87 @@
+/*\r
+ * Copyright (C) 2001-2006 The Mir-coders group\r
+ *\r
+ * This file is part of Mir.\r
+ *\r
+ * Mir is free software; you can redistribute it and/or modify\r
+ * it under the terms of the GNU General Public License as published by\r
+ * the Free Software Foundation; either version 2 of the License, or\r
+ * (at your option) any later version.\r
+ *\r
+ * Mir is distributed in the hope that it will be useful,\r
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of\r
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the\r
+ * GNU General Public License for more details.\r
+ *\r
+ * You should have received a copy of the GNU General Public License\r
+ * along with Mir; if not, write to the Free Software\r
+ * Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA\r
+ *\r
+ * In addition, as a special exception, The Mir-coders gives permission to link\r
+ * the code of this program with  any library licensed under the Apache Software License,\r
+ * and distribute linked combinations including the two.  You must obey the\r
+ * GNU General Public License in all respects for all of the code used other than\r
+ * the above mentioned libraries.  If you modify this file, you may extend this\r
+ * exception to your version of the file, but you are not obligated to do so.\r
+ * If you do not wish to do so, delete this exception statement from your version.\r
+ */\r
+package mir.storage;\r
+\r
+import mir.config.MirPropertiesConfiguration;\r
+import mir.misc.StringUtil;\r
+\r
+import java.text.DateFormat;\r
+import java.text.SimpleDateFormat;\r
+import java.util.Date;\r
+import java.util.TimeZone;\r
+import java.util.GregorianCalendar;\r
+import java.util.Calendar;\r
+\r
+public class DatabaseHelper {\r
+  public static final TimeZone INTERNAL_TIMEZONE = TimeZone.getTimeZone(\r
+      MirPropertiesConfiguration.instance().getString("Mir.DefaultTimezone"));\r
+  public static final DateFormat INTERNAL_DATE_FORMAT =\r
+      new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");\r
+\r
+  private DatabaseHelper() {\r
+  }\r
+\r
+  static {\r
+    INTERNAL_DATE_FORMAT.setTimeZone(INTERNAL_TIMEZONE);\r
+  }\r
+\r
+  public static String convertDateToInternalRepresenation(Date aDate) {\r
+    Calendar calendar = new GregorianCalendar();\r
+    calendar.setTime(aDate);\r
+    calendar.setTimeZone(INTERNAL_TIMEZONE);\r
+    int offset = calendar.get(Calendar.ZONE_OFFSET);\r
+    boolean positive = true;\r
+    if (offset<0) {\r
+      positive=false;\r
+      offset = -offset;\r
+    }\r
+    int offsethours = offset / (60*60*1000);\r
+\r
+    return INTERNAL_DATE_FORMAT.format(aDate) + (positive?"+":"-") +\r
+        StringUtil.zeroPaddingNumber((long) offsethours, 2, 2);\r
+  }\r
+\r
+  public static String getInternalTimeZoneOffset(Date aDate) {\r
+    Calendar calendar = new GregorianCalendar();\r
+    calendar.setTime(aDate);\r
+    calendar.setTimeZone(INTERNAL_TIMEZONE);\r
+\r
+    int offset = calendar.get(Calendar.DST_OFFSET);\r
+    boolean positive = true;\r
+    if (offset<0) {\r
+      positive=false;\r
+      offset = -offset;\r
+    }\r
+    int offsethours = offset / 60*60*1000;\r
+    int offsetminutes = ( offset / 60*1000 ) % 60;\r
+\r
+    return (positive?"+":"-") +\r
+            StringUtil.zeroPaddingNumber((long) offsethours, 2, 2) + ":" +\r
+            StringUtil.zeroPaddingNumber((long) offsetminutes, 2, 2);\r
+  }\r
+}\r