#! /bin/bash
cd /var/www/html/mrp
PGPASSFILE=".pgpass"
export PGPASSFILE
TMPFILE=`mktemp`
DUMPFILE="${TMPFILE}"
SQLFILE="${TMPFILE}.sql"
data/pg_dump -U admin -h localhost -p 5432 --data-only --column-inserts --table=poitem --file=${TMPFILE} pelican
echo "BEGIN TRANSACTION;" > $SQLFILE
echo "delete from poitem;" >> $SQLFILE
sed -e 's/^SET/-- SET/' -e 's/ false,/ 0,/g' -e 's/ false)/ 0)/' -e 's/ true,/ 1,/g' -e 's/ true)/ 1)/' < $TMPFILE >> $SQLFILE
echo "COMMIT TRANSACTION;" >> $SQLFILE
#sqlite3 data/xtuple.db <<EOF
#drop table if exists poitem;
#CREATE TABLE poitem (
#    poitem_id integer,
#    poitem_status character(1),
#    poitem_pohead_id integer,
#    poitem_linenumber integer,
#    poitem_duedate date,
#    poitem_wohead_id integer,
#    poitem_itemsite_id integer,
#    poitem_vend_item_descrip varchar,
#    poitem_vend_uom varchar,
#    poitem_invvenduomratio real,
#    poitem_qty_ordered real NOT NULL,
#    poitem_qty_received real DEFAULT 0.0 NOT NULL,
#    poitem_qty_returned real DEFAULT 0.0 NOT NULL,
#    poitem_qty_vouchered real DEFAULT 0.0 NOT NULL,
#    poitem_unitprice real,
#    poitem_vend_item_number varchar,
#    poitem_comments varchar,
#    poitem_qty_toreceive real,
#    poitem_expcat_id integer,
#    poitem_itemsrc_id integer,
#    poitem_freight real DEFAULT 0.0 NOT NULL,
#    poitem_freight_received real DEFAULT 0.0 NOT NULL,
#    poitem_freight_vouchered real DEFAULT 0.0 NOT NULL,
#    poitem_soitem_id integer,
#    poitem_prj_id integer,
#    poitem_stdcost real,
#    poitem_bom_rev_id integer,
#    poitem_boo_rev_id integer,
#    poitem_manuf_name varchar,
#    poitem_manuf_item_number varchar,
#    poitem_manuf_item_descrip varchar,
#    poitem_taxtype_id integer,
#    poitem_tax_recoverable integer
#);
#EOF
sqlite3 data/xtuple.db < $SQLFILE