Adding upstream version 1:7.0.4.upstream/1%7.0.4upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 564 insertions, 0 deletions

diff --git a/qadevOOo/tests/java/ifc/sdbc/_XParameters.java b/qadevOOo/tests/java/ifc/sdbc/_XParameters.java
new file mode 100644
index 000000000..4284931fe
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XParameters.java
@@ -0,0 +1,564 @@
+/*
+ * This file is part of the LibreOffice project.
+ *
+ * This Source Code Form is subject to the terms of the Mozilla Public
+ * License, v. 2.0. If a copy of the MPL was not distributed with this
+ * file, You can obtain one at http://mozilla.org/MPL/2.0/.
+ *
+ * This file incorporates work covered by the following license notice:
+ *
+ *   Licensed to the Apache Software Foundation (ASF) under one or more
+ *   contributor license agreements. See the NOTICE file distributed
+ *   with this work for additional information regarding copyright
+ *   ownership. The ASF licenses this file to you under the Apache
+ *   License, Version 2.0 (the "License"); you may not use this file
+ *   except in compliance with the License. You may obtain a copy of
+ *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
+ */
+
+package ifc.sdbc;
+
+import java.util.List;
+
+import lib.MultiMethodTest;
+import lib.Status;
+
+import com.sun.star.io.XDataInputStream;
+import com.sun.star.io.XInputStream;
+import com.sun.star.io.XTextInputStream;
+import com.sun.star.sdbc.DataType;
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XParameters;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.util.Date;
+import com.sun.star.util.DateTime;
+import com.sun.star.util.Time;
+
+/**
+/**
+* Testing <code>com.sun.star.sdbc.XParameters</code>
+* interface methods :
+* <ul>
+*  <li><code> setNull()</code></li>
+*  <li><code> setObjectNull()</code></li>
+*  <li><code> setBoolean()</code></li>
+*  <li><code> setByte()</code></li>
+*  <li><code> setShort()</code></li>
+*  <li><code> setInt()</code></li>
+*  <li><code> setLong()</code></li>
+*  <li><code> setFloat()</code></li>
+*  <li><code> setDouble()</code></li>
+*  <li><code> setString()</code></li>
+*  <li><code> setBytes()</code></li>
+*  <li><code> setDate()</code></li>
+*  <li><code> setTime()</code></li>
+*  <li><code> setTimestamp()</code></li>
+*  <li><code> setBinaryStream()</code></li>
+*  <li><code> setCharacterStream()</code></li>
+*  <li><code> setObject()</code></li>
+*  <li><code> setObjectWithInfo()</code></li>
+*  <li><code> setRef()</code></li>
+*  <li><code> setBlob()</code></li>
+*  <li><code> setClob()</code></li>
+*  <li><code> setArray()</code></li>
+*  <li><code> clearParameters()</code></li>
+* </ul> <p>
+* Object relations required :
+* <ul>
+* <li> <code>'XParameters.ParamValues'</code> :  is a
+* <code>java.util.Vector</code> object
+* that contains parameter types and values of the statement. Each
+* element of vector corresponds to appropriate parameter (element
+* with index 0 to parameter #1, 1 -> #2, etc.). <p>
+* The following <code>XParameters</code> methods correspond to classes
+* in Vector :
+* <ul>
+*   <li> <code>setBinaryStream</code> -
+*        <code>com.sun.star.io.XDataInputStream</code> class. </li>
+*   <li> <code>setCharacterStream</code> -
+*        <code>com.sun.star.io.XTextInputStream</code> class. </li>
+*   <li> <code>setObject</code> -
+*        <code>java.lang.Object[]</code> class, the element with
+*         index 0 must be used. </li>
+* </ul>
+* Other methods uses types of their arguments (i.e.
+* <code>String</code>
+* for <code>setString</code> method, <code>com.sun.star.sdbc.XRef</code>
+* for <code>setRef</code> method).
+* </li>
+* </ul>
+* @see com.sun.star.sdbc.XParameters
+*/
+public class _XParameters extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XParameters oObj = null ;
+
+    private List<Object> data = null ;
+
+    /**
+    * Gets object relation
+    */
+    @Override
+    public void before() {
+        data = (List<Object>) tEnv.getObjRelation("XParameters.ParamValues") ;
+        if (data == null) {
+            log.println("!!! Relation not found !!!") ;
+        }
+    }
+
+    /**
+    * Sets String parameter (if exists) to SQL NULL value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setNull() {
+        boolean result = true ;
+        int idx = findParamOfType(String.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setNull(idx, DataType.VARCHAR) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setNull()", result) ;
+    }
+
+    public void _setObjectNull() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setObjectNull()", Status.skipped(true)) ;
+    }
+
+    /**
+    * Sets String parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setString() {
+        boolean result = true ;
+        int idx = findParamOfType(String.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setString(idx, "XParameters") ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setString()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setBoolean() {
+        boolean result = true ;
+        int idx = findParamOfType(Boolean.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setBoolean(idx, true) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setBoolean()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setByte() {
+        boolean result = true ;
+        int idx = findParamOfType(Byte.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setByte(idx, (byte)122) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setByte()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setShort() {
+        boolean result = true ;
+        int idx = findParamOfType(Short.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setShort(idx, (short)133) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setShort()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setInt() {
+        boolean result = true ;
+        int idx = findParamOfType(Integer.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setInt(idx, 13300) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setInt()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setLong() {
+        boolean result = true ;
+        int idx = findParamOfType(Long.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setLong(idx, 13362453) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setLong()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setFloat() {
+        boolean result = true ;
+        int idx = findParamOfType(Float.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setFloat(idx, (float)133.55) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setFloat()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setDouble() {
+        boolean result = true ;
+        int idx = findParamOfType(Double.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setDouble(idx, 133) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setDouble()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setBytes() {
+        boolean result = true ;
+        int idx = findParamOfType(byte[].class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setBytes(idx, new byte[] {5}) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setBytes()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setDate() {
+        boolean result = true ;
+        int idx = findParamOfType(Date.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setDate(
+                    idx, new Date ((short)19, (short)1, (short)1979)) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setDate()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setTime() {
+        boolean result = true ;
+        int idx = findParamOfType(Time.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setTime(
+                    idx, new Time((short)1,(short)2,(short)3,(short)44, false));
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setTime()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setTimestamp() {
+        boolean result = true ;
+        int idx = findParamOfType(DateTime.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                oObj.setTimestamp(idx, new DateTime((short)1,(short)2,(short)3,
+                    (short)4, (short)19, (short)1, (short)1979, false)) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setTimestamp()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setBinaryStream() {
+        boolean result = true ;
+        int idx = findParamOfType(XDataInputStream.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object oStream = tParam.getMSF().
+                        createInstance("com.sun.star.io.DataInputStream") ;
+                XInputStream xStream = UnoRuntime.queryInterface
+                    (XInputStream.class, oStream);
+
+                oObj.setBinaryStream(idx, xStream, 2) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setBinaryStream()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setCharacterStream() {
+        boolean result = true ;
+        int idx = findParamOfType(XTextInputStream.class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object oStream = tParam.getMSF()
+                        .createInstance("com.sun.star.io.TextInputStream") ;
+                XInputStream xStream = UnoRuntime.queryInterface
+                    (XInputStream.class, oStream);
+
+                oObj.setCharacterStream(idx, xStream, 2) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setCharacterStream()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setObject() {
+        boolean result = true ;
+        int idx = findParamOfType(Object[].class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object obj = tParam.getMSF().
+                                createInstance("com.sun.star.io.Pipe") ;
+
+                oObj.setObject(idx, obj) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setObject()", result) ;
+    }
+
+    /**
+    * Sets parameter (if exists) to new value. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _setObjectWithInfo() {
+        boolean result = true ;
+        int idx = findParamOfType(Object[].class) ;
+        if (idx < 0) log.println("Type not found in relation: not tested");
+        else {
+            try {
+                Object obj = tParam.getMSF().
+                    createInstance("com.sun.star.io.Pipe") ;
+
+                oObj.setObjectWithInfo(idx, obj, DataType.OBJECT, 0) ;
+            } catch (SQLException e) {
+                log.println("Unexpected SQL exception:") ;
+                log.println(e) ;
+                result = false ;
+            } catch (com.sun.star.uno.Exception e) {
+                log.println("Unexpected exception:") ;
+                log.println(e) ;
+                result = false ;
+            }
+        }
+
+        tRes.tested("setObjectWithInfo()", result) ;
+    }
+
+    public void _setRef() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setRef()", Status.skipped(true)) ;
+    }
+    public void _setBlob() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setBlob()", Status.skipped(true)) ;
+    }
+    public void _setClob() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setClob()", Status.skipped(true)) ;
+    }
+    public void _setArray() {
+        /*
+            !!! TO DO !!!
+        */
+        tRes.tested("setArray()", Status.skipped(true)) ;
+    }
+
+    /**
+    * Calls method. <p>
+    * Has OK status if no exceptions occurred.
+    */
+    public void _clearParameters() {
+        boolean result = true ;
+        try {
+            oObj.clearParameters() ;
+        } catch (SQLException e) {
+            log.println("Unexpected SQL exception:") ;
+            log.println(e) ;
+            result = false ;
+        }
+
+        tRes.tested("clearParameters()", result) ;
+    }
+
+
+    /**
+    * Finds in relation vector index of parameter of the appropriate
+    * type.
+    */
+    private int findParamOfType(Class<?> clz) {
+        for (int i = 0; i < data.size(); i++)
+            if (clz.isInstance(data.get(i))) return i + 1 ;
+        return -1 ;
+    }
+
+}  // finish class _XParameters
+
+