forked from gyf304/sqlite3-fts5-html
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtest.sql
78 lines (71 loc) · 2.55 KB
/
test.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
CREATE VIRTUAL TABLE test USING fts5(x, y, tokenize = 'html unicode61 remove_diacritics 1');
INSERT INTO test VALUES('a', '
<html>
<head>
<script>ignored</script></head>
<body>
hello <style>also ignored</style> world "asdf"
abcd
中文
</body>
</html>
');
INSERT INTO test VALUES('b', '
<!doctype html>
<html>
<head>
<title>Example Domain</title>
<meta charset="utf-8" />
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<style type="text/css">
body {
background-color: #f0f0f2;
margin: 0;
padding: 0;
font-family: -apple-system, system-ui, BlinkMacSystemFont, "Segoe UI", "Open Sans", "Helvetica Neue", Helvetica, Arial, sans-serif;
}
div {
width: 600px;
margin: 5em auto;
padding: 2em;
background-color: #fdfdff;
border-radius: 0.5em;
box-shadow: 2px 3px 7px 2px rgba(0,0,0,0.02);
}
a:link, a:visited {
color: #38488f;
text-decoration: none;
}
@media (max-width: 700px) {
div {
margin: 0 auto;
width: auto;
}
}
</style>
</head>
<body>
<div>
<h1>Example Domain</h1>
<p>This domain is for use in illustrative examples in documents. You may use this
domain in literature without prior coordination or asking for permission.</p>
<p><a href="https://www.iana.org/domains/example">More information...</a></p>
</div>
</body>
</html>
');
SELECT count(*) FROM test WHERE test MATCH 'ignored'; -- expected: 0
SELECT count(*) FROM test WHERE test MATCH 'hello'; -- expected: 1
SELECT count(*) FROM test WHERE test MATCH 'hello world'; -- expected: 1
SELECT count(*) FROM test WHERE test MATCH 'abcd'; -- expected: 1
SELECT count(*) FROM test WHERE test MATCH '中文'; -- expected: 1
SELECT count(*) FROM test WHERE test MATCH 'example'; -- expected: 1
SELECT count(*) FROM test WHERE test MATCH 'domain'; -- expected: 1
SELECT count(*) FROM test WHERE test MATCH 'information'; -- expected: 1
SELECT count(*) FROM test WHERE test MATCH 'quot'; -- expected: 0
SELECT count(*) FROM test WHERE test MATCH 'nbsp'; -- expected: 0
SELECT count(*) FROM test WHERE test MATCH 'meta'; -- expected: 0
SELECT count(*) FROM test WHERE test MATCH 'margin'; -- expected: 0
SELECT count(*) FROM test WHERE test MATCH 'viewport'; -- expected: 0
SELECT count(*) FROM test WHERE test match 'Helvetica'; -- expected: 0