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