Zabbix

#!/bin/bash

​

# A script to generate SQL from PNG images

# depends on hexdump and base64

​

scriptdir="$(dirname $0)"

pngdir="${1:-png_modern}"

sqlbasedir="$scriptdir/../../database"

imagefile="images.sql"

​

imagefile_mysql="$sqlbasedir/mysql/$imagefile"

imagefile_pgsql="$sqlbasedir/postgresql/$imagefile"

imagefile_oracle="$sqlbasedir/oracle/$imagefile"

​

oracle_string_max=2048

oracle_line_max=15

oracle_base64tmp=tmp_b64

​

for imagefile in "$imagefile_mysql" "$imagefile_pgsql" "$imagefile_oracle"; do

    [[ -s "$imagefile" ]] && {

        echo "Non-empty $imagefile already exists, stopping"

        exit 1

    }

done

​

echo "Generating SQL files"

​

cat images_oracle_start.txt > "$imagefile_oracle"

​

imagecount=$(ls $pngdir/*.png | wc -l)

​

# TODO: this loop won't work with directory names, containing spaces

# using 'find' here seems to be a bit excessive for now

for imagefile in $pngdir/*.png; do

    ((imagesdone++))

    imagename="$(basename "${imagefile%.png}")"

    image_data=$(hexdump -ve '"" 1/1 "%02X"' "$imagefile")

​

    # ----- MySQL

    echo "INSERT INTO \`images\` (\`imageid\`,\`imagetype\`,\`name\`,\`image\`) VALUES ($imagesdone,1,'$imagename',0x$image_data);" >> "$imagefile_mysql"

    # ----- PostgreSQL

    echo "INSERT INTO images (imageid,imagetype,name,image) VALUES ($imagesdone,1,'$imagename',decode('$image_data','hex'));" >> "$imagefile_pgsql"

    # ----- Oracle

    base64 -w$oracle_string_max "$imagefile" > $oracle_base64tmp

    split -l$oracle_line_max $oracle_base64tmp $oracle_base64tmp

    rm -f $oracle_base64tmp

    echo -e "\tl_clob := EMPTY_CLOB();" >> "$imagefile_oracle"

    for oracle_imagefile in $oracle_base64tmp*; do

        echo -e "\tl_clob := l_clob || '$(<$oracle_imagefile)';" >> "$imagefile_oracle"

        rm -f $oracle_imagefile

    done

    echo -e "\tINSERT INTO images VALUES ($imagesdone,1,'$imagename',base64_decode(l_clob));"  >> "$imagefile_oracle"

​

    echo -ne "\b\b\b\b$[$imagesdone*100/$imagecount]% "

done

cat images_oracle_end.txt >> "$imagefile_oracle"

echo