Zabbix

#!/bin/bash

​

if [ -z "$1" ] || [ -z "$2" ] || [ -z "$3" ] || [ -z "$4" ] || [ -z "$5" ] || [ -z "$6" ]; then

    echo "Usage:

    ./export_data.sh -hhost -Pport -uroot -p<password> <DB name> ZBX_DATA > ../src/data.tmpl

    ./export_data.sh -hhost -Pport -uroot -p<password> <DB name> ZBX_TEMPLATE > ../src/templates.tmpl

    ./export_data.sh -hhost -Pport -uroot -p<password> <DB name> ZBX_DASHBOARD > ../src/dashboards.tmpl

    The script generates data file out of existing MySQL database." && exit 1

fi

mysql_cmd="mysql $1 $2 $3 $4 $5"

dbflag=$6

basedir=`dirname "$0"`

schema=$basedir/../src/schema.tmpl

​

echo "--

-- Zabbix

-- Copyright (C) 2001-2022 Zabbix SIA

--

-- This program is free software; you can redistribute it and/or modify

-- it under the terms of the GNU General Public License as published by

-- the Free Software Foundation; either version 2 of the License, or

-- (at your option) any later version.

--

-- This program is distributed in the hope that it will be useful,

-- but WITHOUT ANY WARRANTY; without even the implied warranty of

-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

-- GNU General Public License for more details.

--

-- You should have received a copy of the GNU General Public License

-- along with this program; if not, write to the Free Software

-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.

--

"

​

IFS=$'\n'

for tbl_line in `grep "^TABLE.*${dbflag}" "${schema}"`; do

    tbl_line=${tbl_line#*|}

    table=${tbl_line%%|*}

    tbl_line=${tbl_line#*|}

    primary_key=${tbl_line%%|*}

​

    total_count=`echo "select count(*) from ${table}" | eval ${mysql_cmd} | tail -1`

​

    fields=''

    delim=''

​

    refs=()

    depth=()

​

    for fld_line in `sed -n "/^TABLE|${table}|/,/^$/ p" "${schema}" | grep "^FIELD" | sed 's/[ \t]//g'`; do

        fld_line=${fld_line#*|}     # FIELD

        field=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <field_name>

        field_type=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <field_type>

        default_val=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <default>

        fld_line=${fld_line#*|}     # <not_null>

        flags=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <flags>

        fld_line=${fld_line#*|}     # <index #>

        ref_table=${fld_line%%|*}

        fld_line=${fld_line#*|}     # <ref_table>