Quelle _XResultSet.java Sprache: JAVA

/*
* 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> 
* This test needs the following object relations :
* <ul>
* <li> <code>'XResultSet.hasStatement'</code> (optional of type
* <code>Object</code>):
* it the relation exists than <code>getStatement</code> method
* must not return <code>null</code> </li>
* <ul> 
* Test places DB cursor to different positions and then checks
* its current position. 
* Test is NOT multithread compliant. 
* @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. 
 * Has OK 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. 
 * Has OK status if method returns <code>true</code>. 
 * 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. 
 * Has OK 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. 
 * Has OK status if method returns <code>true</code> 
 * 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. 
 * Has OK 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. 
 * Has OK status if method returns <code>true</code>. 
 * 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. 
 * Has OK 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. 
 * Has OK status if method returns <code>true</code>. 
 * 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. 
 * Has OK 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. 
 * Has OK status if method returns 1. 
 * 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. 
 * Has OK 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. 
 * Has OK 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. 
 * Has OK 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.
 * Has OK 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. 
 * Has OK 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. 
 * Has OK 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. 
 * Has OK 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. 
 * Has OK 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

Messung V0.5

¤ Dauer der Verarbeitung: 0.5 Sekunden ¤

Wurzel

Suchen

Beweissystem der NASA

Beweissystem Isabelle

NIST Cobol Testsuite

Cephes Mathematical Library

Wiener Entwicklungsmethode

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.

Bemerkung:

Die farbliche Syntaxdarstellung und die Messung sind noch experimentell.