#!/bin/bash

FBHOME=/var/tmp/fb40tmp
BKNAME=/var/tmp/tmp4test.fbk
DBNAME=/var/tmp/tmp4test.fdb

export ISC_USER=SYSDBA
export ISC_PASSWORD=masterkey

# ::: NOTE :::
# firebird.conf must contain: KeyHolderPlugin = fbSampleKeyHolder

for f in libfbSampleDbCrypt.so libfbSampleKeyHolder.so
do
    cp --force --preserve $FBHOME/examples/prebuilt/plugins/${f} $FBHOME/plugins/
done

rm -f $DBNAME
crypt_plugin_name=\"fbSampleDbCrypt\"
echo "create database 'localhost:$DBNAME'; show version;" | $FBHOME/bin/isql -q
echo "alter database encrypt with $crypt_plugin_name key Red;shell sleep 2;show database;" | $FBHOME/bin/isql $DBNAME -q

$FBHOME/bin/gfix -sql_dialect 1 $DBNAME

$FBHOME/bin/gstat -h $DBNAME | grep -i dialect
$FBHOME/bin/gbak -b -KEYHOLDER fbSampleKeyHolder -crypt fbSampleDbCrypt $DBNAME $BKNAME
echo ----------- restore using backup ----------------
$FBHOME/bin/gbak -rep -KEYHOLDER fbSampleKeyHolder $BKNAME $DBNAME
echo ----------- restore using PIPE ------------------
$FBHOME/bin/gbak -b -KEYHOLDER fbSampleKeyHolder -crypt fbSampleDbCrypt $DBNAME stdout | $FBHOME/bin/gbak -rep -KEYHOLDER fbSampleKeyHolder stdin $DBNAME

gbak: ERROR:unsuccessful metadata update
gbak: ERROR:    ALTER DATABASE failed
gbak: ERROR:    Error loading plugin FBSAMPLEDBCRYPT
gbak: ERROR:    Module /var/tmp/fb40tmp/plugins/FBSAMPLEDBCRYPT does not contain plugin FBSAMPLEDBCRYPT type 9
gbak:Exiting before completion due to errors

gbak: ERROR:unsuccessful metadata update
gbak: ERROR:    ALTER DATABASE failed
gbak: ERROR:    Crypt plugin FBSAMPLEDBCRYPT failed to load
gbak:Exiting before completion due to errors

KeyHolderPlugin = fbSampleKeyHolder

echo "alter database encrypt with $crypt_plugin_name key Red;shell sleep 2;show database;" | $FBHOME/bin/isql $DBNAME -q

$FBHOME/bin/gfix -sql_dialect 1 $DBNAME