File: sqlline

package info (click to toggle)
libpgjava 42.2.5-2%2Bdeb10u1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 8,136 kB
  • sloc: java: 57,821; xml: 1,135; sh: 307; perl: 99; makefile: 7
file content (12 lines) | stat: -rwxr-xr-x 309 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
 
#!/bin/sh

trap 'rm -f sqlline.out' 0 2 3 15

set -eux

pg_virtualenv -i --auth-host=scram-sha-256 <<'EOF'
	set -eux
	URL="jdbc:postgresql://$PGHOST:$PGPORT/$PGDATABASE?user=$PGUSER&password=$PGPASSWORD"
	echo 'SELECT 3*3*3607*3803;' | sqlline -u $URL 2>&1 | tee sqlline.out
	grep '123456789' sqlline.out
EOF