INTEGRATION: CWS qiq (1.1.2); FILE ADDED

2006/07/06 07:33:03 fs 1.1.2.3: +refreshTables
2006/06/27 08:05:59 fs 1.1.2.2: createQuery does not throw an SQLException
2006/06/22 09:19:29 fs 1.1.2.1: wrapper around a DataSource, to evolve over time ...

1 files changed, 133 insertions, 0 deletions

diff --git a/connectivity/qa/connectivity/tools/DataSource.java b/connectivity/qa/connectivity/tools/DataSource.java
new file mode 100644
index 000000000000..edbe88f26ee3
--- /dev/null
+++ b/connectivity/qa/connectivity/tools/DataSource.java
@@ -0,0 +1,133 @@
+/*************************************************************************
+ *
+ *  OpenOffice.org - a multi-platform office productivity suite
+ *
+ *  $RCSfile: DataSource.java,v $
+ *
+ *  $Revision: 1.2 $
+ *
+ *  last change: $Author: obo $ $Date: 2006-07-10 14:17:42 $
+ *
+ *  The Contents of this file are made available subject to
+ *  the terms of GNU Lesser General Public License Version 2.1.
+ *
+ *
+ *    GNU Lesser General Public License Version 2.1
+ *    =============================================
+ *    Copyright 2005 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
+ *
+ ************************************************************************/
+
+package connectivity.tools;
+
+import com.sun.star.container.ElementExistException;
+import com.sun.star.container.NoSuchElementException;
+import com.sun.star.container.XNameAccess;
+import com.sun.star.container.XNameContainer;
+import com.sun.star.lang.WrappedTargetException;
+import com.sun.star.lang.XSingleServiceFactory;
+import com.sun.star.lang.XMultiServiceFactory;
+import com.sun.star.beans.XPropertySet;
+import com.sun.star.sdb.XQueryDefinitionsSupplier;
+import com.sun.star.sdbc.XDataSource;
+import com.sun.star.sdbcx.XTablesSupplier;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.util.XRefreshable;
+
+public class DataSource
+{
+    // the service factory
+    XMultiServiceFactory    m_orb;
+    XDataSource             m_dataSource;
+
+    public DataSource( XMultiServiceFactory _orb, XDataSource _dataSource )
+    {
+        m_orb = _orb;
+        m_dataSource = _dataSource;
+    }
+
+    /** creates a query with a given name and SQL command
+    */
+    public void createQuery( String _name, String _sqlCommand ) throws ElementExistException, WrappedTargetException, com.sun.star.lang.IllegalArgumentException
+    {
+        createQuery( _name, _sqlCommand, true );
+    }
+
+    /** creates a query with a given name, SQL command, and EscapeProcessing flag
+    */
+    public void createQuery( String _name, String _sqlCommand, boolean _escapeProcessing ) throws ElementExistException, WrappedTargetException, com.sun.star.lang.IllegalArgumentException
+    {
+        XSingleServiceFactory queryDefsFac = (XSingleServiceFactory)UnoRuntime.queryInterface(
+            XSingleServiceFactory.class, getQueryDefinitions() );
+        XPropertySet queryDef = null;
+        try
+        {
+            queryDef = (XPropertySet)UnoRuntime.queryInterface(
+                XPropertySet.class, queryDefsFac.createInstance() );
+            queryDef.setPropertyValue( "Command", _sqlCommand );
+            queryDef.setPropertyValue( "EscapeProcessing", new Boolean( _escapeProcessing ) );
+        }
+        catch( com.sun.star.uno.Exception e )
+        {
+            e.printStackTrace( System.err );
+        }
+
+        XNameContainer queryDefsContainer = (XNameContainer)UnoRuntime.queryInterface(
+            XNameContainer.class, getQueryDefinitions() );
+        queryDefsContainer.insertByName( _name, queryDef );
+    }
+
+    /** provides the query definition with the given name
+     */
+    public QueryDefinition getQueryDefinition( String _name ) throws NoSuchElementException
+    {
+        XNameAccess allDefs = getQueryDefinitions();
+        try
+        {
+            return new QueryDefinition(
+                (XPropertySet)UnoRuntime.queryInterface( XPropertySet.class, allDefs.getByName( _name ) ) );
+        }
+        catch ( WrappedTargetException e )
+        {
+        }
+        throw new NoSuchElementException();
+    }
+
+    /** provides the container of query definitions of the data source
+     */
+    public XNameAccess getQueryDefinitions()
+    {
+        XQueryDefinitionsSupplier suppQueries = (XQueryDefinitionsSupplier)UnoRuntime.queryInterface(
+            XQueryDefinitionsSupplier.class, m_dataSource );
+        return suppQueries.getQueryDefinitions();
+    }
+
+    /** refreshs the table container of a given connection
+     *
+     *  This is usually necessary if you created tables by directly executing SQL statements,
+     *  bypassing the SDBCX layer.
+     */
+    public void refreshTables( com.sun.star.sdbc.XConnection _connection )
+    {
+        XTablesSupplier suppTables = (XTablesSupplier)UnoRuntime.queryInterface(
+            XTablesSupplier.class, _connection );
+        XRefreshable refreshTables = (XRefreshable)UnoRuntime.queryInterface(
+            XRefreshable.class, suppTables.getTables() );
+        refreshTables.refresh();
+    }
+};