Home | History | Annotate | Line # | Download | only in makemandb
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(&section_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(&section_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 {&gt;, &lt;, &quot;, &amp;}.
    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("&lt;");
    761   1.1     joerg 			break;
    762   1.1     joerg 		case '>':
    763  1.21  christos 			append("&gt;");
    764   1.1     joerg 			break;
    765   1.1     joerg 		case '\"':
    766  1.21  christos 			append("&quot;");
    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("&amp;");
    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