6
6
<rect >
7
7
<x >0</x >
8
8
<y >0</y >
9
- <width >626 </width >
9
+ <width >679 </width >
10
10
<height >525</height >
11
11
</rect >
12
12
</property >
13
+ <property name =" sizePolicy" >
14
+ <sizepolicy hsizetype =" Preferred" vsizetype =" Preferred" >
15
+ <horstretch >0</horstretch >
16
+ <verstretch >0</verstretch >
17
+ </sizepolicy >
18
+ </property >
13
19
<property name =" windowTitle" >
14
- <string >SQL window </string >
20
+ <string >SQL Window </string >
15
21
</property >
16
22
<layout class =" QGridLayout" name =" gridLayout_2" >
17
23
<item row =" 1" column =" 0" >
32
38
<bool >true</bool >
33
39
</property >
34
40
<layout class =" QGridLayout" name =" gridLayout" >
35
- <item row =" 0" column =" 0" >
41
+ <item row =" 0" column =" 0" colspan = " 2 " >
36
42
<widget class =" QWidget" name =" loadAsLayerWidget" native =" true" >
37
43
<layout class =" QGridLayout" name =" gridLayout_3" >
38
- <property name =" margin " >
44
+ <property name =" leftMargin " >
39
45
<number >0</number >
40
46
</property >
41
- <item row =" 2" column =" 0" >
42
- <layout class =" QHBoxLayout" name =" horizontalLayout_2" >
43
- <item >
44
- <widget class =" QCheckBox" name =" avoidSelectById" >
45
- <property name =" toolTip" >
46
- <string >< html>< head/>< body>< p> Avoid selecting feature by id. Sometimes - especially when running expensive queries/views - fetching the data sequentially instead of fetching features by id can be much quicker.< /p>< /body>< /html> </string >
47
- </property >
48
- <property name =" text" >
49
- <string >Avoid selecting by feature id</string >
50
- </property >
51
- </widget >
52
- </item >
53
- <item >
54
- <spacer name =" horizontalSpacer_2" >
55
- <property name =" orientation" >
56
- <enum >Qt::Horizontal</enum >
57
- </property >
58
- <property name =" sizeHint" stdset =" 0" >
59
- <size >
60
- <width >40</width >
61
- <height >20</height >
62
- </size >
63
- </property >
64
- </spacer >
65
- </item >
66
- <item >
67
- <widget class =" QPushButton" name =" loadLayerBtn" >
68
- <property name =" text" >
69
- <string >Load now!</string >
70
- </property >
71
- </widget >
72
- </item >
73
- </layout >
74
- </item >
75
- <item row =" 0" column =" 0" >
76
- <layout class =" QHBoxLayout" name =" horizontalLayout_6" >
77
- <item >
78
- <widget class =" QCheckBox" name =" uniqueColumnCheck" >
79
- <property name =" text" >
80
- <string >Column(s) with
81
- unique values</string >
82
- </property >
83
- </widget >
84
- </item >
85
- <item >
86
- <widget class =" QComboBox" name =" uniqueCombo" >
87
- <property name =" enabled" >
88
- <bool >false</bool >
89
- </property >
90
- <property name =" sizePolicy" >
91
- <sizepolicy hsizetype =" Expanding" vsizetype =" Fixed" >
92
- <horstretch >0</horstretch >
93
- <verstretch >0</verstretch >
94
- </sizepolicy >
95
- </property >
96
- <property name =" editable" >
97
- <bool >true</bool >
98
- </property >
99
- <property name =" insertPolicy" >
100
- <enum >QComboBox::NoInsert</enum >
101
- </property >
102
- </widget >
103
- </item >
104
- <item >
105
- <widget class =" QCheckBox" name =" hasGeometryCol" >
106
- <property name =" text" >
107
- <string >Geometry column</string >
108
- </property >
109
- <property name =" checked" >
110
- <bool >true</bool >
111
- </property >
112
- <property name =" tristate" >
113
- <bool >false</bool >
114
- </property >
115
- </widget >
116
- </item >
117
- <item >
118
- <widget class =" QComboBox" name =" geomCombo" >
119
- <property name =" sizePolicy" >
120
- <sizepolicy hsizetype =" Expanding" vsizetype =" Fixed" >
121
- <horstretch >0</horstretch >
122
- <verstretch >0</verstretch >
123
- </sizepolicy >
124
- </property >
125
- <property name =" editable" >
126
- <bool >true</bool >
127
- </property >
128
- <property name =" insertPolicy" >
129
- <enum >QComboBox::NoInsert</enum >
130
- </property >
131
- </widget >
132
- </item >
133
- <item >
134
- <spacer name =" horizontalSpacer_5" >
135
- <property name =" orientation" >
136
- <enum >Qt::Horizontal</enum >
137
- </property >
138
- <property name =" sizeType" >
139
- <enum >QSizePolicy::Fixed</enum >
140
- </property >
141
- <property name =" sizeHint" stdset =" 0" >
142
- <size >
143
- <width >40</width >
144
- <height >20</height >
145
- </size >
146
- </property >
147
- </spacer >
148
- </item >
149
- <item >
150
- <widget class =" QPushButton" name =" getColumnsBtn" >
151
- <property name =" text" >
152
- <string >Retrieve
47
+ <property name =" topMargin" >
48
+ <number >0</number >
49
+ </property >
50
+ <property name =" rightMargin" >
51
+ <number >0</number >
52
+ </property >
53
+ <property name =" bottomMargin" >
54
+ <number >0</number >
55
+ </property >
56
+ <item row =" 0" column =" 3" >
57
+ <widget class =" QPushButton" name =" getColumnsBtn" >
58
+ <property name =" text" >
59
+ <string >Retrieve
153
60
columns</string >
154
- </property >
155
- </widget >
156
- </item >
157
- </layout >
61
+ </property >
62
+ </widget >
63
+ </item >
64
+ <item row =" 2" column =" 1" >
65
+ <spacer name =" horizontalSpacer_2" >
66
+ <property name =" orientation" >
67
+ <enum >Qt::Horizontal</enum >
68
+ </property >
69
+ <property name =" sizeHint" stdset =" 0" >
70
+ <size >
71
+ <width >40</width >
72
+ <height >20</height >
73
+ </size >
74
+ </property >
75
+ </spacer >
76
+ </item >
77
+ <item row =" 1" column =" 3" >
78
+ <widget class =" QPushButton" name =" btnSetFilter" >
79
+ <property name =" text" >
80
+ <string >Set filter</string >
81
+ </property >
82
+ <property name =" autoDefault" >
83
+ <bool >false</bool >
84
+ </property >
85
+ </widget >
86
+ </item >
87
+ <item row =" 2" column =" 3" >
88
+ <widget class =" QPushButton" name =" loadLayerBtn" >
89
+ <property name =" text" >
90
+ <string >Load</string >
91
+ </property >
92
+ </widget >
93
+ </item >
94
+ <item row =" 2" column =" 0" >
95
+ <widget class =" QCheckBox" name =" avoidSelectById" >
96
+ <property name =" toolTip" >
97
+ <string >< html>< head/>< body>< p> Avoid selecting feature by id. Sometimes - especially when running expensive queries/views - fetching the data sequentially instead of fetching features by id can be much quicker.< /p>< /body>< /html> </string >
98
+ </property >
99
+ <property name =" text" >
100
+ <string >Avoid selecting by feature id</string >
101
+ </property >
102
+ </widget >
158
103
</item >
159
- <item row =" 1" column =" 0" >
104
+ <item row =" 1" column =" 0" colspan = " 2 " >
160
105
<layout class =" QHBoxLayout" name =" horizontalLayout_7" >
161
106
<item >
162
107
<widget class =" QLabel" name =" label_5" >
@@ -217,33 +162,67 @@ columns</string>
217
162
</property >
218
163
</widget >
219
164
</item >
220
- <item >
221
- <spacer name =" horizontalSpacer_6" >
222
- <property name =" orientation" >
223
- <enum >Qt::Horizontal</enum >
224
- </property >
225
- <property name =" sizeType" >
226
- <enum >QSizePolicy::Fixed</enum >
227
- </property >
228
- <property name =" sizeHint" stdset =" 0" >
229
- <size >
230
- <width >40</width >
231
- <height >20</height >
232
- </size >
233
- </property >
234
- </spacer >
235
- </item >
236
165
</layout >
237
166
</widget >
238
167
</item >
168
+ </layout >
169
+ </item >
170
+ <item row =" 0" column =" 0" colspan =" 2" >
171
+ <layout class =" QHBoxLayout" name =" horizontalLayout_6" >
239
172
<item >
240
- <widget class =" QPushButton " name =" btnSetFilter " >
173
+ <widget class =" QCheckBox " name =" uniqueColumnCheck " >
241
174
<property name =" text" >
242
- <string >Set filter</string >
175
+ <string >Column(s) with
176
+ unique values</string >
243
177
</property >
244
- <property name =" autoDefault" >
178
+ </widget >
179
+ </item >
180
+ <item >
181
+ <widget class =" QComboBox" name =" uniqueCombo" >
182
+ <property name =" enabled" >
245
183
<bool >false</bool >
246
184
</property >
185
+ <property name =" sizePolicy" >
186
+ <sizepolicy hsizetype =" Expanding" vsizetype =" Fixed" >
187
+ <horstretch >0</horstretch >
188
+ <verstretch >0</verstretch >
189
+ </sizepolicy >
190
+ </property >
191
+ <property name =" editable" >
192
+ <bool >true</bool >
193
+ </property >
194
+ <property name =" insertPolicy" >
195
+ <enum >QComboBox::NoInsert</enum >
196
+ </property >
197
+ </widget >
198
+ </item >
199
+ <item >
200
+ <widget class =" QCheckBox" name =" hasGeometryCol" >
201
+ <property name =" text" >
202
+ <string >Geometry column</string >
203
+ </property >
204
+ <property name =" checked" >
205
+ <bool >true</bool >
206
+ </property >
207
+ <property name =" tristate" >
208
+ <bool >false</bool >
209
+ </property >
210
+ </widget >
211
+ </item >
212
+ <item >
213
+ <widget class =" QComboBox" name =" geomCombo" >
214
+ <property name =" sizePolicy" >
215
+ <sizepolicy hsizetype =" Expanding" vsizetype =" Fixed" >
216
+ <horstretch >0</horstretch >
217
+ <verstretch >0</verstretch >
218
+ </sizepolicy >
219
+ </property >
220
+ <property name =" editable" >
221
+ <bool >true</bool >
222
+ </property >
223
+ <property name =" insertPolicy" >
224
+ <enum >QComboBox::NoInsert</enum >
225
+ </property >
247
226
</widget >
248
227
</item >
249
228
</layout >
@@ -286,12 +265,19 @@ columns</string>
286
265
<item >
287
266
<widget class =" QLabel" name =" label" >
288
267
<property name =" text" >
289
- <string >Saved query: </string >
268
+ <string >Saved query</string >
290
269
</property >
291
270
</widget >
292
271
</item >
293
272
<item >
294
- <widget class =" QComboBox" name =" presetCombo" />
273
+ <widget class =" QComboBox" name =" presetCombo" >
274
+ <property name =" sizePolicy" >
275
+ <sizepolicy hsizetype =" Expanding" vsizetype =" Fixed" >
276
+ <horstretch >1</horstretch >
277
+ <verstretch >0</verstretch >
278
+ </sizepolicy >
279
+ </property >
280
+ </widget >
295
281
</item >
296
282
<item >
297
283
<widget class =" QLabel" name =" label_2" >
@@ -302,6 +288,12 @@ columns</string>
302
288
</item >
303
289
<item >
304
290
<widget class =" QLineEdit" name =" presetName" >
291
+ <property name =" sizePolicy" >
292
+ <sizepolicy hsizetype =" Expanding" vsizetype =" Fixed" >
293
+ <horstretch >1</horstretch >
294
+ <verstretch >0</verstretch >
295
+ </sizepolicy >
296
+ </property >
305
297
<property name =" text" >
306
298
<string notr =" true" />
307
299
</property >
@@ -310,7 +302,7 @@ columns</string>
310
302
<item >
311
303
<widget class =" QPushButton" name =" presetStore" >
312
304
<property name =" text" >
313
- <string >Store </string >
305
+ <string >Save </string >
314
306
</property >
315
307
</widget >
316
308
</item >
@@ -408,9 +400,28 @@ columns</string>
408
400
</customwidget >
409
401
</customwidgets >
410
402
<tabstops >
403
+ <tabstop >queryBuilderBtn</tabstop >
404
+ <tabstop >presetCombo</tabstop >
405
+ <tabstop >presetName</tabstop >
406
+ <tabstop >presetStore</tabstop >
407
+ <tabstop >presetDelete</tabstop >
408
+ <tabstop >editSql</tabstop >
411
409
<tabstop >btnExecute</tabstop >
410
+ <tabstop >btnCreateView</tabstop >
412
411
<tabstop >btnClear</tabstop >
413
412
<tabstop >viewResult</tabstop >
413
+ <tabstop >loadAsLayerGroup</tabstop >
414
+ <tabstop >uniqueColumnCheck</tabstop >
415
+ <tabstop >uniqueCombo</tabstop >
416
+ <tabstop >hasGeometryCol</tabstop >
417
+ <tabstop >geomCombo</tabstop >
418
+ <tabstop >getColumnsBtn</tabstop >
419
+ <tabstop >layerNameEdit</tabstop >
420
+ <tabstop >vectorRadio</tabstop >
421
+ <tabstop >rasterRadio</tabstop >
422
+ <tabstop >btnSetFilter</tabstop >
423
+ <tabstop >avoidSelectById</tabstop >
424
+ <tabstop >loadLayerBtn</tabstop >
414
425
</tabstops >
415
426
<resources />
416
427
<connections >
0 commit comments