apropos-utils.c revision 1.32 1 1.32 abhinav /* $NetBSD: apropos-utils.c,v 1.32 2017/04/27 08:02:24 abhinav Exp $ */
2 1.1 joerg /*-
3 1.1 joerg * Copyright (c) 2011 Abhinav Upadhyay <er.abhinav.upadhyay (at) gmail.com>
4 1.1 joerg * All rights reserved.
5 1.1 joerg *
6 1.1 joerg * This code was developed as part of Google's Summer of Code 2011 program.
7 1.1 joerg *
8 1.1 joerg * Redistribution and use in source and binary forms, with or without
9 1.1 joerg * modification, are permitted provided that the following conditions
10 1.1 joerg * are met:
11 1.1 joerg *
12 1.1 joerg * 1. Redistributions of source code must retain the above copyright
13 1.1 joerg * notice, this list of conditions and the following disclaimer.
14 1.1 joerg * 2. Redistributions in binary form must reproduce the above copyright
15 1.1 joerg * notice, this list of conditions and the following disclaimer in
16 1.1 joerg * the documentation and/or other materials provided with the
17 1.1 joerg * distribution.
18 1.1 joerg *
19 1.1 joerg * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
20 1.1 joerg * ``AS IS'' AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
21 1.1 joerg * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
22 1.1 joerg * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
23 1.1 joerg * COPYRIGHT HOLDERS OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
24 1.1 joerg * INCIDENTAL, SPECIAL, EXEMPLARY OR CONSEQUENTIAL DAMAGES (INCLUDING,
25 1.1 joerg * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
26 1.1 joerg * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED
27 1.1 joerg * AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
28 1.1 joerg * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
29 1.1 joerg * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
30 1.1 joerg * SUCH DAMAGE.
31 1.1 joerg */
32 1.1 joerg
33 1.1 joerg #include <sys/cdefs.h>
34 1.32 abhinav __RCSID("$NetBSD: apropos-utils.c,v 1.32 2017/04/27 08:02:24 abhinav Exp $");
35 1.1 joerg
36 1.7 wiz #include <sys/queue.h>
37 1.1 joerg #include <sys/stat.h>
38 1.1 joerg
39 1.1 joerg #include <assert.h>
40 1.1 joerg #include <ctype.h>
41 1.1 joerg #include <err.h>
42 1.1 joerg #include <math.h>
43 1.1 joerg #include <stdio.h>
44 1.1 joerg #include <stdlib.h>
45 1.1 joerg #include <string.h>
46 1.1 joerg #include <util.h>
47 1.1 joerg #include <zlib.h>
48 1.9 christos #include <term.h>
49 1.30 kamil #include <unistd.h>
50 1.9 christos #undef tab // XXX: manconf.h
51 1.1 joerg
52 1.1 joerg #include "apropos-utils.h"
53 1.7 wiz #include "manconf.h"
54 1.1 joerg
55 1.1 joerg typedef struct orig_callback_data {
56 1.1 joerg void *data;
57 1.1 joerg int (*callback) (void *, const char *, const char *, const char *,
58 1.1 joerg const char *, size_t);
59 1.1 joerg } orig_callback_data;
60 1.1 joerg
61 1.1 joerg typedef struct inverse_document_frequency {
62 1.1 joerg double value;
63 1.1 joerg int status;
64 1.1 joerg } inverse_document_frequency;
65 1.1 joerg
66 1.1 joerg /* weights for individual columns */
67 1.1 joerg static const double col_weights[] = {
68 1.1 joerg 2.0, // NAME
69 1.1 joerg 2.00, // Name-description
70 1.1 joerg 0.55, // DESCRIPTION
71 1.1 joerg 0.10, // LIBRARY
72 1.1 joerg 0.001, //RETURN VALUES
73 1.1 joerg 0.20, //ENVIRONMENT
74 1.1 joerg 0.01, //FILES
75 1.1 joerg 0.001, //EXIT STATUS
76 1.1 joerg 2.00, //DIAGNOSTICS
77 1.1 joerg 0.05, //ERRORS
78 1.1 joerg 0.00, //md5_hash
79 1.1 joerg 1.00 //machine
80 1.1 joerg };
81 1.1 joerg
82 1.1 joerg /*
83 1.1 joerg * lower --
84 1.1 joerg * Converts the string str to lower case
85 1.1 joerg */
86 1.1 joerg char *
87 1.1 joerg lower(char *str)
88 1.1 joerg {
89 1.1 joerg assert(str);
90 1.1 joerg int i = 0;
91 1.1 joerg char c;
92 1.1 joerg while (str[i] != '\0') {
93 1.1 joerg c = tolower((unsigned char) str[i]);
94 1.1 joerg str[i++] = c;
95 1.1 joerg }
96 1.1 joerg return str;
97 1.1 joerg }
98 1.1 joerg
99 1.1 joerg /*
100 1.1 joerg * concat--
101 1.10 christos * Utility function. Concatenates together: dst, a space character and src.
102 1.10 christos * dst + " " + src
103 1.1 joerg */
104 1.1 joerg void
105 1.1 joerg concat(char **dst, const char *src)
106 1.1 joerg {
107 1.1 joerg concat2(dst, src, strlen(src));
108 1.1 joerg }
109 1.1 joerg
110 1.1 joerg void
111 1.1 joerg concat2(char **dst, const char *src, size_t srclen)
112 1.1 joerg {
113 1.27 abhinav size_t totallen, dstlen;
114 1.1 joerg assert(src != NULL);
115 1.1 joerg
116 1.24 christos /*
117 1.24 christos * If destination buffer dst is NULL, then simply
118 1.24 christos * strdup the source buffer
119 1.24 christos */
120 1.1 joerg if (*dst == NULL) {
121 1.27 abhinav *dst = estrndup(src, srclen);
122 1.1 joerg return;
123 1.1 joerg }
124 1.1 joerg
125 1.27 abhinav dstlen = strlen(*dst);
126 1.1 joerg /*
127 1.1 joerg * NUL Byte and separator space
128 1.1 joerg */
129 1.27 abhinav totallen = dstlen + srclen + 2;
130 1.1 joerg
131 1.27 abhinav *dst = erealloc(*dst, totallen);
132 1.1 joerg
133 1.1 joerg /* Append a space at the end of dst */
134 1.27 abhinav (*dst)[dstlen++] = ' ';
135 1.1 joerg
136 1.10 christos /* Now, copy src at the end of dst */
137 1.27 abhinav memcpy(*dst + dstlen, src, srclen);
138 1.28 abhinav (*dst)[dstlen + srclen] = '\0';
139 1.1 joerg }
140 1.1 joerg
141 1.1 joerg void
142 1.1 joerg close_db(sqlite3 *db)
143 1.1 joerg {
144 1.1 joerg sqlite3_close(db);
145 1.1 joerg sqlite3_shutdown();
146 1.1 joerg }
147 1.1 joerg
148 1.1 joerg /*
149 1.1 joerg * create_db --
150 1.1 joerg * Creates the database schema.
151 1.1 joerg */
152 1.1 joerg static int
153 1.1 joerg create_db(sqlite3 *db)
154 1.1 joerg {
155 1.1 joerg const char *sqlstr = NULL;
156 1.1 joerg char *schemasql;
157 1.1 joerg char *errmsg = NULL;
158 1.10 christos
159 1.1 joerg /*------------------------ Create the tables------------------------------*/
160 1.1 joerg
161 1.1 joerg #if NOTYET
162 1.1 joerg sqlite3_exec(db, "PRAGMA journal_mode = WAL", NULL, NULL, NULL);
163 1.1 joerg #else
164 1.1 joerg sqlite3_exec(db, "PRAGMA journal_mode = DELETE", NULL, NULL, NULL);
165 1.1 joerg #endif
166 1.1 joerg
167 1.1 joerg schemasql = sqlite3_mprintf("PRAGMA user_version = %d",
168 1.1 joerg APROPOS_SCHEMA_VERSION);
169 1.1 joerg sqlite3_exec(db, schemasql, NULL, NULL, &errmsg);
170 1.1 joerg if (errmsg != NULL)
171 1.1 joerg goto out;
172 1.1 joerg sqlite3_free(schemasql);
173 1.1 joerg
174 1.24 christos sqlstr =
175 1.24 christos //mandb
176 1.24 christos "CREATE VIRTUAL TABLE mandb USING fts4(section, name, "
177 1.24 christos "name_desc, desc, lib, return_vals, env, files, "
178 1.24 christos "exit_status, diagnostics, errors, md5_hash UNIQUE, machine, "
179 1.32 abhinav #ifndef DEBUG
180 1.32 abhinav "compress=zip, uncompress=unzip, "
181 1.32 abhinav #endif
182 1.32 abhinav "tokenize=porter, notindexed=section, notindexed=md5_hash); "
183 1.24 christos //mandb_meta
184 1.24 christos "CREATE TABLE IF NOT EXISTS mandb_meta(device, inode, mtime, "
185 1.24 christos "file UNIQUE, md5_hash UNIQUE, id INTEGER PRIMARY KEY); "
186 1.24 christos //mandb_links
187 1.31 abhinav "CREATE TABLE IF NOT EXISTS mandb_links(link COLLATE NOCASE, target, section, "
188 1.24 christos "machine, md5_hash); ";
189 1.1 joerg
190 1.1 joerg sqlite3_exec(db, sqlstr, NULL, NULL, &errmsg);
191 1.1 joerg if (errmsg != NULL)
192 1.1 joerg goto out;
193 1.1 joerg
194 1.24 christos sqlstr =
195 1.24 christos "CREATE INDEX IF NOT EXISTS index_mandb_links ON mandb_links "
196 1.24 christos "(link); "
197 1.24 christos "CREATE INDEX IF NOT EXISTS index_mandb_meta_dev ON mandb_meta "
198 1.24 christos "(device, inode); "
199 1.24 christos "CREATE INDEX IF NOT EXISTS index_mandb_links_md5 ON mandb_links "
200 1.24 christos "(md5_hash);";
201 1.1 joerg sqlite3_exec(db, sqlstr, NULL, NULL, &errmsg);
202 1.1 joerg if (errmsg != NULL)
203 1.1 joerg goto out;
204 1.1 joerg return 0;
205 1.1 joerg
206 1.1 joerg out:
207 1.1 joerg warnx("%s", errmsg);
208 1.1 joerg free(errmsg);
209 1.1 joerg sqlite3_close(db);
210 1.1 joerg sqlite3_shutdown();
211 1.1 joerg return -1;
212 1.1 joerg }
213 1.1 joerg
214 1.1 joerg /*
215 1.1 joerg * zip --
216 1.1 joerg * User defined Sqlite function to compress the FTS table
217 1.1 joerg */
218 1.1 joerg static void
219 1.1 joerg zip(sqlite3_context *pctx, int nval, sqlite3_value **apval)
220 1.10 christos {
221 1.1 joerg int nin;
222 1.1 joerg long int nout;
223 1.1 joerg const unsigned char * inbuf;
224 1.1 joerg unsigned char *outbuf;
225 1.1 joerg
226 1.1 joerg assert(nval == 1);
227 1.1 joerg nin = sqlite3_value_bytes(apval[0]);
228 1.1 joerg inbuf = (const unsigned char *) sqlite3_value_blob(apval[0]);
229 1.1 joerg nout = nin + 13 + (nin + 999) / 1000;
230 1.1 joerg outbuf = emalloc(nout);
231 1.1 joerg compress(outbuf, (unsigned long *) &nout, inbuf, nin);
232 1.1 joerg sqlite3_result_blob(pctx, outbuf, nout, free);
233 1.1 joerg }
234 1.1 joerg
235 1.1 joerg /*
236 1.1 joerg * unzip --
237 1.1 joerg * User defined Sqlite function to uncompress the FTS table.
238 1.1 joerg */
239 1.1 joerg static void
240 1.1 joerg unzip(sqlite3_context *pctx, int nval, sqlite3_value **apval)
241 1.1 joerg {
242 1.1 joerg unsigned int rc;
243 1.1 joerg unsigned char *outbuf;
244 1.1 joerg z_stream stream;
245 1.1 joerg
246 1.1 joerg assert(nval == 1);
247 1.1 joerg stream.next_in = __UNCONST(sqlite3_value_blob(apval[0]));
248 1.1 joerg stream.avail_in = sqlite3_value_bytes(apval[0]);
249 1.1 joerg stream.avail_out = stream.avail_in * 2 + 100;
250 1.1 joerg stream.next_out = outbuf = emalloc(stream.avail_out);
251 1.1 joerg stream.zalloc = NULL;
252 1.1 joerg stream.zfree = NULL;
253 1.1 joerg
254 1.1 joerg if (inflateInit(&stream) != Z_OK) {
255 1.1 joerg free(outbuf);
256 1.1 joerg return;
257 1.1 joerg }
258 1.1 joerg
259 1.1 joerg while ((rc = inflate(&stream, Z_SYNC_FLUSH)) != Z_STREAM_END) {
260 1.1 joerg if (rc != Z_OK ||
261 1.1 joerg (stream.avail_out != 0 && stream.avail_in == 0)) {
262 1.1 joerg free(outbuf);
263 1.1 joerg return;
264 1.1 joerg }
265 1.1 joerg outbuf = erealloc(outbuf, stream.total_out * 2);
266 1.1 joerg stream.next_out = outbuf + stream.total_out;
267 1.1 joerg stream.avail_out = stream.total_out;
268 1.1 joerg }
269 1.1 joerg if (inflateEnd(&stream) != Z_OK) {
270 1.1 joerg free(outbuf);
271 1.1 joerg return;
272 1.1 joerg }
273 1.1 joerg outbuf = erealloc(outbuf, stream.total_out);
274 1.24 christos sqlite3_result_text(pctx, (const char *)outbuf, stream.total_out, free);
275 1.1 joerg }
276 1.1 joerg
277 1.7 wiz /*
278 1.7 wiz * get_dbpath --
279 1.7 wiz * Read the path of the database from man.conf and return.
280 1.7 wiz */
281 1.7 wiz char *
282 1.7 wiz get_dbpath(const char *manconf)
283 1.7 wiz {
284 1.7 wiz TAG *tp;
285 1.7 wiz char *dbpath;
286 1.7 wiz
287 1.7 wiz config(manconf);
288 1.7 wiz tp = gettag("_mandb", 1);
289 1.7 wiz if (!tp)
290 1.7 wiz return NULL;
291 1.10 christos
292 1.7 wiz if (TAILQ_EMPTY(&tp->entrylist))
293 1.7 wiz return NULL;
294 1.7 wiz
295 1.7 wiz dbpath = TAILQ_LAST(&tp->entrylist, tqh)->s;
296 1.7 wiz return dbpath;
297 1.7 wiz }
298 1.7 wiz
299 1.1 joerg /* init_db --
300 1.1 joerg * Prepare the database. Register the compress/uncompress functions and the
301 1.1 joerg * stopword tokenizer.
302 1.10 christos * db_flag specifies the mode in which to open the database. 3 options are
303 1.1 joerg * available:
304 1.1 joerg * 1. DB_READONLY: Open in READONLY mode. An error if db does not exist.
305 1.1 joerg * 2. DB_READWRITE: Open in read-write mode. An error if db does not exist.
306 1.1 joerg * 3. DB_CREATE: Open in read-write mode. It will try to create the db if
307 1.1 joerg * it does not exist already.
308 1.1 joerg * RETURN VALUES:
309 1.24 christos * The function will return NULL in case the db does not exist
310 1.24 christos * and DB_CREATE
311 1.10 christos * was not specified. And in case DB_CREATE was specified and yet NULL is
312 1.1 joerg * returned, then there was some other error.
313 1.1 joerg * In normal cases the function should return a handle to the db.
314 1.1 joerg */
315 1.1 joerg sqlite3 *
316 1.23 christos init_db(mandb_access_mode db_flag, const char *manconf)
317 1.1 joerg {
318 1.1 joerg sqlite3 *db = NULL;
319 1.1 joerg sqlite3_stmt *stmt;
320 1.1 joerg struct stat sb;
321 1.1 joerg int rc;
322 1.1 joerg int create_db_flag = 0;
323 1.1 joerg
324 1.7 wiz char *dbpath = get_dbpath(manconf);
325 1.7 wiz if (dbpath == NULL)
326 1.7 wiz errx(EXIT_FAILURE, "_mandb entry not found in man.conf");
327 1.23 christos
328 1.7 wiz if (!(stat(dbpath, &sb) == 0 && S_ISREG(sb.st_mode))) {
329 1.23 christos /* Database does not exist, check if DB_CREATE was specified,
330 1.23 christos * and set flag to create the database schema
331 1.1 joerg */
332 1.1 joerg if (db_flag != (MANDB_CREATE)) {
333 1.1 joerg warnx("Missing apropos database. "
334 1.1 joerg "Please run makemandb to create it.");
335 1.1 joerg return NULL;
336 1.1 joerg }
337 1.1 joerg create_db_flag = 1;
338 1.23 christos } else {
339 1.23 christos /*
340 1.23 christos * Database exists. Check if we have the permissions
341 1.23 christos * to read/write the files
342 1.23 christos */
343 1.23 christos int access_mode = R_OK;
344 1.25 christos switch (db_flag) {
345 1.23 christos case MANDB_CREATE:
346 1.23 christos case MANDB_WRITE:
347 1.23 christos access_mode |= W_OK;
348 1.23 christos break;
349 1.23 christos default:
350 1.23 christos break;
351 1.23 christos }
352 1.23 christos if ((access(dbpath, access_mode)) != 0) {
353 1.23 christos warnx("Unable to access the database, please check"
354 1.23 christos " permissions for `%s'", dbpath);
355 1.23 christos return NULL;
356 1.23 christos }
357 1.1 joerg }
358 1.1 joerg
359 1.1 joerg sqlite3_initialize();
360 1.7 wiz rc = sqlite3_open_v2(dbpath, &db, db_flag, NULL);
361 1.10 christos
362 1.1 joerg if (rc != SQLITE_OK) {
363 1.1 joerg warnx("%s", sqlite3_errmsg(db));
364 1.23 christos goto error;
365 1.1 joerg }
366 1.1 joerg
367 1.1 joerg if (create_db_flag && create_db(db) < 0) {
368 1.1 joerg warnx("%s", "Unable to create database schema");
369 1.1 joerg goto error;
370 1.1 joerg }
371 1.1 joerg
372 1.1 joerg rc = sqlite3_prepare_v2(db, "PRAGMA user_version", -1, &stmt, NULL);
373 1.1 joerg if (rc != SQLITE_OK) {
374 1.3 apb warnx("Unable to query schema version: %s",
375 1.3 apb sqlite3_errmsg(db));
376 1.1 joerg goto error;
377 1.1 joerg }
378 1.1 joerg if (sqlite3_step(stmt) != SQLITE_ROW) {
379 1.1 joerg sqlite3_finalize(stmt);
380 1.3 apb warnx("Unable to query schema version: %s",
381 1.3 apb sqlite3_errmsg(db));
382 1.1 joerg goto error;
383 1.1 joerg }
384 1.1 joerg if (sqlite3_column_int(stmt, 0) != APROPOS_SCHEMA_VERSION) {
385 1.1 joerg sqlite3_finalize(stmt);
386 1.1 joerg warnx("Incorrect schema version found. "
387 1.1 joerg "Please run makemandb -f.");
388 1.1 joerg goto error;
389 1.1 joerg }
390 1.1 joerg sqlite3_finalize(stmt);
391 1.1 joerg
392 1.1 joerg sqlite3_extended_result_codes(db, 1);
393 1.10 christos
394 1.1 joerg /* Register the zip and unzip functions for FTS compression */
395 1.24 christos rc = sqlite3_create_function(db, "zip", 1, SQLITE_ANY, NULL, zip,
396 1.24 christos NULL, NULL);
397 1.1 joerg if (rc != SQLITE_OK) {
398 1.3 apb warnx("Unable to register function: compress: %s",
399 1.3 apb sqlite3_errmsg(db));
400 1.1 joerg goto error;
401 1.1 joerg }
402 1.1 joerg
403 1.10 christos rc = sqlite3_create_function(db, "unzip", 1, SQLITE_ANY, NULL,
404 1.1 joerg unzip, NULL, NULL);
405 1.1 joerg if (rc != SQLITE_OK) {
406 1.3 apb warnx("Unable to register function: uncompress: %s",
407 1.3 apb sqlite3_errmsg(db));
408 1.1 joerg goto error;
409 1.1 joerg }
410 1.1 joerg return db;
411 1.7 wiz
412 1.1 joerg error:
413 1.23 christos close_db(db);
414 1.1 joerg return NULL;
415 1.1 joerg }
416 1.1 joerg
417 1.1 joerg /*
418 1.1 joerg * rank_func --
419 1.1 joerg * Sqlite user defined function for ranking the documents.
420 1.1 joerg * For each phrase of the query, it computes the tf and idf and adds them over.
421 1.1 joerg * It computes the final rank, by multiplying tf and idf together.
422 1.10 christos * Weight of term t for document d = (term frequency of t in d *
423 1.10 christos * inverse document frequency of t)
424 1.1 joerg *
425 1.10 christos * Term Frequency of term t in document d = Number of times t occurs in d /
426 1.24 christos * Number of times t appears in all documents
427 1.1 joerg *
428 1.10 christos * Inverse document frequency of t = log(Total number of documents /
429 1.1 joerg * Number of documents in which t occurs)
430 1.1 joerg */
431 1.1 joerg static void
432 1.1 joerg rank_func(sqlite3_context *pctx, int nval, sqlite3_value **apval)
433 1.1 joerg {
434 1.1 joerg inverse_document_frequency *idf = sqlite3_user_data(pctx);
435 1.1 joerg double tf = 0.0;
436 1.1 joerg const unsigned int *matchinfo;
437 1.1 joerg int ncol;
438 1.1 joerg int nphrase;
439 1.1 joerg int iphrase;
440 1.1 joerg int ndoc;
441 1.1 joerg int doclen = 0;
442 1.1 joerg const double k = 3.75;
443 1.24 christos /*
444 1.24 christos * Check that the number of arguments passed to this
445 1.24 christos * function is correct.
446 1.24 christos */
447 1.1 joerg assert(nval == 1);
448 1.1 joerg
449 1.1 joerg matchinfo = (const unsigned int *) sqlite3_value_blob(apval[0]);
450 1.1 joerg nphrase = matchinfo[0];
451 1.1 joerg ncol = matchinfo[1];
452 1.1 joerg ndoc = matchinfo[2 + 3 * ncol * nphrase + ncol];
453 1.1 joerg for (iphrase = 0; iphrase < nphrase; iphrase++) {
454 1.1 joerg int icol;
455 1.24 christos const unsigned int *phraseinfo =
456 1.24 christos &matchinfo[2 + ncol + iphrase * ncol * 3];
457 1.1 joerg for(icol = 1; icol < ncol; icol++) {
458 1.10 christos
459 1.24 christos /* nhitcount: number of times the current phrase occurs
460 1.24 christos * in the current column in the current document.
461 1.24 christos * nglobalhitcount: number of times current phrase
462 1.24 christos * occurs in the current column in all documents.
463 1.24 christos * ndocshitcount: number of documents in which the
464 1.24 christos * current phrase occurs in the current column at
465 1.24 christos * least once.
466 1.1 joerg */
467 1.1 joerg int nhitcount = phraseinfo[3 * icol];
468 1.1 joerg int nglobalhitcount = phraseinfo[3 * icol + 1];
469 1.1 joerg int ndocshitcount = phraseinfo[3 * icol + 2];
470 1.1 joerg doclen = matchinfo[2 + icol ];
471 1.1 joerg double weight = col_weights[icol - 1];
472 1.1 joerg if (idf->status == 0 && ndocshitcount)
473 1.24 christos idf->value +=
474 1.24 christos log(((double)ndoc / ndocshitcount))* weight;
475 1.1 joerg
476 1.24 christos /*
477 1.24 christos * Dividing the tf by document length to normalize
478 1.24 christos * the effect of longer documents.
479 1.1 joerg */
480 1.1 joerg if (nglobalhitcount > 0 && nhitcount)
481 1.24 christos tf += (((double)nhitcount * weight)
482 1.24 christos / (nglobalhitcount * doclen));
483 1.1 joerg }
484 1.1 joerg }
485 1.1 joerg idf->status = 1;
486 1.10 christos
487 1.24 christos /*
488 1.24 christos * Final score: Dividing by k + tf further normalizes the weight
489 1.24 christos * leading to better results. The value of k is experimental
490 1.1 joerg */
491 1.24 christos double score = (tf * idf->value) / (k + tf);
492 1.1 joerg sqlite3_result_double(pctx, score);
493 1.1 joerg return;
494 1.1 joerg }
495 1.1 joerg
496 1.1 joerg /*
497 1.26 abhinav * generates sql query for matching the user entered query
498 1.1 joerg */
499 1.26 abhinav static char *
500 1.26 abhinav generate_search_query(query_args *args, const char *snippet_args[3])
501 1.1 joerg {
502 1.1 joerg const char *default_snippet_args[3];
503 1.1 joerg char *section_clause = NULL;
504 1.1 joerg char *limit_clause = NULL;
505 1.1 joerg char *machine_clause = NULL;
506 1.1 joerg char *query;
507 1.1 joerg
508 1.1 joerg if (args->machine)
509 1.31 abhinav easprintf(&machine_clause, "AND mandb.machine = \'%s\' ",
510 1.24 christos args->machine);
511 1.1 joerg
512 1.10 christos
513 1.1 joerg /* We want to build a query of the form: "select x,y,z from mandb where
514 1.1 joerg * mandb match :query [AND (section LIKE '1' OR section LIKE '2' OR...)]
515 1.1 joerg * ORDER BY rank DESC..."
516 1.24 christos * NOTES:
517 1.24 christos * 1. The portion in square brackets is optional, it will be there
518 1.24 christos * only if the user has specified an option on the command line
519 1.24 christos * to search in one or more specific sections.
520 1.1 joerg */
521 1.24 christos char *sections_str = args->sec_nums;
522 1.24 christos char *temp;
523 1.24 christos if (sections_str) {
524 1.24 christos while (*sections_str) {
525 1.24 christos size_t len = strcspn(sections_str, " ");
526 1.24 christos char *sec = sections_str;
527 1.24 christos if (sections_str[len] == 0) {
528 1.24 christos sections_str += len;
529 1.24 christos } else {
530 1.24 christos sections_str[len] = 0;
531 1.24 christos sections_str += len + 1;
532 1.24 christos }
533 1.24 christos easprintf(&temp, "\'%s\',", sec);
534 1.1 joerg
535 1.1 joerg if (section_clause) {
536 1.1 joerg concat(§ion_clause, temp);
537 1.1 joerg free(temp);
538 1.1 joerg } else {
539 1.1 joerg section_clause = temp;
540 1.1 joerg }
541 1.1 joerg }
542 1.1 joerg if (section_clause) {
543 1.1 joerg /*
544 1.1 joerg * At least one section requested, add glue for query.
545 1.24 christos * Before doing that, remove the comma at the end of
546 1.24 christos * section_clause
547 1.1 joerg */
548 1.24 christos size_t section_clause_len = strlen(section_clause);
549 1.24 christos if (section_clause[section_clause_len - 1] == ',')
550 1.24 christos section_clause[section_clause_len - 1] = 0;
551 1.1 joerg temp = section_clause;
552 1.31 abhinav easprintf(§ion_clause, " AND mandb.section IN (%s)", temp);
553 1.1 joerg free(temp);
554 1.1 joerg }
555 1.1 joerg }
556 1.26 abhinav
557 1.1 joerg if (args->nrec >= 0) {
558 1.1 joerg /* Use the provided number of records and offset */
559 1.1 joerg easprintf(&limit_clause, " LIMIT %d OFFSET %d",
560 1.1 joerg args->nrec, args->offset);
561 1.1 joerg }
562 1.1 joerg
563 1.1 joerg if (snippet_args == NULL) {
564 1.1 joerg default_snippet_args[0] = "";
565 1.1 joerg default_snippet_args[1] = "";
566 1.1 joerg default_snippet_args[2] = "...";
567 1.1 joerg snippet_args = default_snippet_args;
568 1.1 joerg }
569 1.26 abhinav
570 1.12 christos if (args->legacy) {
571 1.13 christos char *wild;
572 1.13 christos easprintf(&wild, "%%%s%%", args->search_str);
573 1.26 abhinav query = sqlite3_mprintf("SELECT section, name, name_desc, machine"
574 1.12 christos " FROM mandb"
575 1.13 christos " WHERE name LIKE %Q OR name_desc LIKE %Q "
576 1.12 christos "%s"
577 1.12 christos "%s",
578 1.20 christos wild, wild,
579 1.12 christos section_clause ? section_clause : "",
580 1.12 christos limit_clause ? limit_clause : "");
581 1.13 christos free(wild);
582 1.31 abhinav } else if (strchr(args->search_str, ' ') == NULL) {
583 1.31 abhinav /*
584 1.31 abhinav * If it's a single word query, we want to search in the
585 1.31 abhinav * links table as well. If the link table contains an entry
586 1.31 abhinav * for the queried keyword, we want to use that as the name of
587 1.31 abhinav * the man page.
588 1.31 abhinav * For example, for `apropos realloc` the output should be
589 1.31 abhinav * realloc(3) and not malloc(3).
590 1.31 abhinav */
591 1.31 abhinav query = sqlite3_mprintf(
592 1.31 abhinav "SELECT section, name, name_desc, machine,"
593 1.31 abhinav " snippet(mandb, %Q, %Q, %Q, -1, 40 ),"
594 1.31 abhinav " rank_func(matchinfo(mandb, \"pclxn\")) AS rank"
595 1.31 abhinav " FROM mandb WHERE name NOT IN ("
596 1.31 abhinav " SELECT target FROM mandb_links WHERE link=%Q AND"
597 1.31 abhinav " mandb_links.section=mandb.section) AND mandb MATCH %Q %s %s"
598 1.31 abhinav " UNION"
599 1.31 abhinav " SELECT mandb.section, mandb_links.link AS name, mandb.name_desc,"
600 1.31 abhinav " mandb.machine, '' AS snippet, 100.00 AS rank"
601 1.31 abhinav " FROM mandb JOIN mandb_links ON mandb.name=mandb_links.target and"
602 1.31 abhinav " mandb.section=mandb_links.section WHERE mandb_links.link=%Q"
603 1.31 abhinav " %s %s"
604 1.31 abhinav " ORDER BY rank DESC %s",
605 1.31 abhinav snippet_args[0], snippet_args[1], snippet_args[2],
606 1.31 abhinav args->search_str, args->search_str, section_clause ? section_clause : "",
607 1.31 abhinav machine_clause ? machine_clause : "", args->search_str,
608 1.31 abhinav machine_clause ? machine_clause : "",
609 1.31 abhinav section_clause ? section_clause : "",
610 1.31 abhinav limit_clause ? limit_clause : "");
611 1.12 christos } else {
612 1.12 christos query = sqlite3_mprintf("SELECT section, name, name_desc, machine,"
613 1.12 christos " snippet(mandb, %Q, %Q, %Q, -1, 40 ),"
614 1.12 christos " rank_func(matchinfo(mandb, \"pclxn\")) AS rank"
615 1.12 christos " FROM mandb"
616 1.12 christos " WHERE mandb MATCH %Q %s "
617 1.12 christos "%s"
618 1.12 christos " ORDER BY rank DESC"
619 1.12 christos "%s",
620 1.12 christos snippet_args[0], snippet_args[1], snippet_args[2],
621 1.12 christos args->search_str, machine_clause ? machine_clause : "",
622 1.12 christos section_clause ? section_clause : "",
623 1.12 christos limit_clause ? limit_clause : "");
624 1.12 christos }
625 1.1 joerg
626 1.1 joerg free(machine_clause);
627 1.1 joerg free(section_clause);
628 1.1 joerg free(limit_clause);
629 1.26 abhinav return query;
630 1.26 abhinav }
631 1.26 abhinav
632 1.26 abhinav /*
633 1.26 abhinav * Execute the full text search query and return the number of results
634 1.26 abhinav * obtained.
635 1.26 abhinav */
636 1.26 abhinav static unsigned int
637 1.26 abhinav execute_search_query(sqlite3 *db, char *query, query_args *args)
638 1.26 abhinav {
639 1.26 abhinav sqlite3_stmt *stmt;
640 1.26 abhinav const char *section;
641 1.26 abhinav char *name;
642 1.26 abhinav char *slash_ptr;
643 1.26 abhinav const char *name_desc;
644 1.26 abhinav const char *machine;
645 1.26 abhinav const char *snippet = "";
646 1.26 abhinav const char *name_temp;
647 1.26 abhinav char *m = NULL;
648 1.26 abhinav int rc;
649 1.26 abhinav inverse_document_frequency idf = {0, 0};
650 1.1 joerg
651 1.26 abhinav if (!args->legacy) {
652 1.26 abhinav /* Register the rank function */
653 1.26 abhinav rc = sqlite3_create_function(db, "rank_func", 1, SQLITE_ANY,
654 1.26 abhinav (void *) &idf, rank_func, NULL, NULL);
655 1.26 abhinav if (rc != SQLITE_OK) {
656 1.26 abhinav warnx("Unable to register the ranking function: %s",
657 1.26 abhinav sqlite3_errmsg(db));
658 1.26 abhinav sqlite3_close(db);
659 1.26 abhinav sqlite3_shutdown();
660 1.26 abhinav exit(EXIT_FAILURE);
661 1.26 abhinav }
662 1.1 joerg }
663 1.26 abhinav
664 1.1 joerg rc = sqlite3_prepare_v2(db, query, -1, &stmt, NULL);
665 1.1 joerg if (rc == SQLITE_IOERR) {
666 1.1 joerg warnx("Corrupt database. Please rerun makemandb");
667 1.1 joerg return -1;
668 1.1 joerg } else if (rc != SQLITE_OK) {
669 1.1 joerg warnx("%s", sqlite3_errmsg(db));
670 1.1 joerg return -1;
671 1.1 joerg }
672 1.1 joerg
673 1.26 abhinav unsigned int nresults = 0;
674 1.1 joerg while (sqlite3_step(stmt) == SQLITE_ROW) {
675 1.26 abhinav nresults++;
676 1.1 joerg section = (const char *) sqlite3_column_text(stmt, 0);
677 1.4 wiz name_temp = (const char *) sqlite3_column_text(stmt, 1);
678 1.1 joerg name_desc = (const char *) sqlite3_column_text(stmt, 2);
679 1.1 joerg machine = (const char *) sqlite3_column_text(stmt, 3);
680 1.26 abhinav if (!args->legacy)
681 1.26 abhinav snippet = (const char *) sqlite3_column_text(stmt, 4);
682 1.4 wiz if ((slash_ptr = strrchr(name_temp, '/')) != NULL)
683 1.4 wiz name_temp = slash_ptr + 1;
684 1.1 joerg if (machine && machine[0]) {
685 1.1 joerg m = estrdup(machine);
686 1.24 christos easprintf(&name, "%s/%s", lower(m), name_temp);
687 1.1 joerg free(m);
688 1.1 joerg } else {
689 1.24 christos name = estrdup((const char *)
690 1.24 christos sqlite3_column_text(stmt, 1));
691 1.1 joerg }
692 1.1 joerg
693 1.24 christos (args->callback)(args->callback_data, section, name,
694 1.26 abhinav name_desc, snippet, args->legacy? 0: strlen(snippet));
695 1.26 abhinav free(name);
696 1.26 abhinav }
697 1.26 abhinav sqlite3_finalize(stmt);
698 1.26 abhinav return nresults;
699 1.26 abhinav }
700 1.1 joerg
701 1.26 abhinav
702 1.26 abhinav /*
703 1.26 abhinav * run_query_internal --
704 1.26 abhinav * Performs the searches for the keywords entered by the user.
705 1.26 abhinav * The 2nd param: snippet_args is an array of strings providing values for the
706 1.26 abhinav * last three parameters to the snippet function of sqlite. (Look at the docs).
707 1.26 abhinav * The 3rd param: args contains rest of the search parameters. Look at
708 1.26 abhinav * arpopos-utils.h for the description of individual fields.
709 1.26 abhinav *
710 1.26 abhinav */
711 1.26 abhinav static int
712 1.26 abhinav run_query_internal(sqlite3 *db, const char *snippet_args[3], query_args *args)
713 1.26 abhinav {
714 1.26 abhinav char *query;
715 1.26 abhinav query = generate_search_query(args, snippet_args);
716 1.26 abhinav if (query == NULL) {
717 1.26 abhinav *args->errmsg = estrdup("malloc failed");
718 1.26 abhinav return -1;
719 1.1 joerg }
720 1.1 joerg
721 1.26 abhinav execute_search_query(db, query, args);
722 1.1 joerg sqlite3_free(query);
723 1.1 joerg return *(args->errmsg) == NULL ? 0 : -1;
724 1.1 joerg }
725 1.1 joerg
726 1.21 christos static char *
727 1.21 christos get_escaped_html_string(const char *src, size_t *slen)
728 1.1 joerg {
729 1.21 christos static const char trouble[] = "<>\"&\002\003";
730 1.21 christos /*
731 1.21 christos * First scan the src to find out the number of occurrences
732 1.21 christos * of {'>', '<' '"', '&'}. Then allocate a new buffer with
733 1.21 christos * sufficient space to be able to store the quoted versions
734 1.21 christos * of the special characters {>, <, ", &}.
735 1.21 christos * Copy over the characters from the original src into
736 1.21 christos * this buffer while replacing the special characters with
737 1.21 christos * their quoted versions.
738 1.21 christos */
739 1.21 christos char *dst, *ddst;
740 1.21 christos size_t count;
741 1.21 christos const char *ssrc;
742 1.21 christos
743 1.21 christos for (count = 0, ssrc = src; *src; count++) {
744 1.21 christos size_t sz = strcspn(src, trouble);
745 1.21 christos src += sz + 1;
746 1.21 christos }
747 1.1 joerg
748 1.1 joerg
749 1.24 christos #define append(a) \
750 1.24 christos do { \
751 1.24 christos memcpy(dst, (a), sizeof(a) - 1); \
752 1.24 christos dst += sizeof(a) - 1; \
753 1.24 christos } while (/*CONSTCOND*/0)
754 1.24 christos
755 1.1 joerg
756 1.21 christos ddst = dst = emalloc(*slen + count * 5 + 1);
757 1.21 christos for (src = ssrc; *src; src++) {
758 1.21 christos switch (*src) {
759 1.1 joerg case '<':
760 1.21 christos append("<");
761 1.1 joerg break;
762 1.1 joerg case '>':
763 1.21 christos append(">");
764 1.1 joerg break;
765 1.1 joerg case '\"':
766 1.21 christos append(""");
767 1.1 joerg break;
768 1.1 joerg case '&':
769 1.21 christos /*
770 1.21 christos * Don't perform the quoting if this & is part of
771 1.21 christos * an mdoc escape sequence, e.g. \&
772 1.1 joerg */
773 1.21 christos if (src != ssrc && src[-1] != '\\')
774 1.21 christos append("&");
775 1.21 christos else
776 1.21 christos append("&");
777 1.1 joerg break;
778 1.1 joerg case '\002':
779 1.21 christos append("<b>");
780 1.1 joerg break;
781 1.1 joerg case '\003':
782 1.21 christos append("</b>");
783 1.1 joerg break;
784 1.1 joerg default:
785 1.21 christos *dst++ = *src;
786 1.1 joerg break;
787 1.1 joerg }
788 1.1 joerg }
789 1.21 christos *dst = '\0';
790 1.21 christos *slen = dst - ddst;
791 1.21 christos return ddst;
792 1.21 christos }
793 1.21 christos
794 1.21 christos
795 1.21 christos /*
796 1.21 christos * callback_html --
797 1.21 christos * Callback function for run_query_html. It builds the html output and then
798 1.21 christos * calls the actual user supplied callback function.
799 1.21 christos */
800 1.21 christos static int
801 1.21 christos callback_html(void *data, const char *section, const char *name,
802 1.21 christos const char *name_desc, const char *snippet, size_t snippet_length)
803 1.21 christos {
804 1.21 christos struct orig_callback_data *orig_data = data;
805 1.21 christos int (*callback)(void *, const char *, const char *, const char *,
806 1.21 christos const char *, size_t) = orig_data->callback;
807 1.21 christos size_t length = snippet_length;
808 1.21 christos size_t name_description_length = strlen(name_desc);
809 1.21 christos char *qsnippet = get_escaped_html_string(snippet, &length);
810 1.21 christos char *qname_description = get_escaped_html_string(name_desc,
811 1.21 christos &name_description_length);
812 1.21 christos
813 1.21 christos (*callback)(orig_data->data, section, name, qname_description,
814 1.21 christos qsnippet, length);
815 1.1 joerg free(qsnippet);
816 1.21 christos free(qname_description);
817 1.1 joerg return 0;
818 1.1 joerg }
819 1.1 joerg
820 1.1 joerg /*
821 1.1 joerg * run_query_html --
822 1.1 joerg * Utility function to output query result in HTML format.
823 1.17 snj * It internally calls run_query only, but it first passes the output to its
824 1.1 joerg * own custom callback function, which preprocess the snippet for quoting
825 1.1 joerg * inline HTML fragments.
826 1.1 joerg * After that it delegates the call the actual user supplied callback function.
827 1.1 joerg */
828 1.15 christos static int
829 1.1 joerg run_query_html(sqlite3 *db, query_args *args)
830 1.1 joerg {
831 1.1 joerg struct orig_callback_data orig_data;
832 1.1 joerg orig_data.callback = args->callback;
833 1.1 joerg orig_data.data = args->callback_data;
834 1.1 joerg const char *snippet_args[] = {"\002", "\003", "..."};
835 1.1 joerg args->callback = &callback_html;
836 1.1 joerg args->callback_data = (void *) &orig_data;
837 1.15 christos return run_query_internal(db, snippet_args, args);
838 1.1 joerg }
839 1.1 joerg
840 1.1 joerg /*
841 1.9 christos * underline a string, pager style.
842 1.9 christos */
843 1.9 christos static char *
844 1.14 christos ul_pager(int ul, const char *s)
845 1.9 christos {
846 1.9 christos size_t len;
847 1.9 christos char *dst, *d;
848 1.9 christos
849 1.14 christos if (!ul)
850 1.14 christos return estrdup(s);
851 1.14 christos
852 1.9 christos // a -> _\ba
853 1.9 christos len = strlen(s) * 3 + 1;
854 1.9 christos
855 1.9 christos d = dst = emalloc(len);
856 1.9 christos while (*s) {
857 1.9 christos *d++ = '_';
858 1.9 christos *d++ = '\b';
859 1.9 christos *d++ = *s++;
860 1.9 christos }
861 1.9 christos *d = '\0';
862 1.9 christos return dst;
863 1.9 christos }
864 1.9 christos
865 1.9 christos /*
866 1.1 joerg * callback_pager --
867 1.1 joerg * A callback similar to callback_html. It overstrikes the matching text in
868 1.1 joerg * the snippet so that it appears emboldened when viewed using a pager like
869 1.1 joerg * more or less.
870 1.1 joerg */
871 1.1 joerg static int
872 1.10 christos callback_pager(void *data, const char *section, const char *name,
873 1.1 joerg const char *name_desc, const char *snippet, size_t snippet_length)
874 1.1 joerg {
875 1.24 christos struct orig_callback_data *orig_data = data;
876 1.1 joerg char *psnippet;
877 1.1 joerg const char *temp = snippet;
878 1.1 joerg int count = 0;
879 1.14 christos int i = 0, did;
880 1.1 joerg size_t sz = 0;
881 1.1 joerg size_t psnippet_length;
882 1.1 joerg
883 1.24 christos /* Count the number of bytes of matching text. For each of these
884 1.24 christos * bytes we will use 2 extra bytes to overstrike it so that it
885 1.24 christos * appears bold when viewed using a pager.
886 1.1 joerg */
887 1.1 joerg while (*temp) {
888 1.1 joerg sz = strcspn(temp, "\002\003");
889 1.1 joerg temp += sz;
890 1.1 joerg if (*temp == '\003') {
891 1.1 joerg count += 2 * (sz);
892 1.1 joerg }
893 1.1 joerg temp++;
894 1.1 joerg }
895 1.1 joerg
896 1.1 joerg psnippet_length = snippet_length + count;
897 1.1 joerg psnippet = emalloc(psnippet_length + 1);
898 1.1 joerg
899 1.1 joerg /* Copy the bytes from snippet to psnippet:
900 1.1 joerg * 1. Copy the bytes before \002 as it is.
901 1.24 christos * 2. The bytes after \002 need to be overstriked till we
902 1.24 christos * encounter \003.
903 1.1 joerg * 3. To overstrike a byte 'A' we need to write 'A\bA'
904 1.1 joerg */
905 1.14 christos did = 0;
906 1.1 joerg while (*snippet) {
907 1.1 joerg sz = strcspn(snippet, "\002");
908 1.1 joerg memcpy(&psnippet[i], snippet, sz);
909 1.1 joerg snippet += sz;
910 1.1 joerg i += sz;
911 1.1 joerg
912 1.1 joerg /* Don't change this. Advancing the pointer without reading the byte
913 1.1 joerg * is causing strange behavior.
914 1.1 joerg */
915 1.1 joerg if (*snippet == '\002')
916 1.1 joerg snippet++;
917 1.1 joerg while (*snippet && *snippet != '\003') {
918 1.14 christos did = 1;
919 1.1 joerg psnippet[i++] = *snippet;
920 1.1 joerg psnippet[i++] = '\b';
921 1.1 joerg psnippet[i++] = *snippet++;
922 1.1 joerg }
923 1.1 joerg if (*snippet)
924 1.1 joerg snippet++;
925 1.1 joerg }
926 1.1 joerg
927 1.1 joerg psnippet[i] = 0;
928 1.14 christos char *ul_section = ul_pager(did, section);
929 1.14 christos char *ul_name = ul_pager(did, name);
930 1.14 christos char *ul_name_desc = ul_pager(did, name_desc);
931 1.9 christos (orig_data->callback)(orig_data->data, ul_section, ul_name,
932 1.9 christos ul_name_desc, psnippet, psnippet_length);
933 1.9 christos free(ul_section);
934 1.9 christos free(ul_name);
935 1.9 christos free(ul_name_desc);
936 1.1 joerg free(psnippet);
937 1.1 joerg return 0;
938 1.1 joerg }
939 1.1 joerg
940 1.9 christos struct term_args {
941 1.9 christos struct orig_callback_data *orig_data;
942 1.9 christos const char *smul;
943 1.9 christos const char *rmul;
944 1.9 christos };
945 1.9 christos
946 1.9 christos /*
947 1.9 christos * underline a string, pager style.
948 1.9 christos */
949 1.9 christos static char *
950 1.9 christos ul_term(const char *s, const struct term_args *ta)
951 1.9 christos {
952 1.9 christos char *dst;
953 1.9 christos
954 1.9 christos easprintf(&dst, "%s%s%s", ta->smul, s, ta->rmul);
955 1.9 christos return dst;
956 1.9 christos }
957 1.9 christos
958 1.9 christos /*
959 1.9 christos * callback_term --
960 1.9 christos * A callback similar to callback_html. It overstrikes the matching text in
961 1.9 christos * the snippet so that it appears emboldened when viewed using a pager like
962 1.9 christos * more or less.
963 1.9 christos */
964 1.9 christos static int
965 1.10 christos callback_term(void *data, const char *section, const char *name,
966 1.9 christos const char *name_desc, const char *snippet, size_t snippet_length)
967 1.9 christos {
968 1.9 christos struct term_args *ta = data;
969 1.9 christos struct orig_callback_data *orig_data = ta->orig_data;
970 1.9 christos
971 1.9 christos char *ul_section = ul_term(section, ta);
972 1.9 christos char *ul_name = ul_term(name, ta);
973 1.9 christos char *ul_name_desc = ul_term(name_desc, ta);
974 1.9 christos (orig_data->callback)(orig_data->data, ul_section, ul_name,
975 1.9 christos ul_name_desc, snippet, snippet_length);
976 1.9 christos free(ul_section);
977 1.9 christos free(ul_name);
978 1.9 christos free(ul_name_desc);
979 1.9 christos return 0;
980 1.9 christos }
981 1.9 christos
982 1.1 joerg /*
983 1.1 joerg * run_query_pager --
984 1.1 joerg * Utility function similar to run_query_html. This function tries to
985 1.1 joerg * pre-process the result assuming it will be piped to a pager.
986 1.17 snj * For this purpose it first calls its own callback function callback_pager
987 1.1 joerg * which then delegates the call to the user supplied callback.
988 1.1 joerg */
989 1.15 christos static int
990 1.6 joerg run_query_pager(sqlite3 *db, query_args *args)
991 1.1 joerg {
992 1.1 joerg struct orig_callback_data orig_data;
993 1.1 joerg orig_data.callback = args->callback;
994 1.1 joerg orig_data.data = args->callback_data;
995 1.15 christos const char *snippet_args[3] = { "\002", "\003", "..." };
996 1.1 joerg args->callback = &callback_pager;
997 1.1 joerg args->callback_data = (void *) &orig_data;
998 1.15 christos return run_query_internal(db, snippet_args, args);
999 1.1 joerg }
1000 1.9 christos
1001 1.18 christos struct nv {
1002 1.18 christos char *s;
1003 1.18 christos size_t l;
1004 1.18 christos };
1005 1.18 christos
1006 1.18 christos static int
1007 1.18 christos term_putc(int c, void *p)
1008 1.18 christos {
1009 1.18 christos struct nv *nv = p;
1010 1.18 christos nv->s[nv->l++] = c;
1011 1.18 christos return 0;
1012 1.18 christos }
1013 1.18 christos
1014 1.18 christos static char *
1015 1.18 christos term_fix_seq(TERMINAL *ti, const char *seq)
1016 1.18 christos {
1017 1.18 christos char *res = estrdup(seq);
1018 1.18 christos struct nv nv;
1019 1.18 christos
1020 1.19 christos if (ti == NULL)
1021 1.19 christos return res;
1022 1.19 christos
1023 1.18 christos nv.s = res;
1024 1.18 christos nv.l = 0;
1025 1.18 christos ti_puts(ti, seq, 1, term_putc, &nv);
1026 1.18 christos nv.s[nv.l] = '\0';
1027 1.18 christos
1028 1.18 christos return res;
1029 1.18 christos }
1030 1.18 christos
1031 1.9 christos static void
1032 1.9 christos term_init(int fd, const char *sa[5])
1033 1.9 christos {
1034 1.9 christos TERMINAL *ti;
1035 1.9 christos int error;
1036 1.9 christos const char *bold, *sgr0, *smso, *rmso, *smul, *rmul;
1037 1.9 christos
1038 1.9 christos if (ti_setupterm(&ti, NULL, fd, &error) == -1) {
1039 1.9 christos bold = sgr0 = NULL;
1040 1.9 christos smso = rmso = smul = rmul = "";
1041 1.9 christos ti = NULL;
1042 1.9 christos } else {
1043 1.9 christos bold = ti_getstr(ti, "bold");
1044 1.9 christos sgr0 = ti_getstr(ti, "sgr0");
1045 1.9 christos if (bold == NULL || sgr0 == NULL) {
1046 1.9 christos smso = ti_getstr(ti, "smso");
1047 1.9 christos
1048 1.9 christos if (smso == NULL ||
1049 1.9 christos (rmso = ti_getstr(ti, "rmso")) == NULL)
1050 1.9 christos smso = rmso = "";
1051 1.9 christos bold = sgr0 = NULL;
1052 1.9 christos } else
1053 1.9 christos smso = rmso = "";
1054 1.9 christos
1055 1.9 christos smul = ti_getstr(ti, "smul");
1056 1.9 christos if (smul == NULL || (rmul = ti_getstr(ti, "rmul")) == NULL)
1057 1.9 christos smul = rmul = "";
1058 1.9 christos }
1059 1.9 christos
1060 1.18 christos sa[0] = term_fix_seq(ti, bold ? bold : smso);
1061 1.18 christos sa[1] = term_fix_seq(ti, sgr0 ? sgr0 : rmso);
1062 1.9 christos sa[2] = estrdup("...");
1063 1.18 christos sa[3] = term_fix_seq(ti, smul);
1064 1.18 christos sa[4] = term_fix_seq(ti, rmul);
1065 1.18 christos
1066 1.9 christos if (ti)
1067 1.9 christos del_curterm(ti);
1068 1.9 christos }
1069 1.9 christos
1070 1.9 christos /*
1071 1.9 christos * run_query_term --
1072 1.9 christos * Utility function similar to run_query_html. This function tries to
1073 1.9 christos * pre-process the result assuming it will be displayed on a terminal
1074 1.17 snj * For this purpose it first calls its own callback function callback_pager
1075 1.9 christos * which then delegates the call to the user supplied callback.
1076 1.9 christos */
1077 1.15 christos static int
1078 1.9 christos run_query_term(sqlite3 *db, query_args *args)
1079 1.9 christos {
1080 1.9 christos struct orig_callback_data orig_data;
1081 1.9 christos struct term_args ta;
1082 1.9 christos orig_data.callback = args->callback;
1083 1.9 christos orig_data.data = args->callback_data;
1084 1.9 christos const char *snippet_args[5];
1085 1.15 christos
1086 1.15 christos term_init(STDOUT_FILENO, snippet_args);
1087 1.9 christos ta.smul = snippet_args[3];
1088 1.9 christos ta.rmul = snippet_args[4];
1089 1.9 christos ta.orig_data = (void *) &orig_data;
1090 1.9 christos
1091 1.9 christos args->callback = &callback_term;
1092 1.9 christos args->callback_data = &ta;
1093 1.15 christos return run_query_internal(db, snippet_args, args);
1094 1.15 christos }
1095 1.15 christos
1096 1.15 christos static int
1097 1.15 christos run_query_none(sqlite3 *db, query_args *args)
1098 1.15 christos {
1099 1.15 christos struct orig_callback_data orig_data;
1100 1.15 christos orig_data.callback = args->callback;
1101 1.15 christos orig_data.data = args->callback_data;
1102 1.15 christos const char *snippet_args[3] = { "", "", "..." };
1103 1.15 christos args->callback = &callback_pager;
1104 1.15 christos args->callback_data = (void *) &orig_data;
1105 1.15 christos return run_query_internal(db, snippet_args, args);
1106 1.15 christos }
1107 1.15 christos
1108 1.15 christos int
1109 1.15 christos run_query(sqlite3 *db, query_format fmt, query_args *args)
1110 1.15 christos {
1111 1.15 christos switch (fmt) {
1112 1.15 christos case APROPOS_NONE:
1113 1.15 christos return run_query_none(db, args);
1114 1.15 christos case APROPOS_HTML:
1115 1.15 christos return run_query_html(db, args);
1116 1.15 christos case APROPOS_TERM:
1117 1.15 christos return run_query_term(db, args);
1118 1.15 christos case APROPOS_PAGER:
1119 1.15 christos return run_query_pager(db, args);
1120 1.15 christos default:
1121 1.15 christos warnx("Unknown query format %d", (int)fmt);
1122 1.15 christos return -1;
1123 1.15 christos }
1124 1.9 christos }
1125