Safe Haskell	None
Language	Haskell2010

Database.Beam.Sqlite.Connection

Contents

Emulated INSERT RETURNING support

Synopsis

data Sqlite = Sqlite
newtype SqliteM a = SqliteM {
- runSqliteM :: ReaderT (String -> IO (), Connection) IO a
}
sqliteUriSyntax :: c SqliteCommandSyntax Sqlite Connection SqliteM -> BeamURIOpeners c
runBeamSqlite :: Connection -> SqliteM a -> IO a
runBeamSqliteDebug :: (String -> IO ()) -> Connection -> SqliteM a -> IO a
data SqliteInsertReturning (table :: (* -> *) -> *)
insertReturning :: DatabaseEntity be db (TableEntity table) -> SqlInsertValues SqliteInsertValuesSyntax (table (QExpr SqliteExpressionSyntax s)) -> SqliteInsertReturning table
runInsertReturningList :: FromBackendRow Sqlite (table Identity) => SqliteInsertReturning table -> SqliteM [table Identity]

Documentation

data Sqlite Source #

The SQLite backend. Used to parameterize MonadBeam and FromBackendRow to provide support for SQLite databases. See the documentation for MonadBeam and the user guide for more information on how to use this backend.

Constructors

Sqlite

Instances

BeamSql92Backend Sqlite Source #
Instance details Defined in Database.Beam.Sqlite.Connection
BeamSqlBackend Sqlite Source #
Instance details Defined in Database.Beam.Sqlite.Connection
BeamBackend Sqlite Source #
Instance details Defined in Database.Beam.Sqlite.Connection Associated Types type BackendFromField Sqlite :: * -> Constraint #
FromBackendRow Sqlite Bool Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Bool # valuesNeeded :: Proxy Sqlite -> Proxy Bool -> Int #
FromBackendRow Sqlite Char Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Char # valuesNeeded :: Proxy Sqlite -> Proxy Char -> Int #
FromBackendRow Sqlite Double Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Double # valuesNeeded :: Proxy Sqlite -> Proxy Double -> Int #
FromBackendRow Sqlite Float Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Float # valuesNeeded :: Proxy Sqlite -> Proxy Float -> Int #
FromBackendRow Sqlite Int Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Int # valuesNeeded :: Proxy Sqlite -> Proxy Int -> Int #
FromBackendRow Sqlite Int8 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Int8 # valuesNeeded :: Proxy Sqlite -> Proxy Int8 -> Int #
FromBackendRow Sqlite Int16 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Int16 # valuesNeeded :: Proxy Sqlite -> Proxy Int16 -> Int #
FromBackendRow Sqlite Int32 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Int32 # valuesNeeded :: Proxy Sqlite -> Proxy Int32 -> Int #
FromBackendRow Sqlite Int64 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Int64 # valuesNeeded :: Proxy Sqlite -> Proxy Int64 -> Int #
FromBackendRow Sqlite Integer Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Integer # valuesNeeded :: Proxy Sqlite -> Proxy Integer -> Int #
FromBackendRow Sqlite Word Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Word # valuesNeeded :: Proxy Sqlite -> Proxy Word -> Int #
FromBackendRow Sqlite Word8 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Word8 # valuesNeeded :: Proxy Sqlite -> Proxy Word8 -> Int #
FromBackendRow Sqlite Word16 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Word16 # valuesNeeded :: Proxy Sqlite -> Proxy Word16 -> Int #
FromBackendRow Sqlite Word32 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Word32 # valuesNeeded :: Proxy Sqlite -> Proxy Word32 -> Int #
FromBackendRow Sqlite Word64 Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Word64 # valuesNeeded :: Proxy Sqlite -> Proxy Word64 -> Int #
FromBackendRow Sqlite ByteString Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite ByteString # valuesNeeded :: Proxy Sqlite -> Proxy ByteString -> Int #
FromBackendRow Sqlite ByteString Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite ByteString # valuesNeeded :: Proxy Sqlite -> Proxy ByteString -> Int #
FromBackendRow Sqlite Scientific Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Scientific # valuesNeeded :: Proxy Sqlite -> Proxy Scientific -> Int #
FromBackendRow Sqlite Text Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Text # valuesNeeded :: Proxy Sqlite -> Proxy Text -> Int #
FromBackendRow Sqlite UTCTime Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite UTCTime # valuesNeeded :: Proxy Sqlite -> Proxy UTCTime -> Int #
FromBackendRow Sqlite Text Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Text # valuesNeeded :: Proxy Sqlite -> Proxy Text -> Int #
FromBackendRow Sqlite SqlNull Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite SqlNull # valuesNeeded :: Proxy Sqlite -> Proxy SqlNull -> Int #
FromBackendRow Sqlite Null Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Null # valuesNeeded :: Proxy Sqlite -> Proxy Null -> Int #
FromBackendRow Sqlite LocalTime Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite LocalTime # valuesNeeded :: Proxy Sqlite -> Proxy LocalTime -> Int #
FromBackendRow Sqlite Day Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fromBackendRow :: FromBackendRowM Sqlite Day # valuesNeeded :: Proxy Sqlite -> Proxy Day -> Int #
MonadBeamInsertReturning SqliteCommandSyntax Sqlite Connection SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods runInsertReturningList :: (Beamable table, Projectible (Sql92ExpressionSyntax SqliteCommandSyntax) (table (QExpr (Sql92ExpressionSyntax SqliteCommandSyntax) ())), FromBackendRow Sqlite (table Identity)) => DatabaseEntity Sqlite db (TableEntity table) -> SqlInsertValues (Sql92InsertValuesSyntax (Sql92InsertSyntax SqliteCommandSyntax)) (table (QExpr (Sql92InsertExpressionSyntax (Sql92InsertSyntax SqliteCommandSyntax)) s)) -> SqliteM [table Identity] #
MonadBeam SqliteCommandSyntax Sqlite Connection SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods withDatabaseDebug :: (String -> IO ()) -> Connection -> SqliteM a -> IO a # withDatabase :: Connection -> SqliteM a -> IO a # runReturningMany :: FromBackendRow Sqlite x => SqliteCommandSyntax -> (SqliteM (Maybe x) -> SqliteM a) -> SqliteM a # runNoReturn :: SqliteCommandSyntax -> SqliteM () # runReturningOne :: FromBackendRow Sqlite x => SqliteCommandSyntax -> SqliteM (Maybe x) # runReturningList :: FromBackendRow Sqlite x => SqliteCommandSyntax -> SqliteM [x] #
type BackendFromField Sqlite Source #
Instance details Defined in Database.Beam.Sqlite.Connection type BackendFromField Sqlite = FromField

newtype SqliteM a Source #

MonadBeam instance inside whiche SQLite queries are run. See the user guide for more information

Constructors

SqliteM
Fields runSqliteM :: ReaderT (String -> IO (), Connection) IO a Run an IO action with access to a SQLite connection and a debug logging function, called or each query submitted on the connection.

Instances

Monad SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods (>>=) :: SqliteM a -> (a -> SqliteM b) -> SqliteM b # (>>) :: SqliteM a -> SqliteM b -> SqliteM b # return :: a -> SqliteM a # fail :: String -> SqliteM a #
Functor SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods fmap :: (a -> b) -> SqliteM a -> SqliteM b # (<$) :: a -> SqliteM b -> SqliteM a #
Applicative SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods pure :: a -> SqliteM a # (<>) :: SqliteM (a -> b) -> SqliteM a -> SqliteM b # liftA2 :: (a -> b -> c) -> SqliteM a -> SqliteM b -> SqliteM c # (>) :: SqliteM a -> SqliteM b -> SqliteM b # (<*) :: SqliteM a -> SqliteM b -> SqliteM a #
MonadIO SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods liftIO :: IO a -> SqliteM a #
MonadBeamInsertReturning SqliteCommandSyntax Sqlite Connection SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods runInsertReturningList :: (Beamable table, Projectible (Sql92ExpressionSyntax SqliteCommandSyntax) (table (QExpr (Sql92ExpressionSyntax SqliteCommandSyntax) ())), FromBackendRow Sqlite (table Identity)) => DatabaseEntity Sqlite db (TableEntity table) -> SqlInsertValues (Sql92InsertValuesSyntax (Sql92InsertSyntax SqliteCommandSyntax)) (table (QExpr (Sql92InsertExpressionSyntax (Sql92InsertSyntax SqliteCommandSyntax)) s)) -> SqliteM [table Identity] #
MonadBeam SqliteCommandSyntax Sqlite Connection SqliteM Source #
Instance details Defined in Database.Beam.Sqlite.Connection Methods withDatabaseDebug :: (String -> IO ()) -> Connection -> SqliteM a -> IO a # withDatabase :: Connection -> SqliteM a -> IO a # runReturningMany :: FromBackendRow Sqlite x => SqliteCommandSyntax -> (SqliteM (Maybe x) -> SqliteM a) -> SqliteM a # runNoReturn :: SqliteCommandSyntax -> SqliteM () # runReturningOne :: FromBackendRow Sqlite x => SqliteCommandSyntax -> SqliteM (Maybe x) # runReturningList :: FromBackendRow Sqlite x => SqliteCommandSyntax -> SqliteM [x] #

sqliteUriSyntax :: c SqliteCommandSyntax Sqlite Connection SqliteM -> BeamURIOpeners c Source #

URI syntax for use with withDbConnection. See documentation for BeamURIOpeners for more information.

runBeamSqlite :: Connection -> SqliteM a -> IO a Source #

runBeamSqliteDebug :: (String -> IO ()) -> Connection -> SqliteM a -> IO a Source #

Emulated `INSERT RETURNING` support

data SqliteInsertReturning (table :: (* -> *) -> *) Source #

Represents an INSERT statement, from which we can retrieve inserted rows. Beam also offers a backend-agnostic way of using this functionality in the MonadBeamInsertReturning extension. This functionality is emulated in SQLite using a temporary table and a trigger.

insertReturning :: DatabaseEntity be db (TableEntity table) -> SqlInsertValues SqliteInsertValuesSyntax (table (QExpr SqliteExpressionSyntax s)) -> SqliteInsertReturning table Source #

Build a SqliteInsertReturning representing inserting the given values into the given table. Use runInsertReturningList

runInsertReturningList :: FromBackendRow Sqlite (table Identity) => SqliteInsertReturning table -> SqliteM [table Identity] Source #

Runs a SqliteInsertReturning statement and returns a result for each inserted row.

Documentation

Emulated INSERT RETURNING support

Emulated `INSERT RETURNING` support