45 lines
921 B
Bash
Executable File
45 lines
921 B
Bash
Executable File
#!/bin/sh
|
|
if [ $# -eq 0 ]
|
|
then
|
|
echo "No arguments supplied"
|
|
echo "$0 [dbname] [dbport] [sqlpath]"
|
|
exit
|
|
fi
|
|
|
|
DATABASE=$1
|
|
PORT=$2
|
|
SQLPATH=$3
|
|
|
|
# Assumes .pgpass is correctly set
|
|
psql -p $PORT $DATABASE << EOF
|
|
|
|
begin transaction;
|
|
|
|
\i $SQLPATH/01_map.sql
|
|
\i $SQLPATH/02_marker.sql
|
|
\i $SQLPATH/03_ogn_address_type.sql
|
|
\i $SQLPATH/04_ogn_aircraft_type.sql
|
|
\i $SQLPATH/05_ogn_device.sql
|
|
\i $SQLPATH/06_ogn_hidden_station.sql
|
|
\i $SQLPATH/07_packet_type.sql
|
|
\i $SQLPATH/08_sender.sql
|
|
\i $SQLPATH/09_source.sql
|
|
\i $SQLPATH/10_station_type.sql
|
|
\i $SQLPATH/11_station.sql
|
|
\i $SQLPATH/12_station_telemetry_bits.sql
|
|
\i $SQLPATH/13_station_telemetry_eqns.sql
|
|
\i $SQLPATH/14_station_telemetry_param.sql
|
|
\i $SQLPATH/15_station_telemetry_unit.sql
|
|
\i $SQLPATH/16_packet.sql
|
|
\i $SQLPATH/17_packet_weather.sql
|
|
\i $SQLPATH/18_packet_telemetry.sql
|
|
\i $SQLPATH/19_packet_path.sql
|
|
\i $SQLPATH/20_packet_ogn.sql
|
|
|
|
commit;
|
|
|
|
EOF
|
|
|
|
|
|
exit 0
|