connectivity/qa/drivers/dbase/DBaseDateFunctions.java

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: DBaseDateFunctions.java,v $
  10  * $Revision: 1.6 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30 package qa.drivers.dbase;
  31
  32 import com.sun.star.uno.UnoRuntime;
  33 import com.sun.star.sdbc.*;
  34 import com.sun.star.beans.XPropertySet;
  35
  36 import com.sun.star.lang.XMultiServiceFactory;
  37
  38 public class DBaseDateFunctions
  39 {
  40
  41     private final String where = "FROM \"biblio\" \"biblio\" where \"Identifier\" = 'BOR00'";
  42     private final XMultiServiceFactory m_xORB;
  43     private final DBaseDriverTest testcase;
  44
  45     public DBaseDateFunctions(final XMultiServiceFactory _xORB, final DBaseDriverTest _testcase)
  46     {
  47         m_xORB = _xORB;
  48         testcase = _testcase;
  49     }
  50
  51     private void assure(final String s, final boolean b)
  52     {
  53         testcase.assure2(s, b);
  54     }
  55
  56     public void testFunctions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
  57     {
  58         final XRowSet xRowRes = (XRowSet) UnoRuntime.queryInterface(XRowSet.class,
  59                 m_xORB.createInstance("com.sun.star.sdb.RowSet"));
  60
  61         testcase.getLog().println("starting DateTime function test!");
  62         // set the properties needed to connect to a database
  63         final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes);
  64         xProp.setPropertyValue("DataSourceName", "Bibliography");
  65
  66         xProp.setPropertyValue("CommandType", Integer.valueOf(com.sun.star.sdb.CommandType.COMMAND));
  67
  68         try
  69         {
  70             curdate(xRowRes);
  71         }
  72         catch (SQLException ex)
  73         {
  74             assure("upper " + ex.getMessage(), false);
  75             throw ex;
  76         }
  77         try
  78         {
  79             curtime(xRowRes);
  80         }
  81         catch (SQLException ex)
  82         {
  83             assure("lower " + ex.getMessage(), false);
  84             throw ex;
  85         }
  86         try
  87         {
  88             dayname(xRowRes);
  89         }
  90         catch (SQLException ex)
  91         {
  92             assure("ascii " + ex.getMessage(), false);
  93             throw ex;
  94         }
  95         try
  96         {
  97             dayofmonth(xRowRes);
  98         }
  99         catch (SQLException ex)
 100         {
 101             assure("char_len " + ex.getMessage(), false);
 102             throw ex;
 103         }
 104         try
 105         {
 106             dayofweek(xRowRes);
 107         }
 108         catch (SQLException ex)
 109         {
 110             assure("concat " + ex.getMessage(), false);
 111             throw ex;
 112         }
 113         try
 114         {
 115             dayofyear(xRowRes);
 116         }
 117         catch (SQLException ex)
 118         {
 119             assure("locate " + ex.getMessage(), false);
 120             throw ex;
 121         }
 122         try
 123         {
 124             hour(xRowRes);
 125         }
 126         catch (SQLException ex)
 127         {
 128             assure("substr " + ex.getMessage(), false);
 129             throw ex;
 130         }
 131         try
 132         {
 133             minute(xRowRes);
 134         }
 135         catch (SQLException ex)
 136         {
 137             assure("ltrim " + ex.getMessage(), false);
 138             throw ex;
 139         }
 140         try
 141         {
 142             month(xRowRes);
 143         }
 144         catch (SQLException ex)
 145         {
 146             assure("rtrim " + ex.getMessage(), false);
 147             throw ex;
 148         }
 149         try
 150         {
 151             monthname(xRowRes);
 152         }
 153         catch (SQLException ex)
 154         {
 155             assure("space " + ex.getMessage(), false);
 156             throw ex;
 157         }
 158         try
 159         {
 160             now(xRowRes);
 161         }
 162         catch (SQLException ex)
 163         {
 164             assure("replace " + ex.getMessage(), false);
 165             throw ex;
 166         }
 167         try
 168         {
 169             quarter(xRowRes);
 170         }
 171         catch (SQLException ex)
 172         {
 173             assure("repeat " + ex.getMessage(), false);
 174             throw ex;
 175         }
 176         try
 177         {
 178             second(xRowRes);
 179         }
 180         catch (SQLException ex)
 181         {
 182             assure("insert " + ex.getMessage(), false);
 183             throw ex;
 184         }
 185         try
 186         {
 187             week(xRowRes);
 188         }
 189         catch (SQLException ex)
 190         {
 191             assure("left " + ex.getMessage(), false);
 192             throw ex;
 193         }
 194         try
 195         {
 196             year(xRowRes);
 197         }
 198         catch (SQLException ex)
 199         {
 200             assure("right " + ex.getMessage(), false);
 201             throw ex;
 202         }
 203     }
 204
 205     private XRow execute(final XRowSet xRowRes, final String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 206     {
 207         final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes);
 208         xProp.setPropertyValue("Command", "SELECT " + sql + where);
 209         xRowRes.execute();
 210         final XResultSet xRes = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, xRowRes);
 211         assure("No valid row! ", xRes.next());
 212
 213         return (XRow) UnoRuntime.queryInterface(XRow.class, xRes);
 214     }
 215
 216     private void dayofweek(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 217     {
 218         final XRow row = execute(xRowRes, "DAYOFWEEK('1998-02-03') ");
 219         assure("DAYOFWEEK('1998-02-03') failed!", row.getInt(1) == 3);
 220     }
 221
 222     private void dayofmonth(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 223     {
 224         final XRow row = execute(xRowRes, "DAYOFMONTH('1998-02-03') ");
 225         assure("DAYOFMONTH('1998-02-03') failed!", row.getInt(1) == 3);
 226     }
 227
 228     private void dayofyear(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 229     {
 230         final XRow row = execute(xRowRes, "DAYOFYEAR('1998-02-03') ");
 231         assure("DAYOFYEAR('1998-02-03') failed!", row.getInt(1) == 34);
 232     }
 233
 234     private void month(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 235     {
 236         final XRow row = execute(xRowRes, "month('1998-02-03') ");
 237         assure("month('1998-02-03') failed!", row.getInt(1) == 2);
 238     }
 239
 240     private void dayname(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 241     {
 242         final XRow row = execute(xRowRes, "DAYNAME('1998-02-05') ");
 243         assure("DAYNAME('1998-02-05') failed!", row.getString(1).equals("Thursday"));
 244     }
 245
 246     private void monthname(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 247     {
 248         final XRow row = execute(xRowRes, "MONTHNAME('1998-02-05') ");
 249         assure("MONTHNAME('1998-02-05') failed!", row.getString(1).equals("February"));
 250     }
 251
 252     private void quarter(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 253     {
 254         final XRow row = execute(xRowRes, "QUARTER('98-01-01'),QUARTER('98-04-01'),QUARTER('98-07-01'),QUARTER('98-10-01') ");
 255         assure("QUARTER('98-01-01') failed!", row.getInt(1) == 1);
 256         assure("QUARTER('98-04-01') failed!", row.getInt(2) == 2);
 257         assure("QUARTER('98-07-01') failed!", row.getInt(3) == 3);
 258         assure("QUARTER('98-10-01') failed!", row.getInt(4) == 4);
 259     }
 260
 261     private void week(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 262     {
 263         final XRow row = execute(xRowRes, "WEEK('1998-02-20') ");
 264         assure("WEEK('1998-02-20') failed!", row.getInt(1) == 7);
 265     }
 266
 267     private void year(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 268     {
 269         final XRow row = execute(xRowRes, "YEAR('98-02-03') ");
 270         assure("YEAR('98-02-03') failed!", row.getInt(1) == 98);
 271     }
 272
 273     private void hour(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 274     {
 275         final XRow row = execute(xRowRes, "HOUR('10:05:03') ");
 276         assure("HOUR('10:05:03') failed!", row.getInt(1) == 10);
 277     }
 278
 279     private void minute(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 280     {
 281         final XRow row = execute(xRowRes, "MINUTE('98-02-03 10:05:03') ");
 282         assure("MINUTE('98-02-03 10:05:03') failed!", row.getInt(1) == 5);
 283     }
 284
 285     private void second(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 286     {
 287         final XRow row = execute(xRowRes, "SECOND('10:05:03') ");
 288         assure("SECOND('10:05:03') failed!", row.getInt(1) == 3);
 289     }
 290
 291     private void curdate(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 292     {
 293         final XRow row = execute(xRowRes, "CURDATE() ");
 294         final com.sun.star.util.Date aDate = row.getDate(1);
 295         testcase.getLog().println("CURDATE() is '" + aDate.Year + "-" + aDate.Month + "-" + aDate.Day + "'");
 296     }
 297
 298     private void curtime(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 299     {
 300         final XRow row = execute(xRowRes, "CURTIME() ");
 301         final com.sun.star.util.Time aTime = row.getTime(1);
 302         testcase.getLog().println("CURTIME() is '" + aTime.Hours + ":" + aTime.Minutes + ":" + aTime.Seconds + "'");
 303     }
 304
 305     private void now(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 306     {
 307         final XRow row = execute(xRowRes, "NOW() ");
 308         final com.sun.star.util.DateTime aTime = row.getTimestamp(1);
 309         testcase.getLog().println("NOW() is '" + aTime.Year + "-" + aTime.Month + "-" + aTime.Day + "'");
 310         testcase.getLog().println("'" + aTime.Hours + ":" + aTime.Minutes + ":" + aTime.Seconds + "'");
 311     }
 312 }