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 ifc.sdb._XRowSetApproveBroadcaster;
31*cdf0e10cSrcweir import lib.MultiMethodTest;
32*cdf0e10cSrcweir import lib.StatusException;
33*cdf0e10cSrcweir 
34*cdf0e10cSrcweir import com.sun.star.lang.EventObject;
35*cdf0e10cSrcweir import com.sun.star.sdbc.SQLException;
36*cdf0e10cSrcweir import com.sun.star.sdbc.XRowSet;
37*cdf0e10cSrcweir import com.sun.star.sdbc.XRowSetListener;
38*cdf0e10cSrcweir 
39*cdf0e10cSrcweir /**
40*cdf0e10cSrcweir * Testing <code>com.sun.star.sdbc.XRowSet</code>
41*cdf0e10cSrcweir * interface methods :
42*cdf0e10cSrcweir * <ul>
43*cdf0e10cSrcweir *  <li><code> execute()</code></li>
44*cdf0e10cSrcweir *  <li><code> addRowSetListener()</code></li>
45*cdf0e10cSrcweir *  <li><code> removeRowSetListener()</code></li>
46*cdf0e10cSrcweir * </ul> <p>
47*cdf0e10cSrcweir * Required object relations :
48*cdf0e10cSrcweir * <ul>
49*cdf0e10cSrcweir * <li> <code>'XRowSetApproveBroadcaster.ApproveChecker'</code>:
50*cdf0e10cSrcweir *      implementation of inner interface
51*cdf0e10cSrcweir *      <code>ifs.sdb._XRowSetApproveBroadcaster.RowSetApproveChecker</code>
52*cdf0e10cSrcweir *      which can move cursor within a rowset, change row, and change the
53*cdf0e10cSrcweir *      whole rowset. </li>
54*cdf0e10cSrcweir * </ul> <p>
55*cdf0e10cSrcweir * It is better to recreate the object after test, because of unknown
56*cdf0e10cSrcweir * actions made by <code>RowSetApproveChecker</code> interface implementation.
57*cdf0e10cSrcweir * @see com.sun.star.sdbc.XRowSet
58*cdf0e10cSrcweir * @see ifc.sdb._XRowSetApproveBroadcaster
59*cdf0e10cSrcweir */
60*cdf0e10cSrcweir public class _XRowSet extends MultiMethodTest {
61*cdf0e10cSrcweir 
62*cdf0e10cSrcweir     // oObj filled by MultiMethodTest
63*cdf0e10cSrcweir     public XRowSet oObj = null ;
64*cdf0e10cSrcweir     private _XRowSetApproveBroadcaster.RowSetApproveChecker checker = null ;
65*cdf0e10cSrcweir     private TestListener listener = new TestListener() ;
66*cdf0e10cSrcweir 
67*cdf0e10cSrcweir     private class TestListener implements XRowSetListener {
68*cdf0e10cSrcweir         public boolean cursorMoved = false ;
69*cdf0e10cSrcweir         public boolean rowChanged = false ;
70*cdf0e10cSrcweir         public boolean rowSetChanged = false ;
71*cdf0e10cSrcweir 
72*cdf0e10cSrcweir         public void reset() {
73*cdf0e10cSrcweir             cursorMoved = false ;
74*cdf0e10cSrcweir             rowChanged = false ;
75*cdf0e10cSrcweir             rowSetChanged = false ;
76*cdf0e10cSrcweir         }
77*cdf0e10cSrcweir         public void cursorMoved(EventObject ev) {
78*cdf0e10cSrcweir             cursorMoved = true ;
79*cdf0e10cSrcweir         }
80*cdf0e10cSrcweir         public void rowChanged(EventObject ev) {
81*cdf0e10cSrcweir             rowChanged = true ;
82*cdf0e10cSrcweir         }
83*cdf0e10cSrcweir         public void rowSetChanged(EventObject ev) {
84*cdf0e10cSrcweir             rowSetChanged = true ;
85*cdf0e10cSrcweir         }
86*cdf0e10cSrcweir         public void disposing(EventObject ev) {}
87*cdf0e10cSrcweir     }
88*cdf0e10cSrcweir 
89*cdf0e10cSrcweir     /**
90*cdf0e10cSrcweir     * Retrieves relation.
91*cdf0e10cSrcweir     * @throw StatusException If relation not found.
92*cdf0e10cSrcweir     */
93*cdf0e10cSrcweir     public void before() throws StatusException {
94*cdf0e10cSrcweir         checker = (_XRowSetApproveBroadcaster.RowSetApproveChecker)
95*cdf0e10cSrcweir             tEnv.getObjRelation("XRowSetApproveBroadcaster.ApproveChecker") ;
96*cdf0e10cSrcweir 
97*cdf0e10cSrcweir         if (checker == null) {
98*cdf0e10cSrcweir             log.println("Required relation not found !!!") ;
99*cdf0e10cSrcweir             throw new StatusException("Required relation not found !!!",
100*cdf0e10cSrcweir                 new NullPointerException()) ;
101*cdf0e10cSrcweir         }
102*cdf0e10cSrcweir     }
103*cdf0e10cSrcweir 
104*cdf0e10cSrcweir     /**
105*cdf0e10cSrcweir     * Reexecutes the RowSet and checks that listener was called. <p>
106*cdf0e10cSrcweir     * Has OK status if no exceptions were rised and listener was called.
107*cdf0e10cSrcweir     */
108*cdf0e10cSrcweir     public void _execute() {
109*cdf0e10cSrcweir         requiredMethod("addRowSetListener()");
110*cdf0e10cSrcweir         listener.reset();
111*cdf0e10cSrcweir         boolean result = true ;
112*cdf0e10cSrcweir 
113*cdf0e10cSrcweir         try {
114*cdf0e10cSrcweir             oObj.execute() ;
115*cdf0e10cSrcweir         } catch (SQLException e) {
116*cdf0e10cSrcweir             log.println("Exception occured :" + e) ;
117*cdf0e10cSrcweir             result = false ;
118*cdf0e10cSrcweir         }
119*cdf0e10cSrcweir 
120*cdf0e10cSrcweir         tRes.tested("execute()", listener.rowSetChanged);
121*cdf0e10cSrcweir     }
122*cdf0e10cSrcweir 
123*cdf0e10cSrcweir     /**
124*cdf0e10cSrcweir     * Adds listener and calls methods moveCursor, changeRow,
125*cdf0e10cSrcweir     * changeRowSet of the relation and then checks if appropriate
126*cdf0e10cSrcweir     * methods of the listener were called. <p>
127*cdf0e10cSrcweir     * Has OK status if all listener methods were called.
128*cdf0e10cSrcweir     */
129*cdf0e10cSrcweir     public void _addRowSetListener() {
130*cdf0e10cSrcweir         boolean result = true ;
131*cdf0e10cSrcweir 
132*cdf0e10cSrcweir         oObj.addRowSetListener(listener) ;
133*cdf0e10cSrcweir 
134*cdf0e10cSrcweir         checker.moveCursor() ;
135*cdf0e10cSrcweir         result &= listener.cursorMoved ;
136*cdf0e10cSrcweir         if (!listener.cursorMoved)
137*cdf0e10cSrcweir             log.println("cursorMoved event wasn't called") ;
138*cdf0e10cSrcweir         listener.reset() ;
139*cdf0e10cSrcweir 
140*cdf0e10cSrcweir         checker.changeRow() ;
141*cdf0e10cSrcweir         result &= listener.rowChanged ;
142*cdf0e10cSrcweir         if (!listener.rowChanged)
143*cdf0e10cSrcweir             log.println("rowChanged event wasn't called") ;
144*cdf0e10cSrcweir         listener.reset() ;
145*cdf0e10cSrcweir 
146*cdf0e10cSrcweir         checker.changeRowSet() ;
147*cdf0e10cSrcweir         result &= listener.rowSetChanged ;
148*cdf0e10cSrcweir         if (!listener.rowSetChanged)
149*cdf0e10cSrcweir             log.println("rowSetChanged event wasn't called") ;
150*cdf0e10cSrcweir         listener.reset() ;
151*cdf0e10cSrcweir 
152*cdf0e10cSrcweir         tRes.tested("addRowSetListener()", result) ;
153*cdf0e10cSrcweir     }
154*cdf0e10cSrcweir 
155*cdf0e10cSrcweir     /*
156*cdf0e10cSrcweir     * Removes listener added before, and checks for no listener
157*cdf0e10cSrcweir     * methods were called on response to rowSet manipulations. <p>
158*cdf0e10cSrcweir     * Methods to be successfully completed before :
159*cdf0e10cSrcweir     * <ul>
160*cdf0e10cSrcweir     * <li> <code>addRowSetListener()</code> </li>
161*cdf0e10cSrcweir     * </ul> <p>
162*cdf0e10cSrcweir     * Has OK status if no listeners methods were called.
163*cdf0e10cSrcweir     */
164*cdf0e10cSrcweir     public void _removeRowSetListener() {
165*cdf0e10cSrcweir         requiredMethod("addRowSetListener()") ;
166*cdf0e10cSrcweir 
167*cdf0e10cSrcweir         boolean result = true ;
168*cdf0e10cSrcweir 
169*cdf0e10cSrcweir         oObj.removeRowSetListener(listener) ;
170*cdf0e10cSrcweir 
171*cdf0e10cSrcweir         checker.moveCursor() ;
172*cdf0e10cSrcweir         result &= !listener.cursorMoved ;
173*cdf0e10cSrcweir         listener.reset() ;
174*cdf0e10cSrcweir 
175*cdf0e10cSrcweir         checker.changeRow() ;
176*cdf0e10cSrcweir         result &= !listener.rowChanged ;
177*cdf0e10cSrcweir         listener.reset() ;
178*cdf0e10cSrcweir 
179*cdf0e10cSrcweir         checker.changeRowSet() ;
180*cdf0e10cSrcweir         result &= !listener.rowSetChanged ;
181*cdf0e10cSrcweir 
182*cdf0e10cSrcweir         tRes.tested("removeRowSetListener()", result) ;
183*cdf0e10cSrcweir     }
184*cdf0e10cSrcweir 
185*cdf0e10cSrcweir     /**
186*cdf0e10cSrcweir     * Disposes test environment.
187*cdf0e10cSrcweir     */
188*cdf0e10cSrcweir     public void after() {
189*cdf0e10cSrcweir         disposeEnvironment() ;
190*cdf0e10cSrcweir     }
191*cdf0e10cSrcweir 
192*cdf0e10cSrcweir }  // finish class _XRowSet
193*cdf0e10cSrcweir 
194