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.sdbcx; 29*cdf0e10cSrcweir 30*cdf0e10cSrcweir import lib.MultiMethodTest; 31*cdf0e10cSrcweir import lib.Status; 32*cdf0e10cSrcweir import lib.StatusException; 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir import com.sun.star.sdbc.XResultSet; 35*cdf0e10cSrcweir import com.sun.star.sdbcx.XDeleteRows; 36*cdf0e10cSrcweir import com.sun.star.sdbcx.XRowLocate; 37*cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 38*cdf0e10cSrcweir 39*cdf0e10cSrcweir /** 40*cdf0e10cSrcweir * Testing <code>com.sun.star.sdbcx.XDeleteRows</code> 41*cdf0e10cSrcweir * interface methods : 42*cdf0e10cSrcweir * <ul> 43*cdf0e10cSrcweir * <li><code> deleteRows()</code></li> 44*cdf0e10cSrcweir * </ul> <p> 45*cdf0e10cSrcweir * @see com.sun.star.sdbcx.XDeleteRows 46*cdf0e10cSrcweir */ 47*cdf0e10cSrcweir public class _XDeleteRows extends MultiMethodTest { 48*cdf0e10cSrcweir // oObj filled by MultiMethodTest 49*cdf0e10cSrcweir public XDeleteRows oObj = null ; 50*cdf0e10cSrcweir 51*cdf0e10cSrcweir /** 52*cdf0e10cSrcweir * Retrieves bookmark using XRowLocate and deletes 53*cdf0e10cSrcweir * row pointed by this bookmark. <p> 54*cdf0e10cSrcweir * Has OK status if number of rows after deleting is less than before 55*cdf0e10cSrcweir * and no exception rizes while method call, FAILED otherwise. <p> 56*cdf0e10cSrcweir */ 57*cdf0e10cSrcweir public void _deleteRows() { 58*cdf0e10cSrcweir XRowLocate xRowLocate = (XRowLocate) 59*cdf0e10cSrcweir UnoRuntime.queryInterface(XRowLocate.class, oObj); 60*cdf0e10cSrcweir XResultSet xResultSet = (XResultSet) 61*cdf0e10cSrcweir UnoRuntime.queryInterface(XResultSet.class, oObj); 62*cdf0e10cSrcweir if (xRowLocate == null || xResultSet == null) { 63*cdf0e10cSrcweir log.println("The test must be modified according to "+ 64*cdf0e10cSrcweir "component testcase"); 65*cdf0e10cSrcweir throw new StatusException(Status.failed( 66*cdf0e10cSrcweir "The component doesn't support one of the "+ 67*cdf0e10cSrcweir "required interfaces")); 68*cdf0e10cSrcweir } 69*cdf0e10cSrcweir 70*cdf0e10cSrcweir int rowsBefore = 0, rowsAfter = 0; 71*cdf0e10cSrcweir Object bkmrk = null; 72*cdf0e10cSrcweir try { 73*cdf0e10cSrcweir xResultSet.last(); 74*cdf0e10cSrcweir rowsBefore = xResultSet.getRow(); 75*cdf0e10cSrcweir xResultSet.first(); 76*cdf0e10cSrcweir bkmrk = xRowLocate.getBookmark(); 77*cdf0e10cSrcweir oObj.deleteRows(new Object[] {bkmrk}); 78*cdf0e10cSrcweir xResultSet.last(); 79*cdf0e10cSrcweir rowsAfter = xResultSet.getRow(); 80*cdf0e10cSrcweir } catch(com.sun.star.sdbc.SQLException e) { 81*cdf0e10cSrcweir log.println("SQLException:" + e); 82*cdf0e10cSrcweir tRes.tested("deleteRows()", false); 83*cdf0e10cSrcweir return; 84*cdf0e10cSrcweir } 85*cdf0e10cSrcweir 86*cdf0e10cSrcweir log.println("Rows before: " + rowsBefore + ", after: " + rowsAfter); 87*cdf0e10cSrcweir tRes.tested("deleteRows()", rowsBefore - 1 == rowsAfter); 88*cdf0e10cSrcweir } 89*cdf0e10cSrcweir 90*cdf0e10cSrcweir protected void after() { 91*cdf0e10cSrcweir disposeEnvironment(); 92*cdf0e10cSrcweir } 93*cdf0e10cSrcweir } // finish class _XDeleteRows 94*cdf0e10cSrcweir 95