#!/bin/sh
#----------------------------------------------------------------------------
# /var/install/bin/firebird-tools-isql - Firebird SQL Server ISQL start
#
# Creation:     2004-02-14  jv
# Last Update:  $Id$
#
# Copyright (c) 2004-2010 Jens Vehlhaber, jvehlhaber(at)eisfair(dot)org
# Copyright (c) 2015-@@YEAR@@ Holger Bruenjes, holgerbruenjes(at)gmx(dot)net
#
# 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.
#----------------------------------------------------------------------------

#include eislib
. /var/install/include/eislib

export FIREBIRD='/usr/lib/firebird'

# ---------------------------------------------------------------------------
# check for running
# ---------------------------------------------------------------------------
if [ -z "$(pgrep '(fbserver|fbguard)')" ]
then
    mecho ""
    mecho --error "Firebird is not running"
    mecho ""
    anykey
    exit 1
fi

clrhome

# show help file
/var/install/bin/doc /usr/share/doc/firebird/isql.txt

# read the ISC_PASSWORD only
pw=`grep ISC_PASSWORD= ${FIREBIRD}/isc4.pw | sed "s/ISC_PASSWORD=//g"`

# Read DATA_DIRECTORY
. /etc/config.d/firebird

if [ "$FIREBIRD_DATADIR" = "${FIREBIRD}/sample" -o ! -d "${FIREBIRD}/sample" ]
then
    sDir="$FIREBIRD_DATADIR"
else
    sDir="$FIREBIRD_DATADIR,${FIREBIRD}/sample"
fi

# Run file-select tool
/usr/bin/filelist -s=$sDir -e=*.fdb,*.gdb -c -l=23 -r="/usr/bin/isql-fb,-u,SYSDBA,-p,${pw},_FSP_/_FSE_"

exit 0
# ---------------------------------------------------------------------------
# end
# ---------------------------------------------------------------------------