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