#!/usr/local/bin/perl

# IMPORTANT: insert_psu_bin.sql and insert_psu.sql are generated by extract_lv_data.pl
# from wiener_data.txt, but please check them visually!
# IMPORTANT: psu_bin creation must precede that of psu and psu_chan since they have
# foreign keys and constraints to psu_bin; the same is true for filling these tables
# by running the insert_xxx sql scripts below! 

$command = "psql -d gateDB -U alice";

`$command -f create_psu.sql -o create_psu.out 2>create_psu.err`;
#`$command -f insert_psu_bin.sql -o insert_psu_bin.out 2>insert_psu_bin.err`;
`$command -f insert_psu.sql -o insert_psu.out 2>insert_psu.err`;
#`$command -f insert_psu_chan.sql -o insert_psu_chan.out 2>insert_psu_chan.err`;
