What is the simplest way to change PhqlQueryParser::OPERATOR_IS_LIKE from 'LIKE' to 'ILIKE' ?

[szonov]

No description provided.

[andevsoftware]

@szonov, can you explain what you mean by that?

[szonov]

Hello,
I use postgresql as database, LIKE in postgres is case sensitive, in my api search criteria should be be case insensitive. For it in postgres there is ILIKE operator.. I'm looking way to change behaviour, and use in resulting search queries ILIKE instead of LIKE without changing your code.

[szonov]

I thought about extending PhqlQueryParser class, but now it does not work. functions getOperator() and operatorMap() are private - can not change it in extended class. I can redefine const OPERATOR_IS_LIKE in my extended class - but in operatorMap() it is used as self::OPERATOR_IS_LIKE. Maybe you can replace in function operatorMap() usage self::OPERATOR_* to static::OPERATOR_*? It give me possibility to fix my issue by:

class myPhqlQueryParser extends PhqlQueryParser {
const OPERATOR_IS_LIKE = 'ILIKE';
}