1*b1cdbd2cSJim Jagielski /************************************************************** 2*b1cdbd2cSJim Jagielski * 3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski * distributed with this work for additional information 6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski * 11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski * 13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski * under the License. 19*b1cdbd2cSJim Jagielski * 20*b1cdbd2cSJim Jagielski *************************************************************/ 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski package ifc.sdbc; 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski import lib.MultiMethodTest; 27*b1cdbd2cSJim Jagielski import lib.StatusException; 28*b1cdbd2cSJim Jagielski 29*b1cdbd2cSJim Jagielski import com.sun.star.sdbc.SQLException; 30*b1cdbd2cSJim Jagielski import com.sun.star.sdbc.XResultSetUpdate; 31*b1cdbd2cSJim Jagielski import com.sun.star.sdbc.XRowUpdate; 32*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 33*b1cdbd2cSJim Jagielski 34*b1cdbd2cSJim Jagielski /** 35*b1cdbd2cSJim Jagielski /** 36*b1cdbd2cSJim Jagielski * Testing <code>com.sun.star.sdbc.XResultSetUpdate</code> 37*b1cdbd2cSJim Jagielski * interface methods : 38*b1cdbd2cSJim Jagielski * <ul> 39*b1cdbd2cSJim Jagielski * <li><code> insertRow()</code></li> 40*b1cdbd2cSJim Jagielski * <li><code> updateRow()</code></li> 41*b1cdbd2cSJim Jagielski * <li><code> deleteRow()</code></li> 42*b1cdbd2cSJim Jagielski * <li><code> cancelRowUpdates()</code></li> 43*b1cdbd2cSJim Jagielski * <li><code> moveToInsertRow()</code></li> 44*b1cdbd2cSJim Jagielski * <li><code> moveToCurrentRow()</code></li> 45*b1cdbd2cSJim Jagielski * </ul> <p> 46*b1cdbd2cSJim Jagielski * The test requires the following object relations : 47*b1cdbd2cSJim Jagielski * <ul> 48*b1cdbd2cSJim Jagielski * <li><code>'XResultSetUpdate.UpdateTester'</code> 49*b1cdbd2cSJim Jagielski * inner <code>UpdateTester</code> interface implementation : 50*b1cdbd2cSJim Jagielski * is used for checking test results. See interface 51*b1cdbd2cSJim Jagielski * documentation for more information.</li> 52*b1cdbd2cSJim Jagielski * </ul> 53*b1cdbd2cSJim Jagielski * The test is <b>not designed</b> for multithreaded testing. <p> 54*b1cdbd2cSJim Jagielski * After it's execution environment must be recreated. 55*b1cdbd2cSJim Jagielski * @see com.sun.star.sdbc.XResultSetUpdate 56*b1cdbd2cSJim Jagielski */ 57*b1cdbd2cSJim Jagielski public class _XResultSetUpdate extends MultiMethodTest { 58*b1cdbd2cSJim Jagielski 59*b1cdbd2cSJim Jagielski // oObj filled by MultiMethodTest 60*b1cdbd2cSJim Jagielski public XResultSetUpdate oObj = null ; 61*b1cdbd2cSJim Jagielski 62*b1cdbd2cSJim Jagielski private UpdateTester tester = null ; 63*b1cdbd2cSJim Jagielski 64*b1cdbd2cSJim Jagielski /** 65*b1cdbd2cSJim Jagielski * Interface contains some methods for checking 66*b1cdbd2cSJim Jagielski * test results. It's implementation must be passed 67*b1cdbd2cSJim Jagielski * to this test. 68*b1cdbd2cSJim Jagielski */ 69*b1cdbd2cSJim Jagielski public static interface UpdateTester { 70*b1cdbd2cSJim Jagielski /** 71*b1cdbd2cSJim Jagielski * @return Current number of rows. 72*b1cdbd2cSJim Jagielski */ rowCount()73*b1cdbd2cSJim Jagielski public int rowCount() throws SQLException ; 74*b1cdbd2cSJim Jagielski /** 75*b1cdbd2cSJim Jagielski * Updates some data in the current row but doesn't commit 76*b1cdbd2cSJim Jagielski * changes to the source. 77*b1cdbd2cSJim Jagielski */ update()78*b1cdbd2cSJim Jagielski public void update() throws SQLException ; 79*b1cdbd2cSJim Jagielski /** 80*b1cdbd2cSJim Jagielski * Checks if updates made by method <code>update</code> was 81*b1cdbd2cSJim Jagielski * commited to the data source. 82*b1cdbd2cSJim Jagielski */ wasUpdated()83*b1cdbd2cSJim Jagielski public boolean wasUpdated() throws SQLException ; 84*b1cdbd2cSJim Jagielski /** 85*b1cdbd2cSJim Jagielski * Returns current row number. Really it must returns value 86*b1cdbd2cSJim Jagielski * < 1 if the current position is on insert row. 87*b1cdbd2cSJim Jagielski */ currentRow()88*b1cdbd2cSJim Jagielski public int currentRow() throws SQLException ; 89*b1cdbd2cSJim Jagielski } 90*b1cdbd2cSJim Jagielski 91*b1cdbd2cSJim Jagielski /** 92*b1cdbd2cSJim Jagielski * Retrieves relation. 93*b1cdbd2cSJim Jagielski * @throw StatusException If relation not found. 94*b1cdbd2cSJim Jagielski */ before()95*b1cdbd2cSJim Jagielski public void before() throws StatusException { 96*b1cdbd2cSJim Jagielski tester = (UpdateTester)tEnv.getObjRelation 97*b1cdbd2cSJim Jagielski ("XResultSetUpdate.UpdateTester") ; 98*b1cdbd2cSJim Jagielski 99*b1cdbd2cSJim Jagielski if (tester == null) { 100*b1cdbd2cSJim Jagielski log.println("Required relation not found !!!") ; 101*b1cdbd2cSJim Jagielski throw new StatusException("Required relation not found !!!", 102*b1cdbd2cSJim Jagielski new NullPointerException()) ; 103*b1cdbd2cSJim Jagielski } 104*b1cdbd2cSJim Jagielski } 105*b1cdbd2cSJim Jagielski 106*b1cdbd2cSJim Jagielski /** 107*b1cdbd2cSJim Jagielski * Calls method when the cursor position is on existing row. 108*b1cdbd2cSJim Jagielski * Checks total number of rows before and after method call. <p> 109*b1cdbd2cSJim Jagielski * Executes <code>moveToCurrentRow</code> method test before to 110*b1cdbd2cSJim Jagielski * be sure that cursor is not on the insert row. <p> 111*b1cdbd2cSJim Jagielski * Has OK status if after method execution number of rows decreased 112*b1cdbd2cSJim Jagielski * by one. 113*b1cdbd2cSJim Jagielski */ _deleteRow()114*b1cdbd2cSJim Jagielski public void _deleteRow() { 115*b1cdbd2cSJim Jagielski executeMethod("moveToCurrentRow()") ; 116*b1cdbd2cSJim Jagielski 117*b1cdbd2cSJim Jagielski //temporary to avoid SOffice hanging 118*b1cdbd2cSJim Jagielski executeMethod("updateRow()") ; 119*b1cdbd2cSJim Jagielski executeMethod("cancelRowUpdates()") ; 120*b1cdbd2cSJim Jagielski 121*b1cdbd2cSJim Jagielski boolean result = true ; 122*b1cdbd2cSJim Jagielski try { 123*b1cdbd2cSJim Jagielski int rowsBefore = tester.rowCount() ; 124*b1cdbd2cSJim Jagielski oObj.deleteRow() ; 125*b1cdbd2cSJim Jagielski int rowsAfter = tester.rowCount() ; 126*b1cdbd2cSJim Jagielski 127*b1cdbd2cSJim Jagielski result = rowsBefore == rowsAfter + 1 ; 128*b1cdbd2cSJim Jagielski } catch (SQLException e) { 129*b1cdbd2cSJim Jagielski e.printStackTrace(log) ; 130*b1cdbd2cSJim Jagielski result = false ; 131*b1cdbd2cSJim Jagielski } 132*b1cdbd2cSJim Jagielski 133*b1cdbd2cSJim Jagielski tRes.tested("deleteRow()", result) ; 134*b1cdbd2cSJim Jagielski } 135*b1cdbd2cSJim Jagielski 136*b1cdbd2cSJim Jagielski /** 137*b1cdbd2cSJim Jagielski * Using relation methods first updates some data in the current 138*b1cdbd2cSJim Jagielski * row, then calls <code>updateRow</code> method to commit data. 139*b1cdbd2cSJim Jagielski * Then checks if the data changed was commited. <p> 140*b1cdbd2cSJim Jagielski * Executes <code>moveToCurrentRow</code> method test before to 141*b1cdbd2cSJim Jagielski * be sure that cursor is not on the insert row. <p> 142*b1cdbd2cSJim Jagielski * Has OK status if data in the source was changed. 143*b1cdbd2cSJim Jagielski */ _updateRow()144*b1cdbd2cSJim Jagielski public void _updateRow() { 145*b1cdbd2cSJim Jagielski executeMethod("moveToCurrentRow()") ; 146*b1cdbd2cSJim Jagielski boolean result = true ; 147*b1cdbd2cSJim Jagielski try { 148*b1cdbd2cSJim Jagielski tester.update() ; 149*b1cdbd2cSJim Jagielski oObj.updateRow() ; 150*b1cdbd2cSJim Jagielski 151*b1cdbd2cSJim Jagielski result = tester.wasUpdated() ; 152*b1cdbd2cSJim Jagielski } catch (SQLException e) { 153*b1cdbd2cSJim Jagielski e.printStackTrace(log) ; 154*b1cdbd2cSJim Jagielski result = false ; 155*b1cdbd2cSJim Jagielski } 156*b1cdbd2cSJim Jagielski tRes.tested("updateRow()", result) ; 157*b1cdbd2cSJim Jagielski } 158*b1cdbd2cSJim Jagielski 159*b1cdbd2cSJim Jagielski /** 160*b1cdbd2cSJim Jagielski * Using relation methods first updates some data in the current 161*b1cdbd2cSJim Jagielski * row, then calls <code>cancelRowUpdates</code> method. 162*b1cdbd2cSJim Jagielski * Then checks if the data changed was not commited. <p> 163*b1cdbd2cSJim Jagielski * Executes <code>moveToCurrentRow</code> method test before to 164*b1cdbd2cSJim Jagielski * be sure that cursor is not on the insert row. <p> 165*b1cdbd2cSJim Jagielski * Has OK status if data in the source was not changed. 166*b1cdbd2cSJim Jagielski */ _cancelRowUpdates()167*b1cdbd2cSJim Jagielski public void _cancelRowUpdates() { 168*b1cdbd2cSJim Jagielski executeMethod("moveToCurrentRow()") ; 169*b1cdbd2cSJim Jagielski boolean result = true ; 170*b1cdbd2cSJim Jagielski try { 171*b1cdbd2cSJim Jagielski tester.update() ; 172*b1cdbd2cSJim Jagielski oObj.cancelRowUpdates() ; 173*b1cdbd2cSJim Jagielski 174*b1cdbd2cSJim Jagielski result = !tester.wasUpdated() ; 175*b1cdbd2cSJim Jagielski } catch (SQLException e) { 176*b1cdbd2cSJim Jagielski e.printStackTrace(log) ; 177*b1cdbd2cSJim Jagielski result = false ; 178*b1cdbd2cSJim Jagielski } 179*b1cdbd2cSJim Jagielski tRes.tested("cancelRowUpdates()", result) ; 180*b1cdbd2cSJim Jagielski } 181*b1cdbd2cSJim Jagielski 182*b1cdbd2cSJim Jagielski /** 183*b1cdbd2cSJim Jagielski * Tries to move cursor to insert row. Then checks current row 184*b1cdbd2cSJim Jagielski * number. It must be less than 1. (0 as I know) <p> 185*b1cdbd2cSJim Jagielski */ _moveToInsertRow()186*b1cdbd2cSJim Jagielski public void _moveToInsertRow() { 187*b1cdbd2cSJim Jagielski boolean result = true ; 188*b1cdbd2cSJim Jagielski try { 189*b1cdbd2cSJim Jagielski oObj.moveToInsertRow() ; 190*b1cdbd2cSJim Jagielski 191*b1cdbd2cSJim Jagielski result = tester.currentRow() < 1 ; 192*b1cdbd2cSJim Jagielski } catch (SQLException e) { 193*b1cdbd2cSJim Jagielski e.printStackTrace(log) ; 194*b1cdbd2cSJim Jagielski result = false ; 195*b1cdbd2cSJim Jagielski } 196*b1cdbd2cSJim Jagielski tRes.tested("moveToInsertRow()", result) ; 197*b1cdbd2cSJim Jagielski } 198*b1cdbd2cSJim Jagielski 199*b1cdbd2cSJim Jagielski /** 200*b1cdbd2cSJim Jagielski * Returns cursor from insert row back to previous row. <p> 201*b1cdbd2cSJim Jagielski * <code>moveToInsertRow</code> method test must be executed 202*b1cdbd2cSJim Jagielski * first for positioning curosr to insert row. <p> 203*b1cdbd2cSJim Jagielski * Has OK status if after method call current row number is 204*b1cdbd2cSJim Jagielski * above 0. 205*b1cdbd2cSJim Jagielski */ 206*b1cdbd2cSJim Jagielski public void _moveToCurrentRow() { 207*b1cdbd2cSJim Jagielski boolean result = true ; 208*b1cdbd2cSJim Jagielski try { 209*b1cdbd2cSJim Jagielski oObj.moveToCurrentRow() ; 210*b1cdbd2cSJim Jagielski 211*b1cdbd2cSJim Jagielski result = tester.currentRow() >= 1 ; 212*b1cdbd2cSJim Jagielski } catch (SQLException e) { 213*b1cdbd2cSJim Jagielski e.printStackTrace(log) ; 214*b1cdbd2cSJim Jagielski result = false ; 215*b1cdbd2cSJim Jagielski } 216*b1cdbd2cSJim Jagielski tRes.tested("moveToCurrentRow()", result) ; 217*b1cdbd2cSJim Jagielski } 218*b1cdbd2cSJim Jagielski 219*b1cdbd2cSJim Jagielski /** 220*b1cdbd2cSJim Jagielski * Moves cursor to the insert row, then calls the method 221*b1cdbd2cSJim Jagielski * <code>insertRow</code>. Before and after call stores 222*b1cdbd2cSJim Jagielski * total number of rows. <p> 223*b1cdbd2cSJim Jagielski * Has OK status if after method call rows number increases 224*b1cdbd2cSJim Jagielski * by one. 225*b1cdbd2cSJim Jagielski */ _insertRow()226*b1cdbd2cSJim Jagielski public void _insertRow() { 227*b1cdbd2cSJim Jagielski executeMethod("moveToInsertRow()") ; 228*b1cdbd2cSJim Jagielski boolean result = true ; 229*b1cdbd2cSJim Jagielski try { 230*b1cdbd2cSJim Jagielski oObj.moveToCurrentRow(); 231*b1cdbd2cSJim Jagielski int rowsBefore = tester.rowCount() ; 232*b1cdbd2cSJim Jagielski oObj.moveToInsertRow() ; 233*b1cdbd2cSJim Jagielski XRowUpdate rowU = (XRowUpdate) 234*b1cdbd2cSJim Jagielski UnoRuntime.queryInterface(XRowUpdate.class, oObj); 235*b1cdbd2cSJim Jagielski rowU.updateString(1,"open"); 236*b1cdbd2cSJim Jagielski rowU.updateInt(2,5); 237*b1cdbd2cSJim Jagielski rowU.updateDouble(5,3.4); 238*b1cdbd2cSJim Jagielski rowU.updateBoolean(10,true); 239*b1cdbd2cSJim Jagielski oObj.insertRow() ; 240*b1cdbd2cSJim Jagielski oObj.moveToCurrentRow(); 241*b1cdbd2cSJim Jagielski int rowsAfter = tester.rowCount() ; 242*b1cdbd2cSJim Jagielski result = rowsBefore + 1 == rowsAfter ; 243*b1cdbd2cSJim Jagielski } catch (SQLException e) { 244*b1cdbd2cSJim Jagielski e.printStackTrace(log) ; 245*b1cdbd2cSJim Jagielski log.println("******"+e.getMessage()); 246*b1cdbd2cSJim Jagielski result = false ; 247*b1cdbd2cSJim Jagielski } 248*b1cdbd2cSJim Jagielski tRes.tested("insertRow()", result) ; 249*b1cdbd2cSJim Jagielski } 250*b1cdbd2cSJim Jagielski 251*b1cdbd2cSJim Jagielski /** 252*b1cdbd2cSJim Jagielski * Forces environment to be recreated. 253*b1cdbd2cSJim Jagielski */ after()254*b1cdbd2cSJim Jagielski public void after() { 255*b1cdbd2cSJim Jagielski //disposeEnvironment() ; 256*b1cdbd2cSJim Jagielski } 257*b1cdbd2cSJim Jagielski } // finish class _XResultSetUpdate 258*b1cdbd2cSJim Jagielski 259*b1cdbd2cSJim Jagielski 260