diff options
Diffstat (limited to 'connectivity/qa')
28 files changed, 0 insertions, 4434 deletions
diff --git a/connectivity/qa/complex/connectivity/DBaseDriverTest.java b/connectivity/qa/complex/connectivity/DBaseDriverTest.java deleted file mode 100755 index f2e998156c..0000000000 --- a/connectivity/qa/complex/connectivity/DBaseDriverTest.java +++ /dev/null @@ -1,78 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity; - -import complex.connectivity.dbase.DBaseDateFunctions; -import complex.connectivity.dbase.DBaseStringFunctions; -import complex.connectivity.dbase.DBaseSqlTests; -import complex.connectivity.dbase.DBaseNumericFunctions; -import com.sun.star.lang.XMultiServiceFactory; -import complexlib.ComplexTestCase; -import share.LogWriter; - -public class DBaseDriverTest extends ComplexTestCase implements TestCase -{ - public String[] getTestMethodNames() - { - return new String[] - { - "Functions" - }; - } - - @Override - public String getTestObjectName() - { - return "DBaseDriverTest"; - } - - @Override - public void assure( final String i_message, final boolean i_condition ) - { - super.assure( i_message, i_condition ); - } - - public LogWriter getLog() - { - return ComplexTestCase.log; - } - - public void Functions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - DBaseStringFunctions aStringTest = new DBaseStringFunctions(((XMultiServiceFactory) param.getMSF()), this); - aStringTest.testFunctions(); - - DBaseNumericFunctions aNumericTest = new DBaseNumericFunctions(((XMultiServiceFactory) param.getMSF()), this); - aNumericTest.testFunctions(); - - DBaseDateFunctions aDateTest = new DBaseDateFunctions(((XMultiServiceFactory) param.getMSF()), this); - aDateTest.testFunctions(); - - DBaseSqlTests aSqlTest = new DBaseSqlTests(((XMultiServiceFactory) param.getMSF()), this); - aSqlTest.testFunctions(); - } -} diff --git a/connectivity/qa/complex/connectivity/FlatFileAccess.java b/connectivity/qa/complex/connectivity/FlatFileAccess.java deleted file mode 100755 index 3f04816848..0000000000 --- a/connectivity/qa/complex/connectivity/FlatFileAccess.java +++ /dev/null @@ -1,237 +0,0 @@ -package complex.connectivity; - -import com.sun.star.beans.XPropertySet; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdb.CommandType; -import com.sun.star.sdbc.SQLException; -import com.sun.star.util.Date; -import complexlib.ComplexTestCase; -import connectivity.tools.CsvDatabase; -import connectivity.tools.RowSet; -import java.io.File; -import java.io.FileOutputStream; -import java.io.PrintWriter; -import java.util.ArrayList; -import java.util.List; - -public class FlatFileAccess extends ComplexTestCase -{ - public FlatFileAccess() - { - super(); - } - - @Override - public String[] getTestMethodNames() - { - return new String[] { - "testBasicAccess", - "testCalendarFunctions", - "testSortingByFunction" - }; - } - - @Override - public String getTestObjectName() - { - return "FlatFileAccess"; - } - - public void before() throws Exception - { - m_database = new CsvDatabase( (XMultiServiceFactory)param.getMSF() ); - - // proper settings - final XPropertySet dataSourceSettings = m_database.getDataSource().geSettings(); - dataSourceSettings.setPropertyValue( "Extension", "csv" ); - dataSourceSettings.setPropertyValue( "HeaderLine", Boolean.TRUE ); - dataSourceSettings.setPropertyValue( "FieldDelimiter", " " ); - m_database.store(); - - // write the table(s) for our test - final String tableLocation = m_database.getTableFileLocation().getAbsolutePath(); - final PrintWriter tableWriter = new PrintWriter( new FileOutputStream( tableLocation + File.separatorChar + "dates.csv", false ) ); - tableWriter.println( "ID date" ); - tableWriter.println( "1 2013-01-01" ); - tableWriter.println( "2 2012-02-02" ); - tableWriter.println( "3 2011-03-03" ); - tableWriter.close(); - } - - public void after() - { - } - - private class EqualityDate extends Date - { - EqualityDate( short i_day, short i_month, short i_year ) - { - super( i_day, i_month, i_year ); - } - - EqualityDate( Date i_date ) - { - super( i_date.Day, i_date.Month, i_date.Year ); - } - - @Override - public boolean equals( Object i_compare ) - { - if ( !( i_compare instanceof Date ) ) - return false; - return Day == ((Date)i_compare).Day - && Month == ((Date)i_compare).Month - && Year == ((Date)i_compare).Year; - } - } - - /** - * ensures simple SELECTs from our table(s) work, and deliver the expected results - */ - public void testBasicAccess() - { - testRowSetResults( - "SELECT * FROM \"dates\"", - new RowSetIntGetter(1), - new Integer[] { 1, 2, 3 }, - "simple select", "wrong IDs" - ); - - testRowSetResults( - "SELECT * FROM \"dates\"", - new RowSetDateGetter( 2 ), - new EqualityDate[] { new EqualityDate( (short)1, (short)1, (short)2013 ), - new EqualityDate( (short)2, (short)2, (short)2012 ), - new EqualityDate( (short)3, (short)3, (short)2011 ) - }, - "simple select", "wrong dates" - ); - testRowSetResults( - "SELECT \"date\", \"ID\" FROM \"dates\" ORDER BY \"ID\" DESC", - new RowSetIntGetter( 2 ), - new Integer[] { 3, 2, 1 }, - "explicit column selection, sorted by IDs", "wrong IDs" - ); - testRowSetResults( - "SELECT * FROM \"dates\" ORDER BY \"date\"", - new RowSetIntGetter( 1 ), - new Integer[] { 3, 2, 1 }, - "sorted by date", "wrong IDs" - ); - } - - /** - * ensures the basic functionality for selecting calendar functions from a CSV table - this is a prerequisite for - * later tests. - */ - public void testCalendarFunctions() - { - // simple check for proper results of the calendar functions (DATE/MONTH) - // The * at the first position is crucial here - there was code which wrongly calculated - // column positions of function columns when * was present in the statement - testRowSetResults( - "SELECT \"dates\".*, YEAR( \"date\" ) FROM \"dates\"", - new RowSetIntGetter( 3 ), - new Integer[] { 2013, 2012, 2011 }, - "YEAR function", "wrong calculated years" - ); - testRowSetResults( - "SELECT \"dates\".*, MONTH( \"date\" ) FROM \"dates\"", - new RowSetIntGetter( 3 ), - new Integer[] { 1, 2, 3 }, - "MONTH function", "wrong calculated months" - ); - } - - /** - * ensures that sorting by a function column works - */ - public void testSortingByFunction() - { - // most simple case: select a function, and sort by it - testRowSetResults( - "SELECT YEAR( \"date\" ) AS \"year\" FROM \"dates\" ORDER BY \"year\"", - new RowSetIntGetter(1), - new Integer[] { 2011, 2012, 2013 }, - "single YEAR selection, sorted by years", "wrong calculated years" - ); - // somewhat more "difficult" (this used to crash): Select all columns, plus a function, so the calculated - // column has a position greater than column count - testRowSetResults( - "SELECT \"dates\".*, YEAR( \"date\" ) AS \"year\" FROM \"dates\" ORDER BY \"year\" DESC", - new RowSetIntGetter(3), - new Integer[] { 2013, 2012, 2011 }, - "extended YEAR selection, sorted by years", "wrong calculated years" - ); - } - - private interface RowSetValueGetter - { - public Object getValue( final RowSet i_rowSet ) throws SQLException; - } - - private abstract class RowSetColumnValueGetter implements RowSetValueGetter - { - RowSetColumnValueGetter( final int i_columnIndex ) - { - m_columnIndex = i_columnIndex; - } - - protected final int m_columnIndex; - } - - private class RowSetIntGetter extends RowSetColumnValueGetter - { - RowSetIntGetter( final int i_columnIndex ) - { - super( i_columnIndex ); - } - - public Object getValue( final RowSet i_rowSet ) throws SQLException - { - return i_rowSet.getInt( m_columnIndex ); - } - } - - private class RowSetDateGetter extends RowSetColumnValueGetter - { - RowSetDateGetter( final int i_columnIndex ) - { - super( i_columnIndex ); - } - - public Object getValue( final RowSet i_rowSet ) throws SQLException - { - return i_rowSet.getDate( m_columnIndex ); - } - } - - private <T> void testRowSetResults( String i_command, RowSetValueGetter i_getter, - T[] i_expectedValues, String i_context, String i_failureDesc ) - { - RowSet rowSet = null; - try - { - rowSet = m_database.createRowSet( CommandType.COMMAND, i_command ); - rowSet.execute(); - - List< T > values = new ArrayList< T >(); - while ( rowSet.next() ) - { - values.add( (T)i_getter.getValue( rowSet ) ); - } - assureEquals( i_context + ": " + i_failureDesc, i_expectedValues, values.toArray(), true ); - } - catch( final SQLException e ) - { - failed( i_context + ": caught an exception: " + e.toString(), false ); - } - finally - { - if ( rowSet != null ) - rowSet.dispose(); - } - } - - private CsvDatabase m_database = null; -} diff --git a/connectivity/qa/complex/connectivity/HsqlDriverTest.java b/connectivity/qa/complex/connectivity/HsqlDriverTest.java deleted file mode 100755 index bbec489b31..0000000000 --- a/connectivity/qa/complex/connectivity/HsqlDriverTest.java +++ /dev/null @@ -1,156 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity; - -import complex.connectivity.hsqldb.TestCacheSize; -import com.sun.star.frame.XModel; -import com.sun.star.frame.XStorable; - -import com.sun.star.lang.*; -import com.sun.star.document.XDocumentSubStorageSupplier; -import complexlib.ComplexTestCase; - - -import org.hsqldb.lib.StopWatch; -import com.sun.star.uno.UnoRuntime; -import com.sun.star.beans.PropertyState; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.embed.XStorage; -import com.sun.star.sdbc.XDataSource; -import com.sun.star.sdbc.XDriver; -import connectivity.tools.HsqlDatabase; - -public class HsqlDriverTest extends ComplexTestCase { - - - public String[] getTestMethodNames() { - return new String[] { "test" }; - } - - @Override - public String getTestObjectName() { - return "DriverTest"; - } - - public void assurePublic(String sMessage,boolean check){ - super.assure(sMessage,check); - } - - public void test(){ - XDataSource ds = null; - System.gc(); - try { - HsqlDatabase database = new HsqlDatabase( (XMultiServiceFactory)param.getMSF() ); - ds = database.getDataSource().getXDataSource(); - } catch(Exception ex) { - throw new RuntimeException("factory: unable to construct data source" ); - } - - try{ - XDocumentSubStorageSupplier doc = (XDocumentSubStorageSupplier)UnoRuntime.queryInterface(XDocumentSubStorageSupplier.class,ds); - XStorage stor = doc.getDocumentSubStorage("database",4); - try{ - if ( stor.isStreamElement("db.log") ) - stor.removeElement("db.log"); - } catch(Exception e){} - try{ - if ( stor.isStreamElement("db.properties") ) - stor.removeElement("db.properties"); - } catch(Exception e){} - try{ - if ( stor.isStreamElement("db.script") ) - stor.removeElement("db.script"); - } catch(Exception e){} - try{ - if ( stor.isStreamElement("db.script.new") ) - stor.removeElement("db.script.new"); - } catch(Exception e){} - XStorable mod = (XStorable)UnoRuntime.queryInterface(XStorable.class,ds); - mod.store(); - XComponent xComp = (XComponent)UnoRuntime.queryInterface(XComponent.class,stor); - if ( xComp != null ) - xComp.dispose(); - } catch(Exception e){} - - com.sun.star.beans.PropertyValue[] info = null; - XDriver drv = null; - try{ - XDocumentSubStorageSupplier doc = (XDocumentSubStorageSupplier)UnoRuntime.queryInterface(XDocumentSubStorageSupplier.class,ds); - XModel mod = (XModel)UnoRuntime.queryInterface(XModel.class,ds); - XStorage stor = doc.getDocumentSubStorage("database",4); - info = new com.sun.star.beans.PropertyValue[]{ - new com.sun.star.beans.PropertyValue("Storage",0,stor,PropertyState.DIRECT_VALUE) - ,new com.sun.star.beans.PropertyValue("URL",0,mod.getURL(),PropertyState.DIRECT_VALUE) - }; - drv = (XDriver)UnoRuntime.queryInterface(XDriver.class,((XMultiServiceFactory)param.getMSF()).createInstance("com.sun.star.sdbcx.comp.hsqldb.Driver")); - - - TestCacheSize test = new TestCacheSize(((XMultiServiceFactory)param.getMSF()),info,drv); - - StopWatch sw = new StopWatch(); - - try{ - test.setUp(); - test.testFillUp(); - test.checkResults(); - test.tearDown(); - System.out.println("Total Test Time: " + sw.elapsedTime()); - } catch(Exception e){} - - try{ - XStorable mod2 = (XStorable)UnoRuntime.queryInterface(XStorable.class,ds); - mod2.store(); - } catch(Exception e){} - }catch(Exception e){} - } - public void test2(){ - System.gc(); - - com.sun.star.beans.PropertyValue[] info = null; - XDriver drv = null; - try{ - info = new com.sun.star.beans.PropertyValue[]{ - new com.sun.star.beans.PropertyValue("JavaDriverClass",0,"org.hsqldb.jdbcDriver",PropertyState.DIRECT_VALUE) - ,new com.sun.star.beans.PropertyValue("ParameterNameSubstitution",0, false,PropertyState.DIRECT_VALUE) - }; - drv = (XDriver)UnoRuntime.queryInterface(XDriver.class,((XMultiServiceFactory)param.getMSF()).createInstance("com.sun.star.comp.sdbc.JDBCDriver")); - TestCacheSize test = new TestCacheSize(((XMultiServiceFactory)param.getMSF()),info,drv); - test.setURL("jdbc:hsqldb:g:\\hsql\\db"); - - - StopWatch sw = new StopWatch(); - - try{ - test.setUp(); - test.testFillUp(); - test.checkResults(); - test.tearDown(); - System.out.println("Total Test Time: " + sw.elapsedTime()); - } catch(Exception e){} - }catch(Exception e){} - } -} diff --git a/connectivity/qa/complex/connectivity/JdbcLongVarCharTest.java b/connectivity/qa/complex/connectivity/JdbcLongVarCharTest.java deleted file mode 100755 index 7fbdfa5ffd..0000000000 --- a/connectivity/qa/complex/connectivity/JdbcLongVarCharTest.java +++ /dev/null @@ -1,132 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity; - -import com.sun.star.beans.PropertyState; -import com.sun.star.beans.PropertyValue; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdbc.XResultSet; -import com.sun.star.sdbc.XClob; -import com.sun.star.sdbc.XDriverAccess; -import com.sun.star.sdbc.XParameters; -import com.sun.star.sdbc.XPreparedStatement; -import com.sun.star.sdbc.XResultSetMetaData; -import com.sun.star.sdbc.XResultSetMetaDataSupplier; -import com.sun.star.sdbc.XRow; -import com.sun.star.uno.UnoRuntime; -import complexlib.ComplexTestCase; - -public class JdbcLongVarCharTest extends ComplexTestCase -{ - - public String[] getTestMethodNames() - { - return new String[] - { - "testLongVarChar" - }; - } - - @Override - public String getTestObjectName() - { - return "LongVarCharTest"; - } - - public void testLongVarChar() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - - try - { - System.out.println("== Start testing =="); - - String url = "jdbc:mysql://localhost:3306/mysql?user=root"; - //String url = "jdbc:ingres://localhost:II7/demodb;AUTO=multi"; - com.sun.star.sdbc.XConnection xConnection = null; - com.sun.star.beans.PropertyValue prop[] = new PropertyValue[1]; - prop[0] = new PropertyValue("JavaDriverClass", 0, "com.mysql.jdbc.Driver", PropertyState.DIRECT_VALUE); - //prop[0] = new PropertyValue("JavaDriverClass", 0, "com.ingres.jdbc.IngresDriver", PropertyState.DIRECT_VALUE); - - // get the remote office component context - XMultiServiceFactory xServiceManager = (XMultiServiceFactory) param.getMSF(); - Object x = xServiceManager.createInstance("com.sun.star.sdbc.DriverManager"); - com.sun.star.sdbc.XDriverAccess xDriverAccess = (XDriverAccess) UnoRuntime.queryInterface(XDriverAccess.class, x); - com.sun.star.sdbc.XDriver xDriver = xDriverAccess.getDriverByURL(url); - xConnection = xDriver.connect(url, prop); - - //Object prepStmnt = xConnection.prepareStatement("SELECT * FROM t1 WHERE t1.c1 = ?"); - Object prepStmnt = xConnection.prepareStatement("SELECT * FROM i90114 WHERE i90114.c1 = ?"); - ((XParameters) UnoRuntime.queryInterface(XParameters.class, prepStmnt)).clearParameters(); - ((XParameters) UnoRuntime.queryInterface(XParameters.class, prepStmnt)).setInt(1, 1); - XResultSet xResultSet = ((XPreparedStatement) prepStmnt).executeQuery(); - XRow xRow = (XRow) UnoRuntime.queryInterface(XRow.class, xResultSet); - - XResultSetMetaDataSupplier xRsMetaSup = (XResultSetMetaDataSupplier) UnoRuntime.queryInterface(XResultSetMetaDataSupplier.class, xResultSet); - XResultSetMetaData xRsMetaData = xRsMetaSup.getMetaData(); - int nColumnCount = xRsMetaData.getColumnCount(); - - System.out.println("== MetaData =="); - for (int i = 1; i <= nColumnCount; ++i) - { - System.out.println("Name: " + xRsMetaData.getColumnName(i) + " Type: " + - xRsMetaData.getColumnType(i)); - } - - System.out.println("== Result =="); - while (xResultSet.next()) - { - String str = "not set"; - - XClob xClob = null; - xClob = xRow.getClob(2); - if (xClob != null) - { - System.out.println("xClob != null"); - int len = (int) xClob.length(); - str = xClob.getSubString(1, len); - } - else - { - System.out.println("xClob == null"); - } - - System.out.println("c1 (Int): " + xRow.getInt(1) + " c2 (String): " + xRow.getString(2) + " c3 (Clob): " + str); - } - - xConnection.close(); - } - catch (java.lang.Exception e) - { - System.out.println("== Exception occurred while testing =="); - e.printStackTrace(); - } finally - { - System.out.println("== End testing =="); - System.exit(0); - } - } -}
\ No newline at end of file diff --git a/connectivity/qa/complex/connectivity/SubTestCase.java b/connectivity/qa/complex/connectivity/SubTestCase.java deleted file mode 100755 index 1c2e685c59..0000000000 --- a/connectivity/qa/complex/connectivity/SubTestCase.java +++ /dev/null @@ -1,23 +0,0 @@ -package complex.connectivity; - -import share.LogWriter; - -public class SubTestCase implements TestCase -{ - protected SubTestCase( final TestCase i_parentTestCase ) - { - m_parentTestCase = i_parentTestCase; - } - - public void assure( String i_message, boolean i_condition ) - { - m_parentTestCase.assure( i_message, i_condition ); - } - - public LogWriter getLog() - { - return m_parentTestCase.getLog(); - } - - private final TestCase m_parentTestCase; -} diff --git a/connectivity/qa/complex/connectivity/TestCase.java b/connectivity/qa/complex/connectivity/TestCase.java deleted file mode 100755 index bae5fcdcb4..0000000000 --- a/connectivity/qa/complex/connectivity/TestCase.java +++ /dev/null @@ -1,35 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity; - -import share.LogWriter; - -public interface TestCase -{ - public void assure( final String i_message, final boolean i_condition ); - public LogWriter getLog(); -} diff --git a/connectivity/qa/complex/connectivity/dbase/DBaseDateFunctions.java b/connectivity/qa/complex/connectivity/dbase/DBaseDateFunctions.java deleted file mode 100755 index 1ab75985af..0000000000 --- a/connectivity/qa/complex/connectivity/dbase/DBaseDateFunctions.java +++ /dev/null @@ -1,305 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity.dbase; - -import com.sun.star.uno.UnoRuntime; -import com.sun.star.sdbc.*; -import com.sun.star.beans.XPropertySet; - -import com.sun.star.lang.XMultiServiceFactory; -import complex.connectivity.TestCase; -import complex.connectivity.SubTestCase; - -public class DBaseDateFunctions extends SubTestCase -{ - - private final String where = "FROM \"biblio\" \"biblio\" where \"Identifier\" = 'BOR00'"; - private final XMultiServiceFactory m_xORB; - - public DBaseDateFunctions(final XMultiServiceFactory _xORB, final TestCase i_testCase) - { - super( i_testCase ); - m_xORB = _xORB; - } - - public void testFunctions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRowSet xRowRes = (XRowSet) UnoRuntime.queryInterface(XRowSet.class, - m_xORB.createInstance("com.sun.star.sdb.RowSet")); - - getLog().println("starting DateTime function test!"); - // set the properties needed to connect to a database - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("DataSourceName", "Bibliography"); - - xProp.setPropertyValue("CommandType", Integer.valueOf(com.sun.star.sdb.CommandType.COMMAND)); - - try - { - curdate(xRowRes); - } - catch (SQLException ex) - { - assure("upper " + ex.getMessage(), false); - throw ex; - } - try - { - curtime(xRowRes); - } - catch (SQLException ex) - { - assure("lower " + ex.getMessage(), false); - throw ex; - } - try - { - dayname(xRowRes); - } - catch (SQLException ex) - { - assure("ascii " + ex.getMessage(), false); - throw ex; - } - try - { - dayofmonth(xRowRes); - } - catch (SQLException ex) - { - assure("char_len " + ex.getMessage(), false); - throw ex; - } - try - { - dayofweek(xRowRes); - } - catch (SQLException ex) - { - assure("concat " + ex.getMessage(), false); - throw ex; - } - try - { - dayofyear(xRowRes); - } - catch (SQLException ex) - { - assure("locate " + ex.getMessage(), false); - throw ex; - } - try - { - hour(xRowRes); - } - catch (SQLException ex) - { - assure("substr " + ex.getMessage(), false); - throw ex; - } - try - { - minute(xRowRes); - } - catch (SQLException ex) - { - assure("ltrim " + ex.getMessage(), false); - throw ex; - } - try - { - month(xRowRes); - } - catch (SQLException ex) - { - assure("rtrim " + ex.getMessage(), false); - throw ex; - } - try - { - monthname(xRowRes); - } - catch (SQLException ex) - { - assure("space " + ex.getMessage(), false); - throw ex; - } - try - { - now(xRowRes); - } - catch (SQLException ex) - { - assure("replace " + ex.getMessage(), false); - throw ex; - } - try - { - quarter(xRowRes); - } - catch (SQLException ex) - { - assure("repeat " + ex.getMessage(), false); - throw ex; - } - try - { - second(xRowRes); - } - catch (SQLException ex) - { - assure("insert " + ex.getMessage(), false); - throw ex; - } - try - { - week(xRowRes); - } - catch (SQLException ex) - { - assure("left " + ex.getMessage(), false); - throw ex; - } - try - { - year(xRowRes); - } - catch (SQLException ex) - { - assure("right " + ex.getMessage(), false); - throw ex; - } - } - - private XRow execute(final XRowSet xRowRes, final String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("Command", "SELECT " + sql + where); - xRowRes.execute(); - final XResultSet xRes = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, xRowRes); - assure("No valid row! ", xRes.next()); - - return (XRow) UnoRuntime.queryInterface(XRow.class, xRes); - } - - private void dayofweek(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "DAYOFWEEK('1998-02-03') "); - assure("DAYOFWEEK('1998-02-03') failed!", row.getInt(1) == 3); - } - - private void dayofmonth(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "DAYOFMONTH('1998-02-03') "); - assure("DAYOFMONTH('1998-02-03') failed!", row.getInt(1) == 3); - } - - private void dayofyear(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "DAYOFYEAR('1998-02-03') "); - assure("DAYOFYEAR('1998-02-03') failed!", row.getInt(1) == 34); - } - - private void month(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "month('1998-02-03') "); - assure("month('1998-02-03') failed!", row.getInt(1) == 2); - } - - private void dayname(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "DAYNAME('1998-02-05') "); - assure("DAYNAME('1998-02-05') failed!", row.getString(1).equals("Thursday")); - } - - private void monthname(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "MONTHNAME('1998-02-05') "); - assure("MONTHNAME('1998-02-05') failed!", row.getString(1).equals("February")); - } - - private void quarter(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "QUARTER('98-01-01'),QUARTER('98-04-01'),QUARTER('98-07-01'),QUARTER('98-10-01') "); - assure("QUARTER('98-01-01') failed!", row.getInt(1) == 1); - assure("QUARTER('98-04-01') failed!", row.getInt(2) == 2); - assure("QUARTER('98-07-01') failed!", row.getInt(3) == 3); - assure("QUARTER('98-10-01') failed!", row.getInt(4) == 4); - } - - private void week(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "WEEK('1998-02-20') "); - assure("WEEK('1998-02-20') failed!", row.getInt(1) == 7); - } - - private void year(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "YEAR('98-02-03') "); - assure("YEAR('98-02-03') failed!", row.getInt(1) == 98); - } - - private void hour(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "HOUR('10:05:03') "); - assure("HOUR('10:05:03') failed!", row.getInt(1) == 10); - } - - private void minute(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "MINUTE('98-02-03 10:05:03') "); - assure("MINUTE('98-02-03 10:05:03') failed!", row.getInt(1) == 5); - } - - private void second(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "SECOND('10:05:03') "); - assure("SECOND('10:05:03') failed!", row.getInt(1) == 3); - } - - private void curdate(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "CURDATE() "); - final com.sun.star.util.Date aDate = row.getDate(1); - getLog().println("CURDATE() is '" + aDate.Year + "-" + aDate.Month + "-" + aDate.Day + "'"); - } - - private void curtime(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "CURTIME() "); - final com.sun.star.util.Time aTime = row.getTime(1); - getLog().println("CURTIME() is '" + aTime.Hours + ":" + aTime.Minutes + ":" + aTime.Seconds + "'"); - } - - private void now(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "NOW() "); - final com.sun.star.util.DateTime aTime = row.getTimestamp(1); - getLog().println("NOW() is '" + aTime.Year + "-" + aTime.Month + "-" + aTime.Day + "'"); - getLog().println("'" + aTime.Hours + ":" + aTime.Minutes + ":" + aTime.Seconds + "'"); - } -} diff --git a/connectivity/qa/complex/connectivity/dbase/DBaseNumericFunctions.java b/connectivity/qa/complex/connectivity/dbase/DBaseNumericFunctions.java deleted file mode 100755 index e783b2fedf..0000000000 --- a/connectivity/qa/complex/connectivity/dbase/DBaseNumericFunctions.java +++ /dev/null @@ -1,397 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity.dbase; - -import com.sun.star.uno.UnoRuntime; -import com.sun.star.sdbc.*; -import com.sun.star.beans.XPropertySet; -import com.sun.star.lang.XMultiServiceFactory; -import complex.connectivity.SubTestCase; -import complex.connectivity.TestCase; - - -public class DBaseNumericFunctions extends SubTestCase -{ - private final String where = "FROM \"biblio\" \"biblio\" where \"Identifier\" = 'BOR00'"; - private final XMultiServiceFactory m_xORB; - - public DBaseNumericFunctions(final XMultiServiceFactory _xORB, final TestCase i_testCase) - { - super( i_testCase ); - m_xORB = _xORB; - } - - public void testFunctions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRowSet xRowRes = (XRowSet) UnoRuntime.queryInterface(XRowSet.class, - m_xORB.createInstance("com.sun.star.sdb.RowSet")); - - getLog().println("starting Numeric function test"); - // set the properties needed to connect to a database - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("DataSourceName", "Bibliography"); - - xProp.setPropertyValue("CommandType", Integer.valueOf(com.sun.star.sdb.CommandType.COMMAND)); - - try - { - abs(xRowRes); - } - catch (SQLException ex) - { - assure("abs " + ex.getMessage(), false); - throw ex; - } - try - { - acos(xRowRes); - } - catch (SQLException ex) - { - assure("acos " + ex.getMessage(), false); - throw ex; - } - try - { - asin(xRowRes); - } - catch (SQLException ex) - { - assure("asin " + ex.getMessage(), false); - throw ex; - } - try - { - atan(xRowRes); - } - catch (SQLException ex) - { - assure("atan " + ex.getMessage(), false); - throw ex; - } - try - { - atan2(xRowRes); - } - catch (SQLException ex) - { - assure("atan2 " + ex.getMessage(), false); - throw ex; - } - try - { - ceiling(xRowRes); - } - catch (SQLException ex) - { - assure("ceiling " + ex.getMessage(), false); - throw ex; - } - try - { - cos(xRowRes); - } - catch (SQLException ex) - { - assure("cos " + ex.getMessage(), false); - throw ex; - } - try - { - degrees(xRowRes); - } - catch (SQLException ex) - { - assure("degrees " + ex.getMessage(), false); - throw ex; - } - try - { - exp(xRowRes); - } - catch (SQLException ex) - { - assure("exp " + ex.getMessage(), false); - throw ex; - } - try - { - floor(xRowRes); - } - catch (SQLException ex) - { - assure("floor " + ex.getMessage(), false); - throw ex; - } - try - { - log(xRowRes); - } - catch (SQLException ex) - { - assure("log " + ex.getMessage(), false); - throw ex; - } - try - { - log10(xRowRes); - } - catch (SQLException ex) - { - assure("log10 " + ex.getMessage(), false); - throw ex; - } - try - { - mod(xRowRes); - } - catch (SQLException ex) - { - assure("mod " + ex.getMessage(), false); - throw ex; - } - try - { - pi(xRowRes); - } - catch (SQLException ex) - { - assure("pi " + ex.getMessage(), false); - throw ex; - } - try - { - pow(xRowRes); - } - catch (SQLException ex) - { - assure("pow " + ex.getMessage(), false); - throw ex; - } - try - { - radians(xRowRes); - } - catch (SQLException ex) - { - assure("radians " + ex.getMessage(), false); - throw ex; - } - try - { - round(xRowRes); - } - catch (SQLException ex) - { - assure("round " + ex.getMessage(), false); - throw ex; - } - try - { - sign(xRowRes); - } - catch (SQLException ex) - { - assure("sign " + ex.getMessage(), false); - throw ex; - } - try - { - sin(xRowRes); - } - catch (SQLException ex) - { - assure("sin " + ex.getMessage(), false); - throw ex; - } - try - { - sqrt(xRowRes); - } - catch (SQLException ex) - { - assure("sqrt " + ex.getMessage(), false); - throw ex; - } - try - { - tan(xRowRes); - } - catch (SQLException ex) - { - assure("tan " + ex.getMessage(), false); - throw ex; - } - - } - - private XRow execute(final XRowSet xRowRes,final String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("Command", "SELECT " + sql + where); - xRowRes.execute(); - final XResultSet xRes = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, xRowRes); - assure("No valid row! ", xRes.next()); - - return (XRow) UnoRuntime.queryInterface(XRow.class, xRes); - } - - private void abs(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ABS(2),ABS(-32) "); - assure("ABS(2) failed!", row.getInt(1) == 2); - assure("ABS(-32) failed!", row.getInt(2) == 32); - } - - private void sign(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "SIGN(-32),SIGN(0),SIGN(234) "); - assure("SIGN(-32)failed!", row.getInt(1) == -1); - assure("SIGN(0) failed!", row.getInt(2) == 0); - assure("SIGN(234) failed!", row.getInt(3) == 1); - } - - private void mod(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "MOD(234, 10) "); - assure("MOD(234, 10) failed!", row.getInt(1) == 4); - } - - private void floor(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "FLOOR(1.23),FLOOR(-1.23) "); - assure("FLOOR(1.23) failed!", row.getInt(1) == 1); - assure("FLOOR(-1.23) failed!", row.getInt(2) == -2); - } - - private void ceiling(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "CEILING(1.23),CEILING(-1.23) "); - assure("CEILING(1.23) failed!", row.getInt(1) == 2); - assure("CEILING(-1.23) failed!", row.getInt(2) == -1); - } - - private void round(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ROUND(-1.23),ROUND(1.298, 1) "); - assure("ROUND(-1.23) failed!", row.getInt(1) == -1); - assure("ROUND(1.298, 1) failed!", row.getDouble(2) == 1.3); - } - - private void exp(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "EXP(2),EXP(-2) "); - assure("EXP(2) failed!", (float) row.getDouble(1) == (float) java.lang.Math.exp(2)); - assure("EXP(-2) failed!", (float) row.getDouble(2) == (float) java.lang.Math.exp(-2)); - } - - private void log(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LOG(2),LOG(-2) "); - assure("LOG(2) failed!", (float) row.getDouble(1) == (float) java.lang.Math.log(2)); - row.getDouble(2); - assure("LOG(-2) failed!", row.wasNull()); - } - - private void log10(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LOG10(100) "); - assure("LOG10(100) failed!", row.getDouble(1) == 2.0); - } - - private void pow(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "POWER(2,2) "); - assure("POWER(2,2) failed!", row.getDouble(1) == 4.0); - } - - private void sqrt(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "SQRT(4) "); - assure("SQRT(4) failed!", row.getDouble(1) == 2.0); - } - - private void pi(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "PI() "); - assure("PI() failed!", (float) row.getDouble(1) == (float) java.lang.Math.PI); - } - - private void cos(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "COS(PI()) "); - assure("COS(PI()) failed!", row.getDouble(1) == -1.0); - } - - private void sin(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "SIN(2) "); - assure("SIN(PI()) failed!", (float) row.getDouble(1) == (float) java.lang.Math.sin(2)); - } - - private void tan(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "TAN(PI()+1) "); - assure("TAN(PI()+1) failed!", (float) row.getDouble(1) == (float) java.lang.Math.tan(java.lang.Math.PI + 1.0)); - } - - private void acos(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ACOS(1) "); - assure("ACOS(1) failed!", (float) row.getDouble(1) == 0.0); - } - - private void asin(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ASIN(0) "); - assure("ASIN(0) failed!", (float) row.getDouble(1) == (float) java.lang.Math.asin(0.0)); - } - - private void atan(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ATAN(0) "); - assure("ATAN(0) failed!", row.getDouble(1) == 0.0); - } - - private void atan2(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ATAN2(0,2) "); - assure("ATAN2(0,2) failed!", (float) row.getDouble(1) == 0.0); - } - - private void degrees(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "DEGREES(PI()) "); - assure("DEGREES(PI()) failed!", row.getDouble(1) == 180.0); - } - - private void radians(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "RADIANS(90) "); - assure("RADIANS(90) failed!", (float) row.getDouble(1) == (float) (java.lang.Math.PI / 2.0)); - } -} diff --git a/connectivity/qa/complex/connectivity/dbase/DBaseSqlTests.java b/connectivity/qa/complex/connectivity/dbase/DBaseSqlTests.java deleted file mode 100755 index 8f6c26b044..0000000000 --- a/connectivity/qa/complex/connectivity/dbase/DBaseSqlTests.java +++ /dev/null @@ -1,92 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity.dbase; - -import com.sun.star.uno.UnoRuntime; -import com.sun.star.sdbc.*; -import com.sun.star.beans.XPropertySet; -import com.sun.star.lang.XMultiServiceFactory; -import complex.connectivity.TestCase; -import complex.connectivity.SubTestCase; - -public class DBaseSqlTests extends SubTestCase -{ - private final XMultiServiceFactory m_xORB; - - public DBaseSqlTests(final XMultiServiceFactory _xORB,final TestCase i_testCase) - { - super( i_testCase ); - m_xORB = _xORB; - } - - public void testFunctions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRowSet xRowRes = (XRowSet) UnoRuntime.queryInterface(XRowSet.class, - m_xORB.createInstance("com.sun.star.sdb.RowSet")); - - getLog().println("starting SQL test"); - // set the properties needed to connect to a database - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("DataSourceName", "Bibliography"); - xProp.setPropertyValue("CommandType", Integer.valueOf(com.sun.star.sdb.CommandType.COMMAND)); - - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where \"Identifier\" like 'B%'"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where not \"Identifier\" like 'B%'"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where not \"Identifier\" not like 'B%'"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where not(0 = 1)"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where 0 = 0"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where (0 = 0)"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where 0 <> 1"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where 0 < 1"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where 2 > 1"); - execute(xRowRes,"1,1+1,'a' + 'b' FROM \"biblio\" \"biblio\" where 2 > 1"); - // execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where (0 = 0) is true"); - // execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where not (0 = 0) is not true"); - // execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where 1 between 0 and 2"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where not \"Identifier\" is NULL"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where \"Identifier\" is not NULL"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where \"Identifier\" = \"Identifier\""); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where not(not(\"Identifier\" = \"Identifier\"))"); - execute(xRowRes,"1 FROM \"biblio\" \"biblio\" where (1 = 1 and 2 = 1) or 3 = 33 or 4 = 44 or ('a' = 'a' and 'b' = 'b')"); - } - - private void execute(final XRowSet xRowRes, String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - try - { - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("Command", "SELECT " + sql); - xRowRes.execute(); - } - catch(SQLException e) - { - getLog().println(sql + " Error: " + e.getMessage()); - } - } - - -} diff --git a/connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java b/connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java deleted file mode 100755 index 7029afa8f2..0000000000 --- a/connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java +++ /dev/null @@ -1,319 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package complex.connectivity.dbase; - -import com.sun.star.uno.UnoRuntime; -import com.sun.star.sdbc.*; -import com.sun.star.beans.XPropertySet; -import com.sun.star.lang.XMultiServiceFactory; -import complex.connectivity.SubTestCase; -import complex.connectivity.TestCase; - -public class DBaseStringFunctions extends SubTestCase -{ - private String where = "FROM \"biblio\" \"biblio\" where \"Identifier\" = 'BOR00'"; - private final XMultiServiceFactory m_xORB; - - public DBaseStringFunctions(final XMultiServiceFactory _xORB,final TestCase i_testCase) - { - super( i_testCase ); - m_xORB = _xORB; - } - - public void testFunctions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRowSet xRowRes = (XRowSet) UnoRuntime.queryInterface(XRowSet.class, - m_xORB.createInstance("com.sun.star.sdb.RowSet")); - - getLog().println("starting String function test"); - // set the properties needed to connect to a database - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("DataSourceName", "Bibliography"); - - xProp.setPropertyValue("CommandType", Integer.valueOf(com.sun.star.sdb.CommandType.COMMAND)); - - try - { - upper(xRowRes); - } - catch (SQLException ex) - { - assure("upper " + ex.getMessage(), false); - throw ex; - } - try - { - lower(xRowRes); - } - catch (SQLException ex) - { - assure("lower " + ex.getMessage(), false); - throw ex; - } - try - { - acsii(xRowRes); - } - catch (SQLException ex) - { - assure("ascii " + ex.getMessage(), false); - throw ex; - } - try - { - char_length(xRowRes); - } - catch (SQLException ex) - { - assure("char_len " + ex.getMessage(), false); - throw ex; - } - try - { - concat(xRowRes); - } - catch (SQLException ex) - { - assure("concat " + ex.getMessage(), false); - throw ex; - } - try - { - chartest(xRowRes); - } - catch (SQLException ex) - { - assure("char " + ex.getMessage(), false); - throw ex; - } - try - { - locate(xRowRes); - } - catch (SQLException ex) - { - assure("locate " + ex.getMessage(), false); - throw ex; - } - try - { - substring(xRowRes); - } - catch (SQLException ex) - { - assure("substr " + ex.getMessage(), false); - throw ex; - } - try - { - ltrim(xRowRes); - } - catch (SQLException ex) - { - assure("ltrim " + ex.getMessage(), false); - throw ex; - } - try - { - rtrim(xRowRes); - } - catch (SQLException ex) - { - assure("rtrim " + ex.getMessage(), false); - throw ex; - } - try - { - space(xRowRes); - } - catch (SQLException ex) - { - assure("space " + ex.getMessage(), false); - throw ex; - } - try - { - replace(xRowRes); - } - catch (SQLException ex) - { - assure("replace " + ex.getMessage(), false); - throw ex; - } - try - { - repeat(xRowRes); - } - catch (SQLException ex) - { - assure("repeat " + ex.getMessage(), false); - throw ex; - } - try - { - insert(xRowRes); - } - catch (SQLException ex) - { - assure("insert " + ex.getMessage(), false); - throw ex; - } - try - { - left(xRowRes); - } - catch (SQLException ex) - { - assure("left " + ex.getMessage(), false); - throw ex; - } - try - { - right(xRowRes); - } - catch (SQLException ex) - { - assure("right " + ex.getMessage(), false); - throw ex; - } - } - - private XRow execute(final XRowSet xRowRes, String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("Command", "SELECT " + sql + where); - xRowRes.execute(); - final XResultSet xRes = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, xRowRes); - assure("No valid row! ", xRes.next()); - - return (XRow) UnoRuntime.queryInterface(XRow.class, xRes); - } - - private void upper(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "upper('test'),UCASE('test') "); - assure("upper('test') failed!", row.getString(1).equals("TEST")); - assure("ucase('test') failed!", row.getString(2).equals("TEST")); - } - - private void lower(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "lower('TEST'),LCASE('TEST') "); - assure("lower('TEST') failed!", row.getString(1).equals("test")); - assure("lcase('TEST') failed!", row.getString(2).equals("test")); - final String temp = where; - where = "FROM \"biblio\" \"biblio\" where LOWER(\"Identifier\") like 'bor%'"; - execute(xRowRes, "lower('TEST'),LCASE('TEST') "); - where = temp; - } - - private void acsii(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ASCII('2') "); - assure("acsii('2') failed!", row.getInt(1) == 50); - } - - private void char_length(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "char_length('test'),character_length('test'),OCTET_LENGTH('test') "); - assure("char_length('test') failed!", row.getInt(1) == 4); - assure("character_length('test') failed!", row.getInt(2) == 4); - assure("OCTET_LENGTH('test') failed!", row.getInt(3) == 4); - } - - private void concat(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "CONCAT('Hello',' ','World') "); - assure("CONCAT('Hello',' ',,'World') failed!", row.getString(1).equals("Hello World")); - } - - private void locate(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LOCATE('bar', 'foobarbar') "); - assure("LOCATE('bar', 'foobarbar') failed!", row.getInt(1) == 4); - } - - private void substring(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "SUBSTRING('Quadratically',5) "); - assure("SUBSTRING('Quadratically',5) failed!", row.getString(1).equals("ratically")); - } - - private void ltrim(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LTRIM(' barbar') "); - assure("LTRIM(' barbar') failed!", row.getString(1).equals("barbar")); - } - - private void rtrim(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "RTRIM('barbar ') "); - assure("RTRIM('barbar ') failed!", row.getString(1).equals("barbar")); - } - - private void space(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "space(6) "); - assure("space(6) failed!", row.getString(1).equals(" ")); - } - - private void replace(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "REPLACE('www.OOo.com', 'w', 'Ww') "); - assure("REPLACE('www.OOo.com', 'w', 'Ww') failed!", row.getString(1).equals("WwWwWw.OOo.com")); - } - - private void repeat(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "REPEAT('OOo', 3) "); - assure("REPEAT('OOo', 3) failed!", row.getString(1).equals("OOoOOoOOo")); - } - - private void insert(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "INSERT('Quadratic', 3, 4, 'What') "); - assure("INSERT('Quadratic', 3, 4, 'What') failed!", row.getString(1).equals("QuWhattic")); - } - - private void left(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LEFT('foobarbar', 5) "); - assure("LEFT('foobarbar', 5) failed!", row.getString(1).equals("fooba")); - } - - private void right(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "RIGHT('foobarbar', 4) "); - assure("RIGHT('foobarbar', 4) failed!", row.getString(1).equals("rbar")); - } - - private void chartest(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) "); - assure("CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) failed!", row.getString(1).equals("test")); - } -} diff --git a/connectivity/qa/complex/connectivity/hsqldb/DatabaseMetaData.java b/connectivity/qa/complex/connectivity/hsqldb/DatabaseMetaData.java deleted file mode 100755 index 359491c822..0000000000 --- a/connectivity/qa/complex/connectivity/hsqldb/DatabaseMetaData.java +++ /dev/null @@ -1,150 +0,0 @@ -/* - * Class.java - * - * Created on June 23, 2003, 3:19 PM - */ - -/** - * - * @author oj93728 - */ -package complex.connectivity.hsqldb; -import complex.connectivity.HsqlDriverTest; -import java.sql.*; -import java.lang.reflect.Method; - - -public class DatabaseMetaData { - - private java.sql.DatabaseMetaData m_xMD; - private HsqlDriverTest m_TestCase; - - /** Creates a new instance of DatabaseMetaData */ - public DatabaseMetaData(HsqlDriverTest _testCase,java.sql.DatabaseMetaData _xmd) { - m_TestCase = _testCase; - m_xMD = _xmd; - } - - protected void assure(String _sText,boolean btest){ - m_TestCase.assurePublic(_sText,btest); - } - - protected void testMethod(String sName,Class[] params,Object[] objParams,int nCount){ - try { - System.out.println("test method " + sName); - - Method aGet = ((Object)m_xMD).getClass().getDeclaredMethod(sName, params); - if ( aGet != null ){ - ResultSet rs = (ResultSet)aGet.invoke(m_xMD, objParams); - ResultSetMetaData rsMD = rs.getMetaData(); - - assure( sName + " returns wrong column count" , rsMD.getColumnCount() == nCount); - } - else - assure( sName + " returns wrong column count" , false); - } catch( java.lang.NoSuchMethodException ex ) { - assure("Method " + sName + " could not be found!",false); - } catch( java.lang.IllegalAccessException ex ) { - assure("IllegalAccessException!",false); - } catch( SQLException ex ) { - assure("SQLException occurred: " + ex.getMessage() ,false); - } catch( java.lang.reflect.InvocationTargetException ex ) { - assure("IllegalAccessException!",false); - } finally { - - } - } - - public void test(){ - - // try { - - try{ - ResultSet rs = m_xMD.getTables(null,null,"TESTCASE",null); - while ( rs.next() ) - { - String catalog = rs.getString( 1 ); - if ( rs.wasNull() ) - catalog = null; - - String schema = rs.getString( 2 ); - if ( rs.wasNull() ) - schema = null; - - String table = rs.getString( 3 ); - String type = rs.getString( 4 ); - System.out.println("Catalog: " + catalog + " Schema: " + schema + " Table: " + table + " Type: " + type); - System.out.println("------------------ Columns ------------------"); - ResultSet rsColumns = m_xMD.getColumns(catalog,schema,table,"%"); - while ( rsColumns.next() ) - { - System.out.println("Column: " + rsColumns.getString( 4 ) + " Type: " + rsColumns.getInt( 5 ) + " TypeName: " + rsColumns.getString( 6 ) ); - } - - } - } catch(Exception e){ - - } - //testMethod("getTypeInfo", zclass,empty,17); -/* - Class[] zclass = new Class[]{}; - Object[] empty = new Object[]{}; - testMethod("getCatalogs", zclass,empty,1); - - testMethod("getSchemas", zclass,empty,2); - testMethod("getTableTypes", zclass,empty,1); - Class[] a4 = new Class[4]; - Object[] o4 = new Object[4]; - a4[0] = Class.forName("java.lang.Object"); - a4[1] = Class.forName("java.lang.String"); - a4[2] = Class.forName("java.lang.String"); - a4[3] = Class.forName("java.lang.String"); - - o4[0] = null; - o4[1] = null; - o4[2] = null; - o4[3] = "%"; - testMethod("getColumnPrivileges", a4,o4,7); - testMethod("getColumns", a4,o4,18); - testMethod("getProcedureColumns", a4,o4,13); - testMethod("getColumns", a4,o4,18); - - Class[] a3 = new Class[3]; - Object[] o3 = new Object[3]; - a3[0] = Class.forName("java.lang.Object"); - a3[1] = Class.forName("java.lang.String"); - a3[2] = Class.forName("java.lang.String"); - - o3[0] = null; - o3[1] = null; - o3[2] = "%"; - - testMethod("getExportedKeys", a3,o3,14); - testMethod("getImportedKeys", a3,o3,14); - testMethod("getPrimaryKeys", a3,o3,14); - testMethod("getProcedures", a3,o3,5); - testMethod("getTablePrivileges", a3,o3,6); - testMethod("getVersionColumns", a3,o3,7); - // testMethod("getCrossReference", a3,o3,14); - - } catch( java.lang.ClassNotFoundException ex) { - assure("ClassNotFoundException: " + ex.getMessage() ,false); - } - */ - } -/* - public com.sun.star.sdbc.XResultSet getCrossReference(Object obj, String str, String str2, Object obj3, String str4, String str5) { - } - public com.sun.star.sdbc.XResultSet getIndexInfo(Object obj, String str, String str2, boolean param, boolean param4) { - } - - public com.sun.star.sdbc.XResultSet getTables(Object obj, String str, String str2, String[] str3) { - } - - public com.sun.star.sdbc.XResultSet getUDTs(Object obj, String str, String str2, int[] values) { - } - - public com.sun.star.sdbc.XResultSet getBestRowIdentifier(Object obj, String str, String str2, int param, boolean param4) throws com.sun.star.sdbc.SQLException { - } - */ -} diff --git a/connectivity/qa/complex/connectivity/hsqldb/TestCacheSize.java b/connectivity/qa/complex/connectivity/hsqldb/TestCacheSize.java deleted file mode 100755 index 54abbeb3b4..0000000000 --- a/connectivity/qa/complex/connectivity/hsqldb/TestCacheSize.java +++ /dev/null @@ -1,609 +0,0 @@ -/* Copyright (c) 2001-2004, The HSQL Development Group - * All rights reserved. - * - * Redistribution and use in source and binary forms, with or without - * modification, are permitted provided that the following conditions are met: - * - * Redistributions of source code must retain the above copyright notice, this - * list of conditions and the following disclaimer. - * - * Redistributions in binary form must reproduce the above copyright notice, - * this list of conditions and the following disclaimer in the documentation - * and/or other materials provided with the distribution. - * - * Neither the name of the HSQL Development Group nor the names of its - * contributors may be used to endorse or promote products derived from this - * software without specific prior written permission. - * - * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" - * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE - * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE - * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG, - * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, - * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, - * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; - * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND - * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT - * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS - * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. - */ - - -package complex.connectivity.hsqldb; - - - -import org.hsqldb.lib.StopWatch; - -import java.util.Random; -import com.sun.star.lang.*; -import com.sun.star.uno.UnoRuntime; -import com.sun.star.sdbc.*; - -/** - * Test large cached tables by setting up a cached table of 100000 records - * or more and a much smaller memory table with about 1/100th rows used. - * Populate both tables so that an indexed column of the cached table has a - * foreign key reference to the main table. - * - * This database can be used to demonstrate efficient queries to retrieve - * the data from the cached table. - * - * 1.7.1 insert timings for 100000 rows, cache scale 12: - * simple table, no extra index: 52 s - * with index on lastname only: 56 s - * with index on zip only: 211 s - * foreign key, referential_integrity true: 216 s - * - * The above have improved a lot in 1.7.2 - * - * This test now incorporates the defunct TestTextTables - * - * @author fredt@users - * @version 1.7.2 - * @since 1.7.0 - */ -public class TestCacheSize { - - // program can edit the *.properties file to set cache_size - protected boolean filedb = true; - - // shutdown performed mid operation - not for mem: or hsql: URL's - protected boolean shutdown = true; - - // fixed - protected String url = "sdbc:embedded:hsqldb"; - - // frequent reporting of progress - boolean reportProgress = false; - - XMultiServiceFactory servicefactory = null; - - // type of the big table {MEMORY | CACHED | TEXT} - String tableType = "CACHED"; - int cacheScale = 17; - int cacheSizeScale = 8; - - // script format {TEXT, BINARY, COMPRESSED} - String logType = "TEXT"; - int writeDelay = 60; - boolean indexZip = true; - boolean indexLastName = false; - boolean addForeignKey = false; - boolean refIntegrity = true; - - // speeds up inserts when tableType=="CACHED" - boolean createTempTable = false; - - // introduces fragmentation to the .data file during insert - boolean deleteWhileInsert = false; - int deleteWhileInsertInterval = 10000; - - // size of the tables used in test - int bigrows = 10000; - int smallrows = 0xfff; - - // if the extra table needs to be created and filled up - boolean multikeytable = false; - - // - String user; - String password; - XStatement sStatement; - XConnection cConnection; - XDataSource ds; - XDriver drv; - com.sun.star.beans.PropertyValue[] info; - - public TestCacheSize(XMultiServiceFactory _xmulti,com.sun.star.beans.PropertyValue[] _info,XDriver _drv){ - servicefactory = _xmulti; - drv = _drv; - info = _info; - } - - public void setURL(String _url){ - url = _url; - } - - public void setUp() { - - user = "sa"; - password = ""; - - try { - sStatement = null; - cConnection = null; - - //Class.forName("org.hsqldb.jdbcDriver"); - - if (filedb) { - - cConnection = drv.connect(url,info); - sStatement = cConnection.createStatement(); - - sStatement.execute("SET SCRIPTFORMAT " + logType); - sStatement.execute("SET LOGSIZE " + 0); - sStatement.execute("SHUTDOWN"); - cConnection.close(); -// props.setProperty("hsqldb.cache_scale", "" + cacheScale); -// props.setProperty("hsqldb.cache_size_scale", - //"" + cacheSizeScale); - } - } catch (Exception e) { - e.printStackTrace(); - System.out.println("TestSql.setUp() error: " + e.getMessage()); - } - } - - /** - * Fill up the cache - * - * - */ - public void testFillUp() { - - StopWatch sw = new StopWatch(); - String ddl1 = "DROP TABLE test IF EXISTS;" - + "DROP TABLE zip IF EXISTS;"; - String ddl2 = "CREATE CACHED TABLE zip( zip INT IDENTITY );"; - String ddl3 = "CREATE " + tableType + " TABLE test( id INT IDENTITY," - + " firstname VARCHAR, " + " lastname VARCHAR, " - + " zip INTEGER, " + " filler VARCHAR); "; - String ddl31 = "SET TABLE test SOURCE \"test.csv;cache_scale=" - + cacheScale + "\";"; - - // adding extra index will slow down inserts a bit - String ddl4 = "CREATE INDEX idx1 ON TEST (lastname);"; - - // adding this index will slow down inserts a lot - String ddl5 = "CREATE INDEX idx2 ON TEST (zip);"; - - // referential integrity checks will slow down inserts a bit - String ddl6 = - "ALTER TABLE test add constraint c1 FOREIGN KEY (zip) REFERENCES zip(zip);"; - String ddl7 = "CREATE TEMP TABLE temptest( id INT," - + " firstname VARCHAR, " + " lastname VARCHAR, " - + " zip INTEGER, " + " filler VARCHAR); "; - String filler = - "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ" - + "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ"; - String mddl1 = "DROP TABLE test2 IF EXISTS;"; - String mddl2 = "CREATE " + tableType - + " TABLE test2( id1 INT, id2 INT," - + " firstname VARCHAR, " + " lastname VARCHAR, " - + " zip INTEGER, " + " filler VARCHAR, " - + " PRIMARY KEY (id1,id2) ); "; - String mdd13 = "SET TABLE test2 SOURCE \"test2.csv;cache_scale=" - + cacheScale + "\";"; - - try { - System.out.println("Connecting"); - sw.zero(); - - cConnection = null; - sStatement = null; - cConnection = drv.connect(url,info); - - System.out.println("connected: " + sw.elapsedTime()); - sw.zero(); - - sStatement = cConnection.createStatement(); - - java.util.Random randomgen = new java.util.Random(); - - sStatement.execute("SET WRITE_DELAY " + writeDelay); - sStatement.execute(ddl1); - sStatement.execute(ddl2); - sStatement.execute(ddl3); - - if (tableType.equals("TEXT")) { - sStatement.execute(ddl31); - } - - System.out.println("test table with no index"); - - if (indexLastName) { - sStatement.execute(ddl4); - System.out.println("create index on lastname"); - } - - if (indexZip) { - sStatement.execute(ddl5); - System.out.println("create index on zip"); - } - - if (addForeignKey) { - sStatement.execute(ddl6); - System.out.println("add foreign key"); - } - - if (createTempTable) { - sStatement.execute(ddl7); - System.out.println("temp table"); - } - - if (multikeytable) { - sStatement.execute(mddl1); - sStatement.execute(mddl2); - - if (tableType.equals("TEXT")) { - sStatement.execute(mdd13); - } - - System.out.println("multi key table"); - } - -// sStatement.execute("CREATE INDEX idx3 ON tempTEST (zip);"); - System.out.println("Setup time: " + sw.elapsedTime()); - fillUpBigTable(filler, randomgen); - - if (multikeytable) { - fillUpMultiTable(filler, randomgen); - } - - sw.zero(); - - if (shutdown) { - sStatement.execute("SHUTDOWN"); - System.out.println("Shutdown Time: " + sw.elapsedTime()); - } - - cConnection.close(); - } catch (SQLException e) { - System.out.println(e.getMessage()); - } - } - - private void fillUpBigTable(String filler, - Random randomgen) throws SQLException { - - StopWatch sw = new StopWatch(); - int i; - - for (i = 0; i <= smallrows; i++) { - sStatement.execute("INSERT INTO zip VALUES(null);"); - } - - sStatement.execute("SET REFERENTIAL_INTEGRITY " + this.refIntegrity - + ";"); - - XPreparedStatement ps = cConnection.prepareStatement( - "INSERT INTO test (firstname,lastname,zip,filler) VALUES (?,?,?,?)"); - - XParameters para = (XParameters)UnoRuntime.queryInterface(XParameters.class,ps); - para.setString(1, "Julia"); - para.setString(2, "Clancy"); - - for (i = 0; i < bigrows; i++) { - para.setInt(3, randomgen.nextInt(smallrows)); - - long nextrandom = randomgen.nextLong(); - int randomlength = (int) nextrandom & 0x7f; - - if (randomlength > filler.length()) { - randomlength = filler.length(); - } - - String varfiller = filler.substring(0, randomlength); - - para.setString(4, nextrandom + varfiller); - ps.execute(); - - if (reportProgress && (i + 1) % 10000 == 0) { - System.out.println("Insert " + (i + 1) + " : " - + sw.elapsedTime()); - } - - // delete and add 4000 rows to introduce fragmentation - if (deleteWhileInsert && i != 0 - && i % deleteWhileInsertInterval == 0) { - sStatement.execute("CALL IDENTITY();"); - - XMultipleResults mrs = (XMultipleResults)UnoRuntime.queryInterface(XMultipleResults.class,sStatement); - XResultSet rs = mrs.getResultSet(); - - rs.next(); - - XRow row = (XRow)UnoRuntime.queryInterface(XRow.class,rs); - int lastId = row.getInt(1); - - sStatement.execute( - "SELECT * INTO TEMP tempt FROM test WHERE id > " - + (lastId - 4000) + " ;"); - sStatement.execute("DELETE FROM test WHERE id > " - + (lastId - 4000) + " ;"); - sStatement.execute("INSERT INTO test SELECT * FROM tempt;"); - sStatement.execute("DROP TABLE tempt;"); - } - } - -// sStatement.execute("INSERT INTO test SELECT * FROM temptest;"); -// sStatement.execute("DROP TABLE temptest;"); -// sStatement.execute(ddl7); - System.out.println("Total insert: " + i); - System.out.println("Insert time: " + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - } - - private void fillUpMultiTable(String filler, - Random randomgen) throws SQLException { - - StopWatch sw = new StopWatch(); - int i; - XPreparedStatement ps = cConnection.prepareStatement( - "INSERT INTO test2 (id1, id2, firstname,lastname,zip,filler) VALUES (?,?,?,?,?,?)"); - - XParameters para = (XParameters)UnoRuntime.queryInterface(XParameters.class,ps); - para.setString(3, "Julia"); - para.setString(4, "Clancy"); - - int id1 = 0; - - for (i = 0; i < bigrows; i++) { - int id2 = randomgen.nextInt(Integer.MAX_VALUE); - - if (i % 1000 == 0) { - id1 = randomgen.nextInt(Integer.MAX_VALUE); - } - - para.setInt(1, id1); - para.setInt(2, id2); - para.setInt(5, randomgen.nextInt(smallrows)); - - long nextrandom = randomgen.nextLong(); - int randomlength = (int) nextrandom & 0x7f; - - if (randomlength > filler.length()) { - randomlength = filler.length(); - } - - String varfiller = filler.substring(0, randomlength); - - para.setString(6, nextrandom + varfiller); - - try { - ps.execute(); - } catch (SQLException e) { - e.printStackTrace(); - } - - if (reportProgress && (i + 1) % 10000 == 0) { - System.out.println("Insert " + (i + 1) + " : " - + sw.elapsedTime()); - } - } - - System.out.println("Multi Key Total insert: " + i); - System.out.println("Insert time: " + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - } - - public void tearDown() {} - - public void checkResults() { - - try { - StopWatch sw = new StopWatch(); - XResultSet rs; - - cConnection = drv.connect(url,info); - - System.out.println("Reopened database: " + sw.elapsedTime()); - sw.zero(); - - sStatement = cConnection.createStatement(); - - sStatement.execute("SET WRITE_DELAY " + writeDelay); - - // the tests use different indexes - // use primary index - sStatement.execute("SELECT count(*) from TEST"); - - XMultipleResults mrs = (XMultipleResults)UnoRuntime.queryInterface(XMultipleResults.class,sStatement); - rs = mrs.getResultSet(); - XRow row = (XRow)UnoRuntime.queryInterface(XRow.class,rs); - - rs.next(); - System.out.println("Row Count: " + row.getInt(1)); - System.out.println("Time to count: " + sw.elapsedTime()); - - // use index on zip - sw.zero(); - sStatement.execute("SELECT count(*) from TEST where zip > -1"); - - rs = mrs.getResultSet(); - - rs.next(); - System.out.println("Row Count: " + row.getInt(1)); - System.out.println("Time to count: " + sw.elapsedTime()); - checkSelects(); - checkUpdates(); - checkSelects(); - sw.zero(); - sStatement.execute("SELECT count(*) from TEST where zip > -1"); - - rs = mrs.getResultSet(); - - rs.next(); - System.out.println("Row Count: " + row.getInt(1)); - System.out.println("Time to count: " + sw.elapsedTime()); - sw.zero(); - - if (shutdown) { - sStatement.execute("SHUTDOWN"); - System.out.println("Shutdown Time: " + sw.elapsedTime()); - } - - cConnection.close(); - System.out.println("Closed database: " + sw.elapsedTime()); - } catch (SQLException e) { - e.printStackTrace(); - } - } - - private void checkSelects() { - - StopWatch sw = new StopWatch(); - java.util.Random randomgen = new java.util.Random(); - int i = 0; - boolean slow = false; - - try { - XPreparedStatement ps = cConnection.prepareStatement( - "SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?"); - XParameters para = (XParameters)UnoRuntime.queryInterface(XParameters.class,ps); - - for (; i < bigrows; i++) { - para.setInt(1, randomgen.nextInt(smallrows)); - ps.execute(); - - if ((i + 1) == 100 && sw.elapsedTime() > 5000) { - slow = true; - } - - if (reportProgress && (i + 1) % 10000 == 0 - || (slow && (i + 1) % 100 == 0)) { - System.out.println("Select " + (i + 1) + " : " - + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - } - } - } catch (SQLException e) { - e.printStackTrace(); - } - - System.out.println("Select random zip " + i + " rows : " - + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - sw.zero(); - - try { - XPreparedStatement ps = cConnection.prepareStatement( - "SELECT firstname,lastname,zip,filler FROM test WHERE id = ?"); - XParameters para = (XParameters)UnoRuntime.queryInterface(XParameters.class,ps); - - for (i = 0; i < bigrows; i++) { - para.setInt(1, randomgen.nextInt(bigrows - 1)); - ps.execute(); - - if (reportProgress && (i + 1) % 10000 == 0 - || (slow && (i + 1) % 100 == 0)) { - System.out.println("Select " + (i + 1) + " : " - + (sw.elapsedTime() + 1)); - } - } - } catch (SQLException e) { - e.printStackTrace(); - } - - System.out.println("Select random id " + i + " rows : " - + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - sw.zero(); - - try { - XPreparedStatement ps = cConnection.prepareStatement( - "SELECT zip FROM zip WHERE zip = ?"); - XParameters para = (XParameters)UnoRuntime.queryInterface(XParameters.class,ps); - - for (i = 0; i < bigrows; i++) { - para.setInt(1, randomgen.nextInt(smallrows - 1)); - ps.execute(); - - if (reportProgress && (i + 1) % 10000 == 0 - || (slow && (i + 1) % 100 == 0)) { - System.out.println("Select " + (i + 1) + " : " - + (sw.elapsedTime() + 1)); - } - } - } catch (SQLException e) { - e.printStackTrace(); - } - - System.out.println("Select random zip from zip table " + i - + " rows : " + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - } - - private void checkUpdates() { - - StopWatch sw = new StopWatch(); - java.util.Random randomgen = new java.util.Random(); - int i = 0; - boolean slow = false; - int count = 0; - - try { - XPreparedStatement ps = cConnection.prepareStatement( - "UPDATE test SET filler = filler || zip WHERE zip = ?"); - XParameters para = (XParameters)UnoRuntime.queryInterface(XParameters.class,ps); - - for (; i < smallrows; i++) { - int random = randomgen.nextInt(smallrows - 1); - - para.setInt(1, random); - - count += ps.executeUpdate(); - - if (reportProgress && count % 10000 < 20) { - System.out.println("Update " + count + " : " - + (sw.elapsedTime() + 1)); - } - } - } catch (SQLException e) { - e.printStackTrace(); - } - - System.out.println("Update with random zip " + i - + " UPDATE commands, " + count + " rows : " - + sw.elapsedTime() + " rps: " - + (count * 1000 / (sw.elapsedTime() + 1))); - sw.zero(); - - try { - XPreparedStatement ps = cConnection.prepareStatement( - "UPDATE test SET zip = zip + 1 WHERE id = ?"); - XParameters para = (XParameters)UnoRuntime.queryInterface(XParameters.class,ps); - - for (i = 0; i < bigrows; i++) { - int random = randomgen.nextInt(bigrows - 1); - - para.setInt(1, random); - ps.execute(); - - if (reportProgress && (i + 1) % 10000 == 0 - || (slow && (i + 1) % 100 == 0)) { - System.out.println("Update " + (i + 1) + " : " - + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - } - } - } catch (SQLException e) { - e.printStackTrace(); - } - - System.out.println("Update with random id " + i + " rows : " - + sw.elapsedTime() + " rps: " - + (i * 1000 / (sw.elapsedTime() + 1))); - } -} diff --git a/connectivity/qa/connectivity/tools/AbstractDatabase.java b/connectivity/qa/connectivity/tools/AbstractDatabase.java deleted file mode 100755 index 738a348840..0000000000 --- a/connectivity/qa/connectivity/tools/AbstractDatabase.java +++ /dev/null @@ -1,220 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package connectivity.tools; - -import com.sun.star.container.XNameAccess; -import com.sun.star.frame.XModel; -import com.sun.star.frame.XStorable; -import com.sun.star.io.IOException; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdb.XDocumentDataSource; -import com.sun.star.sdb.XOfficeDatabaseDocument; -import com.sun.star.sdbc.SQLException; -import com.sun.star.sdbc.XCloseable; -import com.sun.star.sdbc.XStatement; -import com.sun.star.uno.UnoRuntime; -import com.sun.star.util.CloseVetoException; -import connectivity.tools.sdb.Connection; -import java.io.File; - -/** - * - * @author oj93728 - */ -public abstract class AbstractDatabase implements DatabaseAccess -{ - public AbstractDatabase(final XMultiServiceFactory orb) throws Exception - { - m_orb = orb; - } - - // -------------------------------------------------------------------------------------------------------- - public AbstractDatabase(final XMultiServiceFactory orb, final String _existingDocumentURL ) throws Exception - { - m_orb = orb; - createDBDocument( _existingDocumentURL ); - } - - /** returns a connection to the database - * - * Multiple calls to this method return the same connection. The DbaseDatabase object keeps - * the ownership of the connection, so you don't need to (and should not) dispose/close it. - */ - public Connection defaultConnection() throws SQLException - { - if ( m_connection == null ) - m_connection = new Connection( m_databaseDocument.getDataSource().getConnection("", "") ); - - return m_connection; - } - - /** executes the given SQL statement via the defaultConnection - */ - public void executeSQL(final String statementString) throws SQLException - { - final XStatement statement = defaultConnection().createStatement(); - statement.execute(statementString); - } - - /** stores the database document - */ - public void store() throws IOException - { - if (m_databaseDocument != null) - { - final XStorable storeDoc = UnoRuntime.queryInterface(XStorable.class, m_databaseDocument); - storeDoc.store(); - } - } - - /** closes the database document - * - * Any CloseVetoExceptions fired by third parties are ignored, and any reference to the - * database document is released. - */ - public void close() - { - // close connection - final XCloseable closeConn = UnoRuntime.queryInterface( XCloseable.class, - m_connection != null ? m_connection.getXConnection() : null ); - if (closeConn != null) - { - try - { - closeConn.close(); - } - catch (SQLException e) - { - } - } - m_connection = null; - - // close document - final com.sun.star.util.XCloseable closeDoc = UnoRuntime.queryInterface( com.sun.star.util.XCloseable.class, m_databaseDocument ); - if (closeDoc != null) - { - try - { - closeDoc.close(true); - } - catch (CloseVetoException e) - { - } - } - m_databaseDocument = null; - } - - /** closes the document, and deletes the underlying file - */ - public void closeAndDelete() - { - close(); - - if (m_databaseDocumentFile != null) - { - try - { - final File file = new File(m_databaseDocumentFile); - file.delete(); - } - catch (Exception e) - { - } - } - } - - /** returns the underlying database document - */ - public XOfficeDatabaseDocument getDatabaseDocument() - { - return m_databaseDocument; - } - - /** returns the model interface of the underlying database document - */ - public XModel getModel() - { - return UnoRuntime.queryInterface( XModel.class, m_databaseDocument ); - } - - public XMultiServiceFactory getORB() - { - return m_orb; - } - - // -------------------------------------------------------------------------------------------------------- - final protected void createDBDocument(final String _docURL) throws Exception - { - m_databaseDocumentFile = _docURL; - - final XNameAccess dbContext = UnoRuntime.queryInterface( XNameAccess.class, - m_orb.createInstance( "com.sun.star.sdb.DatabaseContext" ) ); - final XDocumentDataSource dataSource = UnoRuntime.queryInterface( XDocumentDataSource.class, dbContext.getByName( _docURL ) ); - - m_databaseDocument = dataSource.getDatabaseDocument(); - m_dataSource = new DataSource(m_orb, m_databaseDocument.getDataSource()); - } - - /** returns the URL of the ODB document represented by this instance - */ - public String getDocumentURL() - { - return m_databaseDocumentFile; - } - - /** returns the data source belonging to this database - */ - public DataSource getDataSource() - { - return m_dataSource; - } - - /** creates a row set operating the database, with a given command/type - */ - public RowSet createRowSet(final int _commandType, final String _command) - { - return new RowSet(m_orb, getDocumentURL(), _commandType, _command); - } - - @Override - protected void finalize() throws Throwable - { - closeAndDelete(); - super.finalize(); - } - - // the service factory - protected final XMultiServiceFactory m_orb; - // the URL of the temporary file used for the database document - protected String m_databaseDocumentFile; - // the database document - protected XOfficeDatabaseDocument m_databaseDocument; - // the data source belonging to the database document - protected DataSource m_dataSource; - // the default connection - protected Connection m_connection; -} diff --git a/connectivity/qa/connectivity/tools/CRMDatabase.java b/connectivity/qa/connectivity/tools/CRMDatabase.java deleted file mode 100755 index c6287bdca4..0000000000 --- a/connectivity/qa/connectivity/tools/CRMDatabase.java +++ /dev/null @@ -1,295 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package connectivity.tools; - -import com.sun.star.beans.PropertyValue; -import com.sun.star.beans.PropertyState; -import com.sun.star.container.ElementExistException; -import com.sun.star.container.NoSuchElementException; -import com.sun.star.frame.XComponentLoader; -import com.sun.star.frame.XController; -import com.sun.star.frame.XModel; -import com.sun.star.io.IOException; -import com.sun.star.lang.IllegalArgumentException; -import com.sun.star.lang.WrappedTargetException; -import com.sun.star.lang.XComponent; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdb.XSingleSelectQueryComposer; -import com.sun.star.sdb.application.XDatabaseDocumentUI; -import com.sun.star.sdbc.SQLException; -import com.sun.star.sdbcx.XTablesSupplier; -import com.sun.star.uno.UnoRuntime; -import com.sun.star.util.XRefreshable; -import connectivity.tools.sdb.Connection; - -/** implements a small Customer Relationship Management database - * - * Not finished, by far. Feel free to add features as you need them. - */ -public class CRMDatabase -{ - private static final String INTEGER = "INTEGER"; - private static final String VARCHAR50 = "VARCHAR(50)"; - private final XMultiServiceFactory m_orb; - private final HsqlDatabase m_database; - private final DataSource m_dataSource; - private final Connection m_connection; - - /** constructs the CRM database - */ - public CRMDatabase( XMultiServiceFactory _orb, boolean _withUI ) throws Exception - { - m_orb = _orb; - - m_database = new HsqlDatabase( m_orb ); - m_dataSource = m_database.getDataSource(); - - if ( _withUI ) - { - final XComponentLoader loader = UnoRuntime.queryInterface( XComponentLoader.class, - m_orb.createInstance( "com.sun.star.frame.Desktop" ) ); - PropertyValue[] loadArgs = new PropertyValue[] { - new PropertyValue( "PickListEntry", 0, false, PropertyState.DIRECT_VALUE ) - }; - loader.loadComponentFromURL( m_database.getDocumentURL(), "_blank", 0, loadArgs ); - getDocumentUI().connect(); - m_connection = new Connection( getDocumentUI().getActiveConnection() ); - } - else - { - m_connection = m_database.defaultConnection(); - } - - createTables(); - createQueries(); - } - - /** - * creates a CRMDatabase from an existing document, given by URL - * @param _orb - * @param _existingDocumentURL - * @throws Exceptio - */ - public CRMDatabase( XMultiServiceFactory _orb, final String _existingDocumentURL ) throws Exception - { - m_orb = _orb; - - m_database = new HsqlDatabase( m_orb, _existingDocumentURL ); - m_dataSource = m_database.getDataSource(); - m_connection = m_database.defaultConnection(); - } - - // -------------------------------------------------------------------------------------------------------- - /** returns the database document underlying the CRM database - */ - public final HsqlDatabase getDatabase() - { - return m_database; - } - - // -------------------------------------------------------------------------------------------------------- - /** returns the default connection to the database - */ - public final Connection getConnection() - { - return m_connection; - } - - // -------------------------------------------------------------------------------------------------------- - public void saveAndClose() throws SQLException, IOException - { - XDatabaseDocumentUI ui = getDocumentUI(); - if ( ui != null ) - ui.closeSubComponents(); - m_database.store(); - m_database.closeAndDelete(); - } - - // -------------------------------------------------------------------------------------------------------- - public XDatabaseDocumentUI getDocumentUI() - { - XModel docModel = UnoRuntime.queryInterface( XModel.class, m_database.getDatabaseDocument() ); - return UnoRuntime.queryInterface( XDatabaseDocumentUI.class, docModel.getCurrentController() ); - } - - // -------------------------------------------------------------------------------------------------------- - public XController loadSubComponent( final int _objectType, final String _name ) throws IllegalArgumentException, SQLException, NoSuchElementException - { - XDatabaseDocumentUI docUI = getDocumentUI(); - if ( !docUI.isConnected() ) - docUI.connect(); - - XComponent subComponent = docUI.loadComponent( _objectType, _name, false ); - XController controller = UnoRuntime.queryInterface( XController.class, subComponent ); - if ( controller != null ) - return controller; - XModel document = UnoRuntime.queryInterface( XModel.class, subComponent ); - return document.getCurrentController(); - } - - // -------------------------------------------------------------------------------------------------------- - private void createTables() throws SQLException - { - HsqlTableDescriptor table = new HsqlTableDescriptor( "categories", - new HsqlColumnDescriptor[] { - new HsqlColumnDescriptor( "ID",INTEGER, HsqlColumnDescriptor.PRIMARY ), - new HsqlColumnDescriptor( "Name",VARCHAR50), - new HsqlColumnDescriptor( "Description", "VARCHAR(1024)" ), - new HsqlColumnDescriptor( "Image", "LONGVARBINARY" ) } ); - m_database.createTable( table, true ); - - m_database.executeSQL( "INSERT INTO \"categories\" ( \"ID\", \"Name\" ) VALUES ( 1, 'Food' )" ); - m_database.executeSQL( "INSERT INTO \"categories\" ( \"ID\", \"Name\" ) VALUES ( 2, 'Furniture' )" ); - - table = new HsqlTableDescriptor( "products", - new HsqlColumnDescriptor[] { - new HsqlColumnDescriptor( "ID",INTEGER, HsqlColumnDescriptor.PRIMARY ), - new HsqlColumnDescriptor( "Name",VARCHAR50), - new HsqlColumnDescriptor( "CategoryID",INTEGER, HsqlColumnDescriptor.REQUIRED, "categories", "ID" ) } ); - m_database.createTable( table, true ); - - m_database.executeSQL( "INSERT INTO \"products\" VALUES ( 1, 'Oranges', 1 )" ); - m_database.executeSQL( "INSERT INTO \"products\" VALUES ( 2, 'Apples', 1 )" ); - m_database.executeSQL( "INSERT INTO \"products\" VALUES ( 3, 'Pears', 1 )" ); - m_database.executeSQL( "INSERT INTO \"products\" VALUES ( 4, 'Strawberries', 1 )" ); - - table = new HsqlTableDescriptor( "customers", - new HsqlColumnDescriptor[] { - new HsqlColumnDescriptor( "ID",INTEGER, HsqlColumnDescriptor.PRIMARY ), - new HsqlColumnDescriptor( "Name",VARCHAR50), - new HsqlColumnDescriptor( "Address",VARCHAR50), - new HsqlColumnDescriptor( "City",VARCHAR50), - new HsqlColumnDescriptor( "Postal",VARCHAR50), - new HsqlColumnDescriptor( "Comment","LONGVARCHAR")} ); - m_database.createTable( table, true ); - - m_database.executeSQL( "INSERT INTO \"customers\" VALUES(1,'Food, Inc.','Down Under','Melbourne','509','Prefered') " ); - m_database.executeSQL( "INSERT INTO \"customers\" VALUES(2,'Simply Delicious','Down Under','Melbourne','518',null) " ); - m_database.executeSQL( "INSERT INTO \"customers\" VALUES(3,'Pure Health','10 Fish St.','San Francisco','94107',null) " ); - m_database.executeSQL( "INSERT INTO \"customers\" VALUES(4,'Milk And More','Arlington Road 21','Dublin','31021','Good one.') " ); - - table = new HsqlTableDescriptor( "orders", - new HsqlColumnDescriptor[] { - new HsqlColumnDescriptor( "ID",INTEGER, HsqlColumnDescriptor.PRIMARY ), - new HsqlColumnDescriptor( "CustomerID",INTEGER, HsqlColumnDescriptor.REQUIRED, "customers", "ID" ), - new HsqlColumnDescriptor( "OrderDate", "DATE" ), - new HsqlColumnDescriptor( "ShipDate", "DATE" ) } ); - m_database.createTable( table, true ); - - m_database.executeSQL( "INSERT INTO \"orders\" (\"ID\", \"CustomerID\", \"OrderDate\") VALUES(1, 1, {D '2009-01-01'})" ); - m_database.executeSQL( "INSERT INTO \"orders\" VALUES(2, 2, {D '2009-01-01'}, {D '2009-01-23'})" ); - - table = new HsqlTableDescriptor( "orders_details", - new HsqlColumnDescriptor[] { - new HsqlColumnDescriptor( "OrderID",INTEGER, HsqlColumnDescriptor.PRIMARY, "orders", "ID" ), - new HsqlColumnDescriptor( "ProductID",INTEGER, HsqlColumnDescriptor.PRIMARY, "products", "ID" ), - new HsqlColumnDescriptor( "Quantity",INTEGER) } ); - m_database.createTable( table, true ); - - m_database.executeSQL( "INSERT INTO \"orders_details\" VALUES(1, 1, 100)" ); - m_database.executeSQL( "INSERT INTO \"orders_details\" VALUES(1, 2, 100)" ); - m_database.executeSQL( "INSERT INTO \"orders_details\" VALUES(2, 2, 2000)" ); - m_database.executeSQL( "INSERT INTO \"orders_details\" VALUES(2, 3, 2000)" ); - m_database.executeSQL( "INSERT INTO \"orders_details\" VALUES(2, 4, 2000)" ); - - // since we created the tables by directly executing the SQL statements, we need to refresh - // the tables container - m_connection.refreshTables(); - } - - // -------------------------------------------------------------------------------------------------------- - private void validateUnparseable() - { - /* - // The "unparseable" query should be indeed be unparseable by OOo (though a valid HSQL query) - XSingleSelectQueryComposer composer; - QueryDefinition unparseableQuery; - try - { - final XMultiServiceFactory factory = UnoRuntime.queryInterface( - XMultiServiceFactory.class, m_database.defaultConnection().getXConnection() ); - composer = UnoRuntime.queryInterface( - XSingleSelectQueryComposer.class, factory.createInstance( "com.sun.star.sdb.SingleSelectQueryComposer" ) ); - unparseableQuery = m_dataSource.getQueryDefinition( "unparseable" ); - } - catch( Exception e ) - { - throw new RuntimeException( "caught an unexpected exception: " + e.getMessage() ); - } - - boolean caughtExpected = false; - try - { - composer.setQuery( unparseableQuery.getCommand() ); - } - catch (WrappedTargetException e) { } - catch( SQLException e ) - { - caughtExpected = true; - } - - if ( !caughtExpected ) - throw new RuntimeException( "Somebody improved the parser! This is bad :), since we need an unparsable query here!" ); - */ - } - - // -------------------------------------------------------------------------------------------------------- - private void createQueries() throws ElementExistException, WrappedTargetException, com.sun.star.lang.IllegalArgumentException - { - m_database.getDataSource().createQuery( - "all orders", - "SELECT \"orders\".\"ID\" AS \"Order No.\", " + - "\"customers\".\"Name\" AS \"Customer Name\", " + - "\"orders\".\"OrderDate\" AS \"Order Date\", " + - "\"orders\".\"ShipDate\" AS \"Ship Date\", " + - "\"orders_details\".\"Quantity\", " + - "\"products\".\"Name\" AS \"Product Name\" " + - "FROM \"orders_details\" AS \"orders_details\", " + - "\"orders\" AS \"orders\", " + - "\"products\" AS \"products\", " + - "\"customers\" AS \"customers\" " + - "WHERE ( \"orders_details\".\"OrderID\" = \"orders\".\"ID\" " + - "AND \"orders_details\".\"ProductID\" = \"products\".\"ID\" " + - "AND \"orders\".\"CustomerID\" = \"customers\".\"ID\" )" - ); - - m_database.getDataSource().createQuery( - "unshipped orders", - "SELECT * " + - "FROM \"all orders\"" + - "WHERE ( \"ShipDate\" IS NULL )" - ); - - m_database.getDataSource().createQuery( "parseable", "SELECT * FROM \"customers\"" ); - m_database.getDataSource().createQuery( "parseable native", "SELECT * FROM INFORMATION_SCHEMA.SYSTEM_VIEWS", false ); -/* - m_database.getDataSource().createQuery( "unparseable", - "SELECT {fn DAYOFMONTH ('2001-01-01')} AS \"ID_VARCHAR\" FROM \"products\"", false ); -*/ - validateUnparseable(); - } -} diff --git a/connectivity/qa/connectivity/tools/CsvDatabase.java b/connectivity/qa/connectivity/tools/CsvDatabase.java deleted file mode 100755 index f9f16a7182..0000000000 --- a/connectivity/qa/connectivity/tools/CsvDatabase.java +++ /dev/null @@ -1,18 +0,0 @@ -package connectivity.tools; - -import com.sun.star.lang.XMultiServiceFactory; - -public class CsvDatabase extends FlatFileDatabase -{ - // -------------------------------------------------------------------------------------------------------- - public CsvDatabase( final XMultiServiceFactory i_orb ) throws Exception - { - super( i_orb, "flat" ); - } - - // -------------------------------------------------------------------------------------------------------- - protected CsvDatabase( final XMultiServiceFactory i_orb, final String i_existingDocumentURL ) throws Exception - { - super( i_orb, i_existingDocumentURL, "flat" ); - } -} diff --git a/connectivity/qa/connectivity/tools/DataSource.java b/connectivity/qa/connectivity/tools/DataSource.java deleted file mode 100755 index a692ae0d81..0000000000 --- a/connectivity/qa/connectivity/tools/DataSource.java +++ /dev/null @@ -1,163 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -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.uno.Exception; -import com.sun.star.uno.UnoRuntime; -import java.util.logging.Level; -import java.util.logging.Logger; - -public class DataSource -{ - // the service factory - - private final XMultiServiceFactory m_orb; - private XDataSource m_dataSource; - - public DataSource(final XMultiServiceFactory _orb, final String _registeredName) throws Exception - { - m_orb = _orb; - - final XNameAccess dbContext = UnoRuntime.queryInterface( - XNameAccess.class, _orb.createInstance( "com.sun.star.sdb.DatabaseContext" ) ); - - m_dataSource = UnoRuntime.queryInterface( XDataSource.class, dbContext.getByName( _registeredName ) ); - } - - public DataSource(final XMultiServiceFactory _orb,final XDataSource _dataSource) - { - m_orb = _orb; - m_dataSource = _dataSource; - } - - final public XDataSource getXDataSource() - { - return m_dataSource; - } - - /** - * retrieves the data source's settings - */ - public XPropertySet geSettings() - { - return UnoRuntime.queryInterface( XPropertySet.class, impl_getPropertyValue( "Settings" ) ); - } - - /** creates a query with a given name and SQL command - */ - public void createQuery(final String _name, final 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(final String _name, final String _sqlCommand, final boolean _escapeProcessing) throws ElementExistException, WrappedTargetException, com.sun.star.lang.IllegalArgumentException - { - final XSingleServiceFactory queryDefsFac = UnoRuntime.queryInterface( XSingleServiceFactory.class, getQueryDefinitions() ); - XPropertySet queryDef = null; - try - { - queryDef = UnoRuntime.queryInterface( XPropertySet.class, queryDefsFac.createInstance() ); - queryDef.setPropertyValue("Command", _sqlCommand); - queryDef.setPropertyValue("EscapeProcessing", Boolean.valueOf(_escapeProcessing)); - } - catch (com.sun.star.uno.Exception e) - { - e.printStackTrace(System.err); - } - - final XNameContainer queryDefsContainer = UnoRuntime.queryInterface( XNameContainer.class, getQueryDefinitions() ); - queryDefsContainer.insertByName(_name, queryDef); - } - - /** provides the query definition with the given name - */ - public QueryDefinition getQueryDefinition(final String _name) throws NoSuchElementException - { - final XNameAccess allDefs = getQueryDefinitions(); - try - { - return new QueryDefinition( 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() - { - final XQueryDefinitionsSupplier suppQueries = UnoRuntime.queryInterface( - XQueryDefinitionsSupplier.class, m_dataSource); - return suppQueries.getQueryDefinitions(); - } - - /** - * retrieves a property value from the data source - * @param i_propertyName - * the name of the property whose value is to be returned. - */ - private Object impl_getPropertyValue( final String i_propertyName ) - { - Object propertyValue = null; - try - { - final XPropertySet dataSourceProps = UnoRuntime.queryInterface( XPropertySet.class, m_dataSource ); - propertyValue = dataSourceProps.getPropertyValue( i_propertyName ); - } - catch (Exception ex) - { - Logger.getLogger(DataSource.class.getName()).log(Level.SEVERE, null, ex); - } - return propertyValue; - } - - /** returns the name of the data source - * - * If a data source is registered at the database context, the name is the registration - * name. Otherwise, its the URL which the respective database document is based on. - * - * Note that the above definition is from the UNO API, not from this wrapper here. - */ - public String getName() - { - return (String)impl_getPropertyValue( "Name" ); - } -}; diff --git a/connectivity/qa/connectivity/tools/DatabaseAccess.java b/connectivity/qa/connectivity/tools/DatabaseAccess.java deleted file mode 100755 index b86866202b..0000000000 --- a/connectivity/qa/connectivity/tools/DatabaseAccess.java +++ /dev/null @@ -1,63 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package connectivity.tools; - -import com.sun.star.frame.XModel; -import com.sun.star.io.IOException; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdb.XOfficeDatabaseDocument; -import com.sun.star.sdbc.SQLException; -import connectivity.tools.sdb.Connection; - -/** - * - * @author oj93728 - */ -public interface DatabaseAccess -{ - Connection defaultConnection() throws SQLException; - - void executeSQL(final String statementString) throws SQLException; - - void store() throws IOException; - - void close(); - - void closeAndDelete(); - - XOfficeDatabaseDocument getDatabaseDocument(); - - XModel getModel(); - - String getDocumentURL(); - - DataSource getDataSource(); - - RowSet createRowSet(final int _commandType, final String _command); - - XMultiServiceFactory getORB(); -} diff --git a/connectivity/qa/connectivity/tools/DbaseDatabase.java b/connectivity/qa/connectivity/tools/DbaseDatabase.java deleted file mode 100755 index 19a44132ad..0000000000 --- a/connectivity/qa/connectivity/tools/DbaseDatabase.java +++ /dev/null @@ -1,18 +0,0 @@ -package connectivity.tools; - -import com.sun.star.lang.XMultiServiceFactory; - -public class DbaseDatabase extends FlatFileDatabase -{ - // -------------------------------------------------------------------------------------------------------- - public DbaseDatabase( final XMultiServiceFactory i_orb ) throws Exception - { - super( i_orb, "dbase" ); - } - - // -------------------------------------------------------------------------------------------------------- - protected DbaseDatabase( final XMultiServiceFactory i_orb, final String i_existingDocumentURL ) throws Exception - { - super( i_orb, i_existingDocumentURL, "dbase" ); - } -} diff --git a/connectivity/qa/connectivity/tools/FlatFileDatabase.java b/connectivity/qa/connectivity/tools/FlatFileDatabase.java deleted file mode 100755 index b0eca7c414..0000000000 --- a/connectivity/qa/connectivity/tools/FlatFileDatabase.java +++ /dev/null @@ -1,116 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package connectivity.tools; - -import com.sun.star.beans.PropertyValue; -import com.sun.star.beans.XPropertySet; -import com.sun.star.frame.XStorable; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdb.XOfficeDatabaseDocument; -import com.sun.star.sdbc.SQLException; -import com.sun.star.uno.UnoRuntime; - -import helper.URLHelper; -import java.io.File; - -class FlatFileDatabase extends AbstractDatabase -{ - // -------------------------------------------------------------------------------------------------------- - protected FlatFileDatabase( final XMultiServiceFactory i_orb, final String i_urlSubScheme ) throws Exception - { - super(i_orb); - m_urlSubScheme = i_urlSubScheme; - createDBDocument(); - } - - // -------------------------------------------------------------------------------------------------------- - protected FlatFileDatabase(final XMultiServiceFactory i_orb, final String i_existingDocumentURL, - final String i_urlSubScheme ) throws Exception - { - super( i_orb, i_existingDocumentURL ); - m_urlSubScheme = i_urlSubScheme; - - final XPropertySet dsProperties = UnoRuntime.queryInterface(XPropertySet.class, m_databaseDocument.getDataSource()); - final String url = (String)dsProperties.getPropertyValue( "URL" ); - final String expectedURLPrefix = "sdbc:" + m_urlSubScheme + ":"; - if ( !url.startsWith( expectedURLPrefix ) ) - throw new IllegalArgumentException( i_existingDocumentURL + " is of wrong type" ); - - final String location = url.substring( expectedURLPrefix.length() ); - m_tableFileLocation = new File( location ); - if ( m_tableFileLocation.isDirectory() ) - throw new IllegalArgumentException( "unsupported table file location (must be a folder)" ); - } - - /** - * returns a {@link File} which represents the folder where the database's table files reside. - */ - public File getTableFileLocation() - { - return m_tableFileLocation; - } - - /** creates an empty database document in a temporary location - */ - private void createDBDocument() throws Exception - { - final File documentFile = File.createTempFile( m_urlSubScheme, ".odb" ); - if ( documentFile.exists() ) - documentFile.delete(); - m_tableFileLocation = new File(documentFile.getParent() + File.separator + documentFile.getName().replace(".odb", "") + File.separator ); - m_tableFileLocation.mkdir(); - //subPath.deleteOnExit(); - m_databaseDocumentFile = URLHelper.getFileURLFromSystemPath(documentFile); - final String path = URLHelper.getFileURLFromSystemPath( m_tableFileLocation.getPath() ); - - m_databaseDocument = UnoRuntime.queryInterface( XOfficeDatabaseDocument.class, - m_orb.createInstance("com.sun.star.sdb.OfficeDatabaseDocument")); - m_dataSource = new DataSource(m_orb, m_databaseDocument.getDataSource()); - - final XPropertySet dsProperties = UnoRuntime.queryInterface(XPropertySet.class, m_databaseDocument.getDataSource()); - dsProperties.setPropertyValue("URL", "sdbc:" + m_urlSubScheme + ":" + path); - - final XStorable storable = UnoRuntime.queryInterface( XStorable.class, m_databaseDocument ); - storable.storeAsURL( m_databaseDocumentFile, new PropertyValue[] { } ); - } - - /** drops the table with a given name - - @param _name - the name of the table to drop - @param _ifExists - TRUE if it should be dropped only when it exists. - */ - public void dropTable(final String _name,final boolean _ifExists) throws SQLException - { - String dropStatement = "DROP TABLE \"" + _name; - executeSQL(dropStatement); - } - - final String m_urlSubScheme; - File m_tableFileLocation = null; -} diff --git a/connectivity/qa/connectivity/tools/HsqlColumnDescriptor.java b/connectivity/qa/connectivity/tools/HsqlColumnDescriptor.java deleted file mode 100755 index 824f7ebd2f..0000000000 --- a/connectivity/qa/connectivity/tools/HsqlColumnDescriptor.java +++ /dev/null @@ -1,84 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ - -package connectivity.tools; - -/** is a very simply and rudimentary descriptor of table columns, for creating HSQLDB tables - */ -public class HsqlColumnDescriptor -{ - private String Name; - private String TypeName; - private boolean Required; - private boolean PrimaryKey; - private String ForeignTable; - private String ForeignColumn; - - public final String getName() { return Name; } - public final String getTypeName() { return TypeName; } - public final boolean isRequired() { return Required; } - public final boolean isPrimaryKey() { return PrimaryKey; } - - public final boolean isForeignKey() { return ( ForeignTable.length() != 0 ) && ( ForeignColumn.length() != 0 ); } - public final String getForeignTable() { return ForeignTable; } - public final String getForeignColumn() { return ForeignColumn; } - - /// determines that a column is required, i.e. not nullable - public final static int REQUIRED = 1; - /// determines that a column is part of the primary key of its table - public final static int PRIMARY = 2; - - public HsqlColumnDescriptor( String _Name, String _TypeName ) - { - Name = _Name; - TypeName = _TypeName; - Required = false; - PrimaryKey = false; - ForeignTable = ""; - ForeignColumn = ""; - } - - public HsqlColumnDescriptor( String _Name, String _TypeName, int _Flags ) - { - Name = _Name; - TypeName = _TypeName; - Required = ( _Flags & REQUIRED ) != 0; - PrimaryKey = ( _Flags & PRIMARY ) != 0; - ForeignTable = ""; - ForeignColumn = ""; - } - - public HsqlColumnDescriptor( String _Name, String _TypeName, int _Flags, String _ForeignTable, String _ForeignColumn ) - { - Name = _Name; - TypeName = _TypeName; - Required = ( _Flags & REQUIRED ) != 0; - PrimaryKey = ( _Flags & PRIMARY ) != 0; - ForeignTable = _ForeignTable; - ForeignColumn = _ForeignColumn; - } -}; diff --git a/connectivity/qa/connectivity/tools/HsqlDatabase.java b/connectivity/qa/connectivity/tools/HsqlDatabase.java deleted file mode 100755 index d39a322f2f..0000000000 --- a/connectivity/qa/connectivity/tools/HsqlDatabase.java +++ /dev/null @@ -1,213 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ -package connectivity.tools; - -import com.sun.star.beans.PropertyValue; -import com.sun.star.beans.PropertyState; -import com.sun.star.beans.XPropertySet; -import com.sun.star.container.ElementExistException; -import com.sun.star.frame.XStorable; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdb.XOfficeDatabaseDocument; -import com.sun.star.sdbc.SQLException; -import com.sun.star.sdbcx.XAppend; -import com.sun.star.sdbcx.XTablesSupplier; -import com.sun.star.uno.UnoRuntime; - -import helper.URLHelper; -import java.util.HashMap; -import java.util.Iterator; -import java.util.Set; -import java.io.File; - -/** - * - * @author fs93730 - */ -public class HsqlDatabase extends AbstractDatabase -{ - - // -------------------------------------------------------------------------------------------------------- - public HsqlDatabase(final XMultiServiceFactory orb) throws Exception - { - super(orb); - createDBDocument(); - } - - // -------------------------------------------------------------------------------------------------------- - public HsqlDatabase(final XMultiServiceFactory orb, final String _existingDocumentURL) throws Exception - { - super(orb, _existingDocumentURL); - } - - /** creates an empty database document in a temporary location - */ - private void createDBDocument() throws Exception - { - final File documentFile = File.createTempFile("testdb", ".odb"); - if ( documentFile.exists() ) - documentFile.delete(); - m_databaseDocumentFile = URLHelper.getFileURLFromSystemPath(documentFile); - - m_databaseDocument = (XOfficeDatabaseDocument) UnoRuntime.queryInterface( - XOfficeDatabaseDocument.class, m_orb.createInstance("com.sun.star.sdb.OfficeDatabaseDocument")); - m_dataSource = new DataSource(m_orb, m_databaseDocument.getDataSource()); - - final XPropertySet dsProperties = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, m_databaseDocument.getDataSource()); - dsProperties.setPropertyValue("URL", "sdbc:embedded:hsqldb"); - - final XStorable storable = (XStorable) UnoRuntime.queryInterface(XStorable.class, m_databaseDocument); - storable.storeAsURL( m_databaseDocumentFile, new PropertyValue[] - { new PropertyValue( "PickListEntry", 0, false, PropertyState.DIRECT_VALUE ) - } ); - } - - /** drops the table with a given name - - @param _name - the name of the table to drop - @param _ifExists - TRUE if it should be dropped only when it exists. - */ - public void dropTable(final String _name, final boolean _ifExists) throws SQLException - { - final StringBuffer dropStatement = new StringBuffer("DROP TABLE \""); - dropStatement.append(_name); - if (_ifExists) - { - dropStatement.append("\" IF EXISTS"); - } - executeSQL(dropStatement.toString()); - } - - public void createTable(final HsqlTableDescriptor _tableDesc, final boolean _dropIfExists) throws SQLException - { - if (_dropIfExists) - { - dropTable(_tableDesc.getName(), true); - } - createTable(_tableDesc); - } - - /** creates a table - */ - public void createTable(final HsqlTableDescriptor _tableDesc) throws SQLException - { - StringBuffer createStatement = new StringBuffer("CREATE CACHED TABLE \""); - createStatement.append(_tableDesc.getName()); - createStatement.append("\" ( "); - - String primaryKeyList = ""; - - final HashMap foreignKeys = new HashMap(); - final HashMap foreignKeyRefs = new HashMap(); - - final HsqlColumnDescriptor[] columns = _tableDesc.getColumns(); - for (int i = 0; i < columns.length; ++i) - { - if (i > 0) - { - createStatement.append(", "); - } - - createStatement.append("\"" + columns[i].getName()); - createStatement.append("\" " + columns[i].getTypeName()); - - if (columns[i].isRequired()) - { - createStatement.append(" NOT NULL"); - } - - if (columns[i].isPrimaryKey()) - { - if (primaryKeyList.length() > 0) - { - primaryKeyList += ", "; - } - primaryKeyList += "\"" + columns[i].getName() + "\""; - } - - if (columns[i].isForeignKey()) - { - final String foreignTable = columns[i].getForeignTable(); - - String foreignKeysForTable = foreignKeys.containsKey(foreignTable) ? (String) foreignKeys.get(foreignTable) : ""; - if (foreignKeysForTable.length() > 0) - { - foreignKeysForTable += ", "; - } - foreignKeysForTable += "\"" + columns[i].getName() + "\""; - foreignKeys.put(foreignTable, foreignKeysForTable); - - final StringBuffer foreignKeyRefsForTable = new StringBuffer(foreignKeyRefs.containsKey(foreignTable) ? (String) foreignKeyRefs.get(foreignTable) : ""); - if (foreignKeyRefsForTable.length() > 0) - { - foreignKeyRefsForTable.append(", "); - } - foreignKeyRefsForTable.append("\"" + columns[i].getForeignColumn() + "\""); - foreignKeyRefs.put(foreignTable, foreignKeyRefsForTable.toString()); - } - } - - if (primaryKeyList.length() > 0) - { - createStatement.append(", PRIMARY KEY ("); - createStatement.append(primaryKeyList); - createStatement.append(')'); - } - - final Set foreignKeyTables = foreignKeys.keySet(); - for (final Iterator foreignKey = foreignKeyTables.iterator(); - foreignKey.hasNext();) - { - final String foreignTable = (String) foreignKey.next(); - - createStatement.append(", FOREIGN KEY ("); - createStatement.append((String) foreignKeys.get(foreignTable)); - createStatement.append(") REFERENCES \""); - createStatement.append(foreignTable); - createStatement.append("\"("); - createStatement.append((String) foreignKeyRefs.get(foreignTable)); - createStatement.append(')'); - } - - createStatement.append(')'); - - //System.err.println( createStatement ); - executeSQL(createStatement.toString()); - } - - /** creates a table in the database. using the SDBCX-API - */ - public void createTableInSDBCX(final HsqlTableDescriptor _tableDesc) throws SQLException, ElementExistException - { - final XPropertySet sdbcxDescriptor = _tableDesc.createSdbcxDescriptor(defaultConnection()); - final XTablesSupplier suppTables = UnoRuntime.queryInterface( XTablesSupplier.class, defaultConnection().getXConnection() ); - final XAppend appendTable = UnoRuntime.queryInterface( XAppend.class, suppTables.getTables() ); - appendTable.appendByDescriptor(sdbcxDescriptor); - } -} diff --git a/connectivity/qa/connectivity/tools/HsqlTableDescriptor.java b/connectivity/qa/connectivity/tools/HsqlTableDescriptor.java deleted file mode 100755 index b4d1f656dc..0000000000 --- a/connectivity/qa/connectivity/tools/HsqlTableDescriptor.java +++ /dev/null @@ -1,102 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ - -package connectivity.tools; - -import com.sun.star.beans.XPropertySet; -import com.sun.star.container.XNameAccess; -import com.sun.star.sdbc.ColumnValue; -import com.sun.star.sdbcx.XColumnsSupplier; -import com.sun.star.sdbcx.XDataDescriptorFactory; -import com.sun.star.sdbcx.XTablesSupplier; -import com.sun.star.uno.UnoRuntime; -import connectivity.tools.sdb.Connection; - -/** is a very simply descriptor of a HSQL table, to be used with a HsqlDatabase.createTable method - */ -public class HsqlTableDescriptor -{ - private String m_name; - private HsqlColumnDescriptor[] m_columns; - - /** Creates a new instance of HsqlTableDescriptor */ - public HsqlTableDescriptor( String _name, HsqlColumnDescriptor[] _columns ) - { - m_name = _name; - m_columns = _columns; - } - - /** returns the name of the table - */ - public String getName() - { - return m_name; - } - - /** returns the set of column descriptors for the table - */ - public HsqlColumnDescriptor[] getColumns() - { - return m_columns; - } - - public XPropertySet createSdbcxDescriptor( Connection _forConnection ) - { - XTablesSupplier suppTables = UnoRuntime.queryInterface( XTablesSupplier.class, _forConnection.getXConnection() ); - XDataDescriptorFactory tableDescFac = UnoRuntime.queryInterface( XDataDescriptorFactory.class, suppTables.getTables() ); - XPropertySet tableDesc = tableDescFac.createDataDescriptor(); - - try - { - tableDesc.setPropertyValue( "Name", getName() ); - } - catch ( Exception e ) { e.printStackTrace( System.err ); } - - XColumnsSupplier suppDescCols = UnoRuntime.queryInterface( XColumnsSupplier.class, tableDesc ); - - XNameAccess descColumns = suppDescCols.getColumns(); - XDataDescriptorFactory columnDescFac = UnoRuntime.queryInterface( XDataDescriptorFactory.class, descColumns ); - - HsqlColumnDescriptor[] myColumns = getColumns(); - for ( int i = 0; i < myColumns.length; ++i ) - { - XPropertySet columnDesc = columnDescFac.createDataDescriptor(); - try - { - columnDesc.setPropertyValue( "Name", myColumns[i].getName() ); - columnDesc.setPropertyValue( "IsNullable", new Integer( myColumns[i].isRequired() ? ColumnValue.NO_NULLS : ColumnValue.NULLABLE) ); - columnDesc.setPropertyValue( "TypeName", myColumns[i].getTypeName() ); - if ( myColumns[i].isPrimaryKey() || myColumns[i].isForeignKey() ) - // not yet implemented - throw new java.lang.UnsupportedOperationException("creating a primary or foreign key via SDBCX not yet implemented" ); - } - catch( com.sun.star.uno.Exception e ) { e.printStackTrace( System.err ); } - } - - return tableDesc; - } -} diff --git a/connectivity/qa/connectivity/tools/QueryDefinition.java b/connectivity/qa/connectivity/tools/QueryDefinition.java deleted file mode 100755 index 4ca3ca0ef2..0000000000 --- a/connectivity/qa/connectivity/tools/QueryDefinition.java +++ /dev/null @@ -1,74 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ - -package connectivity.tools; - -import com.sun.star.beans.PropertyVetoException; -import com.sun.star.beans.UnknownPropertyException; -import com.sun.star.beans.XPropertySet; -import com.sun.star.lang.WrappedTargetException; -import com.sun.star.lang.IllegalArgumentException; - -public class QueryDefinition -{ - XPropertySet m_queryDef; - - public QueryDefinition( XPropertySet _queryDef ) - { - m_queryDef = _queryDef; - } - - /** retrieves the command underlying the query definition - * - * This method is a mere wrapped around the <code>getPropertyValue( "Command" )</code> call - */ - public final String getCommand() throws WrappedTargetException - { - String command = null; - try { - command = (String)m_queryDef.getPropertyValue( "Command" ); - } - catch (UnknownPropertyException e) { } - - return command; - } - - /** retrieves the command underlying the query definition - * - * This method is a mere wrapped around the <code>getPropertyValue( "Command" )</code> call - */ - public void setCommand( String _command ) throws WrappedTargetException - { - try - { - m_queryDef.setPropertyValue( "Command", _command ); - } - catch (UnknownPropertyException e) { } - catch (PropertyVetoException e) { } - catch (IllegalArgumentException e) { } - } -}; diff --git a/connectivity/qa/connectivity/tools/RowSet.java b/connectivity/qa/connectivity/tools/RowSet.java deleted file mode 100755 index 4ad99a9c9b..0000000000 --- a/connectivity/qa/connectivity/tools/RowSet.java +++ /dev/null @@ -1,299 +0,0 @@ -/************************************************************************* - * - * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. - * - * Copyright 2000, 2010 Oracle and/or its affiliates. - * - * OpenOffice.org - a multi-platform office productivity suite - * - * This file is part of OpenOffice.org. - * - * OpenOffice.org is free software: you can redistribute it and/or modify - * it under the terms of the GNU Lesser General Public License version 3 - * only, as published by the Free Software Foundation. - * - * OpenOffice.org 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 version 3 for more details - * (a copy is included in the LICENSE file that accompanied this code). - * - * You should have received a copy of the GNU Lesser General Public License - * version 3 along with OpenOffice.org. If not, see - * <http://www.openoffice.org/license.html> - * for a copy of the LGPLv3 License. - * - ************************************************************************/ - -package connectivity.tools; - -import com.sun.star.beans.XPropertySet; -import com.sun.star.container.XIndexAccess; -import com.sun.star.container.XNameAccess; -import com.sun.star.io.XInputStream; -import com.sun.star.lang.XComponent; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdbc.SQLException; -import com.sun.star.sdbc.XArray; -import com.sun.star.sdbc.XBlob; -import com.sun.star.sdbc.XClob; -import com.sun.star.sdbc.XRef; -import com.sun.star.sdbc.XRow; -import com.sun.star.sdbc.XRowSet; -import com.sun.star.sdbc.XRowSetListener; -import com.sun.star.sdbcx.XColumnsSupplier; -import com.sun.star.uno.UnoRuntime; -import com.sun.star.util.Date; -import com.sun.star.util.DateTime; -import com.sun.star.util.Time; - -public class RowSet implements XRowSet, XRow -{ - private XRowSet m_rowSet; - private XRow m_row; - private XPropertySet m_rowSetProps; - - public RowSet( XMultiServiceFactory _orb, String _dataSource, int _commandType, String _command ) - { - try - { - m_rowSetProps = UnoRuntime.queryInterface( XPropertySet.class, _orb.createInstance( "com.sun.star.sdb.RowSet" ) ); - m_rowSetProps.setPropertyValue( "DataSourceName", _dataSource ); - m_rowSetProps.setPropertyValue( "CommandType", new Integer( _commandType ) ); - m_rowSetProps.setPropertyValue( "Command", _command ); - - m_rowSet = UnoRuntime.queryInterface( XRowSet.class, m_rowSetProps ); - m_row = UnoRuntime.queryInterface( XRow.class, m_rowSetProps ); - } - catch ( Exception e ) - { - e.printStackTrace(System.err); - throw new java.lang.InstantiationError(); - } - } - - // misc - public int getColumnCount() - { - XColumnsSupplier suppCols = (XColumnsSupplier)UnoRuntime.queryInterface( - XColumnsSupplier.class, m_rowSet ); - XIndexAccess columns = (XIndexAccess)UnoRuntime.queryInterface( - XIndexAccess.class, suppCols.getColumns() ); - return columns.getCount(); - } - - // XRowSet - public void execute() throws SQLException - { - m_rowSet.execute(); - } - - public void addRowSetListener( XRowSetListener _listener ) - { - m_rowSet.addRowSetListener( _listener ); - } - - public void removeRowSetListener( XRowSetListener _listener ) - { - m_rowSet.removeRowSetListener( _listener ); - } - - public boolean next() throws SQLException - { - return m_rowSet.next(); - } - - public boolean isBeforeFirst() throws SQLException - { - return m_rowSet.isBeforeFirst(); - } - - public boolean isAfterLast() throws SQLException - { - return m_rowSet.isAfterLast(); - } - - public boolean isFirst() throws SQLException - { - return m_rowSet.isFirst(); - } - - public boolean isLast() throws SQLException - { - return m_rowSet.isLast(); - } - - public void beforeFirst() throws SQLException - { - m_rowSet.beforeFirst(); - } - - public void afterLast() throws SQLException - { - m_rowSet.afterLast(); - } - - public boolean first() throws SQLException - { - return m_rowSet.first(); - } - - public boolean last() throws SQLException - { - return m_rowSet.last(); - } - - public int getRow() throws SQLException - { - return m_rowSet.getRow(); - } - - public boolean absolute(int i) throws SQLException - { - return m_rowSet.absolute(i); - } - - public boolean relative(int i) throws SQLException - { - return m_rowSet.relative(i); - } - - public boolean previous() throws SQLException - { - return m_rowSet.previous(); - } - - public void refreshRow() throws SQLException - { - m_rowSet.refreshRow(); - } - - public boolean rowUpdated() throws SQLException - { - return m_rowSet.rowUpdated(); - } - - public boolean rowInserted() throws SQLException - { - return m_rowSet.rowInserted(); - } - - public boolean rowDeleted() throws SQLException - { - return m_rowSet.rowDeleted(); - } - - // XRow - public Object getStatement() throws SQLException - { - return m_rowSet.getStatement(); - } - - public boolean wasNull() throws SQLException - { - return m_row.wasNull(); - } - - public String getString(int i) throws SQLException - { - return m_row.getString(i); - } - - public boolean getBoolean(int i) throws SQLException - { - return m_row.getBoolean(i); - } - - public byte getByte(int i) throws SQLException - { - return m_row.getByte(i); - } - - public short getShort(int i) throws SQLException - { - return m_row.getShort(i); - } - - public int getInt(int i) throws SQLException - { - return m_row.getInt(i); - } - - public long getLong(int i) throws SQLException - { - return m_row.getLong(i); - } - - public float getFloat(int i) throws SQLException - { - return m_row.getFloat(i); - } - - public double getDouble(int i) throws SQLException - { - return m_row.getDouble(i); - } - - public byte[] getBytes(int i) throws SQLException - { - return m_row.getBytes(i); - } - - public Date getDate(int i) throws SQLException - { - return m_row.getDate(i); - } - - public Time getTime(int i) throws SQLException - { - return m_row.getTime(i); - } - - public DateTime getTimestamp(int i) throws SQLException - { - return m_row.getTimestamp(i); - } - - public XInputStream getBinaryStream(int i) throws SQLException - { - return m_row.getBinaryStream(i); - } - - public XInputStream getCharacterStream(int i) throws SQLException - { - return m_row.getCharacterStream(i); - } - - public Object getObject(int i, XNameAccess xNameAccess) throws SQLException - { - return m_row.getObject(i, xNameAccess); - } - - public XRef getRef(int i) throws SQLException - { - return m_row.getRef(i); - } - - public XBlob getBlob(int i) throws SQLException - { - return m_row.getBlob(i); - } - - public XClob getClob(int i) throws SQLException - { - return m_row.getClob(i); - } - - public XArray getArray(int i) throws SQLException - { - return m_row.getArray(i); - } - - public void dispose() - { - if ( m_rowSet == null ) - return; - XComponent rowSetComp = UnoRuntime.queryInterface( XComponent.class, m_rowSet ); - rowSetComp.dispose(); - } -}; diff --git a/connectivity/qa/connectivity/tools/makefile.mk b/connectivity/qa/connectivity/tools/makefile.mk deleted file mode 100755 index d77da7f1b9..0000000000 --- a/connectivity/qa/connectivity/tools/makefile.mk +++ /dev/null @@ -1,61 +0,0 @@ -#************************************************************************* -# -# DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. -# -# Copyright 2000, 2010 Oracle and/or its affiliates. -# -# OpenOffice.org - a multi-platform office productivity suite -# -# This file is part of OpenOffice.org. -# -# OpenOffice.org is free software: you can redistribute it and/or modify -# it under the terms of the GNU Lesser General Public License version 3 -# only, as published by the Free Software Foundation. -# -# OpenOffice.org 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 version 3 for more details -# (a copy is included in the LICENSE file that accompanied this code). -# -# You should have received a copy of the GNU Lesser General Public License -# version 3 along with OpenOffice.org. If not, see -# <http://www.openoffice.org/license.html> -# for a copy of the LGPLv3 License. -# -#************************************************************************* - -PRJ = ../../.. -TARGET = ConnectivityTools -PRJNAME = connectivity -PACKAGE = connectivity/tools - -# --- Settings ----------------------------------------------------- -.INCLUDE: settings.mk - -.IF "$(SOLAR_JAVA)" == "" -all: - @echo "Java not available. Build skipped" -.ELSE - -#----- compile .java files ----------------------------------------- - -JARFILES = ridl.jar unoil.jar jurt.jar juh.jar java_uno.jar OOoRunnerLight.jar -JAVAFILES := $(shell @$(FIND) . -name "*.java") - -#----- make a jar from compiled files ------------------------------ - -JARCLASSDIRS = $(PACKAGE) -JARTARGET = $(TARGET).jar - -# --- Targets ------------------------------------------------------ - -.IF "$(depend)" == "" -ALL : ALLTAR -.ELSE -ALL: ALLDEP -.ENDIF - -.ENDIF # "$(SOLAR_JAVA)" == "" - -.INCLUDE : target.mk diff --git a/connectivity/qa/connectivity/tools/sdb/Connection.java b/connectivity/qa/connectivity/tools/sdb/Connection.java deleted file mode 100755 index aac120fb1e..0000000000 --- a/connectivity/qa/connectivity/tools/sdb/Connection.java +++ /dev/null @@ -1,93 +0,0 @@ -/* - * To change this template, choose Tools | Templates - * and open the template in the editor. - */ - -package connectivity.tools.sdb; - -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sdb.XSingleSelectQueryComposer; -import com.sun.star.sdbc.SQLException; -import com.sun.star.sdbc.XConnection; -import com.sun.star.sdbc.XDatabaseMetaData; -import com.sun.star.sdbc.XPreparedStatement; -import com.sun.star.sdbc.XResultSet; -import com.sun.star.sdbc.XStatement; -import com.sun.star.sdbcx.XTablesSupplier; -import com.sun.star.uno.Exception; -import com.sun.star.uno.UnoRuntime; -import com.sun.star.util.XRefreshable; - -/** - * is a convenience wrapper around a SDB-level connection object - */ -public class Connection -{ - private final XConnection m_connection; - - public Connection( final XConnection _connection ) - { - m_connection = _connection; - } - - public XConnection getXConnection() - { - return m_connection; - } - - public boolean execute( final String _sql ) throws SQLException - { - XStatement statement = createStatement(); - return statement.execute( _sql ); - } - - public XResultSet executeQuery( final String _sql ) throws SQLException - { - XStatement statement = createStatement(); - return statement.executeQuery( _sql ); - } - - public int executeUpdate( final String _sql ) throws SQLException - { - XStatement statement = createStatement(); - return statement.executeUpdate( _sql ); - } - - public void refreshTables() - { - final XTablesSupplier suppTables = UnoRuntime.queryInterface(XTablesSupplier.class, m_connection); - final XRefreshable refresh = UnoRuntime.queryInterface( XRefreshable.class, suppTables.getTables() ); - refresh.refresh(); - } - - public XSingleSelectQueryComposer createSingleSelectQueryComposer() throws Exception - { - final XMultiServiceFactory connectionFactory = UnoRuntime.queryInterface( XMultiServiceFactory.class, m_connection ); - return UnoRuntime.queryInterface( - XSingleSelectQueryComposer.class, connectionFactory.createInstance( "com.sun.star.sdb.SingleSelectQueryComposer" ) ); - } - - public - XStatement createStatement() throws SQLException - { - return m_connection.createStatement(); - } - - public - XPreparedStatement prepareStatement( String _sql ) throws SQLException - { - return m_connection.prepareStatement( _sql ); - } - - public - XDatabaseMetaData getMetaData() throws SQLException - { - return m_connection.getMetaData(); - } - - public - void close() throws SQLException - { - m_connection.close(); - } -} diff --git a/connectivity/qa/makefile.mk b/connectivity/qa/makefile.mk deleted file mode 100755 index 3081a751f0..0000000000 --- a/connectivity/qa/makefile.mk +++ /dev/null @@ -1,78 +0,0 @@ -#************************************************************************* -# -# DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. -# -# Copyright 2000, 2010 Oracle and/or its affiliates. -# -# OpenOffice.org - a multi-platform office productivity suite -# -# This file is part of OpenOffice.org. -# -# OpenOffice.org is free software: you can redistribute it and/or modify -# it under the terms of the GNU Lesser General Public License version 3 -# only, as published by the Free Software Foundation. -# -# OpenOffice.org 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 version 3 for more details -# (a copy is included in the LICENSE file that accompanied this code). -# -# You should have received a copy of the GNU Lesser General Public License -# version 3 along with OpenOffice.org. If not, see -# <http://www.openoffice.org/license.html> -# for a copy of the LGPLv3 License. -# -#************************************************************************* - -PRJ = .. -TARGET = ConnectivityComplexTests -PRJNAME = connectivity -PACKAGE = complex/connectivity - -# --- Settings ----------------------------------------------------- -.INCLUDE: settings.mk - -#----- compile .java files ----------------------------------------- - -JARFILES = ridl.jar unoil.jar jurt.jar juh.jar java_uno.jar OOoRunner.jar -JAVAFILES := $(shell @$(FIND) complex -name "*.java") - -.IF "$(SYSTEM_HSQLDB)" == "YES" -EXTRAJARFILES = $(HSQLDB_JAR) -.ELSE -JARFILES += hsqldb.jar -.ENDIF - -#----- make a jar from compiled files ------------------------------ - -JARCLASSDIRS = $(PACKAGE) -JARTARGET = $(TARGET).jar - -# --- Runner Settings ---------------------------------------------- - -# classpath and argument list -RUNNER_CLASSPATH = -cp "$(CLASSPATH)$(PATH_SEPERATOR)$(SOLARBINDIR)$/OOoRunner.jar" -RUNNER_ARGS = org.openoffice.Runner -TestBase java_complex - -# --- Targets ------------------------------------------------------ - -.IF "$(depend)" == "" -ALL : ALLTAR - @echo ----------------------------------------------------- - @echo - do a 'dmake show_targets' to show available targets - @echo ----------------------------------------------------- -.ELSE -ALL: ALLDEP -.ENDIF - -.INCLUDE : target.mk - -show_targets: - +@$(AUGMENT_LIBRARY_PATH) java $(RUNNER_CLASSPATH) complexlib.ShowTargets $(foreach,i,$(JAVAFILES) $(i:s/.\$///:s/.java//)) - -run: $(CLASSDIR)$/$(JARTARGET) - +$(AUGMENT_LIBRARY_PATH) java $(RUNNER_CLASSPATH) $(RUNNER_ARGS) -sce scenarios.sce - -run_%: $(CLASSDIR)$/$(JARTARGET) - +$(AUGMENT_LIBRARY_PATH) java $(RUNNER_CLASSPATH) $(RUNNER_ARGS) -o complex.$(PRJNAME).$(@:s/run_//) diff --git a/connectivity/qa/scenarios.sce b/connectivity/qa/scenarios.sce deleted file mode 100755 index c085f11bd7..0000000000 --- a/connectivity/qa/scenarios.sce +++ /dev/null @@ -1,4 +0,0 @@ --o complex.connectivity.DBaseDriverTest --o complex.connectivity.HsqlDriverTest -#-o complex.connectivity.JdbcLongVarCharTest --o complex.connectivity.FlatFileAccess |