connectivity/source/drivers/file/FDatabaseMetaData.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 "file/FDatabaseMetaData.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/ucb/SearchRecursion.hpp>
  26 #include <com/sun/star/ucb/SearchCommandArgument.hpp>
  27 #include <com/sun/star/ucb/UniversalContentBroker.hpp>
  28 #include <com/sun/star/ucb/SortedDynamicResultSetFactory.hpp>
  29 #include <com/sun/star/lang/XUnoTunnel.hpp>
  30 #include <tools/urlobj.hxx>
  31 #include "file/FDriver.hxx"
  32 #include "file/FTable.hxx"
  33 #include <comphelper/processfactory.hxx>
  34 #include <tools/debug.hxx>
  35 #include <ucbhelper/content.hxx>
  36
  37 using namespace com::sun::star::ucb;
  38 using namespace connectivity::file;
  39 using namespace connectivity;
  40 using namespace com::sun::star::uno;
  41 using namespace com::sun::star::lang;
  42 using namespace com::sun::star::beans;
  43 using namespace com::sun::star::sdbc;
  44 using namespace com::sun::star::sdbcx;
  45 using namespace com::sun::star::container;
  46
  47 ODatabaseMetaData::ODatabaseMetaData(OConnection* _pCon) : ::connectivity::ODatabaseMetaDataBase(_pCon,_pCon->getConnectionInfo())
  48                         ,m_pConnection(_pCon)
  49 {
  50 }
  51
  52 ODatabaseMetaData::~ODatabaseMetaData()
  53 {
  54 }
  55
  56 Reference< XResultSet > ODatabaseMetaData::impl_getTypeInfo_throw(  )
  57 {
  58     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eTypeInfo );
  59 }
  60
  61 OUString ODatabaseMetaData::impl_getCatalogSeparator_throw(  )
  62 {
  63     return OUString();
  64 }
  65
  66 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getColumns(
  67         const Any& /*catalog*/, const OUString& /*schemaPattern*/, const OUString& /*tableNamePattern*/,
  68         const OUString& /*columnNamePattern*/ ) throw(SQLException, RuntimeException, std::exception)
  69 {
  70     SAL_WARN( "connectivity.drivers","Should be overloaded!");
  71     return new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eColumns );
  72 }
  73
  74
  75 namespace
  76 {
  77     sal_Int16 isCaseSensitiveParentFolder( const OUString& _rFolderOrDoc, const OUString& _rDocName )
  78     {
  79         sal_Int16 nIsCS = 1;
  80         try
  81         {
  82             // first get the real content for the URL
  83             INetURLObject aContentURL( _rFolderOrDoc );
  84             ::ucbhelper::Content aContent1;
  85             {
  86                 ::ucbhelper::Content aFolderOrDoc( _rFolderOrDoc, Reference< XCommandEnvironment >(), comphelper::getProcessComponentContext() );
  87                 if ( aFolderOrDoc.isDocument() )
  88                     aContent1 = aFolderOrDoc;
  89                 else
  90                 {
  91                     aContentURL = INetURLObject( _rFolderOrDoc, INetURLObject::WAS_ENCODED );
  92                     aContentURL.Append( _rDocName );
  93                     aContent1 = ::ucbhelper::Content( aContentURL.GetMainURL( INetURLObject::NO_DECODE ), Reference< XCommandEnvironment >(), comphelper::getProcessComponentContext() );
  94                 }
  95             }
  96
  97             // get two extensions which differ by case only
  98             OUString sExtension1(aContentURL.getExtension());
  99             OUString sExtension2(sExtension1.toAsciiLowerCase());
 100             if (sExtension2 == sExtension1)
 101             {
 102                 // the extension was already in lower case
 103                 sExtension2 = sExtension2.toAsciiUpperCase();
 104             }
 105
 106             // the complete URL for the second extension
 107             INetURLObject aURL2( aContentURL );
 108             if (!sExtension2.isEmpty())
 109                 aURL2.SetExtension( sExtension2 );
 110             if ( aURL2.GetMainURL(INetURLObject::NO_DECODE) == aContentURL.GetMainURL(INetURLObject::NO_DECODE) )
 111                 return -1;
 112
 113             // the second context
 114             bool bCanAccess = false;
 115             ::ucbhelper::Content aContent2;
 116             try
 117             {
 118                 aContent2 = ::ucbhelper::Content( aURL2.GetMainURL( INetURLObject::NO_DECODE ), Reference< XCommandEnvironment >(), comphelper::getProcessComponentContext() );
 119                 bCanAccess = aContent2.isDocument();
 120             }
 121             catch( const Exception& )
 122             {
 123             }
 124
 125             if ( bCanAccess )
 126             {
 127                 // here we have two contents whose URLs differ by case only.
 128                 // Now let's check if both really refer to the same object ....
 129                 Reference< XContent > xContent1 = aContent1.get();
 130                 Reference< XContent > xContent2 = aContent2.get();
 131                 OSL_ENSURE( xContent1.is() && xContent2.is(), "isCaseSensitiveParentFolder: invalid content interfaces!" );
 132                 if ( xContent1.is() && xContent2.is() )
 133                 {
 134                     Reference< XContentIdentifier > xID1 = xContent1->getIdentifier();
 135                     Reference< XContentIdentifier > xID2 = xContent2->getIdentifier();
 136                     OSL_ENSURE( xID1.is() && xID2.is(), "isCaseSensitiveParentFolder: invalid ID interfaces!" );
 137                     if ( xID1.is() && xID2.is()
 138                          && ( UniversalContentBroker::create(
 139                                   comphelper::getProcessComponentContext() )->
 140                               compareContentIds( xID1, xID2 ) == 0 ) )
 141                     {
 142                         // finally, we know that the folder is not case-sensitive ....
 143                         nIsCS = 0;
 144                     }
 145                 }
 146             }
 147         }
 148         catch( const Exception& )
 149         {
 150             SAL_WARN( "connectivity.drivers", "isCaseSensitiveParentFolder: caught an unexpected exception!" );
 151         }
 152
 153         return nIsCS;
 154     }
 155 }
 156
 157
 158 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTables(
 159         const Any& /*catalog*/, const OUString& /*schemaPattern*/,
 160         const OUString& tableNamePattern, const Sequence< OUString >& types ) throw(SQLException, RuntimeException, std::exception)
 161 {
 162     ::osl::MutexGuard aGuard( m_aMutex );
 163
 164
 165     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eTables );
 166     Reference< XResultSet > xRef = pResult;
 167
 168     // check if any type is given
 169     // when no types are given then we have to return all tables e.g. TABLE
 170
 171     static const OUString aTable("TABLE");
 172
 173     bool bTableFound = true;
 174     sal_Int32 nLength = types.getLength();
 175     if(nLength)
 176     {
 177         bTableFound = false;
 178
 179         const OUString* pBegin = types.getConstArray();
 180         const OUString* pEnd = pBegin + nLength;
 181         for(;pBegin != pEnd;++pBegin)
 182         {
 183             if(*pBegin == aTable)
 184             {
 185                 bTableFound = true;
 186                 break;
 187             }
 188         }
 189     }
 190     if(!bTableFound)
 191         return xRef;
 192
 193     Reference<XDynamicResultSet> xContent = m_pConnection->getDir();
 194     Reference < XSortedDynamicResultSetFactory > xSRSFac =
 195                 SortedDynamicResultSetFactory::create( m_pConnection->getDriver()->getComponentContext() );
 196
 197     Sequence< NumberedSortingInfo > aSortInfo( 1 );
 198     NumberedSortingInfo* pInfo = aSortInfo.getArray();
 199     pInfo[ 0 ].ColumnIndex = 1;
 200     pInfo[ 0 ].Ascending   = sal_True;
 201
 202     Reference < XAnyCompareFactory > xFactory;
 203     Reference< XDynamicResultSet > xDynamicResultSet;
 204     xDynamicResultSet = xSRSFac->createSortedDynamicResultSet( xContent, aSortInfo, xFactory );
 205     Reference<XResultSet> xResultSet = xDynamicResultSet->getStaticResultSet();
 206
 207     Reference<XRow> xRow(xResultSet,UNO_QUERY);
 208
 209     OUString aFilenameExtension = m_pConnection->getExtension();
 210     OUString sThisContentExtension;
 211     ODatabaseMetaDataResultSet::ORows aRows;
 212     // scan the directory for tables
 213     OUString aName;
 214     INetURLObject aURL;
 215     xResultSet->beforeFirst();
 216
 217     bool bKnowCaseSensivity = false;
 218     bool bCaseSensitiveDir = true;
 219     bool bCheckEnabled = m_pConnection->isCheckEnabled();
 220
 221     while(xResultSet->next())
 222     {
 223         aName = xRow->getString(1);
 224         aURL.SetSmartProtocol(INET_PROT_FILE);
 225         OUString sUrl = m_pConnection->getURL() + "/" + aName;
 226         aURL.SetSmartURL( sUrl );
 227         sThisContentExtension = aURL.getExtension();
 228
 229         ODatabaseMetaDataResultSet::ORow aRow(3);
 230         aRow.reserve(6);
 231         bool bNewRow = false;
 232
 233         if ( !bKnowCaseSensivity )
 234         {
 235             bKnowCaseSensivity = true;
 236             sal_Int16 nCase = isCaseSensitiveParentFolder( m_pConnection->getURL(), aURL.getName() );
 237             switch( nCase )
 238             {
 239             case 1:
 240                 bCaseSensitiveDir = true;
 241                 break;
 242             case -1:
 243                 bKnowCaseSensivity = false;
 244                 /** run through */
 245             case 0:
 246                 bCaseSensitiveDir = false;
 247             }
 248             if ( bKnowCaseSensivity )
 249             {
 250                 m_pConnection->setCaseSensitiveExtension( bCaseSensitiveDir, OConnection::GrantAccess() );
 251                 if ( !bCaseSensitiveDir )
 252                 {
 253                     aFilenameExtension = aFilenameExtension.toAsciiLowerCase();
 254                 }
 255             }
 256         }
 257
 258         if (!aFilenameExtension.isEmpty())
 259         {
 260             if ( !bCaseSensitiveDir )
 261             {
 262                 sThisContentExtension = sThisContentExtension.toAsciiLowerCase();
 263             }
 264
 265             if ( sThisContentExtension == aFilenameExtension )
 266             {
 267                 aName = aName.copy(0, (aName.getLength()-(aFilenameExtension.getLength()+1)));
 268                 sal_Unicode nChar = aName.toChar();
 269                 if ( match(tableNamePattern,aName,'\0') && ( !bCheckEnabled || ( bCheckEnabled && ((nChar < '0' || nChar > '9')))) )
 270                 {
 271                     aRow.push_back(new ORowSetValueDecorator(aName));
 272                     bNewRow = true;
 273                 }
 274             }
 275         }
 276         else // no extension, filter myself
 277         {
 278             bool bErg = false;
 279             do
 280             {
 281                 if (aURL.getExtension().isEmpty())
 282                 {
 283                     sal_Unicode nChar = aURL.getBase()[0];
 284                     if(match(tableNamePattern,aURL.getBase(),'\0') && ( !bCheckEnabled || ( bCheckEnabled && ((nChar < '0' || nChar > '9')))) )
 285                     {
 286                         aRow.push_back(new ORowSetValueDecorator(OUString(aURL.getBase())));
 287                         bNewRow = true;
 288                     }
 289                     break;
 290                 }
 291                 else if ( ( bErg = xResultSet->next() ) )
 292                 {
 293                     aName = xRow->getString(1);
 294                     aURL.SetSmartURL(aName);
 295                 }
 296             } while (bErg);
 297         }
 298         if(bNewRow)
 299         {
 300             aRow.push_back(new ORowSetValueDecorator(aTable));
 301             aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 302
 303             aRows.push_back(aRow);
 304         }
 305     }
 306
 307     pResult->setRows(aRows);
 308
 309     return xRef;
 310 }
 311
 312 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxBinaryLiteralLength(  ) throw(SQLException, RuntimeException, std::exception)
 313 {
 314     return 0;
 315 }
 316
 317 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxRowSize(  ) throw(SQLException, RuntimeException, std::exception)
 318 {
 319     return 0;
 320 }
 321
 322 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCatalogNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 323 {
 324     return 0;
 325 }
 326
 327 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCharLiteralLength(  ) throw(SQLException, RuntimeException, std::exception)
 328 {
 329     return SAL_MAX_INT32;
 330 }
 331
 332 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 333 {
 334     return 0;
 335 }
 336
 337 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInIndex(  ) throw(SQLException, RuntimeException, std::exception)
 338 {
 339     return 0;
 340 }
 341
 342 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxCursorNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 343 {
 344     return 0;
 345 }
 346
 347 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxConnections(  ) throw(SQLException, RuntimeException, std::exception)
 348 {
 349     return 0;
 350 }
 351
 352 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInTable(  ) throw(SQLException, RuntimeException, std::exception)
 353 {
 354     return 0;
 355 }
 356
 357 sal_Int32 ODatabaseMetaData::impl_getMaxStatements_throw(  )
 358 {
 359     return 0;
 360 }
 361
 362 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxTableNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 363 {
 364     return 0;
 365 }
 366
 367 sal_Int32 ODatabaseMetaData::impl_getMaxTablesInSelect_throw(  )
 368 {
 369     return 1;
 370 }
 371
 372 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTablePrivileges(
 373         const Any& /*catalog*/, const OUString& /*schemaPattern*/, const OUString& tableNamePattern ) throw(SQLException, RuntimeException, std::exception)
 374 {
 375     ::osl::MutexGuard aGuard( m_aMutex );
 376
 377     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eTablePrivileges );
 378     Reference< XResultSet > xRef = pResult;
 379     ODatabaseMetaDataResultSet::ORows aRows;
 380
 381
 382     Reference< XTablesSupplier > xTabSup = m_pConnection->createCatalog();
 383     if( xTabSup.is())
 384     {
 385         Reference< XNameAccess> xNames      = xTabSup->getTables();
 386         Sequence< OUString > aNames  = xNames->getElementNames();
 387         const OUString* pBegin = aNames.getConstArray();
 388         const OUString* pEnd = pBegin + aNames.getLength();
 389         for(;pBegin != pEnd;++pBegin)
 390         {
 391             if(match(tableNamePattern,*pBegin,'\0'))
 392             {
 393                 static ODatabaseMetaDataResultSet::ORow aRow(8);
 394
 395                 aRow[2] = new ORowSetValueDecorator(*pBegin);
 396                 aRow[6] = ODatabaseMetaDataResultSet::getSelectValue();
 397                 aRow[7] = new ORowSetValueDecorator(OUString("NO"));
 398                 aRows.push_back(aRow);
 399
 400                 Reference< XPropertySet> xTable(
 401                     xNames->getByName(*pBegin), css::uno::UNO_QUERY);
 402                 if(xTable.is())
 403                 {
 404                     Reference<XUnoTunnel> xTunnel(xTable,UNO_QUERY);
 405                     if(xTunnel.is())
 406                     {
 407                         OFileTable* pTable = reinterpret_cast< OFileTable* >( xTunnel->getSomething(OFileTable::getUnoTunnelImplementationId()) );
 408                         if(pTable)
 409                         {
 410                             if(!pTable->isReadOnly())
 411                             {
 412                                 aRow[6] = ODatabaseMetaDataResultSet::getInsertValue();
 413                                 aRows.push_back(aRow);
 414                                 if(!m_pConnection->showDeleted())
 415                                 {
 416                                     aRow[6] = ODatabaseMetaDataResultSet::getDeleteValue();
 417                                     aRows.push_back(aRow);
 418                                 }
 419                                 aRow[6] = ODatabaseMetaDataResultSet::getUpdateValue();
 420                                 aRows.push_back(aRow);
 421                                 aRow[6] = ODatabaseMetaDataResultSet::getCreateValue();
 422                                 aRows.push_back(aRow);
 423                                 aRow[6] = ODatabaseMetaDataResultSet::getReadValue();
 424                                 aRows.push_back(aRow);
 425                                 aRow[6] = ODatabaseMetaDataResultSet::getAlterValue();
 426                                 aRows.push_back(aRow);
 427                                 aRow[6] = ODatabaseMetaDataResultSet::getDropValue();
 428                                 aRows.push_back(aRow);
 429                             }
 430                         }
 431                     }
 432                 }
 433             }
 434         }
 435     }
 436
 437     pResult->setRows(aRows);
 438     return xRef;
 439 }
 440
 441 sal_Bool SAL_CALL ODatabaseMetaData::doesMaxRowSizeIncludeBlobs(  ) throw(SQLException, RuntimeException, std::exception)
 442 {
 443     return sal_True;
 444 }
 445
 446 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseQuotedIdentifiers(  ) throw(SQLException, RuntimeException, std::exception)
 447 {
 448     return sal_False;
 449 }
 450
 451 sal_Bool SAL_CALL ODatabaseMetaData::storesLowerCaseIdentifiers(  ) throw(SQLException, RuntimeException, std::exception)
 452 {
 453     return sal_False;
 454 }
 455
 456 bool ODatabaseMetaData::impl_storesMixedCaseQuotedIdentifiers_throw(  )
 457 {
 458     return false;
 459 }
 460
 461 sal_Bool SAL_CALL ODatabaseMetaData::storesMixedCaseIdentifiers(  ) throw(SQLException, RuntimeException, std::exception)
 462 {
 463     return sal_False;
 464 }
 465
 466 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseQuotedIdentifiers(  ) throw(SQLException, RuntimeException, std::exception)
 467 {
 468     return sal_False;
 469 }
 470
 471 sal_Bool SAL_CALL ODatabaseMetaData::storesUpperCaseIdentifiers(  ) throw(SQLException, RuntimeException, std::exception)
 472 {
 473     return sal_False;
 474 }
 475
 476 bool ODatabaseMetaData::impl_supportsAlterTableWithAddColumn_throw(  )
 477 {
 478     return false;
 479 }
 480
 481 bool ODatabaseMetaData::impl_supportsAlterTableWithDropColumn_throw(  )
 482 {
 483     return false;
 484 }
 485
 486 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxIndexLength(  ) throw(SQLException, RuntimeException, std::exception)
 487 {
 488     return 0;
 489 }
 490
 491 sal_Bool SAL_CALL ODatabaseMetaData::supportsNonNullableColumns(  ) throw(SQLException, RuntimeException, std::exception)
 492 {
 493     return sal_False;
 494 }
 495
 496 OUString SAL_CALL ODatabaseMetaData::getCatalogTerm(  ) throw(SQLException, RuntimeException, std::exception)
 497 {
 498     return OUString();
 499 }
 500
 501 OUString ODatabaseMetaData::impl_getIdentifierQuoteString_throw(  )
 502 {
 503     static const OUString sQuote("\"");
 504     return sQuote;
 505 }
 506
 507 OUString SAL_CALL ODatabaseMetaData::getExtraNameCharacters(  ) throw(SQLException, RuntimeException, std::exception)
 508 {
 509     return OUString();
 510 }
 511
 512 sal_Bool SAL_CALL ODatabaseMetaData::supportsDifferentTableCorrelationNames(  ) throw(SQLException, RuntimeException, std::exception)
 513 {
 514     return sal_True;
 515 }
 516
 517 bool ODatabaseMetaData::impl_isCatalogAtStart_throw(  )
 518 {
 519     return true;
 520 }
 521
 522 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionIgnoredInTransactions(  ) throw(SQLException, RuntimeException, std::exception)
 523 {
 524     return sal_True;
 525 }
 526
 527 sal_Bool SAL_CALL ODatabaseMetaData::dataDefinitionCausesTransactionCommit(  ) throw(SQLException, RuntimeException, std::exception)
 528 {
 529     return sal_True;
 530 }
 531
 532 sal_Bool SAL_CALL ODatabaseMetaData::supportsDataManipulationTransactionsOnly(  ) throw(SQLException, RuntimeException, std::exception)
 533 {
 534     return sal_False;
 535 }
 536
 537 sal_Bool SAL_CALL ODatabaseMetaData::supportsDataDefinitionAndDataManipulationTransactions(  ) throw(SQLException, RuntimeException, std::exception)
 538 {
 539     return sal_False;
 540 }
 541
 542 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedDelete(  ) throw(SQLException, RuntimeException, std::exception)
 543 {
 544     return sal_False;
 545 }
 546
 547 sal_Bool SAL_CALL ODatabaseMetaData::supportsPositionedUpdate(  ) throw(SQLException, RuntimeException, std::exception)
 548 {
 549     return sal_False;
 550 }
 551
 552 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossRollback(  ) throw(SQLException, RuntimeException, std::exception)
 553 {
 554     return sal_False;
 555 }
 556
 557 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenStatementsAcrossCommit(  ) throw(SQLException, RuntimeException, std::exception)
 558 {
 559     return sal_False;
 560 }
 561
 562 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossCommit(  ) throw(SQLException, RuntimeException, std::exception)
 563 {
 564     return sal_False;
 565 }
 566
 567 sal_Bool SAL_CALL ODatabaseMetaData::supportsOpenCursorsAcrossRollback(  ) throw(SQLException, RuntimeException, std::exception)
 568 {
 569     return sal_False;
 570 }
 571
 572 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactionIsolationLevel( sal_Int32 /*level*/ ) throw(SQLException, RuntimeException, std::exception)
 573 {
 574     return sal_False;
 575 }
 576
 577 bool ODatabaseMetaData::impl_supportsSchemasInDataManipulation_throw(  )
 578 {
 579     return false;
 580 }
 581
 582 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92FullSQL(  ) throw(SQLException, RuntimeException, std::exception)
 583 {
 584     return sal_False;
 585 }
 586
 587 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92EntryLevelSQL(  ) throw(SQLException, RuntimeException, std::exception)
 588 {
 589     return sal_False;
 590 }
 591
 592 sal_Bool SAL_CALL ODatabaseMetaData::supportsIntegrityEnhancementFacility(  ) throw(SQLException, RuntimeException, std::exception)
 593 {
 594     return sal_False;
 595 }
 596
 597 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInIndexDefinitions(  ) throw(SQLException, RuntimeException, std::exception)
 598 {
 599     return sal_False;
 600 }
 601
 602 bool ODatabaseMetaData::impl_supportsSchemasInTableDefinitions_throw(  )
 603 {
 604     return false;
 605 }
 606
 607 bool ODatabaseMetaData::impl_supportsCatalogsInTableDefinitions_throw(  )
 608 {
 609     return false;
 610 }
 611
 612 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInIndexDefinitions(  ) throw(SQLException, RuntimeException, std::exception)
 613 {
 614     return sal_False;
 615 }
 616
 617 bool ODatabaseMetaData::impl_supportsCatalogsInDataManipulation_throw(  )
 618 {
 619     return false;
 620 }
 621
 622 sal_Bool SAL_CALL ODatabaseMetaData::supportsOuterJoins(  ) throw(SQLException, RuntimeException, std::exception)
 623 {
 624     return sal_False;
 625 }
 626
 627 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getTableTypes(  ) throw(SQLException, RuntimeException, std::exception)
 628 {
 629     ::osl::MutexGuard aGuard( m_aMutex );
 630
 631     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet( ODatabaseMetaDataResultSet::eTableTypes );
 632     Reference< XResultSet > xRef = pResult;
 633     static ODatabaseMetaDataResultSet::ORows aRows;
 634     if(aRows.empty())
 635     {
 636         ODatabaseMetaDataResultSet::ORow aRow;
 637         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
 638         aRow.push_back(new ORowSetValueDecorator(OUString("TABLE")));
 639         aRows.push_back(aRow);
 640     }
 641     pResult->setRows(aRows);
 642     return xRef;
 643 }
 644
 645 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxStatementLength(  ) throw(SQLException, RuntimeException, std::exception)
 646 {
 647     return 0;
 648 }
 649
 650 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxProcedureNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 651 {
 652     return 0;
 653 }
 654
 655 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxSchemaNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 656 {
 657     return 0;
 658 }
 659
 660 sal_Bool SAL_CALL ODatabaseMetaData::supportsTransactions(  ) throw(SQLException, RuntimeException, std::exception)
 661 {
 662     return sal_False;
 663 }
 664
 665 sal_Bool SAL_CALL ODatabaseMetaData::allProceduresAreCallable(  ) throw(SQLException, RuntimeException, std::exception)
 666 {
 667     return sal_False;
 668 }
 669
 670 sal_Bool SAL_CALL ODatabaseMetaData::supportsStoredProcedures(  ) throw(SQLException, RuntimeException, std::exception)
 671 {
 672     return sal_False;
 673 }
 674
 675 sal_Bool SAL_CALL ODatabaseMetaData::supportsSelectForUpdate(  ) throw(SQLException, RuntimeException, std::exception)
 676 {
 677     return sal_False;
 678 }
 679
 680 sal_Bool SAL_CALL ODatabaseMetaData::allTablesAreSelectable(  ) throw(SQLException, RuntimeException, std::exception)
 681 {
 682     return sal_True;
 683 }
 684
 685 sal_Bool SAL_CALL ODatabaseMetaData::isReadOnly(  ) throw(SQLException, RuntimeException, std::exception)
 686 {
 687     return sal_True;
 688 }
 689
 690 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFiles(  ) throw(SQLException, RuntimeException, std::exception)
 691 {
 692     return sal_True;
 693 }
 694
 695 sal_Bool SAL_CALL ODatabaseMetaData::usesLocalFilePerTable(  ) throw(SQLException, RuntimeException, std::exception)
 696 {
 697     return sal_True;
 698 }
 699
 700 sal_Bool SAL_CALL ODatabaseMetaData::supportsTypeConversion(  ) throw(SQLException, RuntimeException, std::exception)
 701 {
 702     return sal_False;
 703 }
 704
 705 sal_Bool SAL_CALL ODatabaseMetaData::nullPlusNonNullIsNull(  ) throw(SQLException, RuntimeException, std::exception)
 706 {
 707     return sal_True;
 708 }
 709
 710 sal_Bool SAL_CALL ODatabaseMetaData::supportsColumnAliasing(  ) throw(SQLException, RuntimeException, std::exception)
 711 {
 712     return sal_True;
 713 }
 714
 715 sal_Bool SAL_CALL ODatabaseMetaData::supportsTableCorrelationNames(  ) throw(SQLException, RuntimeException, std::exception)
 716 {
 717     return sal_True;
 718 }
 719
 720 sal_Bool SAL_CALL ODatabaseMetaData::supportsConvert( sal_Int32 /*fromType*/, sal_Int32 /*toType*/ ) throw(SQLException, RuntimeException, std::exception)
 721 {
 722     return sal_False;
 723 }
 724
 725 sal_Bool SAL_CALL ODatabaseMetaData::supportsExpressionsInOrderBy(  ) throw(SQLException, RuntimeException, std::exception)
 726 {
 727     return sal_False;
 728 }
 729
 730 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupBy(  ) throw(SQLException, RuntimeException, std::exception)
 731 {
 732     return sal_False;
 733 }
 734
 735 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByBeyondSelect(  ) throw(SQLException, RuntimeException, std::exception)
 736 {
 737     return sal_False;
 738 }
 739
 740 sal_Bool SAL_CALL ODatabaseMetaData::supportsGroupByUnrelated(  ) throw(SQLException, RuntimeException, std::exception)
 741 {
 742     return sal_False;
 743 }
 744
 745 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleTransactions(  ) throw(SQLException, RuntimeException, std::exception)
 746 {
 747     return sal_False;
 748 }
 749
 750 sal_Bool SAL_CALL ODatabaseMetaData::supportsMultipleResultSets(  ) throw(SQLException, RuntimeException, std::exception)
 751 {
 752     return sal_False;
 753 }
 754
 755 sal_Bool SAL_CALL ODatabaseMetaData::supportsLikeEscapeClause(  ) throw(SQLException, RuntimeException, std::exception)
 756 {
 757     return sal_False;
 758 }
 759
 760 sal_Bool SAL_CALL ODatabaseMetaData::supportsOrderByUnrelated(  ) throw(SQLException, RuntimeException, std::exception)
 761 {
 762     return sal_True;
 763 }
 764
 765 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnion(  ) throw(SQLException, RuntimeException, std::exception)
 766 {
 767     return sal_False;
 768 }
 769
 770 sal_Bool SAL_CALL ODatabaseMetaData::supportsUnionAll(  ) throw(SQLException, RuntimeException, std::exception)
 771 {
 772     return sal_False;
 773 }
 774
 775 sal_Bool SAL_CALL ODatabaseMetaData::supportsMixedCaseIdentifiers(  ) throw(SQLException, RuntimeException, std::exception)
 776 {
 777     return sal_True;
 778 }
 779
 780 bool ODatabaseMetaData::impl_supportsMixedCaseQuotedIdentifiers_throw(  )
 781 {
 782     return false;
 783 }
 784
 785 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtEnd(  ) throw(SQLException, RuntimeException, std::exception)
 786 {
 787     return sal_False;
 788 }
 789
 790 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedAtStart(  ) throw(SQLException, RuntimeException, std::exception)
 791 {
 792     return sal_True;
 793 }
 794
 795 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedHigh(  ) throw(SQLException, RuntimeException, std::exception)
 796 {
 797     return sal_False;
 798 }
 799
 800 sal_Bool SAL_CALL ODatabaseMetaData::nullsAreSortedLow(  ) throw(SQLException, RuntimeException, std::exception)
 801 {
 802     return sal_True;
 803 }
 804
 805 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInProcedureCalls(  ) throw(SQLException, RuntimeException, std::exception)
 806 {
 807     return sal_False;
 808 }
 809
 810 sal_Bool SAL_CALL ODatabaseMetaData::supportsSchemasInPrivilegeDefinitions(  ) throw(SQLException, RuntimeException, std::exception)
 811 {
 812     return sal_False;
 813 }
 814
 815 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInProcedureCalls(  ) throw(SQLException, RuntimeException, std::exception)
 816 {
 817     return sal_False;
 818 }
 819
 820 sal_Bool SAL_CALL ODatabaseMetaData::supportsCatalogsInPrivilegeDefinitions(  ) throw(SQLException, RuntimeException, std::exception)
 821 {
 822     return sal_False;
 823 }
 824
 825 sal_Bool SAL_CALL ODatabaseMetaData::supportsCorrelatedSubqueries(  ) throw(SQLException, RuntimeException, std::exception)
 826 {
 827     return sal_False;
 828 }
 829
 830 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInComparisons(  ) throw(SQLException, RuntimeException, std::exception)
 831 {
 832     return sal_False;
 833 }
 834
 835 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInExists(  ) throw(SQLException, RuntimeException, std::exception)
 836 {
 837     return sal_False;
 838 }
 839
 840 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInIns(  ) throw(SQLException, RuntimeException, std::exception)
 841 {
 842     return sal_False;
 843 }
 844
 845 sal_Bool SAL_CALL ODatabaseMetaData::supportsSubqueriesInQuantifieds(  ) throw(SQLException, RuntimeException, std::exception)
 846 {
 847     return sal_False;
 848 }
 849
 850 sal_Bool SAL_CALL ODatabaseMetaData::supportsANSI92IntermediateSQL(  ) throw(SQLException, RuntimeException, std::exception)
 851 {
 852     return sal_False;
 853 }
 854
 855 OUString SAL_CALL ODatabaseMetaData::getURL(  ) throw(SQLException, RuntimeException, std::exception)
 856 {
 857     static const OUString aValue(  "sdbc:file:" );
 858     return aValue;
 859 }
 860
 861 OUString SAL_CALL ODatabaseMetaData::getUserName(  ) throw(SQLException, RuntimeException, std::exception)
 862 {
 863     return OUString();
 864 }
 865
 866 OUString SAL_CALL ODatabaseMetaData::getDriverName(  ) throw(SQLException, RuntimeException, std::exception)
 867 {
 868     return OUString();
 869 }
 870
 871 OUString SAL_CALL ODatabaseMetaData::getDriverVersion(  ) throw(SQLException, RuntimeException, std::exception)
 872 {
 873     return OUString::number(1);
 874 }
 875
 876 OUString SAL_CALL ODatabaseMetaData::getDatabaseProductVersion(  ) throw(SQLException, RuntimeException, std::exception)
 877 {
 878     return OUString::number(0);
 879 }
 880
 881 OUString SAL_CALL ODatabaseMetaData::getDatabaseProductName(  ) throw(SQLException, RuntimeException, std::exception)
 882 {
 883     return OUString();
 884 }
 885
 886 OUString SAL_CALL ODatabaseMetaData::getProcedureTerm(  ) throw(SQLException, RuntimeException, std::exception)
 887 {
 888     return OUString();
 889 }
 890
 891 OUString SAL_CALL ODatabaseMetaData::getSchemaTerm(  ) throw(SQLException, RuntimeException, std::exception)
 892 {
 893     return OUString();
 894 }
 895
 896 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMajorVersion(  ) throw(RuntimeException, std::exception)
 897 {
 898     return 0;
 899 }
 900
 901 sal_Int32 SAL_CALL ODatabaseMetaData::getDefaultTransactionIsolation(  ) throw(SQLException, RuntimeException, std::exception)
 902 {
 903     return 0;
 904 }
 905
 906 sal_Int32 SAL_CALL ODatabaseMetaData::getDriverMinorVersion(  ) throw(RuntimeException, std::exception)
 907 {
 908     return 0;
 909 }
 910
 911 OUString SAL_CALL ODatabaseMetaData::getSQLKeywords(  ) throw(SQLException, RuntimeException, std::exception)
 912 {
 913     return OUString();
 914 }
 915
 916 OUString SAL_CALL ODatabaseMetaData::getSearchStringEscape(  ) throw(SQLException, RuntimeException, std::exception)
 917 {
 918     return OUString();
 919 }
 920
 921 OUString SAL_CALL ODatabaseMetaData::getStringFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 922 {
 923     return OUString("UCASE,LCASE,ASCII,LENGTH,OCTET_LENGTH,CHAR_LENGTH,CHARACTER_LENGTH,CHAR,CONCAT,LOCATE,SUBSTRING,LTRIM,RTRIM,SPACE,REPLACE,REPEAT,INSERT,LEFT,RIGHT");
 924 }
 925
 926 OUString SAL_CALL ODatabaseMetaData::getTimeDateFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 927 {
 928     return OUString("DAYOFWEEK,DAYOFMONTH,DAYOFYEAR,MONTH,DAYNAME,MONTHNAME,QUARTER,WEEK,YEAR,HOUR,MINUTE,SECOND,CURDATE,CURTIME,NOW");
 929 }
 930
 931 OUString SAL_CALL ODatabaseMetaData::getSystemFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 932 {
 933     return OUString();
 934 }
 935
 936 OUString SAL_CALL ODatabaseMetaData::getNumericFunctions(  ) throw(SQLException, RuntimeException, std::exception)
 937 {
 938     return OUString("ABS,SIGN,MOD,FLOOR,CEILING,ROUND,EXP,LN,LOG,LOG10,POWER,SQRT,PI,COS,SIN,TAN,ACOS,ASIN,ATAN,ATAN2,DEGREES,RADIANS");
 939 }
 940
 941 sal_Bool SAL_CALL ODatabaseMetaData::supportsExtendedSQLGrammar(  ) throw(SQLException, RuntimeException, std::exception)
 942 {
 943     return sal_False;
 944 }
 945
 946 sal_Bool SAL_CALL ODatabaseMetaData::supportsCoreSQLGrammar(  ) throw(SQLException, RuntimeException, std::exception)
 947 {
 948     return sal_False;
 949 }
 950
 951 sal_Bool SAL_CALL ODatabaseMetaData::supportsMinimumSQLGrammar(  ) throw(SQLException, RuntimeException, std::exception)
 952 {
 953     return sal_True;
 954 }
 955
 956 sal_Bool SAL_CALL ODatabaseMetaData::supportsFullOuterJoins(  ) throw(SQLException, RuntimeException, std::exception)
 957 {
 958     return sal_False;
 959 }
 960
 961 sal_Bool SAL_CALL ODatabaseMetaData::supportsLimitedOuterJoins(  ) throw(SQLException, RuntimeException, std::exception)
 962 {
 963     return sal_False;
 964 }
 965
 966 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInGroupBy(  ) throw(SQLException, RuntimeException, std::exception)
 967 {
 968     return 0;
 969 }
 970
 971 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInOrderBy(  ) throw(SQLException, RuntimeException, std::exception)
 972 {
 973     return 0;
 974 }
 975
 976 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxColumnsInSelect(  ) throw(SQLException, RuntimeException, std::exception)
 977 {
 978     return 0;
 979 }
 980
 981 sal_Int32 SAL_CALL ODatabaseMetaData::getMaxUserNameLength(  ) throw(SQLException, RuntimeException, std::exception)
 982 {
 983     return 0;
 984 }
 985
 986 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetType( sal_Int32 setType ) throw(SQLException, RuntimeException, std::exception)
 987 {
 988     switch(setType)
 989     {
 990         case ResultSetType::FORWARD_ONLY:
 991             return sal_True;
 992         case ResultSetType::SCROLL_INSENSITIVE:
 993         case ResultSetType::SCROLL_SENSITIVE:
 994             break;
 995     }
 996     return sal_False;
 997 }
 998
 999 sal_Bool SAL_CALL ODatabaseMetaData::supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 /*concurrency*/ ) throw(SQLException, RuntimeException, std::exception)
1000 {
1001     switch(setType)
1002     {
1003         case ResultSetType::FORWARD_ONLY:
1004             return sal_True;
1005         case ResultSetType::SCROLL_INSENSITIVE:
1006         case ResultSetType::SCROLL_SENSITIVE:
1007             break;
1008     }
1009     return sal_False;
1010 }
1011
1012 sal_Bool SAL_CALL ODatabaseMetaData::ownUpdatesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1013 {
1014     return sal_True;
1015 }
1016
1017 sal_Bool SAL_CALL ODatabaseMetaData::ownDeletesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1018 {
1019     return sal_True;
1020 }
1021
1022 sal_Bool SAL_CALL ODatabaseMetaData::ownInsertsAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1023 {
1024     return sal_True;
1025 }
1026
1027 sal_Bool SAL_CALL ODatabaseMetaData::othersUpdatesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1028 {
1029     return sal_True;
1030 }
1031
1032 sal_Bool SAL_CALL ODatabaseMetaData::othersDeletesAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1033 {
1034     return sal_True;
1035 }
1036
1037 sal_Bool SAL_CALL ODatabaseMetaData::othersInsertsAreVisible( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1038 {
1039     return sal_True;
1040 }
1041
1042 sal_Bool SAL_CALL ODatabaseMetaData::updatesAreDetected( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1043 {
1044     return sal_False;
1045 }
1046
1047 sal_Bool SAL_CALL ODatabaseMetaData::deletesAreDetected( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1048 {
1049     return sal_False;
1050 }
1051
1052 sal_Bool SAL_CALL ODatabaseMetaData::insertsAreDetected( sal_Int32 /*setType*/ ) throw(SQLException, RuntimeException, std::exception)
1053 {
1054     return sal_False;
1055 }
1056
1057 sal_Bool SAL_CALL ODatabaseMetaData::supportsBatchUpdates(  ) throw(SQLException, RuntimeException, std::exception)
1058 {
1059     return sal_False;
1060 }
1061
1062 Reference< XResultSet > SAL_CALL ODatabaseMetaData::getUDTs( const Any& /*catalog*/, const OUString& /*schemaPattern*/, const OUString& /*typeNamePattern*/, const Sequence< sal_Int32 >& /*types*/ ) throw(SQLException, RuntimeException, std::exception)
1063 {
1064     return NULL;
1065 }
1066
1067
1068 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */