Documentation

Fields

• connPrepare :: Text -> IO Statement

  This function should prepare a Statement in the target database, which should allow for efficient query reuse.

• connInsertSql :: EntityDef -> [PersistValue] -> InsertSqlResult

  This function generates the SQL and values necessary for performing an insert against the database.

• connStmtMap :: IORef (Map Text Statement)

  A reference to the cache of statements. Statements are keyed by the Text queries that generated them.

• connClose :: IO ()

  Close the underlying connection.

• connMigrateSql :: [EntityDef] -> (Text -> IO Statement) -> EntityDef -> IO (Either [Text] [(Bool, Text)])

  This function returns the migrations required to include the EntityDef parameter in the [EntityDef] database. This might include creating a new table if the entity is not present, or altering an existing table if it is.

• connBegin :: (Text -> IO Statement) -> Maybe IsolationLevel -> IO ()

  A function to begin a transaction for the underlying database.

• connCommit :: (Text -> IO Statement) -> IO ()

  A function to commit a transaction to the underlying database.

• connRollback :: (Text -> IO Statement) -> IO ()

  A function to roll back a transaction on the underlying database.

• connEscapeFieldName :: FieldNameDB -> Text

  A function to extract and escape the name of the column corresponding to the provided field.

  Since: 2.12.0.0

• connEscapeTableName :: EntityDef -> Text

  A function to extract and escape the name of the table corresponding to the provided entity. PostgreSQL uses this to support schemas.

  Since: 2.12.0.0

• connEscapeRawName :: Text -> Text

  A function to escape raw DB identifiers. MySQL uses backticks, while PostgreSQL uses quotes, and so on.

  Since: 2.12.0.0

• connNoLimit :: Text
   
• connRDBMS :: Text

  A tag displaying what database the SqlBackend is for. Can be used to differentiate features in downstream libraries for different database backends.

• connLimitOffset :: (Int, Int) -> Text -> Text

  Attach a 'LIMIT/OFFSET' clause to a SQL query. Note that LIMIT/OFFSET is problematic for performance, and indexed range queries are the superior way to offer pagination.

• connLogFunc :: LogFunc

  A log function for the SqlBackend to use.