opaleye-0.3.1: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell98

Opaleye.Manipulation

Synopsis

Documentation

arrangeInsert :: Table columns a -> columns -> SqlInsert Source

arrangeInsertSql :: Table columns a -> columns -> String Source

runInsert :: Connection -> Table columns columns' -> columns -> IO Int64 Source

arrangeUpdate :: Table columnsW columnsR -> (columnsR -> columnsW) -> (columnsR -> Column PGBool) -> SqlUpdate Source

arrangeUpdateSql :: Table columnsW columnsR -> (columnsR -> columnsW) -> (columnsR -> Column PGBool) -> String Source

runUpdate :: Connection -> Table columnsW columnsR -> (columnsR -> columnsW) -> (columnsR -> Column PGBool) -> IO Int64 Source

arrangeDelete :: Table a columnsR -> (columnsR -> Column PGBool) -> SqlDelete Source

arrangeDeleteSql :: Table a columnsR -> (columnsR -> Column PGBool) -> String Source

runDelete :: Connection -> Table a columnsR -> (columnsR -> Column PGBool) -> IO Int64 Source

arrangeInsertReturning :: Unpackspec returned returned -> Table columnsW columnsR -> columnsW -> (columnsR -> returned) -> Returning SqlInsert Source

arrangeInsertReturningSql :: Unpackspec returned returned -> Table columnsW columnsR -> columnsW -> (columnsR -> returned) -> String Source

runInsertReturningExplicit :: QueryRunner returned haskells -> Unpackspec returned returned -> Connection -> Table columnsW columnsR -> columnsW -> (columnsR -> returned) -> IO [haskells] Source

runInsertReturning :: (Default QueryRunner returned haskells, Default Unpackspec returned returned) => Connection -> Table columnsW columnsR -> columnsW -> (columnsR -> returned) -> IO [haskells] Source

runInsertReturning's use of the Default typeclass means that the compiler will have trouble inferring types. It is strongly recommended that you provide full type signatures when using runInsertReturning.