Mercurial > hgrepos > Python > libs > ConfigMix
annotate tests/data/extract-new-config.yml @ 769:4a4d1323b282 default tip
Doc what AWS partition is
| author | Franz Glasner <f.glasner@feldmann-mg.com> |
|---|---|
| date | Mon, 19 Feb 2024 16:11:48 +0100 |
| parents | 1514e7d2f691 |
| children |
| rev | line source |
|---|---|
|
760
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
1 # -*- coding: utf-8; mode: yaml; indent-tabs-mode: nil; -*- |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
2 # |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
3 %YAML 1.1 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
4 --- |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
5 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
6 globals: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
7 var1: value1 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
8 var2: value2 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
9 datadir1: &datadir 'E:\home\fag\p\work5\pgdbmgr\_data' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
10 PGBINDIR: 'E:\APPS64\PostgreSQL-9.4\all\bin' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
11 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
12 PATH: '{{PGBINDIR}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
13 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
14 user1: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
15 name: &rootname 'My Username' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
16 pwd: &rootpwd 'My Password' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
17 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
18 user2: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
19 name: 'myquizowner' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
20 pwd: 'abcQQQ123456' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
21 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
22 database: myquiz |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
23 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
24 dbhost: localhost |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
25 dbport: 5432 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
26 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
27 engine0: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
28 url: 'postgresql+psycopg2://{{user1.name|urlquote}}:{{user1.pwd|urlquote}}@{{dbhost}}:{{dbport}}/postgres' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
29 echo: false |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
30 echo_pool: false |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
31 encoding: utf-8 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
32 isolation_level: 'SERIALIZABLE' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
33 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
34 engine1: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
35 url: 'postgresql+psycopg2://{{user2.name|urlquote}}:{{user2.pwd|urlquote}}@{{dbhost}}:{{dbport}}/{{database}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
36 echo: false |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
37 echo_pool: false |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
38 encoding: utf-8 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
39 isolation_level: 'SERIALIZABLE' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
40 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
41 section: This is the Root Section |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
42 parts: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
43 - section: This is Section 1 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
44 parts: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
45 - section: This is Section 2, a subsection of Section 1 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
46 op: initcluster |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
47 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
48 superuser: '{{user1.name}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
49 superpassword: '{{user1.pwd}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
50 # or here also: rootuser: *rootname |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
51 locale: C |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
52 encoding: UTF8 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
53 datadir: *datadir |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
54 # or here also: datadir: '{{datadir1}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
55 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
56 - section: Create a User (DB Owner) |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
57 op: createuser |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
58 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
59 name: '{{user2.name}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
60 password: '{{user2.pwd}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
61 login: true |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
62 options: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
63 connstr: engine0 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
64 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
65 - section: Install |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
66 op: createdb |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
67 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
68 name: '{{database}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
69 owner: '{{user2.name}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
70 connection_limit: 30 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
71 options: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
72 connstr: engine0 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
73 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
74 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
75 - section: This is another section |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
76 depends: This is Section 1 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
77 # OR - if more than one dependency |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
78 # depends: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
79 # - This is Section 1 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
80 # - Maybe another Section on which this section depends |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
81 op: the_new_operation |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
82 with: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
83 vars: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
84 a: '{{var1}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
85 b: 'file://{{user1.name|urlquote}}:{{user1.pwd | urlquote}}@localhost/' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
86 # cwd: 'E:\what{{a}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
87 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
88 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
89 pool: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
90 - section: Start Cluster |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
91 op: startcluster |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
92 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
93 datadir: '{{datadir1}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
94 logfile: '{{datadir1}}/_log.log' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
95 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
96 - section: Stop Cluster |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
97 op: stopcluster |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
98 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
99 datadir: '{{datadir1}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
100 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
101 - section: Configure |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
102 op: amendconfig |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
103 args: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
104 - "log_connections = on" |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
105 - "log_disconnections = on" |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
106 - "log_line_prefix = '%m %u@%d %p %r '" |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
107 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
108 datadir: '{{datadir1}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
109 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
110 - section: Exit |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
111 op: exit |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
112 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
113 exitcode: 0 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
114 |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
115 - section: Uninstall |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
116 op: deletedb |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
117 params: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
118 name: '{{database}}' |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
119 options: |
|
1514e7d2f691
FIX: add forgotten test configuration data file
Franz Glasner <fzglas.hg@dom66.de>
parents:
diff
changeset
|
120 connstr: engine0 |
