Class: QgsDatabaseTableComboBox¶
The QgsDatabaseTableComboBox
class is a combo box which
displays the list of tables for a specific database connection.
Warning
The provider must support the connection API methods in its QgsProviderMetadata
implementation
in order for the combobox to work correctly.
Added in version 3.14.
Class Hierarchy¶
Base classes¶
Methods
Returns |
|
Returns the combobox portion of the widget. |
|
Returns the schema of the current table selected in the combo box. |
|
Returns the name of the current table selected in the combo box. |
|
Refreshes the list of available tables. |
|
Sets whether an optional empty table ("not set") option is present in the combobox. |
|
Sets the database connection name from which to retrieve the available tables. |
|
Sets the schema from which to retrieve the available tables. |
|
Sets the current table selected in the combo box. |
Signals
Emitted whenever the currently selected table changes. |
- class qgis.gui.QgsDatabaseTableComboBox[source]¶
Bases:
QWidget
- __init__(provider: str | None, connection: str | None, schema: str | None = '', parent: QWidget | None = None)
Constructor for QgsDatabaseTableComboBox, for the specified
provider
andconnection
.The optional
schema
argument can be used to restrict the listed tables to a specific schema.Warning
The provider must support the connection API methods in its
QgsProviderMetadata
implementation in order for the model to work correctly.- Parameters:
provider (Optional[str])
connection (Optional[str])
schema (Optional[str] = '')
parent (Optional[QWidget] = None)
- __init__(connection: QgsAbstractDatabaseProviderConnection | None, schema: str | None = '', parent: QWidget | None = None)
Constructor for QgsDatabaseTableComboBox, for the specified
connection
.The optional
schema
argument can be used to restrict the listed tables to a specific schema.Ownership of
connection
is transferred to the combobox.- Parameters:
connection (Optional[QgsAbstractDatabaseProviderConnection])
schema (Optional[str] = '')
parent (Optional[QWidget] = None)
- allowEmptyTable(self) bool [source]¶
Returns
True
if the combobox allows the empty table (“not set”) choice.See also
- Return type:
bool
- comboBox(self) QComboBox | None [source]¶
Returns the combobox portion of the widget.
- Return type:
Optional[QComboBox]
- currentSchema(self) str [source]¶
Returns the schema of the current table selected in the combo box.
- Return type:
str
- currentTable(self) str [source]¶
Returns the name of the current table selected in the combo box.
- Return type:
str
- setAllowEmptyTable(self, allowEmpty: bool)[source]¶
Sets whether an optional empty table (“not set”) option is present in the combobox.
See also
- Parameters:
allowEmpty (bool)
- setConnectionName(self, connection: str | None, provider: str | None = '')[source]¶
Sets the database connection name from which to retrieve the available tables.
Optionally the
provider
can be reset too.- Parameters:
connection (Optional[str])
provider (Optional[str] = '')
- setSchema(self, schema: str | None)[source]¶
Sets the
schema
from which to retrieve the available tables.- Parameters:
schema (Optional[str])