diff -r f99d60d6b59b -r 2602857055c5 eric6/SqlBrowser/SqlConnectionDialog.py
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/eric6/SqlBrowser/SqlConnectionDialog.py Sun Apr 14 15:09:21 2019 +0200
@@ -0,0 +1,107 @@
+# -*- coding: utf-8 -*-
+
+# Copyright (c) 2009 - 2019 Detlev Offenbach <detlev@die-offenbachs.de>
+#
+
+"""
+Module implementing a dialog to enter the connection parameters.
+"""
+
+from __future__ import unicode_literals
+
+from PyQt5.QtCore import pyqtSlot
+from PyQt5.QtWidgets import QDialog, QDialogButtonBox
+from PyQt5.QtSql import QSqlDatabase
+
+from E5Gui.E5PathPicker import E5PathPickerModes
+
+from .Ui_SqlConnectionDialog import Ui_SqlConnectionDialog
+
+
+class SqlConnectionDialog(QDialog, Ui_SqlConnectionDialog):
+ """
+ Class implementing a dialog to enter the connection parameters.
+ """
+ def __init__(self, parent=None):
+ """
+ Constructor
+
+ @param parent reference to the parent widget (QWidget)
+ """
+ super(SqlConnectionDialog, self).__init__(parent)
+ self.setupUi(self)
+
+ self.databasePicker.setMode(E5PathPickerModes.OpenFileMode)
+
+ self.okButton = self.buttonBox.button(QDialogButtonBox.Ok)
+
+ drivers = QSqlDatabase.drivers()
+
+ # remove compatibility names
+ if "QMYSQL3" in drivers:
+ drivers.remove("QMYSQL3")
+ if "QOCI8" in drivers:
+ drivers.remove("QOCI8")
+ if "QODBC3" in drivers:
+ drivers.remove("QODBC3")
+ if "QPSQL7" in drivers:
+ drivers.remove("QPSQL7")
+ if "QTDS7" in drivers:
+ drivers.remove("QTDS7")
+
+ self.driverCombo.addItems(drivers)
+
+ self.__updateDialog()
+
+ msh = self.minimumSizeHint()
+ self.resize(max(self.width(), msh.width()), msh.height())
+
+ def __updateDialog(self):
+ """
+ Private slot to update the dialog depending on its contents.
+ """
+ driver = self.driverCombo.currentText()
+ if driver.startswith("QSQLITE"):
+ self.databasePicker.setPickerEnabled(True)
+ else:
+ self.databasePicker.setPickerEnabled(False)
+
+ if self.databasePicker.text() == "" or driver == "":
+ self.okButton.setEnabled(False)
+ else:
+ self.okButton.setEnabled(True)
+
+ @pyqtSlot(str)
+ def on_driverCombo_activated(self, txt):
+ """
+ Private slot handling the selection of a database driver.
+
+ @param txt text of the driver combo (string)
+ """
+ self.__updateDialog()
+
+ @pyqtSlot(str)
+ def on_databasePicker_textChanged(self, txt):
+ """
+ Private slot handling the change of the database name.
+
+ @param txt text of the edit (string)
+ """
+ self.__updateDialog()
+
+ def getData(self):
+ """
+ Public method to retrieve the connection data.
+
+ @return tuple giving the driver name (string), the database name
+ (string), the user name (string), the password (string), the
+ host name (string) and the port (integer)
+ """
+ return (
+ self.driverCombo.currentText(),
+ self.databasePicker.text(),
+ self.usernameEdit.text(),
+ self.passwordEdit.text(),
+ self.hostnameEdit.text(),
+ self.portSpinBox.value(),
+ )
