SQLite

Check-in [7d0ff26a95]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Test case for the ".log" command to the command-line shell.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 7d0ff26a95cb1e9fcace4641245dda787f3522b4
User & Date: drh 2011-04-25 18:20:04.278
Context
2011-04-27
01:00
Fix a comment typo. (check-in: 19c6625abd user: drh tags: trunk)
2011-04-25
18:20
Test case for the ".log" command to the command-line shell. (check-in: 7d0ff26a95 user: drh tags: trunk)
18:03
Add the (deliberately undocumented) sqlite_log() SQL function as a built-in. (check-in: f7806e0399 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to tool/shell1.test.
707
708
709
710
711
712
713





714
  catchcmd "test.db" ".timer OFF"
} {0 {}}
do_test shell1-3.27.4 {
  # too many arguments
  catchcmd "test.db" ".timer OFF BAD"
} {1 {Error: unknown command or invalid arguments:  "timer". Enter ".help" for help}}






puts "CLI tests completed successfully"







>
>
>
>
>

707
708
709
710
711
712
713
714
715
716
717
718
719
  catchcmd "test.db" ".timer OFF"
} {0 {}}
do_test shell1-3.27.4 {
  # too many arguments
  catchcmd "test.db" ".timer OFF BAD"
} {1 {Error: unknown command or invalid arguments:  "timer". Enter ".help" for help}}

do_test shell1-3-28.1 {
  catchcmd test.db \
     ".log stdout\nSELECT coalesce(sqlite_log(123,'hello'),'456');"
} "0 {(123) hello\n456}"

puts "CLI tests completed successfully"