Hoogle Search

Within LTS Haskell 24.38 (ghc-9.10.3)

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

Exact lookup

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

   esqueleto	Database.Esqueleto

   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 = ?
   

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

   esqueleto	Database.Esqueleto

   This operator translates to the SQL operator >. Example:

   where_ $ user ^. UserAge >. val 20
   

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

   esqueleto	Database.Esqueleto

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

   where_ $ user ^. UserAge >=. val 21
   

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

   esqueleto	Database.Esqueleto

   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 ??..

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

   esqueleto	Database.Esqueleto

   Project a field of an entity.

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

   esqueleto	Database.Esqueleto

   This operator translates to the SQL operator AND. Example:

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

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

   esqueleto	Database.Esqueleto.Experimental

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

   where_ $ user ^. UserName !=. val Bob
   

8. (&&.) :: SqlExpr (Value Bool) -> SqlExpr (Value Bool) -> SqlExpr (Value Bool)

   esqueleto	Database.Esqueleto.Experimental

   This operator translates to the SQL operator AND. Example:

   where_ $
   user ^. UserName ==. val Matt
   &&. user ^. UserAge >=. val 21
   

9. (*.) :: PersistField a => SqlExpr (Value a) -> SqlExpr (Value a) -> SqlExpr (Value a)

   esqueleto	Database.Esqueleto.Experimental

   This operator translates to the SQL operator *. This does not require or assume anything about the SQL values. Interpreting what *. means for a given type is left to the database engine. Example:

   user ^. UserAge *. val 10
   

10. (*=.) :: (PersistEntity val, PersistField a) => EntityField val a -> SqlExpr (Value a) -> SqlExpr (Entity val) -> SqlExpr Update

    esqueleto	Database.Esqueleto.Experimental

    No documentation available.

Page 117 of many | Previous | Next