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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
<script src="/js/jquery.js" type="text/javascript"></script>
<script src="/js/url-search-params.js" type="text/javascript"></script>
<script src="/js/loadingoverlay.min.js" type="text/javascript"></script>
<script src="/js/require.js" type="text/javascript"></script>
<script src="/js/sql-fts5.js" type="module"></script>
<script language="Javascript">
function escapeHtml( text ) {
return text.replace(/&/g, "&").replace(/</g, "<").replace(/>/g, ">" );
}
function draw_ranklist( query, results ) {
var html = '';
if( results.length == 0 ) {
return "<p>No hits for query '" + query + "'...</p>";
} else {
html += "<p>" + results.length + " hits found</p>";
}
var start = 1;
html += "<ol class=\"ranklist\" start=\"" + start + "\">";
for( var i = 0; i < results.length; i++ ) {
var rank = results[i];
var docid = rank['docid'];
var abstract = rank['abstract'];
var title = rank['title'];
if( title == '' ) {
title = 'No title';
}
html += "<li>";
html += "<div class='title'>"
html += "<a href=\"" + docid + "\">" + title + "</a></div>";
if( abstract != '' ) {
html += "<div class='abstract'>" + abstract + "</div>";
}
html += "</li>";
}
html += "</ol>";
return html;
}
function executeQuery( query ) {
$( "#query" ).LoadingOverlay( "show" );
const xhr = new XMLHttpRequest();
xhr.open('GET', '/index/posts.db', true);
xhr.responseType = 'arraybuffer';
xhr.onload = e => {
const uInt8Array = new Uint8Array(xhr.response);
requirejs(["/js/sql-wasm.js"], function(initSqlJs) {
const SQL = initSqlJs({
locateFile: file => `http://localhost:1313/js/${file}`
});
initSqlJs().then( function( SQL ) {
var db = new SQL.Database(uInt8Array);
const stmt = db.prepare( "select uri as docid,title,snippet(posts, 2, '<b>', '</b>', '...', 50) as abstract from posts where posts MATCH @query ORDER BY bm25(posts)" );
stmt.bind({'@query':query});
var results = [];
while(stmt.step()) {
var row = stmt.getAsObject();
results.push( row );
}
stmt.free();
db.close();
var html = draw_ranklist( query, results );
$( '#ranklist' ).html( html );
$( "#query" ).LoadingOverlay( "hide" );
} );
} );
}
xhr.send( );
}
$( window ).load( function( ) {
var paramsString = window.location.search;
var searchParams = new URLSearchParams( paramsString );
if( searchParams.has( "q" ) ) {
executeQuery( searchParams.get( "q" ) );
} else {
// TODO: come up with something here
} // Show full page LoadingOverlay
} );
</script>
<div id="ranklist">
</div>
|