Hoogle Search

Within LTS Haskell 24.32 (ghc-9.10.3)

Note that Stackage only displays results for the latest LTS and Nightly snapshot. Learn more.

  1. (<.) :: PersistField typ => SqlExpr (Value typ) -> SqlExpr (Value typ) -> SqlExpr (Value Bool)

    esqueleto Database.Esqueleto.Legacy

    This operator translates to the SQL operator <. Example: 

    where_ $ val 20 <. user ^. UserAge

  2. (<=.) :: PersistField typ => SqlExpr (Value typ) -> SqlExpr (Value typ) -> SqlExpr (Value Bool)

    esqueleto Database.Esqueleto.Legacy

    This operator translates to the SQL operator <=. Example: 

    where_ $ val 21 <=. user ^. UserAge

  3. (=.) :: (PersistEntity val, PersistField typ) => EntityField val typ -> SqlExpr (Value typ) -> SqlExpr (Entity val) -> SqlExpr Update

    esqueleto Database.Esqueleto.Legacy

    No documentation available.

  4. (==.) :: PersistField typ => SqlExpr (Value typ) -> SqlExpr (Value typ) -> SqlExpr (Value Bool)

    esqueleto Database.Esqueleto.Legacy

    This operator produces the SQL operator =, which is used to compare values for equality. Example: 

    query :: UserId -> SqlPersistT IO [Entity User]
query userId = select $ do
user <- from $ table @User
where_ (user ^. UserId ==. val userId)
pure user
    This would generate the following SQL: 
    SELECT user.*
FROM user
WHERE user.id = ?

  5. (>.) :: PersistField typ => SqlExpr (Value typ) -> SqlExpr (Value typ) -> SqlExpr (Value Bool)

    esqueleto Database.Esqueleto.Legacy

    This operator translates to the SQL operator >. Example: 

    where_ $ user ^. UserAge >. val 20

  6. (>=.) :: PersistField typ => SqlExpr (Value typ) -> SqlExpr (Value typ) -> SqlExpr (Value Bool)

    esqueleto Database.Esqueleto.Legacy

    This operator translates to the SQL operator >=. Example: 

    where_ $ user ^. UserAge >=. val 21

  7. (?.) :: (PersistEntity val, PersistField typ) => SqlExpr (Maybe (Entity val)) -> EntityField val typ -> SqlExpr (Value (Maybe (Nullable typ)))

    esqueleto Database.Esqueleto.Legacy

    Project an EntityField of a nullable entity. The result type will be Nullable, meaning that nested Maybe won't be produced here. As of v3.6.0.0, this will attempt to combine nested Maybe. If you want to keep nested Maybe, then see ??..

  8. (^.) :: forall typ val . (PersistEntity val, PersistField typ) => SqlExpr (Entity val) -> EntityField val typ -> SqlExpr (Value typ)

    esqueleto Database.Esqueleto.Legacy

    Project a field of an entity.

  9. (||.) :: SqlExpr (Value Bool) -> SqlExpr (Value Bool) -> SqlExpr (Value Bool)

    esqueleto Database.Esqueleto.Legacy

    This operator translates to the SQL operator AND. Example: 

    where_ $
user ^. UserName ==. val Matt
||. user ^. UserName ==. val John

  10. ( #-. ) :: JSONBExpr a -> [Text] -> JSONBExpr b

    esqueleto Database.Esqueleto.PostgreSQL.JSON

    Requires PostgreSQL version >= 9.5 This operator can remove elements nested in an object. If a Text is not parsable as a number when selecting in an array (even when halfway through the selection) an exception will be thrown. Negative integers delete counting from the end of an array. (e.g. -1 being the last element, -2 being the second to last, etc.) CAUTION: THIS FUNCTION THROWS AN EXCEPTION WHEN USED ON ANYTHING OTHER THAN OBJECTS OR ARRAYS, AND WILL ALSO THROW WHEN TRYING TO SELECT AN ARRAY ELEMENT WITH A NON-INTEGER TEXT

    Objects

    {"a": 3.14, "b": null}        #- []        == {"a": 3.14, "b": null}
{"a": 3.14, "b": null}        #- ["a"]     == {"b": null}
{"a": 3.14, "b": null}        #- ["a","b"] == {"a": 3.14, "b": null}
{"a": {"b":false}, "b": null} #- ["a","b"] == {"a": {}, "b": null}

    Arrays

    [true, {"b":null}, 5]       #- []            == [true, {"b":null}, 5]
[true, {"b":null}, 5]       #- ["0"]         == [{"b":null}, 5]
[true, {"b":null}, 5]       #- ["b"]         == ERROR: path element at position 1 is not an integer: "b"
[true, {"b":null}, 5]       #- ["1","b"]     == [true, {}, 5]
[true, {"b":null}, 5]       #- ["-2","b"]    == [true, {}, 5]
{"a": {"b":[false,4,null]}} #- ["a","b","2"] == {"a": {"b":[false,4]}}
{"a": {"b":[false,4,null]}} #- ["a","b","c"] == ERROR: path element at position 3 is not an integer: "c"

    Other values

    1    #- {anything} == ERROR: cannot delete from scalar
"a"  #- {anything} == ERROR: cannot delete from scalar
true #- {anything} == ERROR: cannot delete from scalar
null #- {anything} == ERROR: cannot delete from scalar

    PostgreSQL Documentation

    | Type   | Description                                             |  Example
----+--------+---------------------------------------------------------+------------------------------------
#- | text[] | Delete the field or element with specified path         | '["a", {"b":1}]'::jsonb #- '{1,b}'
|        | (for JSON arrays, negative integers count from the end) |

Page 123 of many | Previous | Next