Hoogle Search

Within LTS Haskell 24.20 (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.Experimental

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

   where_ $ val 21 <=. user ^. UserAge
   

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

   esqueleto	Database.Esqueleto.Experimental

   No documentation available.

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

   esqueleto	Database.Esqueleto.Experimental

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

4. (>.) :: 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 ^. UserAge >. val 20
   

5. (>=.) :: 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 ^. UserAge >=. val 21
   

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

   esqueleto	Database.Esqueleto.Experimental

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

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

   esqueleto	Database.Esqueleto.Experimental

   Project a field of an entity.

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 ^. UserName ==. val John
   

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

   esqueleto	Database.Esqueleto.Internal.Internal

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

   where_ $ user ^. UserName !=. val Bob
   

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

    esqueleto	Database.Esqueleto.Internal.Internal

    This operator translates to the SQL operator AND. Example:

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

Page 119 of many | Previous | Next