1 # 2006 October 1

     2 #

     3 # The author disclaims copyright to this source code.  In place of

     4 # a legal notice, here is a blessing:

     5 #

     6 #    May you do good and not evil.

     7 #    May you find forgiveness for yourself and forgive others.

     8 #    May you share freely, never taking more than you give.

     9 #

    10 #*************************************************************************

    11 # This file implements regression tests for SQLite library.  The

    12 # focus of this script is testing the FTS3 module, and in particular

    13 # the Porter stemmer.

    14 #

    15 # $Id: fts3ad.test,v 1.1 2007/08/20 17:38:42 shess Exp $

    16 #

    17 

    18 set testdir [file dirname $argv0]

    19 source $testdir/tester.tcl

    20 

    21 # If SQLITE_ENABLE_FTS3 is defined, omit this file.

    22 ifcapable !fts3 {

    23   finish_test

    24   return

    25 }

    26 

    27 do_test fts3ad-1.1 {

    28   execsql {

    29     CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize porter);

    30     INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');

    31     SELECT rowid FROM t1 WHERE content MATCH 'run jump';

    32   }

    33 } {1}

    34 do_test fts3ad-1.2 {

    35   execsql {

    36     SELECT snippet(t1) FROM t1 WHERE t1 MATCH 'run jump';

    37   }

    38 } {{<b>running</b> and <b>jumping</b>}}

    39 do_test fts3ad-1.3 {

    40   execsql {

    41     INSERT INTO t1(rowid, content) 

    42           VALUES(2, 'abcdefghijklmnopqrstuvwyxz');

    43     SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijqrstuvwyxz'

    44   }

    45 } {2 <b>abcdefghijklmnopqrstuvwyxz</b>}

    46 do_test fts3ad-1.4 {

    47   execsql {

    48     SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH 'abcdefghijXXXXqrstuvwyxz'

    49   }

    50 } {2 <b>abcdefghijklmnopqrstuvwyxz</b>}

    51 do_test fts3ad-1.5 {

    52   execsql {

    53     INSERT INTO t1(rowid, content) 

    54           VALUES(3, 'The value is 123456789');

    55     SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123789'

    56   }

    57 } {3 {The value is <b>123456789</b>}}

    58 do_test fts3ad-1.6 {

    59   execsql {

    60     SELECT rowid, snippet(t1) FROM t1 WHERE t1 MATCH '123000000789'

    61   }

    62 } {3 {The value is <b>123456789</b>}}

    63 

    64 

    65 finish_test