Chromium Code Reviews
chromiumcodereview-hr@appspot.gserviceaccount.com (chromiumcodereview-hr) | Please choose your nickname with Settings | Help | Chromium Project | Gerrit Changes | Sign out
(244)

Unified Diff: third_party/sqlite/sqlite-src-3100200/ext/fts5/tool/showfts5.tcl

Issue 2846743003: [sql] Remove SQLite 3.10.2 reference directory. (Closed)
Patch Set: Created 3 years, 8 months ago
Use n/p to move between diff chunks; N/P to move between comments. Draft comments are only viewable by you.
Jump to:
View side-by-side diff with in-line comments
Download patch
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
- }
-}
-
-
-
-
-

Powered by Google App Engine
This is Rietveld 408576698