48 lines
1.4 KiB
Matlab
48 lines
1.4 KiB
Matlab
% SqlOperator - Enumeration of supported SQL operators for query building.
|
|
%
|
|
% Usage:
|
|
% op = SqlOperator.GREATER_THAN;
|
|
% opStr = op.toSqlString(); % returns '>'
|
|
%
|
|
% Supported operators:
|
|
% EQUALS, GREATER_THAN, LESS_THAN, GREATER_EQUAL, LESS_EQUAL,
|
|
% NOT_EQUAL, IN, BETWEEN, LIKE
|
|
|
|
classdef SqlOperator < uint32
|
|
enumeration
|
|
EQUALS (1) % ==
|
|
GREATER_THAN (2) % >
|
|
LESS_THAN (3) % <
|
|
GREATER_EQUAL (4) % >=
|
|
LESS_EQUAL (5) % <=
|
|
NOT_EQUAL (6) % !=
|
|
IN (7) % IN
|
|
BETWEEN (8) % BETWEEN
|
|
LIKE (9) % LIKE
|
|
end
|
|
|
|
methods
|
|
function op = toSqlString(obj)
|
|
switch obj
|
|
case SqlOperator.EQUALS
|
|
op = '=';
|
|
case SqlOperator.GREATER_THAN
|
|
op = '>';
|
|
case SqlOperator.LESS_THAN
|
|
op = '<';
|
|
case SqlOperator.GREATER_EQUAL
|
|
op = '>=';
|
|
case SqlOperator.LESS_EQUAL
|
|
op = '<=';
|
|
case SqlOperator.NOT_EQUAL
|
|
op = '!=';
|
|
case SqlOperator.IN
|
|
op = 'IN';
|
|
case SqlOperator.BETWEEN
|
|
op = 'BETWEEN';
|
|
case SqlOperator.LIKE
|
|
op = 'LIKE';
|
|
end
|
|
end
|
|
end
|
|
end |