#!/bin/sh

if [ $# -lt 2 ]; then
    BASENAME=`basename $0`
    echo "Syntax:"
    echo "\t$ $BASENAME FILENAME TABLENAME"
    echo "Example:"
    echo "\t$ $BASENAME a.db members"
    exit 0
fi

FILENAME=$1
TABLENAME=$2
SQLFILENAME=$TABLENAME.sql
WORKTABLENAME=${TABLENAME}_old

sqlite3 $FILENAME ".schema $TABLENAME" > $SQLFILENAME

editor $SQLFILENAME

sqlite3 $FILENAME "ALTER TABLE $TABLENAME RENAME TO $WORKTABLENAME"

sqlite3 $FILENAME < $SQLFILENAME

sqlite3 $FILENAME "INSERT INTO $TABLENAME SELECT * FROM $WORKTABLENAME"