This mixin provides SQL string methods such as (like and iLike).

Example

sql.a.like("A%"); //=> "a" LIKE 'A%'
sql.a.iLike("A%"); //=> "a" LIKE 'A%'
sql.a.like(/^a/); //=>  "a" ~* '^a'
            

Constructor

Defined sql.js Source

define({
            

ilike Function Public

---

Defined sql.js

Create a patio.sql.BooleanExpression case insensitive pattern match of the receiver with the given patterns. See patio.sql.StringExpression#like.

Example

sql.a.iLike("A%"); //=> "a" LIKE 'A%'
        

Arguments

• expression :

Returns

• patio.sql.BooleanExpression

Source

function (expression){
   expression = argsToArray(arguments);
   return StringExpression.like.apply(StringExpression, [this].concat(expression).concat([
       {caseInsensitive: true}
   ]));
           
}
    

like Function Public

---

Defined sql.js

Create a patio.sql.BooleanExpression case sensitive (if the database supports it) pattern match of the receiver with the given patterns. See patio.sql.StringExpression#like.

Example

sql.a.like(/^a/); //=>  "a" ~* '^a'
sql.a.like("A%"); //=> "a" LIKE 'A%'
        

Arguments

• expression :

Source

function (expression){
   expression = argsToArray(arguments);
   return StringExpression.like.apply(StringExpression, [this].concat(expression));
           
}
    

---

Documentation generated using coddoc.