/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the Collabora Office project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * 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 . */ #include #include #include #include #include #include #include #include #include #include using namespace connectivity::component; using namespace connectivity::file; using namespace ::com::sun::star::uno; using namespace cpo::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; OComponentDatabaseMetaData::OComponentDatabaseMetaData(OConnection* _pCon) :ODatabaseMetaData(_pCon) { } OComponentDatabaseMetaData::~OComponentDatabaseMetaData() { } Reference< XResultSet > OComponentDatabaseMetaData::impl_getTypeInfo_throw( ) { rtl::Reference pResult = new ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTypeInfo); ODatabaseMetaDataResultSet::ORows aRows; aRows.reserve(6); ODatabaseMetaDataResultSet::ORow aRow { ODatabaseMetaDataResultSet::getEmptyValue(), new ORowSetValueDecorator(u"VARCHAR"_ustr), new ORowSetValueDecorator(DataType::VARCHAR), new ORowSetValueDecorator(sal_Int32(65535)), ODatabaseMetaDataResultSet::getQuoteValue(), ODatabaseMetaDataResultSet::getQuoteValue(), ODatabaseMetaDataResultSet::getEmptyValue(), ODatabaseMetaDataResultSet::get1Value(), // ORowSetValue((sal_Int32)ColumnValue::NULLABLE ODatabaseMetaDataResultSet::get1Value(), new ORowSetValueDecorator(sal_Int32(ColumnSearch::CHAR)), ODatabaseMetaDataResultSet::get1Value(), ODatabaseMetaDataResultSet::get0Value(), ODatabaseMetaDataResultSet::get0Value(), ODatabaseMetaDataResultSet::getEmptyValue(), ODatabaseMetaDataResultSet::get0Value(), ODatabaseMetaDataResultSet::get0Value(), ODatabaseMetaDataResultSet::getEmptyValue(), ODatabaseMetaDataResultSet::getEmptyValue(), new ORowSetValueDecorator(sal_Int32(10)) }; aRows.push_back(aRow); aRow[1] = new ORowSetValueDecorator(u"DECIMAL"_ustr); aRow[2] = new ORowSetValueDecorator(DataType::DECIMAL); aRow[3] = ODatabaseMetaDataResultSet::get0Value(); aRow[9] = ODatabaseMetaDataResultSet::getBasicValue(); aRow[15] = ODatabaseMetaDataResultSet::get0Value(); aRows.push_back(aRow); aRow[1] = new ORowSetValueDecorator(u"BOOL"_ustr); aRow[2] = new ORowSetValueDecorator(DataType::BIT); aRow[3] = new ORowSetValueDecorator(sal_Int32(20)); aRow[9] = ODatabaseMetaDataResultSet::getBasicValue(); aRow[15] = new ORowSetValueDecorator(sal_Int32(15)); aRows.push_back(aRow); aRow[1] = new ORowSetValueDecorator(u"DATE"_ustr); aRow[2] = new ORowSetValueDecorator(DataType::DATE); aRow[3] = ODatabaseMetaDataResultSet::get0Value(); aRow[9] = ODatabaseMetaDataResultSet::getBasicValue(); aRow[15] = ODatabaseMetaDataResultSet::get0Value(); aRows.push_back(aRow); aRow[1] = new ORowSetValueDecorator(u"TIME"_ustr); aRow[2] = new ORowSetValueDecorator(DataType::TIME); aRow[3] = ODatabaseMetaDataResultSet::get0Value(); aRow[9] = ODatabaseMetaDataResultSet::getBasicValue(); aRow[15] = ODatabaseMetaDataResultSet::get0Value(); aRows.push_back(aRow); aRow[1] = new ORowSetValueDecorator(u"TIMESTAMP"_ustr); aRow[2] = new ORowSetValueDecorator(DataType::TIMESTAMP); aRow[3] = ODatabaseMetaDataResultSet::get0Value(); aRow[9] = ODatabaseMetaDataResultSet::getBasicValue(); aRow[15] = ODatabaseMetaDataResultSet::get0Value(); aRows.push_back(std::move(aRow)); pResult->setRows(std::move(aRows)); return pResult; } Reference< XResultSet > OComponentDatabaseMetaData::getColumns( const Any& /*catalog*/, const OUString& /*schemaPattern*/, const OUString& tableNamePattern, const OUString& columnNamePattern ) { ::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)); for (const OUString& rTab : xNames->getElementNames()) { if (match(tableNamePattern, rTab, '\0')) { const Reference xTable(xNames->getByName(rTab), UNO_QUERY_THROW); aRow[3] = new ORowSetValueDecorator(rTab); const Reference< XNameAccess> xColumns = xTable->getColumns(); if(!xColumns.is()) throw SQLException(); const Sequence< OUString> aColNames(xColumns->getElementNames()); for (sal_Int32 i = 0; i < aColNames.getLength(); ++i) { if (match(columnNamePattern, aColNames[i], '\0')) { aRow[4] = new ORowSetValueDecorator(aColNames[i]); auto xColumn = xColumns->getByName(aColNames[i]).query(); OSL_ENSURE(xColumn.is(),"Columns contains a column who isn't a fastpropertyset!"); aRow[5] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE)))); aRow[6] = new ORowSetValueDecorator(::comphelper::getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)))); aRow[7] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION)))); // aRow[8] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)); aRow[9] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE)))); aRow[11] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE)))); // aRow[12] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)); aRow[13] = new ORowSetValueDecorator(::comphelper::getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE)))); // aRow[14] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)); // aRow[15] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)); switch(aRow[5]->getValue().getInt32()) { 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 + 1); switch(aRow[11]->getValue().getInt32()) { case ColumnValue::NO_NULLS: aRow[18] = new ORowSetValueDecorator(u"NO"_ustr); break; case ColumnValue::NULLABLE: aRow[18] = new ORowSetValueDecorator(u"YES"_ustr); break; default: aRow[18] = new ORowSetValueDecorator(OUString()); } aRows.push_back(aRow); } } } } rtl::Reference pResult = new ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eColumns); pResult->setRows(std::move(aRows)); return pResult; } sal_Int32 OComponentDatabaseMetaData::getMaxBinaryLiteralLength( ) { return SAL_MAX_INT32; } sal_Int32 OComponentDatabaseMetaData::getMaxCharLiteralLength( ) { return SAL_MAX_INT32; } sal_Int32 OComponentDatabaseMetaData::getMaxColumnNameLength( ) { return SAL_MAX_INT32; } sal_Int32 OComponentDatabaseMetaData::getMaxColumnsInIndex( ) { return 1; } sal_Int32 OComponentDatabaseMetaData::getMaxColumnsInTable( ) { return 256; } /* vim:set shiftwidth=4 softtabstop=4 expandtab: */