Adding upstream version 4:7.4.7.upstream/4%7.4.7upstream

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

1 files changed, 497 insertions, 0 deletions

diff --git a/qadevOOo/tests/java/ifc/sdbc/_XResultSet.java b/qadevOOo/tests/java/ifc/sdbc/_XResultSet.java
new file mode 100644
index 000000000..a2114d7d0
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdbc/_XResultSet.java
@@ -0,0 +1,497 @@
+/*
+ * 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 lib.MultiMethodTest;
+
+import com.sun.star.sdbc.SQLException;
+import com.sun.star.sdbc.XResultSet;
+import com.sun.star.sdbc.XRow;
+import com.sun.star.sdbc.XRowUpdate;
+import com.sun.star.uno.UnoRuntime;
+
+/**
+/**
+* Testing <code>com.sun.star.sdbc.XResultSet</code>
+* interface methods :
+* <ul>
+*  <li><code> next()</code></li>
+*  <li><code> isBeforeFirst()</code></li>
+*  <li><code> isAfterLast()</code></li>
+*  <li><code> isFirst()</code></li>
+*  <li><code> isLast()</code></li>
+*  <li><code> beforeFirst()</code></li>
+*  <li><code> afterLast()</code></li>
+*  <li><code> first()</code></li>
+*  <li><code> last()</code></li>
+*  <li><code> getRow()</code></li>
+*  <li><code> absolute()</code></li>
+*  <li><code> relative()</code></li>
+*  <li><code> previous()</code></li>
+*  <li><code> refreshRow()</code></li>
+*  <li><code> rowUpdated()</code></li>
+*  <li><code> rowInserted()</code></li>
+*  <li><code> rowDeleted()</code></li>
+*  <li><code> getStatement()</code></li>
+* </ul> <p>
+* This test needs the following object relations :
+* <ul>
+*  <li> <code>'XResultSet.hasStatement'</code> (<b>optional</b> of type
+* <code>Object</code>):
+*  it the relation exists than <code>getStatement</code> method
+*  must not return <code>null</code> </li>
+* <ul> <p>
+* Test places DB cursor to different positions and then checks
+* its current position. <p>
+* Test is <b> NOT </b> multithread compliant. <p>
+* @see com.sun.star.sdbc.XResultSet
+*/
+public class _XResultSet extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XResultSet oObj = null ;
+
+    /**
+     * Positions the cursor to the first row.
+     * Forces method tests to be executed in definite order.
+     */
+    @Override
+    public void before() {
+        try {
+            oObj.last() ;
+            log.println("Totally number of rows is " + oObj.getRow()) ;
+            oObj.first() ;
+        } catch (SQLException e) {
+            log.println("Ignored exception :") ;
+            e.printStackTrace(log);
+        }
+
+        executeMethod("isBeforeFirst()") ;
+        executeMethod("isAfterLast()") ;
+        executeMethod("isLast()") ;
+        executeMethod("isFirst()") ;
+        executeMethod("next()") ;
+        executeMethod("previous()") ;
+    }
+
+    /**
+    * Places the cursor before the first row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _beforeFirst() {
+        try {
+            oObj.beforeFirst() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("beforeFirst()", false) ;
+            return ;
+        }
+        tRes.tested("beforeFirst()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>beforeFirst</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code>. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> beforeFirst </code> : to position cursor before
+    *   the first row. </li>
+    * </ul>
+    */
+    public void _isBeforeFirst() {
+        requiredMethod("beforeFirst()") ;
+
+        boolean result = true ;
+
+        try {
+            result = oObj.isBeforeFirst() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isBeforeFirst()", result) ;
+    }
+
+    /**
+    * Places the cursor after the last row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _afterLast() {
+        try {
+            oObj.afterLast() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("afterLast()", false) ;
+            return ;
+        }
+        tRes.tested("afterLast()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>afterLast</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code> <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> afterLast </code> : to position cursor after
+    *   the last row. </li>
+    * </ul>
+    */
+    public void _isAfterLast() {
+        requiredMethod("afterLast()") ;
+
+        boolean result = true ;
+
+        try {
+            result = oObj.isAfterLast() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isAfterLast()", result) ;
+    }
+
+    /**
+    * Places the cursor on the first row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _first() {
+        try {
+            oObj.first() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("first()", false) ;
+            return ;
+        }
+        tRes.tested("first()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>first</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code>. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> first </code> : to position cursor on
+    *   the first row. </li>
+    * </ul>
+    */
+    public void _isFirst() {
+        requiredMethod("first()") ;
+
+        boolean result = true ;
+
+        try {
+            result = oObj.isFirst() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isFirst()", result) ;
+    }
+
+    /**
+    * Places the cursor on the last row. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _last() {
+        try {
+            oObj.last() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("last()", false) ;
+            return ;
+        }
+        tRes.tested("last()", true) ;
+    }
+
+    /**
+    * The method is called immediately after <code>last</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns <code>true</code>. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> last </code> : to position cursor on
+    *   the last row. </li>
+    * </ul>
+    */
+    public void _isLast() {
+        requiredMethod("last()") ;
+        boolean result = true ;
+
+        try {
+            result = oObj.isLast() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("isLast()", result) ;
+    }
+
+    /**
+    * Places the cursor on the row number 1. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _absolute() {
+        boolean result = true ;
+
+        try {
+            oObj.absolute(1) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("absolute()", result) ;
+    }
+
+    /**
+    * The method is called immediately after <code>absolute</code>
+    * method test. <p>
+    * Has <b>OK</b> status if method returns 1. <p>
+    * The following method tests are to be completed successfully before :
+    * <ul>
+    *  <li> <code> absolute </code> : to position cursor on
+    *   the row number 1. </li>
+    * </ul>
+    */
+    public void _getRow() {
+        requiredMethod("absolute()");
+        boolean result = true;
+
+        try {
+            result &= oObj.getRow() == 1;
+        } catch (SQLException e) {
+            log.println("Exception occurred:");
+            e.printStackTrace(log);
+            result = false;
+        }
+
+        tRes.tested("getRow()", result);
+    }
+
+    /**
+    * Positions the cursor to the next row. Current row
+    * number is retrieved before and after method call. <p>
+    * Has <b>OK</b> status if current row number increases
+    * by 1 after method call.
+    */
+    public void _next() {
+        boolean result = true ;
+
+        try {
+            int prevRow = oObj.getRow() ;
+            oObj.next() ;
+
+            log.println("Row was : " + prevRow + ", row is : " + oObj.getRow());
+            result &= prevRow + 1 == oObj.getRow() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("next()", result) ;
+    }
+
+    /**
+    * Positions the cursor to the previous row. Current row
+    * number is retrieved before and after method call. <p>
+    * Has <b>OK</b> status if current row number decreases
+    * by 1 after method call.
+    */
+    public void _previous() {
+        boolean result = true ;
+
+        try {
+            int prevRow = oObj.getRow() ;
+            oObj.previous() ;
+
+            log.println("Row was : " + prevRow + ", row is : " + oObj.getRow());
+            result &= prevRow - 1 == oObj.getRow() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("previous()", result) ;
+    }
+
+    /**
+    * Positions the cursor relatively by 2 rows forward.
+    * Current row number is retrieved before and after method call. <p>
+    * Has <b>OK</b> status if current row number increases
+    * by 2 after method call.
+    */
+    public void _relative() {
+        boolean result = true ;
+
+        try {
+            oObj.first() ;
+            int prevRow = oObj.getRow() ;
+            oObj.relative(2) ;
+
+            log.println("Row was : " + prevRow + ", row is : " + oObj.getRow());
+
+            result &= prevRow + 2 == oObj.getRow() ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            result = false ;
+        }
+        tRes.tested("relative()", result) ;
+    }
+
+    /**
+    * If component supports XRow and XRowUpdate then:
+    *   test saves current value of string field, updates string,
+    *   calls refreshRow() and checks that value of
+    *   string field was refetched from DB
+    * else: just calls method.<p>
+    * Has <b>OK</b> status if no exceptions were thrown and value after
+    * refreshRow() equals to saved value.
+    */
+    public void _refreshRow() {
+        XRowUpdate xRowUpdate = UnoRuntime.queryInterface(XRowUpdate.class, oObj);
+        XRow xRow = UnoRuntime.queryInterface(XRow.class, oObj);
+
+        if (xRowUpdate == null || xRow == null) {
+            log.println("Test must be modified because XRow or XRowUpdate is't supported");
+            log.println("Only call method");
+            try {
+                oObj.refreshRow() ;
+                tRes.tested("refreshRow()", true) ;
+            } catch (SQLException e) {
+                log.println("Exception occurred :") ;
+                e.printStackTrace(log) ;
+                tRes.tested("refreshRow()", false) ;
+            }
+        } else {
+            log.println("Testing of refreshRow()...");
+            try {
+                String oldValue = xRow.getString(util.DBTools.TST_STRING);
+                log.println("Old value: " + oldValue);
+                xRowUpdate.updateString(util.DBTools.TST_STRING,
+                    "Test method refreshRow");
+                log.println("New value: "
+                    + xRow.getString(util.DBTools.TST_STRING));
+                oObj.refreshRow();
+                String valAfterRefresh =
+                    xRow.getString(util.DBTools.TST_STRING);
+                log.println("Value after refresh: " + valAfterRefresh);
+                tRes.tested("refreshRow()", valAfterRefresh.equals(oldValue));
+            } catch(SQLException e) {
+                log.println("Exception occurred :");
+                e.printStackTrace(log);
+                tRes.tested("refreshRow()", false);
+            }
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _rowUpdated() {
+
+        try {
+            oObj.rowUpdated();
+            tRes.tested("rowUpdated()", true) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("rowUpdated()", false) ;
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _rowInserted() {
+        try {
+            oObj.rowInserted();
+            tRes.tested("rowInserted()", true) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("rowInserted()", false) ;
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if no exceptions were thrown.
+    */
+    public void _rowDeleted() {
+        try {
+            oObj.rowDeleted();
+            tRes.tested("rowDeleted()", true) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("rowDeleted()", false) ;
+        }
+    }
+
+    /**
+    * Just the method is called. <p>
+    * Has <b>OK</b> status if the statement returned isn't null or
+    * the relation exists that informs that statement absent (e.g. for
+    * MetaData row set).
+    */
+    public void _getStatement() {
+        try {
+            boolean hasStatement =
+                tEnv.getObjRelation("XResultSet.hasStatement") != null ;
+            Object res = oObj.getStatement() ;
+            tRes.tested("getStatement()",
+                (hasStatement && res != null) || !hasStatement) ;
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+            tRes.tested("getStatement()", false) ;
+        }
+    }
+
+    /**
+     * Moves the cursor to the first row to avoid affection to
+     * the following interfaces tests
+     */
+    @Override
+    public void after() {
+        log.println("Finally moving cursor to the first row ...");
+        try {
+            oObj.first();
+        } catch (SQLException e) {
+            log.println("Exception occurred :") ;
+            e.printStackTrace(log) ;
+        }
+    }
+
+}  // finish class _XResultSet
+