@@ -62,11 +62,11 @@ def __init__(self, iface, db, parent=None):
62
62
self .connect (self .btnClear , SIGNAL ("clicked()" ), self .clearSql )
63
63
self .connect (self .buttonBox .button (QDialogButtonBox .Close ), SIGNAL ("clicked()" ), self .close )
64
64
65
-
66
65
self .connect (self .presetStore , SIGNAL ("clicked()" ), self .storePreset )
67
66
self .connect (self .presetDelete , SIGNAL ("clicked()" ), self .deletePreset )
68
67
self .connect (self .presetCombo , SIGNAL ("activated(QString)" ), self .loadPreset )
69
68
self .connect (self .presetCombo , SIGNAL ("activated(QString)" ), self .presetName .setText )
69
+ self .updatePresetsCombobox ()
70
70
71
71
# hide the load query as layer if feature is not supported
72
72
self ._loadAsLayerAvailable = self .db .connector .hasCustomQuerySupport ()
@@ -78,22 +78,18 @@ def __init__(self, iface, db, parent=None):
78
78
self .connect (self .loadAsLayerGroup , SIGNAL ("toggled(bool)" ), self .loadAsLayerToggled )
79
79
self .loadAsLayerToggled (False )
80
80
81
- def showEvent (self , event ):
82
- QDialog .showEvent (self , event )
83
- self .updatePresetsCombobox ()
84
-
85
81
def updatePresetsCombobox (self ):
86
- entries = QgsProject .instance ().subkeyList ('DBManager' ,'savedQueries' )
87
82
self .presetCombo .clear ()
83
+
88
84
names = []
85
+ entries = QgsProject .instance ().subkeyList ('DBManager' ,'savedQueries' )
89
86
for entry in entries :
90
87
name = QgsProject .instance ().readEntry ('DBManager' ,'savedQueries/' + entry + '/name' )[0 ]
91
88
names .append ( name )
92
89
93
- names .sort ()
94
-
95
- for name in names :
90
+ for name in sorted (names ):
96
91
self .presetCombo .addItem (name )
92
+ self .presetCombo .setCurrentIndex (- 1 )
97
93
98
94
def storePreset (self ):
99
95
query = self .editSql .toPlainText ()
@@ -112,6 +108,7 @@ def deletePreset(self):
112
108
QgsProject .instance ().removeEntry ('DBManager' ,'savedQueries/q' + str (name .__hash__ ()) )
113
109
self .presetCombo .removeItem ( self .presetCombo .findText (name ) )
114
110
self .presetCombo .setCurrentIndex (- 1 )
111
+
115
112
def loadPreset (self , name ):
116
113
query = QgsProject .instance ().readEntry ('DBManager' ,'savedQueries/q' + str (name .__hash__ ())+ '/query' )[0 ]
117
114
name = QgsProject .instance ().readEntry ('DBManager' ,'savedQueries/q' + str (name .__hash__ ())+ '/name' )[0 ]
0 commit comments