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.

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

    esqueleto Database.Esqueleto

    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

    No documentation available.

  3. (==.) :: 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 = ?

  4. (>.) :: 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

  5. (>=.) :: 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

  6. (?.) :: (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 ??..

  7. (^.) :: 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.

  8. (||.) :: 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

  9. (!=.) :: 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

  10. (&&.) :: 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

Page 117 of many | Previous | Next