simple-0.4.0: A minimalist web framework for the WAI server interface

Safe Haskell	None

Database.PostgreSQL.Sequel

Documentation

data Sequel a Source

Constructors

Sequel
Fields runSequel :: Connection -> IO a

Instances

Monad Sequel
MonadIO Sequel

drop_table :: String -> Sequel ()Source

create_table :: String -> CreateTable a -> Sequel ()Source

type ColumnType = String Source

serial :: ColumnType Source

integer :: ColumnType Source

time :: ColumnType Source

timestamp :: ColumnType Source

varchar :: Integer -> ColumnType Source

string :: ColumnType Source

text :: ColumnType Source

boolean :: ColumnType Source

data ColumnConstraint Source

Constructors

NOT_NULL
UNIQUE
PRIMARY_KEY
DEFAULT String
REFERENCES String String

stringifyConstraint :: ColumnConstraint -> String Source

drop_column :: String -> String -> Sequel ()Source

add_column :: String -> String -> ColumnType -> [ColumnConstraint] -> Sequel ()Source

rename_column :: String -> String -> String -> Sequel ()Source

type CreateTable = StateT [(ColumnType, String, [ColumnConstraint])] Identity Source

runCreateTable :: CreateTable a -> String Source

column :: String -> ColumnType -> [ColumnConstraint] -> CreateTable ()Source

sqlQuery :: (ToRow q, FromRow r) => Query -> q -> Sequel [r]Source

sqlQuery_ :: FromRow r => Query -> Sequel [r]Source

sqlExecute :: ToRow q => Query -> q -> Sequel ()Source

sqlExecute_ :: Query -> Sequel ()Source