par__dbsize ### Test --db-size --dbsize par__dbsize 6 par__dbsize 6 par__listproc ### Test --show-processlist|proclist|listproc par__listproc 2 17 par__listproc 2 17 par__listproc 2 17 par__noheaders ### Test --noheaders --no-headers -n par__noheaders abc 1 par__noheaders def 3 par__noheaders abc 1 par__noheaders def 3 par__noheaders abc 1 par__noheaders def 3 par__tablesize ### Test --table-size --tablesize par__tablesize 93 par__tablesize 93 par_dburl_user_password_host_port ### Test dburl with username password host port par_dburl_user_password_host_port Test dburl with username password host port par_dburl_user_password_host_port OK par_debug ### Test --debug par_debug dburl mysql://tange:tange@/ par_debug databasedriver mysql user tange password tange host port database tange query par_debug [ | ((sleep 1; rm /TMP/tmpfile') & mysql --defaults-extra-file=/TMP/tmpfile' --user=tange tange)] par_debug Test if --debug works par_debug Yes it does par_help ### Test --help -h par_help Usage: par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl [sqlcommand] par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl < sql_command_file par_help par_help See 'man sql' for the options par_help Usage: par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl [sqlcommand] par_help sql [-hnr] [--table-size] [--db-size] [-p pass-through] [-s string] dburl < sql_command_file par_help par_help See 'man sql' for the options par_html ### Test --html par_html
iddata
1abc
3def
par_passthrough ### Test --passthrough -p par_passthrough
iddata
1abc
3def
par_passthrough
iddata
1abc
3def
par_read_sql_from_file ### Test reading sql from file par_read_sql_from_file Test reading SQL from file works par_read_sql_from_file Yes it does par_retry ### Test -r - retry 3 times par_retry dburl pg://nongood@127.0.0.3:2227/ par_retry databasedriver pg user nongood password host 127.0.0.3 port 2227 database nongood query par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood] par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused par_retry Is the server running on that host and accepting TCP/IP connections? par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood] par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused par_retry Is the server running on that host and accepting TCP/IP connections? par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood] par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused par_retry Is the server running on that host and accepting TCP/IP connections? par_retry ### Test --retries=s par_retry dburl pg://nongood@127.0.0.3:2227/ par_retry databasedriver pg user nongood password host 127.0.0.3 port 2227 database nongood query par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood] par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused par_retry Is the server running on that host and accepting TCP/IP connections? par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood] par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused par_retry Is the server running on that host and accepting TCP/IP connections? par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood] par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused par_retry Is the server running on that host and accepting TCP/IP connections? par_retry [ | psql -h 127.0.0.3 -U nongood -p 2227 -d nongood] par_retry psql: error: connection to server at "127.0.0.3", port 2227 failed: Connection refused par_retry Is the server running on that host and accepting TCP/IP connections? par_sep ### Test --sep -s par_sep 2 1 par_sep 2 1 par_shebang-Y ### Test of #! -Y with file as input par_shebang-Y Testing if -Y works par_shebang-Y Yes it does par_shebang_file ### Test of #! --shebang with file as input par_shebang_file Testing if --shebang works par_shebang_file Yes it does par_sql_aliases ### Test .sql/aliases par_sql_aliases Test if .sql/aliases works par_sql_aliases Yes it does par_sql_aliases ### Test sql:sql::alias par_sql_aliases Test sql:sql::alias par_sql_aliases Yes it works par_sql_on_cmdline ### Test reading sql on command line par_sql_on_cmdline Test reading SQL from command line par_sql_on_cmdline Yes it does par_version ### Test --version -V par_version 13 74 535 par_version 13 74 535