where ( specs obj -- )

Vocabulary

db.queries

Inputs

specs	an object
obj	an object

Outputs

None

Definition

IN: db.queries

GENERIC: where ( specs obj -- )

Methods

USING: accessors db.queries db.types kernel nmake ;

M: NULL where drop column-name>> 0% " is NULL" 0% ;


USING: accessors byte-arrays db.queries db.types kernel nmake ;

M: byte-array where over column-name>> 0% " = " 0% bind# ;


USING: db.queries math ;

M: integer where object-where ;


USING: accessors db.queries kernel math.intervals nmake ;

M: interval where
    [
        [ from>> "from" where-interval ]
        [ nip infinite-interval? [ " and " 0% ] unless ]
        [ to>> "to" where-interval ] 2tri
    ] in-parens ;


USING: db.queries ;

M: likeexp where like-where ;


USING: db.queries kernel ;

M: object where object-where ;


USING: accessors db.queries db.types kernel nmake persistency ;

M: pattern where
    value>> over column-name>> 0% " LIKE " 0% bind# ;


USING: db.queries kernel nmake sequences ;

M: sequence where
    [ [ " or " 0% ] [ dupd where ] interleave drop ] in-parens ;


USING: db.queries strings ;

M: string where object-where ;