| /************************************************************** |
| * |
| * 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 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| 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 compilant. <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. |
| */ |
| 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 occured :") ; |
| e.printStackTrace(log) ; |
| tRes.tested("beforeFirst()", false) ; |
| return ; |
| } |
| tRes.tested("beforeFirst()", true) ; |
| } |
| |
| /** |
| * The method is called immediatly 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 occured :") ; |
| 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 occured :") ; |
| e.printStackTrace(log) ; |
| tRes.tested("afterLast()", false) ; |
| return ; |
| } |
| tRes.tested("afterLast()", true) ; |
| } |
| |
| /** |
| * The method is called immediatly 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 occured :") ; |
| 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 occured :") ; |
| e.printStackTrace(log) ; |
| tRes.tested("first()", false) ; |
| return ; |
| } |
| tRes.tested("first()", true) ; |
| } |
| |
| /** |
| * The method is called immediatly 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 occured :") ; |
| 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 occured :") ; |
| e.printStackTrace(log) ; |
| tRes.tested("last()", false) ; |
| return ; |
| } |
| tRes.tested("last()", true) ; |
| } |
| |
| /** |
| * The method is called immediatly 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 occured :") ; |
| 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 occured :") ; |
| e.printStackTrace(log) ; |
| result = false ; |
| } |
| tRes.tested("absolute()", result) ; |
| } |
| |
| /** |
| * The method is called immediatly 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 occured:"); |
| 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 occured :") ; |
| 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 occured :") ; |
| 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 occured :") ; |
| 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 = (XRowUpdate) |
| UnoRuntime.queryInterface(XRowUpdate.class, oObj); |
| XRow 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 occured :") ; |
| 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 occured :"); |
| 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 { |
| boolean res = oObj.rowUpdated() ; |
| tRes.tested("rowUpdated()", true) ; |
| } catch (SQLException e) { |
| log.println("Exception occured :") ; |
| 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 { |
| boolean res = oObj.rowInserted() ; |
| tRes.tested("rowInserted()", true) ; |
| } catch (SQLException e) { |
| log.println("Exception occured :") ; |
| 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 { |
| boolean res = oObj.rowDeleted() ; |
| tRes.tested("rowDeleted()", true) ; |
| } catch (SQLException e) { |
| log.println("Exception occured :") ; |
| 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 occured :") ; |
| e.printStackTrace(log) ; |
| tRes.tested("getStatement()", false) ; |
| } |
| } |
| |
| /** |
| * Moves the cursor to the first row to avoid affection to |
| * the following interfaces tests |
| */ |
| public void after() { |
| log.println("Finally moving cursor to the first row ..."); |
| try { |
| oObj.first(); |
| } catch (SQLException e) { |
| log.println("Exception occured :") ; |
| e.printStackTrace(log) ; |
| } |
| } |
| |
| } // finish class _XResultSet |
| |