Pasta

Documentation

target :: HasTarget s a => Lens' s a

assignments :: HasAssignments s a => Lens' s a

conditions :: HasConditions s a => Lens' s a

insert :: Text -> NonEmpty Text -> NonEmpty Text -> Insert

Builds an INSERT statement using a target, a non-empty list of column names and a non-empty list of values

columns :: HasColumns s a => Lens' s a

values :: HasValues s a => Lens' s a

update :: Text -> NonEmpty Text -> NonEmpty Expression -> Update

Builds an UPDATE statement using a target, a non-empty list of column names and a non-empty list of values

delete :: Text -> Delete

Builds a DELETE statement using a target

returning :: HasReturning s a => Lens' s a

onConflict :: HasOnConflict s a => Lens' s a

doNothing :: Maybe Conflict

Used for conflict resolution when we don't want the conflict to trigger any exception

doUpdate :: ConflictTarget -> [Assignment] -> Maybe Conflict

Used for conflict resolution when we want the conflict to update some column

(.=) :: IsExpression exp => Name -> exp -> Assignment

Assignment operator creates SQL assignments like in conflict resolution rules

(//) :: Name -> Name -> Identifier

Identifier builder, takes two names and builds a qualified identifier (e.g. "information_schema"."tables")

select :: Select

Builds a SELECT null with neither FROM nor WHERE clauses.

selectExp :: Expression -> Select

Builds a SELECT expression with neither FROM nor WHERE clauses

selectFrom :: Name -> Select

Builds a SELECT * FROM table statement.

selectFunction :: Identifier -> [Expression] -> Select

Builds a SELECT fn(parameters) with neither FROM nor WHERE clauses

t :: BooleanExpression

Just a convenient way to write a BoolLiteral True

f :: BooleanExpression

Just a convenient way to write a BoolLiteral False

relations :: HasRelations s a => Lens' s a

toSQL :: IsSQL a => a -> Text

data NonEmpty a :: * -> *

Non-empty (and non-strict) list type.

Since: 4.9.0.0

Constructors

a :| [a] infixr 5

Instances

Monad NonEmpty

Methods

(>>=) :: NonEmpty a -> (a -> NonEmpty b) -> NonEmpty b

(>>) :: NonEmpty a -> NonEmpty b -> NonEmpty b

return :: a -> NonEmpty a

fail :: String -> NonEmpty a

Functor NonEmpty

Methods

fmap :: (a -> b) -> NonEmpty a -> NonEmpty b

(<$) :: a -> NonEmpty b -> NonEmpty a

MonadFix NonEmpty

Methods

mfix :: (a -> NonEmpty a) -> NonEmpty a

Applicative NonEmpty

Methods

pure :: a -> NonEmpty a

(<*>) :: NonEmpty (a -> b) -> NonEmpty a -> NonEmpty b

(*>) :: NonEmpty a -> NonEmpty b -> NonEmpty b

(<*) :: NonEmpty a -> NonEmpty b -> NonEmpty a

Foldable NonEmpty

Methods

fold :: Monoid m => NonEmpty m -> m

foldMap :: Monoid m => (a -> m) -> NonEmpty a -> m

foldr :: (a -> b -> b) -> b -> NonEmpty a -> b

foldr' :: (a -> b -> b) -> b -> NonEmpty a -> b

foldl :: (b -> a -> b) -> b -> NonEmpty a -> b

foldl' :: (b -> a -> b) -> b -> NonEmpty a -> b

foldr1 :: (a -> a -> a) -> NonEmpty a -> a

foldl1 :: (a -> a -> a) -> NonEmpty a -> a

toList :: NonEmpty a -> [a]

null :: NonEmpty a -> Bool

length :: NonEmpty a -> Int

elem :: Eq a => a -> NonEmpty a -> Bool

maximum :: Ord a => NonEmpty a -> a

minimum :: Ord a => NonEmpty a -> a

sum :: Num a => NonEmpty a -> a

product :: Num a => NonEmpty a -> a

Traversable NonEmpty

Methods

traverse :: Applicative f => (a -> f b) -> NonEmpty a -> f (NonEmpty b)

sequenceA :: Applicative f => NonEmpty (f a) -> f (NonEmpty a)

mapM :: Monad m => (a -> m b) -> NonEmpty a -> m (NonEmpty b)

sequence :: Monad m => NonEmpty (m a) -> m (NonEmpty a)

Generic1 NonEmpty

Associated Types

type Rep1 (NonEmpty :: * -> *) :: * -> *

Methods

from1 :: NonEmpty a -> Rep1 NonEmpty a

to1 :: Rep1 NonEmpty a -> NonEmpty a

MonadZip NonEmpty

Methods

mzip :: NonEmpty a -> NonEmpty b -> NonEmpty (a, b)

mzipWith :: (a -> b -> c) -> NonEmpty a -> NonEmpty b -> NonEmpty c

munzip :: NonEmpty (a, b) -> (NonEmpty a, NonEmpty b)

IsList (NonEmpty a)

Associated Types

type Item (NonEmpty a) :: *

Methods

fromList :: [Item (NonEmpty a)] -> NonEmpty a

fromListN :: Int -> [Item (NonEmpty a)] -> NonEmpty a

toList :: NonEmpty a -> [Item (NonEmpty a)]

Eq a => Eq (NonEmpty a)

Methods

(==) :: NonEmpty a -> NonEmpty a -> Bool

(/=) :: NonEmpty a -> NonEmpty a -> Bool

Data a => Data (NonEmpty a)

Methods

gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> NonEmpty a -> c (NonEmpty a)

gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c (NonEmpty a)

toConstr :: NonEmpty a -> Constr

dataTypeOf :: NonEmpty a -> DataType

dataCast1 :: Typeable (* -> *) t => (forall d. Data d => c (t d)) -> Maybe (c (NonEmpty a))

dataCast2 :: Typeable (* -> * -> *) t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c (NonEmpty a))

gmapT :: (forall b. Data b => b -> b) -> NonEmpty a -> NonEmpty a

gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> NonEmpty a -> r

gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> NonEmpty a -> r

gmapQ :: (forall d. Data d => d -> u) -> NonEmpty a -> [u]

gmapQi :: Int -> (forall d. Data d => d -> u) -> NonEmpty a -> u

gmapM :: Monad m => (forall d. Data d => d -> m d) -> NonEmpty a -> m (NonEmpty a)

gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> NonEmpty a -> m (NonEmpty a)

gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> NonEmpty a -> m (NonEmpty a)

Ord a => Ord (NonEmpty a)

Methods

compare :: NonEmpty a -> NonEmpty a -> Ordering

(<) :: NonEmpty a -> NonEmpty a -> Bool

(<=) :: NonEmpty a -> NonEmpty a -> Bool

(>) :: NonEmpty a -> NonEmpty a -> Bool

(>=) :: NonEmpty a -> NonEmpty a -> Bool

max :: NonEmpty a -> NonEmpty a -> NonEmpty a

min :: NonEmpty a -> NonEmpty a -> NonEmpty a

Read a => Read (NonEmpty a)

Methods

readsPrec :: Int -> ReadS (NonEmpty a)

readList :: ReadS [NonEmpty a]

readPrec :: ReadPrec (NonEmpty a)

readListPrec :: ReadPrec [NonEmpty a]

Show a => Show (NonEmpty a)

Methods

showsPrec :: Int -> NonEmpty a -> ShowS

show :: NonEmpty a -> String

showList :: [NonEmpty a] -> ShowS

Generic (NonEmpty a)

Associated Types

type Rep (NonEmpty a) :: * -> *

Methods

from :: NonEmpty a -> Rep (NonEmpty a) x

to :: Rep (NonEmpty a) x -> NonEmpty a

Each (NonEmpty a) (NonEmpty b) a b

Methods

each :: Traversal (NonEmpty a) (NonEmpty b) a b

type Rep1 NonEmpty

type Rep1 NonEmpty = D1 (MetaData "NonEmpty" "Data.List.NonEmpty" "base" False) (C1 (MetaCons ":|" (InfixI RightAssociative 5) False) ((:*:) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) Par1) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec1 []))))

type Rep (NonEmpty a)

type Rep (NonEmpty a) = D1 (MetaData "NonEmpty" "Data.List.NonEmpty" "base" False) (C1 (MetaCons ":|" (InfixI RightAssociative 5) False) ((:*:) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 a)) (S1 (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 [a]))))

type Item (NonEmpty a)

type Item (NonEmpty a) = a

fromList :: [a] -> NonEmpty a

Converts a normal list to a NonEmpty stream.

Raises an error if given an empty list.

data Expression

Constructors

Null

Instances

Eq Expression

Methods

(==) :: Expression -> Expression -> Bool

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

Show Expression

Methods

showsPrec :: Int -> Expression -> ShowS

show :: Expression -> String

showList :: [Expression] -> ShowS

IsString Expression

Methods

fromString :: String -> Expression

TextShow Expression

Methods

showbPrec :: Int -> Expression -> Builder

showb :: Expression -> Builder

showbList :: [Expression] -> Builder

showtPrec :: Int -> Expression -> Text

showt :: Expression -> Text

showtList :: [Expression] -> Text

showtlPrec :: Int -> Expression -> Text

showtl :: Expression -> Text

showtlList :: [Expression] -> Text

data BooleanExpression

Constructors

Not BooleanExpression

In Identifier Select

Instances

Eq BooleanExpression

Methods

(==) :: BooleanExpression -> BooleanExpression -> Bool

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

Show BooleanExpression

Methods

showsPrec :: Int -> BooleanExpression -> ShowS

show :: BooleanExpression -> String

showList :: [BooleanExpression] -> ShowS

TextShow BooleanExpression

Methods

showbPrec :: Int -> BooleanExpression -> Builder

showb :: BooleanExpression -> Builder

showbList :: [BooleanExpression] -> Builder

showtPrec :: Int -> BooleanExpression -> Text

showt :: BooleanExpression -> Text

showtList :: [BooleanExpression] -> Text

showtlPrec :: Int -> BooleanExpression -> Text

showtl :: BooleanExpression -> Text

showtlList :: [BooleanExpression] -> Text

(.|) :: BooleanExpression -> BooleanExpression -> BooleanExpression

Boolean OR

(.&) :: BooleanExpression -> BooleanExpression -> BooleanExpression

Boolean AND

(.!) :: BooleanExpression -> BooleanExpression infixr 0

Boolean NOT

cmp :: (IsExpression lexp, IsExpression rexp) => Text -> lexp -> rexp -> BooleanExpression

Builds a BooleanExpression out of an operator and 2 expressions

eq :: (IsExpression lexp, IsExpression rexp) => lexp -> rexp -> BooleanExpression

Builds a equality comparison out of two expressions

gt :: (IsExpression lexp, IsExpression rexp) => lexp -> rexp -> BooleanExpression

Builds a greater than comparison out of two expressions

lt :: (IsExpression lexp, IsExpression rexp) => lexp -> rexp -> BooleanExpression

Builds a lesser than comparison out of two expressions

gte :: (IsExpression lexp, IsExpression rexp) => lexp -> rexp -> BooleanExpression

Builds a greater than or equal comparison out of two expressions

lte :: (IsExpression lexp, IsExpression rexp) => lexp -> rexp -> BooleanExpression

Builds a lesser than or equal comparison out of two expressions

fn :: Identifier -> [Expression] -> Expression

Builds a function

now :: Expression

Builds a now() function

age :: IsExpression exp => exp -> Expression

Builds an age(t) function