Ian Fijolek
eb80a81255
All checks were successful
continuous-integration/drone/push Build is passing
21 lines
539 B
Bash
Executable File
21 lines
539 B
Bash
Executable File
#! /bin/bash
|
|
set -ex
|
|
|
|
# Check flat file
|
|
test -f /data/test.txt
|
|
grep "^Hello" /data/test.txt
|
|
|
|
# Check Sqlite database
|
|
test -f /data/test_database.db
|
|
sqlite3 /data/test_database.db "select data from test_table where id = 1" | grep "^Test row"
|
|
|
|
# Check MySql database
|
|
mysql --user "$MYSQL_USER" --password "$MYSQL_PWD" main <<-EOF | grep "^Test row"
|
|
select data from test_table where id = 1;
|
|
EOF
|
|
|
|
# Check Postgresql database
|
|
pgsql --username "$PGSQL_USER" --dbname main <<-EOF | grep "^Test row"
|
|
select data from test_table where id = 1;
|
|
EOF
|