'************************************************************************* '* '* $RCSfile: sdbc_XParameters.xba,v $ '* '* $Revision: 1.1 $ '* '* last change:$Date: 2003-01-27 17:52:00 $ '* '* The Contents of this file are made available subject to the terms of '* either of the following licenses '* '* - GNU Lesser General Public License Version 2.1 '* - Sun Industry Standards Source License Version 1.1 '* '* Sun Microsystems Inc., October, 2000 '* '* GNU Lesser General Public License Version 2.1 '* ============================================= '* Copyright 2000 by Sun Microsystems, Inc. '* 901 San Antonio Road, Palo Alto, CA 94303, USA '* '* This library is free software; you can redistribute it and/or '* modify it under the terms of the GNU Lesser General Public '* License version 2.1, as published by the Free Software Foundation. '* '* This library is distributed in the hope that it will be useful, '* but WITHOUT ANY WARRANTY; without even the implied warranty of '* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU '* Lesser General Public License for more details. '* '* You should have received a copy of the GNU Lesser General Public '* License along with this library; if not, write to the Free Software '* Foundation, Inc., 59 Temple Place, Suite 330, Boston, '* MA 02111-1307 USA '* '* '* Sun Industry Standards Source License Version 1.1 '* ================================================= '* The contents of this file are subject to the Sun Industry Standards '* Source License Version 1.1 (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.openoffice.org/license.html. '* '* Software provided under this License is provided on an "AS IS" basis, '* WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, '* WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, '* MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. '* See the License for the specific provisions governing your rights and '* obligations concerning the Software. '* '* The Initial Developer of the Original Code is: Sun Microsystems, Inc. '* '* Copyright: 2000 by Sun Microsystems, Inc. '* '* All Rights Reserved. '* '* Contributor(s): _______________________________________ '* '* '************************************************************************* '************************************************************************* ' Be sure that all variables are dimensioned: option explicit '************************************************************************* ' This Interface/Service test depends on the following GLOBAL variables, ' which must be specified in the object creation: ' - Global paramTypes As Variant ' Array of Strings which describes the types of the query parameters '************************************************************************* Sub RunTest() '************************************************************************* ' INTERFACE: ' com.sun.star.sdbc.XParameters '************************************************************************* On Error Goto ErrHndl Dim bOK As Boolean Dim i As Integer for i = 0 to ubound(paramTypes()) if (paramTypes(i) = "boolean") OR (paramTypes(i) = "byte") OR (paramTypes(i) = "short") OR _ (paramTypes(i) = "int") OR (paramTypes(i) = "long") OR (paramTypes(i) = "float") OR _ (paramTypes(i) = "double") OR (paramTypes(i) = "string") OR (paramTypes(i) = "bytes") OR _ (paramTypes(i) = "date") OR (paramTypes(i) = "time") OR (paramTypes(i) = "timestamp") OR _ (paramTypes(i) = "binarystream") OR (paramTypes(i) = "characterstream") then bOK = true oObj.setNull(i + 1, paramTypes(i)) Test.MethodTested("setNull()", bOK) elseif paramTypes(i) = "ref" then Out.Log("Don't know how to test this :(") ' bOK = true ' oObj.setObjectNull(i) ' Test.MethodTested("setNull()", bOK) end if if paramTypes(i) = "boolean" then Test.StartMethod("setBoolean()") bOK = true oObj.setBoolean(i + 1, true) Test.MethodTested("setBoolean()", bOK) elseif paramTypes(i) = "byte" then Test.StartMethod("setByte()") bOK = true oObj.setByte(i + 1, 5) Test.MethodTested("setByte()", bOK) elseif paramTypes(i) = "short" then Test.StartMethod("setShort()") bOK = true oObj.setShort(i + 1, 6) Test.MethodTested("setShort()", bOK) elseif paramTypes(i) = "int" then Test.StartMethod("setInt()") bOK = true oObj.setInt(i + 1, 234) Test.MethodTested("setInt()", bOK) elseif paramTypes(i) = "long" then Test.StartMethod("setLong()") bOK = true oObj.setLong(i + 1, 34656) Test.MethodTested("setLong()", bOK) elseif paramTypes(i) = "float" then Test.StartMethod("setFloat()") bOK = true oObj.setFloat(i + 1, 98.765) Test.MethodTested("setFloat()", bOK) elseif paramTypes(i) = "double" then Test.StartMethod("setDouble()") bOK = true oObj.setDouble(i + 1, 54.432) Test.MethodTested("setDouble()", bOK) elseif paramTypes(i) = "string" then Test.StartMethod("setString()") bOK = true oObj.setString(i + 1, "XParameters") Test.MethodTested("setString()", bOK) elseif paramTypes(i) = "bytes" then Test.StartMethod("setBytes()") bOK = true oObj.setBytes(i + 1, Array(1,2,3)) Test.MethodTested("setBytes()", bOK) elseif paramTypes(i) = "date" then Dim dat As new com.sun.star.util.Date Test.StartMethod("setDate()") bOK = true oObj.setDate(i + 1, dat) Test.MethodTested("setDate()", bOK) elseif paramTypes(i) = "time" then Dim tim As new com.sun.star.util.Time Test.StartMethod("setTime()") bOK = true oObj.setTime(i + 1, tim) Test.MethodTested("setTime()", bOK) elseif paramTypes(i) = "timestamp" then Dim timstmp As new com.sun.star.util.DateTime Test.StartMethod("setTimestamp()") bOK = true oObj.setTimestamp(i + 1, timstmp) Test.MethodTested("setTimestamp()", bOK) elseif paramTypes(i) = "binarystream" then Test.StartMethod("setBinaryStream()") bOK = true oObj.setBinaryStream(i + 1, ceateUnoService("com.sun.star.io.Pipe")) Test.MethodTested("setBinaryStream()", bOK) elseif paramTypes(i) = "characterstream" then Test.StartMethod("setCharacterStream()") bOK = true oObj.setCharacterStream(i + 1, ceateUnoService("com.sun.star.io.Pipe")) Test.MethodTested("setCharacterStream()", bOK) elseif paramTypes(i) = "object" then Test.StartMethod("setObject()") bOK = true oObj.setObject(i + 1, ceateUnoService("com.sun.star.io.Pipe")) Test.MethodTested("setObject()", bOK) elseif paramTypes(i) = "objectwithinfo" then Out.Log("Don't know how to test this type :(") ' Test.StartMethod("setObjectWithInfo()") ' bOK = true ' oObj.setObjectWithInfo() ' bOK = bOK AND false ' Test.MethodTested("setObjectWithInfo()", bOK) elseif paramTypes(i) = "ref" then Out.Log("Don't know how to test this type :(") ' Test.StartMethod("setRef()") ' bOK = true ' oObj.setRef() ' bOK = bOK AND false ' Test.MethodTested("setRef()", bOK) elseif paramTypes(i) = "blob" then Out.Log("Don't know how to test this type :(") ' Test.StartMethod("setBlob()") ' bOK = true ' oObj.setBlob() ' bOK = bOK AND false ' Test.MethodTested("setBlob()", bOK) elseif paramTypes(i) = "clob" then Out.Log("Don't know how to test this type :(") ' Test.StartMethod("setClob()") ' bOK = true ' oObj.setClob() ' bOK = bOK AND false ' Test.MethodTested("setClob()", bOK) elseif paramTypes(i) = "array" then Out.Log("Don't know how to test this type :(") ' Test.StartMethod("setArray()") ' bOK = true ' oObj.setArray() ' bOK = bOK AND false ' Test.MethodTested("setArray()", bOK) end if next i Test.StartMethod("clearParameters()") bOK = true oObj.clearParameters() Test.MethodTested("clearParameters()", bOK) Exit Sub ErrHndl: Test.Exception() bOK = false resume next End Sub