Documentation Source Text

Check-in [9f7ee8332a]
Login

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

Overview
Comment:Add news and update metrics in testing.html.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 9f7ee8332a29f88e0e96832a8a04975497ffa4f6847ac788138a79da39c84248
User & Date: drh 2018-03-30 18:12:42
Context
2018-03-30
18:33
Fix typos discovered by spell-check. check-in: e436f9d464 user: drh tags: trunk
18:12
Add news and update metrics in testing.html. check-in: 9f7ee8332a user: drh tags: trunk
18:08
Bring the speed-and-size spreadsheet up-to-date. check-in: f80a29418e user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/news.in.

    14     14     hd_puts "<h3>$date - $title</h3>"
    15     15     regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
    16     16     regsub -all {[Tt]icket #(\d+)} $txt \
    17     17         {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
    18     18     hd_resolve "<blockquote>$txt</blockquote>"
    19     19     hd_puts "<hr width=\"50%\">"
    20     20   }
           21  +
           22  +newsitem {2018-03-31} {Release 3.23.0} {
           23  +The [version 3.23.0] release is a regularly scheduled maintenance release.
           24  +See the [version 3.23.0|change log] for a list of enhancements and bug
           25  +fixes.
           26  +}
    21     27   
    22     28   newsitem {2018-01-22} {Release 3.22.0} {
    23     29   The [version 3.22.0] release is a regularly scheduled maintenance release.
    24     30   There are many minor, though interesting, enhancements in this release.
    25     31   See the [version 3.22.0|change log] for details.
    26     32   }
    27     33   

Changes to pages/testing.in.

     9      9   # facilitate that, all the size values are defined by variables here
    10     10   # which are then used as needed through the document.
    11     11   #
    12     12   # NOTE:  Also update the version number in the text!!!
    13     13   #
    14     14   
    15     15   # sloc sqlite3.c
    16         -set stat(coreSLOC)   125375  ;# Non-comment lines of amalgamation code 
           16  +set stat(coreSLOC)   128906  ;# Non-comment lines of amalgamation code 
    17     17   # sloc test*.c
    18         -set stat(tclcSLOC)    25300  ;# Non-comment lines of test C code
           18  +set stat(tclcSLOC)    26088  ;# Non-comment lines of test C code
    19     19   # ls test*.c tclsqlite.c | wc
    20         -set stat(tclcNfile)      46  ;# Number of files of TCL C testcode + tclsqlite.c
           20  +set stat(tclcNfile)      48  ;# Number of files of TCL C testcode + tclsqlite.c
    21     21   # ls -l test*.c tclsqlite.c | awk '{sum+=$5}END{print sum}'
    22         -set stat(tclcNByte) 1193625  ;# Number of bytes of TCL C testcode + tclsqlite.c
           22  +set stat(tclcNByte) 1212234  ;# Number of bytes of TCL C testcode + tclsqlite.c
    23     23   # sloc `find . -name '*.test' -print` test/*.tcl
    24         -set stat(tclsSLOC)   317456  ;# Non-comment lines of TCL test script
           24  +set stat(tclsSLOC)   462686  ;# Non-comment lines of TCL test script
    25     25   # ls `find . -name '*.test' -print` test/*.tcl | wc
    26         -set stat(tclsNFile)    1135  ;# Number of files of TCL test script
           26  +set stat(tclsNFile)    1307  ;# Number of files of TCL test script
    27     27   # wc `find . -name '*.test' -print` test/*.tcl
    28         -set stat(tclsNByte) 13984314 ;# Number of bytes of TCL test script
           28  +set stat(tclsNByte) 16214472 ;# Number of bytes of TCL test script
    29     29   # cat `find . -name '*.test' -print` | egrep 'do[_a-z]*_test' | wc
    30         -set stat(tclNTest)    39747  ;# Number of test cases in the TCL test suite
    31         -set stat(tclNEval)  2504837  ;# Number of test case evaluations (fulltest)
           30  +set stat(tclNTest)    40870  ;# Number of test cases in the TCL test suite
           31  +set stat(tclNEval)  2514125  ;# Number of test case evaluations (fulltest)
    32     32   # grep fuzz device_one/test-out.txt | wc
    33     33   set stat(nSqlFuzz)   111268  ;# Number of SQL fuzz tests
    34     34   set stat(vqNEval)    142597  ;# Number of test evaluations for veryquick.test
    35     35   #  set stat(vqStmtCov)   97.23  ;# veryquick statement coverage
    36     36   #  set stat(vqBrCov)     92.57  ;# veryquick branch coverage
    37     37   #  set stat(allStmtCov)  99.50  ;# all.test statement coverage
    38     38   #  set stat(allBrCov)    97.41  ;# all.test condition/decision coverage
    39     39   # tclsh mkth3.tcl cfg/*.cfg */*.test >th3.c; sloc th3.c
    40         -set stat(th3SLOC)    782314  ;# Non-comment lines in full th3.c
           40  +set stat(th3SLOC)    792338  ;# Non-comment lines in full th3.c
    41     41   # ls -l th3.c
    42         -set stat(th3NByte) 57259210  ;# Number of bytes in full th3.c
           42  +set stat(th3NByte) 57927541  ;# Number of bytes in full th3.c
    43     43   # grep th3testCheck */*.test |wc
    44     44   # grep '^--result' */*.test | wc
    45     45   # grep '^--glob' */*.test | wc
    46     46   # grep '^--notglob' */*.test | wc
    47     47   # grep '^--eqp' */*.test | wc
    48         -set stat(th3NTest)      42213  ;# Number of test cases
           48  +set stat(th3NTest)      43049  ;# Number of test cases
    49     49   # from output of a min.rc test run.
    50         -set stat(th3NECov)    1726070  ;# Number of test case evals for coverage
           50  +set stat(th3NECov)    1614390  ;# Number of test case evals for coverage
    51     51   #set stat(th3NETest)  7247055  ;# Number of test case evaluations
    52     52   #set stat(th3NEExt) 589175483  ;# Number of test case evals extended
    53     53   #set stat(th3NERel) 2500000000 ;# Number of test case evals release
    54     54   set stat(th3StmtCov) 100.00  ;# TH3 statement coverage
    55     55   set stat(th3BrCov)   100.00  ;# TH3 branch coverage
    56     56   # wc `find . -name '*.test'` | awk '{x+=$1}END{print x}'
    57     57   set stat(sltsSLOC)  90489494 ;# Non-comment lines of SLT test script
................................................................................
    62     62   # sloc md5.c slt_*.c sqllogictest.c
    63     63   set stat(sltcSLOC)        1404 ;# Non-comment lines of SLT C code
    64     64   # grep '^query' `fossil ls | awk '/\.test$/{print $2}'` | wc
    65     65   set stat(sltNTest)     7195342 ;# Number of test cases in SLT
    66     66   # grep 'errors out of' all-out.txt | awk '{x+=$5}END{print x}'
    67     67   set stat(sltNRun)     11879758 ;# Number of tests run in SLT
    68     68   # grep 'assert(' sqlite3.c | wc
    69         -set stat(nAssert)         5285 ;# Number of assert statements
           69  +set stat(nAssert)         5415 ;# Number of assert statements
    70     70   # grep 'testcase(' sqlite3.c | grep -v define | wc
    71         -set stat(nTestcase)        846 ;# Number of testcase statements
           71  +set stat(nTestcase)        878 ;# Number of testcase statements
    72     72   
    73     73   set stat(totalSLOC) [expr {$stat(tclcSLOC)+$stat(tclsSLOC)+
    74     74                              $stat(th3SLOC)+$stat(sltcSLOC)+$stat(sltsSLOC)}]
    75     75   
    76     76   proc GB {expr} {
    77     77     set n [uplevel #0 expr $expr]
    78     78     hd_puts [format %.2f [expr {$n/(1000.0*1000.0*1000.0)}]]
................................................................................
   103    103   </tcl>
   104    104   
   105    105   <h1>Introduction</h1>
   106    106   
   107    107   <p>The reliability and robustness of SQLite is achieved in part
   108    108   by thorough and careful testing.</p>
   109    109   
   110         -<p>As of [version 3.20.0] ([dateof:3.20.0]),
          110  +<p>As of [version 3.23.0] ([dateof:3.23.0]),
   111    111   the SQLite library consists of approximately
   112    112   <tcl>KB {$stat(coreSLOC)}</tcl> KSLOC of C code.
   113    113   (KSLOC means thousands of "Source Lines Of Code" or, in other words,
   114    114   lines of code excluding blank lines and comments.)
   115    115   By comparison, the project has
   116    116   <tcl>
   117    117   hd_puts "[expr {int($stat(totalSLOC)/$stat(coreSLOC))}] times as much"