connectivity/source/drivers/macab/MacabDatabaseMetaData.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  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20
  21 #include "MacabDatabaseMetaData.hxx"
  22 #include "MacabAddressBook.hxx"
  23 #include "MacabHeader.hxx"
  24 #include "MacabGroup.hxx"
  25 #include "macabutilities.hxx"
  26
  27 #include "MacabDriver.hxx"
  28 #include <FDatabaseMetaDataResultSet.hxx>
  29 #include <OTypeInfo.hxx>
  30 #include <com/sun/star/sdbc/ColumnSearch.hpp>
  31 #include <com/sun/star/sdbc/ColumnValue.hpp>
  32 #include <com/sun/star/sdbc/ResultSetType.hpp>
  33 #include <com/sun/star/sdbc/SQLException.hpp>
  34 #include <com/sun/star/sdbc/TransactionIsolation.hpp>
  35 #include <rtl/ref.hxx>
  36
  37 #include <vector>
  38
  39 using namespace connectivity::macab;
  40 using namespace com::sun::star::uno;
  41 using namespace com::sun::star::lang;
  42 using namespace com::sun::star::beans;
  43 using namespace com::sun::star::sdbc;
  44
  45 MacabDatabaseMetaData::MacabDatabaseMetaData(MacabConnection* _pCon)
  46         : m_xConnection(_pCon),
  47           m_bUseCatalog(true)
  48 {
  49     OSL_ENSURE(_pCon,"MacabDatabaseMetaData::MacabDatabaseMetaData: No connection set!");
  50
  51     osl_atomic_increment( &m_refCount );
  52     m_bUseCatalog   = !(usesLocalFiles() || usesLocalFilePerTable());
  53     osl_atomic_decrement( &m_refCount );
  54 }
  55
  56 MacabDatabaseMetaData::~MacabDatabaseMetaData()
  57 {
  58 }
  59
  60 OUString SAL_CALL MacabDatabaseMetaData::getCatalogSeparator(  )
  61 {
  62     if (m_bUseCatalog)
  63     { // do some special here for you database
  64     }
  65
  66     return OUString();
  67 }
  68
  69 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxBinaryLiteralLength(  )
  70 {
  71     return 0; // 0 means no limit
  72 }
  73
  74 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxRowSize(  )
  75 {
  76     return 0; // 0 means no limit
  77 }
  78
  79 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxCatalogNameLength(  )
  80 {
  81     return 0; // 0 means no limit
  82 }
  83
  84 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxCharLiteralLength(  )
  85 {
  86     return 0; // 0 means no limit
  87 }
  88
  89 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxColumnNameLength(  )
  90 {
  91     return 0; // 0 means no limit
  92 }
  93
  94 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxColumnsInIndex(  )
  95 {
  96     return 0; // 0 means no limit
  97 }
  98
  99 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxCursorNameLength(  )
 100 {
 101     return 0; // 0 means no limit
 102 }
 103
 104 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxConnections(  )
 105 {
 106     return 0; // 0 means no limit
 107 }
 108
 109 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxColumnsInTable(  )
 110 {
 111     return 0; // 0 means no limit
 112 }
 113
 114 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxStatementLength(  )
 115 {
 116     return 0; // 0 means no limit
 117 }
 118
 119 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxTableNameLength(  )
 120 {
 121     return 0; // 0 means no limit
 122 }
 123
 124 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxTablesInSelect(  )
 125 {
 126     // MaxTablesInSelect describes how many tables can participate in the FROM part of a given SELECT statement,
 127     // currently, the resultset/statement implementations can cope with one table only
 128     return 1;
 129 }
 130
 131 sal_Bool SAL_CALL MacabDatabaseMetaData::doesMaxRowSizeIncludeBlobs(  )
 132 {
 133     return false;
 134 }
 135
 136 sal_Bool SAL_CALL MacabDatabaseMetaData::storesLowerCaseQuotedIdentifiers(  )
 137 {
 138     return false;
 139 }
 140
 141 sal_Bool SAL_CALL MacabDatabaseMetaData::storesLowerCaseIdentifiers(  )
 142 {
 143     return false;
 144 }
 145
 146 sal_Bool SAL_CALL MacabDatabaseMetaData::storesMixedCaseQuotedIdentifiers(  )
 147 {
 148     return false;
 149 }
 150
 151 sal_Bool SAL_CALL MacabDatabaseMetaData::storesMixedCaseIdentifiers(  )
 152 {
 153     return false;
 154 }
 155
 156 sal_Bool SAL_CALL MacabDatabaseMetaData::storesUpperCaseQuotedIdentifiers(  )
 157 {
 158     return false;
 159 }
 160
 161 sal_Bool SAL_CALL MacabDatabaseMetaData::storesUpperCaseIdentifiers(  )
 162 {
 163     return false;
 164 }
 165
 166 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsAlterTableWithAddColumn(  )
 167 {
 168     return false;
 169 }
 170
 171 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsAlterTableWithDropColumn(  )
 172 {
 173     return false;
 174 }
 175
 176 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxIndexLength(  )
 177 {
 178     return 0; // 0 means no limit
 179 }
 180
 181 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsNonNullableColumns(  )
 182 {
 183     return false;
 184 }
 185
 186 OUString SAL_CALL MacabDatabaseMetaData::getCatalogTerm(  )
 187 {
 188     return OUString();
 189 }
 190
 191 OUString SAL_CALL MacabDatabaseMetaData::getIdentifierQuoteString(  )
 192 {
 193     // normally this is "
 194     return "\"";
 195 }
 196
 197 OUString SAL_CALL MacabDatabaseMetaData::getExtraNameCharacters(  )
 198 {
 199     return OUString();
 200 }
 201
 202 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsDifferentTableCorrelationNames(  )
 203 {
 204     return false;
 205 }
 206
 207 sal_Bool SAL_CALL MacabDatabaseMetaData::isCatalogAtStart(  )
 208 {
 209     return false;
 210 }
 211
 212 sal_Bool SAL_CALL MacabDatabaseMetaData::dataDefinitionIgnoredInTransactions(  )
 213 {
 214     return true;
 215 }
 216
 217 sal_Bool SAL_CALL MacabDatabaseMetaData::dataDefinitionCausesTransactionCommit(  )
 218 {
 219     return true;
 220 }
 221
 222 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsDataManipulationTransactionsOnly(  )
 223 {
 224     return true;
 225 }
 226
 227 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsDataDefinitionAndDataManipulationTransactions(  )
 228 {
 229     return true;
 230 }
 231
 232 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsPositionedDelete(  )
 233 {
 234     return false;
 235 }
 236
 237 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsPositionedUpdate(  )
 238 {
 239     return false;
 240 }
 241
 242 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsOpenStatementsAcrossRollback(  )
 243 {
 244     return false;
 245 }
 246
 247 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsOpenStatementsAcrossCommit(  )
 248 {
 249     return false;
 250 }
 251
 252 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsOpenCursorsAcrossCommit(  )
 253 {
 254     return false;
 255 }
 256
 257 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsOpenCursorsAcrossRollback(  )
 258 {
 259     return false;
 260 }
 261
 262 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsTransactionIsolationLevel( sal_Int32 )
 263 {
 264     return false;
 265 }
 266
 267 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSchemasInDataManipulation(  )
 268 {
 269     return false;
 270 }
 271
 272 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsANSI92FullSQL(  )
 273 {
 274     return false;
 275 }
 276
 277 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsANSI92EntryLevelSQL(  )
 278 {
 279     return true; // should be supported at least
 280 }
 281
 282 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsIntegrityEnhancementFacility(  )
 283 {
 284     return false;
 285 }
 286
 287 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSchemasInIndexDefinitions(  )
 288 {
 289     return false;
 290 }
 291
 292 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSchemasInTableDefinitions(  )
 293 {
 294     return false;
 295 }
 296
 297 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsCatalogsInTableDefinitions(  )
 298 {
 299     return false;
 300 }
 301
 302 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsCatalogsInIndexDefinitions(  )
 303 {
 304     return false;
 305 }
 306
 307 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsCatalogsInDataManipulation(  )
 308 {
 309     return false;
 310 }
 311
 312 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsOuterJoins(  )
 313 {
 314     return false;
 315 }
 316
 317 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxStatements(  )
 318 {
 319     return 0; // 0 means no limit
 320 }
 321
 322 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxProcedureNameLength(  )
 323 {
 324     return 0; // 0 means no limit
 325 }
 326
 327 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxSchemaNameLength(  )
 328 {
 329     return 0; // 0 means no limit
 330 }
 331
 332 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsTransactions(  )
 333 {
 334     return false;
 335 }
 336
 337 sal_Bool SAL_CALL MacabDatabaseMetaData::allProceduresAreCallable(  )
 338 {
 339     return false;
 340 }
 341
 342 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsStoredProcedures(  )
 343 {
 344     return false;
 345 }
 346
 347 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSelectForUpdate(  )
 348 {
 349     return false;
 350 }
 351
 352 sal_Bool SAL_CALL MacabDatabaseMetaData::allTablesAreSelectable(  )
 353 {
 354     return false;
 355 }
 356
 357 sal_Bool SAL_CALL MacabDatabaseMetaData::isReadOnly(  )
 358 {
 359     // for the moment, we have read-only addresses, but this might change in the future
 360     return true;
 361 }
 362
 363 sal_Bool SAL_CALL MacabDatabaseMetaData::usesLocalFiles(  )
 364 {
 365     return false;
 366 }
 367
 368 sal_Bool SAL_CALL MacabDatabaseMetaData::usesLocalFilePerTable(  )
 369 {
 370     return false;
 371 }
 372
 373 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsTypeConversion(  )
 374 {
 375     return false;
 376 }
 377
 378 sal_Bool SAL_CALL MacabDatabaseMetaData::nullPlusNonNullIsNull(  )
 379 {
 380     return false;
 381 }
 382
 383 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsColumnAliasing(  )
 384 {
 385     return false;
 386 }
 387
 388 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsTableCorrelationNames(  )
 389 {
 390     return false;
 391 }
 392
 393 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsConvert( sal_Int32, sal_Int32 )
 394 {
 395     return false;
 396 }
 397
 398 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsExpressionsInOrderBy(  )
 399 {
 400     return false;
 401 }
 402
 403 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsGroupBy(  )
 404 {
 405     return false;
 406 }
 407
 408 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsGroupByBeyondSelect(  )
 409 {
 410     return false;
 411 }
 412
 413 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsGroupByUnrelated(  )
 414 {
 415     return false;
 416 }
 417
 418 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsMultipleTransactions(  )
 419 {
 420     return false;
 421 }
 422
 423 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsMultipleResultSets(  )
 424 {
 425     return false;
 426 }
 427
 428 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsLikeEscapeClause(  )
 429 {
 430     return false;
 431 }
 432
 433 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsOrderByUnrelated(  )
 434 {
 435     return false;
 436 }
 437
 438 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsUnion(  )
 439 {
 440     return false;
 441 }
 442
 443 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsUnionAll(  )
 444 {
 445     return false;
 446 }
 447
 448 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsMixedCaseIdentifiers(  )
 449 {
 450     return false;
 451 }
 452
 453 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsMixedCaseQuotedIdentifiers(  )
 454 {
 455     return false;
 456 }
 457
 458 sal_Bool SAL_CALL MacabDatabaseMetaData::nullsAreSortedAtEnd(  )
 459 {
 460     return false;
 461 }
 462
 463 sal_Bool SAL_CALL MacabDatabaseMetaData::nullsAreSortedAtStart(  )
 464 {
 465     return false;
 466 }
 467
 468 sal_Bool SAL_CALL MacabDatabaseMetaData::nullsAreSortedHigh(  )
 469 {
 470     return false;
 471 }
 472
 473 sal_Bool SAL_CALL MacabDatabaseMetaData::nullsAreSortedLow(  )
 474 {
 475     return false;
 476 }
 477
 478 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSchemasInProcedureCalls(  )
 479 {
 480     return false;
 481 }
 482
 483 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSchemasInPrivilegeDefinitions(  )
 484 {
 485     return false;
 486 }
 487
 488 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsCatalogsInProcedureCalls(  )
 489 {
 490     return false;
 491 }
 492
 493 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsCatalogsInPrivilegeDefinitions(  )
 494 {
 495     return false;
 496 }
 497
 498 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsCorrelatedSubqueries(  )
 499 {
 500     return false;
 501 }
 502
 503 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSubqueriesInComparisons(  )
 504 {
 505     return false;
 506 }
 507
 508 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSubqueriesInExists(  )
 509 {
 510     return false;
 511 }
 512
 513 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSubqueriesInIns(  )
 514 {
 515     return false;
 516 }
 517
 518 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsSubqueriesInQuantifieds(  )
 519 {
 520     return false;
 521 }
 522
 523 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsANSI92IntermediateSQL(  )
 524 {
 525     return false;
 526 }
 527
 528 OUString SAL_CALL MacabDatabaseMetaData::getURL(  )
 529 {
 530     // if someday we support more than the default address book,
 531     // this method should return the URL which was used to create it
 532     return "sdbc:address:macab:";
 533 }
 534
 535 OUString SAL_CALL MacabDatabaseMetaData::getUserName(  )
 536 {
 537     return OUString();
 538 }
 539
 540 OUString SAL_CALL MacabDatabaseMetaData::getDriverName(  )
 541 {
 542     return "macab";
 543 }
 544
 545 OUString SAL_CALL MacabDatabaseMetaData::getDriverVersion()
 546 {
 547     return MACAB_DRIVER_VERSION;
 548 }
 549
 550 OUString SAL_CALL MacabDatabaseMetaData::getDatabaseProductVersion(  )
 551 {
 552     return OUString();
 553 }
 554
 555 OUString SAL_CALL MacabDatabaseMetaData::getDatabaseProductName(  )
 556 {
 557     return OUString();
 558 }
 559
 560 OUString SAL_CALL MacabDatabaseMetaData::getProcedureTerm(  )
 561 {
 562     return OUString();
 563 }
 564
 565 OUString SAL_CALL MacabDatabaseMetaData::getSchemaTerm(  )
 566 {
 567     return OUString();
 568 }
 569
 570 sal_Int32 SAL_CALL MacabDatabaseMetaData::getDriverMajorVersion(  )
 571 {
 572     return MACAB_DRIVER_VERSION_MAJOR;
 573 }
 574
 575 sal_Int32 SAL_CALL MacabDatabaseMetaData::getDefaultTransactionIsolation(  )
 576 {
 577     return TransactionIsolation::NONE;
 578 }
 579
 580 sal_Int32 SAL_CALL MacabDatabaseMetaData::getDriverMinorVersion(  )
 581 {
 582     return MACAB_DRIVER_VERSION_MINOR;
 583 }
 584
 585 OUString SAL_CALL MacabDatabaseMetaData::getSQLKeywords(  )
 586 {
 587     return OUString();
 588 }
 589
 590 OUString SAL_CALL MacabDatabaseMetaData::getSearchStringEscape(  )
 591 {
 592     return OUString();
 593 }
 594
 595 OUString SAL_CALL MacabDatabaseMetaData::getStringFunctions(  )
 596 {
 597     return OUString();
 598 }
 599
 600 OUString SAL_CALL MacabDatabaseMetaData::getTimeDateFunctions(  )
 601 {
 602     return OUString();
 603 }
 604
 605 OUString SAL_CALL MacabDatabaseMetaData::getSystemFunctions(  )
 606 {
 607     return OUString();
 608 }
 609
 610 OUString SAL_CALL MacabDatabaseMetaData::getNumericFunctions(  )
 611 {
 612     return OUString();
 613 }
 614
 615 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsExtendedSQLGrammar(  )
 616 {
 617     return false;
 618 }
 619
 620 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsCoreSQLGrammar(  )
 621 {
 622     return false;
 623 }
 624
 625 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsMinimumSQLGrammar(  )
 626 {
 627     return true;
 628 }
 629
 630 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsFullOuterJoins(  )
 631 {
 632     return false;
 633 }
 634
 635 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsLimitedOuterJoins(  )
 636 {
 637     return false;
 638 }
 639
 640 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxColumnsInGroupBy(  )
 641 {
 642     return 0; // 0 means no limit
 643 }
 644
 645 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxColumnsInOrderBy(  )
 646 {
 647     return 0; // 0 means no limit
 648 }
 649
 650 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxColumnsInSelect(  )
 651 {
 652     return 0; // 0 means no limit
 653 }
 654
 655 sal_Int32 SAL_CALL MacabDatabaseMetaData::getMaxUserNameLength(  )
 656 {
 657     return 0; // 0 means no limit
 658 }
 659
 660 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsResultSetType( sal_Int32 setType )
 661 {
 662     switch (setType)
 663     {
 664         case ResultSetType::FORWARD_ONLY:
 665         case ResultSetType::SCROLL_INSENSITIVE:
 666             return true;
 667     }
 668     return false;
 669 }
 670
 671 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 )
 672 {
 673     switch (setType)
 674     {
 675         case ResultSetType::FORWARD_ONLY:
 676         case ResultSetType::SCROLL_INSENSITIVE:
 677             return true;
 678     }
 679     return false;
 680 }
 681
 682 sal_Bool SAL_CALL MacabDatabaseMetaData::ownUpdatesAreVisible( sal_Int32 )
 683 {
 684     return false;
 685 }
 686
 687 sal_Bool SAL_CALL MacabDatabaseMetaData::ownDeletesAreVisible( sal_Int32 )
 688 {
 689     return false;
 690 }
 691
 692 sal_Bool SAL_CALL MacabDatabaseMetaData::ownInsertsAreVisible( sal_Int32 )
 693 {
 694     return false;
 695 }
 696
 697 sal_Bool SAL_CALL MacabDatabaseMetaData::othersUpdatesAreVisible( sal_Int32 )
 698 {
 699     return false;
 700 }
 701
 702 sal_Bool SAL_CALL MacabDatabaseMetaData::othersDeletesAreVisible( sal_Int32 )
 703 {
 704     return false;
 705 }
 706
 707 sal_Bool SAL_CALL MacabDatabaseMetaData::othersInsertsAreVisible( sal_Int32 )
 708 {
 709     return false;
 710 }
 711
 712 sal_Bool SAL_CALL MacabDatabaseMetaData::updatesAreDetected( sal_Int32 )
 713 {
 714     return false;
 715 }
 716
 717 sal_Bool SAL_CALL MacabDatabaseMetaData::deletesAreDetected( sal_Int32 )
 718 {
 719     return false;
 720 }
 721
 722 sal_Bool SAL_CALL MacabDatabaseMetaData::insertsAreDetected( sal_Int32 )
 723 {
 724     return false;
 725 }
 726
 727 sal_Bool SAL_CALL MacabDatabaseMetaData::supportsBatchUpdates(  )
 728 {
 729     return false;
 730 }
 731
 732 Reference< XConnection > SAL_CALL MacabDatabaseMetaData::getConnection(  )
 733 {
 734     return m_xConnection;
 735 }
 736
 737 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getTableTypes(  )
 738 {
 739     rtl::Reference<::connectivity::ODatabaseMetaDataResultSet> pResult = new ::connectivity::ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTableTypes);
 740
 741     static ODatabaseMetaDataResultSet::ORows aRows = []
 742     {
 743         static constexpr OUStringLiteral aTable = u"TABLE";
 744         ODatabaseMetaDataResultSet::ORows tmp;
 745         ODatabaseMetaDataResultSet::ORow aRow(2);
 746         aRow[0] = ODatabaseMetaDataResultSet::getEmptyValue();
 747         aRow[1] = new ORowSetValueDecorator(OUString(aTable));
 748         tmp.push_back(aRow);
 749         return tmp;
 750     }();
 751     pResult->setRows(std::vector(aRows));
 752     return pResult;
 753 }
 754
 755 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getTypeInfo(  )
 756 {
 757     rtl::Reference<ODatabaseMetaDataResultSet> pResult = new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTypeInfo);
 758
 759     static ODatabaseMetaDataResultSet::ORows aRows = []()
 760     {
 761         ODatabaseMetaDataResultSet::ORows tmp;
 762         ODatabaseMetaDataResultSet::ORow aRow(19);
 763
 764         // We support four types: char, timestamp, integer, float
 765         aRow[0] = ODatabaseMetaDataResultSet::getEmptyValue();
 766         aRow[1] = new ORowSetValueDecorator(OUString("CHAR"));
 767         aRow[2] = new ORowSetValueDecorator(DataType::CHAR);
 768         aRow[3] = new ORowSetValueDecorator(sal_Int32(254));
 769         aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue();
 770         aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue();
 771         aRow[6] = ODatabaseMetaDataResultSet::getEmptyValue();
 772         aRow[7] = new ORowSetValueDecorator(sal_Int32(ColumnValue::NULLABLE));
 773         aRow[8] = ODatabaseMetaDataResultSet::get1Value();
 774         aRow[9] = new ORowSetValueDecorator(sal_Int32(ColumnSearch::CHAR));
 775         aRow[10] = ODatabaseMetaDataResultSet::get1Value();
 776         aRow[11] = ODatabaseMetaDataResultSet::get0Value();
 777         aRow[12] = ODatabaseMetaDataResultSet::get0Value();
 778         aRow[13] = ODatabaseMetaDataResultSet::getEmptyValue();
 779         aRow[14] = ODatabaseMetaDataResultSet::get0Value();
 780         aRow[15] = ODatabaseMetaDataResultSet::get0Value();
 781         aRow[16] = ODatabaseMetaDataResultSet::getEmptyValue();
 782         aRow[17] = ODatabaseMetaDataResultSet::getEmptyValue();
 783         aRow[18] = new ORowSetValueDecorator(sal_Int32(10));
 784
 785         tmp.push_back(aRow);
 786
 787         aRow[1] = new ORowSetValueDecorator(OUString("TIMESTAMP"));
 788         aRow[2] = new ORowSetValueDecorator(DataType::TIMESTAMP);
 789         aRow[3] = new ORowSetValueDecorator(sal_Int32(19));
 790         aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue();
 791         aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue();
 792         tmp.push_back(aRow);
 793
 794         aRow[1] = new ORowSetValueDecorator(OUString("INTEGER"));
 795         aRow[2] = new ORowSetValueDecorator(DataType::INTEGER);
 796         aRow[3] = new ORowSetValueDecorator(sal_Int32(20));
 797         aRow[15] = new ORowSetValueDecorator(sal_Int32(20));
 798         tmp.push_back(aRow);
 799
 800         aRow[1] = new ORowSetValueDecorator(OUString("FLOAT"));
 801         aRow[2] = new ORowSetValueDecorator(DataType::FLOAT);
 802         aRow[3] = new ORowSetValueDecorator(sal_Int32(20));
 803         aRow[15] = new ORowSetValueDecorator(sal_Int32(15));
 804         tmp.push_back(aRow);
 805
 806         return tmp;
 807     }();
 808     pResult->setRows(std::vector(aRows));
 809     return pResult;
 810 }
 811
 812 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getCatalogs(  )
 813 {
 814     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eCatalogs );
 815 }
 816
 817 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getSchemas(  )
 818 {
 819     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eSchemas );
 820 }
 821
 822 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getColumnPrivileges(
 823     const Any&, const OUString&, const OUString&,
 824     const OUString& )
 825 {
 826     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eColumnPrivileges );
 827 }
 828
 829 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getColumns(
 830     const Any&,
 831     const OUString&,
 832     const OUString& tableNamePattern,
 833     const OUString& columnNamePattern)
 834 {
 835     rtl::Reference<::connectivity::ODatabaseMetaDataResultSet> pResult = new ::connectivity::ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eColumns);
 836     MacabRecords *aRecords;
 837     OUString sTableName;
 838
 839     aRecords = m_xConnection->getAddressBook()->getMacabRecordsMatch(tableNamePattern);
 840
 841     ODatabaseMetaDataResultSet::ORows aRows;
 842     if(aRecords != nullptr)
 843     {
 844         MacabHeader *aHeader = aRecords->getHeader();
 845         sTableName = aRecords->getName();
 846
 847         ODatabaseMetaDataResultSet::ORow aRow(19);
 848
 849         aRow[0] = ODatabaseMetaDataResultSet::getEmptyValue();
 850         aRow[1] = ODatabaseMetaDataResultSet::getEmptyValue();
 851         aRow[2] = ODatabaseMetaDataResultSet::getEmptyValue();
 852         aRow[3] = new ORowSetValueDecorator(sTableName);
 853         aRow[8] = ODatabaseMetaDataResultSet::getEmptyValue();
 854         aRow[9] = ODatabaseMetaDataResultSet::get0Value();
 855         aRow[10] = new ORowSetValueDecorator(sal_Int32(10));
 856         aRow[11] = ODatabaseMetaDataResultSet::get1Value();
 857         aRow[12] = ODatabaseMetaDataResultSet::getEmptyValue();
 858         aRow[13] = ODatabaseMetaDataResultSet::getEmptyValue();
 859         aRow[14] = ODatabaseMetaDataResultSet::getEmptyValue();
 860         aRow[15] = ODatabaseMetaDataResultSet::getEmptyValue();
 861         aRow[16] = new ORowSetValueDecorator(sal_Int32(254));
 862         aRow[18] = new ORowSetValueDecorator(OUString("YES"));
 863
 864         sal_Int32 nPosition = 1;
 865         OUString sName;
 866
 867         MacabHeader::iterator aField;
 868
 869         for (   aField = aHeader->begin();
 870                 aField != aHeader->end();
 871                 ++aField, ++nPosition)
 872         {
 873
 874             sName = CFStringToOUString(static_cast<CFStringRef>((*aField)->value));
 875             if (match(columnNamePattern, sName, '\0'))
 876             {
 877                 aRow[4] = new ORowSetValueDecorator(sName);
 878                 aRow[17] = new ORowSetValueDecorator(nPosition);
 879                 switch((*aField)->type)
 880                 {
 881                     case kABStringProperty:
 882                         aRow[5] = new ORowSetValueDecorator(DataType::CHAR);
 883                         aRow[6] = new ORowSetValueDecorator(OUString("CHAR"));
 884                         aRow[7] = new ORowSetValueDecorator(sal_Int32(256));
 885                         aRows.push_back(aRow);
 886                         break;
 887                     case kABDateProperty:
 888                         aRow[5] = new ORowSetValueDecorator(DataType::TIMESTAMP);
 889                         aRow[6] = new ORowSetValueDecorator(OUString("TIMESTAMP"));
 890                         aRows.push_back(aRow);
 891                         break;
 892                     case kABIntegerProperty:
 893                         aRow[5] = new ORowSetValueDecorator(DataType::INTEGER);
 894                         aRow[6] = new ORowSetValueDecorator(OUString("INTEGER"));
 895                         aRow[7] = new ORowSetValueDecorator(sal_Int32(20));
 896                         aRows.push_back(aRow);
 897                         break;
 898                     case kABRealProperty:
 899                         aRow[5] = new ORowSetValueDecorator(DataType::FLOAT);
 900                         aRow[6] = new ORowSetValueDecorator(OUString("FLOAT"));
 901                         aRow[7] = new ORowSetValueDecorator(sal_Int32(15));
 902                         aRows.push_back(aRow);
 903                         break;
 904                     default:
 905                         ;
 906                         // shouldn't happen -- throw an error...?
 907                 }
 908             }
 909         }
 910     }
 911     pResult->setRows(std::move(aRows));
 912     return pResult;
 913 }
 914
 915 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getTables(
 916     const Any&,
 917     const OUString&,
 918     const OUString&,
 919     const Sequence< OUString >& types)
 920 {
 921     rtl::Reference<ODatabaseMetaDataResultSet> pResult = new ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTables);
 922
 923     // check whether we have tables in the requested types
 924     // for the moment, we answer only the "TABLE" table type
 925     // when no types are given at all, we return all the tables
 926     static constexpr OUString aTable = u"TABLE"_ustr;
 927     bool bTableFound = false;
 928     const OUString* p = types.getConstArray(),
 929                          * pEnd = p + types.getLength();
 930
 931     if (p == pEnd)
 932     {
 933         bTableFound = true;
 934     }
 935     else while (p < pEnd)
 936     {
 937         if (match(*p, aTable, '\0'))
 938         {
 939             bTableFound = true;
 940             break;
 941         }
 942         p++;
 943     }
 944     if (!bTableFound)
 945         return pResult;
 946
 947     static ODatabaseMetaDataResultSet::ORows aRows = [&]()
 948     {
 949         ODatabaseMetaDataResultSet::ORows tmp;
 950         ODatabaseMetaDataResultSet::ORow aRow(6);
 951
 952         MacabRecords *xRecords = m_xConnection->getAddressBook()->getMacabRecords();
 953         std::vector<MacabGroup *> xGroups = m_xConnection->getAddressBook()->getMacabGroups();
 954         sal_Int32 i, nGroups;
 955         nGroups = xGroups.size();
 956
 957         aRow[0] = ODatabaseMetaDataResultSet::getEmptyValue();
 958         aRow[1] = ODatabaseMetaDataResultSet::getEmptyValue();
 959         aRow[2] = ODatabaseMetaDataResultSet::getEmptyValue();
 960         aRow[3] = new ORowSetValueDecorator(xRecords->getName());
 961         aRow[4] = new ORowSetValueDecorator(aTable);
 962         aRow[5] = ODatabaseMetaDataResultSet::getEmptyValue();
 963         tmp.push_back(aRow);
 964
 965         for(i = 0; i < nGroups; i++)
 966         {
 967             aRow[3] = new ORowSetValueDecorator(xGroups[i]->getName());
 968             tmp.push_back(aRow);
 969         }
 970         return tmp;
 971     }();
 972     pResult->setRows(std::vector(aRows));
 973     return pResult;
 974 }
 975
 976 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getProcedureColumns(
 977     const Any&, const OUString&,
 978     const OUString&, const OUString& )
 979 {
 980     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eProcedureColumns );
 981 }
 982
 983 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getProcedures(
 984     const Any&, const OUString&,
 985     const OUString& )
 986 {
 987     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eProcedures );
 988 }
 989
 990 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getVersionColumns(
 991     const Any&, const OUString&, const OUString& table )
 992 {
 993     rtl::Reference<::connectivity::ODatabaseMetaDataResultSet> pResult = new ::connectivity::ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eVersionColumns);
 994
 995     ODatabaseMetaDataResultSet::ORows aRows;
 996
 997     if (m_xConnection->getAddressBook()->getMacabRecords(table) != nullptr)
 998     {
 999         ODatabaseMetaDataResultSet::ORow aRow( 9 );
1000
1001         OUString sName = CFStringToOUString(kABModificationDateProperty);
1002
1003         aRow[0] = ODatabaseMetaDataResultSet::getEmptyValue();
1004         aRow[1] = ODatabaseMetaDataResultSet::getEmptyValue();
1005         aRow[2] = new ORowSetValueDecorator(sName);
1006         aRow[3] = new ORowSetValueDecorator(DataType::TIMESTAMP);
1007         aRow[4] = new ORowSetValueDecorator(OUString("TIMESTAMP"));
1008
1009         aRow[5] = ODatabaseMetaDataResultSet::getEmptyValue();
1010         aRow[6] = ODatabaseMetaDataResultSet::getEmptyValue();
1011         aRow[7] = ODatabaseMetaDataResultSet::getEmptyValue();
1012         aRow[8] = ODatabaseMetaDataResultSet::getEmptyValue();
1013
1014         aRows.push_back(aRow);
1015     }
1016     pResult->setRows(std::move(aRows));
1017     return pResult;
1018 }
1019
1020 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getExportedKeys(
1021     const Any&, const OUString&, const OUString& )
1022 {
1023     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eExportedKeys );
1024 }
1025
1026 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getImportedKeys(
1027     const Any&, const OUString&, const OUString& )
1028 {
1029     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eImportedKeys );
1030 }
1031
1032 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getPrimaryKeys(
1033     const Any&, const OUString&, const OUString& )
1034 {
1035     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::ePrimaryKeys );
1036 }
1037
1038 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getIndexInfo(
1039     const Any&, const OUString&, const OUString&,
1040     sal_Bool, sal_Bool )
1041 {
1042     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eIndexInfo );
1043 }
1044
1045 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getBestRowIdentifier(
1046     const Any&, const OUString&, const OUString&, sal_Int32,
1047     sal_Bool )
1048 {
1049     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eBestRowIdentifier );
1050 }
1051
1052 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getTablePrivileges(
1053     const Any&, const OUString&, const OUString& )
1054 {
1055     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eTablePrivileges );
1056 }
1057
1058 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getCrossReference(
1059     const Any&, const OUString&,
1060     const OUString&, const Any&,
1061     const OUString&, const OUString& )
1062 {
1063     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eCrossReference );
1064 }
1065
1066 Reference< XResultSet > SAL_CALL MacabDatabaseMetaData::getUDTs( const Any&, const OUString&, const OUString&, const Sequence< sal_Int32 >& )
1067 {
1068     OSL_FAIL("Not implemented yet!");
1069     throw SQLException();
1070 }
1071
1072
1073 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */