github.com/1aal/kubeblocks@v0.0.0-20231107070852-e1c03e598921/deploy/tdengine/scripts/tdengine-reload.tpl (about)

     1  {{- /* mysql global variable update */}}
     2  {{- /* mysql using system variables reference docs: https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html */}}
     3  {{- /*  1. system variable names must be written using underscores, not dashes. */}}
     4  {{- /*  2. string variable 'xxx' */}}
     5  {{- /*  3. type convert to number */}}
     6  {{- range $pk, $pv := $.arg0 }}
     7  	{{- $pk = replace "-" "_" $pk }}
     8  	{{- $var_int := -1 }}
     9      {{- if $pv | regexMatch "^\\d+$" }}
    10  		{{- $var_int = atoi $pv }}
    11  	{{- end}}
    12  	{{- if lt $var_int 0 }}
    13  		{{- $tmp := $pv | regexStringSubmatch "^(\\d+)K$" }}
    14  		{{- if $tmp }}
    15  		{{- $var_int = last $tmp | atoi | mul 1024 }}
    16  		{{- end }}
    17  	{{- end }}
    18  	{{- if lt $var_int 0 }}
    19  		{{- $tmp := $pv | regexStringSubmatch "^(\\d+)M$" }}
    20  		{{- if $tmp }}
    21  		{{- $var_int =  last $tmp | atoi | mul 1024 1024 }}
    22  		{{- end }}
    23  	{{- end }}
    24  	{{- if lt $var_int 0 }}
    25  		{{- $tmp := $pv | regexStringSubmatch "^(\\d+)G$" }}
    26  		{{- if $tmp }}
    27  		{{- $var_int = last $tmp | atoi | mul 1024 1024 1024 }}
    28  		{{- end }}
    29  	{{- end }}
    30  	{{- if ge $var_int 0 }}
    31  		{{- execSql ( printf "SET GLOBAL %s = %d" $pk $var_int ) }}
    32  	{{- else }}
    33  		{{- execSql ( printf "SET GLOBAL %s = '%s'" $pk $pv ) }}
    34  	{{- end }}
    35  {{- end }}