Database.HDBC.Record.Insert

This module provides typed Insert running sequence which intermediate structures are typed.

Documentation

type PreparedInsert a = PreparedStatement a ()

Typed prepared insert type.

prepare :: IConnection conn => conn -> Insert a -> IO (PreparedInsert a)

Typed prepare insert operation.

prepareInsert :: IConnection conn => conn -> Insert a -> IO (PreparedInsert a)

Same as prepare.

runPreparedInsert :: ToSql SqlValue a => PreparedInsert a -> a -> IO Integer

Bind parameters, execute statement and get execution result.

runInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> a -> IO Integer

Prepare insert statement, bind parameters, execute statement and get execution result.

mapInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [Integer]

Prepare and insert each record.

bulkInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO ()

Prepare and insert using chunk insert statement.

bulkInsert' :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO ([Integer], [Integer])

Prepare and insert using chunk insert statement, with the results of insert statements.

bulkInsertInterleave :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO ([Integer], [Integer])

Prepare and insert using chunk insert statement, with the Lazy-IO results of insert statements.

chunksInsert :: (IConnection conn, ToSql SqlValue a) => conn -> Insert a -> [a] -> IO [[Integer]]

Deprecated: use bulkInsert' instead of this.

Deprecated. Use bulkInsert' instead of this. Prepare and insert using chunk insert statement.