1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir package ifc.sdbc; 29*cdf0e10cSrcweir 30*cdf0e10cSrcweir import lib.MultiMethodTest; 31*cdf0e10cSrcweir 32*cdf0e10cSrcweir import com.sun.star.sdbc.SQLException; 33*cdf0e10cSrcweir import com.sun.star.sdbc.XResultSet; 34*cdf0e10cSrcweir import com.sun.star.sdbc.XRow; 35*cdf0e10cSrcweir import com.sun.star.sdbc.XRowUpdate; 36*cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 37*cdf0e10cSrcweir 38*cdf0e10cSrcweir /** 39*cdf0e10cSrcweir /** 40*cdf0e10cSrcweir * Testing <code>com.sun.star.sdbc.XResultSet</code> 41*cdf0e10cSrcweir * interface methods : 42*cdf0e10cSrcweir * <ul> 43*cdf0e10cSrcweir * <li><code> next()</code></li> 44*cdf0e10cSrcweir * <li><code> isBeforeFirst()</code></li> 45*cdf0e10cSrcweir * <li><code> isAfterLast()</code></li> 46*cdf0e10cSrcweir * <li><code> isFirst()</code></li> 47*cdf0e10cSrcweir * <li><code> isLast()</code></li> 48*cdf0e10cSrcweir * <li><code> beforeFirst()</code></li> 49*cdf0e10cSrcweir * <li><code> afterLast()</code></li> 50*cdf0e10cSrcweir * <li><code> first()</code></li> 51*cdf0e10cSrcweir * <li><code> last()</code></li> 52*cdf0e10cSrcweir * <li><code> getRow()</code></li> 53*cdf0e10cSrcweir * <li><code> absolute()</code></li> 54*cdf0e10cSrcweir * <li><code> relative()</code></li> 55*cdf0e10cSrcweir * <li><code> previous()</code></li> 56*cdf0e10cSrcweir * <li><code> refreshRow()</code></li> 57*cdf0e10cSrcweir * <li><code> rowUpdated()</code></li> 58*cdf0e10cSrcweir * <li><code> rowInserted()</code></li> 59*cdf0e10cSrcweir * <li><code> rowDeleted()</code></li> 60*cdf0e10cSrcweir * <li><code> getStatement()</code></li> 61*cdf0e10cSrcweir * </ul> <p> 62*cdf0e10cSrcweir * This test needs the following object relations : 63*cdf0e10cSrcweir * <ul> 64*cdf0e10cSrcweir * <li> <code>'XResultSet.hasStatement'</code> (<b>optional</b> of type 65*cdf0e10cSrcweir * <code>Object</code>): 66*cdf0e10cSrcweir * it the relation exists than <code>getStatement</code> method 67*cdf0e10cSrcweir * must not return <code>null</code> </li> 68*cdf0e10cSrcweir * <ul> <p> 69*cdf0e10cSrcweir * Test places DB cursor to different positions and then checks 70*cdf0e10cSrcweir * its current position. <p> 71*cdf0e10cSrcweir * Test is <b> NOT </b> multithread compilant. <p> 72*cdf0e10cSrcweir * @see com.sun.star.sdbc.XResultSet 73*cdf0e10cSrcweir */ 74*cdf0e10cSrcweir public class _XResultSet extends MultiMethodTest { 75*cdf0e10cSrcweir 76*cdf0e10cSrcweir // oObj filled by MultiMethodTest 77*cdf0e10cSrcweir public XResultSet oObj = null ; 78*cdf0e10cSrcweir 79*cdf0e10cSrcweir /** 80*cdf0e10cSrcweir * Positions the cursor to the first row. 81*cdf0e10cSrcweir * Forces method tests to be executed in definite order. 82*cdf0e10cSrcweir */ 83*cdf0e10cSrcweir public void before() { 84*cdf0e10cSrcweir try { 85*cdf0e10cSrcweir oObj.last() ; 86*cdf0e10cSrcweir log.println("Totally number of rows is " + oObj.getRow()) ; 87*cdf0e10cSrcweir oObj.first() ; 88*cdf0e10cSrcweir } catch (SQLException e) { 89*cdf0e10cSrcweir log.println("Ignored exception :") ; 90*cdf0e10cSrcweir e.printStackTrace(log); 91*cdf0e10cSrcweir } 92*cdf0e10cSrcweir 93*cdf0e10cSrcweir executeMethod("isBeforeFirst()") ; 94*cdf0e10cSrcweir executeMethod("isAfterLast()") ; 95*cdf0e10cSrcweir executeMethod("isLast()") ; 96*cdf0e10cSrcweir executeMethod("isFirst()") ; 97*cdf0e10cSrcweir executeMethod("next()") ; 98*cdf0e10cSrcweir executeMethod("previous()") ; 99*cdf0e10cSrcweir } 100*cdf0e10cSrcweir 101*cdf0e10cSrcweir /** 102*cdf0e10cSrcweir * Places the cursor before the first row. <p> 103*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 104*cdf0e10cSrcweir */ 105*cdf0e10cSrcweir public void _beforeFirst() { 106*cdf0e10cSrcweir try { 107*cdf0e10cSrcweir oObj.beforeFirst() ; 108*cdf0e10cSrcweir } catch (SQLException e) { 109*cdf0e10cSrcweir log.println("Exception occured :") ; 110*cdf0e10cSrcweir e.printStackTrace(log) ; 111*cdf0e10cSrcweir tRes.tested("beforeFirst()", false) ; 112*cdf0e10cSrcweir return ; 113*cdf0e10cSrcweir } 114*cdf0e10cSrcweir tRes.tested("beforeFirst()", true) ; 115*cdf0e10cSrcweir } 116*cdf0e10cSrcweir 117*cdf0e10cSrcweir /** 118*cdf0e10cSrcweir * The method is called immediatly after <code>beforeFirst</code> 119*cdf0e10cSrcweir * method test. <p> 120*cdf0e10cSrcweir * Has <b>OK</b> status if method returns <code>true</code>. <p> 121*cdf0e10cSrcweir * The following method tests are to be completed successfully before : 122*cdf0e10cSrcweir * <ul> 123*cdf0e10cSrcweir * <li> <code> beforeFirst </code> : to position cursor before 124*cdf0e10cSrcweir * the first row. </li> 125*cdf0e10cSrcweir * </ul> 126*cdf0e10cSrcweir */ 127*cdf0e10cSrcweir public void _isBeforeFirst() { 128*cdf0e10cSrcweir requiredMethod("beforeFirst()") ; 129*cdf0e10cSrcweir 130*cdf0e10cSrcweir boolean result = true ; 131*cdf0e10cSrcweir 132*cdf0e10cSrcweir try { 133*cdf0e10cSrcweir result = oObj.isBeforeFirst() ; 134*cdf0e10cSrcweir } catch (SQLException e) { 135*cdf0e10cSrcweir log.println("Exception occured :") ; 136*cdf0e10cSrcweir e.printStackTrace(log) ; 137*cdf0e10cSrcweir result = false ; 138*cdf0e10cSrcweir } 139*cdf0e10cSrcweir tRes.tested("isBeforeFirst()", result) ; 140*cdf0e10cSrcweir } 141*cdf0e10cSrcweir 142*cdf0e10cSrcweir /** 143*cdf0e10cSrcweir * Places the cursor after the last row. <p> 144*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 145*cdf0e10cSrcweir */ 146*cdf0e10cSrcweir public void _afterLast() { 147*cdf0e10cSrcweir try { 148*cdf0e10cSrcweir oObj.afterLast() ; 149*cdf0e10cSrcweir } catch (SQLException e) { 150*cdf0e10cSrcweir log.println("Exception occured :") ; 151*cdf0e10cSrcweir e.printStackTrace(log) ; 152*cdf0e10cSrcweir tRes.tested("afterLast()", false) ; 153*cdf0e10cSrcweir return ; 154*cdf0e10cSrcweir } 155*cdf0e10cSrcweir tRes.tested("afterLast()", true) ; 156*cdf0e10cSrcweir } 157*cdf0e10cSrcweir 158*cdf0e10cSrcweir /** 159*cdf0e10cSrcweir * The method is called immediatly after <code>afterLast</code> 160*cdf0e10cSrcweir * method test. <p> 161*cdf0e10cSrcweir * Has <b>OK</b> status if method returns <code>true</code> <p> 162*cdf0e10cSrcweir * The following method tests are to be completed successfully before : 163*cdf0e10cSrcweir * <ul> 164*cdf0e10cSrcweir * <li> <code> afterLast </code> : to position cursor after 165*cdf0e10cSrcweir * the last row. </li> 166*cdf0e10cSrcweir * </ul> 167*cdf0e10cSrcweir */ 168*cdf0e10cSrcweir public void _isAfterLast() { 169*cdf0e10cSrcweir requiredMethod("afterLast()") ; 170*cdf0e10cSrcweir 171*cdf0e10cSrcweir boolean result = true ; 172*cdf0e10cSrcweir 173*cdf0e10cSrcweir try { 174*cdf0e10cSrcweir result = oObj.isAfterLast() ; 175*cdf0e10cSrcweir } catch (SQLException e) { 176*cdf0e10cSrcweir log.println("Exception occured :") ; 177*cdf0e10cSrcweir e.printStackTrace(log) ; 178*cdf0e10cSrcweir result = false ; 179*cdf0e10cSrcweir } 180*cdf0e10cSrcweir tRes.tested("isAfterLast()", result) ; 181*cdf0e10cSrcweir } 182*cdf0e10cSrcweir 183*cdf0e10cSrcweir /** 184*cdf0e10cSrcweir * Places the cursor on the first row. <p> 185*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 186*cdf0e10cSrcweir */ 187*cdf0e10cSrcweir public void _first() { 188*cdf0e10cSrcweir try { 189*cdf0e10cSrcweir oObj.first() ; 190*cdf0e10cSrcweir } catch (SQLException e) { 191*cdf0e10cSrcweir log.println("Exception occured :") ; 192*cdf0e10cSrcweir e.printStackTrace(log) ; 193*cdf0e10cSrcweir tRes.tested("first()", false) ; 194*cdf0e10cSrcweir return ; 195*cdf0e10cSrcweir } 196*cdf0e10cSrcweir tRes.tested("first()", true) ; 197*cdf0e10cSrcweir } 198*cdf0e10cSrcweir 199*cdf0e10cSrcweir /** 200*cdf0e10cSrcweir * The method is called immediatly after <code>first</code> 201*cdf0e10cSrcweir * method test. <p> 202*cdf0e10cSrcweir * Has <b>OK</b> status if method returns <code>true</code>. <p> 203*cdf0e10cSrcweir * The following method tests are to be completed successfully before : 204*cdf0e10cSrcweir * <ul> 205*cdf0e10cSrcweir * <li> <code> first </code> : to position cursor on 206*cdf0e10cSrcweir * the first row. </li> 207*cdf0e10cSrcweir * </ul> 208*cdf0e10cSrcweir */ 209*cdf0e10cSrcweir public void _isFirst() { 210*cdf0e10cSrcweir requiredMethod("first()") ; 211*cdf0e10cSrcweir 212*cdf0e10cSrcweir boolean result = true ; 213*cdf0e10cSrcweir 214*cdf0e10cSrcweir try { 215*cdf0e10cSrcweir result = oObj.isFirst() ; 216*cdf0e10cSrcweir } catch (SQLException e) { 217*cdf0e10cSrcweir log.println("Exception occured :") ; 218*cdf0e10cSrcweir e.printStackTrace(log) ; 219*cdf0e10cSrcweir result = false ; 220*cdf0e10cSrcweir } 221*cdf0e10cSrcweir tRes.tested("isFirst()", result) ; 222*cdf0e10cSrcweir } 223*cdf0e10cSrcweir 224*cdf0e10cSrcweir /** 225*cdf0e10cSrcweir * Places the cursor on the last row. <p> 226*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 227*cdf0e10cSrcweir */ 228*cdf0e10cSrcweir public void _last() { 229*cdf0e10cSrcweir try { 230*cdf0e10cSrcweir oObj.last() ; 231*cdf0e10cSrcweir } catch (SQLException e) { 232*cdf0e10cSrcweir log.println("Exception occured :") ; 233*cdf0e10cSrcweir e.printStackTrace(log) ; 234*cdf0e10cSrcweir tRes.tested("last()", false) ; 235*cdf0e10cSrcweir return ; 236*cdf0e10cSrcweir } 237*cdf0e10cSrcweir tRes.tested("last()", true) ; 238*cdf0e10cSrcweir } 239*cdf0e10cSrcweir 240*cdf0e10cSrcweir /** 241*cdf0e10cSrcweir * The method is called immediatly after <code>last</code> 242*cdf0e10cSrcweir * method test. <p> 243*cdf0e10cSrcweir * Has <b>OK</b> status if method returns <code>true</code>. <p> 244*cdf0e10cSrcweir * The following method tests are to be completed successfully before : 245*cdf0e10cSrcweir * <ul> 246*cdf0e10cSrcweir * <li> <code> last </code> : to position cursor on 247*cdf0e10cSrcweir * the last row. </li> 248*cdf0e10cSrcweir * </ul> 249*cdf0e10cSrcweir */ 250*cdf0e10cSrcweir public void _isLast() { 251*cdf0e10cSrcweir requiredMethod("last()") ; 252*cdf0e10cSrcweir boolean result = true ; 253*cdf0e10cSrcweir 254*cdf0e10cSrcweir try { 255*cdf0e10cSrcweir result = oObj.isLast() ; 256*cdf0e10cSrcweir } catch (SQLException e) { 257*cdf0e10cSrcweir log.println("Exception occured :") ; 258*cdf0e10cSrcweir e.printStackTrace(log) ; 259*cdf0e10cSrcweir result = false ; 260*cdf0e10cSrcweir } 261*cdf0e10cSrcweir tRes.tested("isLast()", result) ; 262*cdf0e10cSrcweir } 263*cdf0e10cSrcweir 264*cdf0e10cSrcweir /** 265*cdf0e10cSrcweir * Places the cursor on the row number 1. <p> 266*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 267*cdf0e10cSrcweir */ 268*cdf0e10cSrcweir public void _absolute() { 269*cdf0e10cSrcweir boolean result = true ; 270*cdf0e10cSrcweir 271*cdf0e10cSrcweir try { 272*cdf0e10cSrcweir oObj.absolute(1) ; 273*cdf0e10cSrcweir } catch (SQLException e) { 274*cdf0e10cSrcweir log.println("Exception occured :") ; 275*cdf0e10cSrcweir e.printStackTrace(log) ; 276*cdf0e10cSrcweir result = false ; 277*cdf0e10cSrcweir } 278*cdf0e10cSrcweir tRes.tested("absolute()", result) ; 279*cdf0e10cSrcweir } 280*cdf0e10cSrcweir 281*cdf0e10cSrcweir /** 282*cdf0e10cSrcweir * The method is called immediatly after <code>absolute</code> 283*cdf0e10cSrcweir * method test. <p> 284*cdf0e10cSrcweir * Has <b>OK</b> status if method returns 1. <p> 285*cdf0e10cSrcweir * The following method tests are to be completed successfully before : 286*cdf0e10cSrcweir * <ul> 287*cdf0e10cSrcweir * <li> <code> absolute </code> : to position cursor on 288*cdf0e10cSrcweir * the row number 1. </li> 289*cdf0e10cSrcweir * </ul> 290*cdf0e10cSrcweir */ 291*cdf0e10cSrcweir public void _getRow() { 292*cdf0e10cSrcweir requiredMethod("absolute()"); 293*cdf0e10cSrcweir boolean result = true; 294*cdf0e10cSrcweir 295*cdf0e10cSrcweir try { 296*cdf0e10cSrcweir result &= oObj.getRow() == 1; 297*cdf0e10cSrcweir } catch (SQLException e) { 298*cdf0e10cSrcweir log.println("Exception occured:"); 299*cdf0e10cSrcweir e.printStackTrace(log); 300*cdf0e10cSrcweir result = false; 301*cdf0e10cSrcweir } 302*cdf0e10cSrcweir 303*cdf0e10cSrcweir tRes.tested("getRow()", result); 304*cdf0e10cSrcweir } 305*cdf0e10cSrcweir 306*cdf0e10cSrcweir /** 307*cdf0e10cSrcweir * Positions the cursor to the next row. Current row 308*cdf0e10cSrcweir * number is retrieved before and after method call. <p> 309*cdf0e10cSrcweir * Has <b>OK</b> status if current row number increases 310*cdf0e10cSrcweir * by 1 after method call. 311*cdf0e10cSrcweir */ 312*cdf0e10cSrcweir public void _next() { 313*cdf0e10cSrcweir boolean result = true ; 314*cdf0e10cSrcweir 315*cdf0e10cSrcweir try { 316*cdf0e10cSrcweir int prevRow = oObj.getRow() ; 317*cdf0e10cSrcweir oObj.next() ; 318*cdf0e10cSrcweir 319*cdf0e10cSrcweir log.println("Row was : " + prevRow + ", row is : " + oObj.getRow()); 320*cdf0e10cSrcweir result &= prevRow + 1 == oObj.getRow() ; 321*cdf0e10cSrcweir } catch (SQLException e) { 322*cdf0e10cSrcweir log.println("Exception occured :") ; 323*cdf0e10cSrcweir e.printStackTrace(log) ; 324*cdf0e10cSrcweir result = false ; 325*cdf0e10cSrcweir } 326*cdf0e10cSrcweir tRes.tested("next()", result) ; 327*cdf0e10cSrcweir } 328*cdf0e10cSrcweir 329*cdf0e10cSrcweir /** 330*cdf0e10cSrcweir * Positions the cursor to the previous row. Current row 331*cdf0e10cSrcweir * number is retrieved before and after method call. <p> 332*cdf0e10cSrcweir * Has <b>OK</b> status if current row number decreases 333*cdf0e10cSrcweir * by 1 after method call. 334*cdf0e10cSrcweir */ 335*cdf0e10cSrcweir public void _previous() { 336*cdf0e10cSrcweir boolean result = true ; 337*cdf0e10cSrcweir 338*cdf0e10cSrcweir try { 339*cdf0e10cSrcweir int prevRow = oObj.getRow() ; 340*cdf0e10cSrcweir oObj.previous() ; 341*cdf0e10cSrcweir 342*cdf0e10cSrcweir log.println("Row was : " + prevRow + ", row is : " + oObj.getRow()); 343*cdf0e10cSrcweir result &= prevRow - 1 == oObj.getRow() ; 344*cdf0e10cSrcweir } catch (SQLException e) { 345*cdf0e10cSrcweir log.println("Exception occured :") ; 346*cdf0e10cSrcweir e.printStackTrace(log) ; 347*cdf0e10cSrcweir result = false ; 348*cdf0e10cSrcweir } 349*cdf0e10cSrcweir tRes.tested("previous()", result) ; 350*cdf0e10cSrcweir } 351*cdf0e10cSrcweir 352*cdf0e10cSrcweir /** 353*cdf0e10cSrcweir * Positions the cursor relatively by 2 rows forward. 354*cdf0e10cSrcweir * Current row number is retrieved before and after method call. <p> 355*cdf0e10cSrcweir * Has <b>OK</b> status if current row number increases 356*cdf0e10cSrcweir * by 2 after method call. 357*cdf0e10cSrcweir */ 358*cdf0e10cSrcweir public void _relative() { 359*cdf0e10cSrcweir boolean result = true ; 360*cdf0e10cSrcweir 361*cdf0e10cSrcweir try { 362*cdf0e10cSrcweir oObj.first() ; 363*cdf0e10cSrcweir int prevRow = oObj.getRow() ; 364*cdf0e10cSrcweir oObj.relative(2) ; 365*cdf0e10cSrcweir 366*cdf0e10cSrcweir log.println("Row was : " + prevRow + ", row is : " + oObj.getRow()); 367*cdf0e10cSrcweir 368*cdf0e10cSrcweir result &= prevRow + 2 == oObj.getRow() ; 369*cdf0e10cSrcweir } catch (SQLException e) { 370*cdf0e10cSrcweir log.println("Exception occured :") ; 371*cdf0e10cSrcweir e.printStackTrace(log) ; 372*cdf0e10cSrcweir result = false ; 373*cdf0e10cSrcweir } 374*cdf0e10cSrcweir tRes.tested("relative()", result) ; 375*cdf0e10cSrcweir } 376*cdf0e10cSrcweir 377*cdf0e10cSrcweir /** 378*cdf0e10cSrcweir * If component supports XRow and XRowUpdate then: 379*cdf0e10cSrcweir * test saves current value of string field, updates string, 380*cdf0e10cSrcweir * calls refreshRow() and checks that value of 381*cdf0e10cSrcweir * string field was refetched from DB 382*cdf0e10cSrcweir * else: just calls method.<p> 383*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown and value after 384*cdf0e10cSrcweir * refreshRow() equals to saved value. 385*cdf0e10cSrcweir */ 386*cdf0e10cSrcweir public void _refreshRow() { 387*cdf0e10cSrcweir XRowUpdate xRowUpdate = (XRowUpdate) 388*cdf0e10cSrcweir UnoRuntime.queryInterface(XRowUpdate.class, oObj); 389*cdf0e10cSrcweir XRow xRow = (XRow)UnoRuntime.queryInterface(XRow.class, oObj); 390*cdf0e10cSrcweir 391*cdf0e10cSrcweir if (xRowUpdate == null || xRow == null) { 392*cdf0e10cSrcweir log.println("Test must be modified because XRow or XRowUpdate is't supported"); 393*cdf0e10cSrcweir log.println("Only call method"); 394*cdf0e10cSrcweir try { 395*cdf0e10cSrcweir oObj.refreshRow() ; 396*cdf0e10cSrcweir tRes.tested("refreshRow()", true) ; 397*cdf0e10cSrcweir } catch (SQLException e) { 398*cdf0e10cSrcweir log.println("Exception occured :") ; 399*cdf0e10cSrcweir e.printStackTrace(log) ; 400*cdf0e10cSrcweir tRes.tested("refreshRow()", false) ; 401*cdf0e10cSrcweir } 402*cdf0e10cSrcweir } else { 403*cdf0e10cSrcweir log.println("Testing of refreshRow()..."); 404*cdf0e10cSrcweir try { 405*cdf0e10cSrcweir String oldValue = xRow.getString(util.DBTools.TST_STRING); 406*cdf0e10cSrcweir log.println("Old value: " + oldValue); 407*cdf0e10cSrcweir xRowUpdate.updateString(util.DBTools.TST_STRING, 408*cdf0e10cSrcweir "Test method refreshRow"); 409*cdf0e10cSrcweir log.println("New value: " 410*cdf0e10cSrcweir + xRow.getString(util.DBTools.TST_STRING)); 411*cdf0e10cSrcweir oObj.refreshRow(); 412*cdf0e10cSrcweir String valAfterRefresh = 413*cdf0e10cSrcweir xRow.getString(util.DBTools.TST_STRING); 414*cdf0e10cSrcweir log.println("Value after refresh: " + valAfterRefresh); 415*cdf0e10cSrcweir tRes.tested("refreshRow()", valAfterRefresh.equals(oldValue)); 416*cdf0e10cSrcweir } catch(SQLException e) { 417*cdf0e10cSrcweir log.println("Exception occured :"); 418*cdf0e10cSrcweir e.printStackTrace(log); 419*cdf0e10cSrcweir tRes.tested("refreshRow()", false); 420*cdf0e10cSrcweir } 421*cdf0e10cSrcweir } 422*cdf0e10cSrcweir } 423*cdf0e10cSrcweir 424*cdf0e10cSrcweir /** 425*cdf0e10cSrcweir * Just the method is called. <p> 426*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 427*cdf0e10cSrcweir */ 428*cdf0e10cSrcweir public void _rowUpdated() { 429*cdf0e10cSrcweir 430*cdf0e10cSrcweir try { 431*cdf0e10cSrcweir boolean res = oObj.rowUpdated() ; 432*cdf0e10cSrcweir tRes.tested("rowUpdated()", true) ; 433*cdf0e10cSrcweir } catch (SQLException e) { 434*cdf0e10cSrcweir log.println("Exception occured :") ; 435*cdf0e10cSrcweir e.printStackTrace(log) ; 436*cdf0e10cSrcweir tRes.tested("rowUpdated()", false) ; 437*cdf0e10cSrcweir } 438*cdf0e10cSrcweir } 439*cdf0e10cSrcweir 440*cdf0e10cSrcweir /** 441*cdf0e10cSrcweir * Just the method is called. <p> 442*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 443*cdf0e10cSrcweir */ 444*cdf0e10cSrcweir public void _rowInserted() { 445*cdf0e10cSrcweir try { 446*cdf0e10cSrcweir boolean res = oObj.rowInserted() ; 447*cdf0e10cSrcweir tRes.tested("rowInserted()", true) ; 448*cdf0e10cSrcweir } catch (SQLException e) { 449*cdf0e10cSrcweir log.println("Exception occured :") ; 450*cdf0e10cSrcweir e.printStackTrace(log) ; 451*cdf0e10cSrcweir tRes.tested("rowInserted()", false) ; 452*cdf0e10cSrcweir } 453*cdf0e10cSrcweir } 454*cdf0e10cSrcweir 455*cdf0e10cSrcweir /** 456*cdf0e10cSrcweir * Just the method is called. <p> 457*cdf0e10cSrcweir * Has <b>OK</b> status if no exceptions were thrown. 458*cdf0e10cSrcweir */ 459*cdf0e10cSrcweir public void _rowDeleted() { 460*cdf0e10cSrcweir try { 461*cdf0e10cSrcweir boolean res = oObj.rowDeleted() ; 462*cdf0e10cSrcweir tRes.tested("rowDeleted()", true) ; 463*cdf0e10cSrcweir } catch (SQLException e) { 464*cdf0e10cSrcweir log.println("Exception occured :") ; 465*cdf0e10cSrcweir e.printStackTrace(log) ; 466*cdf0e10cSrcweir tRes.tested("rowDeleted()", false) ; 467*cdf0e10cSrcweir } 468*cdf0e10cSrcweir } 469*cdf0e10cSrcweir 470*cdf0e10cSrcweir /** 471*cdf0e10cSrcweir * Just the method is called. <p> 472*cdf0e10cSrcweir * Has <b>OK</b> status if the statement returned isn't null or 473*cdf0e10cSrcweir * the relation exists that informs that statement absent (e.g. for 474*cdf0e10cSrcweir * MetaData row set). 475*cdf0e10cSrcweir */ 476*cdf0e10cSrcweir public void _getStatement() { 477*cdf0e10cSrcweir try { 478*cdf0e10cSrcweir boolean hasStatement = 479*cdf0e10cSrcweir tEnv.getObjRelation("XResultSet.hasStatement") != null ; 480*cdf0e10cSrcweir Object res = oObj.getStatement() ; 481*cdf0e10cSrcweir tRes.tested("getStatement()", 482*cdf0e10cSrcweir (hasStatement && res != null) || !hasStatement) ; 483*cdf0e10cSrcweir } catch (SQLException e) { 484*cdf0e10cSrcweir log.println("Exception occured :") ; 485*cdf0e10cSrcweir e.printStackTrace(log) ; 486*cdf0e10cSrcweir tRes.tested("getStatement()", false) ; 487*cdf0e10cSrcweir } 488*cdf0e10cSrcweir } 489*cdf0e10cSrcweir 490*cdf0e10cSrcweir /** 491*cdf0e10cSrcweir * Moves the cursor to the first row to avoid affection to 492*cdf0e10cSrcweir * the following interfaces tests 493*cdf0e10cSrcweir */ 494*cdf0e10cSrcweir public void after() { 495*cdf0e10cSrcweir log.println("Finally moving cursor to the first row ..."); 496*cdf0e10cSrcweir try { 497*cdf0e10cSrcweir oObj.first(); 498*cdf0e10cSrcweir } catch (SQLException e) { 499*cdf0e10cSrcweir log.println("Exception occured :") ; 500*cdf0e10cSrcweir e.printStackTrace(log) ; 501*cdf0e10cSrcweir } 502*cdf0e10cSrcweir } 503*cdf0e10cSrcweir 504*cdf0e10cSrcweir } // finish class _XResultSet 505*cdf0e10cSrcweir 506