How to escape + and - modificators? about pg-tsquery HOT 8 CLOSED

Nice catch, I'll implement quoting, single or double quotes to search literal values

from pg-tsquery.

@testarossaaaaa I've pushed an update, now you can use quotes: https://github.com/caub/pg-tsquery/blob/master/test/data-default.json#L105-L106

the returned string is then transformed as:

postgres=# select to_tsquery('Test&\"quoted<->text<->G1-ABC<->+37544<->\"');
                               to_tsquery                                
-------------------------------------------------------------------------
 'test' & 'quot' <-> 'text' <-> ( 'g1-abc' & 'g1' & 'abc' ) <-> '+37544'

from pg-tsquery.

This will be good

from pg-tsquery.

I pushed a configurable version

const tsquery = require('pg-tsquery')();

console.log(tsquery('G1-ABC'));
console.log(tsquery('+a37544:*'));
/*
G1&!ABC
a37544:*
*/

const tsquery2 = require('pg-tsquery')({
    OR: /^\s*(?:[|,]|or)/i,
    AND: /^(?!\s*(?:[|,]|or))(?:[\s&:|,!]|and)*/i,
    FOLLOWED_BY: /^\s*<(?:(?:(\d+)|-)?>)?/,
    WORD: /^[\s*&<:,|]*([\s!]*)[\s*&<:,|]*([^\s,|&<:*()[\]!]+)/,
    PAR_START: /^\s*!*[([]/,
    PAR_END: /^[)\]]/,
    NEGATED: /!$/,
    PREFIX: /^(\*|:\*)*/,
    TAIL_OP: '&',
});

console.log(tsquery2('G1-ABC'));
console.log(tsquery2('+37544:*'));
/*
G1-ABC
+37544:*
*/

The options are still a bit complex maybe, and also I need to have tests with different configurations than the default one, feel free to participate

from pg-tsquery.

Can we just disable some options with this approach?

from pg-tsquery.

@testarossaaaaa This is what the configuration above does, I know it's a bit scary, but this config is simpler than the default one, +, - are not parsed

An even simpler one (no or, and, [, ] parsing, but make sure to test it with enough inputs, and see if it pg never throws

const tsquery3 = require('pg-tsquery')({
    OR: /^\s*[|,]/,
    AND: /^(?!\s*[|,])[\s&:|,!]*/,
    FOLLOWED_BY: /^\s*<(?:(?:(\d+)|-)?>)?/,
    WORD: /^[\s*&<:,|]*([\s!]*)[\s*&<:,|]*([^\s,|&<:*()!]+)/,
    PAR_START: /^\s*!*[(]/,
    PAR_END: /^[)]/,
    NEGATED: /!$/,
    PREFIX: /^(\*|:\*)*/,
    TAIL_OP: '&',
});

console.log(tsquery3('G1-ABC'));
console.log(tsquery3('+37544:*'));
/*
G1-ABC
+37544:*
*/

from pg-tsquery.

Apparently now the keys are camel case and you can override just the negate rule in the constructor, eg

const tsParser = new Tsquery({
  negated: /!$/
})

from pg-tsquery.

Yes correct, settings fields are camel cased now as of version 8 c68a36e

Here are the settings: https://github.com/caub/pg-tsquery/blob/master/index.js#L56-L66

from pg-tsquery.