connectivity/source/drivers/file/FColumns.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: FColumns.cxx,v $
  10  * $Revision: 1.9 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_connectivity.hxx"
  33 #include "file/FColumns.hxx"
  34 #include "connectivity/sdbcx/VColumn.hxx"
  35 #include <com/sun/star/sdbc/XRow.hpp>
  36 #include <com/sun/star/sdbc/XResultSet.hpp>
  37 #include <com/sun/star/sdbc/DataType.hpp>
  38 #include <com/sun/star/sdbc/ColumnValue.hpp>
  39 #include "file/FTable.hxx"
  40 #include <comphelper/property.hxx>
  41
  42 using namespace connectivity::file;
  43 using namespace connectivity;
  44 using namespace ::com::sun::star::beans;
  45 using namespace ::com::sun::star::uno;
  46 using namespace ::com::sun::star::sdbcx;
  47 using namespace ::com::sun::star::sdbc;
  48 using namespace ::com::sun::star::container;
  49 using namespace ::com::sun::star::lang;
  50
  51 typedef connectivity::sdbcx::OCollection OCollection_TYPE;
  52
  53 sdbcx::ObjectType OColumns::createObject(const ::rtl::OUString& _rName)
  54 {
  55
  56     Reference< XResultSet > xResult = m_pTable->getConnection()->getMetaData()->getColumns(Any(),
  57     m_pTable->getSchema(),m_pTable->getName(),_rName);
  58
  59     sdbcx::ObjectType xRet = NULL;
  60     if(xResult.is())
  61     {
  62         Reference< XRow > xRow(xResult,UNO_QUERY);
  63         while(xResult->next())
  64         {
  65             if(xRow->getString(4) == _rName)
  66             {
  67                 sdbcx::OColumn* pRet = new sdbcx::OColumn(_rName,
  68                                             xRow->getString(6),
  69                                             xRow->getString(13),
  70                                             xRow->getInt(11),
  71                                             xRow->getInt(7),
  72                                             xRow->getInt(9),
  73                                             xRow->getInt(5),
  74                                             sal_False,
  75                                             sal_False,
  76                                             sal_False,
  77                                             m_pTable->getConnection()->getMetaData()->storesMixedCaseQuotedIdentifiers());
  78                 xRet = pRet;
  79                 break;
  80             }
  81         }
  82     }
  83
  84     return xRet;
  85 }
  86 // -----------------------------------------------------------------------------
  87 void OColumns::impl_refresh() throw(RuntimeException)
  88 {
  89     m_pTable->refreshColumns();
  90 }
  91 // -----------------------------------------------------------------------------
  92
  93
  94
  95
  96