connectivity/source/drivers/firebird/DatabaseMetaData.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 #include "DatabaseMetaData.hxx"
  21 #include "Util.hxx"
  22
  23 #include <ibase.h>
  24 #include <rtl/ustrbuf.hxx>
  25 #include <FDatabaseMetaDataResultSet.hxx>
  26
  27 #include <com/sun/star/sdbc/ColumnValue.hpp>
  28 #include <com/sun/star/sdbc/DataType.hpp>
  29 #include <com/sun/star/sdbc/IndexType.hpp>
  30 #include <com/sun/star/sdbc/ResultSetType.hpp>
  31 #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
  32 #include <com/sun/star/sdbc/TransactionIsolation.hpp>
  33 #include <com/sun/star/sdbc/XParameters.hpp>
  34 #include <com/sun/star/sdbc/XRow.hpp>
  35
  36 using namespace connectivity::firebird;
  37 using namespace com::sun::star;
  38 using namespace com::sun::star::uno;
  39 using namespace com::sun::star::lang;
  40 using namespace com::sun::star::beans;
  41 using namespace com::sun::star::sdbc;
  42
  43 ODatabaseMetaData::ODatabaseMetaData(Connection* _pCon)
  44 : m_pConnection(_pCon)
  45 {
  46     SAL_WARN_IF(!m_pConnection.is(), "connectivity.firebird",
  47             "ODatabaseMetaData::ODatabaseMetaData: No connection set!");
  48 }
  49
  50 ODatabaseMetaData::~ODatabaseMetaData()
  51 {
  52 }
  53
  54 //----- Catalog Info -- UNSUPPORTED -------------------------------------------
  55 OUString SAL_CALL ODatabaseMetaData::getCatalogSeparator() throw(SQLException, RuntimeException, std::exception)
  56 {
  57     return OUString();
  58 }
  59
  60 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCatalogNameLength() throw(SQLException, RuntimeException, std::exception)
  61 {
  62     return -1;
  63 }
  64
  65 OUString SAL_CALL ODatabaseMetaData::getCatalogTerm() throw(SQLException, RuntimeException, std::exception)
  66 {
  67     return OUString();
  68 }
  69
  70 sal_Bool SAL_CALL ODatabaseMetaData::isCatalogAtStart() throw(SQLException, RuntimeException, std::exception)
  71 {
  72     return sal_False;
  73 }
  74
  75 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInTableDefinitions() throw(SQLException, RuntimeException, std::exception)
  76 {
  77     return sal_False;
  78 }
  79
  80 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInIndexDefinitions() throw(SQLException, RuntimeException, std::exception)
  81 {
  82     return sal_False;
  83 }
  84
  85 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInDataManipulation(  ) throw(SQLException, RuntimeException, std::exception)
  86 {
  87     return sal_False;
  88 }
  89
  90 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getCatalogs() throw(SQLException, RuntimeException, std::exception)
  91 {
  92     OSL_FAIL("Not implemented yet!");
  93     // TODO implement
  94     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eCatalogs);
  95 }
  96
  97 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInProcedureCalls() throw(SQLException, RuntimeException, std::exception)
  98 {
  99     return sal_False;
 100 }
 101
 102 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInPrivilegeDefinitions() throw(SQLException, RuntimeException, std::exception)
 103 {
 104     return sal_False;
 105 }
 106
 107 //----- Schema Info -- UNSUPPORTED --------------------------------------------
 108 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInProcedureCalls()
 109     throw(SQLException, RuntimeException, std::exception)
 110 {
 111     return sal_False;
 112 }
 113
 114 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInPrivilegeDefinitions()
 115     throw(SQLException, RuntimeException, std::exception)
 116 {
 117     return sal_False;
 118 }
 119
 120 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInDataManipulation()
 121     throw(SQLException, RuntimeException, std::exception)
 122 {
 123     return sal_False;
 124 }
 125
 126 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInIndexDefinitions()
 127     throw(SQLException, RuntimeException, std::exception)
 128 {
 129     return sal_False;
 130 }
 131
 132 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInTableDefinitions()
 133     throw(SQLException, RuntimeException, std::exception)
 134 {
 135     return sal_False;
 136 }
 137
 138 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxSchemaNameLength()
 139     throw(SQLException, RuntimeException, std::exception)
 140 {
 141     return -1;
 142 }
 143
 144 OUString SAL_CALL ODatabaseMetaData::getSchemaTerm()
 145     throw(SQLException, RuntimeException, std::exception)
 146 {
 147     return OUString();
 148 }
 149
 150 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getSchemas()
 151     throw(SQLException, RuntimeException, std::exception)
 152 {
 153     OSL_FAIL("Not implemented yet!");
 154     // TODO implement
 155     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eSchemas);
 156 }
 157
 158 //----- Max Sizes/Lengths -----------------------------------------------------
 159 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxBinaryLiteralLength() throw(SQLException, RuntimeException, std::exception)
 160 {
 161     return 32767;
 162 }
 163
 164 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxRowSize() throw(SQLException, RuntimeException, std::exception)
 165 {
 166     return 32767;
 167 }
 168
 169 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCharLiteralLength() throw(SQLException, RuntimeException, std::exception)
 170 {
 171     return 32767;
 172 }
 173
 174 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnNameLength() throw(SQLException, RuntimeException, std::exception)
 175 {
 176     return 31;
 177 }
 178
 179 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInIndex() throw(SQLException, RuntimeException, std::exception)
 180 {
 181     // TODO: No idea.
 182     // See: http://www.firebirdsql.org/en/firebird-technical-specifications/
 183     return 16;
 184 }
 185
 186 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCursorNameLength() throw(SQLException, RuntimeException, std::exception)
 187 {
 188     return 32;
 189 }
 190
 191 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxConnections() throw(SQLException, RuntimeException, std::exception)
 192 {
 193     return 100; // Arbitrary
 194 }
 195
 196 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInTable() throw(SQLException, RuntimeException, std::exception)
 197 {
 198     // May however be smaller.
 199     // See: http://www.firebirdsql.org/en/firebird-technical-specifications/
 200     return 32767;
 201 }
 202
 203 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxStatementLength() throw(SQLException, RuntimeException, std::exception)
 204 {
 205     return 32767;
 206 }
 207
 208 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxTableNameLength() throw(SQLException, RuntimeException, std::exception)
 209 {
 210     return 31;
 211 }
 212
 213 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxTablesInSelect(  ) throw(SQLException, RuntimeException, std::exception)
 214 {
 215     sal_Int32 nValue = 0; // 0 means no limit
 216     return nValue;
 217 }
 218
 219
 220 sal_Bool SAL_CALL ODatabaseMetaData::doesMaxRowSizeIncludeBlobs(  ) throw(SQLException, RuntimeException, std::exception)
 221 {
 222     return sal_False;
 223 }
 224
 225 // ---- Identifiers -----------------------------------------------------------
 226 // Only quoted identifiers are case sensitive, unquoted are case insensitive
 227 OUString SAL_CALL ODatabaseMetaData::getIdentifierQuoteString()
 228     throw(SQLException, RuntimeException, std::exception)
 229 {
 230     OUString aVal('"');
 231     return aVal;
 232 }
 233
 234 sal_Bool SAL_CALL ODatabaseMetaData::supportsMixedCaseQuotedIdentifiers(  ) throw(SQLException, RuntimeException, std::exception)
 235 {
 236     return sal_True;
 237 }
 238
 239 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseQuotedIdentifiers()
 240     throw(SQLException, RuntimeException, std::exception)
 241 {
 242     return sal_False;
 243 }
 244
 245 sal_Bool SAL_CALL ODatabaseMetaData::storesMixedCaseQuotedIdentifiers()
 246     throw(SQLException, RuntimeException, std::exception)
 247 {
 248     // TODO: confirm this -- the documentation is highly ambiguous
 249     // However it seems this should be true as quoted identifiers ARE
 250     // stored mixed case.
 251     return sal_True;
 252 }
 253
 254 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseQuotedIdentifiers()
 255     throw(SQLException, RuntimeException, std::exception)
 256 {
 257     return sal_False;
 258 }
 259
 260 // ---- Unquoted Identifiers -------------------------------------------------
 261 // All unquoted identifiers are stored upper case.
 262 sal_Bool SAL_CALL ODatabaseMetaData::supportsMixedCaseIdentifiers()
 263     throw(SQLException, RuntimeException, std::exception)
 264 {
 265     return sal_False;
 266 }
 267
 268 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseIdentifiers()
 269     throw(SQLException, RuntimeException, std::exception)
 270 {
 271     return sal_False;
 272 }
 273
 274 sal_Bool SAL_CALL ODatabaseMetaData::storesMixedCaseIdentifiers()
 275     throw(SQLException, RuntimeException, std::exception)
 276 {
 277     return sal_False;
 278 }
 279
 280 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseIdentifiers()
 281     throw(SQLException, RuntimeException, std::exception)
 282 {
 283     return sal_True;
 284 }
 285
 286 // ---- SQL Feature Support ---------------------------------------------------
 287 sal_Bool SAL_CALL ODatabaseMetaData::supportsCoreSQLGrammar()
 288     throw(SQLException, RuntimeException, std::exception)
 289 {
 290     return sal_True;
 291 }
 292
 293 sal_Bool SAL_CALL ODatabaseMetaData::supportsMinimumSQLGrammar()
 294     throw(SQLException, RuntimeException, std::exception)
 295 {
 296     return sal_True;
 297 }
 298
 299 sal_Bool SAL_CALL ODatabaseMetaData::supportsAlterTableWithAddColumn()
 300     throw(SQLException, RuntimeException, std::exception)
 301 {
 302     return sal_True;
 303 }
 304
 305 sal_Bool SAL_CALL ODatabaseMetaData::supportsAlterTableWithDropColumn()
 306     throw(SQLException, RuntimeException, std::exception)
 307 {
 308     return sal_True;
 309 }
 310
 311 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedDelete()
 312     throw(SQLException, RuntimeException, std::exception)
 313 {
 314     return sal_True;
 315 }
 316
 317 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedUpdate()
 318     throw(SQLException, RuntimeException, std::exception)
 319 {
 320     return sal_True;
 321 }
 322
 323 sal_Bool SAL_CALL ODatabaseMetaData::supportsOuterJoins()
 324     throw(SQLException, RuntimeException, std::exception)
 325 {
 326     return sal_True;
 327 }
 328
 329 sal_Bool SAL_CALL ODatabaseMetaData::supportsSelectForUpdate()
 330     throw(SQLException, RuntimeException, std::exception)
 331 {
 332     return sal_True;
 333 }
 334
 335 sal_Bool SAL_CALL ODatabaseMetaData::allTablesAreSelectable()
 336     throw(SQLException, RuntimeException, std::exception)
 337 {
 338     // TODO: true if embedded, but unsure about remote server
 339     return sal_True;
 340 }
 341
 342 sal_Bool SAL_CALL ODatabaseMetaData::supportsConvert(sal_Int32 fromType,
 343                                                      sal_Int32 toType)
 344     throw(SQLException, RuntimeException, std::exception)
 345 {
 346     (void) fromType;
 347     (void) toType;
 348     return sal_False;
 349 }
 350
 351 sal_Bool SAL_CALL ODatabaseMetaData::supportsTypeConversion()
 352     throw(SQLException, RuntimeException, std::exception)
 353 {
 354     return sal_False;
 355 }
 356
 357 sal_Bool SAL_CALL ODatabaseMetaData::supportsColumnAliasing()
 358     throw(SQLException, RuntimeException, std::exception)
 359 {
 360     return sal_True;
 361 }
 362
 363 sal_Bool SAL_CALL ODatabaseMetaData::supportsTableCorrelationNames()
 364     throw(SQLException, RuntimeException, std::exception)
 365 {
 366     return sal_True;
 367 }
 368
 369 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxIndexLength(  ) throw(SQLException, RuntimeException, std::exception)
 370 {
 371     sal_Int32 nValue = 0; // 0 means no limit
 372     return nValue;
 373 }
 374
 375 sal_Bool SAL_CALL ODatabaseMetaData::supportsNonNullableColumns(  ) throw(SQLException, RuntimeException, std::exception)
 376 {
 377     return sal_True;
 378 }
 379
 380 OUString SAL_CALL ODatabaseMetaData::getExtraNameCharacters(  ) throw(SQLException, RuntimeException, std::exception)
 381 {
 382     OUString aVal;
 383     return aVal;
 384 }
 385
 386 sal_Bool SAL_CALL ODatabaseMetaData::supportsDifferentTableCorrelationNames(  ) throw(SQLException, RuntimeException, std::exception)
 387 {
 388     return sal_False;
 389 }
 390 // ---- Data definition stuff -------------------------------------------------
 391 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionIgnoredInTransactions()
 392     throw(SQLException, RuntimeException, std::exception)
 393 {
 394     return sal_False;
 395 }
 396
 397 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionCausesTransactionCommit()
 398     throw(SQLException, RuntimeException, std::exception)
 399 {
 400     return sal_True;
 401 }
 402
 403 sal_Bool SAL_CALL ODatabaseMetaData::supportsDataManipulationTransactionsOnly()
 404     throw(SQLException, RuntimeException, std::exception)
 405 {
 406     return sal_True;
 407 }
 408
 409 sal_Bool SAL_CALL ODatabaseMetaData::
 410         supportsDataDefinitionAndDataManipulationTransactions()
 411     throw(SQLException, RuntimeException, std::exception)
 412 {
 413     return sal_False;
 414 }
 415 //----- Transaction Support --------------------------------------------------
 416 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactions()
 417     throw(SQLException, RuntimeException, std::exception)
 418 {
 419     return sal_True;
 420 }
 421
 422 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossRollback()
 423     throw(SQLException, RuntimeException, std::exception)
 424 {
 425     return sal_False;
 426 }
 427
 428 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossCommit()
 429     throw(SQLException, RuntimeException, std::exception)
 430 {
 431     return sal_False;
 432 }
 433
 434 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossCommit()
 435     throw(SQLException, RuntimeException, std::exception)
 436 {
 437     return sal_False;
 438 }
 439
 440 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossRollback()
 441     throw(SQLException, RuntimeException, std::exception)
 442 {
 443     return sal_False;
 444 }
 445
 446 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleTransactions()
 447     throw(SQLException, RuntimeException, std::exception)
 448 {
 449     return sal_True;
 450 }
 451
 452 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactionIsolationLevel(
 453         sal_Int32 aLevel)
 454     throw(SQLException, RuntimeException, std::exception)
 455 {
 456     return  aLevel == TransactionIsolation::READ_UNCOMMITTED
 457            || aLevel == TransactionIsolation::READ_COMMITTED
 458            || aLevel == TransactionIsolation::REPEATABLE_READ
 459            || aLevel == TransactionIsolation::SERIALIZABLE;
 460 }
 461
 462 sal_Int32 SAL_CALL ODatabaseMetaData::getDefaultTransactionIsolation()
 463     throw(SQLException, RuntimeException, std::exception)
 464 {
 465     return TransactionIsolation::REPEATABLE_READ;
 466 }
 467
 468
 469 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92FullSQL(  ) throw(SQLException, RuntimeException, std::exception)
 470 {
 471     return sal_False;
 472 }
 473
 474 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92EntryLevelSQL(  ) throw(SQLException, RuntimeException, std::exception)
 475 {
 476     return sal_True; // should be supported at least
 477 }
 478
 479 sal_Bool SAL_CALL ODatabaseMetaData::supportsIntegrityEnhancementFacility(  ) throw(SQLException, RuntimeException, std::exception)
 480 {
 481     return sal_False;
 482 }
 483
 484 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxStatements(  ) throw(SQLException, RuntimeException, std::exception)
 485 {
 486     sal_Int32 nValue = 0; // 0 means no limit
 487     return nValue;
 488 }
 489
 490 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxProcedureNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 491 {
 492     sal_Int32 nValue = 31; // TODO: confirm
 493     return nValue;
 494 }
 495
 496 sal_Bool SAL_CALL ODatabaseMetaData::allProceduresAreCallable(  ) throw(SQLException, RuntimeException, std::exception)
 497 {
 498     return sal_False;
 499 }
 500
 501 sal_Bool SAL_CALL ODatabaseMetaData::supportsStoredProcedures(  ) throw(SQLException, RuntimeException, std::exception)
 502 {
 503     return sal_True;
 504 }
 505
 506 sal_Bool SAL_CALL ODatabaseMetaData::isReadOnly(  ) throw(SQLException, RuntimeException, std::exception)
 507 {
 508     return m_pConnection->isReadOnly();
 509 }
 510
 511 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFiles(  ) throw(SQLException, RuntimeException, std::exception)
 512 {
 513     return m_pConnection->isEmbedded();
 514 }
 515
 516 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFilePerTable(  ) throw(SQLException, RuntimeException, std::exception)
 517 {
 518     return sal_False;
 519 }
 520
 521 sal_Bool SAL_CALL ODatabaseMetaData::nullPlusNonNullIsNull(  ) throw(SQLException, RuntimeException, std::exception)
 522 {
 523     return sal_False;
 524 }
 525
 526 sal_Bool SAL_CALL ODatabaseMetaData::supportsExpressionsInOrderBy(  ) throw(SQLException, RuntimeException, std::exception)
 527 {
 528     return sal_False;
 529 }
 530
 531 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupBy(  ) throw(SQLException, RuntimeException, std::exception)
 532 {
 533     return sal_True;
 534 }
 535
 536 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByBeyondSelect(  ) throw(SQLException, RuntimeException, std::exception)
 537 {
 538     // Unsure
 539     return sal_True;
 540 }
 541
 542 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByUnrelated(  ) throw(SQLException, RuntimeException, std::exception)
 543 {
 544     // Unsure
 545     return sal_False;
 546 }
 547
 548
 549 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleResultSets(  ) throw(SQLException, RuntimeException, std::exception)
 550 {
 551     return sal_False;
 552 }
 553
 554 sal_Bool SAL_CALL ODatabaseMetaData::supportsLikeEscapeClause(  ) throw(SQLException, RuntimeException, std::exception)
 555 {
 556     return sal_False;
 557 }
 558
 559 sal_Bool SAL_CALL ODatabaseMetaData::supportsOrderByUnrelated(  ) throw(SQLException, RuntimeException, std::exception)
 560 {
 561     return sal_False;
 562 }
 563
 564 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnion(  ) throw(SQLException, RuntimeException, std::exception)
 565 {
 566     return sal_True;
 567 }
 568
 569 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnionAll(  ) throw(SQLException, RuntimeException, std::exception)
 570 {
 571     return sal_True;
 572 }
 573
 574 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtEnd(  ) throw(SQLException, RuntimeException, std::exception)
 575 {
 576     return sal_False;
 577 }
 578
 579 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtStart(  ) throw(SQLException, RuntimeException, std::exception)
 580 {
 581     return sal_False;
 582 }
 583
 584 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedHigh(  ) throw(SQLException, RuntimeException, std::exception)
 585 {
 586     return sal_False;
 587 }
 588
 589 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedLow(  ) throw(SQLException, RuntimeException, std::exception)
 590 {
 591     return sal_False;
 592 }
 593
 594 sal_Bool SAL_CALL ODatabaseMetaData::supportsCorrelatedSubqueries(  ) throw(SQLException, RuntimeException, std::exception)
 595 {
 596     return sal_False;
 597 }
 598
 599 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInComparisons(  ) throw(SQLException, RuntimeException, std::exception)
 600 {
 601     return sal_False;
 602 }
 603
 604 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInExists(  ) throw(SQLException, RuntimeException, std::exception)
 605 {
 606     return sal_False;
 607 }
 608
 609 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInIns(  ) throw(SQLException, RuntimeException, std::exception)
 610 {
 611     return sal_False;
 612 }
 613
 614 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInQuantifieds(  ) throw(SQLException, RuntimeException, std::exception)
 615 {
 616     return sal_False;
 617 }
 618
 619 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92IntermediateSQL(  ) throw(SQLException, RuntimeException, std::exception)
 620 {
 621     return sal_False;
 622 }
 623
 624 OUString SAL_CALL ODatabaseMetaData::getURL() throw(SQLException, RuntimeException, std::exception)
 625 {
 626     return m_pConnection->getConnectionURL();
 627 }
 628
 629 OUString SAL_CALL ODatabaseMetaData::getUserName(  ) throw(SQLException, RuntimeException, std::exception)
 630 {
 631     OUString aValue;
 632     return aValue;
 633 }
 634
 635 OUString SAL_CALL ODatabaseMetaData::getDriverName(  ) throw(SQLException, RuntimeException, std::exception)
 636 {
 637     OUString aValue;
 638     return aValue;
 639 }
 640
 641 OUString SAL_CALL ODatabaseMetaData::getDriverVersion() throw(SQLException, RuntimeException, std::exception)
 642 {
 643     OUString aValue;
 644     return aValue;
 645 }
 646
 647 OUString SAL_CALL ODatabaseMetaData::getDatabaseProductVersion(  ) throw(SQLException, RuntimeException, std::exception)
 648 {
 649     OUString aValue;
 650     return aValue;
 651 }
 652
 653 OUString SAL_CALL ODatabaseMetaData::getDatabaseProductName(  ) throw(SQLException, RuntimeException, std::exception)
 654 {
 655     OUString aValue;
 656     return aValue;
 657 }
 658
 659 OUString SAL_CALL ODatabaseMetaData::getProcedureTerm(  ) throw(SQLException, RuntimeException, std::exception)
 660 {
 661     OUString aValue;
 662     return aValue;
 663 }
 664
 665 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMajorVersion(  ) throw(RuntimeException, std::exception)
 666 {
 667     return 1;
 668 }
 669
 670 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMinorVersion(  ) throw(RuntimeException, std::exception)
 671 {
 672     return 0;
 673 }
 674
 675 OUString SAL_CALL ODatabaseMetaData::getSQLKeywords(  ) throw(SQLException, RuntimeException, std::exception)
 676 {
 677     OUString aValue;
 678     return aValue;
 679 }
 680
 681 OUString SAL_CALL ODatabaseMetaData::getSearchStringEscape(  ) throw(SQLException, RuntimeException, std::exception)
 682 {
 683     OUString aValue;
 684     return aValue;
 685 }
 686
 687 OUString SAL_CALL ODatabaseMetaData::getStringFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 688 {
 689     return OUString();
 690 }
 691
 692 OUString SAL_CALL ODatabaseMetaData::getTimeDateFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 693 {
 694     return OUString();
 695 }
 696
 697 OUString SAL_CALL ODatabaseMetaData::getSystemFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 698 {
 699     return OUString();
 700 }
 701
 702 OUString SAL_CALL ODatabaseMetaData::getNumericFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 703 {
 704     return OUString();
 705 }
 706
 707 sal_Bool SAL_CALL ODatabaseMetaData::supportsExtendedSQLGrammar(  ) throw(SQLException, RuntimeException, std::exception)
 708 {
 709     return sal_False;
 710 }
 711
 712 sal_Bool SAL_CALL ODatabaseMetaData::supportsFullOuterJoins(  ) throw(SQLException, RuntimeException, std::exception)
 713 {
 714     return sal_False;
 715 }
 716
 717 sal_Bool SAL_CALL ODatabaseMetaData::supportsLimitedOuterJoins(  ) throw(SQLException, RuntimeException, std::exception)
 718 {
 719     return sal_False;
 720 }
 721
 722 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInGroupBy(  ) throw(SQLException, RuntimeException, std::exception)
 723 {
 724     sal_Int32 nValue = 0; // 0 means no limit
 725     return nValue;
 726 }
 727
 728 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInOrderBy(  ) throw(SQLException, RuntimeException, std::exception)
 729 {
 730     sal_Int32 nValue = 0; // 0 means no limit
 731     return nValue;
 732 }
 733
 734 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInSelect(  ) throw(SQLException, RuntimeException, std::exception)
 735 {
 736     sal_Int32 nValue = 0; // 0 means no limit
 737     return nValue;
 738 }
 739
 740 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxUserNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 741 {
 742     return 31;
 743 }
 744
 745 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetType(sal_Int32 setType)
 746     throw(SQLException, RuntimeException, std::exception)
 747 {
 748     switch (setType)
 749     {
 750         case ResultSetType::FORWARD_ONLY:
 751             return sal_True;
 752         default:
 753             return sal_False;
 754     }
 755 }
 756
 757 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetConcurrency(
 758         sal_Int32 aResultSetType,
 759         sal_Int32 aConcurrency)
 760     throw(SQLException, RuntimeException, std::exception)
 761 {
 762     if (aResultSetType == ResultSetType::FORWARD_ONLY
 763         && aConcurrency == ResultSetConcurrency::READ_ONLY)
 764         return sal_True;
 765     else
 766         return sal_False;
 767 }
 768
 769 sal_Bool SAL_CALL ODatabaseMetaData::ownUpdatesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 770 {
 771     (void) setType;
 772     return sal_False;
 773 }
 774
 775 sal_Bool SAL_CALL ODatabaseMetaData::ownDeletesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 776 {
 777     (void) setType;
 778     return sal_False;
 779 }
 780
 781 sal_Bool SAL_CALL ODatabaseMetaData::ownInsertsAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 782 {
 783     (void) setType;
 784     return sal_False;
 785 }
 786
 787 sal_Bool SAL_CALL ODatabaseMetaData::othersUpdatesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 788 {
 789     (void) setType;
 790     return sal_False;
 791 }
 792
 793 sal_Bool SAL_CALL ODatabaseMetaData::othersDeletesAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 794 {
 795     (void) setType;
 796     return sal_False;
 797 }
 798
 799 sal_Bool SAL_CALL ODatabaseMetaData::othersInsertsAreVisible( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 800 {
 801     (void) setType;
 802     return sal_False;
 803 }
 804
 805 sal_Bool SAL_CALL ODatabaseMetaData::updatesAreDetected( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 806 {
 807     (void) setType;
 808     return sal_False;
 809 }
 810
 811 sal_Bool SAL_CALL ODatabaseMetaData::deletesAreDetected( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 812 {
 813     (void) setType;
 814     return sal_False;
 815 }
 816
 817 sal_Bool SAL_CALL ODatabaseMetaData::insertsAreDetected( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 818 {
 819     (void) setType;
 820     return sal_False;
 821 }
 822
 823 sal_Bool SAL_CALL ODatabaseMetaData::supportsBatchUpdates()
 824     throw(SQLException, RuntimeException, std::exception)
 825 {
 826     // No batch support in firebird
 827     return sal_False;
 828 }
 829
 830 uno::Reference< XConnection > SAL_CALL ODatabaseMetaData::getConnection()
 831     throw(SQLException, RuntimeException, std::exception)
 832 {
 833     return uno::Reference<XConnection>(m_pConnection.get());
 834 }
 835
 836 // here follow all methods which return a resultset
 837 // the first methods is an example implementation how to use this resultset
 838 // of course you could implement it on your and you should do this because
 839 // the general way is more memory expensive
 840
 841 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTableTypes(  ) throw(SQLException, RuntimeException, std::exception)
 842 {
 843     OSL_FAIL("Not implemented yet!");
 844     // TODO implement
 845     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTableTypes);
 846 }
 847
 848 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTypeInfo()
 849     throw(SQLException, RuntimeException, std::exception)
 850 {
 851     SAL_INFO("connectivity.firebird", "getTypeInfo()");
 852
 853     // this returns an empty resultset where the column-names are already set
 854     // in special the metadata of the resultset already returns the right columns
 855     ODatabaseMetaDataResultSet* pResultSet =
 856             new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTypeInfo);
 857     uno::Reference< XResultSet > xResultSet = pResultSet;
 858     static ODatabaseMetaDataResultSet::ORows aResults;
 859
 860     if(aResults.empty())
 861     {
 862         ODatabaseMetaDataResultSet::ORow aRow(19);
 863
 864         // Common data
 865         aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue(); // Literal quote marks
 866         aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue(); // Literal quote marks
 867         aRow[7] = new ORowSetValueDecorator(sal_True); // Nullable
 868         aRow[8] = new ORowSetValueDecorator(sal_True); // Case sensitive
 869         aRow[10] = new ORowSetValueDecorator(sal_False); // Is unsigned
 870         // FIXED_PREC_SCALE: docs state "can it be a money value? " however
 871         // in reality this causes Base to treat all numbers as money formatted
 872         // by default which is wrong (and formatting as money value is still
 873         // possible for all values).
 874         aRow[11] = new ORowSetValueDecorator(sal_False);
 875         // Localised Type Name -- TODO: implement (but can be null):
 876         aRow[13] = new ORowSetValueDecorator();
 877         aRow[16] = new ORowSetValueDecorator();             // Unused
 878         aRow[17] = new ORowSetValueDecorator();             // Unused
 879         aRow[18] = new ORowSetValueDecorator(sal_Int16(10));// Radix
 880
 881         // SQL_TEXT
 882         aRow[1] = new ORowSetValueDecorator(OUString("CHAR"));
 883         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_TEXT));
 884         aRow[3] = new ORowSetValueDecorator(sal_Int16(32767)); // Prevision = max length
 885         aRow[6] = new ORowSetValueDecorator(OUString("length")); // Create Params
 886         aRow[9] = new ORowSetValueDecorator(
 887                 sal_Int16(ColumnSearch::FULL)); // Searchable
 888         aRow[12] = new ORowSetValueDecorator(sal_False); // Autoincrement
 889         aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
 890         aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max scale
 891         aResults.push_back(aRow);
 892
 893         // SQL_VARYING
 894         aRow[1] = new ORowSetValueDecorator(OUString("VARCHAR"));
 895         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_VARYING));
 896         aRow[3] = new ORowSetValueDecorator(sal_Int16(32767)); // Prevision = max length
 897         aRow[6] = new ORowSetValueDecorator(OUString("length")); // Create Params
 898         aRow[9] = new ORowSetValueDecorator(
 899                 sal_Int16(ColumnSearch::FULL)); // Searchable
 900         aRow[12] = new ORowSetValueDecorator(sal_False); // Autoincrement
 901         aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
 902         aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max scale
 903         aResults.push_back(aRow);
 904
 905         // Integer Types common
 906         {
 907             aRow[6] = new ORowSetValueDecorator(); // Create Params
 908             aRow[9] = new ORowSetValueDecorator(
 909                 sal_Int16(ColumnSearch::FULL)); // Searchable
 910             aRow[12] = new ORowSetValueDecorator(sal_True); // Autoincrement
 911             aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
 912             aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max scale
 913         }
 914         // SQL_SHORT
 915         aRow[1] = new ORowSetValueDecorator(OUString("SMALLINT"));
 916         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_SHORT));
 917         aRow[3] = new ORowSetValueDecorator(sal_Int16(5)); // Prevision
 918         aResults.push_back(aRow);
 919         // SQL_LONG
 920         aRow[1] = new ORowSetValueDecorator(OUString("INTEGER"));
 921         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_LONG));
 922         aRow[3] = new ORowSetValueDecorator(sal_Int16(10)); // Precision
 923         aResults.push_back(aRow);
 924         // SQL_INT64
 925         aRow[1] = new ORowSetValueDecorator(OUString("BIGINT"));
 926         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_INT64));
 927         aRow[3] = new ORowSetValueDecorator(sal_Int16(20)); // Precision
 928         aResults.push_back(aRow);
 929
 930         // Decimal Types common
 931         {
 932             aRow[6] = new ORowSetValueDecorator(); // Create Params
 933             aRow[9] = new ORowSetValueDecorator(
 934                 sal_Int16(ColumnSearch::FULL)); // Searchable
 935             aRow[12] = new ORowSetValueDecorator(sal_True); // Autoincrement
 936         }
 937         // SQL_FLOAT
 938         aRow[1] = new ORowSetValueDecorator(OUString("FLOAT"));
 939         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_FLOAT));
 940         aRow[3] = new ORowSetValueDecorator(sal_Int16(7)); // Precision
 941         aRow[14] = new ORowSetValueDecorator(sal_Int16(1)); // Minimum scale
 942         aRow[15] = new ORowSetValueDecorator(sal_Int16(7)); // Max scale
 943         aResults.push_back(aRow);
 944         // SQL_DOUBLE
 945         aRow[1] = new ORowSetValueDecorator(OUString("DOUBLE PRECISION"));
 946         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_DOUBLE));
 947         aRow[3] = new ORowSetValueDecorator(sal_Int16(15)); // Precision
 948         aRow[14] = new ORowSetValueDecorator(sal_Int16(1)); // Minimum scale
 949         aRow[15] = new ORowSetValueDecorator(sal_Int16(15)); // Max scale
 950         aResults.push_back(aRow);
 951 //         // SQL_D_FLOAT
 952 //         aRow[1] = new ORowSetValueDecorator(getColumnTypeNameFromFBType(SQL_D_FLOAT));
 953 //         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_D_FLOAT));
 954 //         aRow[3] = new ORowSetValueDecorator(sal_Int16(15)); // Precision
 955 //         aRow[14] = new ORowSetValueDecorator(sal_Int16(1)); // Minimum scale
 956 //         aRow[15] = new ORowSetValueDecorator(sal_Int16(15)); // Max scale
 957 //         aResults.push_back(aRow);
 958         // TODO: no idea whether D_FLOAT corresponds to an sql type
 959
 960         // SQL_TIMESTAMP
 961         // TODO: precision?
 962         aRow[1] = new ORowSetValueDecorator(OUString("TIMESTAMP"));
 963         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_TIMESTAMP));
 964         aRow[3] = new ORowSetValueDecorator(sal_Int32(8)); // Prevision = max length
 965         aRow[6] = new ORowSetValueDecorator(); // Create Params
 966         aRow[9] = new ORowSetValueDecorator(
 967                 sal_Int16(ColumnSearch::FULL)); // Searchable
 968         aRow[12] = new ORowSetValueDecorator(sal_False); // Autoincrement
 969         aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
 970         aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max scale
 971         aResults.push_back(aRow);
 972
 973         // SQL_TYPE_TIME
 974         // TODO: precision?
 975         aRow[1] = new ORowSetValueDecorator(OUString("TIME"));
 976         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_TYPE_TIME));
 977         aRow[3] = new ORowSetValueDecorator(sal_Int32(8)); // Prevision = max length
 978         aRow[6] = new ORowSetValueDecorator(); // Create Params
 979         aRow[9] = new ORowSetValueDecorator(
 980                 sal_Int16(ColumnSearch::FULL)); // Searchable
 981         aRow[12] = new ORowSetValueDecorator(sal_False); // Autoincrement
 982         aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
 983         aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max scale
 984         aResults.push_back(aRow);
 985
 986         // SQL_TYPE_DATE
 987         // TODO: precision?
 988         aRow[1] = new ORowSetValueDecorator(OUString("DATE"));
 989         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_TYPE_DATE));
 990         aRow[3] = new ORowSetValueDecorator(sal_Int32(8)); // Prevision = max length
 991         aRow[6] = new ORowSetValueDecorator(); // Create Params
 992         aRow[9] = new ORowSetValueDecorator(
 993                 sal_Int16(ColumnSearch::FULL)); // Searchable
 994         aRow[12] = new ORowSetValueDecorator(sal_False); // Autoincrement
 995         aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
 996         aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max scale
 997         aResults.push_back(aRow);
 998
 999         // SQL_BLOB
1000         // TODO: precision?
1001         aRow[1] = new ORowSetValueDecorator(OUString("BLOB"));
1002         aRow[2] = new ORowSetValueDecorator(getColumnTypeFromFBType(SQL_BLOB));
1003         aRow[3] = new ORowSetValueDecorator(sal_Int32(0)); // Prevision = max length
1004         aRow[6] = new ORowSetValueDecorator(); // Create Params
1005         aRow[9] = new ORowSetValueDecorator(
1006                 sal_Int16(ColumnSearch::NONE)); // Searchable
1007         aRow[12] = new ORowSetValueDecorator(sal_False); // Autoincrement
1008         aRow[14] = ODatabaseMetaDataResultSet::get0Value(); // Minimum scale
1009         aRow[15] = ODatabaseMetaDataResultSet::get0Value(); // Max scale
1010         aResults.push_back(aRow);
1011
1012         // TODO: complete
1013 //     case SQL_ARRAY:
1014 //     case SQL_NULL:
1015 //     case SQL_QUAD:      // Is a "Blob ID" according to the docs
1016     }
1017     pResultSet->setRows(aResults);
1018     return xResultSet;
1019 }
1020
1021 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getColumnPrivileges(
1022         const Any& /*aCatalog*/,
1023         const OUString& /*sSchema*/,
1024         const OUString& sTable,
1025         const OUString& sColumnNamePattern)
1026     throw(SQLException, RuntimeException, std::exception)
1027 {
1028     SAL_INFO("connectivity.firebird", "getColumnPrivileges() with "
1029              "Table: " << sTable
1030              << " & ColumnNamePattern: " << sColumnNamePattern);
1031
1032     ODatabaseMetaDataResultSet* pResultSet = new
1033         ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eColumnPrivileges);
1034     uno::Reference< XResultSet > xResultSet = pResultSet;
1035     uno::Reference< XStatement > statement = m_pConnection->createStatement();
1036
1037     static const char wld[] = "%";
1038     OUStringBuffer queryBuf(
1039             "SELECT "
1040             "priv.RDB$RELATION_NAME, "  // 1 Table name
1041             "priv.RDB$GRANTOR,"         // 2
1042             "priv.RDB$USER, "           // 3 Grantee
1043             "priv.RDB$PRIVILEGE, "      // 4
1044             "priv.RDB$GRANT_OPTION, "   // 5 is Grantable
1045             "priv.RDB$FIELD_NAME "      // 6 Column name
1046             "FROM RDB$USER_PRIVILEGES priv ");
1047
1048     {
1049         OUString sAppend = "WHERE priv.RDB$RELATION_NAME = '%' ";
1050         queryBuf.append(sAppend.replaceAll("%", sTable));
1051     }
1052     if (!sColumnNamePattern.isEmpty())
1053     {
1054         OUString sAppend;
1055         if (sColumnNamePattern.match(wld))
1056             sAppend = "AND priv.RDB$FIELD_NAME LIKE '%' ";
1057         else
1058             sAppend = "AND priv.RDB$FIELD_NAME = '%' ";
1059
1060         queryBuf.append(sAppend.replaceAll(wld, sColumnNamePattern));
1061     }
1062
1063     queryBuf.append(" ORDER BY priv.RDB$FIELD, "
1064                               "priv.RDB$PRIVILEGE");
1065
1066     OUString query = queryBuf.makeStringAndClear();
1067
1068     uno::Reference< XResultSet > rs = statement->executeQuery(query.getStr());
1069     uno::Reference< XRow > xRow( rs, UNO_QUERY_THROW );
1070     ODatabaseMetaDataResultSet::ORows aResults;
1071
1072     ODatabaseMetaDataResultSet::ORow aCurrentRow(8);
1073     aCurrentRow[0] = new ORowSetValueDecorator(); // Unused
1074     aCurrentRow[1] = new ORowSetValueDecorator(); // 1. TABLE_CAT Unsupported
1075     aCurrentRow[2] = new ORowSetValueDecorator(); // 1. TABLE_SCHEM Unsupported
1076
1077     while( rs->next() )
1078     {
1079         // 3. TABLE_NAME
1080         aCurrentRow[3] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(1)));
1081         // 4. COLUMN_NAME
1082         aCurrentRow[4] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(6)));
1083         aCurrentRow[5] = new ORowSetValueDecorator(xRow->getString(2)); // 5. GRANTOR
1084         aCurrentRow[6] = new ORowSetValueDecorator(xRow->getString(3)); // 6. GRANTEE
1085         aCurrentRow[7] = new ORowSetValueDecorator(xRow->getString(4)); // 7. Privilege
1086         aCurrentRow[7] = new ORowSetValueDecorator(xRow->getBoolean(5)); // 8. Grantable
1087
1088         aResults.push_back(aCurrentRow);
1089     }
1090
1091     pResultSet->setRows( aResults );
1092
1093     return xResultSet;
1094 }
1095
1096 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getColumns(
1097         const Any& /*catalog*/,
1098         const OUString& /*schemaPattern*/,
1099         const OUString& tableNamePattern,
1100         const OUString& columnNamePattern)
1101     throw(SQLException, RuntimeException, std::exception)
1102 {
1103     SAL_INFO("connectivity.firebird", "getColumns() with "
1104              "TableNamePattern: " << tableNamePattern <<
1105              " & ColumnNamePattern: " << columnNamePattern);
1106
1107     OUStringBuffer queryBuf("SELECT "
1108         "relfields.RDB$RELATION_NAME, " // 1
1109         "relfields.RDB$FIELD_NAME, "    // 2
1110         "relfields.RDB$DESCRIPTION,"    // 3
1111         "relfields.RDB$DEFAULT_VALUE, " // 4
1112         "relfields.RDB$FIELD_POSITION, "// 5
1113         "fields.RDB$FIELD_TYPE, "       // 6
1114         "fields.RDB$FIELD_LENGTH, "     // 7
1115         "fields.RDB$FIELD_PRECISION, "  // 8
1116         // Specifically use relfields null flag -- the one in fields is used
1117         // for domains, whether a specific field is nullable is set in relfields,
1118         // this is also the one we manually fiddle when changin NULL/NOT NULL
1119         // (see Table.cxx)
1120         "relfields.RDB$NULL_FLAG "      // 9
1121         "FROM RDB$RELATION_FIELDS relfields "
1122         "JOIN RDB$FIELDS fields "
1123         "on (fields.RDB$FIELD_NAME = relfields.RDB$FIELD_SOURCE) "
1124         "WHERE (1 = 1) ");
1125
1126     if (!tableNamePattern.isEmpty())
1127     {
1128         OUString sAppend;
1129         if (tableNamePattern.match("%"))
1130             sAppend = "AND relfields.RDB$RELATION_NAME LIKE '%' ";
1131         else
1132             sAppend = "AND relfields.RDB$RELATION_NAME = '%' ";
1133
1134         queryBuf.append(sAppend.replaceAll("%", tableNamePattern));
1135     }
1136
1137     if (!columnNamePattern.isEmpty())
1138     {
1139         OUString sAppend;
1140         if (columnNamePattern.match("%"))
1141             sAppend = "AND relfields.RDB$FIELD_NAME LIKE '%' ";
1142         else
1143             sAppend = "AND relfields.RDB$FIELD_NAME = '%' ";
1144
1145         queryBuf.append(sAppend.replaceAll("%", columnNamePattern));
1146     }
1147
1148     OUString query = queryBuf.makeStringAndClear();
1149
1150     uno::Reference< XStatement > statement = m_pConnection->createStatement();
1151     uno::Reference< XResultSet > rs = statement->executeQuery(query.getStr());
1152     uno::Reference< XRow > xRow( rs, UNO_QUERY_THROW );
1153
1154     ODatabaseMetaDataResultSet::ORows aResults;
1155     ODatabaseMetaDataResultSet::ORow aCurrentRow(19);
1156
1157     aCurrentRow[0] =  new ORowSetValueDecorator(); // Unused -- numbering starts from 0
1158     aCurrentRow[1] =  new ORowSetValueDecorator(); // Catalog - can be null
1159     aCurrentRow[2] =  new ORowSetValueDecorator(); // Schema - can be null
1160     aCurrentRow[8] =  new ORowSetValueDecorator(); // Unused
1161     aCurrentRow[10] = new ORowSetValueDecorator(sal_Int32(10)); // Radix: fixed in FB
1162     aCurrentRow[14] = new ORowSetValueDecorator(); // Unused
1163     aCurrentRow[15] = new ORowSetValueDecorator(); // Unused
1164
1165     while( rs->next() )
1166     {
1167         // 3. TABLE_NAME
1168         aCurrentRow[3] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(1)));
1169         // 4. Column Name
1170         aCurrentRow[4] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(2)));
1171         // 5. Datatype
1172         short aType = getFBTypeFromBlrType(xRow->getShort(6));
1173         aCurrentRow[5] = new ORowSetValueDecorator(getColumnTypeFromFBType(aType));
1174         // 6. Typename (SQL_*)
1175         aCurrentRow[6] = new ORowSetValueDecorator(getColumnTypeNameFromFBType(aType));
1176
1177         // 7. Column Sizes
1178         {
1179             sal_Int32 aColumnSize = 0;
1180             switch (aType)
1181             {
1182                 case SQL_TEXT:
1183                 case SQL_VARYING:
1184                     aColumnSize = xRow->getShort(7);
1185                     break;
1186                 case SQL_SHORT:
1187                 case SQL_LONG:
1188                 case SQL_FLOAT:
1189                 case SQL_DOUBLE:
1190                 case SQL_D_FLOAT:
1191                 case SQL_INT64:
1192                 case SQL_QUAD:
1193                     aColumnSize = xRow->getShort(8);
1194                     break;
1195                 case SQL_TIMESTAMP:
1196                 case SQL_BLOB:
1197                 case SQL_ARRAY:
1198                 case SQL_TYPE_TIME:
1199                 case SQL_TYPE_DATE:
1200                 case SQL_NULL:
1201                     // TODO: implement.
1202                     break;
1203             }
1204             aCurrentRow[7] = new ORowSetValueDecorator(aColumnSize);
1205         }
1206
1207         // 9. Decimal Digits
1208         // TODO: implement
1209         aCurrentRow[9] = new ORowSetValueDecorator(sal_Int32(0));
1210
1211         // 11. Nullable
1212         if (xRow->getShort(9))
1213         {
1214             aCurrentRow[11] = new ORowSetValueDecorator(ColumnValue::NO_NULLS);
1215         }
1216         else
1217         {
1218             aCurrentRow[11] = new ORowSetValueDecorator(ColumnValue::NULLABLE);
1219         }
1220         // 12. Comments -- may be omitted
1221         {
1222             OUString aDescription;
1223             uno::Reference< XBlob > xDescriptionBlob = xRow->getBlob(3);
1224             if (xDescriptionBlob.is())
1225             {
1226                 sal_Int32 aBlobLength = (sal_Int32) xDescriptionBlob->length();
1227                 aDescription = OUString(reinterpret_cast<char*>(xDescriptionBlob->getBytes(0, aBlobLength).getArray()),
1228                                         aBlobLength,
1229                                         RTL_TEXTENCODING_UTF8);
1230             }
1231             aCurrentRow[12] = new ORowSetValueDecorator(aDescription);
1232         }
1233         // 13. Default --  may be omitted.
1234         {
1235             uno::Reference< XBlob > xDefaultValueBlob = xRow->getBlob(4);
1236             if (xDefaultValueBlob.is())
1237             {
1238                 // TODO: Implement
1239             }
1240             aCurrentRow[13] = new ORowSetValueDecorator();
1241         }
1242
1243         // 16. Bytes in Column for char
1244         if (aType == SQL_TEXT)
1245         {
1246             aCurrentRow[16] = new ORowSetValueDecorator(xRow->getShort(7));
1247         }
1248         else if (aType == SQL_VARYING)
1249         {
1250             aCurrentRow[16] = new ORowSetValueDecorator(sal_Int32(32767));
1251         }
1252         else
1253         {
1254             aCurrentRow[16] = new ORowSetValueDecorator(sal_Int32(0));
1255         }
1256         // 17. Index of column
1257         {
1258             short nColumnNumber = xRow->getShort(5);
1259             // Firebird stores column numbers beginning with 0 internally
1260             // SDBC expects column numbering to begin with 1.
1261             aCurrentRow[17] = new ORowSetValueDecorator(sal_Int32(nColumnNumber + 1));
1262         }
1263         // 18. Is nullable
1264         if (xRow->getShort(9))
1265         {
1266             aCurrentRow[18] = new ORowSetValueDecorator(OUString("NO"));
1267         }
1268         else
1269         {
1270             aCurrentRow[18] = new ORowSetValueDecorator(OUString("YES"));
1271         }
1272
1273         aResults.push_back(aCurrentRow);
1274     }
1275     ODatabaseMetaDataResultSet* pResultSet = new
1276             ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eColumns);
1277     uno::Reference< XResultSet > xResultSet = pResultSet;
1278     pResultSet->setRows( aResults );
1279
1280     return xResultSet;
1281 }
1282
1283 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTables(
1284         const Any& /*catalog*/,
1285         const OUString& /*schemaPattern*/,
1286         const OUString& tableNamePattern,
1287         const Sequence< OUString >& types)
1288     throw(SQLException, RuntimeException, std::exception)
1289 {
1290     SAL_INFO("connectivity.firebird", "getTables() with "
1291              "TableNamePattern: " << tableNamePattern);
1292
1293     ODatabaseMetaDataResultSet* pResultSet = new
1294         ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTables);
1295     uno::Reference< XResultSet > xResultSet = pResultSet;
1296     uno::Reference< XStatement > statement = m_pConnection->createStatement();
1297
1298     static const char wld[] = "%";
1299     OUStringBuffer queryBuf(
1300             "SELECT "
1301             "RDB$RELATION_NAME, "
1302             "RDB$SYSTEM_FLAG, "
1303             "RDB$RELATION_TYPE, "
1304             "RDB$DESCRIPTION, "
1305             "RDB$VIEW_BLR "
1306             "FROM RDB$RELATIONS "
1307             "WHERE ");
1308
1309     // TODO: GLOBAL TEMPORARY, LOCAL TEMPORARY, ALIAS, SYNONYM
1310     if ((types.getLength() == 0) || (types.getLength() == 1 && types[0].match(wld)))
1311     {
1312         // All table types? I.e. includes system tables.
1313         queryBuf.append("(RDB$RELATION_TYPE = 0 OR RDB$RELATION_TYPE = 1) ");
1314     }
1315     else
1316     {
1317         queryBuf.append("( (0 = 1) ");
1318         for (int i = 0; i < types.getLength(); i++)
1319         {
1320             if (types[i] == "SYSTEM TABLE")
1321                 queryBuf.append("OR (RDB$SYSTEM_FLAG = 1 AND RDB$VIEW_BLR IS NULL) ");
1322             else if (types[i] == "TABLE")
1323                 queryBuf.append("OR (RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG = 0 AND RDB$VIEW_BLR IS NULL) ");
1324             else if (types[i] == "VIEW")
1325                 queryBuf.append("OR (RDB$SYSTEM_FLAG IS NULL OR RDB$SYSTEM_FLAG = 0 AND RDB$VIEW_BLR IS NOT NULL) ");
1326             else
1327                 throw SQLException(); // TODO: implement other types, see above.
1328         }
1329         queryBuf.append(") ");
1330     }
1331
1332     if (!tableNamePattern.isEmpty())
1333     {
1334         OUString sAppend;
1335         if (tableNamePattern.match(wld))
1336             sAppend = "AND RDB$RELATION_NAME LIKE '%' ";
1337         else
1338             sAppend = "AND RDB$RELATION_NAME = '%' ";
1339
1340         queryBuf.append(sAppend.replaceAll(wld, tableNamePattern));
1341     }
1342
1343     queryBuf.append(" ORDER BY RDB$RELATION_TYPE, RDB$RELATION_NAME");
1344
1345     OUString query = queryBuf.makeStringAndClear();
1346
1347     uno::Reference< XResultSet > rs = statement->executeQuery(query.getStr());
1348     uno::Reference< XRow > xRow( rs, UNO_QUERY_THROW );
1349     ODatabaseMetaDataResultSet::ORows aResults;
1350
1351     ODatabaseMetaDataResultSet::ORow aCurrentRow(6);
1352     aCurrentRow[0] = new ORowSetValueDecorator(); // 0. Unused
1353     aCurrentRow[1] = new ORowSetValueDecorator(); // 1. Table_Cat Unsupported
1354     aCurrentRow[2] = new ORowSetValueDecorator(); // 2. Table_Schem Unsupported
1355
1356     while( rs->next() )
1357     {
1358         // 3. TABLE_NAME
1359         aCurrentRow[3] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(1)));
1360         // 4. TABLE_TYPE
1361         {
1362             // TODO: check this as the docs are a bit unclear.
1363             sal_Int16 nSystemFlag = xRow->getShort(2);
1364             sal_Int16 nTableType  = xRow->getShort(3);
1365             xRow->getBlob(5); // We have to retrieve a column to verify it is null.
1366             bool aIsView      = !xRow->wasNull();
1367             OUString sTableType;
1368
1369             if (nSystemFlag == 1)
1370             {
1371                 sTableType = "SYSTEM TABLE";
1372             }
1373             else if (aIsView)
1374             {
1375                 sTableType = "VIEW";
1376             }
1377             else
1378             {
1379                 if (nTableType == 0)
1380                     sTableType = "TABLE";
1381             }
1382
1383             aCurrentRow[4] = new ORowSetValueDecorator(sTableType);
1384         }
1385         // 5. REMARKS
1386         {
1387             uno::Reference< XBlob > xBlob   = xRow->getBlob(4);
1388             OUString sDescription;
1389
1390             if (xBlob.is())
1391             {
1392                 // TODO: we should actually be using CLOB here instead.
1393                 // However we haven't implemented CLOB yet, so use BLOB.
1394                 sal_Int32 aBlobLength = (sal_Int32) xBlob->length();
1395                 sDescription = OUString(reinterpret_cast<char*>(xBlob->getBytes(0, aBlobLength).getArray()),
1396                                         aBlobLength,
1397                                         RTL_TEXTENCODING_UTF8);
1398             }
1399
1400             aCurrentRow[5] = new ORowSetValueDecorator(sDescription);
1401         }
1402
1403         aResults.push_back(aCurrentRow);
1404     }
1405
1406     pResultSet->setRows( aResults );
1407
1408     return xResultSet;
1409 }
1410
1411 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getProcedureColumns(
1412     const Any& catalog, const OUString& schemaPattern,
1413     const OUString& procedureNamePattern, const OUString& columnNamePattern ) throw(SQLException, RuntimeException, std::exception)
1414 {
1415     SAL_WARN("connectivity.firebird", "Not yet implemented");
1416     (void) catalog;
1417     (void) schemaPattern;
1418     (void) procedureNamePattern;
1419     (void) columnNamePattern;
1420     OSL_FAIL("Not implemented yet!");
1421     // TODO implement
1422     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eProcedureColumns);
1423 }
1424
1425 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getProcedures(
1426     const Any& catalog, const OUString& schemaPattern,
1427     const OUString& procedureNamePattern ) throw(SQLException, RuntimeException, std::exception)
1428 {
1429     SAL_WARN("connectivity.firebird", "Not yet implemented");
1430     (void) catalog;
1431     (void) schemaPattern;
1432     (void) procedureNamePattern;
1433     OSL_FAIL("Not implemented yet!");
1434     // TODO implement
1435     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eProcedures);
1436 }
1437
1438 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getVersionColumns(
1439     const Any& catalog, const OUString& schema, const OUString& table ) throw(SQLException, RuntimeException, std::exception)
1440 {
1441     SAL_WARN("connectivity.firebird", "Not yet implemented");
1442     (void) catalog;
1443     (void) schema;
1444     (void) table;
1445     OSL_FAIL("Not implemented yet!");
1446     // TODO implement
1447     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eVersionColumns);
1448 }
1449
1450 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getExportedKeys(
1451     const Any& catalog, const OUString& schema, const OUString& table ) throw(SQLException, RuntimeException, std::exception)
1452 {
1453     // List the columns in a table which are foreign keys. This is actually
1454     // never used anywhere in the LO codebase currently. Retrieval from firebird
1455     // requires using a 5-table join.
1456     SAL_WARN("connectivity.firebird", "Not yet implemented");
1457     (void) catalog;
1458     (void) schema;
1459     (void) table;
1460     OSL_FAIL("Not implemented yet!");
1461     // TODO implement
1462     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eExportedKeys);
1463 }
1464
1465 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getImportedKeys(
1466     const Any& catalog, const OUString& schema, const OUString& table ) throw(SQLException, RuntimeException, std::exception)
1467 {
1468     // List the columns in a table (which must be primary key, or possibly just
1469     // unique) that are referred to in other foreign keys. Will have a similar
1470     // 5-table or so join as in getExportedKeys.
1471     SAL_WARN("connectivity.firebird", "Not yet implemented");
1472     (void) catalog;
1473     (void) schema;
1474     (void) table;
1475     OSL_FAIL("Not implemented yet!");
1476     // TODO implement
1477     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eImportedKeys);
1478 }
1479
1480 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getPrimaryKeys(
1481         const Any& /*aCatalog*/,
1482         const OUString& /*sSchema*/,
1483         const OUString& sTable)
1484     throw(SQLException, RuntimeException, std::exception)
1485 {
1486     SAL_INFO("connectivity.firebird", "getPrimaryKeys() with "
1487              "Table: " << sTable);
1488
1489     OUStringBuffer aQueryBuf("SELECT "
1490         "constr.RDB$RELATION_NAME, "    // 1. Table Name
1491         "inds.RDB$FIELD_NAME, "         // 2. Column Name
1492         "inds.RDB$FIELD_POSITION, "     // 3. Sequence Number
1493         "constr.RDB$CONSTRAINT_NAME "   // 4 Constraint name
1494         "FROM RDB$RELATION_CONSTRAINTS constr "
1495         "JOIN RDB$INDEX_SEGMENTS inds "
1496         "on (constr.RDB$INDEX_NAME = inds.RDB$INDEX_NAME) ");
1497
1498     OUString sAppend = "WHERE constr.RDB$RELATION_NAME = '%' ";
1499     aQueryBuf.append(sAppend.replaceAll("%", sTable));
1500
1501     aQueryBuf.append("AND constr.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY' "
1502                     "ORDER BY inds.RDB$FIELD_NAME");
1503
1504     OUString sQuery = aQueryBuf.makeStringAndClear();
1505
1506     uno::Reference< XStatement > xStatement = m_pConnection->createStatement();
1507     uno::Reference< XResultSet > xRs = xStatement->executeQuery(sQuery);
1508     uno::Reference< XRow > xRow( xRs, UNO_QUERY_THROW );
1509
1510     ODatabaseMetaDataResultSet::ORows aResults;
1511     ODatabaseMetaDataResultSet::ORow aCurrentRow(7);
1512
1513     aCurrentRow[0] =  new ORowSetValueDecorator(); // Unused -- numbering starts from 0
1514     aCurrentRow[1] =  new ORowSetValueDecorator(); // Catalog - can be null
1515     aCurrentRow[2] =  new ORowSetValueDecorator(); // Schema - can be null
1516
1517     while(xRs->next())
1518     {
1519         // 3. Table Name
1520         if (xRs->getRow() == 1) // Table name doesn't change, so only retrieve once
1521         {
1522             aCurrentRow[3] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(1)));
1523         }
1524         // 4. Column Name
1525         aCurrentRow[4] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(2)));
1526         // 5. KEY_SEQ (which key in the sequence)
1527         aCurrentRow[5] = new ORowSetValueDecorator(xRow->getShort(3));
1528         // 6. Primary Key Name
1529         aCurrentRow[6] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(4)));
1530
1531         aResults.push_back(aCurrentRow);
1532     }
1533     ODatabaseMetaDataResultSet* pResultSet = new
1534             ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::ePrimaryKeys);
1535     uno::Reference< XResultSet > xResultSet = pResultSet;
1536     pResultSet->setRows( aResults );
1537
1538     return xResultSet;
1539 }
1540
1541 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getIndexInfo(
1542         const Any& /*aCatalog*/,
1543         const OUString& /*sSchema*/,
1544         const OUString& sTable,
1545         sal_Bool bIsUnique,
1546         sal_Bool bIsApproximate)
1547     throw(SQLException, RuntimeException, std::exception)
1548 {
1549     // Apparently this method can also return a "tableIndexStatistic"
1550     // However this is only mentioned in XDatabaseMetaData.idl (whose comments
1551     // are duplicated in the postgresql driver), and is otherwise undocumented.
1552     SAL_INFO("connectivity.firebird", "getPrimaryKeys() with "
1553              "Table: " << sTable);
1554
1555     OUStringBuffer aQueryBuf("SELECT "
1556         "indices.RDB$RELATION_NAME, "               // 1. Table Name
1557         "index_segments.RDB$FIELD_NAME, "           // 2. Column Name
1558         "index_segments.RDB$FIELD_POSITION, "       // 3. Sequence Number
1559         "indices.RDB$INDEX_NAME, "                  // 4. Index name
1560         "indices.RDB$UNIQUE_FLAG, "                 // 5. Unique Flag
1561         "indices.RDB$INDEX_TYPE "                   // 6. Index Type
1562         "FROM RDB$INDICES indices "
1563         "JOIN RDB$INDEX_SEGMENTS index_segments "
1564         "on (indices.RDB$INDEX_NAME = index_segments.RDB$INDEX_NAME) "
1565         "WHERE indices.RDB$RELATION_NAME = '" + sTable + "' "
1566         "AND (indices.RDB$SYSTEM_FLAG = 0) ");
1567     // Not sure whether we should exclude system indices, but otoh. we never
1568     // actually deal with system tables (system indices only apply to system
1569     // tables) within the GUI.
1570
1571     // Only filter if true (according to the docs), i.e.:
1572     // If false we return all indices, if true we return only unique indices
1573     if (bIsUnique)
1574         aQueryBuf.append("AND (indices.RDB$UNIQUE_FLAG = 1) ");
1575
1576     // TODO: what is bIsApproximate?
1577     (void) bIsApproximate;
1578
1579     OUString sQuery = aQueryBuf.makeStringAndClear();
1580
1581     uno::Reference< XStatement > xStatement = m_pConnection->createStatement();
1582     uno::Reference< XResultSet > xRs = xStatement->executeQuery(sQuery);
1583     uno::Reference< XRow > xRow( xRs, UNO_QUERY_THROW );
1584
1585     ODatabaseMetaDataResultSet::ORows aResults;
1586     ODatabaseMetaDataResultSet::ORow aCurrentRow(14);
1587
1588     aCurrentRow[0] = new ORowSetValueDecorator(); // Unused -- numbering starts from 0
1589     aCurrentRow[1] = new ORowSetValueDecorator(); // Catalog - can be null
1590     aCurrentRow[2] = new ORowSetValueDecorator(); // Schema - can be null
1591     aCurrentRow[5] = new ORowSetValueDecorator(); // Index Catalog -- can be null
1592     // According to wikipedia firebird uses clustered indices.
1593     // The documentation does not specifically seem to specify this.
1594     aCurrentRow[7] = new ORowSetValueDecorator(IndexType::CLUSTERED); // 7. INDEX TYPE
1595     aCurrentRow[13] = new ORowSetValueDecorator(); // Filter Condition -- can be null
1596
1597     while(xRs->next())
1598     {
1599         // 3. Table Name
1600         if (xRs->getRow() == 1) // Table name doesn't change, so only retrieve once
1601         {
1602             aCurrentRow[3] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(1)));
1603         }
1604
1605         // 4. NON_UNIQUE -- i.e. specifically negate here.
1606         aCurrentRow[4] = new ORowSetValueDecorator(!xRow->getBoolean(5));
1607         // 6. INDEX NAME
1608         aCurrentRow[6] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(4)));
1609
1610         // 8. ORDINAL POSITION
1611         aCurrentRow[8] = new ORowSetValueDecorator(xRow->getShort(3));
1612         // 9. COLUMN NAME
1613         aCurrentRow[9] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(2)));
1614         // 10. ASC(ending)/DESC(ending)
1615         if (xRow->getShort(6) == 1)
1616             aCurrentRow[10] = new ORowSetValueDecorator(OUString("D"));
1617         else
1618             aCurrentRow[10] = new ORowSetValueDecorator(OUString("A"));
1619         // TODO: double check this^^^, doesn't seem to be officially documented anywhere.
1620         // 11. CARDINALITY
1621         aCurrentRow[11] = new ORowSetValueDecorator((sal_Int32)0); // TODO: determine how to do this
1622         // 12. PAGES
1623         aCurrentRow[12] = new ORowSetValueDecorator((sal_Int32)0); // TODO: determine how to do this
1624
1625         aResults.push_back(aCurrentRow);
1626     }
1627     ODatabaseMetaDataResultSet* pResultSet = new
1628             ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::ePrimaryKeys);
1629     uno::Reference< XResultSet > xResultSet = pResultSet;
1630     pResultSet->setRows( aResults );
1631
1632     return xResultSet;
1633 }
1634
1635 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getBestRowIdentifier(
1636     const Any& catalog, const OUString& schema, const OUString& table, sal_Int32 scope,
1637     sal_Bool nullable ) throw(SQLException, RuntimeException, std::exception)
1638 {
1639     (void) catalog;
1640     (void) schema;
1641     (void) table;
1642     (void) scope;
1643     (void) nullable;
1644     OSL_FAIL("Not implemented yet!");
1645     // TODO implement
1646     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eBestRowIdentifier);
1647 }
1648
1649 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTablePrivileges(
1650         const Any& /*aCatalog*/,
1651         const OUString& /*sSchemaPattern*/,
1652         const OUString& sTableNamePattern)
1653     throw(SQLException, RuntimeException, std::exception)
1654 {
1655     SAL_INFO("connectivity.firebird", "getTablePrivileges() with "
1656              "TableNamePattern: " << sTableNamePattern);
1657
1658     ODatabaseMetaDataResultSet* pResultSet = new
1659         ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTablePrivileges);
1660     uno::Reference< XResultSet > xResultSet = pResultSet;
1661     uno::Reference< XStatement > statement = m_pConnection->createStatement();
1662
1663     // TODO: column specific privileges are included, we may need
1664     // to have WHERE RDB$FIELD_NAME = NULL or similar.
1665     static const char wld[] = "%";
1666     OUStringBuffer queryBuf(
1667             "SELECT "
1668             "priv.RDB$RELATION_NAME, "  // 1
1669             "priv.RDB$GRANTOR,"         // 2
1670             "priv.RDB$USER, "           // 3 Grantee
1671             "priv.RDB$PRIVILEGE, "      // 4
1672             "priv.RDB$GRANT_OPTION "    // 5 is Grantable
1673             "FROM RDB$USER_PRIVILEGES priv ");
1674
1675     if (!sTableNamePattern.isEmpty())
1676     {
1677         OUString sAppend;
1678         if (sTableNamePattern.match(wld))
1679             sAppend = "WHERE priv.RDB$RELATION_NAME LIKE '%' ";
1680         else
1681             sAppend = "WHERE priv.RDB$RELATION_NAME = '%' ";
1682
1683         queryBuf.append(sAppend.replaceAll(wld, sTableNamePattern));
1684     }
1685     queryBuf.append(" ORDER BY priv.RDB$RELATION_TYPE, "
1686                               "priv.RDB$RELATION_NAME, "
1687                               "priv.RDB$PRIVILEGE");
1688
1689     OUString query = queryBuf.makeStringAndClear();
1690
1691     uno::Reference< XResultSet > rs = statement->executeQuery(query.getStr());
1692     uno::Reference< XRow > xRow( rs, UNO_QUERY_THROW );
1693     ODatabaseMetaDataResultSet::ORows aResults;
1694
1695     ODatabaseMetaDataResultSet::ORow aRow(8);
1696     aRow[0] = new ORowSetValueDecorator(); // Unused
1697     aRow[1] = new ORowSetValueDecorator(); // TABLE_CAT unsupported
1698     aRow[2] = new ORowSetValueDecorator(); // TABLE_SCHEM unussported.
1699
1700     while( rs->next() )
1701     {
1702         // 3. TABLE_NAME
1703         aRow[3] = new ORowSetValueDecorator(sanitizeIdentifier(xRow->getString(1)));
1704         aRow[4] = new ORowSetValueDecorator(xRow->getString(2)); // 4. GRANTOR
1705         aRow[5] = new ORowSetValueDecorator(xRow->getString(3)); // 5. GRANTEE
1706         aRow[6] = new ORowSetValueDecorator(xRow->getString(4)); // 6. Privilege
1707         aRow[7] = new ORowSetValueDecorator(xRow->getBoolean(5)); // 7. Is Grantable
1708
1709         aResults.push_back(aRow);
1710     }
1711
1712     pResultSet->setRows( aResults );
1713
1714     return xResultSet;
1715 }
1716
1717 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getCrossReference(
1718     const Any& primaryCatalog, const OUString& primarySchema,
1719     const OUString& primaryTable, const Any& foreignCatalog,
1720     const OUString& foreignSchema, const OUString& foreignTable ) throw(SQLException, RuntimeException, std::exception)
1721 {
1722     (void) primaryCatalog;
1723     (void) primarySchema;
1724     (void) primaryTable;
1725     (void) foreignCatalog;
1726     (void) foreignSchema;
1727     (void) foreignTable;
1728     OSL_FAIL("Not implemented yet!");
1729     // TODO implement
1730     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eCrossReference);
1731 }
1732
1733 uno::Reference< XResultSet > SAL_CALL ODatabaseMetaData::getUDTs( const Any& catalog, const OUString& schemaPattern, const OUString& typeNamePattern, const Sequence< sal_Int32 >& types ) throw(SQLException, RuntimeException, std::exception)
1734 {
1735     (void) catalog;
1736     (void) schemaPattern;
1737     (void) typeNamePattern;
1738     (void) types;
1739     OSL_FAIL("Not implemented yet!");
1740     // TODO implement
1741     return new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eUDTs);
1742 }
1743
1744
1745
1746
1747 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */