SqlBrowser/SqlBrowserWidget.py

changeset 2993
4933ac9daa80
parent 2965
d133c7edd88a
child 3020
542e97d4ecb3
child 3057
10516539f238
--- a/SqlBrowser/SqlBrowserWidget.py	Mon Oct 07 19:10:11 2013 +0200
+++ b/SqlBrowser/SqlBrowserWidget.py	Mon Oct 07 19:57:08 2013 +0200
@@ -9,7 +9,8 @@
 
 from PyQt4.QtCore import pyqtSignal, QVariant, Qt, pyqtSlot
 from PyQt4.QtGui import QWidget, QStandardItemModel, QDialog, QAbstractItemView
-from PyQt4.QtSql import QSqlDatabase, QSqlError, QSqlTableModel, QSqlQueryModel, QSqlQuery
+from PyQt4.QtSql import QSqlDatabase, QSqlError, QSqlTableModel, \
+    QSqlQueryModel, QSqlQuery
 
 from E5Gui import E5MessageBox
 
@@ -41,12 +42,15 @@
         if len(QSqlDatabase.drivers()) == 0:
             E5MessageBox.information(self,
                 self.trUtf8("No database drivers found"),
-                self.trUtf8("""This tool requires at least one Qt database driver. """
-                """Please check the Qt documentation how to build the """
-                """Qt SQL plugins."""))
+                self.trUtf8(
+                    """This tool requires at least one Qt database driver. """
+                    """Please check the Qt documentation how to build the """
+                    """Qt SQL plugins."""))
         
-        self.connections.tableActivated.connect(self.on_connections_tableActivated)
-        self.connections.schemaRequested.connect(self.on_connections_schemaRequested)
+        self.connections.tableActivated.connect(
+            self.on_connections_tableActivated)
+        self.connections.schemaRequested.connect(
+            self.on_connections_schemaRequested)
         self.connections.cleared.connect(self.on_connections_cleared)
         
         self.statusMessage.emit(self.trUtf8("Ready"))
@@ -125,15 +129,16 @@
         err = QSqlError()
         
         self.__class__.cCount += 1
-        db = QSqlDatabase.addDatabase(driver.upper(),
-                                      "Browser{0:d}".format(self.__class__.cCount))
+        db = QSqlDatabase.addDatabase(
+            driver.upper(), "Browser{0:d}".format(self.__class__.cCount))
         db.setDatabaseName(dbName)
         db.setHostName(host)
         db.setPort(port)
         if not db.open(user, password):
             err = db.lastError()
             db = QSqlDatabase()
-            QSqlDatabase.removeDatabase("Browser{0:d}".format(self.__class__.cCount))
+            QSqlDatabase.removeDatabase(
+                "Browser{0:d}".format(self.__class__.cCount))
         
         self.connections.refresh()
         
@@ -147,12 +152,14 @@
         dlg = SqlConnectionDialog(self)
         if dlg.exec_() == QDialog.Accepted:
             driver, dbName, user, password, host, port = dlg.getData()
-            err = self.addConnection(driver, dbName, user, password, host, port)
+            err = self.addConnection(
+                driver, dbName, user, password, host, port)
             
             if err.type() != QSqlError.NoError:
                 E5MessageBox.warning(self,
                     self.trUtf8("Unable to open database"),
-                    self.trUtf8("""An error occurred while opening the connection."""))
+                    self.trUtf8(
+                        """An error occurred while opening the connection."""))
     
     def showTable(self, table):
         """
@@ -172,7 +179,8 @@
         
         self.table.resizeColumnsToContents()
         
-        self.table.selectionModel().currentRowChanged.connect(self.updateActions)
+        self.table.selectionModel().currentRowChanged.connect(
+            self.updateActions)
         
         self.updateActions()
     
@@ -203,9 +211,9 @@
                 model.setData(model.index(i, 1),
                               QVariant.typeToName(fld.type()))
             else:
-                model.setData(model.index(i, 1), "{0} ({1})".format(
-                                                 QVariant.typeToName(fld.type()),
-                                                 fld.typeID()))
+                model.setData(
+                    model.index(i, 1), "{0} ({1})".format(
+                    QVariant.typeToName(fld.type()), fld.typeID()))
             if fld.length() < 0:
                 model.setData(model.index(i, 2), "?")
             else:
@@ -282,8 +290,8 @@
         Public slot to execute the entered query.
         """
         model = QSqlQueryModel(self.table)
-        model.setQuery(
-            QSqlQuery(self.sqlEdit.toPlainText(), self.connections.currentDatabase()))
+        model.setQuery(QSqlQuery(
+            self.sqlEdit.toPlainText(), self.connections.currentDatabase()))
         self.table.setModel(model)
         
         if model.lastError().type() != QSqlError.NoError:

eric ide

mercurial