Copyright | 2013 Kei Hibino |
---|---|
License | BSD3 |
Maintainer | ex8k.hibino@gmail.com |
Stability | experimental |
Portability | unknown |
Safe Haskell | None |
Language | Haskell2010 |
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 Integer Source
Bind parameters, execute statement and get execution result.
runInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> a -> IO Integer Source
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.