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
|
/* -*- 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 DBAUI_TYPEINFO_HXX
#define DBAUI_TYPEINFO_HXX
#include <rtl/ustring.hxx>
#include <com/sun/star/sdbc/DataType.hpp>
#include <com/sun/star/sdbc/ColumnSearch.hpp>
#include <com/sun/star/sdbc/ColumnValue.hpp>
#include <boost/shared_ptr.hpp>
#include <map>
namespace dbaui
{
//========================================================================
// Anhand dieser Ids werden die sprachabhaengigen ::rtl::OUString aus der Resource geholt
const sal_uInt16 TYPE_UNKNOWN = 0;
const sal_uInt16 TYPE_TEXT = 1;
const sal_uInt16 TYPE_NUMERIC = 2;
const sal_uInt16 TYPE_DATETIME = 3;
const sal_uInt16 TYPE_DATE = 4;
const sal_uInt16 TYPE_TIME = 5;
const sal_uInt16 TYPE_BOOL = 6;
const sal_uInt16 TYPE_CURRENCY = 7;
const sal_uInt16 TYPE_MEMO = 8;
const sal_uInt16 TYPE_COUNTER = 9;
const sal_uInt16 TYPE_IMAGE = 10;
const sal_uInt16 TYPE_CHAR = 11;
const sal_uInt16 TYPE_DECIMAL = 12;
const sal_uInt16 TYPE_BINARY = 13;
const sal_uInt16 TYPE_VARBINARY = 14;
const sal_uInt16 TYPE_BIGINT = 15;
const sal_uInt16 TYPE_DOUBLE = 16;
const sal_uInt16 TYPE_FLOAT = 17;
const sal_uInt16 TYPE_REAL = 18;
const sal_uInt16 TYPE_INTEGER = 19;
const sal_uInt16 TYPE_SMALLINT = 20;
const sal_uInt16 TYPE_TINYINT = 21;
const sal_uInt16 TYPE_SQLNULL = 22;
const sal_uInt16 TYPE_OBJECT = 23;
const sal_uInt16 TYPE_DISTINCT = 24;
const sal_uInt16 TYPE_STRUCT = 25;
const sal_uInt16 TYPE_ARRAY = 26;
const sal_uInt16 TYPE_BLOB = 27;
const sal_uInt16 TYPE_CLOB = 28;
const sal_uInt16 TYPE_REF = 29;
const sal_uInt16 TYPE_OTHER = 30;
const sal_uInt16 TYPE_BIT = 31;
class OTypeInfo
{
public:
::rtl::OUString aUIName; // the name which is the user see (a combination of resource text and aTypeName)
::rtl::OUString aTypeName; // Name des Types in der Datenbank
::rtl::OUString aLiteralPrefix; // Prefix zum Quoten
::rtl::OUString aLiteralSuffix; // Suffix zum Quoten
::rtl::OUString aCreateParams; // Parameter zum Erstellen
::rtl::OUString aLocalTypeName;
sal_Int32 nPrecision; // Laenge des Types
sal_Int32 nType; // Datenbanktyp
sal_Int16 nMaximumScale; // Nachkommastellen
sal_Int16 nMinimumScale; // Min Nachkommastellen
sal_Int16 nSearchType; // kann nach dem Typen gesucht werden
sal_Bool bCurrency : 1, // Waehrung
bAutoIncrement : 1, // Ist es ein automatisch incrementierendes Feld
bNullable : 1, // Kann das Feld NULL annehmen
bCaseSensitive : 1, // Ist der Type Casesensitive
bUnsigned : 1; // Ist der Type Unsigned
OTypeInfo()
:nPrecision(0)
,nType(::com::sun::star::sdbc::DataType::OTHER)
,nMaximumScale(0)
,nMinimumScale(0)
,nSearchType(::com::sun::star::sdbc::ColumnSearch::FULL)
,bCurrency(sal_False)
,bAutoIncrement(sal_False)
,bNullable(sal_True)
,bCaseSensitive(sal_False)
,bUnsigned(sal_False)
{}
sal_Bool operator == (const OTypeInfo& lh) const { return lh.nType == nType; }
sal_Bool operator != (const OTypeInfo& lh) const { return lh.nType != nType; }
inline ::rtl::OUString getDBName() const { return aTypeName; }
};
typedef ::boost::shared_ptr<OTypeInfo> TOTypeInfoSP;
typedef ::std::multimap<sal_Int32,TOTypeInfoSP> OTypeInfoMap;
/** return the most suitable typeinfo for a requested type
@param _rTypeInfo contains a map of type to typeinfo
@param _nType the requested type
@param _sTypeName the typename
@param _sCreateParams the create params
@param _nPrecision the precision
@param _nScale the scale
@param _bAutoIncrement if it is a auto increment
@param _brForceToType true when type was found which has some differenes
*/
TOTypeInfoSP getTypeInfoFromType(const OTypeInfoMap& _rTypeInfo,
sal_Int32 _nType,
const ::rtl::OUString& _sTypeName,
const ::rtl::OUString& _sCreateParams,
sal_Int32 _nPrecision,
sal_Int32 _nScale,
sal_Bool _bAutoIncrement,
sal_Bool& _brForceToType);
}
#endif // DBAUI_TYPEINFO_HXX
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|