/ Check-in [33a14e7b]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Fix the help message that sqlite3_analyzer.exe generates for invalid arguments.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 33a14e7be1004abca7a30f675459138d7f8d72b1
User & Date: drh 2015-09-08 17:31:30
Context
2015-09-08
20:26
Eponymous virtual tables exist in the "main" schema only. Enforce this rule. check-in: 06f90bb2 user: drh tags: trunk
17:31
Fix the help message that sqlite3_analyzer.exe generates for invalid arguments. check-in: 33a14e7b user: drh tags: trunk
2015-09-07
23:40
Minor tweaks to Lemon. check-in: 98667722 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to tool/spaceanal.tcl.

    22     22     return 0
    23     23   }
    24     24   
    25     25   # Get the name of the database to analyze
    26     26   #
    27     27   proc usage {} {
    28     28     set argv0 [file rootname [file tail [info nameofexecutable]]]
    29         -  puts stderr "Usage: $argv0 \[--pageinfo] \[--stats] database-name"
           29  +  puts stderr "Usage: $argv0 ?--pageinfo? ?--stats? database-filename"
           30  +  puts stderr {
           31  +Analyze the SQLite3 database file specified by the "database-filename"
           32  +argument and output a report detailing size and storage efficiency
           33  +information for the database and its constituent tables and indexes.
           34  +
           35  +Options:
           36  +
           37  +   --stats        Output SQL text that creates a new database containing
           38  +                  statistics about the database that was analyzed
           39  +
           40  +   --pageinfo     Show how each page of the database-file is used
           41  +}
    30     42     exit 1
    31     43   }
    32     44   set file_to_analyze {}
    33     45   set flags(-pageinfo) 0
    34     46   set flags(-stats) 0
    35     47   append argv {}
    36     48   foreach arg $argv {