This mixin includes the inequality methods (>, <, >=, <=) that are defined on objects that can be used in a numeric or string context in SQL.

Example

sql.a.gt("b")  //=> a > "b"
sql.a.lt("b")  //=> a > "b"
sql.a.gte("b") //=> a >= "b"
sql.a.lte("b") //=> a <= "b"
sql.a.eq("b") //=> a = "b"
            

Constructor

Defined sql.js Source

define({
            

between Function Private

---

Defined sql.js

Example

sql.x.between([1,2]) => //=> WHERE ((x >= 1) AND (x <= 10))
sql.x.between([1,2]).invert() => //=> WHERE ((x < 1) OR (x > 10))
        

Arguments

• items :

  a two element array where the first element it the item to be gte and the second item lte.

Returns

• patio.sql.BooleanExpression

  a boolean expression containing the between expression.

Source

function (items){
   return new BooleanExpression("AND", new BooleanExpression("gte", this, items[0]), new BooleanExpression("lte", this, items[1]));
           
}
    

eq Function Public

---

Defined sql.js

Example

sql.a.eq("b")  //=> a = "b"
        

Returns

• patio.sql.BooleanExpression

Source

inequalityMethod("eq")
    

gt Function Public

---

Defined sql.js

Example

sql.a.gt("b")  //=> a > "b"
        

Returns

• patio.sql.BooleanExpression

Source

inequalityMethod("gt")
    

gte Function Public

---

Defined sql.js

Example

sql.a.gte("b")  //=> a >= "b"
        

Returns

• patio.sql.BooleanExpression

Source

inequalityMethod("gte")
    

lt Function Public

---

Defined sql.js

Example

sql.a.lt("b")  //=> a < "b"
        

Returns

• patio.sql.BooleanExpression

Source

inequalityMethod("lt")
    

lte Function Public

---

Defined sql.js

Example

sql.a.lte("b")  //=> a <= "b"
        

Returns

• patio.sql.BooleanExpression

Source

inequalityMethod("lte")
    

---

Documentation generated using coddoc.