sc/qa/extras/scdatabaserangeobj.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  */
   9
  10 #include <test/calc_unoapi_test.hxx>
  11 #include <test/sheet/databaserange.hxx>
  12 #include <test/sheet/xcellrangereferrer.hxx>
  13 #include <test/sheet/xdatabaserange.hxx>
  14
  15 #include <com/sun/star/beans/XPropertySet.hpp>
  16 #include <com/sun/star/container/XNameAccess.hpp>
  17 #include <com/sun/star/sheet/XCellRangeAddressable.hpp>
  18 #include <com/sun/star/sheet/XCellRangeReferrer.hpp>
  19 #include <com/sun/star/sheet/XDatabaseRange.hpp>
  20 #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
  21
  22 using namespace css;
  23 using namespace css::uno;
  24
  25 namespace sc_apitest {
  26
  27 class ScDatabaseRangeObj : public CalcUnoApiTest,
  28                            public apitest::DatabaseRange,
  29                            public apitest::XCellRangeReferrer,
  30                            public apitest::XDatabaseRange
  31 {
  32 public:
  33     virtual void setUp() override;
  34     virtual void tearDown() override;
  35
  36     virtual uno::Reference< uno::XInterface > init() override;
  37     virtual uno::Reference< uno::XInterface > init( const OUString& rDBName ) override;
  38
  39     ScDatabaseRangeObj();
  40
  41     CPPUNIT_TEST_SUITE(ScDatabaseRangeObj);
  42
  43     // DatabaseRange
  44     CPPUNIT_TEST(testMoveCells);
  45     CPPUNIT_TEST(testKeepFormats);
  46     CPPUNIT_TEST(testStripData);
  47     CPPUNIT_TEST(testAutoFilter);
  48     CPPUNIT_TEST(testUseFilterCriteriaSource);
  49     CPPUNIT_TEST(testFilterCriteriaSource);
  50     CPPUNIT_TEST(testRefreshPeriod);
  51     CPPUNIT_TEST(testFromSelection);
  52     CPPUNIT_TEST(testTokenIndex);
  53     CPPUNIT_TEST(testTotalsRow);
  54     CPPUNIT_TEST(testContainsHeader);
  55
  56     // XCellRangeReferrer
  57     CPPUNIT_TEST(testGetReferredCells);
  58
  59     // XDatabaseRange
  60     CPPUNIT_TEST(testDataArea);
  61     CPPUNIT_TEST(testGetSortDescriptor);
  62     CPPUNIT_TEST(testGetSubtotalDescriptor);
  63     CPPUNIT_TEST(testGetImportDescriptor);
  64     CPPUNIT_TEST(testGetFilterDescriptor);
  65     CPPUNIT_TEST(testRefresh);
  66
  67     CPPUNIT_TEST_SUITE_END();
  68 private:
  69     uno::Reference< lang::XComponent > mxComponent;
  70 };
  71
  72 ScDatabaseRangeObj::ScDatabaseRangeObj()
  73       : CalcUnoApiTest("/sc/qa/extras/testdocuments")
  74 {
  75 }
  76
  77 uno::Reference<uno::XInterface> ScDatabaseRangeObj::init()
  78 {
  79     return init("DataArea");
  80 }
  81
  82 uno::Reference< uno::XInterface > ScDatabaseRangeObj::init( const OUString& rDBName )
  83 {
  84     uno::Reference< sheet::XSpreadsheetDocument > xDoc(mxComponent, UNO_QUERY_THROW);
  85
  86     uno::Reference< beans::XPropertySet > xPropSet(xDoc, UNO_QUERY_THROW);
  87     uno::Reference< container::XNameAccess > xNameAccess( xPropSet->getPropertyValue("DatabaseRanges"), UNO_QUERY_THROW);
  88
  89     uno::Reference<sheet::XCellRangeReferrer> xCRR(xNameAccess->getByName(rDBName), UNO_QUERY_THROW);
  90     uno::Reference<sheet::XCellRangeAddressable> xCRA(xCRR->getReferredCells(), UNO_QUERY_THROW);
  91     setCellRange(xCRA->getRangeAddress());
  92
  93     uno::Reference< sheet::XDatabaseRange > xDBRange( xNameAccess->getByName(rDBName), UNO_QUERY_THROW);
  94     CPPUNIT_ASSERT(xDBRange.is());
  95
  96     return xDBRange;
  97 }
  98
  99 void ScDatabaseRangeObj::setUp()
 100 {
 101     CalcUnoApiTest::setUp();
 102
 103     OUString aFileURL;
 104     createFileURL("ScDatabaseRangeObj.ods", aFileURL);
 105     mxComponent = loadFromDesktop(aFileURL, "com.sun.star.sheet.SpreadsheetDocument");
 106
 107 }
 108
 109 void ScDatabaseRangeObj::tearDown()
 110 {
 111     closeDocument(mxComponent);
 112     CalcUnoApiTest::tearDown();
 113 }
 114
 115 CPPUNIT_TEST_SUITE_REGISTRATION(ScDatabaseRangeObj);
 116
 117 }
 118
 119 CPPUNIT_PLUGIN_IMPLEMENT();
 120
 121 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */