Copyright | (c) 2016-2017 Red Hat Inc. |
---|---|
License | LGPL |
Maintainer | https://github.com/weldr |
Stability | alpha |
Portability | portable |
Safe Haskell | None |
Language | Haskell2010 |
The metadata database schema and miscellaneous database helper functions
- schemaVersion :: Int64
- getDbVersion :: 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 :: 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.
Projects | |
|
Eq Projects Source # | |
Show Projects Source # | |
PersistEntity Projects Source # | |
PersistFieldSql Projects Source # | |
PersistField 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 #
Sources | |
|
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 # | |
Builds | |
|
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 #
BuildSignatures | |
|
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 #
Files | |
|
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 #
SourceFiles | |
|
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 #
BuildFiles | |
|
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 #
KeyVal | |
|
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 #
ProjectKeyValues | |
|
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 #
SourceKeyValues | |
|
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 #
BuildKeyValues | |
|
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 #
FileKeyValues | |
|
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 #
Groups | |
|
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 #
GroupFiles | |
|
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 #
GroupGroups | |
|
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 #
GroupKeyValues | |
|
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 #
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 #
GroupRequirements | |
|
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 #
Scripts | |
|
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 #
GroupScripts | |
|
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.
:: 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)