Defined Type: dbutils::statement

Defined in:
modules/dbutils/manifests/statement.pp

Overview

SPDX-License-Identifier: Apache-2.0

Parameters:

  • statement (String[1])
  • unless (String[1])
  • unless_grep_match (Optional[String[1]]) (defaults to: undef) 


2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'modules/dbutils/manifests/statement.pp', line 2

define dbutils::statement (
    String[1]           $statement,
    String[1]           $unless,
    Optional[String[1]] $unless_grep_match = undef,
) {
    $exec_user = 'root'
    $exec_bin = '/usr/bin/mysql'
    $exec_args = "--user=${exec_user} --batch --silent -e"
    $exec_timeout = '30'

    if $unless_grep_match {
        $match = $unless_grep_match
    } else {
        $match = $statement
    }

    exec { "db-statement-${title}":
        command => "${exec_bin} ${exec_args} \"${statement};\"",
        unless  => "${exec_bin} ${exec_args} \"${unless};\" | grep -q \"${match}\"",
        user    => $exec_user,
        timeout => $exec_timeout,
    }
}