DS4A Latam 2020 - Week 3 - Extended Case Automation

run_query.sh

#!/bin/sh

# Reads query from file
query=$(cat $1)

# Creates output file
touch $2

# Performs query
PGPASSWORD=[password] psql -h [server] -U postgres -d [database] -c "${query}" > $2

# Removes first line
echo "$(sed '1d' $2)\n" > $2
# Formats for Markdown
sed -i 's/\+/|/g' $2

# Copies to clipboard
xclip -sel c < $2