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	iliev	1161	#!/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"