QGIS API Documentation 3.99.0-Master (f78f5286a64)
Loading...
Searching...
No Matches
qgsabstractdatabaseproviderconnection.cpp
Go to the documentation of this file.
1/***************************************************************************
2 qgsabstractdatabaseproviderconnection.cpp - QgsAbstractDatabaseProviderConnection
3
4 ---------------------
5 begin : 2.8.2019
6 copyright : (C) 2019 by Alessandro Pasotti
7 email : elpaso at itopen dot it
8 ***************************************************************************
9 * *
10 * This program is free software; you can redistribute it and/or modify *
11 * it under the terms of the GNU General Public License as published by *
12 * the Free Software Foundation; either version 2 of the License, or *
13 * (at your option) any later version. *
14 * *
15 ***************************************************************************/
16#include "qgsabstractdatabaseproviderconnection.h"
17#include "moc_qgsabstractdatabaseproviderconnection.cpp"
18#include "qgsvectorlayer.h"
19#include "qgsexception.h"
20#include "qgsweakrelation.h"
21#include "qgsfeedback.h"
22#include "qgsprovidersqlquerybuilder.h"
23
24#include <QVariant>
25#include <QObject>
26
32
33QgsAbstractDatabaseProviderConnection::QgsAbstractDatabaseProviderConnection( const QString &uri, const QVariantMap &configuration ):
34 QgsAbstractProviderConnection( uri, configuration )
35{
36
37}
38
43
48
53
58
59QString QgsAbstractDatabaseProviderConnection::createVectorLayerExporterDestinationUri( const VectorLayerExporterOptions &, QVariantMap & ) const
60{
61 throw QgsProviderConnectionException( QObject::tr( "Operation 'createVectorLayerExporterDestinationUri' is not supported" ) );
62}
63
64QString QgsAbstractDatabaseProviderConnection::tableUri( const QString &schema, const QString &name ) const
65{
66 Q_UNUSED( schema )
67 Q_UNUSED( name )
68 throw QgsProviderConnectionException( QObject::tr( "Operation 'tableUri' is not supported" ) );
69}
70
71
73void QgsAbstractDatabaseProviderConnection::checkCapability( QgsAbstractDatabaseProviderConnection::Capability capability ) const
74{
75 if ( ! mCapabilities.testFlag( capability ) )
76 {
77 static QMetaEnum metaEnum = QMetaEnum::fromType<QgsAbstractDatabaseProviderConnection::Capability>();
78 const QString capName { metaEnum.valueToKey( capability ) };
79 throw QgsProviderConnectionException( QObject::tr( "Operation '%1' is not supported for this connection" ).arg( capName ) );
80 }
81}
82
83void QgsAbstractDatabaseProviderConnection::checkCapability( Qgis::DatabaseProviderConnectionCapability2 capability ) const
84{
85 if ( ! mCapabilities2.testFlag( capability ) )
86 {
87 throw QgsProviderConnectionException( QObject::tr( "Operation '%1' is not supported for this connection" ).arg( qgsEnumValueToKey( capability ) ) );
88 }
89}
90
91QString QgsAbstractDatabaseProviderConnection::sanitizeSqlForQueryLayer( const QString &sql ) const
92{
93 QString sanitizedSql { sql.trimmed() };
94 while ( sanitizedSql.endsWith( ';' ) )
95 {
96 sanitizedSql.chop( 1 );
97 }
98 return sanitizedSql;
99}
100
102
107
108QMultiMap<Qgis::SqlKeywordCategory, QStringList> QgsAbstractDatabaseProviderConnection::sqlDictionary()
109{
110 return
111 {
112 // Common constants
113 {
114 Qgis::SqlKeywordCategory::Constant, {
115 QStringLiteral( "NULL" ),
116 QStringLiteral( "FALSE" ),
117 QStringLiteral( "TRUE" ),
118 }
119 },
120 // Common SQL reserved words
121 // From: GET https://en.wikipedia.org/wiki/SQL_reserved_words| grep 'style="background: #ececec; color: black; font-weight: bold;'| sed -e 's/.*>//'|sort
122 {
123 Qgis::SqlKeywordCategory::Keyword,
124 {
125 QStringLiteral( "ABORT " ),
126 QStringLiteral( "ABORTSESSION" ),
127 QStringLiteral( "ABS" ),
128 QStringLiteral( "ABSOLUTE" ),
129 QStringLiteral( "ACCESS" ),
130 QStringLiteral( "ACCESSIBLE" ),
131 QStringLiteral( "ACCESS_LOCK" ),
132 QStringLiteral( "ACCOUNT" ),
133 QStringLiteral( "ACOS" ),
134 QStringLiteral( "ACOSH" ),
135 QStringLiteral( "ACTION" ),
136 QStringLiteral( "ADD" ),
137 QStringLiteral( "ADD_MONTHS" ),
138 QStringLiteral( "ADMIN" ),
139 QStringLiteral( "AFTER" ),
140 QStringLiteral( "AGGREGATE" ),
141 QStringLiteral( "ALIAS" ),
142 QStringLiteral( "ALL" ),
143 QStringLiteral( "ALLOCATE" ),
144 QStringLiteral( "ALLOW" ),
145 QStringLiteral( "ALTER" ),
146 QStringLiteral( "ALTERAND" ),
147 QStringLiteral( "AMP" ),
148 QStringLiteral( "ANALYSE" ),
149 QStringLiteral( "ANALYZE" ),
150 QStringLiteral( "AND" ),
151 QStringLiteral( "ANSIDATE" ),
152 QStringLiteral( "ANY" ),
153 QStringLiteral( "ARE" ),
154 QStringLiteral( "ARRAY" ),
155 QStringLiteral( "ARRAY_AGG" ),
156 QStringLiteral( "ARRAY_EXISTS" ),
157 QStringLiteral( "ARRAY_MAX_CARDINALITY" ),
158 QStringLiteral( "AS" ),
159 QStringLiteral( "ASC" ),
160 QStringLiteral( "ASENSITIVE" ),
161 QStringLiteral( "ASIN" ),
162 QStringLiteral( "ASINH" ),
163 QStringLiteral( "ASSERTION" ),
164 QStringLiteral( "ASSOCIATE" ),
165 QStringLiteral( "ASUTIME" ),
166 QStringLiteral( "ASYMMETRIC" ),
167 QStringLiteral( "AT" ),
168 QStringLiteral( "ATAN" ),
169 QStringLiteral( "ATAN2" ),
170 QStringLiteral( "ATANH" ),
171 QStringLiteral( "ATOMIC" ),
172 QStringLiteral( "AUDIT" ),
173 QStringLiteral( "AUTHORIZATION" ),
174 QStringLiteral( "AUX" ),
175 QStringLiteral( "AUXILIARY" ),
176 QStringLiteral( "AVE" ),
177 QStringLiteral( "AVERAGE" ),
178 QStringLiteral( "AVG" ),
179 QStringLiteral( "BACKUP" ),
180 QStringLiteral( "BEFORE" ),
181 QStringLiteral( "BEGIN" ),
182 QStringLiteral( "BEGIN_FRAME" ),
183 QStringLiteral( "BEGIN_PARTITION" ),
184 QStringLiteral( "BETWEEN" ),
185 QStringLiteral( "BIGINT" ),
186 QStringLiteral( "BINARY" ),
187 QStringLiteral( "BIT" ),
188 QStringLiteral( "BLOB" ),
189 QStringLiteral( "BOOLEAN" ),
190 QStringLiteral( "BOTH" ),
191 QStringLiteral( "BREADTH" ),
192 QStringLiteral( "BREAK" ),
193 QStringLiteral( "BROWSE" ),
194 QStringLiteral( "BT" ),
195 QStringLiteral( "BUFFERPOOL" ),
196 QStringLiteral( "BULK" ),
197 QStringLiteral( "BUT" ),
198 QStringLiteral( "BY" ),
199 QStringLiteral( "BYTE" ),
200 QStringLiteral( "BYTEINT" ),
201 QStringLiteral( "BYTES" ),
202 QStringLiteral( "CALL" ),
203 QStringLiteral( "CALLED" ),
204 QStringLiteral( "CAPTURE" ),
205 QStringLiteral( "CARDINALITY" ),
206 QStringLiteral( "CASCADE" ),
207 QStringLiteral( "CASCADED" ),
208 QStringLiteral( "CASE" ),
209 QStringLiteral( "CASE_N" ),
210 QStringLiteral( "CASESPECIFIC" ),
211 QStringLiteral( "CAST" ),
212 QStringLiteral( "CATALOG" ),
213 QStringLiteral( "CCSID" ),
214 QStringLiteral( "CD" ),
215 QStringLiteral( "CEIL" ),
216 QStringLiteral( "CEILING" ),
217 QStringLiteral( "CHANGE" ),
218 QStringLiteral( "CHAR" ),
219 QStringLiteral( "CHAR2HEXINT" ),
220 QStringLiteral( "CHARACTER" ),
221 QStringLiteral( "CHARACTER_LENGTH" ),
222 QStringLiteral( "CHARACTERS" ),
223 QStringLiteral( "CHAR_LENGTH" ),
224 QStringLiteral( "CHARS" ),
225 QStringLiteral( "CHECK" ),
226 QStringLiteral( "CHECKPOINT" ),
227 QStringLiteral( "CLASS" ),
228 QStringLiteral( "CLASSIFIER" ),
229 QStringLiteral( "CLOB" ),
230 QStringLiteral( "CLONE" ),
231 QStringLiteral( "CLOSE" ),
232 QStringLiteral( "CLUSTER" ),
233 QStringLiteral( "CLUSTERED" ),
234 QStringLiteral( "CM" ),
235 QStringLiteral( "COALESCE" ),
236 QStringLiteral( "COLLATE" ),
237 QStringLiteral( "COLLATION" ),
238 QStringLiteral( "COLLECT" ),
239 QStringLiteral( "COLLECTION" ),
240 QStringLiteral( "COLLID" ),
241 QStringLiteral( "COLUMN" ),
242 QStringLiteral( "COLUMN_VALUE" ),
243 QStringLiteral( "COMMENT" ),
244 QStringLiteral( "COMMIT" ),
245 QStringLiteral( "COMPLETION" ),
246 QStringLiteral( "COMPRESS" ),
247 QStringLiteral( "COMPUTE" ),
248 QStringLiteral( "CONCAT" ),
249 QStringLiteral( "CONCURRENTLY" ),
250 QStringLiteral( "CONDITION" ),
251 QStringLiteral( "CONNECT" ),
252 QStringLiteral( "CONNECTION" ),
253 QStringLiteral( "CONSTRAINT" ),
254 QStringLiteral( "CONSTRAINTS" ),
255 QStringLiteral( "CONSTRUCTOR" ),
256 QStringLiteral( "CONTAINS" ),
257 QStringLiteral( "CONTAINSTABLE" ),
258 QStringLiteral( "CONTENT" ),
259 QStringLiteral( "CONTINUE" ),
260 QStringLiteral( "CONVERT" ),
261 QStringLiteral( "CONVERT_TABLE_HEADER" ),
262 QStringLiteral( "COPY" ),
263 QStringLiteral( "CORR" ),
264 QStringLiteral( "CORRESPONDING" ),
265 QStringLiteral( "COS" ),
266 QStringLiteral( "COSH" ),
267 QStringLiteral( "COUNT" ),
268 QStringLiteral( "COVAR_POP" ),
269 QStringLiteral( "COVAR_SAMP" ),
270 QStringLiteral( "CREATE" ),
271 QStringLiteral( "CROSS" ),
272 QStringLiteral( "CS" ),
273 QStringLiteral( "CSUM" ),
274 QStringLiteral( "CT" ),
275 QStringLiteral( "CUBE" ),
276 QStringLiteral( "CUME_DIST" ),
277 QStringLiteral( "CURRENT" ),
278 QStringLiteral( "CURRENT_CATALOG" ),
279 QStringLiteral( "CURRENT_DATE" ),
280 QStringLiteral( "CURRENT_DEFAULT_TRANSFORM_GROUP" ),
281 QStringLiteral( "CURRENT_LC_CTYPE" ),
282 QStringLiteral( "CURRENT_PATH" ),
283 QStringLiteral( "CURRENT_ROLE" ),
284 QStringLiteral( "CURRENT_ROW" ),
285 QStringLiteral( "CURRENT_SCHEMA" ),
286 QStringLiteral( "CURRENT_SERVER" ),
287 QStringLiteral( "CURRENT_TIME" ),
288 QStringLiteral( "CURRENT_TIMESTAMP" ),
289 QStringLiteral( "CURRENT_TIMEZONE" ),
290 QStringLiteral( "CURRENT_TRANSFORM_GROUP_FOR_TYPE" ),
291 QStringLiteral( "CURRENT_USER" ),
292 QStringLiteral( "CURRVAL" ),
293 QStringLiteral( "CURSOR" ),
294 QStringLiteral( "CV" ),
295 QStringLiteral( "CYCLE" ),
296 QStringLiteral( "DATA" ),
297 QStringLiteral( "DATABASE" ),
298 QStringLiteral( "DATABASES" ),
299 QStringLiteral( "DATABLOCKSIZE" ),
300 QStringLiteral( "DATE" ),
301 QStringLiteral( "DATEFORM" ),
302 QStringLiteral( "DAY" ),
303 QStringLiteral( "DAY_HOUR" ),
304 QStringLiteral( "DAY_MICROSECOND" ),
305 QStringLiteral( "DAY_MINUTE" ),
306 QStringLiteral( "DAYS" ),
307 QStringLiteral( "DAY_SECOND" ),
308 QStringLiteral( "DBCC" ),
309 QStringLiteral( "DBINFO" ),
310 QStringLiteral( "DEALLOCATE" ),
311 QStringLiteral( "DEC" ),
312 QStringLiteral( "DECFLOAT" ),
313 QStringLiteral( "DECIMAL" ),
314 QStringLiteral( "DECLARE" ),
315 QStringLiteral( "DEFAULT" ),
316 QStringLiteral( "DEFERRABLE" ),
317 QStringLiteral( "DEFERRED" ),
318 QStringLiteral( "DEFINE" ),
319 QStringLiteral( "DEGREES" ),
320 QStringLiteral( "DEL" ),
321 QStringLiteral( "DELAYED" ),
322 QStringLiteral( "DELETE" ),
323 QStringLiteral( "DENSE_RANK" ),
324 QStringLiteral( "DENY" ),
325 QStringLiteral( "DEPTH" ),
326 QStringLiteral( "DEREF" ),
327 QStringLiteral( "DESC" ),
328 QStringLiteral( "DESCRIBE" ),
329 QStringLiteral( "DESCRIPTOR" ),
330 QStringLiteral( "DESTROY" ),
331 QStringLiteral( "DESTRUCTOR" ),
332 QStringLiteral( "DETERMINISTIC" ),
333 QStringLiteral( "DIAGNOSTIC" ),
334 QStringLiteral( "DIAGNOSTICS" ),
335 QStringLiteral( "DICTIONARY" ),
336 QStringLiteral( "DISABLE" ),
337 QStringLiteral( "DISABLED" ),
338 QStringLiteral( "DISALLOW" ),
339 QStringLiteral( "DISCONNECT" ),
340 QStringLiteral( "DISK" ),
341 QStringLiteral( "DISTINCT" ),
342 QStringLiteral( "DISTINCTROW" ),
343 QStringLiteral( "DISTRIBUTED" ),
344 QStringLiteral( "DIV" ),
345 QStringLiteral( "DO" ),
346 QStringLiteral( "DOCUMENT" ),
347 QStringLiteral( "DOMAIN" ),
348 QStringLiteral( "DOUBLE" ),
349 QStringLiteral( "DROP" ),
350 QStringLiteral( "DSSIZE" ),
351 QStringLiteral( "DUAL" ),
352 QStringLiteral( "DUMP" ),
353 QStringLiteral( "DYNAMIC" ),
354 QStringLiteral( "EACH" ),
355 QStringLiteral( "ECHO" ),
356 QStringLiteral( "EDITPROC" ),
357 QStringLiteral( "ELEMENT" ),
358 QStringLiteral( "ELSE" ),
359 QStringLiteral( "ELSEIF" ),
360 QStringLiteral( "EMPTY" ),
361 QStringLiteral( "ENABLED" ),
362 QStringLiteral( "ENCLOSED" ),
363 QStringLiteral( "ENCODING" ),
364 QStringLiteral( "ENCRYPTION" ),
365 QStringLiteral( "END" ),
366 QStringLiteral( "END-EXEC" ),
367 QStringLiteral( "END_FRAME" ),
368 QStringLiteral( "ENDING" ),
369 QStringLiteral( "END_PARTITION" ),
370 QStringLiteral( "EQ" ),
371 QStringLiteral( "EQUALS" ),
372 QStringLiteral( "ERASE" ),
373 QStringLiteral( "ERRLVL" ),
374 QStringLiteral( "ERROR" ),
375 QStringLiteral( "ERRORFILES" ),
376 QStringLiteral( "ERRORTABLES" ),
377 QStringLiteral( "ESCAPE" ),
378 QStringLiteral( "ESCAPED" ),
379 QStringLiteral( "ET" ),
380 QStringLiteral( "EVERY" ),
381 QStringLiteral( "EXCEPT" ),
382 QStringLiteral( "EXCEPTION" ),
383 QStringLiteral( "EXCLUSIVE" ),
384 QStringLiteral( "EXEC" ),
385 QStringLiteral( "EXECUTE" ),
386 QStringLiteral( "EXISTS" ),
387 QStringLiteral( "EXIT" ),
388 QStringLiteral( "EXP" ),
389 QStringLiteral( "EXPLAIN" ),
390 QStringLiteral( "EXTERNAL" ),
391 QStringLiteral( "EXTRACT" ),
392 QStringLiteral( "FALLBACK" ),
393 QStringLiteral( "FALSE" ),
394 QStringLiteral( "FASTEXPORT" ),
395 QStringLiteral( "FENCED" ),
396 QStringLiteral( "FETCH" ),
397 QStringLiteral( "FIELDPROC" ),
398 QStringLiteral( "FILE" ),
399 QStringLiteral( "FILLFACTOR" ),
400 QStringLiteral( "FILTER" ),
401 QStringLiteral( "FINAL" ),
402 QStringLiteral( "FIRST" ),
403 QStringLiteral( "FIRST_VALUE" ),
404 QStringLiteral( "FLOAT" ),
405 QStringLiteral( "FLOAT4" ),
406 QStringLiteral( "FLOAT8" ),
407 QStringLiteral( "FLOOR" ),
408 QStringLiteral( "FOR" ),
409 QStringLiteral( "FORCE" ),
410 QStringLiteral( "FOREIGN" ),
411 QStringLiteral( "FORMAT" ),
412 QStringLiteral( "FOUND" ),
413 QStringLiteral( "FRAME_ROW" ),
414 QStringLiteral( "FREE" ),
415 QStringLiteral( "FREESPACE" ),
416 QStringLiteral( "FREETEXT" ),
417 QStringLiteral( "FREETEXTTABLE" ),
418 QStringLiteral( "FREEZE" ),
419 QStringLiteral( "FROM" ),
420 QStringLiteral( "FULL" ),
421 QStringLiteral( "FULLTEXT" ),
422 QStringLiteral( "FUNCTION" ),
423 QStringLiteral( "FUSION" ),
424 QStringLiteral( "GE" ),
425 QStringLiteral( "GENERAL" ),
426 QStringLiteral( "GENERATED" ),
427 QStringLiteral( "GET" ),
428 QStringLiteral( "GIVE" ),
429 QStringLiteral( "GLOBAL" ),
430 QStringLiteral( "GO" ),
431 QStringLiteral( "GOTO" ),
432 QStringLiteral( "GRANT" ),
433 QStringLiteral( "GRAPHIC" ),
434 QStringLiteral( "GROUP" ),
435 QStringLiteral( "GROUPING" ),
436 QStringLiteral( "GROUPS" ),
437 QStringLiteral( "GT" ),
438 QStringLiteral( "HANDLER" ),
439 QStringLiteral( "HASH" ),
440 QStringLiteral( "HASHAMP" ),
441 QStringLiteral( "HASHBAKAMP" ),
442 QStringLiteral( "HASHBUCKET" ),
443 QStringLiteral( "HASHROW" ),
444 QStringLiteral( "HAVING" ),
445 QStringLiteral( "HELP" ),
446 QStringLiteral( "HIGH_PRIORITY" ),
447 QStringLiteral( "HOLD" ),
448 QStringLiteral( "HOLDLOCK" ),
449 QStringLiteral( "HOST" ),
450 QStringLiteral( "HOUR" ),
451 QStringLiteral( "HOUR_MICROSECOND" ),
452 QStringLiteral( "HOUR_MINUTE" ),
453 QStringLiteral( "HOURS" ),
454 QStringLiteral( "HOUR_SECOND" ),
455 QStringLiteral( "IDENTIFIED" ),
456 QStringLiteral( "IDENTITY" ),
457 QStringLiteral( "IDENTITYCOL" ),
458 QStringLiteral( "IDENTITY_INSERT" ),
459 QStringLiteral( "IF" ),
460 QStringLiteral( "IGNORE" ),
461 QStringLiteral( "ILIKE" ),
462 QStringLiteral( "IMMEDIATE" ),
463 QStringLiteral( "IN" ),
464 QStringLiteral( "INCLUSIVE" ),
465 QStringLiteral( "INCONSISTENT" ),
466 QStringLiteral( "INCREMENT" ),
467 QStringLiteral( "INDEX" ),
468 QStringLiteral( "INDICATOR" ),
469 QStringLiteral( "INFILE" ),
470 QStringLiteral( "INHERIT" ),
471 QStringLiteral( "INITIAL" ),
472 QStringLiteral( "INITIALIZE" ),
473 QStringLiteral( "INITIALLY" ),
474 QStringLiteral( "INITIATE" ),
475 QStringLiteral( "INNER" ),
476 QStringLiteral( "INOUT" ),
477 QStringLiteral( "INPUT" ),
478 QStringLiteral( "INS" ),
479 QStringLiteral( "INSENSITIVE" ),
480 QStringLiteral( "INSERT" ),
481 QStringLiteral( "INSTEAD" ),
482 QStringLiteral( "INT" ),
483 QStringLiteral( "INT1" ),
484 QStringLiteral( "INT2" ),
485 QStringLiteral( "INT3" ),
486 QStringLiteral( "INT4" ),
487 QStringLiteral( "INT8" ),
488 QStringLiteral( "INTEGER" ),
489 QStringLiteral( "INTEGERDATE" ),
490 QStringLiteral( "INTERSECT" ),
491 QStringLiteral( "INTERSECTION" ),
492 QStringLiteral( "INTERVAL" ),
493 QStringLiteral( "INTO" ),
494 QStringLiteral( "IO_AFTER_GTIDS" ),
495 QStringLiteral( "IO_BEFORE_GTIDS" ),
496 QStringLiteral( "IS" ),
497 QStringLiteral( "ISNULL" ),
498 QStringLiteral( "ISOBID" ),
499 QStringLiteral( "ISOLATION" ),
500 QStringLiteral( "ITERATE" ),
501 QStringLiteral( "JAR" ),
502 QStringLiteral( "JOIN" ),
503 QStringLiteral( "JOURNAL" ),
504 QStringLiteral( "JSON_ARRAY" ),
505 QStringLiteral( "JSON_ARRAYAGG" ),
506 QStringLiteral( "JSON_EXISTS" ),
507 QStringLiteral( "JSON_OBJECT" ),
508 QStringLiteral( "JSON_OBJECTAGG" ),
509 QStringLiteral( "JSON_QUERY" ),
510 QStringLiteral( "JSON_TABLE" ),
511 QStringLiteral( "JSON_TABLE_PRIMITIVE" ),
512 QStringLiteral( "JSON_VALUE" ),
513 QStringLiteral( "KEEP" ),
514 QStringLiteral( "KEY" ),
515 QStringLiteral( "KEYS" ),
516 QStringLiteral( "KILL" ),
517 QStringLiteral( "KURTOSIS" ),
518 QStringLiteral( "LABEL" ),
519 QStringLiteral( "LAG" ),
520 QStringLiteral( "LANGUAGE" ),
521 QStringLiteral( "LARGE" ),
522 QStringLiteral( "LAST" ),
523 QStringLiteral( "LAST_VALUE" ),
524 QStringLiteral( "LATERAL" ),
525 QStringLiteral( "LC_CTYPE" ),
526 QStringLiteral( "LE" ),
527 QStringLiteral( "LEAD" ),
528 QStringLiteral( "LEADING" ),
529 QStringLiteral( "LEAVE" ),
530 QStringLiteral( "LEFT" ),
531 QStringLiteral( "LESS" ),
532 QStringLiteral( "LEVEL" ),
533 QStringLiteral( "LIKE" ),
534 QStringLiteral( "LIKE_REGEX" ),
535 QStringLiteral( "LIMIT" ),
536 QStringLiteral( "LINEAR" ),
537 QStringLiteral( "LINENO" ),
538 QStringLiteral( "LINES" ),
539 QStringLiteral( "LISTAGG" ),
540 QStringLiteral( "LN" ),
541 QStringLiteral( "LOAD" ),
542 QStringLiteral( "LOADING" ),
543 QStringLiteral( "LOCAL" ),
544 QStringLiteral( "LOCALE" ),
545 QStringLiteral( "LOCALTIME" ),
546 QStringLiteral( "LOCALTIMESTAMP" ),
547 QStringLiteral( "LOCATOR" ),
548 QStringLiteral( "LOCATORS" ),
549 QStringLiteral( "LOCK" ),
550 QStringLiteral( "LOCKING" ),
551 QStringLiteral( "LOCKMAX" ),
552 QStringLiteral( "LOCKSIZE" ),
553 QStringLiteral( "LOG" ),
554 QStringLiteral( "LOG10" ),
555 QStringLiteral( "LOGGING" ),
556 QStringLiteral( "LOGON" ),
557 QStringLiteral( "LONG" ),
558 QStringLiteral( "LONGBLOB" ),
559 QStringLiteral( "LONGTEXT" ),
560 QStringLiteral( "LOOP" ),
561 QStringLiteral( "LOWER" ),
562 QStringLiteral( "LOW_PRIORITY" ),
563 QStringLiteral( "LT" ),
564 QStringLiteral( "MACRO" ),
565 QStringLiteral( "MAINTAINED" ),
566 QStringLiteral( "MAP" ),
567 QStringLiteral( "MASTER_BIND" ),
568 QStringLiteral( "MASTER_SSL_VERIFY_SERVER_CERT" ),
569 QStringLiteral( "MATCH" ),
570 QStringLiteral( "MATCHES" ),
571 QStringLiteral( "MATCH_NUMBER" ),
572 QStringLiteral( "MATCH_RECOGNIZE" ),
573 QStringLiteral( "MATERIALIZED" ),
574 QStringLiteral( "MAVG" ),
575 QStringLiteral( "MAX" ),
576 QStringLiteral( "MAXEXTENTS" ),
577 QStringLiteral( "MAXIMUM" ),
578 QStringLiteral( "MAXVALUE" ),
579 QStringLiteral( "MCHARACTERS" ),
580 QStringLiteral( "MDIFF" ),
581 QStringLiteral( "MEDIUMBLOB" ),
582 QStringLiteral( "MEDIUMINT" ),
583 QStringLiteral( "MEDIUMTEXT" ),
584 QStringLiteral( "MEMBER" ),
585 QStringLiteral( "MERGE" ),
586 QStringLiteral( "METHOD" ),
587 QStringLiteral( "MICROSECOND" ),
588 QStringLiteral( "MICROSECONDS" ),
589 QStringLiteral( "MIDDLEINT" ),
590 QStringLiteral( "MIN" ),
591 QStringLiteral( "MINDEX" ),
592 QStringLiteral( "MINIMUM" ),
593 QStringLiteral( "MINUS" ),
594 QStringLiteral( "MINUTE" ),
595 QStringLiteral( "MINUTE_MICROSECOND" ),
596 QStringLiteral( "MINUTES" ),
597 QStringLiteral( "MINUTE_SECOND" ),
598 QStringLiteral( "MLINREG" ),
599 QStringLiteral( "MLOAD" ),
600 QStringLiteral( "MLSLABEL" ),
601 QStringLiteral( "MOD" ),
602 QStringLiteral( "MODE" ),
603 QStringLiteral( "MODIFIES" ),
604 QStringLiteral( "MODIFY" ),
605 QStringLiteral( "MODULE" ),
606 QStringLiteral( "MONITOR" ),
607 QStringLiteral( "MONRESOURCE" ),
608 QStringLiteral( "MONSESSION" ),
609 QStringLiteral( "MONTH" ),
610 QStringLiteral( "MONTHS" ),
611 QStringLiteral( "MSUBSTR" ),
612 QStringLiteral( "MSUM" ),
613 QStringLiteral( "MULTISET" ),
614 QStringLiteral( "NAMED" ),
615 QStringLiteral( "NAMES" ),
616 QStringLiteral( "NATIONAL" ),
617 QStringLiteral( "NATURAL" ),
618 QStringLiteral( "NCHAR" ),
619 QStringLiteral( "NCLOB" ),
620 QStringLiteral( "NE" ),
621 QStringLiteral( "NESTED_TABLE_ID" ),
622 QStringLiteral( "NEW" ),
623 QStringLiteral( "NEW_TABLE" ),
624 QStringLiteral( "NEXT" ),
625 QStringLiteral( "NEXTVAL" ),
626 QStringLiteral( "NO" ),
627 QStringLiteral( "NOAUDIT" ),
628 QStringLiteral( "NOCHECK" ),
629 QStringLiteral( "NOCOMPRESS" ),
630 QStringLiteral( "NONCLUSTERED" ),
631 QStringLiteral( "NONE" ),
632 QStringLiteral( "NORMALIZE" ),
633 QStringLiteral( "NOT" ),
634 QStringLiteral( "NOTNULL" ),
635 QStringLiteral( "NOWAIT" ),
636 QStringLiteral( "NO_WRITE_TO_BINLOG" ),
637 QStringLiteral( "NTH_VALUE" ),
638 QStringLiteral( "NTILE" ),
639 QStringLiteral( "NULL" ),
640 QStringLiteral( "NULLIF" ),
641 QStringLiteral( "NULLIFZERO" ),
642 QStringLiteral( "NULLS" ),
643 QStringLiteral( "NUMBER" ),
644 QStringLiteral( "NUMERIC" ),
645 QStringLiteral( "NUMPARTS" ),
646 QStringLiteral( "OBID" ),
647 QStringLiteral( "OBJECT" ),
648 QStringLiteral( "OBJECTS" ),
649 QStringLiteral( "OCCURRENCES_REGEX" ),
650 QStringLiteral( "OCTET_LENGTH" ),
651 QStringLiteral( "OF" ),
652 QStringLiteral( "OFF" ),
653 QStringLiteral( "OFFLINE" ),
654 QStringLiteral( "OFFSET" ),
655 QStringLiteral( "OFFSETS" ),
656 QStringLiteral( "OLD" ),
657 QStringLiteral( "OLD_TABLE" ),
658 QStringLiteral( "OMIT" ),
659 QStringLiteral( "ON" ),
660 QStringLiteral( "ONE" ),
661 QStringLiteral( "ONLINE" ),
662 QStringLiteral( "ONLY" ),
663 QStringLiteral( "OPEN" ),
664 QStringLiteral( "OPENDATASOURCE" ),
665 QStringLiteral( "OPENQUERY" ),
666 QStringLiteral( "OPENROWSET" ),
667 QStringLiteral( "OPENXML" ),
668 QStringLiteral( "OPERATION" ),
669 QStringLiteral( "OPTIMIZATION" ),
670 QStringLiteral( "OPTIMIZE" ),
671 QStringLiteral( "OPTIMIZER_COSTS" ),
672 QStringLiteral( "OPTION" ),
673 QStringLiteral( "OPTIONALLY" ),
674 QStringLiteral( "OR" ),
675 QStringLiteral( "ORDER" ),
676 QStringLiteral( "ORDINALITY" ),
677 QStringLiteral( "ORGANIZATION" ),
678 QStringLiteral( "OUT" ),
679 QStringLiteral( "OUTER" ),
680 QStringLiteral( "OUTFILE" ),
681 QStringLiteral( "OUTPUT" ),
682 QStringLiteral( "OVER" ),
683 QStringLiteral( "OVERLAPS" ),
684 QStringLiteral( "OVERLAY" ),
685 QStringLiteral( "OVERRIDE" ),
686 QStringLiteral( "PACKAGE" ),
687 QStringLiteral( "PAD" ),
688 QStringLiteral( "PADDED" ),
689 QStringLiteral( "PARAMETER" ),
690 QStringLiteral( "PARAMETERS" ),
691 QStringLiteral( "PART" ),
692 QStringLiteral( "PARTIAL" ),
693 QStringLiteral( "PARTITION" ),
694 QStringLiteral( "PARTITIONED" ),
695 QStringLiteral( "PARTITIONING" ),
696 QStringLiteral( "PASSWORD" ),
697 QStringLiteral( "PATH" ),
698 QStringLiteral( "PATTERN" ),
699 QStringLiteral( "PCTFREE" ),
700 QStringLiteral( "PER" ),
701 QStringLiteral( "PERCENT" ),
702 QStringLiteral( "PERCENTILE_CONT" ),
703 QStringLiteral( "PERCENTILE_DISC" ),
704 QStringLiteral( "PERCENT_RANK" ),
705 QStringLiteral( "PERIOD" ),
706 QStringLiteral( "PERM" ),
707 QStringLiteral( "PERMANENT" ),
708 QStringLiteral( "PIECESIZE" ),
709 QStringLiteral( "PIVOT" ),
710 QStringLiteral( "PLACING" ),
711 QStringLiteral( "PLAN" ),
712 QStringLiteral( "PORTION" ),
713 QStringLiteral( "POSITION" ),
714 QStringLiteral( "POSITION_REGEX" ),
715 QStringLiteral( "POSTFIX" ),
716 QStringLiteral( "POWER" ),
717 QStringLiteral( "PRECEDES" ),
718 QStringLiteral( "PRECISION" ),
719 QStringLiteral( "PREFIX" ),
720 QStringLiteral( "PREORDER" ),
721 QStringLiteral( "PREPARE" ),
722 QStringLiteral( "PRESERVE" ),
723 QStringLiteral( "PREVVAL" ),
724 QStringLiteral( "PRIMARY" ),
725 QStringLiteral( "PRINT" ),
726 QStringLiteral( "PRIOR" ),
727 QStringLiteral( "PRIQTY" ),
728 QStringLiteral( "PRIVATE" ),
729 QStringLiteral( "PRIVILEGES" ),
730 QStringLiteral( "PROC" ),
731 QStringLiteral( "PROCEDURE" ),
732 QStringLiteral( "PROFILE" ),
733 QStringLiteral( "PROGRAM" ),
734 QStringLiteral( "PROPORTIONAL" ),
735 QStringLiteral( "PROTECTION" ),
736 QStringLiteral( "PSID" ),
737 QStringLiteral( "PTF" ),
738 QStringLiteral( "PUBLIC" ),
739 QStringLiteral( "PURGE" ),
740 QStringLiteral( "QUALIFIED" ),
741 QStringLiteral( "QUALIFY" ),
742 QStringLiteral( "QUANTILE" ),
743 QStringLiteral( "QUERY" ),
744 QStringLiteral( "QUERYNO" ),
745 QStringLiteral( "RADIANS" ),
746 QStringLiteral( "RAISERROR" ),
747 QStringLiteral( "RANDOM" ),
748 QStringLiteral( "RANGE" ),
749 QStringLiteral( "RANGE_N" ),
750 QStringLiteral( "RANK" ),
751 QStringLiteral( "RAW" ),
752 QStringLiteral( "READ" ),
753 QStringLiteral( "READS" ),
754 QStringLiteral( "READTEXT" ),
755 QStringLiteral( "READ_WRITE" ),
756 QStringLiteral( "REAL" ),
757 QStringLiteral( "RECONFIGURE" ),
758 QStringLiteral( "RECURSIVE" ),
759 QStringLiteral( "REF" ),
760 QStringLiteral( "REFERENCES" ),
761 QStringLiteral( "REFERENCING" ),
762 QStringLiteral( "REFRESH" ),
763 QStringLiteral( "REGEXP" ),
764 QStringLiteral( "REGR_AVGX" ),
765 QStringLiteral( "REGR_AVGY" ),
766 QStringLiteral( "REGR_COUNT" ),
767 QStringLiteral( "REGR_INTERCEPT" ),
768 QStringLiteral( "REGR_R2" ),
769 QStringLiteral( "REGR_SLOPE" ),
770 QStringLiteral( "REGR_SXX" ),
771 QStringLiteral( "REGR_SXY" ),
772 QStringLiteral( "REGR_SYY" ),
773 QStringLiteral( "RELATIVE" ),
774 QStringLiteral( "RELEASE" ),
775 QStringLiteral( "RENAME" ),
776 QStringLiteral( "REPEAT" ),
777 QStringLiteral( "REPLACE" ),
778 QStringLiteral( "REPLICATION" ),
779 QStringLiteral( "REPOVERRIDE" ),
780 QStringLiteral( "REQUEST" ),
781 QStringLiteral( "REQUIRE" ),
782 QStringLiteral( "RESIGNAL" ),
783 QStringLiteral( "RESOURCE" ),
784 QStringLiteral( "RESTART" ),
785 QStringLiteral( "RESTORE" ),
786 QStringLiteral( "RESTRICT" ),
787 QStringLiteral( "RESULT" ),
788 QStringLiteral( "RESULT_SET_LOCATOR" ),
789 QStringLiteral( "RESUME" ),
790 QStringLiteral( "RET" ),
791 QStringLiteral( "RETRIEVE" ),
792 QStringLiteral( "RETURN" ),
793 QStringLiteral( "RETURNING" ),
794 QStringLiteral( "RETURNS" ),
795 QStringLiteral( "REVALIDATE" ),
796 QStringLiteral( "REVERT" ),
797 QStringLiteral( "REVOKE" ),
798 QStringLiteral( "RIGHT" ),
799 QStringLiteral( "RIGHTS" ),
800 QStringLiteral( "RLIKE" ),
801 QStringLiteral( "ROLE" ),
802 QStringLiteral( "ROLLBACK" ),
803 QStringLiteral( "ROLLFORWARD" ),
804 QStringLiteral( "ROLLUP" ),
805 QStringLiteral( "ROUND_CEILING" ),
806 QStringLiteral( "ROUND_DOWN" ),
807 QStringLiteral( "ROUND_FLOOR" ),
808 QStringLiteral( "ROUND_HALF_DOWN" ),
809 QStringLiteral( "ROUND_HALF_EVEN" ),
810 QStringLiteral( "ROUND_HALF_UP" ),
811 QStringLiteral( "ROUND_UP" ),
812 QStringLiteral( "ROUTINE" ),
813 QStringLiteral( "ROW" ),
814 QStringLiteral( "ROWCOUNT" ),
815 QStringLiteral( "ROWGUIDCOL" ),
816 QStringLiteral( "ROWID" ),
817 QStringLiteral( "ROWNUM" ),
818 QStringLiteral( "ROW_NUMBER" ),
819 QStringLiteral( "ROWS" ),
820 QStringLiteral( "ROWSET" ),
821 QStringLiteral( "RULE" ),
822 QStringLiteral( "RUN" ),
823 QStringLiteral( "RUNNING" ),
824 QStringLiteral( "SAMPLE" ),
825 QStringLiteral( "SAMPLEID" ),
826 QStringLiteral( "SAVE" ),
827 QStringLiteral( "SAVEPOINT" ),
828 QStringLiteral( "SCHEMA" ),
829 QStringLiteral( "SCHEMAS" ),
830 QStringLiteral( "SCOPE" ),
831 QStringLiteral( "SCRATCHPAD" ),
832 QStringLiteral( "SCROLL" ),
833 QStringLiteral( "SEARCH" ),
834 QStringLiteral( "SECOND" ),
835 QStringLiteral( "SECOND_MICROSECOND" ),
836 QStringLiteral( "SECONDS" ),
837 QStringLiteral( "SECQTY" ),
838 QStringLiteral( "SECTION" ),
839 QStringLiteral( "SECURITY" ),
840 QStringLiteral( "SECURITYAUDIT" ),
841 QStringLiteral( "SEEK" ),
842 QStringLiteral( "SEL" ),
843 QStringLiteral( "SELECT" ),
844 QStringLiteral( "SEMANTICKEYPHRASETABLE" ),
845 QStringLiteral( "SEMANTICSIMILARITYDETAILSTABLE" ),
846 QStringLiteral( "SEMANTICSIMILARITYTABLE" ),
847 QStringLiteral( "SENSITIVE" ),
848 QStringLiteral( "SEPARATOR" ),
849 QStringLiteral( "SEQUENCE" ),
850 QStringLiteral( "SESSION" ),
851 QStringLiteral( "SESSION_USER" ),
852 QStringLiteral( "SET" ),
853 QStringLiteral( "SETRESRATE" ),
854 QStringLiteral( "SETS" ),
855 QStringLiteral( "SETSESSRATE" ),
856 QStringLiteral( "SETUSER" ),
857 QStringLiteral( "SHARE" ),
858 QStringLiteral( "SHOW" ),
859 QStringLiteral( "SHUTDOWN" ),
860 QStringLiteral( "SIGNAL" ),
861 QStringLiteral( "SIMILAR" ),
862 QStringLiteral( "SIMPLE" ),
863 QStringLiteral( "SIN" ),
864 QStringLiteral( "SINH" ),
865 QStringLiteral( "SIZE" ),
866 QStringLiteral( "SKEW" ),
867 QStringLiteral( "SKIP" ),
868 QStringLiteral( "SMALLINT" ),
869 QStringLiteral( "SOME" ),
870 QStringLiteral( "SOUNDEX" ),
871 QStringLiteral( "SOURCE" ),
872 QStringLiteral( "SPACE" ),
873 QStringLiteral( "SPATIAL" ),
874 QStringLiteral( "SPECIFIC" ),
875 QStringLiteral( "SPECIFICTYPE" ),
876 QStringLiteral( "SPOOL" ),
877 QStringLiteral( "SQL" ),
878 QStringLiteral( "SQL_BIG_RESULT" ),
879 QStringLiteral( "SQL_CALC_FOUND_ROWS" ),
880 QStringLiteral( "SQLEXCEPTION" ),
881 QStringLiteral( "SQL_SMALL_RESULT" ),
882 QStringLiteral( "SQLSTATE" ),
883 QStringLiteral( "SQLTEXT" ),
884 QStringLiteral( "SQLWARNING" ),
885 QStringLiteral( "SQRT" ),
886 QStringLiteral( "SS" ),
887 QStringLiteral( "SSL" ),
888 QStringLiteral( "STANDARD" ),
889 QStringLiteral( "START" ),
890 QStringLiteral( "STARTING" ),
891 QStringLiteral( "STARTUP" ),
892 QStringLiteral( "STATE" ),
893 QStringLiteral( "STATEMENT" ),
894 QStringLiteral( "STATIC" ),
895 QStringLiteral( "STATISTICS" ),
896 QStringLiteral( "STAY" ),
897 QStringLiteral( "STDDEV_POP" ),
898 QStringLiteral( "STDDEV_SAMP" ),
899 QStringLiteral( "STEPINFO" ),
900 QStringLiteral( "STOGROUP" ),
901 QStringLiteral( "STORED" ),
902 QStringLiteral( "STORES" ),
903 QStringLiteral( "STRAIGHT_JOIN" ),
904 QStringLiteral( "STRING_CS" ),
905 QStringLiteral( "STRUCTURE" ),
906 QStringLiteral( "STYLE" ),
907 QStringLiteral( "SUBMULTISET" ),
908 QStringLiteral( "SUBSCRIBER" ),
909 QStringLiteral( "SUBSET" ),
910 QStringLiteral( "SUBSTR" ),
911 QStringLiteral( "SUBSTRING" ),
912 QStringLiteral( "SUBSTRING_REGEX" ),
913 QStringLiteral( "SUCCEEDS" ),
914 QStringLiteral( "SUCCESSFUL" ),
915 QStringLiteral( "SUM" ),
916 QStringLiteral( "SUMMARY" ),
917 QStringLiteral( "SUSPEND" ),
918 QStringLiteral( "SYMMETRIC" ),
919 QStringLiteral( "SYNONYM" ),
920 QStringLiteral( "SYSDATE" ),
921 QStringLiteral( "SYSTEM" ),
922 QStringLiteral( "SYSTEM_TIME" ),
923 QStringLiteral( "SYSTEM_USER" ),
924 QStringLiteral( "SYSTIMESTAMP" ),
925 QStringLiteral( "TABLE" ),
926 QStringLiteral( "TABLESAMPLE" ),
927 QStringLiteral( "TABLESPACE" ),
928 QStringLiteral( "TAN" ),
929 QStringLiteral( "TANH" ),
930 QStringLiteral( "TBL_CS" ),
931 QStringLiteral( "TEMPORARY" ),
932 QStringLiteral( "TERMINATE" ),
933 QStringLiteral( "TERMINATED" ),
934 QStringLiteral( "TEXTSIZE" ),
935 QStringLiteral( "THAN" ),
936 QStringLiteral( "THEN" ),
937 QStringLiteral( "THRESHOLD" ),
938 QStringLiteral( "TIME" ),
939 QStringLiteral( "TIMESTAMP" ),
940 QStringLiteral( "TIMEZONE_HOUR" ),
941 QStringLiteral( "TIMEZONE_MINUTE" ),
942 QStringLiteral( "TINYBLOB" ),
943 QStringLiteral( "TINYINT" ),
944 QStringLiteral( "TINYTEXT" ),
945 QStringLiteral( "TITLE" ),
946 QStringLiteral( "TO" ),
947 QStringLiteral( "TOP" ),
948 QStringLiteral( "TRACE" ),
949 QStringLiteral( "TRAILING" ),
950 QStringLiteral( "TRAN" ),
951 QStringLiteral( "TRANSACTION" ),
952 QStringLiteral( "TRANSLATE" ),
953 QStringLiteral( "TRANSLATE_CHK" ),
954 QStringLiteral( "TRANSLATE_REGEX" ),
955 QStringLiteral( "TRANSLATION" ),
956 QStringLiteral( "TREAT" ),
957 QStringLiteral( "TRIGGER" ),
958 QStringLiteral( "TRIM" ),
959 QStringLiteral( "TRIM_ARRAY" ),
960 QStringLiteral( "TRUE" ),
961 QStringLiteral( "TRUNCATE" ),
962 QStringLiteral( "TRY_CONVERT" ),
963 QStringLiteral( "TSEQUAL" ),
964 QStringLiteral( "TYPE" ),
965 QStringLiteral( "UC" ),
966 QStringLiteral( "UESCAPE" ),
967 QStringLiteral( "UID" ),
968 QStringLiteral( "UNDEFINED" ),
969 QStringLiteral( "UNDER" ),
970 QStringLiteral( "UNDO" ),
971 QStringLiteral( "UNION" ),
972 QStringLiteral( "UNIQUE" ),
973 QStringLiteral( "UNKNOWN" ),
974 QStringLiteral( "UNLOCK" ),
975 QStringLiteral( "UNNEST" ),
976 QStringLiteral( "UNPIVOT" ),
977 QStringLiteral( "UNSIGNED" ),
978 QStringLiteral( "UNTIL" ),
979 QStringLiteral( "UPD" ),
980 QStringLiteral( "UPDATE" ),
981 QStringLiteral( "UPDATETEXT" ),
982 QStringLiteral( "UPPER" ),
983 QStringLiteral( "UPPERCASE" ),
984 QStringLiteral( "USAGE" ),
985 QStringLiteral( "USE" ),
986 QStringLiteral( "USER" ),
987 QStringLiteral( "USING" ),
988 QStringLiteral( "UTC_DATE" ),
989 QStringLiteral( "UTC_TIME" ),
990 QStringLiteral( "UTC_TIMESTAMP" ),
991 QStringLiteral( "VALIDATE" ),
992 QStringLiteral( "VALIDPROC" ),
993 QStringLiteral( "VALUE" ),
994 QStringLiteral( "VALUE_OF" ),
995 QStringLiteral( "VALUES" ),
996 QStringLiteral( "VARBINARY" ),
997 QStringLiteral( "VARBYTE" ),
998 QStringLiteral( "VARCHAR" ),
999 QStringLiteral( "VARCHAR2" ),
1000 QStringLiteral( "VARCHARACTER" ),
1001 QStringLiteral( "VARGRAPHIC" ),
1002 QStringLiteral( "VARIABLE" ),
1003 QStringLiteral( "VARIADIC" ),
1004 QStringLiteral( "VARIANT" ),
1005 QStringLiteral( "VAR_POP" ),
1006 QStringLiteral( "VAR_SAMP" ),
1007 QStringLiteral( "VARYING" ),
1008 QStringLiteral( "VCAT" ),
1009 QStringLiteral( "VERBOSE" ),
1010 QStringLiteral( "VERSIONING" ),
1011 QStringLiteral( "VIEW" ),
1012 QStringLiteral( "VIRTUAL" ),
1013 QStringLiteral( "VOLATILE" ),
1014 QStringLiteral( "VOLUMES" ),
1015 QStringLiteral( "WAIT" ),
1016 QStringLiteral( "WAITFOR" ),
1017 QStringLiteral( "WHEN" ),
1018 QStringLiteral( "WHENEVER" ),
1019 QStringLiteral( "WHERE" ),
1020 QStringLiteral( "WHILE" ),
1021 QStringLiteral( "WIDTH_BUCKET" ),
1022 QStringLiteral( "WINDOW" ),
1023 QStringLiteral( "WITH" ),
1024 QStringLiteral( "WITHIN" ),
1025 QStringLiteral( "WITHIN_GROUP" ),
1026 QStringLiteral( "WITHOUT" ),
1027 QStringLiteral( "WLM" ),
1028 QStringLiteral( "WORK" ),
1029 QStringLiteral( "WRITE" ),
1030 QStringLiteral( "WRITETEXT" ),
1031 QStringLiteral( "XMLCAST" ),
1032 QStringLiteral( "XMLEXISTS" ),
1033 QStringLiteral( "XMLNAMESPACES" ),
1034 QStringLiteral( "XOR" ),
1035 QStringLiteral( "YEAR" ),
1036 QStringLiteral( "YEAR_MONTH" ),
1037 QStringLiteral( "YEARS" ),
1038 QStringLiteral( "ZEROFILL" ),
1039 QStringLiteral( "ZEROIFNULL" ),
1040 QStringLiteral( "ZONE" ),
1041 }
1042 }
1043 };
1044}
1045
1050
1051QString QgsAbstractDatabaseProviderConnection::defaultPrimaryKeyColumnName() const
1052{
1053 return QStringLiteral( "pk" );
1054}
1055
1056QString QgsAbstractDatabaseProviderConnection::defaultGeometryColumnName() const
1057{
1058 return QStringLiteral( "geom" );
1059}
1060
1061QList<Qgis::FieldDomainType> QgsAbstractDatabaseProviderConnection::supportedFieldDomainTypes() const
1062{
1063 return {};
1064}
1065
1066QList<Qgis::RelationshipCardinality> QgsAbstractDatabaseProviderConnection::supportedRelationshipCardinalities() const
1067{
1068 return {};
1069}
1070
1071QList<Qgis::RelationshipStrength> QgsAbstractDatabaseProviderConnection::supportedRelationshipStrengths() const
1072{
1073 return {};
1074}
1075
1080
1081QStringList QgsAbstractDatabaseProviderConnection::relatedTableTypes() const
1082{
1083 return {};
1084}
1085
1090
1091void QgsAbstractDatabaseProviderConnection::createVectorTable( const QString &schema,
1092 const QString &name,
1093 const QgsFields &fields,
1094 Qgis::WkbType wkbType,
1095 const QgsCoordinateReferenceSystem &srs,
1096 bool overwrite,
1097 const QMap<QString, QVariant> *
1098 options ) const
1099{
1100 Q_UNUSED( schema );
1101 Q_UNUSED( name );
1102 Q_UNUSED( fields );
1103 Q_UNUSED( srs );
1104 Q_UNUSED( overwrite );
1105 Q_UNUSED( options );
1106 Q_UNUSED( wkbType );
1107 throw QgsProviderConnectionException( QObject::tr( "Operation 'createVectorTable' is not supported" ) );
1108}
1109
1110void QgsAbstractDatabaseProviderConnection::renameVectorTable( const QString &, const QString &, const QString & ) const
1111{
1112 checkCapability( Capability::RenameVectorTable );
1113}
1114
1115
1121
1122void QgsAbstractDatabaseProviderConnection::renameRasterTable( const QString &, const QString &, const QString & ) const
1123{
1124 checkCapability( Capability::RenameRasterTable );
1125}
1126
1127void QgsAbstractDatabaseProviderConnection::dropVectorTable( const QString &, const QString & ) const
1128{
1129 checkCapability( Capability::DropVectorTable );
1130}
1131
1132bool QgsAbstractDatabaseProviderConnection::tableExists( const QString &schema, const QString &name ) const
1133{
1134 checkCapability( Capability::TableExists );
1135 const QList<QgsAbstractDatabaseProviderConnection::TableProperty> constTables { tables( schema ) };
1136 for ( const auto &t : constTables )
1137 {
1138 if ( t.tableName() == name )
1139 {
1140 return true;
1141 }
1142 }
1143 return false;
1144}
1145
1146
1147QList<QgsLayerMetadataProviderResult> QgsAbstractDatabaseProviderConnection::searchLayerMetadata( const QgsMetadataSearchContext &searchContext, const QString &searchString, const QgsRectangle &geographicExtent, QgsFeedback *feedback ) const
1148{
1149 Q_UNUSED( feedback );
1150 Q_UNUSED( searchContext );
1151 Q_UNUSED( searchString );
1152 Q_UNUSED( geographicExtent );
1153 throw QgsNotSupportedException( QObject::tr( "Provider %1 has no %2 method" ).arg( providerKey(), QStringLiteral( "searchLayerMetadata" ) ) );
1154}
1155
1156void QgsAbstractDatabaseProviderConnection::dropRasterTable( const QString &, const QString & ) const
1157{
1158 checkCapability( Capability::DropRasterTable );
1159}
1160
1161void QgsAbstractDatabaseProviderConnection::createSchema( const QString & ) const
1162{
1163 checkCapability( Capability::CreateSchema );
1164}
1165
1166void QgsAbstractDatabaseProviderConnection::dropSchema( const QString &, bool ) const
1167{
1168 checkCapability( Capability::DropSchema );
1169}
1170
1171void QgsAbstractDatabaseProviderConnection::renameSchema( const QString &, const QString & ) const
1172{
1173 checkCapability( Capability::RenameSchema );
1174}
1175
1176QList<QList<QVariant>> QgsAbstractDatabaseProviderConnection::executeSql( const QString &sql, QgsFeedback *feedback ) const
1177{
1178 return execSql( sql, feedback ).rows();
1179}
1180
1181
1187
1188
1189void QgsAbstractDatabaseProviderConnection::vacuum( const QString &, const QString & ) const
1190{
1191 checkCapability( Capability::Vacuum );
1192}
1193
1198
1199QgsVectorLayer *QgsAbstractDatabaseProviderConnection::createSqlVectorLayer( const SqlVectorLayerOptions & ) const
1200{
1201 checkCapability( Capability::SqlLayers );
1202 return nullptr;
1203}
1204
1205bool QgsAbstractDatabaseProviderConnection::validateSqlVectorLayer( const SqlVectorLayerOptions &, QString & ) const
1206{
1207 checkCapability( Capability::SqlLayers );
1208 return true;
1209}
1210
1211void QgsAbstractDatabaseProviderConnection::deleteSpatialIndex( const QString &, const QString &, const QString & ) const
1212{
1213 checkCapability( Capability::DeleteSpatialIndex );
1214}
1215
1216bool QgsAbstractDatabaseProviderConnection::spatialIndexExists( const QString &, const QString &, const QString & ) const
1217{
1218 checkCapability( Capability::SpatialIndexExists );
1219 return false;
1220}
1221
1222void QgsAbstractDatabaseProviderConnection::deleteField( const QString &fieldName, const QString &schema, const QString &tableName, bool ) const
1223{
1224 checkCapability( Capability::DeleteField );
1225
1226 QgsVectorLayer::LayerOptions options { false, false };
1227 options.skipCrsValidation = true;
1228 std::unique_ptr<QgsVectorLayer> vl { std::make_unique<QgsVectorLayer>( tableUri( schema, tableName ), QStringLiteral( "temp_layer" ), mProviderKey, options ) };
1229 if ( ! vl->isValid() )
1230 {
1231 throw QgsProviderConnectionException( QObject::tr( "Could not create a vector layer for table '%1' in schema '%2'" )
1232 .arg( tableName, schema ) );
1233 }
1234 if ( vl->fields().lookupField( fieldName ) == -1 )
1235 {
1236 throw QgsProviderConnectionException( QObject::tr( "Could not find field '%1' in table '%2' in schema '%3'" )
1237 .arg( fieldName, tableName, schema ) );
1238
1239 }
1240 if ( ! vl->dataProvider()->deleteAttributes( { vl->fields().lookupField( fieldName ) } ) )
1241 {
1242 throw QgsProviderConnectionException( QObject::tr( "Unknown error deleting field '%1' in table '%2' in schema '%3'" )
1243 .arg( fieldName, tableName, schema ) );
1244 }
1245}
1246
1247void QgsAbstractDatabaseProviderConnection::addField( const QgsField &field, const QString &schema, const QString &tableName ) const
1248{
1249 checkCapability( Capability::AddField );
1250
1251 QgsVectorLayer::LayerOptions options { false, false };
1252 options.skipCrsValidation = true;
1253 auto vl = std::make_unique<QgsVectorLayer>( tableUri( schema, tableName ), QStringLiteral( "temp_layer" ), mProviderKey, options ) ;
1254 if ( ! vl->isValid() )
1255 {
1256 throw QgsProviderConnectionException( QObject::tr( "Could not create a vector layer for table '%1' in schema '%2'" )
1257 .arg( tableName, schema ) );
1258 }
1259 if ( vl->fields().lookupField( field.name() ) != -1 )
1260 {
1261 throw QgsProviderConnectionException( QObject::tr( "Field '%1' in table '%2' in schema '%3' already exists" )
1262 .arg( field.name(), tableName, schema ) );
1263
1264 }
1265 if ( ! vl->dataProvider()->addAttributes( { field } ) )
1266 {
1267 throw QgsProviderConnectionException( QObject::tr( "Unknown error adding field '%1' in table '%2' in schema '%3'" )
1268 .arg( field.name(), tableName, schema ) );
1269 }
1270}
1271
1272void QgsAbstractDatabaseProviderConnection::renameField( const QString &schema, const QString &tableName, const QString &name, const QString &newName ) const
1273{
1274 checkCapability( Capability::RenameField );
1275
1276 QgsVectorLayer::LayerOptions options { false, false };
1277 options.skipCrsValidation = true;
1278 auto vl = std::make_unique<QgsVectorLayer>( tableUri( schema, tableName ), QStringLiteral( "temp_layer" ), mProviderKey, options ) ;
1279 if ( ! vl->isValid() )
1280 {
1281 throw QgsProviderConnectionException( QObject::tr( "Could not create a vector layer for table '%1' in schema '%2'" )
1282 .arg( tableName, schema ) );
1283 }
1284 int existingIndex = vl->fields().lookupField( name );
1285 if ( existingIndex == -1 )
1286 {
1287 throw QgsProviderConnectionException( QObject::tr( "Field '%1' in table '%2' in does not exist" )
1288 .arg( name, tableName ) );
1289
1290 }
1291 if ( vl->fields().lookupField( newName ) != -1 )
1292 {
1293 throw QgsProviderConnectionException( QObject::tr( "A field with name '%1' already exists in table '%2'" )
1294 .arg( newName, tableName ) );
1295
1296 }
1297 if ( ! vl->dataProvider()->renameAttributes( {{existingIndex, newName}} ) )
1298 {
1299 throw QgsProviderConnectionException( QObject::tr( "Unknown error renaming field '%1' in table '%2' to '%3'" )
1300 .arg( name, tableName, newName ) );
1301 }
1302}
1303
1304QList<QgsAbstractDatabaseProviderConnection::TableProperty> QgsAbstractDatabaseProviderConnection::tables( const QString &, const QgsAbstractDatabaseProviderConnection::TableFlags &, QgsFeedback * ) const
1305{
1306 checkCapability( Capability::Tables );
1307 return QList<QgsAbstractDatabaseProviderConnection::TableProperty>();
1308}
1309
1310
1311QgsAbstractDatabaseProviderConnection::TableProperty QgsAbstractDatabaseProviderConnection::table( const QString &schema, const QString &name, QgsFeedback *feedback ) const
1312{
1313 checkCapability( Capability::Tables );
1314 const QList<QgsAbstractDatabaseProviderConnection::TableProperty> constTables { tables( schema, TableFlags(), feedback ) };
1315 for ( const auto &t : constTables )
1316 {
1317 if ( t.tableName() == name )
1318 {
1319 return t;
1320 }
1321 }
1322 throw QgsProviderConnectionException( QObject::tr( "Table '%1' was not found in schema '%2'" )
1323 .arg( name, schema ) );
1324}
1325
1326QList<QgsAbstractDatabaseProviderConnection::TableProperty> QgsAbstractDatabaseProviderConnection::tablesInt( const QString &schema, const int flags ) const
1327{
1328 return tables( schema, static_cast<QgsAbstractDatabaseProviderConnection::TableFlags>( flags ) );
1329}
1330
1331
1332QStringList QgsAbstractDatabaseProviderConnection::schemas( ) const
1333{
1334 checkCapability( Capability::Schemas );
1335 return QStringList();
1336}
1337
1338QString QgsAbstractDatabaseProviderConnection::TableProperty::tableName() const
1339{
1340 return mTableName;
1341}
1342
1343void QgsAbstractDatabaseProviderConnection::TableProperty::setTableName( const QString &name )
1344{
1345 mTableName = name;
1346}
1347
1348void QgsAbstractDatabaseProviderConnection::TableProperty::addGeometryColumnType( Qgis::WkbType type, const QgsCoordinateReferenceSystem &crs )
1349{
1350 // Do not add the type if it's already present
1351 const QgsAbstractDatabaseProviderConnection::TableProperty::GeometryColumnType toAdd { type, crs };
1352 for ( const auto &t : std::as_const( mGeometryColumnTypes ) )
1353 {
1354 if ( t == toAdd )
1355 {
1356 return;
1357 }
1358 }
1359 mGeometryColumnTypes.push_back( toAdd );
1360}
1361
1362QList<QgsAbstractDatabaseProviderConnection::TableProperty::GeometryColumnType> QgsAbstractDatabaseProviderConnection::TableProperty::geometryColumnTypes() const
1363{
1364 return mGeometryColumnTypes;
1365}
1366
1367
1368QgsFields QgsAbstractDatabaseProviderConnection::fields( const QString &schema, const QString &tableName, QgsFeedback * ) const
1369{
1370 QgsVectorLayer::LayerOptions options { false, true };
1371 options.skipCrsValidation = true;
1372 QgsVectorLayer vl { tableUri( schema, tableName ), QStringLiteral( "temp_layer" ), mProviderKey, options };
1373 if ( vl.isValid() )
1374 {
1375 // Note: this implementation works for providers that do not hide any "special" field (geometry or PKs)
1376 return vl.fields();
1377 }
1378 else
1379 {
1380 throw QgsProviderConnectionException( QObject::tr( "Error retrieving fields information for uri: %1" ).arg( vl.publicSource() ) );
1381 }
1382}
1383
1384QStringList QgsAbstractDatabaseProviderConnection::fieldDomainNames() const
1385{
1386 checkCapability( Capability::ListFieldDomains );
1387 return QStringList();
1388}
1389
1390QgsFieldDomain *QgsAbstractDatabaseProviderConnection::fieldDomain( const QString & ) const
1391{
1392 checkCapability( Capability::RetrieveFieldDomain );
1393 return nullptr;
1394}
1395
1396void QgsAbstractDatabaseProviderConnection::setFieldDomainName( const QString &, const QString &, const QString &, const QString & ) const
1397{
1398 checkCapability( Capability::SetFieldDomain );
1399}
1400
1401void QgsAbstractDatabaseProviderConnection::addFieldDomain( const QgsFieldDomain &, const QString & ) const
1402{
1403 checkCapability( Capability::AddFieldDomain );
1404}
1405
1406void QgsAbstractDatabaseProviderConnection::setFieldAlias( const QString &, const QString &, const QString &, const QString & ) const
1407{
1408 checkCapability( Qgis::DatabaseProviderConnectionCapability2::SetFieldAlias );
1409}
1410
1411void QgsAbstractDatabaseProviderConnection::setTableComment( const QString &, const QString &, const QString & ) const
1412{
1413 checkCapability( Qgis::DatabaseProviderConnectionCapability2::SetTableComment );
1414}
1415
1416void QgsAbstractDatabaseProviderConnection::setFieldComment( const QString &, const QString &, const QString &, const QString & ) const
1417{
1418 checkCapability( Qgis::DatabaseProviderConnectionCapability2::SetFieldComment );
1419}
1420
1421QList< QgsWeakRelation > QgsAbstractDatabaseProviderConnection::relationships( const QString &, const QString & ) const
1422{
1423 checkCapability( Capability::RetrieveRelationships );
1424 return {};
1425}
1426
1431
1436
1441
1442QString QgsAbstractDatabaseProviderConnection::TableProperty::defaultName() const
1443{
1444 QString n = mTableName;
1445 if ( mGeometryColumnCount > 1 ) n += '.' + mGeometryColumn;
1446 return n;
1447}
1448
1449void QgsAbstractDatabaseProviderConnection::moveTableToSchema( const QString &schema, const QString &tableName, const QString &targetSchema ) const
1450{
1451 Q_UNUSED( schema );
1452 Q_UNUSED( tableName );
1453 Q_UNUSED( targetSchema );
1454 checkCapability( Capability::MoveTableToSchema );
1455}
1456
1457QgsAbstractDatabaseProviderConnection::TableProperty QgsAbstractDatabaseProviderConnection::TableProperty::at( int index ) const
1458{
1459 TableProperty property;
1460
1461 Q_ASSERT( index >= 0 && index < mGeometryColumnTypes.size() );
1462
1463 property.mGeometryColumnTypes << mGeometryColumnTypes[ index ];
1464 property.mSchema = mSchema;
1465 property.mTableName = mTableName;
1466 property.mGeometryColumn = mGeometryColumn;
1467 property.mPkColumns = mPkColumns;
1468 property.mGeometryColumnCount = mGeometryColumnCount;
1469 property.mFlags = mFlags;
1470 property.mComment = mComment;
1471 property.mInfo = mInfo;
1472 return property;
1473}
1474
1479
1480int QgsAbstractDatabaseProviderConnection::TableProperty::maxCoordinateDimensions() const
1481{
1482 int res = 0;
1483 for ( const TableProperty::GeometryColumnType &ct : std::as_const( mGeometryColumnTypes ) )
1484 {
1485 res = std::max( res, QgsWkbTypes::coordDimensions( ct.wkbType ) );
1486 }
1487 return res;
1488}
1489
1490bool QgsAbstractDatabaseProviderConnection::TableProperty::operator==( const QgsAbstractDatabaseProviderConnection::TableProperty &other ) const
1491{
1492 return mSchema == other.mSchema &&
1493 mTableName == other.mTableName &&
1494 mGeometryColumn == other.mGeometryColumn &&
1495 mGeometryColumnCount == other.mGeometryColumnCount &&
1496 mPkColumns == other.mPkColumns &&
1497 mFlags == other.mFlags &&
1498 mComment == other.mComment &&
1499 mInfo == other.mInfo;
1500}
1501
1502
1503void QgsAbstractDatabaseProviderConnection::TableProperty::setGeometryColumnTypes( const QList<QgsAbstractDatabaseProviderConnection::TableProperty::GeometryColumnType> &columnTypes )
1504{
1505 mGeometryColumnTypes = columnTypes;
1506}
1507
1508
1509int QgsAbstractDatabaseProviderConnection::TableProperty::geometryColumnCount() const
1510{
1511 return mGeometryColumnCount;
1512}
1513
1514void QgsAbstractDatabaseProviderConnection::TableProperty::setGeometryColumnCount( int geometryColumnCount )
1515{
1516 mGeometryColumnCount = geometryColumnCount;
1517}
1518
1519QVariantMap QgsAbstractDatabaseProviderConnection::TableProperty::info() const
1520{
1521 return mInfo;
1522}
1523
1524void QgsAbstractDatabaseProviderConnection::TableProperty::setInfo( const QVariantMap &info )
1525{
1526 mInfo = info;
1527}
1528
1529QString QgsAbstractDatabaseProviderConnection::TableProperty::comment() const
1530{
1531 return mComment;
1532}
1533
1534void QgsAbstractDatabaseProviderConnection::TableProperty::setComment( const QString &comment )
1535{
1536 mComment = comment;
1537}
1538
1543
1548
1549QList<QgsCoordinateReferenceSystem> QgsAbstractDatabaseProviderConnection::TableProperty::crsList() const
1550{
1551 QList<QgsCoordinateReferenceSystem> crss;
1552 for ( const auto &t : std::as_const( mGeometryColumnTypes ) )
1553 {
1554 crss.push_back( t.crs );
1555 }
1556 return crss;
1557}
1558
1559QStringList QgsAbstractDatabaseProviderConnection::TableProperty::primaryKeyColumns() const
1560{
1561 return mPkColumns;
1562}
1563
1564void QgsAbstractDatabaseProviderConnection::TableProperty::setPrimaryKeyColumns( const QStringList &pkColumns )
1565{
1566 mPkColumns = pkColumns;
1567}
1568
1569QString QgsAbstractDatabaseProviderConnection::TableProperty::geometryColumn() const
1570{
1571 return mGeometryColumn;
1572}
1573
1574void QgsAbstractDatabaseProviderConnection::TableProperty::setGeometryColumn( const QString &geometryColumn )
1575{
1576 mGeometryColumn = geometryColumn;
1577}
1578
1579QString QgsAbstractDatabaseProviderConnection::TableProperty::schema() const
1580{
1581 return mSchema;
1582}
1583
1584void QgsAbstractDatabaseProviderConnection::TableProperty::setSchema( const QString &schema )
1585{
1586 mSchema = schema;
1587}
1588
1590
1591QStringList QgsAbstractDatabaseProviderConnection::QueryResult::columns() const
1592{
1593 return mColumns;
1594}
1595
1596QList<QList<QVariant> > QgsAbstractDatabaseProviderConnection::QueryResult::rows( QgsFeedback *feedback )
1597{
1598
1599 QList<QList<QVariant> > rows;
1600
1601 while ( mResultIterator &&
1602 mResultIterator->hasNextRow() &&
1603 ( ! feedback || ! feedback->isCanceled() ) )
1604 {
1605 const QVariantList row( mResultIterator->nextRow() );
1606 if ( row.isEmpty() )
1607 {
1608 break;
1609 }
1610 else
1611 {
1612 rows.push_back( row );
1613 }
1614 }
1615 return rows;
1616}
1617
1618QList<QVariant> QgsAbstractDatabaseProviderConnection::QueryResult::nextRow() const
1619{
1620 if ( ! mResultIterator )
1621 {
1622 return QList<QVariant>();
1623 }
1624 return mResultIterator->nextRow();
1625}
1626
1627
1628long long QgsAbstractDatabaseProviderConnection::QueryResult::fetchedRowCount() const
1629{
1630 if ( ! mResultIterator )
1631 {
1632 return 0;
1633 }
1634 return mResultIterator->fetchedRowCount();
1635}
1636
1637long long QgsAbstractDatabaseProviderConnection::QueryResult::rowCount() const
1638{
1639 if ( ! mResultIterator )
1640 {
1641 return static_cast<long long>( Qgis::FeatureCountState::UnknownCount );
1642 }
1643 return mResultIterator->rowCount();
1644}
1645
1646
1647bool QgsAbstractDatabaseProviderConnection::QueryResult::hasNextRow() const
1648{
1649 if ( ! mResultIterator )
1650 {
1651 return false;
1652 }
1653 return mResultIterator->hasNextRow();
1654}
1655
1656void QgsAbstractDatabaseProviderConnection::QueryResult::appendColumn( const QString &columnName )
1657{
1658 mColumns.push_back( columnName );
1659}
1660
1661
1662QgsAbstractDatabaseProviderConnection::QueryResult::QueryResult( std::shared_ptr<QgsAbstractDatabaseProviderConnection::QueryResult::QueryResultIterator> iterator )
1663 : mResultIterator( iterator )
1664{}
1665
1666double QgsAbstractDatabaseProviderConnection::QueryResult::queryExecutionTime() const
1667{
1668 return mQueryExecutionTime;
1669}
1670
1671void QgsAbstractDatabaseProviderConnection::QueryResult::setQueryExecutionTime( double queryExecutionTime )
1672{
1673 mQueryExecutionTime = queryExecutionTime;
1674}
1675
1676
1677QVariantList QgsAbstractDatabaseProviderConnection::QueryResult::QueryResultIterator::nextRow()
1678{
1679 QMutexLocker lock( &mMutex );
1680 const QVariantList row = nextRowPrivate();
1681 if ( ! row.isEmpty() )
1682 {
1683 mFetchedRowCount++;
1684 }
1685 return row;
1686}
1687
1688bool QgsAbstractDatabaseProviderConnection::QueryResult::QueryResultIterator::hasNextRow() const
1689{
1690 QMutexLocker lock( &mMutex );
1691 return hasNextRowPrivate();
1692}
1693
1694long long QgsAbstractDatabaseProviderConnection::QueryResult::QueryResultIterator::fetchedRowCount()
1695{
1696 QMutexLocker lock( &mMutex );
1697 return mFetchedRowCount;
1698}
1699
1700long long QgsAbstractDatabaseProviderConnection::QueryResult::QueryResultIterator::rowCount()
1701{
1702 QMutexLocker lock( &mMutex );
1703 return rowCountPrivate();
1704}
1705
1707
Qgis::DatabaseProviderConnectionCapability2
DatabaseProviderConnectionCapability2
The Capability enum represents the extended operations supported by the connection.
Definition qgis.h:5271
Qgis::DatabaseProviderConnectionCapability2::SetTableComment
@ SetTableComment
Can set comments for tables via setTableComment()
Qgis::DatabaseProviderConnectionCapability2::SetFieldComment
@ SetFieldComment
Can set comments for fields via setFieldComment()
Qgis::DatabaseProviderConnectionCapability2::SetFieldAlias
@ SetFieldAlias
Can set aliases for fields via setFieldAlias()
Qgis::SqlKeywordCategory::Constant
@ Constant
SQL constant.
Qgis::RelationshipCapabilities
QFlags< RelationshipCapability > RelationshipCapabilities
Relationship capabilities.
Definition qgis.h:4343
Qgis::DatabaseProviderConnectionCapabilities2
QFlags< DatabaseProviderConnectionCapability2 > DatabaseProviderConnectionCapabilities2
Definition qgis.h:5277
Qgis::WkbType
WkbType
The WKB type describes the number of dimensions a geometry has.
Definition qgis.h:256
Qgis::SqlLayerDefinitionCapabilities
QFlags< SqlLayerDefinitionCapability > SqlLayerDefinitionCapabilities
SQL layer definition capabilities.
Definition qgis.h:1063
QgsAbstractDatabaseProviderConnection::defaultGeometryColumnName
virtual QString defaultGeometryColumnName() const
Returns the default name to use for a geometry column for the connection.
Definition qgsabstractdatabaseproviderconnection.cpp:1056
QgsAbstractDatabaseProviderConnection::setFieldComment
virtual void setFieldComment(const QString &fieldName, const QString &schema, const QString &tableName, const QString &comment) const
Sets the comment for the existing field with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1416
QgsAbstractDatabaseProviderConnection::relationships
virtual QList< QgsWeakRelation > relationships(const QString &schema=QString(), const QString &tableName=QString()) const
Returns a list of relationships detected in the database.
Definition qgsabstractdatabaseproviderconnection.cpp:1421
QgsAbstractDatabaseProviderConnection::createVectorTable
virtual void createVectorTable(const QString &schema, const QString &name, const QgsFields &fields, Qgis::WkbType wkbType, const QgsCoordinateReferenceSystem &srs, bool overwrite, const QMap< QString, QVariant > *options) const
Creates an empty table with name in the given schema (schema is ignored if not supported by the backe...
Definition qgsabstractdatabaseproviderconnection.cpp:1091
QgsAbstractDatabaseProviderConnection::createSqlVectorLayer
virtual QgsVectorLayer * createSqlVectorLayer(const SqlVectorLayerOptions &options) const
Creates and returns a (possibly invalid) vector layer based on a SQL statement and options.
Definition qgsabstractdatabaseproviderconnection.cpp:1199
QgsAbstractDatabaseProviderConnection::tableExists
virtual bool tableExists(const QString &schema, const QString &name) const
Checks whether a table name exists in the given schema.
Definition qgsabstractdatabaseproviderconnection.cpp:1132
QgsAbstractDatabaseProviderConnection::tablesInt
QList< QgsAbstractDatabaseProviderConnection::TableProperty > tablesInt(const QString &schema=QString(), const int flags=0) const
Returns information on the tables in the given schema.
Definition qgsabstractdatabaseproviderconnection.cpp:1326
QgsAbstractDatabaseProviderConnection::updateRelationship
virtual void updateRelationship(const QgsWeakRelation &relationship) const
Updates an existing relationship in the database.
Definition qgsabstractdatabaseproviderconnection.cpp:1432
QgsAbstractDatabaseProviderConnection::renameField
virtual void renameField(const QString &schema, const QString &tableName, const QString &name, const QString &newName) const
Renames an existing field.
Definition qgsabstractdatabaseproviderconnection.cpp:1272
QgsAbstractDatabaseProviderConnection::dropSchema
virtual void dropSchema(const QString &name, bool force=false) const
Drops an entire schema with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1166
QgsAbstractDatabaseProviderConnection::mSqlLayerDefinitionCapabilities
Qgis::SqlLayerDefinitionCapabilities mSqlLayerDefinitionCapabilities
Definition qgsabstractdatabaseproviderconnection.h:1269
QgsAbstractDatabaseProviderConnection::addField
virtual void addField(const QgsField &field, const QString &schema, const QString &tableName) const
Adds a field.
Definition qgsabstractdatabaseproviderconnection.cpp:1247
QgsAbstractDatabaseProviderConnection::tables
virtual QList< QgsAbstractDatabaseProviderConnection::TableProperty > tables(const QString &schema=QString(), const QgsAbstractDatabaseProviderConnection::TableFlags &flags=QgsAbstractDatabaseProviderConnection::TableFlags(), QgsFeedback *feedback=nullptr) const
Returns information on the tables in the given schema.
Definition qgsabstractdatabaseproviderconnection.cpp:1304
QgsAbstractDatabaseProviderConnection::mCapabilities2
Qgis::DatabaseProviderConnectionCapabilities2 mCapabilities2
Definition qgsabstractdatabaseproviderconnection.h:1266
QgsAbstractDatabaseProviderConnection::vacuum
virtual void vacuum(const QString &schema, const QString &name) const
Vacuum the database table with given schema and name (schema is ignored if not supported by the backe...
Definition qgsabstractdatabaseproviderconnection.cpp:1189
QgsAbstractDatabaseProviderConnection::supportedFieldDomainTypes
virtual QList< Qgis::FieldDomainType > supportedFieldDomainTypes() const
Returns a list of field domain types which are supported by the provider.
Definition qgsabstractdatabaseproviderconnection.cpp:1061
QgsAbstractDatabaseProviderConnection::renameVectorTable
virtual void renameVectorTable(const QString &schema, const QString &name, const QString &newName) const
Renames a vector or aspatial table with given schema (schema is ignored if not supported by the backe...
Definition qgsabstractdatabaseproviderconnection.cpp:1110
QgsAbstractDatabaseProviderConnection::createSchema
virtual void createSchema(const QString &name) const
Creates a new schema with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1161
QgsAbstractDatabaseProviderConnection::deleteSpatialIndex
virtual void deleteSpatialIndex(const QString &schema, const QString &name, const QString &geometryColumn) const
Deletes the existing spatial index for the database table with given schema, name and geometryColumn ...
Definition qgsabstractdatabaseproviderconnection.cpp:1211
QgsAbstractDatabaseProviderConnection::dropRasterTable
virtual void dropRasterTable(const QString &schema, const QString &name) const
Drops a raster table with given schema (schema is ignored if not supported by the backend) and name.
Definition qgsabstractdatabaseproviderconnection.cpp:1156
QgsAbstractDatabaseProviderConnection::capabilities2
Qgis::DatabaseProviderConnectionCapabilities2 capabilities2() const
Returns extended connection capabilities.
Definition qgsabstractdatabaseproviderconnection.cpp:44
QgsAbstractDatabaseProviderConnection::execSql
virtual QueryResult execSql(const QString &sql, QgsFeedback *feedback=nullptr) const
Executes raw sql and returns the (possibly empty) query results, optionally feedback can be provided.
Definition qgsabstractdatabaseproviderconnection.cpp:1182
QgsAbstractDatabaseProviderConnection::queryBuilder
virtual QgsProviderSqlQueryBuilder * queryBuilder() const
Returns a SQL query builder for the connection, which provides an interface for provider-specific cre...
Definition qgsabstractdatabaseproviderconnection.cpp:1086
QgsAbstractDatabaseProviderConnection::setFieldDomainName
virtual void setFieldDomainName(const QString &fieldName, const QString &schema, const QString &tableName, const QString &domainName) const
Sets the field domain name for the existing field with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1396
QgsAbstractDatabaseProviderConnection::deleteField
virtual void deleteField(const QString &fieldName, const QString &schema, const QString &tableName, bool force=false) const
Deletes the field with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1222
QgsAbstractDatabaseProviderConnection::tableUri
virtual QString tableUri(const QString &schema, const QString &name) const
Returns the URI string for the given table and schema.
Definition qgsabstractdatabaseproviderconnection.cpp:64
QgsAbstractDatabaseProviderConnection::GeometryColumnCapabilities
QFlags< GeometryColumnCapability > GeometryColumnCapabilities
Definition qgsabstractdatabaseproviderconnection.h:541
QgsAbstractDatabaseProviderConnection::deleteRelationship
virtual void deleteRelationship(const QgsWeakRelation &relationship) const
Deletes an existing relationship in the database.
Definition qgsabstractdatabaseproviderconnection.cpp:1437
QgsAbstractDatabaseProviderConnection::Capability
Capability
The Capability enum represents the operations supported by the connection.
Definition qgsabstractdatabaseproviderconnection.h:485
QgsAbstractDatabaseProviderConnection::RetrieveFieldDomain
@ RetrieveFieldDomain
Can retrieve field domain details from provider via fieldDomain()
Definition qgsabstractdatabaseproviderconnection.h:508
QgsAbstractDatabaseProviderConnection::CreateSpatialIndex
@ CreateSpatialIndex
The connection can create spatial indices.
Definition qgsabstractdatabaseproviderconnection.h:501
QgsAbstractDatabaseProviderConnection::AddRelationship
@ AddRelationship
Can add new relationships to the database via addRelationship()
Definition qgsabstractdatabaseproviderconnection.h:513
QgsAbstractDatabaseProviderConnection::SqlLayers
@ SqlLayers
Can create vector layers from SQL SELECT queries.
Definition qgsabstractdatabaseproviderconnection.h:498
QgsAbstractDatabaseProviderConnection::DropVectorTable
@ DropVectorTable
Can DROP a vector (or aspatial) table/layer.
Definition qgsabstractdatabaseproviderconnection.h:488
QgsAbstractDatabaseProviderConnection::DeleteSpatialIndex
@ DeleteSpatialIndex
The connection can delete spatial indices for tables.
Definition qgsabstractdatabaseproviderconnection.h:503
QgsAbstractDatabaseProviderConnection::RetrieveRelationships
@ RetrieveRelationships
Can retrieve relationships from the database.
Definition qgsabstractdatabaseproviderconnection.h:512
QgsAbstractDatabaseProviderConnection::SetFieldDomain
@ SetFieldDomain
Can set the domain for an existing field via setFieldDomainName()
Definition qgsabstractdatabaseproviderconnection.h:509
QgsAbstractDatabaseProviderConnection::AddFieldDomain
@ AddFieldDomain
Can add new field domains to the database via addFieldDomain()
Definition qgsabstractdatabaseproviderconnection.h:510
QgsAbstractDatabaseProviderConnection::DeleteRelationship
@ DeleteRelationship
Can delete existing relationships from the database via deleteRelationship()
Definition qgsabstractdatabaseproviderconnection.h:515
QgsAbstractDatabaseProviderConnection::RenameVectorTable
@ RenameVectorTable
Can RENAME a vector (or aspatial) table/layer.
Definition qgsabstractdatabaseproviderconnection.h:489
QgsAbstractDatabaseProviderConnection::RenameField
@ RenameField
Can rename existing fields via renameField()
Definition qgsabstractdatabaseproviderconnection.h:511
QgsAbstractDatabaseProviderConnection::MoveTableToSchema
@ MoveTableToSchema
Can move table to another schema via moveTableToAnotherSchema()
Definition qgsabstractdatabaseproviderconnection.h:516
QgsAbstractDatabaseProviderConnection::ExecuteSql
@ ExecuteSql
Can execute raw SQL queries (without returning results)
Definition qgsabstractdatabaseproviderconnection.h:494
QgsAbstractDatabaseProviderConnection::UpdateRelationship
@ UpdateRelationship
Can update existing relationships in the database via updateRelationship()
Definition qgsabstractdatabaseproviderconnection.h:514
QgsAbstractDatabaseProviderConnection::SpatialIndexExists
@ SpatialIndexExists
The connection can determine if a spatial index exists.
Definition qgsabstractdatabaseproviderconnection.h:502
QgsAbstractDatabaseProviderConnection::ListFieldDomains
@ ListFieldDomains
Can return a list of field domain names via fieldDomainNames()
Definition qgsabstractdatabaseproviderconnection.h:507
QgsAbstractDatabaseProviderConnection::Schemas
@ Schemas
Can list schemas (if not set, the connection does not support schemas)
Definition qgsabstractdatabaseproviderconnection.h:497
QgsAbstractDatabaseProviderConnection::createSpatialIndex
virtual void createSpatialIndex(const QString &schema, const QString &name, const QgsAbstractDatabaseProviderConnection::SpatialIndexOptions &options=QgsAbstractDatabaseProviderConnection::SpatialIndexOptions()) const
Creates a spatial index for the database table with given schema and name (schema is ignored if not s...
Definition qgsabstractdatabaseproviderconnection.cpp:1194
QgsAbstractDatabaseProviderConnection::relatedTableTypes
virtual QStringList relatedTableTypes() const
Returns a list of the related table types supported by the database format.
Definition qgsabstractdatabaseproviderconnection.cpp:1081
QgsAbstractDatabaseProviderConnection::geometryColumnCapabilities
virtual GeometryColumnCapabilities geometryColumnCapabilities()
Returns connection geometry column capabilities (Z, M, SinglePart, Curves).
Definition qgsabstractdatabaseproviderconnection.cpp:49
QgsAbstractDatabaseProviderConnection::sqlLayerDefinitionCapabilities
virtual Qgis::SqlLayerDefinitionCapabilities sqlLayerDefinitionCapabilities()
Returns SQL layer definition capabilities (Filters, GeometryColumn, PrimaryKeys).
Definition qgsabstractdatabaseproviderconnection.cpp:54
QgsAbstractDatabaseProviderConnection::renameRasterTable
virtual void renameRasterTable(const QString &schema, const QString &name, const QString &newName) const
Renames a raster table with given schema (schema is ignored if not supported by the backend) and name...
Definition qgsabstractdatabaseproviderconnection.cpp:1122
QgsAbstractDatabaseProviderConnection::dropVectorTable
virtual void dropVectorTable(const QString &schema, const QString &name) const
Drops a vector (or aspatial) table with given schema (schema is ignored if not supported by the backe...
Definition qgsabstractdatabaseproviderconnection.cpp:1127
QgsAbstractDatabaseProviderConnection::fieldDomainNames
virtual QStringList fieldDomainNames() const
Returns a list of field domain names present on the provider.
Definition qgsabstractdatabaseproviderconnection.cpp:1384
QgsAbstractDatabaseProviderConnection::setFieldAlias
virtual void setFieldAlias(const QString &fieldName, const QString &schema, const QString &tableName, const QString &alias) const
Sets the alias for the existing field with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1406
QgsAbstractDatabaseProviderConnection::renameSchema
virtual void renameSchema(const QString &name, const QString &newName) const
Renames a schema with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1171
QgsAbstractDatabaseProviderConnection::addFieldDomain
virtual void addFieldDomain(const QgsFieldDomain &domain, const QString &schema) const
Adds a new field domain to the database.
Definition qgsabstractdatabaseproviderconnection.cpp:1401
QgsAbstractDatabaseProviderConnection::executeSql
virtual QList< QList< QVariant > > executeSql(const QString &sql, QgsFeedback *feedback=nullptr) const
Executes raw sql and returns the (possibly empty) list of results in a multi-dimensional array,...
Definition qgsabstractdatabaseproviderconnection.cpp:1176
QgsAbstractDatabaseProviderConnection::spatialIndexExists
virtual bool spatialIndexExists(const QString &schema, const QString &name, const QString &geometryColumn) const
Determines whether a spatial index exists for the database table with given schema,...
Definition qgsabstractdatabaseproviderconnection.cpp:1216
QgsAbstractDatabaseProviderConnection::table
virtual QgsAbstractDatabaseProviderConnection::TableProperty table(const QString &schema, const QString &table, QgsFeedback *feedback=nullptr) const
Returns information on a table in the given schema.
Definition qgsabstractdatabaseproviderconnection.cpp:1311
QgsAbstractDatabaseProviderConnection::sqlDictionary
virtual QMultiMap< Qgis::SqlKeywordCategory, QStringList > sqlDictionary()
Returns a dictionary of SQL keywords supported by the provider.
Definition qgsabstractdatabaseproviderconnection.cpp:108
QgsAbstractDatabaseProviderConnection::supportedRelationshipCapabilities
virtual Qgis::RelationshipCapabilities supportedRelationshipCapabilities() const
Returns the relationship capabilities supported by the provider.
Definition qgsabstractdatabaseproviderconnection.cpp:1076
QgsAbstractDatabaseProviderConnection::sqlOptions
virtual SqlVectorLayerOptions sqlOptions(const QString &layerSource)
Returns the SQL layer options from a layerSource.
Definition qgsabstractdatabaseproviderconnection.cpp:1116
QgsAbstractDatabaseProviderConnection::illegalFieldNames
virtual QSet< QString > illegalFieldNames() const
Returns a list of field names which are considered illegal by the connection and should not be used w...
Definition qgsabstractdatabaseproviderconnection.cpp:1046
QgsAbstractDatabaseProviderConnection::schemas
virtual QStringList schemas() const
Returns information about the existing schemas.
Definition qgsabstractdatabaseproviderconnection.cpp:1332
QgsAbstractDatabaseProviderConnection::supportedRelationshipCardinalities
virtual QList< Qgis::RelationshipCardinality > supportedRelationshipCardinalities() const
Returns a list of relationship cardinalities which are supported by the provider.
Definition qgsabstractdatabaseproviderconnection.cpp:1066
QgsAbstractDatabaseProviderConnection::createVectorLayerExporterDestinationUri
virtual QString createVectorLayerExporterDestinationUri(const QgsAbstractDatabaseProviderConnection::VectorLayerExporterOptions &options, QVariantMap &providerOptions) const
Creates a URI for use with QgsVectorLayerExporter corresponding to given destination table options fo...
Definition qgsabstractdatabaseproviderconnection.cpp:59
QgsAbstractDatabaseProviderConnection::moveTableToSchema
virtual void moveTableToSchema(const QString &sourceSchema, const QString &tableName, const QString &targetSchema) const
Move table to a different schema.
Definition qgsabstractdatabaseproviderconnection.cpp:1449
QgsAbstractDatabaseProviderConnection::supportedRelationshipStrengths
virtual QList< Qgis::RelationshipStrength > supportedRelationshipStrengths() const
Returns a list of relationship strengths which are supported by the provider.
Definition qgsabstractdatabaseproviderconnection.cpp:1071
QgsAbstractDatabaseProviderConnection::searchLayerMetadata
virtual QList< QgsLayerMetadataProviderResult > searchLayerMetadata(const QgsMetadataSearchContext &searchContext, const QString &searchString=QString(), const QgsRectangle &geographicExtent=QgsRectangle(), QgsFeedback *feedback=nullptr) const
Search the stored layer metadata in the connection, optionally limiting the search to the metadata id...
Definition qgsabstractdatabaseproviderconnection.cpp:1147
QgsAbstractDatabaseProviderConnection::addRelationship
virtual void addRelationship(const QgsWeakRelation &relationship) const
Adds a new field relationship to the database.
Definition qgsabstractdatabaseproviderconnection.cpp:1427
QgsAbstractDatabaseProviderConnection::fieldDomain
virtual QgsFieldDomain * fieldDomain(const QString &name) const
Returns the field domain with the specified name from the provider.
Definition qgsabstractdatabaseproviderconnection.cpp:1390
QgsAbstractDatabaseProviderConnection::QgsAbstractDatabaseProviderConnection
QgsAbstractDatabaseProviderConnection(const QString &name)
Creates a new connection with name by reading its configuration from the settings.
Definition qgsabstractdatabaseproviderconnection.cpp:27
QgsAbstractDatabaseProviderConnection::setTableComment
virtual void setTableComment(const QString &schema, const QString &tableName, const QString &comment) const
Sets the comment for the existing table with the specified name.
Definition qgsabstractdatabaseproviderconnection.cpp:1411
QgsAbstractDatabaseProviderConnection::defaultPrimaryKeyColumnName
virtual QString defaultPrimaryKeyColumnName() const
Returns the default name to use for a primary key column for the connection.
Definition qgsabstractdatabaseproviderconnection.cpp:1051
QgsAbstractDatabaseProviderConnection::validateSqlVectorLayer
virtual bool validateSqlVectorLayer(const SqlVectorLayerOptions &options, QString &message) const
Validates the SQL query options to determine if it is possible to create a vector layer based on a SQ...
Definition qgsabstractdatabaseproviderconnection.cpp:1205
QgsAbstractDatabaseProviderConnection::capabilities
Capabilities capabilities() const
Returns connection capabilities.
Definition qgsabstractdatabaseproviderconnection.cpp:39
QgsAbstractDatabaseProviderConnection::fields
virtual QgsFields fields(const QString &schema, const QString &table, QgsFeedback *feedback=nullptr) const
Returns the fields of a table and schema.
Definition qgsabstractdatabaseproviderconnection.cpp:1368
QgsAbstractProviderConnection
An interface for data provider connections.
Definition qgsabstractproviderconnection.h:43
QgsCoordinateReferenceSystem
Represents a coordinate reference system (CRS).
Definition qgscoordinatereferencesystem.h:212
QgsFeedback
Base class for feedback objects to be used for cancellation of something running in a worker thread.
Definition qgsfeedback.h:44
QgsFeedback::isCanceled
bool isCanceled() const
Tells whether the operation has been canceled already.
Definition qgsfeedback.h:53
QgsFieldDomain
Base class for field domains.
Definition qgsfielddomain.h:34
QgsField
Encapsulate a field in an attribute table or data source.
Definition qgsfield.h:53
QgsField::name
QString name
Definition qgsfield.h:62
QgsFields
Container of fields for a vector layer.
Definition qgsfields.h:46
QgsNotSupportedException
Custom exception class which is raised when an operation is not supported.
Definition qgsexception.h:118
QgsProviderConnectionException
Custom exception class for provider connection related exceptions.
Definition qgsexception.h:101
QgsProviderSqlQueryBuilder
Provides an interface for provider-specific creation of SQL queries.
Definition qgsprovidersqlquerybuilder.h:34
QgsRectangle
A rectangle specified with double values.
Definition qgsrectangle.h:44
QgsVectorLayer
Represents a vector layer which manages a vector based dataset.
Definition qgsvectorlayer.h:402
QgsWeakRelation
Represent a QgsRelation with possibly unresolved layers or unmatched fields.
Definition qgsweakrelation.h:42
QgsWkbTypes::coordDimensions
static Q_INVOKABLE int coordDimensions(Qgis::WkbType type)
Returns the coordinate dimension of the geometry type as an integer.
Definition qgswkbtypes.h:912
Qgis::FeatureCountState::UnknownCount
@ UnknownCount
Provider returned an unknown feature count.
qgsEnumValueToKey
QString qgsEnumValueToKey(const T &value, bool *returnOk=nullptr)
Returns the value for the given key of an enum.
Definition qgis.h:6583
crs
const QgsCoordinateReferenceSystem & crs
Definition qgswfsgetfeature.cpp:53
QgsAbstractDatabaseProviderConnection::QueryResult
The QueryResult class represents the result of a query executed by execSql()
Definition qgsabstractdatabaseproviderconnection.h:87
QgsAbstractDatabaseProviderConnection::QueryResult::rows
QList< QList< QVariant > > rows(QgsFeedback *feedback=nullptr)
Returns the result rows by calling the iterator internally and fetching all the rows,...
QgsAbstractDatabaseProviderConnection::QueryResult::fetchedRowCount
long long fetchedRowCount() const
Returns the number of fetched rows.
QgsAbstractDatabaseProviderConnection::QueryResult::hasNextRow
bool hasNextRow() const
Returns true if there are more rows to fetch.
QgsAbstractDatabaseProviderConnection::QueryResult::nextRow
QList< QVariant > nextRow() const
Returns the next result row or an empty row if there are no rows left.
QgsAbstractDatabaseProviderConnection::QueryResult::rowCount
long long rowCount() const
Returns the number of rows returned by a SELECT query or Qgis::FeatureCountState::UnknownCount if unk...
QgsAbstractDatabaseProviderConnection::QueryResult::columns
QStringList columns() const
Returns the column names.
QgsAbstractDatabaseProviderConnection::SpatialIndexOptions
The SpatialIndexOptions contains extra options relating to spatial index creation.
Definition qgsabstractdatabaseproviderconnection.h:474
QgsAbstractDatabaseProviderConnection::SqlVectorLayerOptions
The SqlVectorLayerOptions stores all information required to create a SQL (query) layer.
Definition qgsabstractdatabaseproviderconnection.h:241
QgsAbstractDatabaseProviderConnection::TableProperty::GeometryColumnType
The GeometryColumnType struct represents the combination of geometry type and CRS for the table geome...
Definition qgsabstractdatabaseproviderconnection.h:284
QgsAbstractDatabaseProviderConnection::TableProperty
The TableProperty class represents a database table or view.
Definition qgsabstractdatabaseproviderconnection.h:269
QgsAbstractDatabaseProviderConnection::TableProperty::setTableName
void setTableName(const QString &name)
Sets the table name to name.
Definition qgsabstractdatabaseproviderconnection.cpp:1343
QgsAbstractDatabaseProviderConnection::TableProperty::operator==
bool operator==(const QgsAbstractDatabaseProviderConnection::TableProperty &other) const
Definition qgsabstractdatabaseproviderconnection.cpp:1490
QgsAbstractDatabaseProviderConnection::TableProperty::setPrimaryKeyColumns
void setPrimaryKeyColumns(const QStringList &primaryKeyColumns)
Sets the primary key column names to primaryKeyColumns.
Definition qgsabstractdatabaseproviderconnection.cpp:1564
QgsAbstractDatabaseProviderConnection::TableProperty::defaultName
QString defaultName() const
Returns the default name for the table entry.
Definition qgsabstractdatabaseproviderconnection.cpp:1442
QgsAbstractDatabaseProviderConnection::TableProperty::geometryColumnTypes
QList< QgsAbstractDatabaseProviderConnection::TableProperty::GeometryColumnType > geometryColumnTypes() const
Returns the list of geometry column types and CRSs.
Definition qgsabstractdatabaseproviderconnection.cpp:1362
QgsAbstractDatabaseProviderConnection::TableProperty::setGeometryColumn
void setGeometryColumn(const QString &geometryColumn)
Sets the geometry column name to geometryColumn.
Definition qgsabstractdatabaseproviderconnection.cpp:1574
QgsAbstractDatabaseProviderConnection::TableProperty::at
TableProperty at(int index) const
Returns the table property corresponding to the geometry type at the given index.
Definition qgsabstractdatabaseproviderconnection.cpp:1457
QgsAbstractDatabaseProviderConnection::TableProperty::maxCoordinateDimensions
int maxCoordinateDimensions() const
Returns the maximum coordinate dimensions of the geometries of a vector table.
Definition qgsabstractdatabaseproviderconnection.cpp:1480
QgsAbstractDatabaseProviderConnection::TableProperty::geometryColumnCount
int geometryColumnCount() const
Returns the number of geometry columns in the original table this entry refers to.
Definition qgsabstractdatabaseproviderconnection.cpp:1509
QgsAbstractDatabaseProviderConnection::TableProperty::crsList
QList< QgsCoordinateReferenceSystem > crsList() const
Returns the list of CRSs supported by the geometry column.
Definition qgsabstractdatabaseproviderconnection.cpp:1549
QgsAbstractDatabaseProviderConnection::TableProperty::info
QVariantMap info() const
Returns additional information about the table.
Definition qgsabstractdatabaseproviderconnection.cpp:1519
QgsAbstractDatabaseProviderConnection::TableProperty::setInfo
void setInfo(const QVariantMap &info)
Sets additional information about the table to info.
Definition qgsabstractdatabaseproviderconnection.cpp:1524
QgsAbstractDatabaseProviderConnection::TableProperty::primaryKeyColumns
QStringList primaryKeyColumns() const
Returns the list of primary key column names.
Definition qgsabstractdatabaseproviderconnection.cpp:1559
QgsAbstractDatabaseProviderConnection::TableProperty::setGeometryColumnTypes
void setGeometryColumnTypes(const QList< QgsAbstractDatabaseProviderConnection::TableProperty::GeometryColumnType > &geometryColumnTypes)
Sets the geometry column types to geometryColumnTypes.
Definition qgsabstractdatabaseproviderconnection.cpp:1503
QgsAbstractDatabaseProviderConnection::TableProperty::schema
QString schema() const
Returns the schema or an empty string for backends that do not support a schema.
Definition qgsabstractdatabaseproviderconnection.cpp:1579
QgsAbstractDatabaseProviderConnection::TableProperty::setGeometryColumnCount
void setGeometryColumnCount(int geometryColumnCount)
Sets the geometryColumnCount.
Definition qgsabstractdatabaseproviderconnection.cpp:1514
QgsAbstractDatabaseProviderConnection::TableProperty::addGeometryColumnType
void addGeometryColumnType(Qgis::WkbType type, const QgsCoordinateReferenceSystem &crs)
Appends the geometry column type with the given srid to the geometry column types list.
Definition qgsabstractdatabaseproviderconnection.cpp:1348
QgsAbstractDatabaseProviderConnection::VectorLayerExporterOptions
Stores all information required to create a QgsVectorLayerExporter for the backend.
Definition qgsabstractdatabaseproviderconnection.h:621
QgsVectorLayer::LayerOptions
Setting options for loading vector layers.
Definition qgsvectorlayer.h:425
QgsVectorLayer::LayerOptions::skipCrsValidation
bool skipCrsValidation
Controls whether the layer is allowed to have an invalid/unknown CRS.
Definition qgsvectorlayer.h:503
Generated on Fri Jul 18 2025 14:01:06 for QGIS API Documentation by doxygen 1.9.8