connectivity/qa/drivers/dbase/DBaseNumericFunctions.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: DBaseNumericFunctions.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 import com.sun.star.lang.XMultiServiceFactory;
  36
  37
  38 public class DBaseNumericFunctions
  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 DBaseNumericFunctions(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 Numeric 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             abs(xRowRes);
  71         }
  72         catch (SQLException ex)
  73         {
  74             assure("abs " + ex.getMessage(), false);
  75             throw ex;
  76         }
  77         try
  78         {
  79             acos(xRowRes);
  80         }
  81         catch (SQLException ex)
  82         {
  83             assure("acos " + ex.getMessage(), false);
  84             throw ex;
  85         }
  86         try
  87         {
  88             asin(xRowRes);
  89         }
  90         catch (SQLException ex)
  91         {
  92             assure("asin " + ex.getMessage(), false);
  93             throw ex;
  94         }
  95         try
  96         {
  97             atan(xRowRes);
  98         }
  99         catch (SQLException ex)
 100         {
 101             assure("atan " + ex.getMessage(), false);
 102             throw ex;
 103         }
 104         try
 105         {
 106             atan2(xRowRes);
 107         }
 108         catch (SQLException ex)
 109         {
 110             assure("atan2 " + ex.getMessage(), false);
 111             throw ex;
 112         }
 113         try
 114         {
 115             ceiling(xRowRes);
 116         }
 117         catch (SQLException ex)
 118         {
 119             assure("ceiling " + ex.getMessage(), false);
 120             throw ex;
 121         }
 122         try
 123         {
 124             cos(xRowRes);
 125         }
 126         catch (SQLException ex)
 127         {
 128             assure("cos " + ex.getMessage(), false);
 129             throw ex;
 130         }
 131         try
 132         {
 133             degrees(xRowRes);
 134         }
 135         catch (SQLException ex)
 136         {
 137             assure("degrees " + ex.getMessage(), false);
 138             throw ex;
 139         }
 140         try
 141         {
 142             exp(xRowRes);
 143         }
 144         catch (SQLException ex)
 145         {
 146             assure("exp " + ex.getMessage(), false);
 147             throw ex;
 148         }
 149         try
 150         {
 151             floor(xRowRes);
 152         }
 153         catch (SQLException ex)
 154         {
 155             assure("floor " + ex.getMessage(), false);
 156             throw ex;
 157         }
 158         try
 159         {
 160             log(xRowRes);
 161         }
 162         catch (SQLException ex)
 163         {
 164             assure("log " + ex.getMessage(), false);
 165             throw ex;
 166         }
 167         try
 168         {
 169             log10(xRowRes);
 170         }
 171         catch (SQLException ex)
 172         {
 173             assure("log10 " + ex.getMessage(), false);
 174             throw ex;
 175         }
 176         try
 177         {
 178             mod(xRowRes);
 179         }
 180         catch (SQLException ex)
 181         {
 182             assure("mod " + ex.getMessage(), false);
 183             throw ex;
 184         }
 185         try
 186         {
 187             pi(xRowRes);
 188         }
 189         catch (SQLException ex)
 190         {
 191             assure("pi " + ex.getMessage(), false);
 192             throw ex;
 193         }
 194         try
 195         {
 196             pow(xRowRes);
 197         }
 198         catch (SQLException ex)
 199         {
 200             assure("pow " + ex.getMessage(), false);
 201             throw ex;
 202         }
 203         try
 204         {
 205             radians(xRowRes);
 206         }
 207         catch (SQLException ex)
 208         {
 209             assure("radians " + ex.getMessage(), false);
 210             throw ex;
 211         }
 212         try
 213         {
 214             round(xRowRes);
 215         }
 216         catch (SQLException ex)
 217         {
 218             assure("round " + ex.getMessage(), false);
 219             throw ex;
 220         }
 221         try
 222         {
 223             sign(xRowRes);
 224         }
 225         catch (SQLException ex)
 226         {
 227             assure("sign " + ex.getMessage(), false);
 228             throw ex;
 229         }
 230         try
 231         {
 232             sin(xRowRes);
 233         }
 234         catch (SQLException ex)
 235         {
 236             assure("sin " + ex.getMessage(), false);
 237             throw ex;
 238         }
 239         try
 240         {
 241             sqrt(xRowRes);
 242         }
 243         catch (SQLException ex)
 244         {
 245             assure("sqrt " + ex.getMessage(), false);
 246             throw ex;
 247         }
 248         try
 249         {
 250             tan(xRowRes);
 251         }
 252         catch (SQLException ex)
 253         {
 254             assure("tan " + ex.getMessage(), false);
 255             throw ex;
 256         }
 257
 258     }
 259
 260     private XRow execute(final XRowSet xRowRes,final  String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 261     {
 262         final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes);
 263         xProp.setPropertyValue("Command", "SELECT " + sql + where);
 264         xRowRes.execute();
 265         final XResultSet xRes = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, xRowRes);
 266         assure("No valid row! ", xRes.next());
 267
 268         return (XRow) UnoRuntime.queryInterface(XRow.class, xRes);
 269     }
 270
 271     private void abs(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 272     {
 273         final XRow row = execute(xRowRes, "ABS(2),ABS(-32) ");
 274         assure("ABS(2) failed!", row.getInt(1) == 2);
 275         assure("ABS(-32) failed!", row.getInt(2) == 32);
 276     }
 277
 278     private void sign(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 279     {
 280         final XRow row = execute(xRowRes, "SIGN(-32),SIGN(0),SIGN(234) ");
 281         assure("SIGN(-32)failed!", row.getInt(1) == -1);
 282         assure("SIGN(0) failed!", row.getInt(2) == 0);
 283         assure("SIGN(234) failed!", row.getInt(3) == 1);
 284     }
 285
 286     private void mod(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 287     {
 288         final XRow row = execute(xRowRes, "MOD(234, 10) ");
 289         assure("MOD(234, 10) failed!", row.getInt(1) == 4);
 290     }
 291
 292     private void floor(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 293     {
 294         final XRow row = execute(xRowRes, "FLOOR(1.23),FLOOR(-1.23) ");
 295         assure("FLOOR(1.23) failed!", row.getInt(1) == 1);
 296         assure("FLOOR(-1.23) failed!", row.getInt(2) == -2);
 297     }
 298
 299     private void ceiling(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 300     {
 301         final XRow row = execute(xRowRes, "CEILING(1.23),CEILING(-1.23) ");
 302         assure("CEILING(1.23) failed!", row.getInt(1) == 2);
 303         assure("CEILING(-1.23) failed!", row.getInt(2) == -1);
 304     }
 305
 306     private void round(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 307     {
 308         final XRow row = execute(xRowRes, "ROUND(-1.23),ROUND(1.298, 1) ");
 309         assure("ROUND(-1.23) failed!", row.getInt(1) == -1);
 310         assure("ROUND(1.298, 1) failed!", row.getDouble(2) == 1.3);
 311     }
 312
 313     private void exp(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 314     {
 315         final XRow row = execute(xRowRes, "EXP(2),EXP(-2) ");
 316         assure("EXP(2) failed!", (float) row.getDouble(1) == (float) java.lang.Math.exp(2));
 317         assure("EXP(-2) failed!", (float) row.getDouble(2) == (float) java.lang.Math.exp(-2));
 318     }
 319
 320     private void log(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 321     {
 322         final XRow row = execute(xRowRes, "LOG(2),LOG(-2) ");
 323         assure("LOG(2) failed!", (float) row.getDouble(1) == (float) java.lang.Math.log(2));
 324         row.getDouble(2);
 325         assure("LOG(-2) failed!", row.wasNull());
 326     }
 327
 328     private void log10(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 329     {
 330         final XRow row = execute(xRowRes, "LOG10(100) ");
 331         assure("LOG10(100) failed!", row.getDouble(1) == 2.0);
 332     }
 333
 334     private void pow(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 335     {
 336         final XRow row = execute(xRowRes, "POWER(2,2) ");
 337         assure("POWER(2,2) failed!", row.getDouble(1) == 4.0);
 338     }
 339
 340     private void sqrt(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 341     {
 342         final XRow row = execute(xRowRes, "SQRT(4) ");
 343         assure("SQRT(4) failed!", row.getDouble(1) == 2.0);
 344     }
 345
 346     private void pi(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 347     {
 348         final XRow row = execute(xRowRes, "PI() ");
 349         assure("PI() failed!", (float) row.getDouble(1) == (float) java.lang.Math.PI);
 350     }
 351
 352     private void cos(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 353     {
 354         final XRow row = execute(xRowRes, "COS(PI()) ");
 355         assure("COS(PI()) failed!", row.getDouble(1) == -1.0);
 356     }
 357
 358     private void sin(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 359     {
 360         final XRow row = execute(xRowRes, "SIN(2) ");
 361         assure("SIN(PI()) failed!", (float) row.getDouble(1) == (float) java.lang.Math.sin(2));
 362     }
 363
 364     private void tan(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 365     {
 366         final XRow row = execute(xRowRes, "TAN(PI()+1) ");
 367         assure("TAN(PI()+1) failed!", (float) row.getDouble(1) == (float) java.lang.Math.tan(java.lang.Math.PI + 1.0));
 368     }
 369
 370     private void acos(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 371     {
 372         final XRow row = execute(xRowRes, "ACOS(1) ");
 373         assure("ACOS(1) failed!", (float) row.getDouble(1) == 0.0);
 374     }
 375
 376     private void asin(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 377     {
 378         final XRow row = execute(xRowRes, "ASIN(0) ");
 379         assure("ASIN(0) failed!", (float) row.getDouble(1) == (float) java.lang.Math.asin(0.0));
 380     }
 381
 382     private void atan(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 383     {
 384         final XRow row = execute(xRowRes, "ATAN(0) ");
 385         assure("ATAN(0) failed!", row.getDouble(1) == 0.0);
 386     }
 387
 388     private void atan2(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 389     {
 390         final XRow row = execute(xRowRes, "ATAN2(0,2) ");
 391         assure("ATAN2(0,2) failed!", (float) row.getDouble(1) == 0.0);
 392     }
 393
 394     private void degrees(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 395     {
 396         final XRow row = execute(xRowRes, "DEGREES(PI()) ");
 397         assure("DEGREES(PI()) failed!", row.getDouble(1) == 180.0);
 398     }
 399
 400     private void radians(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 401     {
 402         final XRow row = execute(xRowRes, "RADIANS(90) ");
 403         assure("RADIANS(90) failed!", (float) row.getDouble(1) == (float) (java.lang.Math.PI / 2.0));
 404     }
 405 }