File: rpl_change_topology_merge_variables.inc

package info (click to toggle)
mysql-8.0 8.0.43-3
  • links: PTS, VCS
  • area: main
  • in suites: sid
  • size: 1,273,924 kB
  • sloc: cpp: 4,684,605; ansic: 412,450; pascal: 108,398; java: 83,641; perl: 30,221; cs: 27,067; sql: 26,594; sh: 24,181; python: 21,816; yacc: 17,169; php: 11,522; xml: 7,388; javascript: 7,076; makefile: 2,194; lex: 1,075; awk: 670; asm: 520; objc: 183; ruby: 97; lisp: 86
file content (89 lines) | stat: -rw-r--r-- 3,403 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
# ==== Purpose ====
#
# The purpose of this utility script is to override the values of a
# topology include typical parameter of the form `1:2, 3:a, 4:off, *:on,
# ...` with the values of another topology script parameter, when the
# values for the latter match a specific value.
#
# ==== Usage ====
#
# --let $rpl_topology_override_variable =
# --let $rpl_topology_with_variable =
# --let $rpl_topology_when_override_value =
# --let $rpl_server_count =
# --source include/save_sysvars.inc
#
# Parameters:
#
#  $rpl_topology_override_variable
#    The variable to be overriden, on the form `1:2, 3:a, 4:off, *:on, ...`
#
#  $rpl_topology_with_variable
#    The variable to get the override values from, on the form `1:2, 3:a,
#    4:off, *:on, ...`
#
#  $rpl_topology_when_override_value
#    The value to look for in `$rpl_topology_with_variable` to trigger an
#    override in `$rpl_topology_override_variable`
#
#  $rpl_server_count
#    Number of servers in the topology
#
# Output:
#
#  $rpl_topology_overriden_result
#    The result from overriden the `$rpl_topology_override_variable` with
#    the values in `$rpl_topology_with_variable` that match
#    `$rpl_topology_override_value`
#
#

if ($rpl_topology_with_variable == '') {
  --die ERROR IN TEST: The $rpl_topology_with_variable parameter must be set
}

if ($rpl_topology_when_override_value == '') {
  --die ERROR IN TEST: The $rpl_topology_when_override_value parameter must be set
}

if ($rpl_server_count == '') {
  --die ERROR IN TEST: The $rpl_server_count parameter must be set
}

--let $_overriden_variable =

--let $_override_index = `SELECT LOCATE('*:$rpl_topology_when_override_value', '$rpl_topology_with_variable')`
--let $_overriden_index = `SELECT LOCATE('*:', '$rpl_topology_override_variable')`
if ($_override_index) {
  --let $_override_value = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING('$rpl_topology_with_variable', $_override_index), ',', 1), ':', -1)`
  --let $_overriden_variable = *:$_override_value
}
if (`SELECT NOT($_override_index) AND $_overriden_index`) {
  --let $_override_value = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING('$rpl_topology_override_variable', $_overriden_index), ',', 1), ':', -1)`
  --let $_overriden_variable = *:$_override_value
}

--let $_conn_count = $rpl_server_count
while($_conn_count != 0) {
  --let $_override_index = `SELECT LOCATE('$_conn_count:$rpl_topology_when_override_value', '$rpl_topology_with_variable')`
  --let $_overriden_index = `SELECT LOCATE('$_conn_count:', '$rpl_topology_override_variable')`

  if ($_override_index) {
    if ($_overriden_variable != '') {
      --let $_overriden_variable = $_overriden_variable,
    }
    --let $_override_value = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING('$rpl_topology_with_variable', $_override_index), ',', 1), ':', -1)`
    --let $_overriden_variable = $_overriden_variable $_conn_count:$_override_value
  }
  if (`SELECT NOT($_override_index) AND $_overriden_index`) {
    if ($_overriden_variable != '') {
      --let $_overriden_variable = $_overriden_variable,
    }
    --let $_override_value = `SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING('$rpl_topology_override_variable', $_overriden_index), ',', 1), ':', -1)`
    --let $_overriden_variable = $_overriden_variable $_conn_count:$_override_value
  }

  --dec $_conn_count
}

--let $rpl_topology_overriden_result = $_overriden_variable