34 : QDialog( parent, fl )
35 , mOriginalConnName( connName )
40 connect( btnConnect, &QPushButton::clicked,
this, &QgsNewOgrConnection::btnConnect_clicked );
45 buttonBox->button( QDialogButtonBox::Ok )->setDisabled(
true );
46 connect( txtName, &QLineEdit::textChanged,
this, &QgsNewOgrConnection::updateOkButtonState );
47 connect( txtHost, &QLineEdit::textChanged,
this, &QgsNewOgrConnection::updateOkButtonState );
48 connect( txtDatabase, &QLineEdit::textChanged,
this, &QgsNewOgrConnection::updateOkButtonState );
49 connect( txtPort, &QLineEdit::textChanged,
this, &QgsNewOgrConnection::updateOkButtonState );
55 for (
int i = 0; i < dbDrivers.count(); i++ )
57 const QString dbDriver = dbDrivers.at( i );
58 if ( !dbDriver.isEmpty() )
59 cmbDatabaseTypes->addItem( dbDriver.split(
',' ).at( 0 ) );
61 txtName->setEnabled(
true );
62 cmbDatabaseTypes->setEnabled(
true );
64 if ( !connType.isEmpty() )
66 cmbDatabaseTypes->setCurrentIndex( cmbDatabaseTypes->findText( connType ) );
69 if ( !connName.isEmpty() )
73 const QString key =
'/' + connType +
"/connections/" + connName;
74 txtHost->setText( settings.
value( key +
"/host" ).toString() );
75 txtDatabase->setText( settings.
value( key +
"/database" ).toString() );
76 const QString port = settings.
value( key +
"/port" ).toString();
77 txtPort->setText( port );
78 if ( settings.
value( key +
"/store_username" ).toString() == QLatin1String(
"true" ) )
80 mAuthSettingsDatabase->setUsername( settings.
value( key +
"/username" ).toString() );
81 mAuthSettingsDatabase->setStoreUsernameChecked(
true );
83 if ( settings.
value( key +
"/store_password" ).toString() == QLatin1String(
"true" ) )
85 mAuthSettingsDatabase->setPassword( settings.
value( key +
"/password" ).toString() );
86 mAuthSettingsDatabase->setStorePasswordChecked(
true );
88 mAuthSettingsDatabase->setConfigId( settings.
value( key +
"/configid" ).toString() );
89 txtName->setText( connName );
90 txtName->setEnabled(
false );
91 cmbDatabaseTypes->setEnabled(
false );
93 txtName->setValidator(
new QRegularExpressionValidator( QRegularExpression(
"[^\\/]+" ), txtName ) );
94 mAuthSettingsDatabase->setDataprovider( QStringLiteral(
"ogr" ) );
95 mAuthSettingsDatabase->showStoreCheckboxes(
true );
104 mAuthSettingsDatabase->configId(),
105 mAuthSettingsDatabase->username(),
106 mAuthSettingsDatabase->password(),
111 OGRSFDriverH pahDriver;
113 poDS = OGROpen( uri.toUtf8().constData(),
false, &pahDriver );
116 QMessageBox::information(
this, tr(
"Test Connection" ), tr(
"Connection failed - Check settings and try again.\n\nExtended error information:\n%1" ).arg( QString::fromUtf8( CPLGetLastErrorMsg() ) ) );
120 QMessageBox::information(
this, tr(
"Test Connection" ), tr(
"Connection to %1 was successful." ).arg( uri ) );
121 OGRReleaseDataSource( poDS );
141 QString baseKey =
'/' + cmbDatabaseTypes->currentText() +
"/connections/";
142 settings.
setValue( baseKey +
"selected", txtName->text() );
145 if ( ( mOriginalConnName.isNull() || mOriginalConnName != txtName->text() ) &&
146 settings.
contains( baseKey + txtName->text() +
"/host" ) &&
147 QMessageBox::question(
this,
148 tr(
"Save Connection" ),
149 tr(
"Should the existing connection %1 be overwritten?" ).arg( txtName->text() ),
150 QMessageBox::Ok | QMessageBox::Cancel ) == QMessageBox::Cancel )
156 if ( !mOriginalConnName.isNull() && mOriginalConnName != txtName->text() )
158 settings.
remove( baseKey + mOriginalConnName );
161 baseKey += txtName->text();
162 settings.
setValue( baseKey +
"/host", txtHost->text() );
163 settings.
setValue( baseKey +
"/database", txtDatabase->text() );
164 settings.
setValue( baseKey +
"/port", txtPort->text() );
165 settings.
setValue( baseKey +
"/username", mAuthSettingsDatabase->storeUsernameIsChecked() ? mAuthSettingsDatabase->username() : QString() );
166 settings.
setValue( baseKey +
"/password", mAuthSettingsDatabase->storePasswordIsChecked() ? mAuthSettingsDatabase->password() : QString() );
167 settings.
setValue( baseKey +
"/store_username", mAuthSettingsDatabase->storeUsernameIsChecked() ?
"true" :
"false" );
168 settings.
setValue( baseKey +
"/store_password", mAuthSettingsDatabase->storePasswordIsChecked() ?
"true" :
"false" );
169 settings.
setValue( baseKey +
"/configid", mAuthSettingsDatabase->configId() );
static QString createDatabaseURI(const QString &connectionType, const QString &host, const QString &database, QString port, const QString &configId, QString username, QString password, bool expandAuthConfig=false)
Create database uri from connection parameters.