Adding upstream version 4:24.2.0.upstream/4%24.2.0

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 226 insertions, 0 deletions

diff --git a/sc/qa/unit/dataproviders_test.cxx b/sc/qa/unit/dataproviders_test.cxx
new file mode 100644
index 0000000000..5b1aa76b95
--- /dev/null
+++ b/sc/qa/unit/dataproviders_test.cxx
@@ -0,0 +1,226 @@
+/*
+ * 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 <rtl/ustring.hxx>
+
+#include "helper/qahelper.hxx"
+#include <document.hxx>
+#include <address.hxx>
+#include <dbdata.hxx>
+#include <datamapper.hxx>
+#include <vcl/scheduler.hxx>
+#include <orcusxml.hxx>
+
+#include <memory>
+
+using namespace ::com::sun::star;
+using namespace ::com::sun::star::uno;
+
+class ScDataProvidersTest : public ScModelTestBase
+{
+public:
+    ScDataProvidersTest();
+
+    void testCSVImport();
+    void testDataLargerThanDB();
+    void testHTMLImport();
+    void testXMLImport();
+    // void testBaseImport();
+
+    CPPUNIT_TEST_SUITE(ScDataProvidersTest);
+    CPPUNIT_TEST(testCSVImport);
+    CPPUNIT_TEST(testDataLargerThanDB);
+    CPPUNIT_TEST(testHTMLImport);
+    CPPUNIT_TEST(testXMLImport);
+    // CPPUNIT_TEST(testBaseImport);
+    CPPUNIT_TEST_SUITE_END();
+};
+
+void ScDataProvidersTest::testCSVImport()
+{
+    createScDoc();
+
+    ScDBData* pDBData = new ScDBData("testDB", 0, 0, 0, 10, 10);
+    ScDocument* pDoc = getScDoc();
+    bool bInserted
+        = pDoc->GetDBCollection()->getNamedDBs().insert(std::unique_ptr<ScDBData>(pDBData));
+    CPPUNIT_ASSERT(bInserted);
+
+    OUString aFileURL = createFileURL(u"csv/test1.csv");
+    sc::ExternalDataSource aDataSource(aFileURL, "org.libreoffice.calc.csv", pDoc);
+    aDataSource.setDBData(pDBData->GetName());
+
+    pDoc->GetExternalDataMapper().insertDataSource(aDataSource);
+    auto& rDataSources = pDoc->GetExternalDataMapper().getDataSources();
+    CPPUNIT_ASSERT(!rDataSources.empty());
+
+    rDataSources[0].refresh(pDoc, true);
+    Scheduler::ProcessEventsToIdle();
+
+    CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(0, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(1, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(2, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(4.0, pDoc->GetValue(3, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test1"), pDoc->GetString(0, 1, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test2"), pDoc->GetString(1, 1, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test3"), pDoc->GetString(2, 1, 0));
+}
+
+void ScDataProvidersTest::testDataLargerThanDB()
+{
+    createScDoc();
+
+    ScDBData* pDBData = new ScDBData("testDB", 0, 0, 0, 1, 1);
+    ScDocument* pDoc = getScDoc();
+    bool bInserted
+        = pDoc->GetDBCollection()->getNamedDBs().insert(std::unique_ptr<ScDBData>(pDBData));
+    CPPUNIT_ASSERT(bInserted);
+
+    OUString aFileURL = createFileURL(u"csv/test1.csv");
+    sc::ExternalDataSource aDataSource(aFileURL, "org.libreoffice.calc.csv", pDoc);
+    aDataSource.setDBData(pDBData->GetName());
+
+    pDoc->GetExternalDataMapper().insertDataSource(aDataSource);
+    auto& rDataSources = pDoc->GetExternalDataMapper().getDataSources();
+    CPPUNIT_ASSERT(!rDataSources.empty());
+
+    rDataSources[0].refresh(pDoc, true);
+    Scheduler::ProcessEventsToIdle();
+
+    CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(0, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(1, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(2, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(0.0, pDoc->GetValue(3, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test1"), pDoc->GetString(0, 1, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test2"), pDoc->GetString(1, 1, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString(), pDoc->GetString(2, 1, 0));
+}
+
+void ScDataProvidersTest::testHTMLImport()
+{
+    createScDoc();
+
+    ScDBData* pDBData = new ScDBData("testDB", 0, 0, 0, 10, 10);
+    ScDocument* pDoc = getScDoc();
+    bool bInserted
+        = pDoc->GetDBCollection()->getNamedDBs().insert(std::unique_ptr<ScDBData>(pDBData));
+    CPPUNIT_ASSERT(bInserted);
+
+    OUString aFileURL = createFileURL(u"html/test1.html");
+    sc::ExternalDataSource aDataSource(aFileURL, "org.libreoffice.calc.html", pDoc);
+    aDataSource.setID("//table");
+    aDataSource.setDBData(pDBData->GetName());
+
+    pDoc->GetExternalDataMapper().insertDataSource(aDataSource);
+    auto& rDataSources = pDoc->GetExternalDataMapper().getDataSources();
+    CPPUNIT_ASSERT(!rDataSources.empty());
+
+    rDataSources[0].refresh(pDoc, true);
+    Scheduler::ProcessEventsToIdle();
+
+    std::vector<OUString> aCarManufacturers = { "Audi", "GM", "Nissan", "Ferrari", "Peugeot" };
+    std::vector<OUString> aCities = { "Berlin", "San Francisco", "Tokyo", "Rome", "Paris" };
+    std::vector<double> aFirstCol = { 1, 10, -100, -0.11111, 1 };
+    std::vector<double> aSecondCol = {
+        2, 2.1, 40179, 2, 2,
+    }; // 40179 is equal to 2010-1-1
+
+    CPPUNIT_ASSERT_EQUAL(OUString("Col1"), pDoc->GetString(0, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("Col2"), pDoc->GetString(1, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("Col3"), pDoc->GetString(2, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("Col4"), pDoc->GetString(3, 0, 0));
+
+    for (SCROW nRow = 0; nRow <= 4; ++nRow)
+    {
+        ASSERT_DOUBLES_EQUAL(aFirstCol[nRow], pDoc->GetValue(0, nRow + 1, 0));
+        ASSERT_DOUBLES_EQUAL(aSecondCol[nRow], pDoc->GetValue(1, nRow + 1, 0));
+        CPPUNIT_ASSERT_EQUAL(aCarManufacturers[nRow], pDoc->GetString(2, nRow + 1, 0));
+        CPPUNIT_ASSERT_EQUAL(aCities[nRow], pDoc->GetString(3, nRow + 1, 0));
+    }
+}
+
+void ScDataProvidersTest::testXMLImport()
+{
+    createScDoc();
+
+    ScDBData* pDBData = new ScDBData("testDB", 0, 0, 0, 10, 10);
+    ScDocument* pDoc = getScDoc();
+    bool bInserted
+        = pDoc->GetDBCollection()->getNamedDBs().insert(std::unique_ptr<ScDBData>(pDBData));
+    CPPUNIT_ASSERT(bInserted);
+
+    ScOrcusImportXMLParam aParam;
+
+    ScOrcusImportXMLParam::RangeLink aRangeLink;
+    aRangeLink.maPos = ScAddress(0, 0, 0);
+    aRangeLink.maFieldPaths.push_back("/bookstore/book/title"_ostr);
+    aRangeLink.maFieldPaths.push_back("/bookstore/book/author"_ostr);
+    aRangeLink.maRowGroups.push_back("/bookstore/book"_ostr);
+    aParam.maRangeLinks.push_back(aRangeLink);
+
+    OUString aFileURL = createFileURL(u"xml/test1.xml");
+    sc::ExternalDataSource aDataSource(aFileURL, "org.libreoffice.calc.xml", pDoc);
+    aDataSource.setDBData("testDB");
+    aDataSource.setXMLImportParam(aParam);
+
+    pDoc->GetExternalDataMapper().insertDataSource(aDataSource);
+    auto& rDataSources = pDoc->GetExternalDataMapper().getDataSources();
+    CPPUNIT_ASSERT(!rDataSources.empty());
+
+    rDataSources[0].refresh(pDoc, true);
+    Scheduler::ProcessEventsToIdle();
+
+    CPPUNIT_ASSERT_EQUAL(OUString("title"), pDoc->GetString(0, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("author"), pDoc->GetString(1, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(1.0, pDoc->GetValue(0, 1, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test1"), pDoc->GetString(1, 1, 0));
+    CPPUNIT_ASSERT_EQUAL(2.0, pDoc->GetValue(0, 2, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test2"), pDoc->GetString(1, 2, 0));
+    CPPUNIT_ASSERT_EQUAL(3.0, pDoc->GetValue(0, 3, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test3"), pDoc->GetString(1, 3, 0));
+    CPPUNIT_ASSERT_EQUAL(4.0, pDoc->GetValue(0, 4, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("test4"), pDoc->GetString(1, 4, 0));
+}
+
+/*
+void ScDataProvidersTest::testBaseImport()
+{
+    createScDoc();
+
+    ScDBData* pDBData = new ScDBData("testDB", 0, 0, 0, 10, 10);
+    ScDocument* pDoc = getScDoc();
+    bool bInserted = pDoc->GetDBCollection()->getNamedDBs().insert(pDBData);
+    CPPUNIT_ASSERT(bInserted);
+
+    sc::ExternalDataSource aDataSource("~/dummy.file", "org.libreoffice.calc.sql", pDoc);
+    aDataSource.setDBData("testDB");
+    aDataSource.setID("biblio@Bibliography");
+
+
+    pDoc->GetExternalDataMapper().insertDataSource(aDataSource);
+    auto& rDataSources = pDoc->GetExternalDataMapper().getDataSources();
+    CPPUNIT_ASSERT(!rDataSources.empty());
+
+    rDataSources[0].refresh(pDoc, true);
+    Scheduler::ProcessEventsToIdle();
+
+    CPPUNIT_ASSERT_EQUAL(OUString("ARJ00"), pDoc->GetString(0, 0, 0));
+    CPPUNIT_ASSERT_EQUAL(OUString("AVV00"), pDoc->GetString(1, 1, 0));
+}
+*/
+
+ScDataProvidersTest::ScDataProvidersTest()
+    : ScModelTestBase("sc/qa/unit/data/dataprovider")
+{
+}
+
+CPPUNIT_TEST_SUITE_REGISTRATION(ScDataProvidersTest);
+
+CPPUNIT_PLUGIN_IMPLEMENT();
+
+/* vim:set shiftwidth=4 softtabstop=4 expandtab: */