#!/bin/bash

tcid=$1
timestamp=$(date +%s)

if [ -z "$tcid" ]; then
  echo please supply tcid
  exit 1
fi

psql tvguide uktivo <<!
INSERT INTO MESSAGE_REQUESTS (message_type, message_id, message_filename, tcid, request_date)
VALUES ('run_script', '29000004', 'diagnostics.bash', '$tcid', $timestamp);
!