2010-09-01 13:26:45 +00:00
|
|
|
### Test of #! -Y with file as input
|
|
|
|
|
Testing if -Y works
|
|
|
|
|
Yes it does
|
|
|
|
|
### Test of #! --shebang with file as input
|
|
|
|
|
Testing if --shebang works
|
|
|
|
|
Yes it does
|
|
|
|
|
### Test reading sql on command line
|
|
|
|
|
Test reading SQL from command line
|
|
|
|
|
Yes it does
|
|
|
|
|
### Test reading sql from file
|
|
|
|
|
Test reading SQL from file works
|
|
|
|
|
Yes it does
|
|
|
|
|
### Test dburl with username password host port
|
|
|
|
|
Test reading SQL from file works
|
|
|
|
|
Yes it does
|
2010-09-07 23:43:11 +00:00
|
|
|
### Test .sql/aliases
|
|
|
|
|
Test if .sql/aliases works
|
2010-09-01 13:26:45 +00:00
|
|
|
Yes it does
|
2011-03-09 15:23:53 +00:00
|
|
|
### Test sql:sql::alias
|
|
|
|
|
Test sql:sql::alias
|
|
|
|
|
Yes it works
|
2010-09-01 13:26:45 +00:00
|
|
|
### Test --noheaders --no-headers -n
|
|
|
|
|
abc 1
|
|
|
|
|
def 3
|
|
|
|
|
abc 1
|
|
|
|
|
def 3
|
|
|
|
|
abc 1
|
|
|
|
|
def 3
|
|
|
|
|
### Test --sep -s
|
|
|
|
|
2 1
|
|
|
|
|
2 1
|
|
|
|
|
### Test --passthrough -p
|
|
|
|
|
<TABLE BORDER=1><TR><TH>id</TH><TH>data</TH></TR><TR><TD>1</TD><TD>abc</TD></TR><TR><TD>3</TD><TD>def</TD></TR></TABLE>
|
|
|
|
|
<TABLE BORDER=1><TR><TH>id</TH><TH>data</TH></TR><TR><TD>1</TD><TD>abc</TD></TR><TR><TD>3</TD><TD>def</TD></TR></TABLE>
|
|
|
|
|
### Test --html
|
|
|
|
|
<TABLE BORDER=1><TR><TH>id</TH><TH>data</TH></TR><TR><TD>1</TD><TD>abc</TD></TR><TR><TD>3</TD><TD>def</TD></TR></TABLE>
|
|
|
|
|
### Test --show-processlist|proclist|listproc
|
2010-09-07 23:43:11 +00:00
|
|
|
2 17
|
|
|
|
|
2 17
|
|
|
|
|
2 17
|
2010-09-01 13:26:45 +00:00
|
|
|
### Test --db-size --dbsize
|
|
|
|
|
3 12 89
|
|
|
|
|
3 12 89
|
|
|
|
|
### Test --table-size --tablesize
|
|
|
|
|
30
|
|
|
|
|
30
|
|
|
|
|
### Test --debug
|
2010-09-10 00:26:01 +00:00
|
|
|
dburl mysql://sqlunittest:CB5A1FFFA5A@localhost:3306/sqlunittest
|
|
|
|
|
databasedriver mysql user sqlunittest password CB5A1FFFA5A host localhost port 3306 database sqlunittest query
|
2010-09-01 13:26:45 +00:00
|
|
|
mysql -C --host=localhost --user=sqlunittest --port=3306 --password=CB5A1FFFA5A sqlunittest
|
|
|
|
|
Test if --debug works
|
|
|
|
|
Yes it does
|
|
|
|
|
### Test --version -V
|
|
|
|
|
7 43 306
|
|
|
|
|
7 43 306
|
|
|
|
|
### Test -r
|
2010-09-10 00:26:01 +00:00
|
|
|
dburl pg://nongood@127.0.0.3:2227/
|
|
|
|
|
databasedriver pg user nongood password host 127.0.0.3 port 2227 database query
|
2010-09-01 13:26:45 +00:00
|
|
|
psql -h 127.0.0.3 -U nongood -p 2227
|
|
|
|
|
psql: could not connect to server: Connection refused
|
|
|
|
|
Is the server running on host "127.0.0.3" and accepting
|
|
|
|
|
TCP/IP connections on port 2227?
|
|
|
|
|
psql -h 127.0.0.3 -U nongood -p 2227
|
|
|
|
|
psql: could not connect to server: Connection refused
|
|
|
|
|
Is the server running on host "127.0.0.3" and accepting
|
|
|
|
|
TCP/IP connections on port 2227?
|
|
|
|
|
psql -h 127.0.0.3 -U nongood -p 2227
|
|
|
|
|
psql: could not connect to server: Connection refused
|
|
|
|
|
Is the server running on host "127.0.0.3" and accepting
|
|
|
|
|
TCP/IP connections on port 2227?
|
|
|
|
|
### Test --retries=s
|
2010-09-10 00:26:01 +00:00
|
|
|
dburl pg://nongood@127.0.0.3:2227/
|
|
|
|
|
databasedriver pg user nongood password host 127.0.0.3 port 2227 database query
|
2010-09-01 13:26:45 +00:00
|
|
|
psql -h 127.0.0.3 -U nongood -p 2227
|
|
|
|
|
psql: could not connect to server: Connection refused
|
|
|
|
|
Is the server running on host "127.0.0.3" and accepting
|
|
|
|
|
TCP/IP connections on port 2227?
|
|
|
|
|
psql -h 127.0.0.3 -U nongood -p 2227
|
|
|
|
|
psql: could not connect to server: Connection refused
|
|
|
|
|
Is the server running on host "127.0.0.3" and accepting
|
|
|
|
|
TCP/IP connections on port 2227?
|
|
|
|
|
psql -h 127.0.0.3 -U nongood -p 2227
|
|
|
|
|
psql: could not connect to server: Connection refused
|
|
|
|
|
Is the server running on host "127.0.0.3" and accepting
|
|
|
|
|
TCP/IP connections on port 2227?
|
|
|
|
|
psql -h 127.0.0.3 -U nongood -p 2227
|
|
|
|
|
psql: could not connect to server: Connection refused
|
|
|
|
|
Is the server running on host "127.0.0.3" and accepting
|
|
|
|
|
TCP/IP connections on port 2227?
|
|
|
|
|
### Test --help -h
|
|
|
|
|
Usage:
|
|
|
|
|
sql [options] dburl [sqlcommand]
|
|
|
|
|
sql [options] dburl < sql_command_file
|
|
|
|
|
|
|
|
|
|
See 'man sql' for the options
|
|
|
|
|
Usage:
|
|
|
|
|
sql [options] dburl [sqlcommand]
|
|
|
|
|
sql [options] dburl < sql_command_file
|
|
|
|
|
|
|
|
|
|
See 'man sql' for the options
|
