connectivity/source/drivers/mozab/MColumns.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: MColumns.cxx,v $
  10  * $Revision: 1.7 $
  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 "MColumns.hxx"
  34 #include "connectivity/sdbcx/VColumn.hxx"
  35 #include "connectivity/sdbcx/VColumn.hxx"
  36 #include <com/sun/star/sdbc/XRow.hpp>
  37 #include <com/sun/star/sdbc/XResultSet.hpp>
  38 #include <com/sun/star/sdbc/DataType.hpp>
  39 #include <com/sun/star/sdbc/ColumnValue.hpp>
  40 #include "MTable.hxx"
  41 #include "MTables.hxx"
  42 #include "MCatalog.hxx"
  43 #include <comphelper/types.hxx>
  44 #include "connectivity/dbtools.hxx"
  45
  46 using namespace ::comphelper;
  47
  48
  49 using namespace connectivity::mozab;
  50 using namespace connectivity::sdbcx;
  51 using namespace connectivity;
  52 using namespace ::com::sun::star::uno;
  53 using namespace ::com::sun::star::beans;
  54 //      using namespace ::com::sun::star::sdbcx;
  55 using namespace ::com::sun::star::sdbc;
  56 using namespace ::com::sun::star::container;
  57 using namespace ::com::sun::star::lang;
  58 typedef connectivity::sdbcx::OCollection OCollection_TYPE;
  59
  60 sdbcx::ObjectType OColumns::createObject(const ::rtl::OUString& _rName)
  61 {
  62     Reference< XResultSet > xResult = m_pTable->getConnection()->getMetaData()->getColumns(Any(),
  63     m_pTable->getSchema(),m_pTable->getTableName(),_rName);
  64
  65     sdbcx::ObjectType xRet = NULL;
  66     if(xResult.is())
  67     {
  68         Reference< XRow > xRow(xResult,UNO_QUERY);
  69         while(xResult->next())
  70         {
  71             if(xRow->getString(4) == _rName)
  72             {
  73                 sal_Int32 nType                         = xRow->getInt(5);
  74                 ::rtl::OUString sTypeName       = xRow->getString(6);
  75                 sal_Int32 nPrec                         = xRow->getInt(7);
  76
  77                 OColumn* pRet = new OColumn(_rName,
  78                                             sTypeName,
  79                                             xRow->getString(13),
  80                                             xRow->getInt(11),
  81                                             nPrec,
  82                                             xRow->getInt(9),
  83                                             nType,
  84                                             sal_False,sal_False,sal_False,sal_True);
  85                 xRet = pRet;
  86                 break;
  87             }
  88         }
  89     }
  90
  91     return xRet;
  92 }
  93
  94 // -------------------------------------------------------------------------
  95 void OColumns::impl_refresh() throw(RuntimeException)
  96 {
  97     m_pTable->refreshColumns();
  98 }
  99 // -----------------------------------------------------------------------------
 100
 101
 102