blob: 22c91bc15d1ffd506ab5fe2aa1a538a87cb5c284 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
/*************************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2000, 2010 Oracle and/or its affiliates.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************/
#ifndef OOX_XLS_WEBQUERYBUFFER_HXX
#define OOX_XLS_WEBQUERYBUFFER_HXX
#include <vector>
#include <hash_map>
#include <boost/shared_ptr.hpp>
#include <com/sun/star/table/CellRangeAddress.hpp>
#include "oox/xls/workbookhelper.hxx"
namespace oox {
namespace xls {
// ============================================================================
struct QueryTable
{
sal_Int32 mnConnectionId;
};
// struct WebQuery
// {
// enum WebQueryMode
// {
// xlWQUnknown, /// Not specified.
// xlWQDocument, /// Entire document.
// xlWQAllTables, /// All tables.
// xlWQSpecTables /// Specific tables.
// };
//
// ::rtl::OUString maURL; /// Source document URL.
// ::rtl::OUString maTables; /// List of source range names.
// ::com::sun::star::table::CellRangeAddress maDestRange; /// Destination range.
// WebQueryMode meMode; /// Current mode of web query.
// sal_uInt16 mnRefresh; /// Refresh time in minutes.
// };
struct BaseProperties
{
};
/** Stores web query properties from webPr element. */
struct WebProperties : public BaseProperties
{
::rtl::OUString maURL;
};
/** Stores text data source properties from textPr element. */
struct TextProperties : public BaseProperties
{
::rtl::OUString maSourceFile;
};
struct Connection
{
static const sal_Int32 CONNECTION_ODBC_SOURCE;
static const sal_Int32 CONNECTION_DAO_SOURCE;
static const sal_Int32 CONNECTION_FILE_SOURCE;
static const sal_Int32 CONNECTION_WEBQUERY;
static const sal_Int32 CONNECTION_OLEDB_SOURCE;
static const sal_Int32 CONNECTION_TEXT_SOURCE;
static const sal_Int32 CONNECTION_ADO_RECORD_SET;
static const sal_Int32 CONNECTION_DSP;
::rtl::OUString maName; /// Connection name (must be unique).
sal_Int32 mnType;
::boost::shared_ptr< BaseProperties > mpProperties;
};
// ============================================================================
typedef ::std::hash_map< ::rtl::OUString, QueryTable, ::rtl::OUStringHash, ::std::equal_to< ::rtl::OUString > > QueryTableHashMap;
class WebQueryBuffer : public WorkbookHelper
{
public:
explicit WebQueryBuffer( const WorkbookHelper& rHelper );
void importQueryTable( const AttributeList& rAttribs );
void importConnection( const AttributeList& rAttribs );
void importWebPr( const AttributeList& rAttribs );
/** Dumps content for debug purposes. */
void dump() const;
private:
QueryTableHashMap maQueryTableMap;
::std::vector< Connection > maConnections;
sal_Int32 mnCurConnId; /// Current connection ID.
};
// ============================================================================
} // namespace xls
} // namespace oox
#endif
|
