QGIS API Documentation  3.37.0-Master (a5b4d9743e8)
Classes | Public Types | Public Member Functions | Protected Member Functions | List of all members
QgsSQLComposerDialog Class Reference

SQL composer dialog. More...

#include <qgssqlcomposerdialog.h>

Inheritance diagram for QgsSQLComposerDialog:
Inheritance graph
[legend]

Classes

struct  Argument
 argument of a function More...
 
struct  Function
 description of server functions More...
 
class  SQLValidatorCallback
 Callback to do validation check on dialog validation. More...
 
class  TableSelectedCallback
 Callback to do actions on table selection. More...
 

Public Types

typedef QPair< QString, QString > PairNameTitle
 pair (name, title) More...
 
typedef QPair< QString, QString > PairNameType
 pair (name, type) More...
 

Public Member Functions

 QgsSQLComposerDialog (QgsVectorLayer *layer, QWidget *parent=nullptr, Qt::WindowFlags fl=QgsGuiUtils::ModalDialogFlags)
 This constructor is used on an existing layer. More...
 
 QgsSQLComposerDialog (QWidget *parent=nullptr, Qt::WindowFlags fl=QgsGuiUtils::ModalDialogFlags)
 constructor More...
 
 ~QgsSQLComposerDialog () override
 
void addApis (const QStringList &list)
 add a list of API for autocompletion More...
 
void addColumnNames (const QList< PairNameType > &list, const QString &tableName)
 add a list of column names More...
 
void addColumnNames (const QStringList &list, const QString &tableName)
 add a list of column names More...
 
void addFunctions (const QList< Function > &list)
 add a list of functions More...
 
void addFunctions (const QStringList &list)
 add a list of functions More...
 
void addOperators (const QStringList &list)
 add a list of operators More...
 
void addSpatialPredicates (const QList< Function > &list)
 add a list of spatial predicates More...
 
void addSpatialPredicates (const QStringList &list)
 add a list of spatial predicates More...
 
void addTableNames (const QList< PairNameTitle > &listNameTitle)
 add a list of table names More...
 
void addTableNames (const QStringList &list)
 add a list of table names More...
 
void setSql (const QString &sql)
 initialize the SQL statement More...
 
void setSQLValidatorCallback (SQLValidatorCallback *sqlValidatorCallback)
 Set a callback that will be called when the OK button is pushed. More...
 
void setSubsetString (const QString &subsetString) override
 Sets a subset string into the dialog. More...
 
void setSupportMultipleTables (bool bMultipleTables, const QString &mainTypename=QString())
 Sets if multiple tables/joins are supported. Default is false. More...
 
void setTableSelectedCallback (TableSelectedCallback *tableSelectedCallback)
 Set a callback that will be called when a new table is selected, so that new column names can be added typically. More...
 
QString sql () const
 Gets the SQL statement. More...
 
QString subsetString () const override
 Returns the subset string entered in the dialog. More...
 
- Public Member Functions inherited from QgsSubsetStringEditorInterface
 QgsSubsetStringEditorInterface (QWidget *parent=nullptr, Qt::WindowFlags fl=QgsGuiUtils::ModalDialogFlags)
 Constructor. More...
 

Protected Member Functions

bool eventFilter (QObject *obj, QEvent *event) override
 

Detailed Description

SQL composer dialog.

Note
not available in Python bindings

Definition at line 41 of file qgssqlcomposerdialog.h.

Member Typedef Documentation

◆ PairNameTitle

typedef QPair<QString, QString> QgsSQLComposerDialog::PairNameTitle

pair (name, title)

Definition at line 48 of file qgssqlcomposerdialog.h.

◆ PairNameType

typedef QPair<QString, QString> QgsSQLComposerDialog::PairNameType

pair (name, type)

Definition at line 51 of file qgssqlcomposerdialog.h.

Constructor & Destructor Documentation

◆ QgsSQLComposerDialog() [1/2]

QgsSQLComposerDialog::QgsSQLComposerDialog ( QWidget *  parent = nullptr,
Qt::WindowFlags  fl = QgsGuiUtils::ModalDialogFlags 
)
explicit

constructor

Definition at line 31 of file qgssqlcomposerdialog.cpp.

◆ QgsSQLComposerDialog() [2/2]

QgsSQLComposerDialog::QgsSQLComposerDialog ( QgsVectorLayer layer,
QWidget *  parent = nullptr,
Qt::WindowFlags  fl = QgsGuiUtils::ModalDialogFlags 
)

This constructor is used on an existing layer.

On successful accept, it will update the layer subset string.

Parameters
layerexisting vector layer
parentParent widget
fldialog flags

Definition at line 35 of file qgssqlcomposerdialog.cpp.

◆ ~QgsSQLComposerDialog()

QgsSQLComposerDialog::~QgsSQLComposerDialog ( )
override

Definition at line 127 of file qgssqlcomposerdialog.cpp.

Member Function Documentation

◆ addApis()

void QgsSQLComposerDialog::addApis ( const QStringList &  list)

add a list of API for autocompletion

Definition at line 765 of file qgssqlcomposerdialog.cpp.

◆ addColumnNames() [1/2]

void QgsSQLComposerDialog::addColumnNames ( const QList< PairNameType > &  list,
const QString &  tableName 
)

add a list of column names

Definition at line 406 of file qgssqlcomposerdialog.cpp.

◆ addColumnNames() [2/2]

void QgsSQLComposerDialog::addColumnNames ( const QStringList &  list,
const QString &  tableName 
)

add a list of column names

Definition at line 386 of file qgssqlcomposerdialog.cpp.

◆ addFunctions() [1/2]

void QgsSQLComposerDialog::addFunctions ( const QList< Function > &  list)

add a list of functions

Definition at line 547 of file qgssqlcomposerdialog.cpp.

◆ addFunctions() [2/2]

void QgsSQLComposerDialog::addFunctions ( const QStringList &  list)

add a list of functions

Definition at line 534 of file qgssqlcomposerdialog.cpp.

◆ addOperators()

void QgsSQLComposerDialog::addOperators ( const QStringList &  list)

add a list of operators

Definition at line 431 of file qgssqlcomposerdialog.cpp.

◆ addSpatialPredicates() [1/2]

void QgsSQLComposerDialog::addSpatialPredicates ( const QList< Function > &  list)

add a list of spatial predicates

Definition at line 524 of file qgssqlcomposerdialog.cpp.

◆ addSpatialPredicates() [2/2]

void QgsSQLComposerDialog::addSpatialPredicates ( const QStringList &  list)

add a list of spatial predicates

Definition at line 511 of file qgssqlcomposerdialog.cpp.

◆ addTableNames() [1/2]

void QgsSQLComposerDialog::addTableNames ( const QList< PairNameTitle > &  listNameTitle)

add a list of table names

Definition at line 363 of file qgssqlcomposerdialog.cpp.

◆ addTableNames() [2/2]

void QgsSQLComposerDialog::addTableNames ( const QStringList &  list)

add a list of table names

Definition at line 354 of file qgssqlcomposerdialog.cpp.

◆ eventFilter()

bool QgsSQLComposerDialog::eventFilter ( QObject *  obj,
QEvent *  event 
)
overrideprotected

Definition at line 136 of file qgssqlcomposerdialog.cpp.

◆ setSql()

void QgsSQLComposerDialog::setSql ( const QString &  sql)

initialize the SQL statement

Definition at line 203 of file qgssqlcomposerdialog.cpp.

◆ setSQLValidatorCallback()

void QgsSQLComposerDialog::setSQLValidatorCallback ( SQLValidatorCallback sqlValidatorCallback)

Set a callback that will be called when the OK button is pushed.

Ownership of the callback remains to the caller.

Definition at line 198 of file qgssqlcomposerdialog.cpp.

◆ setSubsetString()

void QgsSQLComposerDialog::setSubsetString ( const QString &  subsetString)
inlineoverridevirtual

Sets a subset string into the dialog.

Implements QgsSubsetStringEditorInterface.

Definition at line 133 of file qgssqlcomposerdialog.h.

◆ setSupportMultipleTables()

void QgsSQLComposerDialog::setSupportMultipleTables ( bool  bMultipleTables,
const QString &  mainTypename = QString() 
)

Sets if multiple tables/joins are supported. Default is false.

Definition at line 782 of file qgssqlcomposerdialog.cpp.

◆ setTableSelectedCallback()

void QgsSQLComposerDialog::setTableSelectedCallback ( TableSelectedCallback tableSelectedCallback)

Set a callback that will be called when a new table is selected, so that new column names can be added typically.

Ownership of the callback remains to the caller.

Definition at line 193 of file qgssqlcomposerdialog.cpp.

◆ sql()

QString QgsSQLComposerDialog::sql ( ) const

Gets the SQL statement.

Definition at line 209 of file qgssqlcomposerdialog.cpp.

◆ subsetString()

QString QgsSQLComposerDialog::subsetString ( ) const
inlineoverridevirtual

Returns the subset string entered in the dialog.

Implements QgsSubsetStringEditorInterface.

Definition at line 132 of file qgssqlcomposerdialog.h.


The documentation for this class was generated from the following files: