/src/libreoffice/connectivity/source/commontools/FDatabaseMetaDataResultSetMetaData.cxx
Line | Count | Source |
1 | | /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ |
2 | | /* |
3 | | * This file is part of the LibreOffice project. |
4 | | * |
5 | | * This Source Code Form is subject to the terms of the Mozilla Public |
6 | | * License, v. 2.0. If a copy of the MPL was not distributed with this |
7 | | * file, You can obtain one at http://mozilla.org/MPL/2.0/. |
8 | | * |
9 | | * This file incorporates work covered by the following license notice: |
10 | | * |
11 | | * Licensed to the Apache Software Foundation (ASF) under one or more |
12 | | * contributor license agreements. See the NOTICE file distributed |
13 | | * with this work for additional information regarding copyright |
14 | | * ownership. The ASF licenses this file to you under the Apache |
15 | | * License, Version 2.0 (the "License"); you may not use this file |
16 | | * except in compliance with the License. You may obtain a copy of |
17 | | * the License at http://www.apache.org/licenses/LICENSE-2.0 . |
18 | | */ |
19 | | |
20 | | #include <FDatabaseMetaDataResultSetMetaData.hxx> |
21 | | #include <com/sun/star/sdbc/DataType.hpp> |
22 | | #include <com/sun/star/sdbc/ColumnValue.hpp> |
23 | | |
24 | | using namespace connectivity; |
25 | | using namespace ::com::sun::star::sdbc; |
26 | | |
27 | | ODatabaseMetaDataResultSetMetaData::~ODatabaseMetaDataResultSetMetaData() |
28 | 0 | { |
29 | 0 | } |
30 | | |
31 | | sal_Int32 SAL_CALL ODatabaseMetaDataResultSetMetaData::getColumnDisplaySize( sal_Int32 column ) |
32 | 0 | { |
33 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
34 | 0 | return (*m_mColumnsIter).second.getColumnDisplaySize(); |
35 | | |
36 | 0 | return 0; |
37 | 0 | } |
38 | | |
39 | | sal_Int32 SAL_CALL ODatabaseMetaDataResultSetMetaData::getColumnType( sal_Int32 column ) |
40 | 0 | { |
41 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
42 | 0 | return (*m_mColumnsIter).second.getColumnType(); |
43 | 0 | return 1; |
44 | 0 | } |
45 | | |
46 | | sal_Int32 SAL_CALL ODatabaseMetaDataResultSetMetaData::getColumnCount( ) |
47 | 0 | { |
48 | 0 | return m_mColumns.size(); |
49 | 0 | } |
50 | | |
51 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isCaseSensitive( sal_Int32 column ) |
52 | 0 | { |
53 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
54 | 0 | return (*m_mColumnsIter).second.isCaseSensitive(); |
55 | 0 | return true; |
56 | 0 | } |
57 | | |
58 | | OUString SAL_CALL ODatabaseMetaDataResultSetMetaData::getSchemaName( sal_Int32 /*column*/ ) |
59 | 0 | { |
60 | 0 | return OUString(); |
61 | 0 | } |
62 | | |
63 | | OUString SAL_CALL ODatabaseMetaDataResultSetMetaData::getColumnName( sal_Int32 column ) |
64 | 0 | { |
65 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
66 | 0 | return (*m_mColumnsIter).second.getColumnName(); |
67 | 0 | return OUString(); |
68 | 0 | } |
69 | | |
70 | | OUString SAL_CALL ODatabaseMetaDataResultSetMetaData::getTableName( sal_Int32 column ) |
71 | 0 | { |
72 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
73 | 0 | return (*m_mColumnsIter).second.getTableName(); |
74 | 0 | return OUString(); |
75 | 0 | } |
76 | | |
77 | | OUString SAL_CALL ODatabaseMetaDataResultSetMetaData::getCatalogName( sal_Int32 /*column*/ ) |
78 | 0 | { |
79 | 0 | return OUString(); |
80 | 0 | } |
81 | | |
82 | | OUString SAL_CALL ODatabaseMetaDataResultSetMetaData::getColumnTypeName( sal_Int32 /*column*/ ) |
83 | 0 | { |
84 | 0 | return OUString(); |
85 | 0 | } |
86 | | |
87 | | OUString SAL_CALL ODatabaseMetaDataResultSetMetaData::getColumnLabel( sal_Int32 column ) |
88 | 0 | { |
89 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
90 | 0 | return (*m_mColumnsIter).second.getColumnLabel(); |
91 | 0 | return getColumnName(column); |
92 | 0 | } |
93 | | |
94 | | OUString SAL_CALL ODatabaseMetaDataResultSetMetaData::getColumnServiceName( sal_Int32 /*column*/ ) |
95 | 0 | { |
96 | 0 | return OUString(); |
97 | 0 | } |
98 | | |
99 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isCurrency( sal_Int32 column ) |
100 | 0 | { |
101 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
102 | 0 | return (*m_mColumnsIter).second.isCurrency(); |
103 | 0 | return false; |
104 | 0 | } |
105 | | |
106 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isAutoIncrement( sal_Int32 column ) |
107 | 0 | { |
108 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
109 | 0 | return (*m_mColumnsIter).second.isAutoIncrement(); |
110 | 0 | return false; |
111 | 0 | } |
112 | | |
113 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isSigned( sal_Int32 column ) |
114 | 0 | { |
115 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
116 | 0 | return (*m_mColumnsIter).second.isSigned(); |
117 | 0 | return false; |
118 | 0 | } |
119 | | |
120 | | sal_Int32 SAL_CALL ODatabaseMetaDataResultSetMetaData::getPrecision( sal_Int32 column ) |
121 | 0 | { |
122 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
123 | 0 | return (*m_mColumnsIter).second.getPrecision(); |
124 | 0 | return 0; |
125 | 0 | } |
126 | | |
127 | | sal_Int32 SAL_CALL ODatabaseMetaDataResultSetMetaData::getScale( sal_Int32 column ) |
128 | 0 | { |
129 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
130 | 0 | return (*m_mColumnsIter).second.getScale(); |
131 | | |
132 | 0 | return 0; |
133 | 0 | } |
134 | | |
135 | | sal_Int32 SAL_CALL ODatabaseMetaDataResultSetMetaData::isNullable( sal_Int32 column ) |
136 | 0 | { |
137 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
138 | 0 | return (*m_mColumnsIter).second.isNullable(); |
139 | | |
140 | 0 | return sal_Int32(false); |
141 | 0 | } |
142 | | |
143 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isSearchable( sal_Int32 column ) |
144 | 0 | { |
145 | 0 | if((m_mColumnsIter = m_mColumns.find(column)) != m_mColumns.end()) |
146 | 0 | return (*m_mColumnsIter).second.isSearchable(); |
147 | 0 | return true; |
148 | 0 | } |
149 | | |
150 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isReadOnly( sal_Int32 /*column*/ ) |
151 | 0 | { |
152 | 0 | return true; |
153 | 0 | } |
154 | | |
155 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isDefinitelyWritable( sal_Int32 /*column*/ ) |
156 | 0 | { |
157 | 0 | return false; |
158 | 0 | } |
159 | | |
160 | | sal_Bool SAL_CALL ODatabaseMetaDataResultSetMetaData::isWritable( sal_Int32 column ) |
161 | 0 | { |
162 | 0 | return isDefinitelyWritable(column); |
163 | 0 | } |
164 | | |
165 | | void ODatabaseMetaDataResultSetMetaData::setColumnPrivilegesMap() |
166 | 0 | { |
167 | 0 | setColumnMap(); |
168 | 0 | m_mColumns[5] = OColumn(OUString(),u"GRANTOR"_ustr, ColumnValue::NULLABLE, 3,3,0, DataType::VARCHAR); |
169 | 0 | m_mColumns[6] = OColumn(OUString(),u"GRANTEE"_ustr, ColumnValue::NULLABLE, 3,3,0, DataType::VARCHAR); |
170 | 0 | m_mColumns[7] = OColumn(OUString(),u"PRIVILEGE"_ustr, ColumnValue::NULLABLE, 3,3,0, DataType::VARCHAR); |
171 | 0 | m_mColumns[8] = OColumn(OUString(),u"IS_GRANTABLE"_ustr, ColumnValue::NULLABLE, 3,3,0, DataType::VARCHAR); |
172 | 0 | } |
173 | | |
174 | | void ODatabaseMetaDataResultSetMetaData::setTableNameMap() |
175 | 0 | { |
176 | 0 | m_mColumns[1] = OColumn(OUString(),u"TABLE_CAT"_ustr, ColumnValue::NULLABLE, 3,3,0, DataType::VARCHAR); |
177 | 0 | m_mColumns[2] = OColumn(OUString(),u"TABLE_SCHEM"_ustr, ColumnValue::NULLABLE, 3,3,0, DataType::VARCHAR); |
178 | 0 | m_mColumns[3] = OColumn(OUString(),u"TABLE_NAME"_ustr, ColumnValue::NO_NULLS, 3,3,0, DataType::VARCHAR); |
179 | 0 | } |
180 | | |
181 | | void ODatabaseMetaDataResultSetMetaData::setColumnMap() |
182 | 0 | { |
183 | 0 | setTableNameMap(); |
184 | 0 | m_mColumns[4] = OColumn(OUString(),u"COLUMN_NAME"_ustr, ColumnValue::NO_NULLS, 3,3,0, DataType::VARCHAR); |
185 | 0 | } |
186 | | |
187 | | void ODatabaseMetaDataResultSetMetaData::setColumnsMap() |
188 | 0 | { |
189 | 0 | setColumnMap(); |
190 | |
|
191 | 0 | m_mColumns[5] = OColumn(OUString(),u"DATA_TYPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
192 | 0 | m_mColumns[6] = OColumn(OUString(),u"TYPE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
193 | 0 | m_mColumns[7] = OColumn(OUString(),u"COLUMN_SIZE"_ustr, ColumnValue::NO_NULLS, 3,3,0, DataType::INTEGER); |
194 | 0 | m_mColumns[8] = OColumn(OUString(),u"BUFFER_LENGTH"_ustr, ColumnValue::NULLABLE, 3,3,0, DataType::INTEGER); |
195 | 0 | m_mColumns[9] = OColumn(OUString(),u"DECIMAL_DIGITS"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
196 | 0 | m_mColumns[10] = OColumn(OUString(),u"NUM_PREC_RADIX"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
197 | 0 | m_mColumns[11] = OColumn(OUString(),u"NULLABLE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
198 | 0 | m_mColumns[12] = OColumn(OUString(),u"REMARKS"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
199 | 0 | m_mColumns[13] = OColumn(OUString(),u"COLUMN_DEF"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
200 | 0 | m_mColumns[14] = OColumn(OUString(),u"SQL_DATA_TYPE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
201 | 0 | m_mColumns[15] = OColumn(OUString(),u"SQL_DATETIME_SUB"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
202 | 0 | m_mColumns[16] = OColumn(OUString(),u"CHAR_OCTET_LENGTH"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
203 | 0 | m_mColumns[17] = OColumn(OUString(),u"ORDINAL_POSITION"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
204 | 0 | m_mColumns[18] = OColumn(OUString(),u"IS_NULLABLE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::VARCHAR); |
205 | 0 | } |
206 | | |
207 | | void ODatabaseMetaDataResultSetMetaData::setTablesMap() |
208 | 0 | { |
209 | 0 | setTableNameMap(); |
210 | 0 | m_mColumns[4] = OColumn(OUString(),u"TABLE_TYPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
211 | 0 | m_mColumns[5] = OColumn(OUString(),u"REMARKS"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
212 | 0 | } |
213 | | |
214 | | void ODatabaseMetaDataResultSetMetaData::setProcedureNameMap() |
215 | 0 | { |
216 | 0 | m_mColumns[1] = OColumn(OUString(),u"PROCEDURE_CAT"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
217 | 0 | m_mColumns[2] = OColumn(OUString(),u"PROCEDURE_SCHEM"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
218 | 0 | m_mColumns[3] = OColumn(OUString(),u"PROCEDURE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
219 | 0 | } |
220 | | |
221 | | void ODatabaseMetaDataResultSetMetaData::setProcedureColumnsMap() |
222 | 0 | { |
223 | 0 | setProcedureNameMap(); |
224 | 0 | m_mColumns[4] = OColumn(OUString(),u"COLUMN_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
225 | 0 | m_mColumns[5] = OColumn(OUString(),u"COLUMN_TYPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
226 | 0 | m_mColumns[6] = OColumn(OUString(),u"DATA_TYPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
227 | 0 | m_mColumns[7] = OColumn(OUString(),u"TYPE_NAME"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
228 | 0 | m_mColumns[8] = OColumn(OUString(),u"PRECISION"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
229 | 0 | m_mColumns[9] = OColumn(OUString(),u"LENGTH"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
230 | 0 | m_mColumns[10] = OColumn(OUString(),u"SCALE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
231 | 0 | m_mColumns[11] = OColumn(OUString(),u"RADIX"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
232 | 0 | m_mColumns[12] = OColumn(OUString(),u"NULLABLE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
233 | 0 | m_mColumns[13] = OColumn(OUString(),u"REMARKS"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
234 | 0 | } |
235 | | |
236 | | void ODatabaseMetaDataResultSetMetaData::setPrimaryKeysMap() |
237 | 0 | { |
238 | 0 | setColumnMap(); |
239 | 0 | m_mColumns[5] = OColumn(OUString(),u"KEY_SEQ"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
240 | 0 | m_mColumns[6] = OColumn(OUString(),u"PK_NAME"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
241 | 0 | } |
242 | | |
243 | | void ODatabaseMetaDataResultSetMetaData::setIndexInfoMap() |
244 | 0 | { |
245 | 0 | setTableNameMap(); |
246 | 0 | m_mColumns[4] = OColumn(OUString(),u"NON_UNIQUE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::BIT); |
247 | 0 | m_mColumns[5] = OColumn(OUString(),u"INDEX_QUALIFIER"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
248 | 0 | m_mColumns[6] = OColumn(OUString(),u"INDEX_NAME"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
249 | 0 | m_mColumns[7] = OColumn(OUString(),u"TYPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
250 | 0 | m_mColumns[8] = OColumn(OUString(),u"ORDINAL_POSITION"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
251 | 0 | m_mColumns[9] = OColumn(OUString(),u"COLUMN_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
252 | 0 | m_mColumns[10] = OColumn(OUString(),u"ASC_OR_DESC"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
253 | 0 | m_mColumns[11] = OColumn(OUString(),u"CARDINALITY"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
254 | 0 | m_mColumns[12] = OColumn(OUString(),u"PAGES"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
255 | 0 | m_mColumns[13] = OColumn(OUString(),u"FILTER_CONDITION"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
256 | 0 | } |
257 | | |
258 | | void ODatabaseMetaDataResultSetMetaData::setTablePrivilegesMap() |
259 | 0 | { |
260 | 0 | setTableNameMap(); |
261 | 0 | m_mColumns[4] = OColumn(OUString(),u"GRANTOR"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
262 | 0 | m_mColumns[5] = OColumn(OUString(),u"GRANTEE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
263 | 0 | m_mColumns[6] = OColumn(OUString(),u"PRIVILEGE"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
264 | 0 | m_mColumns[7] = OColumn(OUString(),u"IS_GRANTABLE"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
265 | 0 | } |
266 | | |
267 | | void ODatabaseMetaDataResultSetMetaData::setCrossReferenceMap() |
268 | 0 | { |
269 | 0 | m_mColumns[1] = OColumn(OUString(),u"PKTABLE_CAT"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
270 | 0 | m_mColumns[2] = OColumn(OUString(),u"PKTABLE_SCHEM"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
271 | 0 | m_mColumns[3] = OColumn(OUString(),u"PKTABLE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
272 | 0 | m_mColumns[4] = OColumn(OUString(),u"PKCOLUMN_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
273 | 0 | m_mColumns[5] = OColumn(OUString(),u"FKTABLE_CAT"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
274 | 0 | m_mColumns[6] = OColumn(OUString(),u"FKTABLE_SCHEM"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
275 | 0 | m_mColumns[7] = OColumn(OUString(),u"FKTABLE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
276 | 0 | m_mColumns[8] = OColumn(OUString(),u"FKCOLUMN_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
277 | |
|
278 | 0 | m_mColumns[9] = OColumn(OUString(),u"KEY_SEQ"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
279 | 0 | m_mColumns[10] = OColumn(OUString(),u"UPDATE_RULE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
280 | 0 | m_mColumns[11] = OColumn(OUString(),u"DELETE_RULE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
281 | 0 | m_mColumns[12] = OColumn(OUString(),u"FK_NAME"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
282 | 0 | m_mColumns[13] = OColumn(OUString(),u"PK_NAME"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
283 | 0 | m_mColumns[14] = OColumn(OUString(),u"DEFERRABILITY"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
284 | 0 | } |
285 | | |
286 | | void ODatabaseMetaDataResultSetMetaData::setTypeInfoMap() |
287 | 0 | { |
288 | 0 | m_mColumns[1] = OColumn(OUString(),u"TYPE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
289 | 0 | m_mColumns[2] = OColumn(OUString(),u"DATA_TYPE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
290 | 0 | m_mColumns[3] = OColumn(OUString(),u"PRECISION"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
291 | 0 | m_mColumns[4] = OColumn(OUString(),u"LITERAL_PREFIX"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
292 | 0 | m_mColumns[5] = OColumn(OUString(),u"LITERAL_SUFFIX"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
293 | 0 | m_mColumns[6] = OColumn(OUString(),u"CREATE_PARAMS"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
294 | 0 | m_mColumns[7] = OColumn(OUString(),u"NULLABLE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
295 | 0 | m_mColumns[8] = OColumn(OUString(),u"CASE_SENSITIVE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::BIT); |
296 | 0 | m_mColumns[9] = OColumn(OUString(),u"SEARCHABLE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
297 | 0 | m_mColumns[10] = OColumn(OUString(),u"UNSIGNED_ATTRIBUTE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::BIT); |
298 | 0 | m_mColumns[11] = OColumn(OUString(),u"FIXED_PREC_SCALE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::BIT); |
299 | 0 | m_mColumns[12] = OColumn(OUString(),u"AUTO_INCREMENT"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::BIT); |
300 | 0 | m_mColumns[13] = OColumn(OUString(),u"LOCAL_TYPE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
301 | 0 | m_mColumns[14] = OColumn(OUString(),u"MINIMUM_SCALE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
302 | 0 | m_mColumns[15] = OColumn(OUString(),u"MAXIMUM_SCALE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
303 | 0 | m_mColumns[16] = OColumn(OUString(),u"SQL_DATA_TYPE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
304 | 0 | m_mColumns[17] = OColumn(OUString(),u"SQL_DATETIME_SUB"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
305 | 0 | m_mColumns[18] = OColumn(OUString(),u"NUM_PREC_RADIX"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
306 | 0 | } |
307 | | |
308 | | void ODatabaseMetaDataResultSetMetaData::setProceduresMap() |
309 | 0 | { |
310 | 0 | setProcedureNameMap(); |
311 | 0 | m_mColumns[4] = OColumn(OUString(),u"RESERVED1"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
312 | 0 | m_mColumns[5] = OColumn(OUString(),u"RESERVED2"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
313 | 0 | m_mColumns[6] = OColumn(OUString(),u"RESERVED3"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
314 | 0 | m_mColumns[7] = OColumn(OUString(),u"REMARKS"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
315 | 0 | m_mColumns[8] = OColumn(OUString(),u"PROCEDURE_TYPE"_ustr, ColumnValue::NO_NULLS, 1,1,0, DataType::INTEGER); |
316 | 0 | } |
317 | | |
318 | | void ODatabaseMetaDataResultSetMetaData::setTableTypes() |
319 | 0 | { |
320 | 0 | m_mColumns[1] = OColumn(OUString(),u"TABLE_TYPE"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
321 | 0 | } |
322 | | |
323 | | void ODatabaseMetaDataResultSetMetaData::setCatalogsMap() |
324 | 0 | { |
325 | 0 | m_mColumns[1] = OColumn(OUString(),u"TABLE_CAT"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
326 | 0 | } |
327 | | |
328 | | void ODatabaseMetaDataResultSetMetaData::setSchemasMap() |
329 | 0 | { |
330 | 0 | m_mColumns[1] = OColumn(OUString(),u"TABLE_SCHEM"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
331 | 0 | } |
332 | | |
333 | | void ODatabaseMetaDataResultSetMetaData::setVersionColumnsMap() |
334 | 0 | { |
335 | 0 | m_mColumns[1] = OColumn(OUString(),u"SCOPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
336 | 0 | m_mColumns[2] = OColumn(OUString(),u"COLUMN_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
337 | 0 | m_mColumns[3] = OColumn(OUString(),u"DATA_TYPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
338 | 0 | m_mColumns[4] = OColumn(OUString(),u"TYPE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
339 | 0 | m_mColumns[5] = OColumn(OUString(),u"COLUMN_SIZE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
340 | 0 | m_mColumns[6] = OColumn(OUString(),u"BUFFER_LENGTH"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
341 | 0 | m_mColumns[7] = OColumn(OUString(),u"DECIMAL_DIGITS"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::INTEGER); |
342 | 0 | m_mColumns[8] = OColumn(OUString(),u"PSEUDO_COLUMN"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::INTEGER); |
343 | 0 | } |
344 | | |
345 | | void ODatabaseMetaDataResultSetMetaData::setUDTsMap() |
346 | 0 | { |
347 | 0 | m_mColumns[1] = OColumn(OUString(),u"TYPE_CAT"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
348 | 0 | m_mColumns[2] = OColumn(OUString(),u"TYPE_SCHEM"_ustr, ColumnValue::NULLABLE, 0,0,0, DataType::VARCHAR); |
349 | 0 | m_mColumns[3] = OColumn(OUString(),u"TYPE_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
350 | 0 | m_mColumns[4] = OColumn(OUString(),u"CLASS_NAME"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
351 | 0 | m_mColumns[5] = OColumn(OUString(),u"DATA_TYPE"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
352 | 0 | m_mColumns[6] = OColumn(OUString(),u"REMARKS"_ustr, ColumnValue::NO_NULLS, 0,0,0, DataType::VARCHAR); |
353 | 0 | } |
354 | | |
355 | | /* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |