Database.HDBC.Record.Insert

This module provides typed Insert running sequence which intermediate structres 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.

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

Prepare and insert with chunk insert statement. Result is insert action list.

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

Prepare and insert with chunk insert statement.