head     1.2;
branch   ;
access   ;
symbols  ;
locks    ; strict;
comment  @# @;


1.2
date     91.11.20.03.05.48;  author mer;  state Exp;
branches ;
next     1.1;

1.1
date     91.11.19.23.15.26;  author mer;  state Exp;
branches ;
next     ;


desc
@bring the video demo into the golden age of automation
@


1.2
log
@ooops do all scripts.
@
text
@#!/bin/sh

# $Header: /users/mer/postgres/video/RCS/wholevideo.sh,v 1.1 1991/11/19 23:15:26 mer Exp mer $
# This is a simple script used to run the entire video without having to
# type all of those tedious include commands to the terminal monitor.
# This script assumes that the postmaster is currently running.
# 
# NOTE:
# It also assumes that you don't have a data base video in which you keep
# important data (it destroys video if it exists then re-creates it to run
# the postgres video queries).

datafile=/tmp/pgvideo.$$

if [ -d $POSTGRESHOME/data/base/video ]
then
	echo ===== destroying old video database... =====
	destroydb video
fi

echo ===== creating new video database... =====
$POSTGRESHOME/bin/createdb video

rm -f $datafile

echo "retrieve (x=1) \g" > $datafile

for f in `cat video_order`
do
	cat $POSTGRESHOME/video/$f | sed -e 's/\\p/\\g/g' >> $datafile
done

$POSTGRESHOME/bin/monitor video < $datafile

rm -f $datafile
@


1.1
log
@Initial revision
@
text
@d3 1
a3 1
# $Header: /users/mer/postgres/demo/RCS/wholedemo.sh,v 1.2 1991/11/19 18:21:43 mer Exp $
a31 3

echo Data file is $datafile
exit 0
@