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
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#ifndef _CONNECTIVITY_DBASE_TABLE_HXX_
#define _CONNECTIVITY_DBASE_TABLE_HXX_
#include "file/FTable.hxx"
#include "connectivity/sdbcx/VColumn.hxx"
#include "connectivity/CommonTools.hxx"
#include <tools/urlobj.hxx>
namespace connectivity
{
namespace dbase
{
typedef file::OFileTable ODbaseTable_BASE;
class ODbaseConnection;
class ODbaseTable : public ODbaseTable_BASE
{
// The first byte of a dBase file specifies its type
public:
enum DBFType { dBaseIII = 0x03,
dBaseIV = 0x04,
dBaseV = 0x05,
VisualFoxPro = 0x30,
VisualFoxProAuto = 0x31, // Visual FoxPro with AutoIncrement field
dBaseFS = 0x43,
dBaseFSMemo = 0xB3,
dBaseIIIMemo = 0x83,
dBaseIVMemo = 0x8B,
dBaseIVMemoSQL = 0x8E,
FoxProMemo = 0xF5
};
enum DBFMemoType { MemodBaseIII = 0,
MemodBaseIV,
MemoFoxPro
};
private:
struct DBFHeader { /* Header struct */
DBFType db_typ; /* File type */
sal_uInt8 db_aedat[3]; /* Date of last change */
/* YY MM DD */
sal_uInt32 db_anz; /* Data set count */
sal_uInt16 db_kopf; /* Header length */
sal_uInt16 db_slng; /* Data set length */
sal_uInt8 db_frei[20]; /* Reserved */
};
struct DBFColumn { /* Column descriptors */
sal_uInt8 db_fnm[11]; /* Field name */
sal_uInt8 db_typ; /* Field type */
sal_uInt32 db_adr; /* Field address */
sal_uInt8 db_flng; /* Field length */
sal_uInt8 db_dez; /* Decimal places for N */
sal_uInt8 db_frei2[14]; /* Reserved */
};
struct DBFMemoHeader
{
DBFMemoType db_typ; /* File type */
sal_uInt32 db_next; /* Next free block */
sal_uInt16 db_size; /* Block size: dBase 3 fixed */
};
::std::vector<sal_Int32> m_aTypes; // holds all types for columns just to avoid to ask the propertyset
::std::vector<sal_Int32> m_aPrecisions; // same as above
::std::vector<sal_Int32> m_aScales;
::std::vector<sal_Int32> m_aRealFieldLengths;
DBFHeader m_aHeader;
DBFMemoHeader m_aMemoHeader;
SvStream* m_pMemoStream;
rtl_TextEncoding m_eEncoding;
sal_Bool m_bWriteableMemo;
void alterColumn(sal_Int32 index,
const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& descriptor ,
const ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XDataDescriptorFactory>& xOldColumn );
void readHeader();
void fillColumns();
OUString createTempFile();
void copyData(ODbaseTable* _pNewTable,sal_Int32 _nPos);
sal_Bool CreateFile(const INetURLObject& aFile, sal_Bool& bCreateMemo);
sal_Bool CreateMemoFile(const INetURLObject& aFile);
sal_Bool HasMemoFields() const { return m_aHeader.db_typ > dBaseIV;}
sal_Bool ReadMemoHeader();
sal_Bool ReadMemo(sal_Size nBlockNo, ORowSetValue& aVariable);
sal_Bool WriteMemo(const ORowSetValue& aVariable, sal_Size& rBlockNr);
sal_Bool WriteBuffer();
sal_Bool UpdateBuffer(OValueRefVector& rRow, OValueRefRow pOrgRow,const ::com::sun::star::uno::Reference< ::com::sun::star::container::XIndexAccess>& _xCols, bool bForceAllFields);
::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet> isUniqueByColumnName(sal_Int32 _nColumnPos);
void AllocBuffer();
void throwInvalidDbaseFormat();
void SAL_CALL renameImpl( const OUString& newName ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::ElementExistException, ::com::sun::star::uno::RuntimeException);
void throwInvalidColumnType(const sal_uInt16 _nErrorId,const OUString& _sColumnName);
protected:
virtual void FileClose();
// using ::connectivity::sdbcx::OTableDescriptor_BASE::rBHelper;
public:
virtual void refreshColumns();
virtual void refreshIndexes();
public:
ODbaseTable( sdbcx::OCollection* _pTables,ODbaseConnection* _pConnection);
ODbaseTable( sdbcx::OCollection* _pTables,ODbaseConnection* _pConnection,
const OUString& _Name,
const OUString& _Type,
const OUString& _Description = OUString(),
const OUString& _SchemaName = OUString(),
const OUString& _CatalogName = OUString()
);
void construct(); // can throw any exception
virtual sal_Int32 getCurrentLastPos() const;
virtual sal_Bool seekRow(IResultSetHelper::Movement eCursorPosition, sal_Int32 nOffset, sal_Int32& nCurPos);
virtual sal_Bool fetchRow(OValueRefRow& _rRow,const OSQLColumns& _rCols, sal_Bool _bUseTableDefs,sal_Bool bRetrieveData);
virtual ::com::sun::star::uno::Any SAL_CALL queryInterface( const ::com::sun::star::uno::Type & rType ) throw(::com::sun::star::uno::RuntimeException, std::exception);
//XTypeProvider
virtual ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL getTypes( ) throw(::com::sun::star::uno::RuntimeException, std::exception);
virtual void SAL_CALL disposing(void);
// com::sun::star::lang::XUnoTunnel
virtual sal_Int64 SAL_CALL getSomething( const ::com::sun::star::uno::Sequence< sal_Int8 >& aIdentifier ) throw(::com::sun::star::uno::RuntimeException, std::exception);
static ::com::sun::star::uno::Sequence< sal_Int8 > getUnoTunnelImplementationId();
// XAlterTable
virtual void SAL_CALL alterColumnByName( const OUString& colName, const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::NoSuchElementException, ::com::sun::star::uno::RuntimeException, std::exception);
virtual void SAL_CALL alterColumnByIndex( sal_Int32 index, const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::lang::IndexOutOfBoundsException, ::com::sun::star::uno::RuntimeException, std::exception);
// XRename
virtual void SAL_CALL rename( const OUString& newName ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::ElementExistException, ::com::sun::star::uno::RuntimeException, std::exception);
sal_Bool DropImpl();
sal_Bool CreateImpl();
virtual sal_Bool InsertRow(OValueRefVector& rRow, sal_Bool bFlush,const ::com::sun::star::uno::Reference< ::com::sun::star::container::XIndexAccess>& _xCols);
virtual sal_Bool DeleteRow(const OSQLColumns& _rCols);
virtual sal_Bool UpdateRow(OValueRefVector& rRow, OValueRefRow& pOrgRow,const ::com::sun::star::uno::Reference< ::com::sun::star::container::XIndexAccess>& _xCols);
virtual void addColumn(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& descriptor);
virtual void dropColumn(sal_Int32 _nPos);
static OUString getEntry(file::OConnection* _pConnection,const OUString& _sURL );
static sal_Bool Drop_Static(const OUString& _sUrl,sal_Bool _bHasMemoFields,sdbcx::OCollection* _pIndexes );
virtual void refreshHeader();
virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData> getMetaData() const;
};
}
}
#endif // _CONNECTIVITY_DBASE_TABLE_HXX_
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
