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

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

   No documentation available.

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

   esqueleto	Database.Esqueleto.Internal.Internal

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

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

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

   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. (??.) :: (PersistEntity val, PersistField typ) => SqlExpr (Maybe (Entity val)) -> EntityField val typ -> SqlExpr (Value (Maybe typ))

   esqueleto	Database.Esqueleto.Internal.Internal

   Project a field of an entity that may be null. This variant will produce a nested Maybe if you select a Maybe column. If you want to collapse Maybe, see ?..

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

   esqueleto	Database.Esqueleto.Internal.Internal

   Project a field of an entity.

9. (||.) :: 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 ^. UserName ==. val John
   

10. (!=.) :: 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 ^. UserName !=. val Bob
    

Page 121 of many | Previous | Next