Predicate Query |
Translated SQL Query |
==
predicateGigaSpace read { person: Person =>
person.name == "john"
}
|
=
gigaSpace read new SQLQuery(classOf[Person],
"name = ?", "john"
)
|
!=
predicateGigaSpace read { person: Person =>
person.name != "john"
}
|
<>
gigaSpace read new SQLQuery(classOf[Person],
"name <> ?", "john"
)
|
>
predicateGigaSpace read { person: Person =>
person.height > 10
}
|
>
gigaSpace read new SQLQuery(classOf[Person],
"height > ?", 10: Integer
)
|
>=
predicateGigaSpace read { person: Person =>
person.height >= 10
}
|
>=
gigaSpace read new SQLQuery(classOf[Person],
"height >= ?", 10: Integer
)
|
<
predicateGigaSpace read { person: Person =>
person.height < 10
}
|
<
gigaSpace read new SQLQuery(classOf[Person],
"height < ?", 10: Integer
)
|
<=
predicateGigaSpace read { person: Person =>
person.height <= 10
}
|
<=
gigaSpace read new SQLQuery(classOf[Person],
"height <= ?", 10: Integer
)
|
&&
predicateGigaSpace read { person: Person =>
person.height > 10 && person.height < 100
}
|
AND
gigaSpace read new SQLQuery(classOf[Person],
"( height > ? ) AND ( height < ? )",
10: Integer, 100: Integer
)
|
||
predicateGigaSpace read { person: Person =>
person.height < 10 || person.height > 100
}
|
OR
gigaSpace read new SQLQuery(classOf[Person],
"( height < ? ) OR ( height > ? )",
10: Integer, 100: Integer
)
|
eq null
predicateGigaSpace read { person: Person =>
person.name eq null
}
|
is null
gigaSpace read new SQLQuery(classOf[Person],
"name is null", QueryResultType.OBJECT
)
|
ne null
predicateGigaSpace read { person: Person =>
person.name ne null
}
|
is NOT null
gigaSpace read new SQLQuery(classOf[Person],
"name is NOT null", QueryResultType.OBJECT
)
|
like
predicateGigaSpace read { person: Person =>
person.name like "j%"
}
|
like
gigaSpace read new SQLQuery(classOf[Person],
"name like 'j%'", QueryResultType.OBJECT
)
|
notLike
predicateGigaSpace read { person: Person =>
person.name notLike "j%"
}
|
NOT like
gigaSpace read new SQLQuery(classOf[Person],
"name NOT like 'j%'", QueryResultType.OBJECT
)
|
rlike
predicateGigaSpace read { person: Person =>
person.name rlike "j.*"
}
|
rlike
gigaSpace read new SQLQuery(classOf[Person],
"name rlike 'j.*'", QueryResultType.OBJECT
)
|
Nested Queries
predicateGigaSpace read { person: Person =>
person.son.name == "dave"
}
|
gigaSpace read new SQLQuery(classOf[Person],
"son.name = ?", "dave"
)
|
Date
predicateGigaSpace read { person: Person =>
person.birthday < janesBirthday
}
|
gigaSpace read new SQLQuery(classOf[Person],
"birthday < ?", janesBirthday
)
|
Date
predicateGigaSpace read { person: Person =>
person.birthday <= janesBirthday
}
|
gigaSpace read new SQLQuery(classOf[Person],
"birthday <= ?", janesBirthday
)
|
Date
predicateGigaSpace read { person: Person =>
person.birthday > janesBirthday
}
|
gigaSpace read new SQLQuery(classOf[Person],
"birthday > ?", janesBirthday
)
|
Date
predicateGigaSpace read { person: Person =>
person.birthday >= janesBirthday
}
|
gigaSpace read new SQLQuery(classOf[Person],
"birthday >= ?", janesBirthday
)
|
select
predicateGigaSpace read { person: Person =>
select(person.name, person.birthday)
person.id == someId
}
|
setProjections
gigaSpace read new SQLQuery(classOf[Person],
"id = ?", someId
).setProjections("name, birthday")
|
orderBy
predicateGigaSpace read { person: Person =>
orderBy(person.birthday)
person.nickName eq null
}
|
ORDER BY
gigaSpace read new SQLQuery(classOf[Person],
"nickName is null ORDER BY birthday",
QueryResultType.OBJECT
)
|
orderBy().ascending
predicateGigaSpace read { person: Person =>
orderBy(person.birthday).ascending
person.nickName eq null
}
|
ORDER BY ... ASC
gigaSpace read new SQLQuery(classOf[Person],
"nickName is null ORDER BY birthday ASC",
QueryResultType.OBJECT
)
|
orderBy().descending
predicateGigaSpace read { person: Person =>
orderBy(person.birthday).descending
person.nickName eq null
}
|
ORDER BY ... DESC
gigaSpace read new SQLQuery(classOf[Person],
"nickName is null ORDER BY birthday DESC",
QueryResultType.OBJECT
)
|
groupBy
predicateGigaSpace read { person: Person =>
groupBy(person.birthday)
person.nickName eq null
}
|
GROUP BY
gigaSpace read new SQLQuery(classOf[Person],
"nickName is null GROUP BY birthday",
QueryResultType.OBJECT
)
|