| Index: third_party/sqlite/sqlite-src-3100200/ext/fts5/tool/showfts5.tcl
|
| diff --git a/third_party/sqlite/sqlite-src-3100200/ext/fts5/tool/showfts5.tcl b/third_party/sqlite/sqlite-src-3100200/ext/fts5/tool/showfts5.tcl
|
| deleted file mode 100644
|
| index 75ac0f1c8f809dca172b1130b3a0452cc2c4d127..0000000000000000000000000000000000000000
|
| --- a/third_party/sqlite/sqlite-src-3100200/ext/fts5/tool/showfts5.tcl
|
| +++ /dev/null
|
| @@ -1,97 +0,0 @@
|
| -
|
| -
|
| -
|
| -#-------------------------------------------------------------------------
|
| -# Process command line arguments.
|
| -#
|
| -proc usage {} {
|
| - puts stderr "usage: $::argv0 ?OPTIONS? database table"
|
| - puts stderr ""
|
| - puts stderr " -nterm (count number of terms in each segment)"
|
| - puts stderr " -segments (output segment contents)"
|
| - puts stderr ""
|
| - exit 1
|
| -}
|
| -
|
| -set O(nterm) 0
|
| -set O(segments) 0
|
| -
|
| -if {[llength $argv]<2} usage
|
| -foreach a [lrange $argv 0 end-2] {
|
| - switch -- $a {
|
| - -nterm {
|
| - set O(nterm) 1
|
| - }
|
| -
|
| - -segments {
|
| - set O(segments) 1
|
| - }
|
| -
|
| - default {
|
| - usage
|
| - }
|
| - }
|
| -}
|
| -
|
| -set database [lindex $argv end-1]
|
| -set tbl [lindex $argv end]
|
| -
|
| -
|
| -#-------------------------------------------------------------------------
|
| -# Count the number of terms in each segment of fts5 table $tbl. Store the
|
| -# counts in the array variable in the parent context named by parameter
|
| -# $arrayname, indexed by segment-id. Example:
|
| -#
|
| -# count_terms fts_tbl A
|
| -# foreach {k v} [array get A] { puts "segid=$k nTerm=$v" }
|
| -#
|
| -proc count_terms {tbl arrayname} {
|
| - upvar A $arrayname
|
| - array unset A
|
| - db eval "SELECT fts5_decode(rowid, block) AS d FROM ${tbl}_data" {
|
| - set desc [lindex $d 0]
|
| - if {[regexp {^segid=([0-9]*)} $desc -> id]} {
|
| - foreach i [lrange $d 1 end] {
|
| - if {[string match {term=*} $i]} { incr A($id) }
|
| - }
|
| - }
|
| - }
|
| -}
|
| -
|
| -
|
| -#-------------------------------------------------------------------------
|
| -# Start of main program.
|
| -#
|
| -sqlite3 db $database
|
| -catch { load_static_extension db fts5 }
|
| -
|
| -if {$O(nterm)} { count_terms $tbl A }
|
| -
|
| -db eval "SELECT fts5_decode(rowid, block) AS d FROM ${tbl}_data WHERE id=10" {
|
| - foreach lvl [lrange $d 1 end] {
|
| - puts [lrange $lvl 0 2]
|
| -
|
| - foreach seg [lrange $lvl 3 end] {
|
| - if {$::O(nterm)} {
|
| - regexp {^id=([0-9]*)} $seg -> id
|
| - set nTerm 0
|
| - catch { set nTerm $A($id) }
|
| - puts [format " % -28s nTerm=%d" $seg $nTerm]
|
| - } else {
|
| - puts [format " % -28s" $seg]
|
| - }
|
| - }
|
| - }
|
| -}
|
| -
|
| -if {$O(segments)} {
|
| - puts ""
|
| - db eval "SELECT fts5_decode(rowid, block) AS d FROM ${tbl}_data WHERE id>10" {
|
| - puts $d
|
| - }
|
| -}
|
| -
|
| -
|
| -
|
| -
|
| -
|
|
|