mosano-eu / auto-advanced-search

auto-advanced-search

auto-advanced-search

Auto-advanced-search is a module to prepare strings to perform match against in boolean mode modifier in mysql, that handles relevences of the required words for the query.

Installation:

npm i --save auto-advanced-search

Example:

// Require dependencies
var aas = require( 'auto-advanced-search' );

// Do the filtering
var string = 'something that i want to find',

// Call function with the required query
var query = aas( string );

// Returned result
	// query - returns '+something +that +want +find*'

Explanation:

The first string is always returned because, in this way, while the user is typing the word is going to appear some results. The next words will be filtered if it have three characters or less because in most cases this words doesn't have much relevance in the searching. In the last word have a "", like the sql wildcard "%", for the next characters match. The response will return the string with a plus "+" and in the last word have a "", like the sql "LIKE" wildcard "%", ex.'+string*' or '+first +second*' for the in boolean mode modifier assigns the relevance to the query.

Find with hit, and give their relevance with auto-advanced-search for better searches!

auto-advanced-search's Issues

String invalidated must be returned as it is.

If the String is invalidated, it returns '' an empty String, but this doesn't seems to work if i searched by a number, it just kills my query instead breaking throw as clean number.

Ex. https://github.com/findhit/auto-advanced-search/blob/master/lib/query.js#L10

we need a findhit/strider-docker-findhit based image with mysql preconfigured

@fernadoneto could you please provide a docker image based on top of findhit/strider-docker-findhit with mysql server and client resources installed?

Tests aren't running because we need mysql on test environment - http://strider.findhit.com/findhit/auto-advanced-search/

Module review

remove unsecure chars from aas query

  aas
    ✓ should not break with " 
    ✓ should not break with ' 
    ✓ should not break with ; 
    ✓ should not break with ( 
    ✓ should not break with ) 
    ✓ should not break with () 
    ✓ should not break with ! 
    ✓ should not break with ? 
    ✓ should not break with : 
    ✓ should not break with - 
    ✓ should not break with _ 
    ✓ should not break with ` 
    ✓ should not break with ´ 
    ✓ should not break with | 
    ✓ should not break with \ 
    ✓ should not break with # 
    ✓ should not break with $ 
    ✓ should not break with % 
    ✓ should not break with & 
    ✓ should not break with / 
    ✓ should not break with = 
    ✓ should not break with + 
    ✓ should not break with º 
    ✓ should not break with ª 
    ✓ should not break with ç 
    ✓ should not break with ~ 
    ✓ should not break with ^ 
    ✓ should not break with § 
    ✓ should not break with ± 
    ✓ should not break with @ 
    ✓ should not break with € 
    ✓ should not break with £ 
    ✓ should not break with ‰ 
    ✓ should not break with ¶ 
    ✓ should not break with ✓ 
    ✓ should not break with « 
    ✓ should not break with » 
    ✓ should not break with > 
    ✓ should not break with < 
    ✓ should not break with ≤ 
    ✓ should not break with ≥ 
    ✓ should not break with — 
    ✓ should not break with … 
    ✓ should not break with “ 
    ✓ should not break with ” 
    ✓ should clean also hexadecimal shits 

update README.md to match 1.0.0

with changes on #9