set limit to 20 to store database query in the history

slarosa · slarosa · commit 84d86935e422 · 2018-04-05T22:53:04.000+02:00
diff --git a/python/plugins/db_manager/dlg_sql_window.py b/python/plugins/db_manager/dlg_sql_window.py
@@ -53,6 +53,7 @@
 
 class DlgSqlWindow(QWidget, Ui_Dialog):
     nameChanged = pyqtSignal(str)
+    QUERY_HISTORY_LIMIT = 20
 
     def __init__(self, iface, db, parent=None):
         QWidget.__init__(self, parent)
@@ -181,6 +182,9 @@ def populateQueryHistory(self):
         self.queryHistoryTableWidget.resizeRowsToContents()
 
     def writeQueryHistory(self, sql, affectedRows, secs):
+        if len(self.history[self.connectionName]) >= self.QUERY_HISTORY_LIMIT:
+            self.history[self.connectionName].pop(0)
+
         settings = QgsSettings()
         self.history[self.connectionName].append({'query': sql,
                                                   'rows': affectedRows,
