summaryrefslogtreecommitdiff
path: root/connectivity/qa/connectivity/mork/DriverTest.cxx
diff options
context:
space:
mode:
Diffstat (limited to 'connectivity/qa/connectivity/mork/DriverTest.cxx')
-rw-r--r--connectivity/qa/connectivity/mork/DriverTest.cxx195
1 files changed, 0 insertions, 195 deletions
diff --git a/connectivity/qa/connectivity/mork/DriverTest.cxx b/connectivity/qa/connectivity/mork/DriverTest.cxx
deleted file mode 100644
index bea76fd028dc..000000000000
--- a/connectivity/qa/connectivity/mork/DriverTest.cxx
+++ /dev/null
@@ -1,195 +0,0 @@
-/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
-/*
- * This file is part of the LibreOffice project.
- *
- * This Source Code Form is subject to the terms of the Mozilla Public
- * License, v. 2.0. If a copy of the MPL was not distributed with this
- * file, You can obtain one at http://mozilla.org/MPL/2.0/.
- */
-
-#include <test/bootstrapfixture.hxx>
-
-#include <com/sun/star/sdbc/XDriver.hpp>
-#include <com/sun/star/sdbc/XRow.hpp>
-
-using namespace ::com::sun::star::beans;
-using namespace ::com::sun::star::sdbc;
-using namespace ::com::sun::star::uno;
-
-namespace connectivity::mork {
-
-
-class MorkDriverTest: public test::BootstrapFixture
-{
-public:
- MorkDriverTest() : test::BootstrapFixture(false, false) {};
-
- void checkAcceptsURL(Reference< XDriver> const & xDriver, const char* url, bool expected);
- void test_metadata();
- void test_select_default_all();
- void test_select_list_table_joe_doe_5();
-
- virtual void setUp() override;
- virtual void tearDown() override;
-
- CPPUNIT_TEST_SUITE(MorkDriverTest);
-
- CPPUNIT_TEST(test_metadata);
- CPPUNIT_TEST(test_select_default_all);
- CPPUNIT_TEST(test_select_list_table_joe_doe_5);
- CPPUNIT_TEST_SUITE_END();
-
-private:
- Reference<XInterface> m_xMorkComponent;
- Reference<XConnection> m_xConnection;
-};
-
-void MorkDriverTest::checkAcceptsURL(Reference< XDriver> const & xDriver, const char* url, bool expected)
-{
- bool res = xDriver->acceptsURL(OUString::createFromAscii(url));
- if (res != expected)
- {
- CPPUNIT_ASSERT_MESSAGE("wrong URL outcome!", true);
- }
-}
-
-void MorkDriverTest::setUp()
-{
- test::BootstrapFixture::setUp();
- m_xMorkComponent = getMultiServiceFactory()->createInstance("com.sun.star.comp.sdbc.MorkDriver");
- CPPUNIT_ASSERT_MESSAGE("no mork component!", m_xMorkComponent.is());
-
- // is this the best way to pass test file through URL?
- // may be take a custom Sequence< PropertyValue > route?
- OUString url = "sdbc:address:thunderbird:unittest:" +
- m_directories.getPathFromSrc("/connectivity/qa/connectivity/mork/abook_10_john_does.mab");
-
- Sequence< PropertyValue > info;
- Reference< XDriver> xDriver(m_xMorkComponent, UNO_QUERY);
- if (!xDriver.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot connect to mork driver!", xDriver.is());
- }
-
- // bad
- checkAcceptsURL(xDriver, "sdbc:address:macab", false);
- checkAcceptsURL(xDriver, "sdbc:mozab:ldap:", false);
- checkAcceptsURL(xDriver, "sdbc:mozab:outlook:", false);
- checkAcceptsURL(xDriver, "sdbc:mozab:outlookexp:", false);
-
- // good
- checkAcceptsURL(xDriver, "sdbc:mozab:mozilla:", true);
- checkAcceptsURL(xDriver, "sdbc:mozab:thunderbird:", true);
- checkAcceptsURL(xDriver, "sdbc:address:mozilla:", true);
- checkAcceptsURL(xDriver, "sdbc:address:thunderbird:", true);
-
- m_xConnection = xDriver->connect(url, info);
- if (!m_xConnection.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot connect to address book data source!", m_xConnection.is());
- }
-}
-
-void MorkDriverTest::tearDown()
-{
-// how to make dispose() work?
-// Reference< css::lang::XComponent >( m_xMorkComponent, UNO_QUERY_THROW )->dispose();
- m_xConnection->close();
- test::BootstrapFixture::tearDown();
-}
-
-void MorkDriverTest::test_metadata()
-{
- Reference< XDatabaseMetaData > xDatabaseMetaData = m_xConnection->getMetaData();
- if (!xDatabaseMetaData.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot retrieve meta data!", xDatabaseMetaData.is());
- }
-
- const Any catalog;
- const Sequence< OUString > types;
-
- Reference< XResultSet > xResultSet =
- xDatabaseMetaData->getTables(catalog, "%", "%", types);
- if (!xResultSet.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot retrieve tables!", xResultSet.is());
- }
-
- // TODO: how to access that result set and check the tables?
- // it should be 3 tables inside: AddressBook, does_5 and does_10
-}
-
-void MorkDriverTest::test_select_default_all()
-{
- Reference< XPreparedStatement > xStatement = m_xConnection->prepareStatement("select \"E-mail\" from \"AddressBook\" ORDER BY \"E-mail\"");
- if (!xStatement.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot create prepared statement!", xStatement.is());
- }
-
- Reference< XResultSet > xResultSet = xStatement->executeQuery();
- if (!xResultSet.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot execute sql statement!", xResultSet.is());
- }
-
- Reference< XRow > xDelegatorRow(xResultSet, UNO_QUERY);
- if (!xDelegatorRow.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot extract row from result set!", xDelegatorRow.is());
- }
-
- bool result = xResultSet->first();
- CPPUNIT_ASSERT_MESSAGE("fetch first row failed!", result);
- OUString mail = xDelegatorRow->getString(1);
- CPPUNIT_ASSERT_EQUAL_MESSAGE("first row is not john@doe.org!", OUString("john@doe.org"), mail);
-
- result = xResultSet->next();
- CPPUNIT_ASSERT_MESSAGE("fetch second row failed!", result);
- mail = xDelegatorRow->getString(1);
- CPPUNIT_ASSERT_EQUAL_MESSAGE("second row is not john@doe10.org!", OUString("john@doe10.org"), mail);
-
- result = xResultSet->last();
- CPPUNIT_ASSERT_MESSAGE("fetch last row failed!", result);
- mail = xDelegatorRow->getString(1);
- CPPUNIT_ASSERT_EQUAL_MESSAGE("last row is not john@doe9.org!", OUString("john@doe9.org"), mail);
-
- css::uno::Reference<css::sdbc::XCloseable>(
- xStatement, css::uno::UNO_QUERY_THROW)->close();
-}
-
-void MorkDriverTest::test_select_list_table_joe_doe_5()
-{
- Reference< XPreparedStatement > xStatement = m_xConnection->prepareStatement("select \"E-mail\" from \"does_5\" where \"E-mail\" LIKE '%doe5.org' ");
- if (!xStatement.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot create prepared statement!", xStatement.is());
- }
-
- Reference< XResultSet > xResultSet = xStatement->executeQuery();
- if (!xResultSet.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot execute sql statement!", xResultSet.is());
- }
-
- Reference< XRow > xDelegatorRow(xResultSet, UNO_QUERY);
- if (!xDelegatorRow.is())
- {
- CPPUNIT_ASSERT_MESSAGE("cannot extract row from result set!", xDelegatorRow.is());
- }
-
- bool result = xResultSet->first();
- CPPUNIT_ASSERT_MESSAGE("fetch first row failed!", result);
- OUString mail = xDelegatorRow->getString(1);
- CPPUNIT_ASSERT_EQUAL_MESSAGE("last row is not john@doe5.org!", OUString("john@doe5.org"), mail);
-
- css::uno::Reference<css::sdbc::XCloseable>(
- xStatement, css::uno::UNO_QUERY_THROW)->close();
-}
-
-CPPUNIT_TEST_SUITE_REGISTRATION(MorkDriverTest);
-
-}
-
-CPPUNIT_PLUGIN_IMPLEMENT();
generated by cgit (git 2.34.1) at 2024-05-22 16:22:39 +0000