Database.Selda.Debug

Functionality for inspecting and debugging Selda queries.

Documentation

data OnError

Constructors

Fail

Ignore

Instances

Eq OnError

Defined in Database.Selda.Table.Compile

Methods

(==) :: OnError -> OnError -> Bool

(/=) :: OnError -> OnError -> Bool

Ord OnError

Defined in Database.Selda.Table.Compile

Methods

compare :: OnError -> OnError -> Ordering

(<) :: OnError -> OnError -> Bool

(<=) :: OnError -> OnError -> Bool

(>) :: OnError -> OnError -> Bool

(>=) :: OnError -> OnError -> Bool

max :: OnError -> OnError -> OnError

min :: OnError -> OnError -> OnError

Show OnError

Defined in Database.Selda.Table.Compile

Methods

showsPrec :: Int -> OnError -> ShowS

show :: OnError -> String

showList :: [OnError] -> ShowS

defPPConfig :: PPConfig

Default settings for pretty-printing. Geared towards SQLite.

The default definition of ppTypePK is 'defType, so that you don’t have to do anything special if you don’t use special types for primary keys.

compile :: Result a => Query s a -> (Text, [Param])

Compile a query into a parameterised SQL statement.

The types given are tailored for SQLite. To translate SQLite types into whichever types are used by your backend, use compileWith.

compileCreateTable :: PPConfig -> OnError -> Table a -> Text

Compile a sequence of queries to create the given table, including indexes. The first query in the sequence is always CREATE TABLE.

compileDropTable :: OnError -> Table a -> Text

Compile a DROP TABLE query.

compileInsert :: Relational a => PPConfig -> Table a -> [a] -> [(Text, [Param])]

Compile an INSERT query, given the keyword representing default values in the target SQL dialect, a table and a list of items corresponding to the table.

compileUpdate

Arguments

:: (Relational a, SqlRow a)

=> PPConfig

-> Table a

Table to update.

-> (Row s a -> Row s a)

Update function.

-> (Row s a -> Col s Bool)

Predicate.

-> (Text, [Param])

Compile an UPDATE query.