| /************************************************************** | |
| * | |
| * Licensed to the Apache Software Foundation (ASF) under one | |
| * or more contributor license agreements. See the NOTICE file | |
| * distributed with this work for additional information | |
| * regarding copyright ownership. The ASF licenses this file | |
| * to you under the Apache License, Version 2.0 (the | |
| * "License"); you may not use this file except in compliance | |
| * with the License. You may obtain a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * | |
| * Unless required by applicable law or agreed to in writing, | |
| * software distributed under the License is distributed on an | |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY | |
| * KIND, either express or implied. See the License for the | |
| * specific language governing permissions and limitations | |
| * under the License. | |
| * | |
| *************************************************************/ | |
| // MARKER(update_precomp.py): autogen include statement, do not remove | |
| #include "precompiled_flat.hxx" | |
| #include "flat/EDatabaseMetaData.hxx" | |
| #include <com/sun/star/sdbc/DataType.hpp> | |
| #include <com/sun/star/sdbc/ResultSetType.hpp> | |
| #include <com/sun/star/sdbc/ColumnValue.hpp> | |
| #include <com/sun/star/beans/XFastPropertySet.hpp> | |
| #include <com/sun/star/sdbc/ResultSetConcurrency.hpp> | |
| #include <com/sun/star/sdbcx/XColumnsSupplier.hpp> | |
| #include <com/sun/star/sdbcx/XIndexesSupplier.hpp> | |
| #include <tools/urlobj.hxx> | |
| #include "FDatabaseMetaDataResultSet.hxx" | |
| #include <com/sun/star/lang/XUnoTunnel.hpp> | |
| #include <comphelper/extract.hxx> | |
| #include <comphelper/types.hxx> | |
| #include <rtl/logfile.hxx> | |
| using namespace ::comphelper; | |
| using namespace connectivity; | |
| using namespace connectivity::flat; | |
| // using namespace connectivity::file; | |
| using namespace ::com::sun::star::uno; | |
| using namespace ::com::sun::star::beans; | |
| using namespace ::com::sun::star::sdbcx; | |
| using namespace ::com::sun::star::sdbc; | |
| using namespace ::com::sun::star::container; | |
| OFlatDatabaseMetaData::OFlatDatabaseMetaData(::connectivity::file::OConnection* _pCon) :ODatabaseMetaData(_pCon) | |
| { | |
| RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "flat", "Ocke.Janssen@sun.com", "OFlatDatabaseMetaData::OFlatDatabaseMetaData" ); | |
| } | |
| // ------------------------------------------------------------------------- | |
| OFlatDatabaseMetaData::~OFlatDatabaseMetaData() | |
| { | |
| RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "flat", "Ocke.Janssen@sun.com", "OFlatDatabaseMetaData::~OFlatDatabaseMetaData" ); | |
| } | |
| // ------------------------------------------------------------------------- | |
| Reference< XResultSet > OFlatDatabaseMetaData::impl_getTypeInfo_throw( ) | |
| { | |
| RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "flat", "Ocke.Janssen@sun.com", "OFlatDatabaseMetaData::impl_getTypeInfo_throw" ); | |
| ::osl::MutexGuard aGuard( m_aMutex ); | |
| ::connectivity::ODatabaseMetaDataResultSet* pResult = new ::connectivity::ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTypeInfo); | |
| Reference< XResultSet > xRef = pResult; | |
| static ODatabaseMetaDataResultSet::ORows aRows; | |
| if(aRows.empty()) | |
| { | |
| ODatabaseMetaDataResultSet::ORow aRow; | |
| aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue()); | |
| aRow.push_back(new ORowSetValueDecorator(::rtl::OUString::createFromAscii("CHAR"))); | |
| aRow.push_back(new ORowSetValueDecorator(DataType::CHAR)); | |
| aRow.push_back(new ORowSetValueDecorator((sal_Int32)254)); | |
| aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue()); | |
| aRow.push_back(new ORowSetValueDecorator((sal_Int32)ColumnValue::NULLABLE)); | |
| aRow.push_back(ODatabaseMetaDataResultSet::get1Value()); | |
| aRow.push_back(new ORowSetValueDecorator((sal_Int32)ColumnSearch::CHAR)); | |
| aRow.push_back(ODatabaseMetaDataResultSet::get1Value()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::get0Value()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::get0Value()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::get0Value()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::get0Value()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue()); | |
| aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue()); | |
| aRow.push_back(new ORowSetValueDecorator((sal_Int32)10)); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("VARCHAR")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::VARCHAR); | |
| aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("LONGVARCHAR")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::LONGVARCHAR); | |
| aRow[3] = new ORowSetValueDecorator((sal_Int32)65535); | |
| aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("DATE")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::DATE); | |
| aRow[3] = new ORowSetValueDecorator((sal_Int32)10); | |
| aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("TIME")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::TIME); | |
| aRow[3] = new ORowSetValueDecorator((sal_Int32)8); | |
| aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("TIMESTAMP")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::TIMESTAMP); | |
| aRow[3] = new ORowSetValueDecorator((sal_Int32)19); | |
| aRow[4] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRow[5] = ODatabaseMetaDataResultSet::getQuoteValue(); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("BOOL")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::BIT); | |
| aRow[3] = ODatabaseMetaDataResultSet::get1Value(); | |
| aRow[9] = ODatabaseMetaDataResultSet::getBasicValue(); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("DECIMAL")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::DECIMAL); | |
| aRow[3] = new ORowSetValueDecorator((sal_Int32)20); | |
| aRow[15] = new ORowSetValueDecorator((sal_Int32)15); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("DOUBLE")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::DOUBLE); | |
| aRow[3] = new ORowSetValueDecorator((sal_Int32)20); | |
| aRow[15] = ODatabaseMetaDataResultSet::get0Value(); | |
| aRows.push_back(aRow); | |
| aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("NUMERIC")); | |
| aRow[2] = new ORowSetValueDecorator(DataType::NUMERIC); | |
| aRow[3] = new ORowSetValueDecorator((sal_Int32)20); | |
| aRow[15] = new ORowSetValueDecorator((sal_Int32)20); | |
| aRows.push_back(aRow); | |
| } | |
| pResult->setRows(aRows); | |
| return xRef; | |
| } | |
| // ------------------------------------------------------------------------- | |
| Reference< XResultSet > SAL_CALL OFlatDatabaseMetaData::getColumns( | |
| const Any& /*catalog*/, const ::rtl::OUString& /*schemaPattern*/, const ::rtl::OUString& tableNamePattern, | |
| const ::rtl::OUString& columnNamePattern ) | |
| { | |
| RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "flat", "Ocke.Janssen@sun.com", "OFlatDatabaseMetaData::getColumns" ); | |
| ::osl::MutexGuard aGuard( m_aMutex ); | |
| Reference< XTablesSupplier > xTables = m_pConnection->createCatalog(); | |
| if(!xTables.is()) | |
| throw SQLException(); | |
| Reference< XNameAccess> xNames = xTables->getTables(); | |
| if(!xNames.is()) | |
| throw SQLException(); | |
| ODatabaseMetaDataResultSet::ORows aRows; | |
| ODatabaseMetaDataResultSet::ORow aRow(19); | |
| aRow[10] = new ORowSetValueDecorator((sal_Int32)10); | |
| Sequence< ::rtl::OUString> aTabNames(xNames->getElementNames()); | |
| const ::rtl::OUString* pTabBegin = aTabNames.getConstArray(); | |
| const ::rtl::OUString* pTabEnd = pTabBegin + aTabNames.getLength(); | |
| for(;pTabBegin != pTabEnd;++pTabBegin) | |
| { | |
| if(match(tableNamePattern,*pTabBegin,'\0')) | |
| { | |
| Reference< XColumnsSupplier> xTable; | |
| ::cppu::extractInterface(xTable,xNames->getByName(*pTabBegin)); | |
| aRow[3] = new ORowSetValueDecorator(*pTabBegin); | |
| Reference< XNameAccess> xColumns = xTable->getColumns(); | |
| if(!xColumns.is()) | |
| throw SQLException(); | |
| Sequence< ::rtl::OUString> aColNames(xColumns->getElementNames()); | |
| const ::rtl::OUString* pBegin = aColNames.getConstArray(); | |
| const ::rtl::OUString* pEnd = pBegin + aColNames.getLength(); | |
| Reference< XPropertySet> xColumn; | |
| for(sal_Int32 i=1;pBegin != pEnd;++pBegin,++i) | |
| { | |
| if(match(columnNamePattern,*pBegin,'\0')) | |
| { | |
| aRow[4] = new ORowSetValueDecorator(*pBegin); | |
| ::cppu::extractInterface(xColumn,xColumns->getByName(*pBegin)); | |
| OSL_ENSURE(xColumn.is(),"Columns contains a column who isn't a fastpropertyset!"); | |
| aRow[5] = new ORowSetValueDecorator(getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE)))); | |
| aRow[6] = new ORowSetValueDecorator(getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)))); | |
| aRow[7] = new ORowSetValueDecorator(getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION)))); | |
| aRow[9] = new ORowSetValueDecorator(getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE)))); | |
| aRow[11] = new ORowSetValueDecorator(getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE)))); | |
| aRow[13] = new ORowSetValueDecorator(getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE)))); | |
| switch((sal_Int32)aRow[5]->getValue()) | |
| { | |
| case DataType::CHAR: | |
| case DataType::VARCHAR: | |
| aRow[16] = new ORowSetValueDecorator((sal_Int32)254); | |
| break; | |
| case DataType::LONGVARCHAR: | |
| aRow[16] = new ORowSetValueDecorator((sal_Int32)65535); | |
| break; | |
| default: | |
| aRow[16] = new ORowSetValueDecorator((sal_Int32)0); | |
| } | |
| aRow[17] = new ORowSetValueDecorator(i); | |
| switch(sal_Int32(aRow[11]->getValue())) | |
| { | |
| case ColumnValue::NO_NULLS: | |
| aRow[18] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("NO")); | |
| break; | |
| case ColumnValue::NULLABLE: | |
| aRow[18] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("YES")); | |
| break; | |
| default: | |
| aRow[18] = new ORowSetValueDecorator(::rtl::OUString()); | |
| } | |
| aRows.push_back(aRow); | |
| } | |
| } | |
| } | |
| } | |
| ::connectivity::ODatabaseMetaDataResultSet* pResult = new ::connectivity::ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eColumns); | |
| Reference< XResultSet > xRef = pResult; | |
| pResult->setRows(aRows); | |
| return xRef; | |
| } | |
| // ------------------------------------------------------------------------- | |
| ::rtl::OUString SAL_CALL OFlatDatabaseMetaData::getURL( ) | |
| { | |
| RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "flat", "Ocke.Janssen@sun.com", "OFlatDatabaseMetaData::getURL" ); | |
| ::osl::MutexGuard aGuard( m_aMutex ); | |
| return ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("sdbc:flat:")) + m_pConnection->getURL(); | |
| } | |
| // ----------------------------------------------------------------------------- |