Ticket #4093: recreate_fb_tables.sh

#!/bin/sh

# Discover where the shell script resides
ORIGDIR=`pwd`                          # original directory (builtin)
PROGNAME=`type $0 | awk '{print $3}'`  # search for executable on path
PROGDIR=`dirname $PROGNAME`            # extract directory of program
PROGNAME=`basename $PROGNAME`          # base name of program
cd $PROGDIR                            # go to that directory
PROGDIR=`pwd`                          # remove any symbolic link parts


create_database()
{
    DB_NAME=$1
    SCRIPT_NAME=$2

    /Library/FrontBase/bin/sql92 <<END
STOP DATABASE ${DB_NAME};
DELETE DATABASE ${DB_NAME};
CREATE DATABASE ${DB_NAME};

CONNECT TO ${DB_NAME} AS SESSION_NAME USER _SYSTEM;
SET COMMIT FALSE;

CREATE USER RAILS;
CREATE SCHEMA RAILS AUTHORIZATION RAILS;
COMMIT;

SET SESSION AUTHORIZATION RAILS;
SCRIPT '${SCRIPT_NAME}';

COMMIT;

DISCONNECT ALL;
END
}


create_database activerecord_unittest $PROGDIR/test/fixtures/db_definitions/frontbase.sql
create_database activerecord_unittest2 $PROGDIR/test/fixtures/db_definitions/frontbase2.sql
exit 0

/Library/FrontBase/bin/sql92 <<END
STOP DATABASE TEST;
DELETE DATABASE TEST;
CREATE DATABASE TEST;

CONNECT TO  TEST AS SESSION_NAME USER _SYSTEM;
SET COMMIT FALSE;

CREATE USER RAILS;
CREATE SCHEMA RAILS AUTHORIZATION RAILS;
COMMIT;

SET SESSION AUTHORIZATION RAILS;
SCRIPT '$PROGDIR/test/fixtures/db_definitions/frontbase.sql';

COMMIT;

disconnect all;
END