@sql-extra/selecttsquery v0.1.1

@sql-extra/selecttsquery

Generate SQL command for SELECT with tsquery.

const selectTsquery = require('@sql-extra/selecttsquery');
// selectTsquery(<table>, <query>, [tsvector], [options])
// -> sql command

// options: {
//   columns: '*',  // select columns: all
//   order: false,  // order rows: no
//   limit: null,   // limit rows: no
//   normalization: 0,  // rank normalization: ignores the document length
// }


selectTsquery('columns', 'total fat');
// SELECT * FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total fat');

selectTsquery('columns', 'total fat', '"tsvector"', {columns: '"code"'});
// SELECT "code" FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total fat');

selectTsquery('columns', 'total fat', '"tsvector"', {order: true, limit: 1, normalization: 2});
// SELECT * FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total fat') ORDER BY ts_rank("tsvector", plainto_tsquery('total fat'), 2) DESC LIMIT 1;