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 Returns 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 Source
function (expression){
   expression = argsToArray(arguments);
   return StringExpression.like.apply(StringExpression, [this].concat(expression));
           
}
    

Documentation generated using coddoc.