17#include "moc_qgsdbrelationshipwidget.cpp"
21#include <QDialogButtonBox>
23#include <QSortFilterProxyModel>
31 , mConnection( connection )
47 if ( cardinalities.contains( cardinality ) )
58 if ( strengths.contains( strength ) )
65 mForwardLabelLineEdit->hide();
66 mForwardLabel->hide();
71 mBackwardLabelLineEdit->hide();
72 mReverseLabel->hide();
76 mRelatedTableTypeCombo->addItems( relatedTableTypes );
78 mProxyModel =
new QSortFilterProxyModel( mTableModel );
79 mProxyModel->setSourceModel( mTableModel );
80 mProxyModel->setDynamicSortFilter(
true );
81 mProxyModel->setSortCaseSensitivity( Qt::CaseInsensitive );
82 mProxyModel->setSortRole( Qt::DisplayRole );
83 mProxyModel->sort( 0 );
85 mLeftTableCombo->setModel( mProxyModel );
86 mRightTableCombo->setModel( mProxyModel );
88 connect( mNameEdit, &QLineEdit::textChanged,
this, [ = ]
92 connect( mLeftTableCombo, qOverload< int >( &QComboBox::currentIndexChanged ),
this, [ = ](
int )
94 mLeftFieldsCombo->setFields( mConnection->
fields( QString(), mLeftTableCombo->currentText() ) );
97 connect( mRightTableCombo, qOverload< int >( &QComboBox::currentIndexChanged ),
this, [ = ](
int )
99 mRightFieldsCombo->setFields( mConnection->
fields( QString(), mRightTableCombo->currentText() ) );
103 for ( QComboBox *combo :
106 qobject_cast< QComboBox *>( mLeftFieldsCombo ),
107 qobject_cast< QComboBox *>( mRightFieldsCombo ),
109 mRelatedTableTypeCombo
112 connect( combo, qOverload< int >( &QComboBox::currentIndexChanged ),
this, [ = ](
int )
118 mLeftFieldsCombo->setFields( mConnection->
fields( QString(), mLeftTableCombo->currentText() ) );
119 mRightFieldsCombo->setFields( mConnection->
fields( QString(), mRightTableCombo->currentText() ) );
125 mNameEdit->setText( mRelation.
name() );
126 mNameEdit->setEnabled(
false );
127 mStrengthCombo->setCurrentIndex( mStrengthCombo->findData( QVariant::fromValue( mRelation.
strength() ) ) );
130 mLeftTableCombo->setCurrentText( parts.value( QStringLiteral(
"layerName" ) ).toString() );
132 mRightTableCombo->setCurrentText( parts.value( QStringLiteral(
"layerName" ) ).toString() );
134 mCardinalityCombo->setCurrentIndex( mCardinalityCombo->findData( QVariant::fromValue( mRelation.
cardinality() ) ) );
145 mRelation.
name().isEmpty() ? mNameEdit->text() : mRelation.
name(),
149 mConnection->
tableUri( QString(), mRightTableCombo->currentText() ),
153 mConnection->
tableUri( QString(), mLeftTableCombo->currentText() ),
157 result.setReferencedLayerFields( { mLeftFieldsCombo->currentText() } );
158 result.setReferencingLayerFields( { mRightFieldsCombo->currentText() } );
159 result.setForwardPathLabel( mForwardLabelLineEdit->text() );
160 result.setBackwardPathLabel( mBackwardLabelLineEdit->text() );
166 if ( mRelatedTableTypeCombo->currentIndex() >= 0 )
167 result.setRelatedTableType( mRelatedTableTypeCombo->currentText() );
173 if ( mNameEdit->text().trimmed().isEmpty() )
176 if ( mLeftTableCombo->currentText().isEmpty() )
179 if ( mRightTableCombo->currentText().isEmpty() )
182 if ( mLeftTableCombo->currentText() == mRightTableCombo->currentText() )
185 if ( mLeftFieldsCombo->currentText().isEmpty() )
188 if ( mRightFieldsCombo->currentText().isEmpty() )
200 : QDialog( parent, flags )
202 setObjectName( QStringLiteral(
"QgsDbRelationDialog" ) );
204 QVBoxLayout *vLayout =
new QVBoxLayout();
206 vLayout->addWidget( mWidget, 1 );
208 mButtonBox =
new QDialogButtonBox( QDialogButtonBox::Ok | QDialogButtonBox::Cancel );
209 connect( mButtonBox, &QDialogButtonBox::accepted,
this, &QDialog::accept );
210 connect( mButtonBox, &QDialogButtonBox::rejected,
this, &QDialog::reject );
211 vLayout->addWidget( mButtonBox );
213 setLayout( vLayout );
215 validityChanged( mWidget->
isValid() );
238void QgsDbRelationDialog::validityChanged(
bool isValid )
240 mButtonBox->button( QDialogButtonBox::Ok )->setEnabled( isValid );
RelationshipStrength
Relationship strength.
@ Composition
Fix relation, related elements are part of the parent and a parent copy will copy any children or del...
@ Association
Loose relation, related elements are not part of the parent and a parent copy will not copy any child...
@ BackwardPathLabel
Supports backward path labels.
@ ForwardPathLabel
Supports forward path labels.
RelationshipCardinality
Relationship cardinality.
@ ManyToMany
Many to many relationship.
@ ManyToOne
Many to one relationship.
@ OneToOne
One to one relationship.
@ OneToMany
One to many relationship.
QFlags< RelationshipCapability > RelationshipCapabilities
Relationship capabilities.
The QgsAbstractDatabaseProviderConnection class provides common functionality for DB based connection...
QString providerKey() const
Returns the provider key.
virtual QString tableUri(const QString &schema, const QString &name) const
Returns the URI string for the given table and schema.
virtual QStringList relatedTableTypes() const
Returns a list of the related table types supported by the database format.
virtual Qgis::RelationshipCapabilities supportedRelationshipCapabilities() const
Returns the relationship capabilities supported by the provider.
virtual QList< Qgis::RelationshipCardinality > supportedRelationshipCardinalities() const
Returns a list of relationship cardinalities which are supported by the provider.
virtual QList< Qgis::RelationshipStrength > supportedRelationshipStrengths() const
Returns a list of relationship strengths which are supported by the provider.
virtual QgsFields fields(const QString &schema, const QString &table, QgsFeedback *feedback=nullptr) const
Returns the fields of a table and schema.
A model containing tables from a database connection.
QgsDbRelationDialog(QgsAbstractDatabaseProviderConnection *connection, QWidget *parent=nullptr, Qt::WindowFlags flags=Qt::WindowFlags())
Constructor for QgsDbRelationDialog, with the specified parent widget and window flags,...
QgsWeakRelation relationship() const
Returns the relationship as defined in the dialog.
void setRelationship(const QgsWeakRelation &relationship)
Sets the current relationship to show properties for in the dialog.
static void enableAutoGeometryRestore(QWidget *widget, const QString &key=QString())
Register the widget to allow its position to be automatically saved and restored when open and closed...
QVariantMap decodeUri(const QString &providerKey, const QString &uri)
Breaks a provider data source URI into its component paths (e.g.
static QgsProviderRegistry * instance(const QString &pluginPath=QString())
Means of accessing canonical single instance.
static QString cardinalityToDisplayString(Qgis::RelationshipCardinality cardinality)
Returns a user-friendly translated string representing a relationship cardinality.
static QString strengthToDisplayString(Qgis::RelationshipStrength strength)
Returns a user-friendly translated string representing a relationship strength.
The QgsWeakRelation class represent a QgsRelation with possibly unresolved layers or unmatched fields...
QStringList mappingReferencingLayerFields() const
Returns the list of fields from the mappingTable() involved in the relationship.
QString relatedTableType() const
Returns the type string of the related table.
QString name() const
Returns the relationship's name.
QString backwardPathLabel() const
Returns the label of the backward path for the relationship.
QString referencedLayerSource() const
Returns the source URI for the referenced (or "parent" / "left") layer.
QString referencingLayerSource() const
Returns the source URI for the referencing (or "child" / "right") layer.
QString id() const
Returns the relationship's ID.
QString forwardPathLabel() const
Returns the label of the forward path for the relationship.
Qgis::RelationshipCardinality cardinality() const
Returns the relationship's cardinality.
QgsVectorLayerRef mappingTable() const
Returns a weak reference to the mapping table, which forms the middle table in many-to-many relations...
void setCardinality(Qgis::RelationshipCardinality cardinality)
Sets the relationship's cardinality.
QStringList referencedLayerFields() const
Returns the list of fields from the referencedLayer() involved in the relationship.
QStringList mappingReferencedLayerFields() const
Returns the list of fields from the mappingTable() involved in the relationship.
QStringList referencingLayerFields() const
Returns the list of fields from the referencingLayer() involved in the relationship.
Qgis::RelationshipStrength strength() const
Returns the strength of the relation.