| Copyright | (c) 2016-2017 Red Hat Inc. |
|---|---|
| License | LGPL |
| Maintainer | https://github.com/weldr |
| Stability | alpha |
| Portability | portable |
| Safe Haskell | None |
| Language | Haskell2010 |
BDCS.DB
Description
The metadata database schema and miscellaneous database helper functions
- schemaVersion :: Int64
- getDbVersion :: (MonadError String m, MonadIO m) => SqlPersistT m Int64
- checkDbVersion :: (MonadError String m, MonadIO m) => SqlPersistT m ()
- checkAndRunSqlite :: (MonadError String m, MonadBaseControl IO m, MonadIO m) => Text -> SqlPersistT (NoLoggingT (ResourceT m)) a -> m a
- data Projects = Projects {
- projectsName :: !Text
- projectsSummary :: !Text
- projectsDescription :: !Text
- projectsHomepage :: !(Maybe Text)
- projectsUpstream_vcs :: !Text
- type ProjectsId = Key Projects
- data Sources = Sources {
- sourcesProject_id :: !(Key Projects)
- sourcesLicense :: !Text
- sourcesVersion :: !Text
- sourcesSource_ref :: !Text
- type SourcesId = Key Sources
- data Builds = Builds {
- buildsSource_id :: !(Key Sources)
- buildsEpoch :: !Int
- buildsRelease :: !Text
- buildsArch :: !Text
- buildsBuild_time :: !UTCTime
- buildsChangelog :: !ByteString
- buildsBuild_config_ref :: !Text
- buildsBuild_env_ref :: !Text
- type BuildsId = Key Builds
- data BuildSignatures = BuildSignatures {
- buildSignaturesBuild_id :: !(Key Builds)
- buildSignaturesSignature_type :: !Text
- buildSignaturesSignature_data :: !ByteString
- type BuildSignaturesId = Key BuildSignatures
- data Files = Files {
- filesPath :: !Text
- filesFile_user :: !Text
- filesFile_group :: !Text
- filesMtime :: !Int
- filesCs_object :: !(Maybe ByteString)
- filesMode :: !Int
- filesSize :: !Int
- filesTarget :: !(Maybe Text)
- type FilesId = Key Files
- data SourceFiles = SourceFiles {
- sourceFilesSource_id :: !(Key Sources)
- sourceFilesFile_id :: !(Key Files)
- type SourceFilesId = Key SourceFiles
- data BuildFiles = BuildFiles {
- buildFilesBuild_id :: !(Key Builds)
- buildFilesFile_id :: !(Key Files)
- type BuildFilesId = Key BuildFiles
- data KeyVal = KeyVal {
- keyValKey_value :: !KeyType
- keyValVal_value :: !(Maybe Text)
- keyValExt_value :: !(Maybe Text)
- type KeyValId = Key KeyVal
- data ProjectKeyValues = ProjectKeyValues {
- projectKeyValuesPackage_id :: !(Key Projects)
- projectKeyValuesKey_val_id :: !(Key KeyVal)
- type ProjectKeyValuesId = Key ProjectKeyValues
- data SourceKeyValues = SourceKeyValues {
- sourceKeyValuesSource_id :: !(Key Sources)
- sourceKeyValuesKey_val_id :: !(Key KeyVal)
- type SourceKeyValuesId = Key SourceKeyValues
- data BuildKeyValues = BuildKeyValues {
- buildKeyValuesBuild_id :: !(Key Builds)
- buildKeyValuesKey_val_id :: !(Key KeyVal)
- type BuildKeyValuesId = Key BuildKeyValues
- data FileKeyValues = FileKeyValues {
- fileKeyValuesFile_id :: !(Key Files)
- fileKeyValuesKey_val_id :: !(Key KeyVal)
- type FileKeyValuesId = Key FileKeyValues
- data Groups = Groups {
- groupsName :: !Text
- groupsGroup_type :: !Text
- groupsBuild_id :: !(Maybe (Key Builds))
- type GroupsId = Key Groups
- data GroupFiles = GroupFiles {
- groupFilesGroup_id :: !(Key Groups)
- groupFilesFile_id :: !(Key Files)
- type GroupFilesId = Key GroupFiles
- data GroupGroups = GroupGroups {
- groupGroupsParent_group_id :: !(Key Groups)
- groupGroupsChild_group_id :: !(Key Groups)
- type GroupGroupsId = Key GroupGroups
- data GroupKeyValues = GroupKeyValues {
- groupKeyValuesGroup_id :: !(Key Groups)
- groupKeyValuesKey_val_id :: !(Key KeyVal)
- type GroupKeyValuesId = Key GroupKeyValues
- data Requirements = Requirements {}
- type RequirementsId = Key Requirements
- data GroupRequirements = GroupRequirements {
- groupRequirementsGroup_id :: !(Key Groups)
- groupRequirementsReq_id :: !(Key Requirements)
- type GroupRequirementsId = Key GroupRequirements
- data Scripts = Scripts {
- scriptsTy :: !Text
- scriptsBody :: !Text
- scriptsTrigger_prog :: !(Maybe Text)
- scriptsTrigger_index :: !(Maybe Int)
- scriptsTrigger_name :: !(Maybe Text)
- scriptsTrigger_version :: !(Maybe Text)
- scriptsTrigger_flags :: !(Maybe Int)
- type ScriptsId = Key Scripts
- data GroupScripts = GroupScripts {
- groupScriptsGroup_id :: !(Key Groups)
- groupScriptsScript_id :: !(Key Scripts)
- type GroupScriptsId = Key GroupScripts
- migrateAll :: Migration
- firstEntityResult :: Monad m => m [Entity a] -> m (Maybe a)
- firstKeyResult :: Monad m => m [Value a] -> m (Maybe a)
- maybeKey :: MonadIO m => m b -> (t -> m b) -> m (Maybe t) -> m b
- (==?) :: (PersistField typ, Esqueleto query expr backend) => expr (Value (Maybe typ)) -> Maybe typ -> expr (Value Bool)
- orDo :: MonadIO m => m (Maybe b) -> m b -> m b
- orInsert :: (MonadIO m, PersistEntity a, ToBackendKey SqlBackend a) => SqlPersistT m (Maybe (Key a)) -> a -> SqlPersistT m (Key a)
Documentation
schemaVersion :: Int64 Source #
The database schema version as implemented by this module. This must match the PRAGMA user_version value in schema.sql, shipped elsewhere in the source.
getDbVersion :: (MonadError String m, MonadIO m) => SqlPersistT m Int64 Source #
Return the version number stored in the database.
checkDbVersion :: (MonadError String m, MonadIO m) => SqlPersistT m () Source #
Verify that the version number stored in the database matches the schema version number implemented by this module. If there is a version mismatch, throw an error.
checkAndRunSqlite :: (MonadError String m, MonadBaseControl IO m, MonadIO m) => Text -> SqlPersistT (NoLoggingT (ResourceT m)) a -> m a Source #
Like runSqlite, but first checks that the database's schema version
matches what is expected. This prevents running against incompatible database versions.
Constructors
| Projects | |
Fields
| |
Instances
| Eq Projects Source # | |
| Show Projects Source # | |
| PersistEntity Projects Source # | |
| ToJSON Projects Source # | |
| PersistFieldSql Projects Source # | |
| PersistField Projects Source # | |
| FromJSON Projects Source # | |
| ToBackendKey SqlBackend Projects Source # | |
| Eq (Key Projects) Source # | |
| Ord (Key Projects) Source # | |
| Read (Key Projects) Source # | |
| Show (Key Projects) Source # | |
| ToJSON (Key Projects) Source # | |
| ToHttpApiData (Key Projects) Source # | |
| PersistFieldSql (Key Projects) Source # | |
| PersistField (Key Projects) Source # | |
| PathPiece (Key Projects) Source # | |
| FromJSON (Key Projects) Source # | |
| FromHttpApiData (Key Projects) Source # | |
| data Key Projects Source # | |
| type PersistEntityBackend Projects Source # | |
| data EntityField Projects Source # | |
| data Unique Projects Source # | |
type ProjectsId = Key Projects Source #
Constructors
| Sources | |
Fields
| |
Instances
| Eq Sources Source # | |
| Show Sources Source # | |
| PersistEntity Sources Source # | |
| PersistFieldSql Sources Source # | |
| PersistField Sources Source # | |
| ToBackendKey SqlBackend Sources Source # | |
| Eq (Key Sources) Source # | |
| Ord (Key Sources) Source # | |
| Read (Key Sources) Source # | |
| Show (Key Sources) Source # | |
| ToJSON (Key Sources) Source # | |
| ToHttpApiData (Key Sources) Source # | |
| PersistFieldSql (Key Sources) Source # | |
| PersistField (Key Sources) Source # | |
| PathPiece (Key Sources) Source # | |
| FromJSON (Key Sources) Source # | |
| FromHttpApiData (Key Sources) Source # | |
| data Key Sources Source # | |
| type PersistEntityBackend Sources Source # | |
| data EntityField Sources Source # | |
| data Unique Sources Source # | |
Constructors
| Builds | |
Fields
| |
Instances
| Eq Builds Source # | |
| Show Builds Source # | |
| PersistEntity Builds Source # | |
| PersistFieldSql Builds Source # | |
| PersistField Builds Source # | |
| ToBackendKey SqlBackend Builds Source # | |
| Eq (Key Builds) Source # | |
| Ord (Key Builds) Source # | |
| Read (Key Builds) Source # | |
| Show (Key Builds) Source # | |
| ToJSON (Key Builds) Source # | |
| ToHttpApiData (Key Builds) Source # | |
| PersistFieldSql (Key Builds) Source # | |
| PersistField (Key Builds) Source # | |
| PathPiece (Key Builds) Source # | |
| FromJSON (Key Builds) Source # | |
| FromHttpApiData (Key Builds) Source # | |
| data Key Builds Source # | |
| type PersistEntityBackend Builds Source # | |
| data EntityField Builds Source # | |
| data Unique Builds Source # | |
data BuildSignatures Source #
Constructors
| BuildSignatures | |
Fields
| |
Instances
| Eq BuildSignatures Source # | |
| Show BuildSignatures Source # | |
| PersistEntity BuildSignatures Source # | |
| PersistFieldSql BuildSignatures Source # | |
| PersistField BuildSignatures Source # | |
| ToBackendKey SqlBackend BuildSignatures Source # | |
| Eq (Key BuildSignatures) Source # | |
| Ord (Key BuildSignatures) Source # | |
| Read (Key BuildSignatures) Source # | |
| Show (Key BuildSignatures) Source # | |
| ToJSON (Key BuildSignatures) Source # | |
| ToHttpApiData (Key BuildSignatures) Source # | |
| PersistFieldSql (Key BuildSignatures) Source # | |
| PersistField (Key BuildSignatures) Source # | |
| PathPiece (Key BuildSignatures) Source # | |
| FromJSON (Key BuildSignatures) Source # | |
| FromHttpApiData (Key BuildSignatures) Source # | |
| data Key BuildSignatures Source # | |
| type PersistEntityBackend BuildSignatures Source # | |
| data EntityField BuildSignatures Source # | |
| data Unique BuildSignatures Source # | |
type BuildSignaturesId = Key BuildSignatures Source #
Constructors
| Files | |
Fields
| |
Instances
| Eq Files Source # | |
| Show Files Source # | |
| PersistEntity Files Source # | |
| PersistFieldSql Files Source # | |
| PersistField Files Source # | |
| ToBackendKey SqlBackend Files Source # | |
| Eq (Key Files) Source # | |
| Ord (Key Files) Source # | |
| Read (Key Files) Source # | |
| Show (Key Files) Source # | |
| ToJSON (Key Files) Source # | |
| ToHttpApiData (Key Files) Source # | |
| PersistFieldSql (Key Files) Source # | |
| PersistField (Key Files) Source # | |
| PathPiece (Key Files) Source # | |
| FromJSON (Key Files) Source # | |
| FromHttpApiData (Key Files) Source # | |
| data Key Files Source # | |
| type PersistEntityBackend Files Source # | |
| data EntityField Files Source # | |
| data Unique Files Source # | |
data SourceFiles Source #
Constructors
| SourceFiles | |
Fields
| |
Instances
| Eq SourceFiles Source # | |
| Show SourceFiles Source # | |
| PersistEntity SourceFiles Source # | |
| PersistFieldSql SourceFiles Source # | |
| PersistField SourceFiles Source # | |
| ToBackendKey SqlBackend SourceFiles Source # | |
| Eq (Key SourceFiles) Source # | |
| Ord (Key SourceFiles) Source # | |
| Read (Key SourceFiles) Source # | |
| Show (Key SourceFiles) Source # | |
| ToJSON (Key SourceFiles) Source # | |
| ToHttpApiData (Key SourceFiles) Source # | |
| PersistFieldSql (Key SourceFiles) Source # | |
| PersistField (Key SourceFiles) Source # | |
| PathPiece (Key SourceFiles) Source # | |
| FromJSON (Key SourceFiles) Source # | |
| FromHttpApiData (Key SourceFiles) Source # | |
| data Key SourceFiles Source # | |
| type PersistEntityBackend SourceFiles Source # | |
| data EntityField SourceFiles Source # | |
| data Unique SourceFiles Source # | |
type SourceFilesId = Key SourceFiles Source #
data BuildFiles Source #
Constructors
| BuildFiles | |
Fields
| |
Instances
| Eq BuildFiles Source # | |
| Show BuildFiles Source # | |
| PersistEntity BuildFiles Source # | |
| PersistFieldSql BuildFiles Source # | |
| PersistField BuildFiles Source # | |
| ToBackendKey SqlBackend BuildFiles Source # | |
| Eq (Key BuildFiles) Source # | |
| Ord (Key BuildFiles) Source # | |
| Read (Key BuildFiles) Source # | |
| Show (Key BuildFiles) Source # | |
| ToJSON (Key BuildFiles) Source # | |
| ToHttpApiData (Key BuildFiles) Source # | |
| PersistFieldSql (Key BuildFiles) Source # | |
| PersistField (Key BuildFiles) Source # | |
| PathPiece (Key BuildFiles) Source # | |
| FromJSON (Key BuildFiles) Source # | |
| FromHttpApiData (Key BuildFiles) Source # | |
| data Key BuildFiles Source # | |
| type PersistEntityBackend BuildFiles Source # | |
| data EntityField BuildFiles Source # | |
| data Unique BuildFiles Source # | |
type BuildFilesId = Key BuildFiles Source #
Constructors
| KeyVal | |
Fields
| |
Instances
| Eq KeyVal Source # | |
| Show KeyVal Source # | |
| PersistEntity KeyVal Source # | |
| ToJSON KeyVal Source # | |
| PersistFieldSql KeyVal Source # | |
| PersistField KeyVal Source # | |
| ToBackendKey SqlBackend KeyVal Source # | |
| Eq (Key KeyVal) Source # | |
| Ord (Key KeyVal) Source # | |
| Read (Key KeyVal) Source # | |
| Show (Key KeyVal) Source # | |
| ToJSON (Key KeyVal) Source # | |
| ToHttpApiData (Key KeyVal) Source # | |
| PersistFieldSql (Key KeyVal) Source # | |
| PersistField (Key KeyVal) Source # | |
| PathPiece (Key KeyVal) Source # | |
| FromJSON (Key KeyVal) Source # | |
| FromHttpApiData (Key KeyVal) Source # | |
| data Key KeyVal Source # | |
| type PersistEntityBackend KeyVal Source # | |
| data EntityField KeyVal Source # | |
| data Unique KeyVal Source # | |
data ProjectKeyValues Source #
Constructors
| ProjectKeyValues | |
Fields
| |
Instances
| Eq ProjectKeyValues Source # | |
| Show ProjectKeyValues Source # | |
| PersistEntity ProjectKeyValues Source # | |
| PersistFieldSql ProjectKeyValues Source # | |
| PersistField ProjectKeyValues Source # | |
| ToBackendKey SqlBackend ProjectKeyValues Source # | |
| Eq (Key ProjectKeyValues) Source # | |
| Ord (Key ProjectKeyValues) Source # | |
| Read (Key ProjectKeyValues) Source # | |
| Show (Key ProjectKeyValues) Source # | |
| ToJSON (Key ProjectKeyValues) Source # | |
| ToHttpApiData (Key ProjectKeyValues) Source # | |
| PersistFieldSql (Key ProjectKeyValues) Source # | |
| PersistField (Key ProjectKeyValues) Source # | |
| PathPiece (Key ProjectKeyValues) Source # | |
| FromJSON (Key ProjectKeyValues) Source # | |
| FromHttpApiData (Key ProjectKeyValues) Source # | |
| data Key ProjectKeyValues Source # | |
| type PersistEntityBackend ProjectKeyValues Source # | |
| data EntityField ProjectKeyValues Source # | |
| data Unique ProjectKeyValues Source # | |
type ProjectKeyValuesId = Key ProjectKeyValues Source #
data SourceKeyValues Source #
Constructors
| SourceKeyValues | |
Fields
| |
Instances
| Eq SourceKeyValues Source # | |
| Show SourceKeyValues Source # | |
| PersistEntity SourceKeyValues Source # | |
| PersistFieldSql SourceKeyValues Source # | |
| PersistField SourceKeyValues Source # | |
| ToBackendKey SqlBackend SourceKeyValues Source # | |
| Eq (Key SourceKeyValues) Source # | |
| Ord (Key SourceKeyValues) Source # | |
| Read (Key SourceKeyValues) Source # | |
| Show (Key SourceKeyValues) Source # | |
| ToJSON (Key SourceKeyValues) Source # | |
| ToHttpApiData (Key SourceKeyValues) Source # | |
| PersistFieldSql (Key SourceKeyValues) Source # | |
| PersistField (Key SourceKeyValues) Source # | |
| PathPiece (Key SourceKeyValues) Source # | |
| FromJSON (Key SourceKeyValues) Source # | |
| FromHttpApiData (Key SourceKeyValues) Source # | |
| data Key SourceKeyValues Source # | |
| type PersistEntityBackend SourceKeyValues Source # | |
| data EntityField SourceKeyValues Source # | |
| data Unique SourceKeyValues Source # | |
type SourceKeyValuesId = Key SourceKeyValues Source #
data BuildKeyValues Source #
Constructors
| BuildKeyValues | |
Fields
| |
Instances
| Eq BuildKeyValues Source # | |
| Show BuildKeyValues Source # | |
| PersistEntity BuildKeyValues Source # | |
| PersistFieldSql BuildKeyValues Source # | |
| PersistField BuildKeyValues Source # | |
| ToBackendKey SqlBackend BuildKeyValues Source # | |
| Eq (Key BuildKeyValues) Source # | |
| Ord (Key BuildKeyValues) Source # | |
| Read (Key BuildKeyValues) Source # | |
| Show (Key BuildKeyValues) Source # | |
| ToJSON (Key BuildKeyValues) Source # | |
| ToHttpApiData (Key BuildKeyValues) Source # | |
| PersistFieldSql (Key BuildKeyValues) Source # | |
| PersistField (Key BuildKeyValues) Source # | |
| PathPiece (Key BuildKeyValues) Source # | |
| FromJSON (Key BuildKeyValues) Source # | |
| FromHttpApiData (Key BuildKeyValues) Source # | |
| data Key BuildKeyValues Source # | |
| type PersistEntityBackend BuildKeyValues Source # | |
| data EntityField BuildKeyValues Source # | |
| data Unique BuildKeyValues Source # | |
type BuildKeyValuesId = Key BuildKeyValues Source #
data FileKeyValues Source #
Constructors
| FileKeyValues | |
Fields
| |
Instances
| Eq FileKeyValues Source # | |
| Show FileKeyValues Source # | |
| PersistEntity FileKeyValues Source # | |
| PersistFieldSql FileKeyValues Source # | |
| PersistField FileKeyValues Source # | |
| ToBackendKey SqlBackend FileKeyValues Source # | |
| Eq (Key FileKeyValues) Source # | |
| Ord (Key FileKeyValues) Source # | |
| Read (Key FileKeyValues) Source # | |
| Show (Key FileKeyValues) Source # | |
| ToJSON (Key FileKeyValues) Source # | |
| ToHttpApiData (Key FileKeyValues) Source # | |
| PersistFieldSql (Key FileKeyValues) Source # | |
| PersistField (Key FileKeyValues) Source # | |
| PathPiece (Key FileKeyValues) Source # | |
| FromJSON (Key FileKeyValues) Source # | |
| FromHttpApiData (Key FileKeyValues) Source # | |
| data Key FileKeyValues Source # | |
| type PersistEntityBackend FileKeyValues Source # | |
| data EntityField FileKeyValues Source # | |
| data Unique FileKeyValues Source # | |
type FileKeyValuesId = Key FileKeyValues Source #
Constructors
| Groups | |
Fields
| |
Instances
| Eq Groups Source # | |
| Show Groups Source # | |
| PersistEntity Groups Source # | |
| PersistFieldSql Groups Source # | |
| PersistField Groups Source # | |
| ToBackendKey SqlBackend Groups Source # | |
| Eq (Key Groups) Source # | |
| Ord (Key Groups) Source # | |
| Read (Key Groups) Source # | |
| Show (Key Groups) Source # | |
| ToJSON (Key Groups) Source # | |
| ToHttpApiData (Key Groups) Source # | |
| PersistFieldSql (Key Groups) Source # | |
| PersistField (Key Groups) Source # | |
| PathPiece (Key Groups) Source # | |
| FromJSON (Key Groups) Source # | |
| FromHttpApiData (Key Groups) Source # | |
| data Key Groups Source # | |
| type PersistEntityBackend Groups Source # | |
| data EntityField Groups Source # | |
| data Unique Groups Source # | |
data GroupFiles Source #
Constructors
| GroupFiles | |
Fields
| |
Instances
| Eq GroupFiles Source # | |
| Show GroupFiles Source # | |
| PersistEntity GroupFiles Source # | |
| PersistFieldSql GroupFiles Source # | |
| PersistField GroupFiles Source # | |
| ToBackendKey SqlBackend GroupFiles Source # | |
| Eq (Key GroupFiles) Source # | |
| Ord (Key GroupFiles) Source # | |
| Read (Key GroupFiles) Source # | |
| Show (Key GroupFiles) Source # | |
| ToJSON (Key GroupFiles) Source # | |
| ToHttpApiData (Key GroupFiles) Source # | |
| PersistFieldSql (Key GroupFiles) Source # | |
| PersistField (Key GroupFiles) Source # | |
| PathPiece (Key GroupFiles) Source # | |
| FromJSON (Key GroupFiles) Source # | |
| FromHttpApiData (Key GroupFiles) Source # | |
| data Key GroupFiles Source # | |
| type PersistEntityBackend GroupFiles Source # | |
| data EntityField GroupFiles Source # | |
| data Unique GroupFiles Source # | |
type GroupFilesId = Key GroupFiles Source #
data GroupGroups Source #
Constructors
| GroupGroups | |
Fields
| |
Instances
| Eq GroupGroups Source # | |
| Show GroupGroups Source # | |
| PersistEntity GroupGroups Source # | |
| PersistFieldSql GroupGroups Source # | |
| PersistField GroupGroups Source # | |
| ToBackendKey SqlBackend GroupGroups Source # | |
| Eq (Key GroupGroups) Source # | |
| Ord (Key GroupGroups) Source # | |
| Read (Key GroupGroups) Source # | |
| Show (Key GroupGroups) Source # | |
| ToJSON (Key GroupGroups) Source # | |
| ToHttpApiData (Key GroupGroups) Source # | |
| PersistFieldSql (Key GroupGroups) Source # | |
| PersistField (Key GroupGroups) Source # | |
| PathPiece (Key GroupGroups) Source # | |
| FromJSON (Key GroupGroups) Source # | |
| FromHttpApiData (Key GroupGroups) Source # | |
| data Key GroupGroups Source # | |
| type PersistEntityBackend GroupGroups Source # | |
| data EntityField GroupGroups Source # | |
| data Unique GroupGroups Source # | |
type GroupGroupsId = Key GroupGroups Source #
data GroupKeyValues Source #
Constructors
| GroupKeyValues | |
Fields
| |
Instances
| Eq GroupKeyValues Source # | |
| Show GroupKeyValues Source # | |
| PersistEntity GroupKeyValues Source # | |
| PersistFieldSql GroupKeyValues Source # | |
| PersistField GroupKeyValues Source # | |
| ToBackendKey SqlBackend GroupKeyValues Source # | |
| Eq (Key GroupKeyValues) Source # | |
| Ord (Key GroupKeyValues) Source # | |
| Read (Key GroupKeyValues) Source # | |
| Show (Key GroupKeyValues) Source # | |
| ToJSON (Key GroupKeyValues) Source # | |
| ToHttpApiData (Key GroupKeyValues) Source # | |
| PersistFieldSql (Key GroupKeyValues) Source # | |
| PersistField (Key GroupKeyValues) Source # | |
| PathPiece (Key GroupKeyValues) Source # | |
| FromJSON (Key GroupKeyValues) Source # | |
| FromHttpApiData (Key GroupKeyValues) Source # | |
| data Key GroupKeyValues Source # | |
| type PersistEntityBackend GroupKeyValues Source # | |
| data EntityField GroupKeyValues Source # | |
| data Unique GroupKeyValues Source # | |
type GroupKeyValuesId = Key GroupKeyValues Source #
data Requirements Source #
Constructors
| Requirements | |
Fields | |
Instances
| Eq Requirements Source # | |
| Show Requirements Source # | |
| PersistEntity Requirements Source # | |
| PersistFieldSql Requirements Source # | |
| PersistField Requirements Source # | |
| ToBackendKey SqlBackend Requirements Source # | |
| Eq (Key Requirements) Source # | |
| Ord (Key Requirements) Source # | |
| Read (Key Requirements) Source # | |
| Show (Key Requirements) Source # | |
| ToJSON (Key Requirements) Source # | |
| ToHttpApiData (Key Requirements) Source # | |
| PersistFieldSql (Key Requirements) Source # | |
| PersistField (Key Requirements) Source # | |
| PathPiece (Key Requirements) Source # | |
| FromJSON (Key Requirements) Source # | |
| FromHttpApiData (Key Requirements) Source # | |
| data Key Requirements Source # | |
| type PersistEntityBackend Requirements Source # | |
| data EntityField Requirements Source # | |
| data Unique Requirements Source # | |
type RequirementsId = Key Requirements Source #
data GroupRequirements Source #
Constructors
| GroupRequirements | |
Fields
| |
Instances
| Eq GroupRequirements Source # | |
| Show GroupRequirements Source # | |
| PersistEntity GroupRequirements Source # | |
| PersistFieldSql GroupRequirements Source # | |
| PersistField GroupRequirements Source # | |
| ToBackendKey SqlBackend GroupRequirements Source # | |
| Eq (Key GroupRequirements) Source # | |
| Ord (Key GroupRequirements) Source # | |
| Read (Key GroupRequirements) Source # | |
| Show (Key GroupRequirements) Source # | |
| ToJSON (Key GroupRequirements) Source # | |
| ToHttpApiData (Key GroupRequirements) Source # | |
| PersistFieldSql (Key GroupRequirements) Source # | |
| PersistField (Key GroupRequirements) Source # | |
| PathPiece (Key GroupRequirements) Source # | |
| FromJSON (Key GroupRequirements) Source # | |
| FromHttpApiData (Key GroupRequirements) Source # | |
| data Key GroupRequirements Source # | |
| type PersistEntityBackend GroupRequirements Source # | |
| data EntityField GroupRequirements Source # | |
| data Unique GroupRequirements Source # | |
type GroupRequirementsId = Key GroupRequirements Source #
Constructors
| Scripts | |
Fields
| |
Instances
| Eq Scripts Source # | |
| Show Scripts Source # | |
| PersistEntity Scripts Source # | |
| PersistFieldSql Scripts Source # | |
| PersistField Scripts Source # | |
| ToBackendKey SqlBackend Scripts Source # | |
| Eq (Key Scripts) Source # | |
| Ord (Key Scripts) Source # | |
| Read (Key Scripts) Source # | |
| Show (Key Scripts) Source # | |
| ToJSON (Key Scripts) Source # | |
| ToHttpApiData (Key Scripts) Source # | |
| PersistFieldSql (Key Scripts) Source # | |
| PersistField (Key Scripts) Source # | |
| PathPiece (Key Scripts) Source # | |
| FromJSON (Key Scripts) Source # | |
| FromHttpApiData (Key Scripts) Source # | |
| data Key Scripts Source # | |
| type PersistEntityBackend Scripts Source # | |
| data EntityField Scripts Source # | |
| data Unique Scripts Source # | |
data GroupScripts Source #
Constructors
| GroupScripts | |
Fields
| |
Instances
| Eq GroupScripts Source # | |
| Show GroupScripts Source # | |
| PersistEntity GroupScripts Source # | |
| PersistFieldSql GroupScripts Source # | |
| PersistField GroupScripts Source # | |
| ToBackendKey SqlBackend GroupScripts Source # | |
| Eq (Key GroupScripts) Source # | |
| Ord (Key GroupScripts) Source # | |
| Read (Key GroupScripts) Source # | |
| Show (Key GroupScripts) Source # | |
| ToJSON (Key GroupScripts) Source # | |
| ToHttpApiData (Key GroupScripts) Source # | |
| PersistFieldSql (Key GroupScripts) Source # | |
| PersistField (Key GroupScripts) Source # | |
| PathPiece (Key GroupScripts) Source # | |
| FromJSON (Key GroupScripts) Source # | |
| FromHttpApiData (Key GroupScripts) Source # | |
| data Key GroupScripts Source # | |
| type PersistEntityBackend GroupScripts Source # | |
| data EntityField GroupScripts Source # | |
| data Unique GroupScripts Source # | |
type GroupScriptsId = Key GroupScripts Source #
migrateAll :: Migration Source #
firstEntityResult :: Monad m => m [Entity a] -> m (Maybe a) Source #
Run an SQL query, returning the first Entity as a Maybe. Use this when you
want a single row out of the database.
firstKeyResult :: Monad m => m [Value a] -> m (Maybe a) Source #
Run an SQL query, returning the first key as a Maybe. Use this when you want a single index out of the database.
Arguments
| :: MonadIO m | |
| => m b | Default value |
| -> (t -> m b) | A function to run on the key |
| -> m (Maybe t) | A |
| -> m b |
Like maybe, but for keys. If the key is nothing, return the default value. Otherwise,
run the function on the key and return that value.
(==?) :: (PersistField typ, Esqueleto query expr backend) => expr (Value (Maybe typ)) -> Maybe typ -> expr (Value Bool) infix 4 Source #
Return a query fragment to match a Maybe value. If the value is Nothing, this is equivalent to (column is NULL) If the value is Just x, this is (value == column) Unlike the other Esqueleto operators, the right-hand value is not boxed in a Value, since we need to examine it in order to generate the correct SQL.
e.g., with a table like: > create table example ( > id integer primary key, > value text ); you could use an esqueleto query like: > select $ from $ example -> do > where_ $ maybeVal ==? (example ?. ExampleValue)