#!/bin/bash
# Nathalie - 13/02/2024

while read line
do
  msimageid=$(mysql -sN -e "select ms_image_id from images where file_name='$line';")
  query_txt="insert into MetadataFromPA set mdfpa_pic_id=$msimageid, mdfpa_csv='3:238\r\n\"PP\"', mdfpa_created_at=now();"
  echo $query_txt
  #$(mysql -h94.23.128.22 -upixadmin -pere6ahgu -Dmain_server -e "insert into MetadataFromPA set mdfpa_pic_id=$msimageid, mdfpa_csv='3:238\r\n\"PP\"', mdfpa_created_at=now();")
done < $1