dbaccess/qa/unit/tdf119625.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 "dbtest_base.cxx"
  11
  12 #include <osl/process.h>
  13 #include <cppunit/plugin/TestPlugIn.h>
  14 #include <com/sun/star/sdbc/XRow.hpp>
  15 #include <cppunit/extensions/HelperMacros.h>
  16 #include <com/sun/star/util/Time.hpp>
  17 #include <officecfg/Office/Common.hxx>
  18
  19 class Tdf119625Test : public DBTestBase
  20 {
  21 public:
  22     void testTime();
  23
  24     virtual void setUp() override;
  25
  26     CPPUNIT_TEST_SUITE(Tdf119625Test);
  27
  28     CPPUNIT_TEST(testTime);
  29
  30     CPPUNIT_TEST_SUITE_END();
  31 };
  32
  33 void Tdf119625Test::setUp()
  34 {
  35     DBTestBase::setUp();
  36     osl_setEnvironment(OUString{ "DBACCESS_HSQL_MIGRATION" }.pData, OUString{ "1" }.pData);
  37 }
  38
  39 namespace
  40 {
  41 struct expect_t
  42 {
  43     sal_Int16 id;
  44     sal_Int16 h, m, s;
  45 };
  46 }
  47
  48 /* The values here assume that our results are in UTC.  However,
  49    tdf#119675 "Firebird: Migration: User dialog to set treatment of
  50    datetime and time values during migration" is going to change the
  51    final result of migration. If that change is implemented below
  52    the level we are testing, this test will have to allow for or set
  53    the destination timezone.
  54  */
  55 const expect_t expect[] = { { 0, 15, 10, 10 }, { 1, 23, 30, 30 }, { 2, 5, 0, 0 },  { 3, 4, 30, 0 },
  56                             { 4, 3, 15, 10 },  { 5, 5, 0, 0 },    { 6, 3, 22, 22 } };
  57
  58 void Tdf119625Test::testTime()
  59 {
  60     bool oldValue = officecfg::Office::Common::Misc::ExperimentalMode::get();
  61     {
  62         std::shared_ptr<comphelper::ConfigurationChanges> xChanges(
  63             comphelper::ConfigurationChanges::create());
  64         officecfg::Office::Common::Misc::ExperimentalMode::set(true, xChanges);
  65         xChanges->commit();
  66     }
  67
  68     // the migration requires the file to be writable
  69     utl::TempFile const temp(createTempCopy(u"tdf119625.odb"));
  70     uno::Reference<XOfficeDatabaseDocument> const xDocument = getDocumentForUrl(temp.GetURL());
  71
  72     uno::Reference<XConnection> xConnection = getConnectionForDocument(xDocument);
  73     // at this point migration is already done
  74     /* In the presence of tdf#119625, terminal already has messages
  75
  76            *value exceeds the range for a valid time
  77            caused by
  78            'isc_dsql_execute'
  79
  80            warn:dbaccess:22435:22435:dbaccess/source/filter/hsqldb/hsqlimport.cxx:373: Error during migration
  81
  82        In this case, we do not expect anything good from the following
  83        code, but I (tje, 2018-09-04) do not know how to detect this
  84        situation.  In particular, the migration has been observed to
  85        create the destination table (but truncated after the first
  86        row), and xConnection.is() returns true.
  87     */
  88
  89     // select basically everything from the .odb
  90     uno::Reference<XStatement> statement = xConnection->createStatement();
  91
  92     uno::Reference<XResultSet> xRes = statement->executeQuery("  SELECT id, tst_dt, tst_d, tst_t "
  93                                                               "    FROM tst_data "
  94                                                               "ORDER BY id");
  95     uno::Reference<XRow> xRow(xRes, UNO_QUERY_THROW);
  96
  97     // check result
  98     for (auto& e : expect)
  99     {
 100         CPPUNIT_ASSERT(xRes->next());
 101         CPPUNIT_ASSERT_EQUAL(xRow->getShort(1), e.id);
 102         auto time_got = xRow->getTime(4);
 103         auto time_expected = com::sun::star::util::Time(0, e.s, e.m, e.h, false);
 104         auto equal_times = time_got == time_expected;
 105         CPPUNIT_ASSERT(equal_times);
 106     }
 107     CPPUNIT_ASSERT(!xRes->next());
 108
 109     closeDocument(uno::Reference<lang::XComponent>(xDocument, uno::UNO_QUERY));
 110     if (!oldValue)
 111     {
 112         std::shared_ptr<comphelper::ConfigurationChanges> xChanges(
 113             comphelper::ConfigurationChanges::create());
 114         officecfg::Office::Common::Misc::ExperimentalMode::set(false, xChanges);
 115         xChanges->commit();
 116     }
 117 }
 118
 119 CPPUNIT_TEST_SUITE_REGISTRATION(Tdf119625Test);
 120
 121 CPPUNIT_PLUGIN_IMPLEMENT();