1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_connectivity.hxx"
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski
28*b1cdbd2cSJim Jagielski #include "calc/CDatabaseMetaData.hxx"
29*b1cdbd2cSJim Jagielski #include "calc/CConnection.hxx"
30*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/DataType.hpp>
31*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/ResultSetType.hpp>
32*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/ColumnValue.hpp>
33*b1cdbd2cSJim Jagielski #include <com/sun/star/beans/XPropertySet.hpp>
34*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
35*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XColumnsSupplier.hpp>
36*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbcx/XIndexesSupplier.hpp>
37*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
38*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/XSpreadsheet.hpp>
39*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/XCellRangesQuery.hpp>
40*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/XCellRangeAddressable.hpp>
41*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/XDatabaseRanges.hpp>
42*b1cdbd2cSJim Jagielski #include <com/sun/star/sheet/XDatabaseRange.hpp>
43*b1cdbd2cSJim Jagielski #include <tools/urlobj.hxx>
44*b1cdbd2cSJim Jagielski #include "FDatabaseMetaDataResultSet.hxx"
45*b1cdbd2cSJim Jagielski #include <com/sun/star/lang/XUnoTunnel.hpp>
46*b1cdbd2cSJim Jagielski #include <comphelper/types.hxx>
47*b1cdbd2cSJim Jagielski #include <rtl/logfile.hxx>
48*b1cdbd2cSJim Jagielski
49*b1cdbd2cSJim Jagielski using namespace connectivity::calc;
50*b1cdbd2cSJim Jagielski using namespace connectivity::file;
51*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
52*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::beans;
53*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbcx;
54*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sdbc;
55*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::container;
56*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::table;
57*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sheet;
58*b1cdbd2cSJim Jagielski
59*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
60*b1cdbd2cSJim Jagielski
OCalcDatabaseMetaData(OConnection * _pCon)61*b1cdbd2cSJim Jagielski OCalcDatabaseMetaData::OCalcDatabaseMetaData(OConnection* _pCon) :ODatabaseMetaData(_pCon)
62*b1cdbd2cSJim Jagielski {
63*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::OCalcDatabaseMetaData" );
64*b1cdbd2cSJim Jagielski }
65*b1cdbd2cSJim Jagielski
66*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
67*b1cdbd2cSJim Jagielski
~OCalcDatabaseMetaData()68*b1cdbd2cSJim Jagielski OCalcDatabaseMetaData::~OCalcDatabaseMetaData()
69*b1cdbd2cSJim Jagielski {
70*b1cdbd2cSJim Jagielski }
71*b1cdbd2cSJim Jagielski
72*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
impl_getTypeInfo_throw()73*b1cdbd2cSJim Jagielski Reference< XResultSet > OCalcDatabaseMetaData::impl_getTypeInfo_throw( )
74*b1cdbd2cSJim Jagielski {
75*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::impl_getTypeInfo_throw" );
76*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard( m_aMutex );
77*b1cdbd2cSJim Jagielski
78*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTypeInfo);
79*b1cdbd2cSJim Jagielski Reference< XResultSet > xRef = pResult;
80*b1cdbd2cSJim Jagielski
81*b1cdbd2cSJim Jagielski static ODatabaseMetaDataResultSet::ORows aRows;
82*b1cdbd2cSJim Jagielski if(aRows.empty())
83*b1cdbd2cSJim Jagielski {
84*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet::ORow aRow;
85*b1cdbd2cSJim Jagielski
86*b1cdbd2cSJim Jagielski aRows.reserve(6);
87*b1cdbd2cSJim Jagielski aRow.reserve(18);
88*b1cdbd2cSJim Jagielski
89*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
90*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator(::rtl::OUString::createFromAscii("VARCHAR")));
91*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator(DataType::VARCHAR));
92*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator((sal_Int32)65535));
93*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue());
94*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue());
95*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
96*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::get1Value()); // ORowSetValue((sal_Int32)ColumnValue::NULLABLE)
97*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::get1Value());
98*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator((sal_Int32)ColumnSearch::CHAR));
99*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::get1Value());
100*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
101*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
102*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
103*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
104*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
105*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
106*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
107*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator((sal_Int32)10));
108*b1cdbd2cSJim Jagielski
109*b1cdbd2cSJim Jagielski
110*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
111*b1cdbd2cSJim Jagielski
112*b1cdbd2cSJim Jagielski aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("DECIMAL"));
113*b1cdbd2cSJim Jagielski aRow[2] = new ORowSetValueDecorator(DataType::DECIMAL);
114*b1cdbd2cSJim Jagielski aRow[3] = ODatabaseMetaDataResultSet::get0Value();
115*b1cdbd2cSJim Jagielski aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
116*b1cdbd2cSJim Jagielski aRow[15] = ODatabaseMetaDataResultSet::get0Value();
117*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
118*b1cdbd2cSJim Jagielski
119*b1cdbd2cSJim Jagielski aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("BOOL"));
120*b1cdbd2cSJim Jagielski aRow[2] = new ORowSetValueDecorator(DataType::BIT);
121*b1cdbd2cSJim Jagielski aRow[3] = new ORowSetValueDecorator((sal_Int32)20);
122*b1cdbd2cSJim Jagielski aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
123*b1cdbd2cSJim Jagielski aRow[15] = new ORowSetValueDecorator((sal_Int32)15);
124*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
125*b1cdbd2cSJim Jagielski
126*b1cdbd2cSJim Jagielski aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("DATE"));
127*b1cdbd2cSJim Jagielski aRow[2] = new ORowSetValueDecorator(DataType::DATE);
128*b1cdbd2cSJim Jagielski aRow[3] = ODatabaseMetaDataResultSet::get0Value();
129*b1cdbd2cSJim Jagielski aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
130*b1cdbd2cSJim Jagielski aRow[15] = ODatabaseMetaDataResultSet::get0Value();
131*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
132*b1cdbd2cSJim Jagielski
133*b1cdbd2cSJim Jagielski aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("TIME"));
134*b1cdbd2cSJim Jagielski aRow[2] = new ORowSetValueDecorator(DataType::TIME);
135*b1cdbd2cSJim Jagielski aRow[3] = ODatabaseMetaDataResultSet::get0Value();
136*b1cdbd2cSJim Jagielski aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
137*b1cdbd2cSJim Jagielski aRow[15] = ODatabaseMetaDataResultSet::get0Value();
138*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
139*b1cdbd2cSJim Jagielski
140*b1cdbd2cSJim Jagielski aRow[1] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("TIMESTAMP"));
141*b1cdbd2cSJim Jagielski aRow[2] = new ORowSetValueDecorator(DataType::TIMESTAMP);
142*b1cdbd2cSJim Jagielski aRow[3] = ODatabaseMetaDataResultSet::get0Value();
143*b1cdbd2cSJim Jagielski aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
144*b1cdbd2cSJim Jagielski aRow[15] = ODatabaseMetaDataResultSet::get0Value();
145*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
146*b1cdbd2cSJim Jagielski }
147*b1cdbd2cSJim Jagielski
148*b1cdbd2cSJim Jagielski pResult->setRows(aRows);
149*b1cdbd2cSJim Jagielski return xRef;
150*b1cdbd2cSJim Jagielski }
151*b1cdbd2cSJim Jagielski
152*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
153*b1cdbd2cSJim Jagielski
getColumns(const Any &,const::rtl::OUString &,const::rtl::OUString & tableNamePattern,const::rtl::OUString & columnNamePattern)154*b1cdbd2cSJim Jagielski Reference< XResultSet > SAL_CALL OCalcDatabaseMetaData::getColumns(
155*b1cdbd2cSJim Jagielski const Any& /*catalog*/, const ::rtl::OUString& /*schemaPattern*/, const ::rtl::OUString& tableNamePattern,
156*b1cdbd2cSJim Jagielski const ::rtl::OUString& columnNamePattern ) throw(SQLException, RuntimeException)
157*b1cdbd2cSJim Jagielski {
158*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getColumns" );
159*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard( m_aMutex );
160*b1cdbd2cSJim Jagielski
161*b1cdbd2cSJim Jagielski
162*b1cdbd2cSJim Jagielski Reference< XTablesSupplier > xTables = m_pConnection->createCatalog();
163*b1cdbd2cSJim Jagielski if(!xTables.is())
164*b1cdbd2cSJim Jagielski throw SQLException();
165*b1cdbd2cSJim Jagielski
166*b1cdbd2cSJim Jagielski Reference< XNameAccess> xNames = xTables->getTables();
167*b1cdbd2cSJim Jagielski if(!xNames.is())
168*b1cdbd2cSJim Jagielski throw SQLException();
169*b1cdbd2cSJim Jagielski
170*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet::ORows aRows;
171*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet::ORow aRow(19);
172*b1cdbd2cSJim Jagielski
173*b1cdbd2cSJim Jagielski aRow[10] = new ORowSetValueDecorator((sal_Int32)10);
174*b1cdbd2cSJim Jagielski
175*b1cdbd2cSJim Jagielski Sequence< ::rtl::OUString> aTabNames(xNames->getElementNames());
176*b1cdbd2cSJim Jagielski const ::rtl::OUString* pTabIter = aTabNames.getConstArray();
177*b1cdbd2cSJim Jagielski const ::rtl::OUString* pTabEnd = pTabIter + aTabNames.getLength();
178*b1cdbd2cSJim Jagielski for(;pTabIter != pTabEnd;++pTabIter)
179*b1cdbd2cSJim Jagielski {
180*b1cdbd2cSJim Jagielski if(match(tableNamePattern,*pTabIter,'\0'))
181*b1cdbd2cSJim Jagielski {
182*b1cdbd2cSJim Jagielski const Reference< XColumnsSupplier> xTable(xNames->getByName(*pTabIter),UNO_QUERY_THROW);
183*b1cdbd2cSJim Jagielski OSL_ENSURE(xTable.is(),"Table not found! Normallya exception had to be thrown here!");
184*b1cdbd2cSJim Jagielski aRow[3] = new ORowSetValueDecorator(*pTabIter);
185*b1cdbd2cSJim Jagielski
186*b1cdbd2cSJim Jagielski const Reference< XNameAccess> xColumns = xTable->getColumns();
187*b1cdbd2cSJim Jagielski if(!xColumns.is())
188*b1cdbd2cSJim Jagielski throw SQLException();
189*b1cdbd2cSJim Jagielski
190*b1cdbd2cSJim Jagielski const Sequence< ::rtl::OUString> aColNames(xColumns->getElementNames());
191*b1cdbd2cSJim Jagielski
192*b1cdbd2cSJim Jagielski const ::rtl::OUString* pColumnIter = aColNames.getConstArray();
193*b1cdbd2cSJim Jagielski const ::rtl::OUString* pEnd = pColumnIter + aColNames.getLength();
194*b1cdbd2cSJim Jagielski Reference< XPropertySet> xColumn;
195*b1cdbd2cSJim Jagielski for(sal_Int32 i=1;pColumnIter != pEnd;++pColumnIter,++i)
196*b1cdbd2cSJim Jagielski {
197*b1cdbd2cSJim Jagielski if(match(columnNamePattern,*pColumnIter,'\0'))
198*b1cdbd2cSJim Jagielski {
199*b1cdbd2cSJim Jagielski aRow[4] = new ORowSetValueDecorator( *pColumnIter);
200*b1cdbd2cSJim Jagielski
201*b1cdbd2cSJim Jagielski xColumns->getByName(*pColumnIter) >>= xColumn;
202*b1cdbd2cSJim Jagielski OSL_ENSURE(xColumn.is(),"Columns contains a column who isn't a fastpropertyset!");
203*b1cdbd2cSJim Jagielski aRow[5] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))));
204*b1cdbd2cSJim Jagielski aRow[6] = new ORowSetValueDecorator(::comphelper::getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME))));
205*b1cdbd2cSJim Jagielski aRow[7] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION))));
206*b1cdbd2cSJim Jagielski // aRow[8] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
207*b1cdbd2cSJim Jagielski aRow[9] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE))));
208*b1cdbd2cSJim Jagielski aRow[11] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE))));
209*b1cdbd2cSJim Jagielski // aRow[12] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
210*b1cdbd2cSJim Jagielski aRow[13] = new ORowSetValueDecorator(::comphelper::getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE))));
211*b1cdbd2cSJim Jagielski // aRow[14] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
212*b1cdbd2cSJim Jagielski // aRow[15] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
213*b1cdbd2cSJim Jagielski switch(sal_Int32(aRow[5]->getValue()))
214*b1cdbd2cSJim Jagielski {
215*b1cdbd2cSJim Jagielski case DataType::CHAR:
216*b1cdbd2cSJim Jagielski case DataType::VARCHAR:
217*b1cdbd2cSJim Jagielski aRow[16] = new ORowSetValueDecorator((sal_Int32)254);
218*b1cdbd2cSJim Jagielski break;
219*b1cdbd2cSJim Jagielski case DataType::LONGVARCHAR:
220*b1cdbd2cSJim Jagielski aRow[16] = new ORowSetValueDecorator((sal_Int32)65535);
221*b1cdbd2cSJim Jagielski break;
222*b1cdbd2cSJim Jagielski default:
223*b1cdbd2cSJim Jagielski aRow[16] = new ORowSetValueDecorator((sal_Int32)0);
224*b1cdbd2cSJim Jagielski }
225*b1cdbd2cSJim Jagielski aRow[17] = new ORowSetValueDecorator(i);
226*b1cdbd2cSJim Jagielski switch(sal_Int32(aRow[11]->getValue()))
227*b1cdbd2cSJim Jagielski {
228*b1cdbd2cSJim Jagielski case ColumnValue::NO_NULLS:
229*b1cdbd2cSJim Jagielski aRow[18] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("NO"));
230*b1cdbd2cSJim Jagielski break;
231*b1cdbd2cSJim Jagielski case ColumnValue::NULLABLE:
232*b1cdbd2cSJim Jagielski aRow[18] = new ORowSetValueDecorator(::rtl::OUString::createFromAscii("YES"));
233*b1cdbd2cSJim Jagielski break;
234*b1cdbd2cSJim Jagielski default:
235*b1cdbd2cSJim Jagielski aRow[18] = new ORowSetValueDecorator(::rtl::OUString());
236*b1cdbd2cSJim Jagielski }
237*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
238*b1cdbd2cSJim Jagielski }
239*b1cdbd2cSJim Jagielski }
240*b1cdbd2cSJim Jagielski }
241*b1cdbd2cSJim Jagielski }
242*b1cdbd2cSJim Jagielski
243*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eColumns);
244*b1cdbd2cSJim Jagielski Reference< XResultSet > xRef = pResult;
245*b1cdbd2cSJim Jagielski pResult->setRows(aRows);
246*b1cdbd2cSJim Jagielski
247*b1cdbd2cSJim Jagielski return xRef;
248*b1cdbd2cSJim Jagielski }
249*b1cdbd2cSJim Jagielski
250*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
251*b1cdbd2cSJim Jagielski
getURL()252*b1cdbd2cSJim Jagielski ::rtl::OUString SAL_CALL OCalcDatabaseMetaData::getURL( ) throw(SQLException, RuntimeException)
253*b1cdbd2cSJim Jagielski {
254*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getURL" );
255*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard( m_aMutex );
256*b1cdbd2cSJim Jagielski
257*b1cdbd2cSJim Jagielski return ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("sdbc:calc:")) + m_pConnection->getURL();
258*b1cdbd2cSJim Jagielski }
259*b1cdbd2cSJim Jagielski
260*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
261*b1cdbd2cSJim Jagielski
getMaxBinaryLiteralLength()262*b1cdbd2cSJim Jagielski sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxBinaryLiteralLength( ) throw(SQLException, RuntimeException)
263*b1cdbd2cSJim Jagielski {
264*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxBinaryLiteralLength" );
265*b1cdbd2cSJim Jagielski return STRING_MAXLEN;
266*b1cdbd2cSJim Jagielski }
267*b1cdbd2cSJim Jagielski
268*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
269*b1cdbd2cSJim Jagielski
getMaxCharLiteralLength()270*b1cdbd2cSJim Jagielski sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxCharLiteralLength( ) throw(SQLException, RuntimeException)
271*b1cdbd2cSJim Jagielski {
272*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxCharLiteralLength" );
273*b1cdbd2cSJim Jagielski return STRING_MAXLEN;
274*b1cdbd2cSJim Jagielski }
275*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
getMaxColumnNameLength()276*b1cdbd2cSJim Jagielski sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxColumnNameLength( ) throw(SQLException, RuntimeException)
277*b1cdbd2cSJim Jagielski {
278*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxColumnNameLength" );
279*b1cdbd2cSJim Jagielski return STRING_MAXLEN;
280*b1cdbd2cSJim Jagielski }
281*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
getMaxColumnsInIndex()282*b1cdbd2cSJim Jagielski sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxColumnsInIndex( ) throw(SQLException, RuntimeException)
283*b1cdbd2cSJim Jagielski {
284*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxColumnsInIndex" );
285*b1cdbd2cSJim Jagielski return 1;
286*b1cdbd2cSJim Jagielski }
287*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
getMaxColumnsInTable()288*b1cdbd2cSJim Jagielski sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxColumnsInTable( ) throw(SQLException, RuntimeException)
289*b1cdbd2cSJim Jagielski {
290*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxColumnsInTable" );
291*b1cdbd2cSJim Jagielski return 256;
292*b1cdbd2cSJim Jagielski }
293*b1cdbd2cSJim Jagielski
294*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
295*b1cdbd2cSJim Jagielski
lcl_IsEmptyOrHidden(const Reference<XSpreadsheets> & xSheets,const::rtl::OUString & rName)296*b1cdbd2cSJim Jagielski sal_Bool lcl_IsEmptyOrHidden( const Reference<XSpreadsheets>& xSheets, const ::rtl::OUString& rName )
297*b1cdbd2cSJim Jagielski {
298*b1cdbd2cSJim Jagielski Any aAny = xSheets->getByName( rName );
299*b1cdbd2cSJim Jagielski Reference<XSpreadsheet> xSheet;
300*b1cdbd2cSJim Jagielski if ( aAny >>= xSheet )
301*b1cdbd2cSJim Jagielski {
302*b1cdbd2cSJim Jagielski // test if sheet is hidden
303*b1cdbd2cSJim Jagielski
304*b1cdbd2cSJim Jagielski Reference<XPropertySet> xProp( xSheet, UNO_QUERY );
305*b1cdbd2cSJim Jagielski if (xProp.is())
306*b1cdbd2cSJim Jagielski {
307*b1cdbd2cSJim Jagielski sal_Bool bVisible = sal_Bool();
308*b1cdbd2cSJim Jagielski Any aVisAny = xProp->getPropertyValue( ::rtl::OUString::createFromAscii("IsVisible") );
309*b1cdbd2cSJim Jagielski if ( aVisAny >>= bVisible )
310*b1cdbd2cSJim Jagielski if (!bVisible)
311*b1cdbd2cSJim Jagielski return sal_True; // hidden
312*b1cdbd2cSJim Jagielski }
313*b1cdbd2cSJim Jagielski
314*b1cdbd2cSJim Jagielski #if 0
315*b1cdbd2cSJim Jagielski // test if whole sheet is empty
316*b1cdbd2cSJim Jagielski
317*b1cdbd2cSJim Jagielski Reference<XCellRangeAddressable> xAddr( xSheet, UNO_QUERY );
318*b1cdbd2cSJim Jagielski Reference<XCellRangesQuery> xQuery( xSheet, UNO_QUERY );
319*b1cdbd2cSJim Jagielski if ( xAddr.is() && xQuery.is() )
320*b1cdbd2cSJim Jagielski {
321*b1cdbd2cSJim Jagielski CellRangeAddress aTotalRange = xAddr->getRangeAddress();
322*b1cdbd2cSJim Jagielski // queryIntersection to get a ranges object
323*b1cdbd2cSJim Jagielski Reference<XSheetCellRanges> xRanges = xQuery->queryIntersection( aTotalRange );
324*b1cdbd2cSJim Jagielski if (xRanges.is())
325*b1cdbd2cSJim Jagielski {
326*b1cdbd2cSJim Jagielski Reference<XEnumerationAccess> xCells = xRanges->getCells();
327*b1cdbd2cSJim Jagielski if (xCells.is())
328*b1cdbd2cSJim Jagielski {
329*b1cdbd2cSJim Jagielski if ( !xCells->hasElements() )
330*b1cdbd2cSJim Jagielski return sal_True; // empty
331*b1cdbd2cSJim Jagielski }
332*b1cdbd2cSJim Jagielski }
333*b1cdbd2cSJim Jagielski }
334*b1cdbd2cSJim Jagielski #endif
335*b1cdbd2cSJim Jagielski
336*b1cdbd2cSJim Jagielski // use the same data area as in OCalcTable to test for empty table
337*b1cdbd2cSJim Jagielski
338*b1cdbd2cSJim Jagielski Reference<XSheetCellCursor> xCursor = xSheet->createCursor();
339*b1cdbd2cSJim Jagielski Reference<XCellRangeAddressable> xRange( xCursor, UNO_QUERY );
340*b1cdbd2cSJim Jagielski if ( xRange.is() )
341*b1cdbd2cSJim Jagielski {
342*b1cdbd2cSJim Jagielski xCursor->collapseToSize( 1, 1 ); // single (first) cell
343*b1cdbd2cSJim Jagielski xCursor->collapseToCurrentRegion(); // contiguous data area
344*b1cdbd2cSJim Jagielski
345*b1cdbd2cSJim Jagielski CellRangeAddress aRangeAddr = xRange->getRangeAddress();
346*b1cdbd2cSJim Jagielski if ( aRangeAddr.StartColumn == aRangeAddr.EndColumn &&
347*b1cdbd2cSJim Jagielski aRangeAddr.StartRow == aRangeAddr.EndRow )
348*b1cdbd2cSJim Jagielski {
349*b1cdbd2cSJim Jagielski // single cell -> check content
350*b1cdbd2cSJim Jagielski Reference<XCell> xCell = xCursor->getCellByPosition( 0, 0 );
351*b1cdbd2cSJim Jagielski if ( xCell.is() && xCell->getType() == CellContentType_EMPTY )
352*b1cdbd2cSJim Jagielski return sal_True;
353*b1cdbd2cSJim Jagielski }
354*b1cdbd2cSJim Jagielski }
355*b1cdbd2cSJim Jagielski }
356*b1cdbd2cSJim Jagielski
357*b1cdbd2cSJim Jagielski return sal_False;
358*b1cdbd2cSJim Jagielski }
359*b1cdbd2cSJim Jagielski
lcl_IsUnnamed(const Reference<XDatabaseRanges> & xRanges,const::rtl::OUString & rName)360*b1cdbd2cSJim Jagielski sal_Bool lcl_IsUnnamed( const Reference<XDatabaseRanges>& xRanges, const ::rtl::OUString& rName )
361*b1cdbd2cSJim Jagielski {
362*b1cdbd2cSJim Jagielski sal_Bool bUnnamed = sal_False;
363*b1cdbd2cSJim Jagielski
364*b1cdbd2cSJim Jagielski Any aAny = xRanges->getByName( rName );
365*b1cdbd2cSJim Jagielski Reference<XDatabaseRange> xRange;
366*b1cdbd2cSJim Jagielski if ( aAny >>= xRange )
367*b1cdbd2cSJim Jagielski {
368*b1cdbd2cSJim Jagielski Reference<XPropertySet> xRangeProp( xRange, UNO_QUERY );
369*b1cdbd2cSJim Jagielski if ( xRangeProp.is() )
370*b1cdbd2cSJim Jagielski {
371*b1cdbd2cSJim Jagielski try
372*b1cdbd2cSJim Jagielski {
373*b1cdbd2cSJim Jagielski Any aUserAny = xRangeProp->getPropertyValue( ::rtl::OUString::createFromAscii("IsUserDefined") );
374*b1cdbd2cSJim Jagielski sal_Bool bUserDefined = sal_Bool();
375*b1cdbd2cSJim Jagielski if ( aUserAny >>= bUserDefined )
376*b1cdbd2cSJim Jagielski bUnnamed = !bUserDefined;
377*b1cdbd2cSJim Jagielski }
378*b1cdbd2cSJim Jagielski catch ( UnknownPropertyException& )
379*b1cdbd2cSJim Jagielski {
380*b1cdbd2cSJim Jagielski // optional property
381*b1cdbd2cSJim Jagielski }
382*b1cdbd2cSJim Jagielski }
383*b1cdbd2cSJim Jagielski }
384*b1cdbd2cSJim Jagielski
385*b1cdbd2cSJim Jagielski return bUnnamed;
386*b1cdbd2cSJim Jagielski }
387*b1cdbd2cSJim Jagielski
388*b1cdbd2cSJim Jagielski // -------------------------------------------------------------------------
389*b1cdbd2cSJim Jagielski
getTables(const Any &,const::rtl::OUString &,const::rtl::OUString & tableNamePattern,const Sequence<::rtl::OUString> & types)390*b1cdbd2cSJim Jagielski Reference< XResultSet > SAL_CALL OCalcDatabaseMetaData::getTables(
391*b1cdbd2cSJim Jagielski const Any& /*catalog*/, const ::rtl::OUString& /*schemaPattern*/,
392*b1cdbd2cSJim Jagielski const ::rtl::OUString& tableNamePattern, const Sequence< ::rtl::OUString >& types )
393*b1cdbd2cSJim Jagielski throw(SQLException, RuntimeException)
394*b1cdbd2cSJim Jagielski {
395*b1cdbd2cSJim Jagielski RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getTables" );
396*b1cdbd2cSJim Jagielski ::osl::MutexGuard aGuard( m_aMutex );
397*b1cdbd2cSJim Jagielski
398*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTables);
399*b1cdbd2cSJim Jagielski Reference< XResultSet > xRef = pResult;
400*b1cdbd2cSJim Jagielski
401*b1cdbd2cSJim Jagielski // check if ORowSetValue type is given
402*b1cdbd2cSJim Jagielski // when no types are given then we have to return all tables e.g. TABLE
403*b1cdbd2cSJim Jagielski
404*b1cdbd2cSJim Jagielski ::rtl::OUString aTable(::rtl::OUString::createFromAscii("TABLE"));
405*b1cdbd2cSJim Jagielski
406*b1cdbd2cSJim Jagielski sal_Bool bTableFound = sal_True;
407*b1cdbd2cSJim Jagielski sal_Int32 nLength = types.getLength();
408*b1cdbd2cSJim Jagielski if(nLength)
409*b1cdbd2cSJim Jagielski {
410*b1cdbd2cSJim Jagielski bTableFound = sal_False;
411*b1cdbd2cSJim Jagielski
412*b1cdbd2cSJim Jagielski const ::rtl::OUString* pIter = types.getConstArray();
413*b1cdbd2cSJim Jagielski const ::rtl::OUString* pEnd = pIter + nLength;
414*b1cdbd2cSJim Jagielski for(;pIter != pEnd;++pIter)
415*b1cdbd2cSJim Jagielski {
416*b1cdbd2cSJim Jagielski if(*pIter == aTable)
417*b1cdbd2cSJim Jagielski {
418*b1cdbd2cSJim Jagielski bTableFound = sal_True;
419*b1cdbd2cSJim Jagielski break;
420*b1cdbd2cSJim Jagielski }
421*b1cdbd2cSJim Jagielski }
422*b1cdbd2cSJim Jagielski }
423*b1cdbd2cSJim Jagielski if(!bTableFound)
424*b1cdbd2cSJim Jagielski return xRef;
425*b1cdbd2cSJim Jagielski
426*b1cdbd2cSJim Jagielski // get the sheet names from the document
427*b1cdbd2cSJim Jagielski
428*b1cdbd2cSJim Jagielski OCalcConnection::ODocHolder aDocHodler(((OCalcConnection*)m_pConnection));
429*b1cdbd2cSJim Jagielski Reference<XSpreadsheetDocument> xDoc = aDocHodler.getDoc();
430*b1cdbd2cSJim Jagielski if ( !xDoc.is() )
431*b1cdbd2cSJim Jagielski throw SQLException();
432*b1cdbd2cSJim Jagielski Reference<XSpreadsheets> xSheets = xDoc->getSheets();
433*b1cdbd2cSJim Jagielski if ( !xSheets.is() )
434*b1cdbd2cSJim Jagielski throw SQLException();
435*b1cdbd2cSJim Jagielski Sequence< ::rtl::OUString > aSheetNames = xSheets->getElementNames();
436*b1cdbd2cSJim Jagielski
437*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet::ORows aRows;
438*b1cdbd2cSJim Jagielski sal_Int32 nSheetCount = aSheetNames.getLength();
439*b1cdbd2cSJim Jagielski for (sal_Int32 nSheet=0; nSheet<nSheetCount; nSheet++)
440*b1cdbd2cSJim Jagielski {
441*b1cdbd2cSJim Jagielski ::rtl::OUString aName = aSheetNames[nSheet];
442*b1cdbd2cSJim Jagielski if ( !lcl_IsEmptyOrHidden( xSheets, aName ) && match(tableNamePattern,aName,'\0') )
443*b1cdbd2cSJim Jagielski {
444*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet::ORow aRow(3);
445*b1cdbd2cSJim Jagielski aRow.reserve(6);
446*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator(aName));
447*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator(aTable));
448*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
449*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
450*b1cdbd2cSJim Jagielski }
451*b1cdbd2cSJim Jagielski }
452*b1cdbd2cSJim Jagielski
453*b1cdbd2cSJim Jagielski // also use database ranges
454*b1cdbd2cSJim Jagielski
455*b1cdbd2cSJim Jagielski Reference<XPropertySet> xDocProp( xDoc, UNO_QUERY );
456*b1cdbd2cSJim Jagielski if ( xDocProp.is() )
457*b1cdbd2cSJim Jagielski {
458*b1cdbd2cSJim Jagielski Any aRangesAny = xDocProp->getPropertyValue( ::rtl::OUString::createFromAscii("DatabaseRanges") );
459*b1cdbd2cSJim Jagielski Reference<XDatabaseRanges> xRanges;
460*b1cdbd2cSJim Jagielski if ( aRangesAny >>= xRanges )
461*b1cdbd2cSJim Jagielski {
462*b1cdbd2cSJim Jagielski Sequence< ::rtl::OUString > aDBNames = xRanges->getElementNames();
463*b1cdbd2cSJim Jagielski sal_Int32 nDBCount = aDBNames.getLength();
464*b1cdbd2cSJim Jagielski for (sal_Int32 nRange=0; nRange<nDBCount; nRange++)
465*b1cdbd2cSJim Jagielski {
466*b1cdbd2cSJim Jagielski ::rtl::OUString aName = aDBNames[nRange];
467*b1cdbd2cSJim Jagielski if ( !lcl_IsUnnamed( xRanges, aName ) && match(tableNamePattern,aName,'\0') )
468*b1cdbd2cSJim Jagielski {
469*b1cdbd2cSJim Jagielski ODatabaseMetaDataResultSet::ORow aRow(3);
470*b1cdbd2cSJim Jagielski aRow.reserve(6);
471*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator(aName));
472*b1cdbd2cSJim Jagielski aRow.push_back(new ORowSetValueDecorator(aTable));
473*b1cdbd2cSJim Jagielski aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
474*b1cdbd2cSJim Jagielski aRows.push_back(aRow);
475*b1cdbd2cSJim Jagielski }
476*b1cdbd2cSJim Jagielski }
477*b1cdbd2cSJim Jagielski }
478*b1cdbd2cSJim Jagielski }
479*b1cdbd2cSJim Jagielski
480*b1cdbd2cSJim Jagielski pResult->setRows(aRows);
481*b1cdbd2cSJim Jagielski
482*b1cdbd2cSJim Jagielski return xRef;
483*b1cdbd2cSJim Jagielski }
484*b1cdbd2cSJim Jagielski // -----------------------------------------------------------------------------
485*b1cdbd2cSJim Jagielski
486*b1cdbd2cSJim Jagielski
487