connectivity/source/drivers/mozab/MDatabaseMetaData.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 "MDatabaseMetaData.hxx"
  21 #include "FDatabaseMetaDataResultSet.hxx"
  22 #include <com/sun/star/sdbc/DataType.hpp>
  23 #include <com/sun/star/sdbc/ResultSetType.hpp>
  24 #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
  25 #include <com/sun/star/sdbc/TransactionIsolation.hpp>
  26 #include <connectivity/dbexception.hxx>
  27 #include <connectivity/FValue.hxx>
  28 #include <com/sun/star/sdbc/ColumnValue.hpp>
  29 #include <com/sun/star/sdbc/ColumnSearch.hpp>
  30 #include "resource/common_res.hrc"
  31 #include <vector>
  32
  33 #if OSL_DEBUG_LEVEL > 0
  34 # define OUtoCStr( x ) ( OUStringToOString ( (x), RTL_TEXTENCODING_ASCII_US).getStr())
  35 #else /* OSL_DEBUG_LEVEL */
  36 # define OUtoCStr( x ) ("dummy")
  37 #endif /* OSL_DEBUG_LEVEL */
  38
  39 using namespace connectivity::mozab;
  40 using namespace connectivity;
  41 using namespace com::sun::star::uno;
  42 using namespace com::sun::star::lang;
  43 using namespace com::sun::star::beans;
  44 using namespace com::sun::star::sdbc;
  45 using namespace com::sun::star::sdbcx;
  46
  47
  48 namespace connectivity
  49 {
  50     namespace mozab
  51     {
  52         static sal_Int32    const s_nCOLUMN_SIZE = 256;
  53         static sal_Int32    const s_nDECIMAL_DIGITS = 0;
  54         static sal_Int32    const s_nNULLABLE = 1;
  55         static sal_Int32 const s_nCHAR_OCTET_LENGTH = 65535;
  56     }
  57 }
  58
  59
  60 ODatabaseMetaData::ODatabaseMetaData(OConnection* _pCon)
  61                         : ::connectivity::ODatabaseMetaDataBase(_pCon,_pCon->getConnectionInfo())
  62                         ,m_pConnection(_pCon)
  63 {
  64     OSL_ENSURE(m_pConnection,"ODatabaseMetaData::ODatabaseMetaData: No connection set!");
  65     m_pDbMetaDataHelper = new  MDatabaseMetaDataHelper();
  66 }
  67
  68 ODatabaseMetaData::~ODatabaseMetaData()
  69 {
  70     delete m_pDbMetaDataHelper;
  71 }
  72
  73
  74 ODatabaseMetaDataResultSet::ORows& SAL_CALL ODatabaseMetaData::getColumnRows(
  75         const OUString& tableNamePattern,
  76         const OUString& columnNamePattern ) throw(SQLException)
  77 {
  78     static ODatabaseMetaDataResultSet::ORows aRows;
  79     ODatabaseMetaDataResultSet::ORow  aRow(19);
  80     aRows.clear();
  81
  82     ::osl::MutexGuard aGuard( m_aMutex );
  83
  84     ::std::vector< OUString > tables;
  85     ::std::vector< OUString > types;
  86     if ( !m_pDbMetaDataHelper->getTableStrings( m_pConnection, tables, types) ) {
  87         getOwnConnection()->throwSQLException( m_pDbMetaDataHelper->getError(), *this );
  88     }
  89
  90     // ****************************************************
  91     // Some entries in a row never change, so set them now
  92     // ****************************************************
  93
  94     // Catalog
  95     aRow[1] = new ORowSetValueDecorator(OUString(""));
  96     // Schema
  97     aRow[2] = new ORowSetValueDecorator(OUString(""));
  98     // DATA_TYPE
  99     aRow[5] = new ORowSetValueDecorator(static_cast<sal_Int16>(DataType::VARCHAR));
 100     // TYPE_NAME, not used
 101     aRow[6] = new ORowSetValueDecorator(OUString("VARCHAR"));
 102     // COLUMN_SIZE
 103     aRow[7] = new ORowSetValueDecorator(s_nCOLUMN_SIZE);
 104     // BUFFER_LENGTH, not used
 105     aRow[8] = ODatabaseMetaDataResultSet::getEmptyValue();
 106     // DECIMAL_DIGITS.
 107     aRow[9] = new ORowSetValueDecorator(s_nDECIMAL_DIGITS);
 108     // NUM_PREC_RADIX
 109     aRow[10] = new ORowSetValueDecorator((sal_Int32)10);
 110     // NULLABLE
 111     aRow[11] = new ORowSetValueDecorator(s_nNULLABLE);
 112     // REMARKS
 113     aRow[12] = ODatabaseMetaDataResultSet::getEmptyValue();
 114     // COULUMN_DEF, not used
 115     aRow[13] = ODatabaseMetaDataResultSet::getEmptyValue();
 116     // SQL_DATA_TYPE, not used
 117     aRow[14] = ODatabaseMetaDataResultSet::getEmptyValue();
 118     // SQL_DATETIME_SUB, not used
 119     aRow[15] = ODatabaseMetaDataResultSet::getEmptyValue();
 120     // CHAR_OCTET_LENGTH, refer to [5]
 121     aRow[16] = new ORowSetValueDecorator(s_nCHAR_OCTET_LENGTH);
 122     // IS_NULLABLE
 123     aRow[18] = new ORowSetValueDecorator(OUString("YES"));
 124
 125     const OColumnAlias& colNames = m_pConnection->getColumnAlias();
 126
 127     // Iterate over all tables
 128     for(size_t j = 0; j < tables.size(); j++ ) {
 129         if(match(tableNamePattern, tables[j],'\0')) {
 130             // TABLE_NAME
 131             aRow[3] = new ORowSetValueDecorator( tables[j] );
 132
 133             OSL_TRACE( "\t\tTableName = %s;",OUtoCStr( tables[j] ));
 134
 135             // Iterate over all collumns in the table.
 136             for (   OColumnAlias::AliasMap::const_iterator compare = colNames.begin();
 137                     compare != colNames.end();
 138                     ++compare
 139                 )
 140             {
 141                 if ( match( columnNamePattern, compare->first, '\0' ) )
 142                 {
 143                     OSL_TRACE( "\t\t\tColumnName = %s;", OUtoCStr( compare->first ) );
 144                     // COLUMN_NAME
 145                     aRow[4] = new ORowSetValueDecorator( compare->first );
 146                     // ORDINAL_POSITION
 147                     aRow[17] = new ORowSetValueDecorator( static_cast< sal_Int32 >( compare->second.columnPosition ) + 1 );
 148                     aRows.push_back(aRow);
 149                 }
 150             }
 151         }
 152     }
 153     return aRows;
 154 }
 155
 156 OUString ODatabaseMetaData::impl_getCatalogSeparator_throw(  )
 157 {
 158     return OUString();
 159 }
 160
 161 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxBinaryLiteralLength(  ) throw(SQLException, RuntimeException)
 162 {
 163     sal_Int32 nValue = 65535; // 0 means no limit
 164     return nValue;
 165 }
 166
 167 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxRowSize(  ) throw(SQLException, RuntimeException)
 168 {
 169     sal_Int32 nValue = 0; // 0 means no limit
 170     return nValue;
 171 }
 172
 173 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCatalogNameLength(  ) throw(SQLException, RuntimeException)
 174 {
 175     sal_Int32 nValue = 0; // 0 means no limit
 176     return nValue;
 177 }
 178
 179 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCharLiteralLength(  ) throw(SQLException, RuntimeException)
 180 {
 181     sal_Int32 nValue = 254; // 0 means no limit
 182     return nValue;
 183 }
 184
 185 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnNameLength(  ) throw(SQLException, RuntimeException)
 186 {
 187     sal_Int32 nValue = 20; // 0 means no limit
 188     return nValue;
 189 }
 190
 191 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInIndex(  ) throw(SQLException, RuntimeException)
 192 {
 193     sal_Int32 nValue = 0; // 0 means no limit
 194     return nValue;
 195 }
 196
 197 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCursorNameLength(  ) throw(SQLException, RuntimeException)
 198 {
 199     sal_Int32 nValue = 0; // 0 means no limit
 200     return nValue;
 201 }
 202
 203 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxConnections(  ) throw(SQLException, RuntimeException)
 204 {
 205     sal_Int32 nValue = 0; // 0 means no limit
 206     return nValue;
 207 }
 208
 209 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInTable(  ) throw(SQLException, RuntimeException)
 210 {
 211     sal_Int32 nValue = 0; // 0 means no limit
 212     return nValue;
 213 }
 214
 215 sal_Int32 ODatabaseMetaData::impl_getMaxStatements_throw(  )
 216 {
 217     return 0;
 218 }
 219
 220 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxTableNameLength(  ) throw(SQLException, RuntimeException)
 221 {
 222     sal_Int32 nValue = 0; // 0 means no limit
 223     return nValue;
 224 }
 225
 226 sal_Int32 ODatabaseMetaData::impl_getMaxTablesInSelect_throw(  )
 227 {
 228     // We only support a single table
 229     return 1;
 230 }
 231
 232
 233 sal_Bool SAL_CALL ODatabaseMetaData::doesMaxRowSizeIncludeBlobs(  ) throw(SQLException, RuntimeException)
 234 {
 235     return sal_False;
 236 }
 237
 238 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseQuotedIdentifiers(  ) throw(SQLException, RuntimeException)
 239 {
 240     return sal_False;
 241 }
 242
 243 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 244 {
 245     return sal_False;
 246 }
 247
 248 bool ODatabaseMetaData::impl_storesMixedCaseQuotedIdentifiers_throw(  )
 249 {
 250     return false;
 251 }
 252
 253 sal_Bool SAL_CALL ODatabaseMetaData::storesMixedCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 254 {
 255     return sal_False;
 256 }
 257
 258 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseQuotedIdentifiers(  ) throw(SQLException, RuntimeException)
 259 {
 260     return sal_False;
 261 }
 262
 263 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 264 {
 265     return sal_False;
 266 }
 267
 268 bool ODatabaseMetaData::impl_supportsAlterTableWithAddColumn_throw(  )
 269 {
 270     return false;
 271 }
 272
 273 bool ODatabaseMetaData::impl_supportsAlterTableWithDropColumn_throw(  )
 274 {
 275     return false;
 276 }
 277
 278 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxIndexLength(  ) throw(SQLException, RuntimeException)
 279 {
 280     sal_Int32 nValue = 0; // 0 means no limit
 281     return nValue;
 282 }
 283
 284 sal_Bool SAL_CALL ODatabaseMetaData::supportsNonNullableColumns(  ) throw(SQLException, RuntimeException)
 285 {
 286     return sal_False;
 287 }
 288
 289 OUString SAL_CALL ODatabaseMetaData::getCatalogTerm(  ) throw(SQLException, RuntimeException)
 290 {
 291     OUString aVal;
 292     return aVal;
 293 }
 294
 295 OUString ODatabaseMetaData::impl_getIdentifierQuoteString_throw(  )
 296 {
 297     // normally this is "
 298     return OUString("\"");
 299 }
 300
 301 OUString SAL_CALL ODatabaseMetaData::getExtraNameCharacters(  ) throw(SQLException, RuntimeException)
 302 {
 303     OUString aVal;
 304     return aVal;
 305 }
 306
 307 sal_Bool SAL_CALL ODatabaseMetaData::supportsDifferentTableCorrelationNames(  ) throw(SQLException, RuntimeException)
 308 {
 309     return sal_True;
 310 }
 311
 312 bool ODatabaseMetaData::impl_isCatalogAtStart_throw(  )
 313 {
 314     return true;
 315 }
 316
 317 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionIgnoredInTransactions(  ) throw(SQLException, RuntimeException)
 318 {
 319     return sal_True;
 320 }
 321
 322 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionCausesTransactionCommit(  ) throw(SQLException, RuntimeException)
 323 {
 324     return sal_True;
 325 }
 326
 327 sal_Bool SAL_CALL ODatabaseMetaData::supportsDataManipulationTransactionsOnly(  ) throw(SQLException, RuntimeException)
 328 {
 329     //We support create table
 330     return sal_False;
 331 }
 332
 333 sal_Bool SAL_CALL ODatabaseMetaData::supportsDataDefinitionAndDataManipulationTransactions(  ) throw(SQLException, RuntimeException)
 334 {
 335     return sal_False;
 336 }
 337
 338 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedDelete(  ) throw(SQLException, RuntimeException)
 339 {
 340     return sal_False;
 341 }
 342
 343 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedUpdate(  ) throw(SQLException, RuntimeException)
 344 {
 345     return sal_False;
 346 }
 347
 348 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossRollback(  ) throw(SQLException, RuntimeException)
 349 {
 350     return sal_False;
 351 }
 352
 353 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossCommit(  ) throw(SQLException, RuntimeException)
 354 {
 355     return sal_False;
 356 }
 357
 358 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossCommit(  ) throw(SQLException, RuntimeException)
 359 {
 360     return sal_False;
 361 }
 362
 363 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossRollback(  ) throw(SQLException, RuntimeException)
 364 {
 365     return sal_False;
 366 }
 367
 368 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactionIsolationLevel( sal_Int32 /*level*/ ) throw(SQLException, RuntimeException)
 369 {
 370     return sal_False;
 371 }
 372
 373 bool ODatabaseMetaData::impl_supportsSchemasInDataManipulation_throw(  )
 374 {
 375     return false;
 376 }
 377
 378 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92FullSQL(  ) throw(SQLException, RuntimeException)
 379 {
 380     return sal_False;
 381 }
 382
 383 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92EntryLevelSQL(  ) throw(SQLException, RuntimeException)
 384 {
 385     return sal_True; // should be supported at least
 386 }
 387
 388 sal_Bool SAL_CALL ODatabaseMetaData::supportsIntegrityEnhancementFacility(  ) throw(SQLException, RuntimeException)
 389 {
 390     return sal_False;
 391 }
 392
 393 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInIndexDefinitions(  ) throw(SQLException, RuntimeException)
 394 {
 395     return sal_False;
 396 }
 397
 398 bool ODatabaseMetaData::impl_supportsSchemasInTableDefinitions_throw(  )
 399 {
 400     return false;
 401 }
 402
 403 bool ODatabaseMetaData::impl_supportsCatalogsInTableDefinitions_throw(  )
 404 {
 405     return false;
 406 }
 407
 408 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInIndexDefinitions(  ) throw(SQLException, RuntimeException)
 409 {
 410     return sal_False;
 411 }
 412
 413 bool ODatabaseMetaData::impl_supportsCatalogsInDataManipulation_throw(  )
 414 {
 415     return false;
 416 }
 417
 418 sal_Bool SAL_CALL ODatabaseMetaData::supportsOuterJoins(  ) throw(SQLException, RuntimeException)
 419 {
 420     return sal_False;
 421 }
 422
 423 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxStatementLength(  ) throw(SQLException, RuntimeException)
 424 {
 425     return 0;// 0 means no limit
 426 }
 427
 428 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxProcedureNameLength(  ) throw(SQLException, RuntimeException)
 429 {
 430     sal_Int32 nValue = 0; // 0 means no limit
 431     return nValue;
 432 }
 433
 434 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxSchemaNameLength(  ) throw(SQLException, RuntimeException)
 435 {
 436     sal_Int32 nValue = 0; // 0 means no limit
 437     return nValue;
 438 }
 439
 440 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactions(  ) throw(SQLException, RuntimeException)
 441 {
 442     return sal_False;
 443 }
 444
 445 sal_Bool SAL_CALL ODatabaseMetaData::allProceduresAreCallable(  ) throw(SQLException, RuntimeException)
 446 {
 447     return sal_False;
 448 }
 449
 450 sal_Bool SAL_CALL ODatabaseMetaData::supportsStoredProcedures(  ) throw(SQLException, RuntimeException)
 451 {
 452     return sal_False;
 453 }
 454
 455 sal_Bool SAL_CALL ODatabaseMetaData::supportsSelectForUpdate(  ) throw(SQLException, RuntimeException)
 456 {
 457     return sal_False;
 458 }
 459
 460 sal_Bool SAL_CALL ODatabaseMetaData::allTablesAreSelectable(  ) throw(SQLException, RuntimeException)
 461 {
 462     // We allow you to select from any table.
 463     return sal_True;
 464 }
 465
 466 sal_Bool SAL_CALL ODatabaseMetaData::isReadOnly(  ) throw(SQLException, RuntimeException)
 467 {
 468     //we support insert/update/delete now
 469     //But we have to set this to return sal_True otherwise the UI will add create "table/edit table"
 470     //entry to the popup menu. We should avoid them.
 471     return sal_True;
 472 }
 473
 474 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFiles(  ) throw(SQLException, RuntimeException)
 475 {
 476     return sal_False;
 477 }
 478
 479 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFilePerTable(  ) throw(SQLException, RuntimeException)
 480 {
 481     return sal_False;
 482 }
 483
 484 sal_Bool SAL_CALL ODatabaseMetaData::supportsTypeConversion(  ) throw(SQLException, RuntimeException)
 485 {
 486     return sal_False;
 487 }
 488
 489 sal_Bool SAL_CALL ODatabaseMetaData::nullPlusNonNullIsNull(  ) throw(SQLException, RuntimeException)
 490 {
 491     return sal_False;
 492 }
 493
 494 sal_Bool SAL_CALL ODatabaseMetaData::supportsColumnAliasing(  ) throw(SQLException, RuntimeException)
 495 {
 496     // Support added for this.
 497     return sal_True;
 498 }
 499
 500 sal_Bool SAL_CALL ODatabaseMetaData::supportsTableCorrelationNames(  ) throw(SQLException, RuntimeException)
 501 {
 502     return sal_False;
 503 }
 504
 505 sal_Bool SAL_CALL ODatabaseMetaData::supportsConvert( sal_Int32 /*fromType*/, sal_Int32 /*toType*/ ) throw(SQLException, RuntimeException)
 506 {
 507     return sal_False;
 508 }
 509
 510 sal_Bool SAL_CALL ODatabaseMetaData::supportsExpressionsInOrderBy(  ) throw(SQLException, RuntimeException)
 511 {
 512     return sal_False;
 513 }
 514
 515 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupBy(  ) throw(SQLException, RuntimeException)
 516 {
 517     return sal_False;
 518 }
 519
 520 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByBeyondSelect(  ) throw(SQLException, RuntimeException)
 521 {
 522     return sal_False;
 523 }
 524
 525 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByUnrelated(  ) throw(SQLException, RuntimeException)
 526 {
 527     return sal_False;
 528 }
 529
 530 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleTransactions(  ) throw(SQLException, RuntimeException)
 531 {
 532     return sal_False;
 533 }
 534
 535 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleResultSets(  ) throw(SQLException, RuntimeException)
 536 {
 537     return sal_False;
 538 }
 539
 540 sal_Bool SAL_CALL ODatabaseMetaData::supportsLikeEscapeClause(  ) throw(SQLException, RuntimeException)
 541 {
 542     return sal_False;
 543 }
 544
 545 sal_Bool SAL_CALL ODatabaseMetaData::supportsOrderByUnrelated(  ) throw(SQLException, RuntimeException)
 546 {
 547     return sal_False;
 548 }
 549
 550 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnion(  ) throw(SQLException, RuntimeException)
 551 {
 552     return sal_False;
 553 }
 554
 555 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnionAll(  ) throw(SQLException, RuntimeException)
 556 {
 557     return sal_False;
 558 }
 559
 560 sal_Bool SAL_CALL ODatabaseMetaData::supportsMixedCaseIdentifiers(  ) throw(SQLException, RuntimeException)
 561 {
 562     return sal_True;
 563 }
 564
 565 bool ODatabaseMetaData::impl_supportsMixedCaseQuotedIdentifiers_throw(  )
 566 {
 567     // Any case may be used
 568     return true;
 569 }
 570
 571 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtEnd(  ) throw(SQLException, RuntimeException)
 572 {
 573     return sal_False;
 574 }
 575
 576 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtStart(  ) throw(SQLException, RuntimeException)
 577 {
 578     return sal_True;
 579 }
 580
 581 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedHigh(  ) throw(SQLException, RuntimeException)
 582 {
 583     return sal_False;
 584 }
 585
 586 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedLow(  ) throw(SQLException, RuntimeException)
 587 {
 588     return sal_True;
 589 }
 590
 591 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInProcedureCalls(  ) throw(SQLException, RuntimeException)
 592 {
 593     return sal_False;
 594 }
 595
 596 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInPrivilegeDefinitions(  ) throw(SQLException, RuntimeException)
 597 {
 598     return sal_False;
 599 }
 600
 601 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInProcedureCalls(  ) throw(SQLException, RuntimeException)
 602 {
 603     return sal_False;
 604 }
 605
 606 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInPrivilegeDefinitions(  ) throw(SQLException, RuntimeException)
 607 {
 608     return sal_False;
 609 }
 610
 611 sal_Bool SAL_CALL ODatabaseMetaData::supportsCorrelatedSubqueries(  ) throw(SQLException, RuntimeException)
 612 {
 613     return sal_False;
 614 }
 615
 616 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInComparisons(  ) throw(SQLException, RuntimeException)
 617 {
 618     return sal_False;
 619 }
 620
 621 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInExists(  ) throw(SQLException, RuntimeException)
 622 {
 623     return sal_False;
 624 }
 625
 626 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInIns(  ) throw(SQLException, RuntimeException)
 627 {
 628     return sal_False;
 629 }
 630
 631 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInQuantifieds(  ) throw(SQLException, RuntimeException)
 632 {
 633     return sal_False;
 634 }
 635
 636 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92IntermediateSQL(  ) throw(SQLException, RuntimeException)
 637 {
 638     return sal_False;
 639 }
 640
 641 OUString SAL_CALL ODatabaseMetaData::getURL(  ) throw(SQLException, RuntimeException)
 642 {
 643     ::osl::MutexGuard aGuard( m_aMutex );
 644
 645     return m_pConnection->getURL();
 646 }
 647
 648 OUString SAL_CALL ODatabaseMetaData::getUserName(  ) throw(SQLException, RuntimeException)
 649 {
 650     OUString aValue;
 651     return aValue;
 652 }
 653
 654 OUString SAL_CALL ODatabaseMetaData::getDriverName(  ) throw(SQLException, RuntimeException)
 655 {
 656     OUString aValue;
 657     return aValue;
 658 }
 659
 660 OUString SAL_CALL ODatabaseMetaData::getDriverVersion() throw(SQLException, RuntimeException)
 661 {
 662     return OUString( "1" );
 663 }
 664
 665 OUString SAL_CALL ODatabaseMetaData::getDatabaseProductVersion(  ) throw(SQLException, RuntimeException)
 666 {
 667     return OUString( "0" );
 668 }
 669
 670 OUString SAL_CALL ODatabaseMetaData::getDatabaseProductName(  ) throw(SQLException, RuntimeException)
 671 {
 672     OUString aValue;
 673     return aValue;
 674 }
 675
 676 OUString SAL_CALL ODatabaseMetaData::getProcedureTerm(  ) throw(SQLException, RuntimeException)
 677 {
 678     OUString aValue;
 679     return aValue;
 680 }
 681
 682 OUString SAL_CALL ODatabaseMetaData::getSchemaTerm(  ) throw(SQLException, RuntimeException)
 683 {
 684     OUString aValue;
 685     return aValue;
 686 }
 687
 688 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMajorVersion(  ) throw(RuntimeException)
 689 {
 690     return 1;
 691 }
 692
 693 sal_Int32 SAL_CALL ODatabaseMetaData::getDefaultTransactionIsolation(  ) throw(SQLException, RuntimeException)
 694 {
 695     return TransactionIsolation::NONE;
 696 }
 697
 698 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMinorVersion(  ) throw(RuntimeException)
 699 {
 700     return 0;
 701 }
 702
 703 OUString SAL_CALL ODatabaseMetaData::getSQLKeywords(  ) throw(SQLException, RuntimeException)
 704 {
 705     OUString aValue;
 706     return aValue;
 707 }
 708
 709 OUString SAL_CALL ODatabaseMetaData::getSearchStringEscape(  ) throw(SQLException, RuntimeException)
 710 {
 711     OUString aValue;
 712     return aValue;
 713 }
 714
 715 OUString SAL_CALL ODatabaseMetaData::getStringFunctions(  ) throw(SQLException, RuntimeException)
 716 {
 717     return OUString();
 718 }
 719
 720 OUString SAL_CALL ODatabaseMetaData::getTimeDateFunctions(  ) throw(SQLException, RuntimeException)
 721 {
 722     return OUString();
 723 }
 724
 725 OUString SAL_CALL ODatabaseMetaData::getSystemFunctions(  ) throw(SQLException, RuntimeException)
 726 {
 727     return OUString();
 728 }
 729
 730 OUString SAL_CALL ODatabaseMetaData::getNumericFunctions(  ) throw(SQLException, RuntimeException)
 731 {
 732     return OUString();
 733 }
 734
 735 sal_Bool SAL_CALL ODatabaseMetaData::supportsExtendedSQLGrammar(  ) throw(SQLException, RuntimeException)
 736 {
 737     return sal_False;
 738 }
 739
 740 sal_Bool SAL_CALL ODatabaseMetaData::supportsCoreSQLGrammar(  ) throw(SQLException, RuntimeException)
 741 {
 742     return sal_False;
 743 }
 744
 745 sal_Bool SAL_CALL ODatabaseMetaData::supportsMinimumSQLGrammar(  ) throw(SQLException, RuntimeException)
 746 {
 747     return sal_True;
 748 }
 749
 750 sal_Bool SAL_CALL ODatabaseMetaData::supportsFullOuterJoins(  ) throw(SQLException, RuntimeException)
 751 {
 752     return sal_False;
 753 }
 754
 755 sal_Bool SAL_CALL ODatabaseMetaData::supportsLimitedOuterJoins(  ) throw(SQLException, RuntimeException)
 756 {
 757     return sal_False;
 758 }
 759
 760 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInGroupBy(  ) throw(SQLException, RuntimeException)
 761 {
 762     sal_Int32 nValue = 0; // 0 means no limit
 763     return nValue;
 764 }
 765
 766 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInOrderBy(  ) throw(SQLException, RuntimeException)
 767 {
 768     sal_Int32 nValue = 0; // 0 means no limit
 769     return nValue;
 770 }
 771
 772 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInSelect(  ) throw(SQLException, RuntimeException)
 773 {
 774     sal_Int32 nValue = 0; // 0 means no limit
 775     return nValue;
 776 }
 777
 778 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxUserNameLength(  ) throw(SQLException, RuntimeException)
 779 {
 780     sal_Int32 nValue = 0; // 0 means no limit
 781     return nValue;
 782 }
 783
 784 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetType( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 785 {
 786     return sal_False;
 787 }
 788
 789 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetConcurrency( sal_Int32 /*setType*/, sal_Int32 /*concurrency*/ ) throw(SQLException, RuntimeException)
 790 {
 791     return sal_False;
 792 }
 793
 794 sal_Bool SAL_CALL ODatabaseMetaData::ownUpdatesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 795 {
 796     return sal_True;
 797 }
 798
 799 sal_Bool SAL_CALL ODatabaseMetaData::ownDeletesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 800 {
 801     return sal_True;
 802 }
 803
 804 sal_Bool SAL_CALL ODatabaseMetaData::ownInsertsAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 805 {
 806     return sal_True;
 807 }
 808
 809 sal_Bool SAL_CALL ODatabaseMetaData::othersUpdatesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 810 {
 811     return sal_False;
 812 }
 813
 814 sal_Bool SAL_CALL ODatabaseMetaData::othersDeletesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 815 {
 816     return sal_False;
 817 }
 818
 819 sal_Bool SAL_CALL ODatabaseMetaData::othersInsertsAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 820 {
 821     return sal_False;
 822 }
 823
 824 sal_Bool SAL_CALL ODatabaseMetaData::updatesAreDetected( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 825 {
 826     return sal_True;
 827 }
 828
 829 sal_Bool SAL_CALL ODatabaseMetaData::deletesAreDetected( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 830 {
 831     return sal_True;
 832 }
 833
 834 sal_Bool SAL_CALL ODatabaseMetaData::insertsAreDetected( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException)
 835 {
 836     return sal_True;
 837 }
 838
 839 sal_Bool SAL_CALL ODatabaseMetaData::supportsBatchUpdates(  ) throw(SQLException, RuntimeException)
 840 {
 841     return sal_False;
 842 }
 843
 844 // here follow all methods which return a resultset
 845 // the first methods is an example implementation how to use this resultset
 846 // of course you could implement it on your and you should do this because
 847 // the general way is more memory expensive
 848
 849 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTableTypes(  ) throw(SQLException, RuntimeException)
 850 {
 851     // there exists no possibility to get table types so we have to check
 852     static OUString sTableTypes[] =
 853     {
 854         OUString("TABLE"),
 855         OUString("VIEW")
 856         // Currently we only support a 'TABLE' and 'VIEW' nothing more complex
 857         //
 858         // OUString("SYSTEM TABLE"),
 859         // OUString("GLOBAL TEMPORARY"),
 860         // OUString("LOCAL TEMPORARY"),
 861         // OUString("ALIAS"),
 862         // OUString("SYNONYM")
 863     };
 864     ::connectivity::ODatabaseMetaDataResultSet* pResult = new ::connectivity::ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTableTypes);
 865     Reference< XResultSet > xRef = pResult;
 866
 867     // here we fill the rows which should be visible when ask for data from the resultset returned here
 868     const sal_Int32  nSize = sizeof(sTableTypes) / sizeof(OUString);
 869     ODatabaseMetaDataResultSet::ORows aRows;
 870     for(sal_Int32 i=0;i < nSize;++i)
 871     {
 872         ODatabaseMetaDataResultSet::ORow aRow;
 873         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 874         aRow.push_back(new ORowSetValueDecorator(sTableTypes[i]));
 875         // bound row
 876         aRows.push_back(aRow);
 877     }
 878     // here we set the rows at the resultset
 879     pResult->setRows(aRows);
 880     return xRef;
 881 }
 882
 883 Reference< XResultSet > ODatabaseMetaData::impl_getTypeInfo_throw(  )
 884 {
 885     // this returns an empty resultset where the column-names are already set
 886     // in special the metadata of the resultset already returns the right columns
 887     ODatabaseMetaDataResultSet* pResultSet = new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTypeInfo);
 888     Reference< XResultSet > xResultSet = pResultSet;
 889     static ODatabaseMetaDataResultSet::ORows aRows;
 890
 891     if(aRows.empty())
 892     {
 893         ODatabaseMetaDataResultSet::ORow aRow;
 894         aRow.reserve(19);
 895         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 896         aRow.push_back(new ORowSetValueDecorator(OUString("VARCHAR")));
 897         aRow.push_back(new ORowSetValueDecorator(DataType::VARCHAR));
 898         aRow.push_back(new ORowSetValueDecorator((sal_Int32)s_nCHAR_OCTET_LENGTH));
 899         aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue());
 900         aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue());
 901         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 902         // aRow.push_back(new ORowSetValueDecorator((sal_Int32)ColumnValue::NULLABLE));
 903         aRow.push_back(ODatabaseMetaDataResultSet::get1Value());
 904         aRow.push_back(ODatabaseMetaDataResultSet::get1Value());
 905         aRow.push_back(new ORowSetValueDecorator((sal_Int32)ColumnSearch::CHAR));
 906         aRow.push_back(ODatabaseMetaDataResultSet::get1Value());
 907         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
 908         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
 909         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 910         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
 911         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
 912         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 913         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 914         aRow.push_back(new ORowSetValueDecorator((sal_Int32)10));
 915
 916         aRows.push_back(aRow);
 917
 918     }
 919     pResultSet->setRows(aRows);
 920     return xResultSet;
 921 }
 922
 923 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getColumns(
 924     const Any& /*catalog*/, const OUString& /*schemaPattern*/, const OUString& tableNamePattern,
 925     const OUString& columnNamePattern ) throw(SQLException, RuntimeException)
 926 {
 927     // this returns an empty resultset where the column-names are already set
 928     // in special the metadata of the resultset already returns the right columns
 929     ODatabaseMetaDataResultSet* pResultSet = new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eColumns);
 930     Reference< XResultSet > xResultSet = pResultSet;
 931     pResultSet->setRows( getColumnRows( tableNamePattern, columnNamePattern ));
 932     return xResultSet;
 933 }
 934
 935 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTables(
 936     const Any& /*catalog*/, const OUString& /*schemaPattern*/,
 937     const OUString& tableNamePattern, const Sequence< OUString >& types ) throw(SQLException, RuntimeException)
 938 {
 939     // this returns an empty resultset where the column-names are already set
 940     // in special the metadata of the resultset already returns the right columns
 941     ODatabaseMetaDataResultSet* pResultSet = new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTables);
 942     Reference< XResultSet > xResultSet = pResultSet;
 943
 944     // ODatabaseMetaDataResultSet::ORows aRows;
 945     // aRows = m_pDbMetaDataHelper->getTables( m_pConnection, tableNamePattern );
 946     // pResultSet->setRows( aRows );
 947     ODatabaseMetaDataResultSet::ORows _rRows;
 948     if ( !m_pDbMetaDataHelper->getTables( m_pConnection, tableNamePattern, types,_rRows ) ) {
 949         getOwnConnection()->throwSQLException( m_pDbMetaDataHelper->getError(), *this );
 950     }
 951     pResultSet->setRows( _rRows );
 952
 953     return xResultSet;
 954 }
 955
 956 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTablePrivileges(
 957     const Any& /*catalog*/, const OUString& /*schemaPattern*/, const OUString& tableNamePattern ) throw(SQLException, RuntimeException)
 958 {
 959     ::connectivity::ODatabaseMetaDataResultSet* pResult = new ::connectivity::ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTablePrivileges);
 960
 961     Reference< XResultSet > xRef = pResult;
 962
 963     ::std::vector< OUString > tables;
 964     ::std::vector< OUString > types;
 965     if ( !m_pDbMetaDataHelper->getTableStrings( m_pConnection, tables, types ) )
 966         getOwnConnection()->throwSQLException( m_pDbMetaDataHelper->getError(), *this );
 967
 968     ::connectivity::ODatabaseMetaDataResultSet::ORows aRows;
 969     ::connectivity::ODatabaseMetaDataResultSet::ORow aRow(8);
 970     aRows.reserve(8);
 971     aRow[0] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 972     aRow[1] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 973     aRow[3] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 974     aRow[4] = ::connectivity::ODatabaseMetaDataResultSet::getEmptyValue();
 975     aRow[5] = new ::connectivity::ORowSetValueDecorator(getUserName());
 976     aRow[7] = new ::connectivity::ORowSetValueDecorator(OUString("NO"));
 977
 978
 979     // Iterate over all tables
 980     for(size_t j = 0; j < tables.size(); j++ ) {
 981        if(match(tableNamePattern, tables[j],'\0'))
 982            {
 983             // TABLE_NAME
 984             aRow[2] = new ORowSetValueDecorator( tables[j] );
 985
 986             OSL_TRACE( "\t\tTableName = %s;",OUtoCStr( tables[j] ));
 987
 988                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getSelectValue();
 989                 aRows.push_back(aRow);
 990                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getInsertValue();
 991                 aRows.push_back(aRow);
 992                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getDeleteValue();
 993                 aRows.push_back(aRow);
 994                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getUpdateValue();
 995                 aRows.push_back(aRow);
 996                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getCreateValue();
 997                 aRows.push_back(aRow);
 998                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getReadValue();
 999                 aRows.push_back(aRow);
1000                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getAlterValue();
1001                 aRows.push_back(aRow);
1002                 aRow[6] = ::connectivity::ODatabaseMetaDataResultSet::getDropValue();
1003                 aRows.push_back(aRow);
1004         }
1005     }
1006     pResult->setRows(aRows);
1007     return xRef;
1008
1009 }
1010
1011 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getUDTs( const Any& /*catalog*/, const OUString& /*schemaPattern*/, const OUString& /*typeNamePattern*/, const Sequence< sal_Int32 >& /*types*/ ) throw(SQLException, RuntimeException)
1012 {
1013     return NULL;
1014 }
1015
1016
1017
1018
1019 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */