oox/source/xls/webquerybuffer.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: webquerybuffer.cxx,v $
  10  * $Revision: 1.4 $
  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 #include "oox/xls/webquerybuffer.hxx"
  32 #include "oox/helper/attributelist.hxx"
  33
  34 #define DEBUG_OOX_WEBQUERY_BUFFER 1
  35
  36 #if DEBUG_OOX_WEBQUERY_BUFFER
  37 #include <stdio.h>
  38 #endif
  39
  40 using ::rtl::OUString;
  41
  42 namespace oox {
  43 namespace xls {
  44
  45 const sal_Int32 Connection::CONNECTION_ODBC_SOURCE    = 1;
  46 const sal_Int32 Connection::CONNECTION_DAO_SOURCE     = 2;
  47 const sal_Int32 Connection::CONNECTION_FILE_SOURCE    = 3;
  48 const sal_Int32 Connection::CONNECTION_WEBQUERY       = 4;
  49 const sal_Int32 Connection::CONNECTION_OLEDB_SOURCE   = 5;
  50 const sal_Int32 Connection::CONNECTION_TEXT_SOURCE    = 6;
  51 const sal_Int32 Connection::CONNECTION_ADO_RECORD_SET = 7;
  52 const sal_Int32 Connection::CONNECTION_DSP            = 8;
  53
  54 // ============================================================================
  55
  56 WebQueryBuffer::WebQueryBuffer( const WorkbookHelper& rHelper ) :
  57     WorkbookHelper( rHelper )
  58 {
  59     maQueryTableMap.clear();
  60 }
  61
  62 void WebQueryBuffer::importQueryTable( const AttributeList& rAttribs )
  63 {
  64     OUString aName = rAttribs.getString( XML_name, OUString() );
  65     if ( !aName.getLength() )
  66         return;
  67
  68     QueryTable aQTable;
  69     aQTable.mnConnectionId = rAttribs.getInteger( XML_connectionId, 0 );
  70
  71     maQueryTableMap.insert( QueryTableHashMap::value_type( aName, aQTable ) );
  72
  73     // All documented attributes of queryTable:
  74     //   adjustColumnWidth (bool)
  75     //   applyAlignmentFormats (bool)
  76     //   applyBorderFormats (bool)
  77     //   applyFontFormats (bool)
  78     //   applyNumberFormats (bool)
  79     //   applyPatternFormats (bool)
  80     //   applyWidthHeightFormats (bool)
  81     //   autoFormatId (unsigned int)
  82     //   backgroundRefresh (bool)
  83     //   connectionId (unsigned int)
  84     //   disableEdit (bool)
  85     //   disableRefresh (bool)
  86     //   fillFormulas (bool)
  87     //   firstBackgroundRefresh (bool)
  88     //   growShrinkType (insertClear, insertDelete, overwriteClear)
  89     //   headers (bool)
  90     //   intermediate (bool)
  91     //   name (string)
  92     //   preserveFormatting(bool)
  93     //   refreshOnLoad (bool)
  94     //   removeDataOnSave (bool)
  95     //   rowNumbers (bool)
  96 }
  97
  98 void WebQueryBuffer::importConnection( const AttributeList& rAttribs )
  99 {
 100     if ( !rAttribs.hasAttribute( XML_id ) || !rAttribs.hasAttribute( XML_name ) )
 101     {
 102         mnCurConnId = -1;
 103         return;
 104     }
 105
 106     sal_uInt32 nId = rAttribs.getUnsigned( XML_id, 0 );
 107     if ( maConnections.size() < (nId + 1) )
 108         maConnections.resize(nId + 1);
 109
 110     Connection aConn;
 111     aConn.maName = rAttribs.getString( XML_name, OUString() );
 112     aConn.mnType = rAttribs.getInteger( XML_type, 0 );
 113     maConnections[nId] = aConn;
 114     mnCurConnId = nId;
 115
 116     // All documented attributes of connection.
 117     //   background (bool)
 118     //   credentials (integrated, none, prompt, stored)
 119     //   deleted (bool)
 120     //   description (string)
 121     //   id (unsigned int)
 122     //   interval (unsigned int)
 123     //   keepAlive (bool)
 124     //   minRefreshableVersion (unsigned byte)
 125     //   name (string)
 126     //   new (bool)
 127     //   odcFile (string)
 128     //   onlyUseConnectionFile (bool)
 129     //   reconnectionMethod (unsigned int)
 130     //   refreshedVersion (unsigned byte)
 131     //   refreshOnLoad (bool)
 132     //   saveData (bool)
 133     //   savePassword (bool)
 134     //   singleSignOnId (string)
 135     //   sourceFile (string)
 136     //   type (unsigned int)
 137 }
 138
 139 void WebQueryBuffer::importWebPr( const AttributeList& rAttribs )
 140 {
 141     if ( 0 > mnCurConnId )
 142         return;
 143
 144     Connection& rConn = maConnections[mnCurConnId];
 145     rConn.mpProperties.reset( new WebProperties );
 146     WebProperties* pWebPr = static_cast< WebProperties* >( rConn.mpProperties.get() );
 147     pWebPr->maURL = rAttribs.getString( XML_url, OUString() );
 148
 149     // All available attributes:
 150     //   consecutive (bool)
 151     //   editPage (string)
 152     //   firstRow (bool)
 153     //   htmlFormat (all, none, rtf)
 154     //   htmlTables (bool)
 155     //   parsePre (bool)
 156     //   post (string)
 157     //   sourceData (bool)
 158     //   textDates (bool)
 159     //   url (string)
 160     //   xl2000 (bool)
 161     //   xl97 (bool)
 162     //   xml (bool)
 163 }
 164
 165 void WebQueryBuffer::dump() const
 166 {
 167 #if DEBUG_OOX_WEBQUERY_BUFFER
 168     fprintf(stdout, "----------------------------------------\n");
 169     {
 170         using ::std::vector;
 171         vector< Connection >::const_iterator itr = maConnections.begin(), itrEnd = maConnections.end();
 172         sal_Int32 nId = 0;
 173         for (; itr != itrEnd; ++itr, ++nId)
 174         {
 175             if ( itr->mnType == Connection::CONNECTION_WEBQUERY )
 176             {
 177                 WebProperties* pWebPr = static_cast< WebProperties* >( itr->mpProperties.get() );
 178                 fprintf(stdout, "WebQueryBuffer::dump: id = %d  url = %s\n",
 179                         (int)nId,
 180                         OUStringToOString(pWebPr->maURL, RTL_TEXTENCODING_UTF8).getStr());
 181             }
 182         }
 183     }
 184
 185     QueryTableHashMap::const_iterator itr = maQueryTableMap.begin(), itrEnd = maQueryTableMap.end();
 186     for (; itr != itrEnd; ++itr)
 187     {
 188         fprintf(stdout, "WebQueryBuffer::dump: name = %s  connection ID = %d\n",
 189                 OUStringToOString(itr->first, RTL_TEXTENCODING_UTF8).getStr(),
 190                 (int)(itr->second.mnConnectionId));
 191     }
 192
 193     fprintf(stdout, "----------------------------------------\n");
 194     fflush(stdout);
 195 #endif
 196 }
 197
 198 // ============================================================================
 199
 200 } // namespace xls
 201 } // namespace oox
 202