Portability | unknown |
---|---|
Stability | experimental |
Maintainer | ex8k.hibino@gmail.com |
Safe Haskell | None |
This module provides typed Insert
running sequence
which intermediate structres are typed.
- type PreparedInsert a = PreparedStatement a ()
- prepare :: IConnection conn => conn -> Insert a -> IO (PreparedInsert a)
- prepareInsert :: IConnection conn => conn -> Insert a -> IO (PreparedInsert a)
- runPreparedInsert :: ToSql SqlValue a => PreparedInsert a -> a -> IO Integer
- runInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> a -> IO Integer
- mapInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [Integer]
- chunksInsertActions :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [IO [Integer]]
- chunksInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [[Integer]]
Documentation
type PreparedInsert a = PreparedStatement a ()Source
Typed prepared insert type.
prepare :: IConnection conn => conn -> Insert a -> IO (PreparedInsert a)Source
Typed prepare insert operation.
prepareInsert :: IConnection conn => conn -> Insert a -> IO (PreparedInsert a)Source
Same as prepare
.
runPreparedInsert :: ToSql SqlValue a => PreparedInsert a -> a -> IO IntegerSource
Bind parameters, execute statement and get execution result.
runInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> a -> IO IntegerSource
Prepare insert statement, bind parameters, execute statement and get execution result.
mapInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [Integer]Source
Prepare and insert each record.
chunksInsertActions :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [IO [Integer]]Source
Prepare and insert with chunk insert statement. Result is insert action list.
chunksInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [[Integer]]Source
Prepare and insert with chunk insert statement.