CODEWITHSUNDEEP
sqlbash
bedford
bedford

Reputation: 181

How to read lines from .txt file into this bash script?

I have this bash script which connects to a postgre sql db and performs a query. I would like to be able to read line from a .txt file into the query as parameters. What is the best way to do that? Your assistance is greatly appreciated! I have my example code below however it is not working.

#!/bin/sh

query="SELECT ci.NAME_VALUE NAME_VALUE FROM certificate_identity ci WHERE ci.NAME_TYPE = 'dNSName' AND reverse(lower(ci.NAME_VALUE)) LIKE reverse(lower('%.$1'));"

(echo $1; echo $query | \
    psql -t -h crt.sh -p 5432 -U guest certwatch | \
    sed -e 's:^ *::g' -e 's:^*\.::g' -e '/^$/d' | \
    sed -e 's:*.::g';) | sort -u

Upvotes: 0

Views: 270

Answers (1)

Joao Vitorino
Joao Vitorino

Reputation: 3256

Considering that the file has only one sql query per line:

while read -r line; do echo "${line}" | "your code to run psql here"; done < file_with_query.sql

That means: while read the content of file_with_query.sql line by line, do something with each line.

Upvotes: 1

Related Questions