Safe Haskell	None
Language	Haskell2010

Database.Groundhog.Sqlite

Synopsis

withSqlitePool :: (MonadBaseControl IO m, MonadIO m) => String -> Int -> (Pool Sqlite -> m a) -> m a
withSqliteConn :: (MonadBaseControl IO m, MonadIO m) => String -> (Sqlite -> m a) -> m a
createSqlitePool :: MonadIO m => String -> Int -> m (Pool Sqlite)
runDbConn :: (MonadIO m, MonadBaseControl IO m, ConnectionManager conn, ExtractConnection cm conn) => Action conn a -> cm -> m a
data Sqlite = Sqlite Database (IORef (HashMap ByteString Statement))
module Database.Groundhog
module Database.Groundhog.Generic.Sql.Functions

Documentation

withSqlitePool Source #

Arguments

:: (MonadBaseControl IO m, MonadIO m)
=> String	connection string
-> Int	number of connections to open
-> (Pool Sqlite -> m a)
-> m a

withSqliteConn Source #

Arguments

:: (MonadBaseControl IO m, MonadIO m)
=> String	connection string
-> (Sqlite -> m a)
-> m a

createSqlitePool Source #

Arguments

:: MonadIO m
=> String	connection string
-> Int	number of connections to open
-> m (Pool Sqlite)

runDbConn :: (MonadIO m, MonadBaseControl IO m, ConnectionManager conn, ExtractConnection cm conn) => Action conn a -> cm -> m a #

Runs action within connection. It can handle a simple connection, a pool of them, etc.

data Sqlite Source #

Constructors

Sqlite Database (IORef (HashMap ByteString Statement))

Instances

Instances details

SchemaAnalyzer Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods schemaExists :: (PersistBackend m, Conn m ~ Sqlite) => String -> m Bool # getCurrentSchema :: (PersistBackend m, Conn m ~ Sqlite) => m (Maybe String) # listTables :: (PersistBackend m, Conn m ~ Sqlite) => Maybe String -> m [String] # listTableTriggers :: (PersistBackend m, Conn m ~ Sqlite) => QualifiedName -> m [String] # analyzeTable :: (PersistBackend m, Conn m ~ Sqlite) => QualifiedName -> m (Maybe TableInfo) # analyzeTrigger :: (PersistBackend m, Conn m ~ Sqlite) => QualifiedName -> m (Maybe String) # analyzeFunction :: (PersistBackend m, Conn m ~ Sqlite) => QualifiedName -> m (Maybe (Maybe [DbTypePrimitive], Maybe DbTypePrimitive, String)) # getMigrationPack :: (PersistBackend m, Conn m ~ Sqlite) => m (MigrationPack Sqlite) #
SqlDb Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods append :: (ExpressionOf Sqlite r a String, ExpressionOf Sqlite r b String) => a -> b -> Expr Sqlite r String # signum' :: (ExpressionOf Sqlite r x a, Num a) => x -> Expr Sqlite r a # quotRem' :: (ExpressionOf Sqlite r x a, ExpressionOf Sqlite r y a, Integral a) => x -> y -> (Expr Sqlite r a, Expr Sqlite r a) # equalsOperator :: RenderS Sqlite r -> RenderS Sqlite r -> RenderS Sqlite r # notEqualsOperator :: RenderS Sqlite r -> RenderS Sqlite r -> RenderS Sqlite r #
DbDescriptor Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Associated Types type AutoKeyType Sqlite # type QueryRaw Sqlite :: Type -> Type # Methods backendName :: proxy Sqlite -> String #
PersistBackendConn Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods insert :: (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => v -> m (AutoKey v) # insert_ :: (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => v -> m () # insertBy :: (PersistEntity v, IsUniqueKey (Key v (Unique u)), PersistBackend m, Conn m ~ Sqlite) => u (UniqueMarker v) -> v -> m (Either (AutoKey v) (AutoKey v)) # insertByAll :: (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => v -> m (Either (AutoKey v) (AutoKey v)) # replace :: (PersistEntity v, PrimitivePersistField (Key v BackendSpecific), PersistBackend m, Conn m ~ Sqlite) => Key v BackendSpecific -> v -> m () # replaceBy :: (PersistEntity v, IsUniqueKey (Key v (Unique u)), PersistBackend m, Conn m ~ Sqlite) => u (UniqueMarker v) -> v -> m () # select :: forall v (c :: (Type -> Type) -> Type) opts m. (PersistEntity v, EntityConstr v c, HasSelectOptions opts Sqlite (RestrictionHolder v c), PersistBackend m, Conn m ~ Sqlite) => opts -> m [v] # selectStream :: forall v (c :: (Type -> Type) -> Type) opts m. (PersistEntity v, EntityConstr v c, HasSelectOptions opts Sqlite (RestrictionHolder v c), PersistBackend m, Conn m ~ Sqlite) => opts -> m (RowStream v) # selectAll :: (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => m [(AutoKey v, v)] # selectAllStream :: (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => m (RowStream (AutoKey v, v)) # get :: (PersistEntity v, PrimitivePersistField (Key v BackendSpecific), PersistBackend m, Conn m ~ Sqlite) => Key v BackendSpecific -> m (Maybe v) # getBy :: forall v (u :: (Type -> Type) -> Type) m. (PersistEntity v, IsUniqueKey (Key v (Unique u)), PersistBackend m, Conn m ~ Sqlite) => Key v (Unique u) -> m (Maybe v) # update :: forall v (c :: (Type -> Type) -> Type) m. (PersistEntity v, EntityConstr v c, PersistBackend m, Conn m ~ Sqlite) => [Update Sqlite (RestrictionHolder v c)] -> Cond Sqlite (RestrictionHolder v c) -> m () # delete :: forall v (c :: (Type -> Type) -> Type) m. (PersistEntity v, EntityConstr v c, PersistBackend m, Conn m ~ Sqlite) => Cond Sqlite (RestrictionHolder v c) -> m () # deleteBy :: (PersistEntity v, PrimitivePersistField (Key v BackendSpecific), PersistBackend m, Conn m ~ Sqlite) => Key v BackendSpecific -> m () # deleteAll :: (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => v -> m () # count :: forall v (c :: (Type -> Type) -> Type) m. (PersistEntity v, EntityConstr v c, PersistBackend m, Conn m ~ Sqlite) => Cond Sqlite (RestrictionHolder v c) -> m Int # countAll :: (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => v -> m Int # project :: forall v (c :: (Type -> Type) -> Type) p a opts m. (PersistEntity v, EntityConstr v c, Projection' p Sqlite (RestrictionHolder v c) a, HasSelectOptions opts Sqlite (RestrictionHolder v c), PersistBackend m, Conn m ~ Sqlite) => p -> opts -> m [a] # projectStream :: forall v (c :: (Type -> Type) -> Type) p a opts m. (PersistEntity v, EntityConstr v c, Projection' p Sqlite (RestrictionHolder v c) a, HasSelectOptions opts Sqlite (RestrictionHolder v c), PersistBackend m, Conn m ~ Sqlite) => p -> opts -> m (RowStream a) # migrate :: forall v (m :: Type -> Type). (PersistEntity v, PersistBackend m, Conn m ~ Sqlite) => v -> Migration m # executeRaw :: (PersistBackend m, Conn m ~ Sqlite) => Bool -> String -> [PersistValue] -> m () # queryRaw :: (PersistBackend m, Conn m ~ Sqlite) => Bool -> String -> [PersistValue] -> m (RowStream [PersistValue]) # insertList :: (PersistField a, PersistBackend m, Conn m ~ Sqlite) => [a] -> m Int64 # getList :: (PersistField a, PersistBackend m, Conn m ~ Sqlite) => Int64 -> m [a] #
ConnectionManager Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods withConn :: (MonadBaseControl IO m, MonadIO m) => (Sqlite -> m a) -> Sqlite -> m a #
TryConnectionManager Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods tryWithConn :: (MonadBaseControl IO m, MonadIO m, MonadCatch m) => (Sqlite -> n a) -> (n a -> m (Either SomeException a)) -> Sqlite -> m (Either SomeException a) #
Savepoint Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods withConnSavepoint :: (MonadBaseControl IO m, MonadIO m) => String -> m a -> Sqlite -> m a #
ExtractConnection Sqlite Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods extractConn :: (MonadBaseControl IO m, MonadIO m) => (Sqlite -> m a) -> Sqlite -> m a #
ExtractConnection (Pool Sqlite) Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite Methods extractConn :: (MonadBaseControl IO m, MonadIO m) => (Sqlite -> m a) -> Pool Sqlite -> m a #
type QueryRaw Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite type QueryRaw Sqlite = Snippet Sqlite
type AutoKeyType Sqlite Source #
Instance details Defined in Database.Groundhog.Sqlite type AutoKeyType Sqlite = Int64

module Database.Groundhog

module Database.Groundhog.Generic.Sql.Functions