#!/bin/bash

POSTGRES_USER=scalebox
POSTGRES_HOST=localhost
POSTGRES_DB=scalebox
PGPORT=5432

job_id=$1

objids=("NGC6217" "NGC6397")
for((i=0;i<${#objids[@]};i++)); do
    m=${objids[$i]}
    echo $m
    docker exec -t database psql -U ${POSTGRES_USER} -h ${POSTGRES_HOST} -d ${POSTGRES_DB} -p ${PGPORT} \
        -c "INSERT INTO t_task(job,key_message) VALUES(${job_id},'${m}')"
done