Projekt

Obecné

Profil

« Předchozí | Další » 

Revize aed2fdb1

Přidáno uživatelem Dominik Poch před téměř 6 roky(ů)

Re #7551 Procedure fixes

Zobrazit rozdíly:

.idea/codeStyles/Project.xml
1 
<component name="ProjectCodeStyleConfiguration">
2 
  <code_scheme name="Project" version="173">
3 
    <DBN-PSQL>
4 
      <case-options enabled="true">
5 
        <option name="KEYWORD_CASE" value="lower" />
6 
        <option name="FUNCTION_CASE" value="lower" />
7 
        <option name="PARAMETER_CASE" value="lower" />
8 
        <option name="DATATYPE_CASE" value="lower" />
9 
        <option name="OBJECT_CASE" value="preserve" />
10 
      </case-options>
11 
      <formatting-settings enabled="false" />
12 
    </DBN-PSQL>
13 
    <DBN-SQL>
14 
      <case-options enabled="true">
15 
        <option name="KEYWORD_CASE" value="lower" />
16 
        <option name="FUNCTION_CASE" value="lower" />
17 
        <option name="PARAMETER_CASE" value="lower" />
18 
        <option name="DATATYPE_CASE" value="lower" />
19 
        <option name="OBJECT_CASE" value="preserve" />
20 
      </case-options>
21 
      <formatting-settings enabled="false">
22 
        <option name="STATEMENT_SPACING" value="one_line" />
23 
        <option name="CLAUSE_CHOP_DOWN" value="chop_down_if_statement_long" />
24 
        <option name="ITERATION_ELEMENTS_WRAPPING" value="chop_down_if_not_single" />
25 
      </formatting-settings>
26 
    </DBN-SQL>
27 
  </code_scheme>
28 
</component>
.idea/dbnavigator.xml
1 
<?xml version="1.0" encoding="UTF-8"?>
2 
<project version="4">
3 
  <component name="DBNavigator.Project.DataEditorManager">
4 
    <record-view-column-sorting-type value="BY_INDEX" />
5 
    <value-preview-text-wrapping value="true" />
6 
    <value-preview-pinned value="false" />
7 
  </component>
8 
  <component name="DBNavigator.Project.DataExportManager">
9 
    <export-instructions>
10 
      <create-header value="true" />
11 
      <quote-values-containing-separator value="true" />
12 
      <quote-all-values value="false" />
13 
      <value-separator value="" />
14 
      <file-name value="" />
15 
      <file-location value="" />
16 
      <scope value="GLOBAL" />
17 
      <destination value="FILE" />
18 
      <format value="EXCEL" />
19 
      <charset value="windows-1250" />
20 
    </export-instructions>
21 
  </component>
22 
  <component name="DBNavigator.Project.DatabaseBrowserManager">
23 
    <autoscroll-to-editor value="false" />
24 
    <autoscroll-from-editor value="true" />
25 
    <show-object-properties value="true" />
26 
    <loaded-nodes />
27 
  </component>
28 
  <component name="DBNavigator.Project.DatabaseFileManager">
29 
    <open-files />
30 
  </component>
31 
  <component name="DBNavigator.Project.EditorStateManager">
32 
    <last-used-providers />
33 
  </component>
34 
  <component name="DBNavigator.Project.MethodExecutionManager">
35 
    <method-browser />
36 
    <execution-history>
37 
      <group-entries value="true" />
38 
      <execution-inputs />
39 
    </execution-history>
40 
    <argument-values-cache />
41 
  </component>
42 
  <component name="DBNavigator.Project.ObjectDependencyManager">
43 
    <last-used-dependency-type value="INCOMING" />
44 
  </component>
45 
  <component name="DBNavigator.Project.ObjectQuickFilterManager">
46 
    <last-used-operator value="EQUAL" />
47 
    <filters />
48 
  </component>
49 
  <component name="DBNavigator.Project.ScriptExecutionManager" clear-outputs="true">
50 
    <recently-used-interfaces />
51 
  </component>
52 
  <component name="DBNavigator.Project.Settings">
53 
    <connections />
54 
    <browser-settings>
55 
      <general>
56 
        <display-mode value="TABBED" />
57 
        <navigation-history-size value="100" />
58 
        <show-object-details value="false" />
59 
      </general>
60 
      <filters>
61 
        <object-type-filter>
62 
          <object-type name="SCHEMA" enabled="true" />
63 
          <object-type name="USER" enabled="true" />
64 
          <object-type name="ROLE" enabled="true" />
65 
          <object-type name="PRIVILEGE" enabled="true" />
66 
          <object-type name="CHARSET" enabled="true" />
67 
          <object-type name="TABLE" enabled="true" />
68 
          <object-type name="VIEW" enabled="true" />
69 
          <object-type name="MATERIALIZED_VIEW" enabled="true" />
70 
          <object-type name="NESTED_TABLE" enabled="true" />
71 
          <object-type name="COLUMN" enabled="true" />
72 
          <object-type name="INDEX" enabled="true" />
73 
          <object-type name="CONSTRAINT" enabled="true" />
74 
          <object-type name="DATASET_TRIGGER" enabled="true" />
75 
          <object-type name="DATABASE_TRIGGER" enabled="true" />
76 
          <object-type name="SYNONYM" enabled="true" />
77 
          <object-type name="SEQUENCE" enabled="true" />
78 
          <object-type name="PROCEDURE" enabled="true" />
79 
          <object-type name="FUNCTION" enabled="true" />
80 
          <object-type name="PACKAGE" enabled="true" />
81 
          <object-type name="TYPE" enabled="true" />
82 
          <object-type name="TYPE_ATTRIBUTE" enabled="true" />
83 
          <object-type name="ARGUMENT" enabled="true" />
84 
          <object-type name="DIMENSION" enabled="true" />
85 
          <object-type name="CLUSTER" enabled="true" />
86 
          <object-type name="DBLINK" enabled="true" />
87 
        </object-type-filter>
88 
      </filters>
89 
      <sorting>
90 
        <object-type name="COLUMN" sorting-type="NAME" />
91 
        <object-type name="FUNCTION" sorting-type="NAME" />
92 
        <object-type name="PROCEDURE" sorting-type="NAME" />
93 
        <object-type name="ARGUMENT" sorting-type="POSITION" />
94 
      </sorting>
95 
      <default-editors>
96 
        <object-type name="VIEW" editor-type="SELECTION" />
97 
        <object-type name="PACKAGE" editor-type="SELECTION" />
98 
        <object-type name="TYPE" editor-type="SELECTION" />
99 
      </default-editors>
100 
    </browser-settings>
101 
    <navigation-settings>
102 
      <lookup-filters>
103 
        <lookup-objects>
104 
          <object-type name="SCHEMA" enabled="true" />
105 
          <object-type name="USER" enabled="false" />
106 
          <object-type name="ROLE" enabled="false" />
107 
          <object-type name="PRIVILEGE" enabled="false" />
108 
          <object-type name="CHARSET" enabled="false" />
109 
          <object-type name="TABLE" enabled="true" />
110 
          <object-type name="VIEW" enabled="true" />
111 
          <object-type name="MATERIALIZED VIEW" enabled="true" />
112 
          <object-type name="NESTED TABLE" enabled="false" />
113 
          <object-type name="COLUMN" enabled="false" />
114 
          <object-type name="INDEX" enabled="true" />
115 
          <object-type name="CONSTRAINT" enabled="true" />
116 
          <object-type name="DATASET TRIGGER" enabled="true" />
117 
          <object-type name="DATABASE TRIGGER" enabled="true" />
118 
          <object-type name="SYNONYM" enabled="false" />
119 
          <object-type name="SEQUENCE" enabled="true" />
120 
          <object-type name="PROCEDURE" enabled="true" />
121 
          <object-type name="FUNCTION" enabled="true" />
122 
          <object-type name="PACKAGE" enabled="true" />
123 
          <object-type name="TYPE" enabled="true" />
124 
          <object-type name="TYPE ATTRIBUTE" enabled="false" />
125 
          <object-type name="ARGUMENT" enabled="false" />
126 
          <object-type name="DIMENSION" enabled="false" />
127 
          <object-type name="CLUSTER" enabled="false" />
128 
          <object-type name="DBLINK" enabled="true" />
129 
        </lookup-objects>
130 
        <force-database-load value="false" />
131 
        <prompt-connection-selection value="true" />
132 
        <prompt-schema-selection value="true" />
133 
      </lookup-filters>
134 
    </navigation-settings>
135 
    <dataset-grid-settings>
136 
      <general>
137 
        <enable-zooming value="true" />
138 
        <enable-column-tooltip value="true" />
139 
      </general>
140 
      <sorting>
141 
        <nulls-first value="true" />
142 
        <max-sorting-columns value="4" />
143 
      </sorting>
144 
      <tracking-columns>
145 
        <columnNames value="" />
146 
        <visible value="true" />
147 
        <editable value="false" />
148 
      </tracking-columns>
149 
    </dataset-grid-settings>
150 
    <dataset-editor-settings>
151 
      <text-editor-popup>
152 
        <active value="false" />
153 
        <active-if-empty value="false" />
154 
        <data-length-threshold value="100" />
155 
        <popup-delay value="1000" />
156 
      </text-editor-popup>
157 
      <values-actions-popup>
158 
        <show-popup-button value="true" />
159 
        <element-count-threshold value="1000" />
160 
        <data-length-threshold value="250" />
161 
      </values-actions-popup>
162 
      <general>
163 
        <fetch-block-size value="100" />
164 
        <fetch-timeout value="30" />
165 
        <trim-whitespaces value="true" />
166 
        <convert-empty-strings-to-null value="true" />
167 
        <select-content-on-cell-edit value="true" />
168 
        <large-value-preview-active value="true" />
169 
      </general>
170 
      <filters>
171 
        <prompt-filter-dialog value="true" />
172 
        <default-filter-type value="BASIC" />
173 
      </filters>
174 
      <qualified-text-editor text-length-threshold="300">
175 
        <content-types>
176 
          <content-type name="Text" enabled="true" />
177 
          <content-type name="Properties" enabled="true" />
178 
          <content-type name="XML" enabled="true" />
179 
          <content-type name="DTD" enabled="true" />
180 
          <content-type name="HTML" enabled="true" />
181 
          <content-type name="XHTML" enabled="true" />
182 
          <content-type name="Java" enabled="true" />
183 
          <content-type name="SQL" enabled="true" />
184 
          <content-type name="PL/SQL" enabled="true" />
185 
          <content-type name="Groovy" enabled="true" />
186 
          <content-type name="AIDL" enabled="true" />
187 
          <content-type name="YAML" enabled="true" />
188 
          <content-type name="Manifest" enabled="true" />
189 
        </content-types>
190 
      </qualified-text-editor>
191 
      <record-navigation>
192 
        <navigation-target value="VIEWER" />
193 
      </record-navigation>
194 
    </dataset-editor-settings>
195 
    <code-editor-settings>
196 
      <general>
197 
        <show-object-navigation-gutter value="false" />
198 
        <show-spec-declaration-navigation-gutter value="true" />
199 
        <enable-spellchecking value="true" />
200 
        <enable-reference-spellchecking value="false" />
201 
      </general>
202 
      <confirmations>
203 
        <save-changes value="false" />
204 
        <revert-changes value="true" />
205 
      </confirmations>
206 
    </code-editor-settings>
207 
    <code-completion-settings>
208 
      <filters>
209 
        <basic-filter>
210 
          <filter-element type="RESERVED_WORD" id="keyword" selected="true" />
211 
          <filter-element type="RESERVED_WORD" id="function" selected="true" />
212 
          <filter-element type="RESERVED_WORD" id="parameter" selected="true" />
213 
          <filter-element type="RESERVED_WORD" id="datatype" selected="true" />
214 
          <filter-element type="RESERVED_WORD" id="exception" selected="true" />
215 
          <filter-element type="OBJECT" id="schema" selected="true" />
216 
          <filter-element type="OBJECT" id="role" selected="true" />
217 
          <filter-element type="OBJECT" id="user" selected="true" />
218 
          <filter-element type="OBJECT" id="privilege" selected="true" />
219 
          <user-schema>
220 
            <filter-element type="OBJECT" id="table" selected="true" />
221 
            <filter-element type="OBJECT" id="view" selected="true" />
222 
            <filter-element type="OBJECT" id="materialized view" selected="true" />
223 
            <filter-element type="OBJECT" id="index" selected="true" />
224 
            <filter-element type="OBJECT" id="constraint" selected="true" />
225 
            <filter-element type="OBJECT" id="trigger" selected="true" />
226 
            <filter-element type="OBJECT" id="synonym" selected="false" />
227 
            <filter-element type="OBJECT" id="sequence" selected="true" />
228 
            <filter-element type="OBJECT" id="procedure" selected="true" />
229 
            <filter-element type="OBJECT" id="function" selected="true" />
230 
            <filter-element type="OBJECT" id="package" selected="true" />
231 
            <filter-element type="OBJECT" id="type" selected="true" />
232 
            <filter-element type="OBJECT" id="dimension" selected="true" />
233 
            <filter-element type="OBJECT" id="cluster" selected="true" />
234 
            <filter-element type="OBJECT" id="dblink" selected="true" />
235 
          </user-schema>
236 
          <public-schema>
237 
            <filter-element type="OBJECT" id="table" selected="false" />
238 
            <filter-element type="OBJECT" id="view" selected="false" />
239 
            <filter-element type="OBJECT" id="materialized view" selected="false" />
240 
            <filter-element type="OBJECT" id="index" selected="false" />
241 
            <filter-element type="OBJECT" id="constraint" selected="false" />
242 
            <filter-element type="OBJECT" id="trigger" selected="false" />
243 
            <filter-element type="OBJECT" id="synonym" selected="false" />
244 
            <filter-element type="OBJECT" id="sequence" selected="false" />
245 
            <filter-element type="OBJECT" id="procedure" selected="false" />
246 
            <filter-element type="OBJECT" id="function" selected="false" />
247 
            <filter-element type="OBJECT" id="package" selected="false" />
248 
            <filter-element type="OBJECT" id="type" selected="false" />
249 
            <filter-element type="OBJECT" id="dimension" selected="false" />
250 
            <filter-element type="OBJECT" id="cluster" selected="false" />
251 
            <filter-element type="OBJECT" id="dblink" selected="false" />
252 
          </public-schema>
253 
          <any-schema>
254 
            <filter-element type="OBJECT" id="table" selected="true" />
255 
            <filter-element type="OBJECT" id="view" selected="true" />
256 
            <filter-element type="OBJECT" id="materialized view" selected="true" />
257 
            <filter-element type="OBJECT" id="index" selected="true" />
258 
            <filter-element type="OBJECT" id="constraint" selected="true" />
259 
            <filter-element type="OBJECT" id="trigger" selected="true" />
260 
            <filter-element type="OBJECT" id="synonym" selected="true" />
261 
            <filter-element type="OBJECT" id="sequence" selected="true" />
262 
            <filter-element type="OBJECT" id="procedure" selected="true" />
263 
            <filter-element type="OBJECT" id="function" selected="true" />
264 
            <filter-element type="OBJECT" id="package" selected="true" />
265 
            <filter-element type="OBJECT" id="type" selected="true" />
266 
            <filter-element type="OBJECT" id="dimension" selected="true" />
267 
            <filter-element type="OBJECT" id="cluster" selected="true" />
268 
            <filter-element type="OBJECT" id="dblink" selected="true" />
269 
          </any-schema>
270 
        </basic-filter>
271 
        <extended-filter>
272 
          <filter-element type="RESERVED_WORD" id="keyword" selected="true" />
273 
          <filter-element type="RESERVED_WORD" id="function" selected="true" />
274 
          <filter-element type="RESERVED_WORD" id="parameter" selected="true" />
275 
          <filter-element type="RESERVED_WORD" id="datatype" selected="true" />
276 
          <filter-element type="RESERVED_WORD" id="exception" selected="true" />
277 
          <filter-element type="OBJECT" id="schema" selected="true" />
278 
          <filter-element type="OBJECT" id="user" selected="true" />
279 
          <filter-element type="OBJECT" id="role" selected="true" />
280 
          <filter-element type="OBJECT" id="privilege" selected="true" />
281 
          <user-schema>
282 
            <filter-element type="OBJECT" id="table" selected="true" />
283 
            <filter-element type="OBJECT" id="view" selected="true" />
284 
            <filter-element type="OBJECT" id="materialized view" selected="true" />
285 
            <filter-element type="OBJECT" id="index" selected="true" />
286 
            <filter-element type="OBJECT" id="constraint" selected="true" />
287 
            <filter-element type="OBJECT" id="trigger" selected="true" />
288 
            <filter-element type="OBJECT" id="synonym" selected="true" />
289 
            <filter-element type="OBJECT" id="sequence" selected="true" />
290 
            <filter-element type="OBJECT" id="procedure" selected="true" />
291 
            <filter-element type="OBJECT" id="function" selected="true" />
292 
            <filter-element type="OBJECT" id="package" selected="true" />
293 
            <filter-element type="OBJECT" id="type" selected="true" />
294 
            <filter-element type="OBJECT" id="dimension" selected="true" />
295 
            <filter-element type="OBJECT" id="cluster" selected="true" />
296 
            <filter-element type="OBJECT" id="dblink" selected="true" />
297 
          </user-schema>
298 
          <public-schema>
299 
            <filter-element type="OBJECT" id="table" selected="true" />
300 
            <filter-element type="OBJECT" id="view" selected="true" />
301 
            <filter-element type="OBJECT" id="materialized view" selected="true" />
302 
            <filter-element type="OBJECT" id="index" selected="true" />
303 
            <filter-element type="OBJECT" id="constraint" selected="true" />
304 
            <filter-element type="OBJECT" id="trigger" selected="true" />
305 
            <filter-element type="OBJECT" id="synonym" selected="true" />
306 
            <filter-element type="OBJECT" id="sequence" selected="true" />
307 
            <filter-element type="OBJECT" id="procedure" selected="true" />
308 
            <filter-element type="OBJECT" id="function" selected="true" />
309 
            <filter-element type="OBJECT" id="package" selected="true" />
310 
            <filter-element type="OBJECT" id="type" selected="true" />
311 
            <filter-element type="OBJECT" id="dimension" selected="true" />
312 
            <filter-element type="OBJECT" id="cluster" selected="true" />
313 
            <filter-element type="OBJECT" id="dblink" selected="true" />
314 
          </public-schema>
315 
          <any-schema>
316 
            <filter-element type="OBJECT" id="table" selected="true" />
317 
            <filter-element type="OBJECT" id="view" selected="true" />
318 
            <filter-element type="OBJECT" id="materialized view" selected="true" />
319 
            <filter-element type="OBJECT" id="index" selected="true" />
320 
            <filter-element type="OBJECT" id="constraint" selected="true" />
321 
            <filter-element type="OBJECT" id="trigger" selected="true" />
322 
            <filter-element type="OBJECT" id="synonym" selected="true" />
323 
            <filter-element type="OBJECT" id="sequence" selected="true" />
324 
            <filter-element type="OBJECT" id="procedure" selected="true" />
325 
            <filter-element type="OBJECT" id="function" selected="true" />
326 
            <filter-element type="OBJECT" id="package" selected="true" />
327 
            <filter-element type="OBJECT" id="type" selected="true" />
328 
            <filter-element type="OBJECT" id="dimension" selected="true" />
329 
            <filter-element type="OBJECT" id="cluster" selected="true" />
330 
            <filter-element type="OBJECT" id="dblink" selected="true" />
331 
          </any-schema>
332 
        </extended-filter>
333 
      </filters>
334 
      <sorting enabled="true">
335 
        <sorting-element type="RESERVED_WORD" id="keyword" />
336 
        <sorting-element type="RESERVED_WORD" id="datatype" />
337 
        <sorting-element type="OBJECT" id="column" />
338 
        <sorting-element type="OBJECT" id="table" />
339 
        <sorting-element type="OBJECT" id="view" />
340 
        <sorting-element type="OBJECT" id="materialized view" />
341 
        <sorting-element type="OBJECT" id="index" />
342 
        <sorting-element type="OBJECT" id="constraint" />
343 
        <sorting-element type="OBJECT" id="trigger" />
344 
        <sorting-element type="OBJECT" id="synonym" />
345 
        <sorting-element type="OBJECT" id="sequence" />
346 
        <sorting-element type="OBJECT" id="procedure" />
347 
        <sorting-element type="OBJECT" id="function" />
348 
        <sorting-element type="OBJECT" id="package" />
349 
        <sorting-element type="OBJECT" id="type" />
350 
        <sorting-element type="OBJECT" id="dimension" />
351 
        <sorting-element type="OBJECT" id="cluster" />
352 
        <sorting-element type="OBJECT" id="dblink" />
353 
        <sorting-element type="OBJECT" id="schema" />
354 
        <sorting-element type="OBJECT" id="role" />
355 
        <sorting-element type="OBJECT" id="user" />
356 
        <sorting-element type="RESERVED_WORD" id="function" />
357 
        <sorting-element type="RESERVED_WORD" id="parameter" />
358 
      </sorting>
359 
      <format>
360 
        <enforce-code-style-case value="true" />
361 
      </format>
362 
    </code-completion-settings>
363 
    <execution-engine-settings>
364 
      <statement-execution>
365 
        <fetch-block-size value="100" />
366 
        <execution-timeout value="20" />
367 
        <debug-execution-timeout value="600" />
368 
        <focus-result value="false" />
369 
        <prompt-execution value="false" />
370 
      </statement-execution>
371 
      <script-execution>
372 
        <command-line-interfaces />
373 
        <execution-timeout value="300" />
374 
      </script-execution>
375 
      <method-execution>
376 
        <execution-timeout value="30" />
377 
        <debug-execution-timeout value="600" />
378 
        <parameter-history-size value="10" />
379 
      </method-execution>
380 
    </execution-engine-settings>
381 
    <operation-settings>
382 
      <transactions>
383 
        <uncommitted-changes>
384 
          <on-project-close value="ASK" />
385 
          <on-disconnect value="ASK" />
386 
          <on-autocommit-toggle value="ASK" />
387 
        </uncommitted-changes>
388 
        <multiple-uncommitted-changes>
389 
          <on-commit value="ASK" />
390 
          <on-rollback value="ASK" />
391 
        </multiple-uncommitted-changes>
392 
      </transactions>
393 
      <session-browser>
394 
        <disconnect-session value="ASK" />
395 
        <kill-session value="ASK" />
396 
        <reload-on-filter-change value="false" />
397 
      </session-browser>
398 
      <compiler>
399 
        <compile-type value="KEEP" />
400 
        <compile-dependencies value="ASK" />
401 
        <always-show-controls value="false" />
402 
      </compiler>
403 
      <debugger>
404 
        <debugger-type value="ASK" />
405 
        <use-generic-runners value="true" />
406 
      </debugger>
407 
    </operation-settings>
408 
    <ddl-file-settings>
409 
      <extensions>
410 
        <mapping file-type-id="VIEW" extensions="vw" />
411 
        <mapping file-type-id="TRIGGER" extensions="trg" />
412 
        <mapping file-type-id="PROCEDURE" extensions="prc" />
413 
        <mapping file-type-id="FUNCTION" extensions="fnc" />
414 
        <mapping file-type-id="PACKAGE" extensions="pkg" />
415 
        <mapping file-type-id="PACKAGE_SPEC" extensions="pks" />
416 
        <mapping file-type-id="PACKAGE_BODY" extensions="pkb" />
417 
        <mapping file-type-id="TYPE" extensions="tpe" />
418 
        <mapping file-type-id="TYPE_SPEC" extensions="tps" />
419 
        <mapping file-type-id="TYPE_BODY" extensions="tpb" />
420 
      </extensions>
421 
      <general>
422 
        <lookup-ddl-files value="true" />
423 
        <create-ddl-files value="false" />
424 
        <synchronize-ddl-files value="true" />
425 
        <use-qualified-names value="false" />
426 
        <make-scripts-rerunnable value="true" />
427 
      </general>
428 
    </ddl-file-settings>
429 
    <general-settings>
430 
      <regional-settings>
431 
        <date-format value="MEDIUM" />
432 
        <number-format value="UNGROUPED" />
433 
        <locale value="SYSTEM_DEFAULT" />
434 
        <use-custom-formats value="false" />
435 
      </regional-settings>
436 
      <environment>
437 
        <environment-types>
438 
          <environment-type id="development" name="Development" description="Development environment" color="-2430209/-12296320" readonly-code="false" readonly-data="false" />
439 
          <environment-type id="integration" name="Integration" description="Integration environment" color="-2621494/-12163514" readonly-code="true" readonly-data="false" />
440 
          <environment-type id="production" name="Production" description="Productive environment" color="-11574/-10271420" readonly-code="true" readonly-data="true" />
441 
          <environment-type id="other" name="Other" description="" color="-1576/-10724543" readonly-code="false" readonly-data="false" />
442 
        </environment-types>
443 
        <visibility-settings>
444 
          <connection-tabs value="true" />
445 
          <dialog-headers value="true" />
446 
          <object-editor-tabs value="true" />
447 
          <script-editor-tabs value="false" />
448 
          <execution-result-tabs value="true" />
449 
        </visibility-settings>
450 
      </environment>
451 
    </general-settings>
452 
  </component>
453 
  <component name="DBNavigator.Project.StatementExecutionManager">
454 
    <execution-variables />
455 
  </component>
456 
</project>
server/src/main/java/cz/zcu/yamanager/repository/UserRepository.java
11 11 
import org.springframework.jdbc.core.simple.SimpleJdbcCall;
12 12 
import org.springframework.stereotype.Repository;
13 13 

  		




  14
  
  
    
import java.sql.CallableStatement;


  		




  15
  
  
    
import java.sql.ResultSet;


  		




  16
  
  
    
import java.sql.Timestamp;


  		




  17
  
  
    
import java.sql.Types;


  		




  
  14
  
    
import java.sql.*;


  		




  18
  15
  
    
import java.util.ArrayList;


  		




  19
  16
  
    
import java.util.List;


  		




  20
  17
  
    
import java.util.Map;


  		




  ......




  61
  58
  
    
        paramList.add(new SqlOutParameter("out_no_vacations", Types.FLOAT));


  		




  62
  59
  
    
        paramList.add(new SqlOutParameter("out_no_sick_days", Types.INTEGER));


  		




  63
  60
  
    
        paramList.add(new SqlOutParameter("out_taken_sick_days", Types.INTEGER));


  		




  64
  
  
    
        paramList.add(new SqlOutParameter("out_alert", Types.DATE));


  		




  
  61
  
    
        paramList.add(new SqlOutParameter("out_alert", Types.TIMESTAMP));


  		




  65
  62
  
    
        paramList.add(new SqlOutParameter("out_email", Types.VARCHAR));


  		




  66
  63
  
    
        paramList.add(new SqlOutParameter("out_photo", Types.LONGVARCHAR));


  		




  67
  
  
    
        paramList.add(new SqlOutParameter("out_creation_date", Types.DATE));


  		




  
  64
  
    
        paramList.add(new SqlOutParameter("out_creation_date", Types.TIMESTAMP));


  		




  68
  65
  
    
        paramList.add(new SqlOutParameter("out_role", Types.VARCHAR));


  		




  69
  66
  
    
        paramList.add(new SqlOutParameter("out_status", Types.VARCHAR));


  		




  70
  67
  
    

  		




  ......




  77
  74
  
    
            callableStatement.registerOutParameter(5, Types.FLOAT);


  		




  78
  75
  
    
            callableStatement.registerOutParameter(6, Types.INTEGER);


  		




  79
  76
  
    
            callableStatement.registerOutParameter(7, Types.INTEGER);


  		




  80
  
  
    
            callableStatement.registerOutParameter(8, Types.DATE);


  		




  
  77
  
    
            callableStatement.registerOutParameter(8, Types.TIMESTAMP);


  		




  81
  78
  
    
            callableStatement.registerOutParameter(9, Types.VARCHAR);


  		




  82
  79
  
    
            callableStatement.registerOutParameter(10, Types.LONGNVARCHAR);


  		




  83
  
  
    
            callableStatement.registerOutParameter(11, Types.DATE);


  		




  
  80
  
    
            callableStatement.registerOutParameter(11, Types.TIMESTAMP);


  		




  84
  81
  
    
            callableStatement.registerOutParameter(12, Types.VARCHAR);


  		




  85
  82
  
    
            callableStatement.registerOutParameter(13, Types.VARCHAR);


  		




  86
  83
  
    
            return callableStatement;


  		




  87
  84
  
    
        }, paramList);


  		




  88
  85
  
    

  		




  89
  86
  
    
        FullUserProfile user = new FullUserProfile();


  		




  90
  
  
    
        user.setId((long)resultMap.get("out_id"));


  		




  
  87
  
    
        user.setId((Long)resultMap.get("out_id"));


  		




  91
  88
  
    
        user.setFirstName((String)resultMap.get("out_first_name"));


  		




  92
  89
  
    
        user.setLastName((String)resultMap.get("out_last_name"));


  		




  93
  
  
    
        user.setVacationCount((float)resultMap.get("out_no_vacations"));


  		




  94
  
  
    
        user.setSickdayCount((int)resultMap.get("out_no_sick_days"));


  		




  95
  
  
    
        user.setTakenSickdayCount((int)resultMap.get("out_taken_sick_days"));


  		




  
  90
  
    
        user.setVacationCount(((Double)resultMap.get("out_no_vacations")).floatValue());


  		




  
  91
  
    
        user.setSickdayCount((Integer)resultMap.get("out_no_sick_days"));


  		




  
  92
  
    
        user.setTakenSickdayCount((Integer)resultMap.get("out_taken_sick_days"));


  		




  96
  93
  
    
        user.setNotification(((Timestamp)resultMap.get("out_alert")).toLocalDateTime());


  		




  97
  94
  
    
        user.setEmail((String)resultMap.get(("out_email")));


  		




  98
  95
  
    
        user.setPhoto((String)resultMap.get("out_photo"));


  		




  ......




  111
  108
  
    
        paramList.add(new SqlOutParameter("out_no_vacations", Types.FLOAT));


  		




  112
  109
  
    
        paramList.add(new SqlOutParameter("out_no_sick_days", Types.INTEGER));


  		




  113
  110
  
    
        paramList.add(new SqlOutParameter("out_taken_sick_days", Types.INTEGER));


  		




  114
  
  
    
        paramList.add(new SqlOutParameter("out_alert", Types.DATE));


  		




  
  111
  
    
        paramList.add(new SqlOutParameter("out_alert", Types.TIMESTAMP));


  		




  115
  112
  
    
        paramList.add(new SqlOutParameter("out_email", Types.VARCHAR));


  		




  116
  113
  
    
        paramList.add(new SqlOutParameter("out_photo", Types.LONGVARCHAR));


  		




  117
  
  
    
        paramList.add(new SqlOutParameter("out_creation_date", Types.DATE));


  		




  
  114
  
    
        paramList.add(new SqlOutParameter("out_creation_date", Types.TIMESTAMP));


  		




  118
  115
  
    
        paramList.add(new SqlOutParameter("out_role", Types.VARCHAR));


  		




  119
  116
  
    
        paramList.add(new SqlOutParameter("out_status", Types.VARCHAR));


  		




  120
  117
  
    

  		




  ......




  127
  124
  
    
            callableStatement.registerOutParameter(5, Types.FLOAT);


  		




  128
  125
  
    
            callableStatement.registerOutParameter(6, Types.INTEGER);


  		




  129
  126
  
    
            callableStatement.registerOutParameter(7, Types.INTEGER);


  		




  130
  
  
    
            callableStatement.registerOutParameter(8, Types.DATE);


  		




  
  127
  
    
            callableStatement.registerOutParameter(8, Types.TIMESTAMP);


  		




  131
  128
  
    
            callableStatement.registerOutParameter(9, Types.VARCHAR);


  		




  132
  129
  
    
            callableStatement.registerOutParameter(10, Types.LONGNVARCHAR);


  		




  133
  
  
    
            callableStatement.registerOutParameter(11, Types.DATE);


  		




  
  130
  
    
            callableStatement.registerOutParameter(11, Types.TIMESTAMP);


  		




  134
  131
  
    
            callableStatement.registerOutParameter(12, Types.VARCHAR);


  		




  135
  132
  
    
            callableStatement.registerOutParameter(13, Types.VARCHAR);


  		




  136
  133
  
    
            return callableStatement;


  		




  137
  134
  
    
        }, paramList);


  		




  138
  135
  
    

  		




  139
  136
  
    
        FullUserProfile user = new FullUserProfile();


  		




  140
  
  
    
        user.setId((long)resultMap.get("out_id"));


  		




  
  137
  
    
        user.setId((Long)resultMap.get("out_id"));


  		




  141
  138
  
    
        user.setFirstName((String)resultMap.get("out_first_name"));


  		




  142
  139
  
    
        user.setLastName((String)resultMap.get("out_last_name"));


  		




  143
  
  
    
        user.setVacationCount((float)resultMap.get("out_no_vacations"));


  		




  144
  
  
    
        user.setSickdayCount((int)resultMap.get("out_no_sick_days"));


  		




  145
  
  
    
        user.setTakenSickdayCount((int)resultMap.get("out_taken_sick_days"));


  		




  
  140
  
    
        user.setVacationCount(((Double)resultMap.get("out_no_vacations")).floatValue());


  		




  
  141
  
    
        user.setSickdayCount((Integer)resultMap.get("out_no_sick_days"));


  		




  
  142
  
    
        user.setTakenSickdayCount((Integer)resultMap.get("out_taken_sick_days"));


  		




  146
  143
  
    
        user.setNotification(((Timestamp)resultMap.get("out_alert")).toLocalDateTime());


  		




  147
  144
  
    
        user.setEmail((String)resultMap.get(("out_email")));


  		




  148
  145
  
    
        user.setPhoto((String)resultMap.get("out_photo"));


  		












Také k dispozici:  Unified diff