1 // Copyright (C) 2015 Yasuhiro Matsumoto <mattn.jp@gmail.com>.
3 // Use of this source code is governed by an MIT-style
4 // license that can be found in the LICENSE file.
14 func TestFTS3(t *testing.T) {
15 tempFilename := TempFilename(t)
16 defer os.Remove(tempFilename)
17 db, err := sql.Open("sqlite3", tempFilename)
19 t.Fatal("Failed to open database:", err)
23 _, err = db.Exec("DROP TABLE foo")
24 _, err = db.Exec("CREATE VIRTUAL TABLE foo USING fts3(id INTEGER PRIMARY KEY, value TEXT)")
26 t.Fatal("Failed to create table:", err)
29 _, err = db.Exec("INSERT INTO foo(id, value) VALUES(?, ?)", 1, `今日の 晩御飯は 天麩羅よ`)
31 t.Fatal("Failed to insert value:", err)
34 _, err = db.Exec("INSERT INTO foo(id, value) VALUES(?, ?)", 2, `今日は いい 天気だ`)
36 t.Fatal("Failed to insert value:", err)
39 rows, err := db.Query("SELECT id, value FROM foo WHERE value MATCH '今日* 天*'")
41 t.Fatal("Unable to query foo table:", err)
49 if err := rows.Scan(&id, &value); err != nil {
50 t.Error("Unable to scan results:", err)
54 if id == 1 && value != `今日の 晩御飯は 天麩羅よ` {
55 t.Error("Value for id 1 should be `今日の 晩御飯は 天麩羅よ`, but:", value)
56 } else if id == 2 && value != `今日は いい 天気だ` {
57 t.Error("Value for id 2 should be `今日は いい 天気だ`, but:", value)
61 rows, err = db.Query("SELECT value FROM foo WHERE value MATCH '今日* 天麩羅*'")
63 t.Fatal("Unable to query foo table:", err)
69 t.Fatal("Result should be only one")
72 if err := rows.Scan(&value); err != nil {
73 t.Fatal("Unable to scan results:", err)
76 if value != `今日の 晩御飯は 天麩羅よ` {
77 t.Fatal("Value should be `今日の 晩御飯は 天麩羅よ`, but:", value)
81 t.Fatal("Result should be only one")
85 func TestFTS4(t *testing.T) {
86 tempFilename := TempFilename(t)
87 defer os.Remove(tempFilename)
88 db, err := sql.Open("sqlite3", tempFilename)
90 t.Fatal("Failed to open database:", err)
94 _, err = db.Exec("DROP TABLE foo")
95 _, err = db.Exec("CREATE VIRTUAL TABLE foo USING fts4(tokenize=unicode61, id INTEGER PRIMARY KEY, value TEXT)")
97 case err != nil && err.Error() == "unknown tokenizer: unicode61":
98 t.Skip("FTS4 not supported")
100 t.Fatal("Failed to create table:", err)
103 _, err = db.Exec("INSERT INTO foo(id, value) VALUES(?, ?)", 1, `février`)
105 t.Fatal("Failed to insert value:", err)
108 rows, err := db.Query("SELECT value FROM foo WHERE value MATCH 'fevrier'")
110 t.Fatal("Unable to query foo table:", err)
116 t.Fatal("Result should be only one")
119 if err := rows.Scan(&value); err != nil {
120 t.Fatal("Unable to scan results:", err)
123 if value != `février` {
124 t.Fatal("Value should be `février`, but:", value)
128 t.Fatal("Result should be only one")