Module: Rufus::Tokyo::QueryConstants

Included in:
Edo::TableQuery, TableQuery
Defined in:
lib/rufus/tokyo/query.rb

Overview

Some constants shared by table implementations.

Constant Summary collapse

OPERATORS =
{

  # strings...

  :streq => 0, # string equality
  :eq => 0,
  :eql => 0,
  :equals => 0,

  :strinc => 1, # string include
  :inc => 1, # string include
  :includes => 1, # string include

  :strbw => 2, # string begins with
  :bw => 2,
  :starts_with => 2,
  :strew => 3, # string ends with
  :ew => 3,
  :ends_with => 3,

  :strand => 4, # string which include all the tokens in the given exp
  :and => 4,

  :stror => 5, # string which include at least one of the tokens
  :or => 5,

  :stroreq => 6, # string which is equal to at least one token

  :strorrx => 7, # string which matches the given regex
  :regex => 7,
  :matches => 7,

  # numbers...

  :numeq => 8, # equal
  :numequals => 8,
  :numgt => 9, # greater than
  :gt => 9,
  :numge => 10, # greater or equal
  :ge => 10,
  :gte => 10,
  :numlt => 11, # greater or equal
  :lt => 11,
  :numle => 12, # greater or equal
  :le => 12,
  :lte => 12,
  :numbt => 13, # a number between two tokens in the given exp
  :bt => 13,
  :between => 13,

  :numoreq => 14, # number which is equal to at least one token

  # full-text search
  :ftsph => 15,
  :ftsphrase => 15,
  :phrase => 15,
  :ftsand => 16,
  :ftsor => 17,
  :ftsex => 18
}
TDBQCNEGATE =
1 << 24
TDBQCNOIDX =
1 << 25
DIRECTIONS =
{
  :strasc => 0,
  :strdesc => 1,
  :asc => 0,
  :desc => 1,
  :numasc => 2,
  :numdesc => 3
}