trunk/scripts/create_instr_db.sh

#!/bin/sh

MYDIR="`dirname $0`"
INSTR_DB="$MYDIR/../instruments.db"
SQLITE="`which sqlite3`"

echo "Creating the instrument's DB..."

if [ ! -x "$SQLITE" ] ; then
    echo "Can't find sqlite3" 1>&2
    exit -1
fi

if [ -e "$INSTR_DB" ] ; then
    echo "DB file exists ($INSTR_DB); Skipping..."
    echo "To recreate the instrument DB remove the old DB file first."
    exit
fi

$SQLITE -line $INSTR_DB < "$MYDIR/create_instr_db.sql"

echo "Done"
1	#!/bin/sh
2
3	MYDIR="`dirname $0`"
4	INSTR_DB="$MYDIR/../instruments.db"
5	SQLITE="`which sqlite3`"
6
7	echo "Creating the instrument's DB..."
8
9	if [ ! -x "$SQLITE" ] ; then
10	echo "Can't find sqlite3" 1>&2
11	exit -1
12	fi
13
14	if [ -e "$INSTR_DB" ] ; then
15	echo "DB file exists ($INSTR_DB); Skipping..."
16	echo "To recreate the instrument DB remove the old DB file first."
17	exit
18	fi
19
20	$SQLITE -line $INSTR_DB < "$MYDIR/create_instr_db.sql"
21
22	echo "Done"