set limit to 20 to store database query in the history

qgis · Apr 5, 2018 · 84d8693 · 84d8693
1 parent 1242402
commit 84d8693
Showing 1 changed file with 4 additions and 0 deletions.
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,