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