Orville.PostgreSQL.Expr.Insert

Since: 1.0.0.0

Documentation

data InsertExpr

Type to represent a SQL INSERT statement. E.G.

INSERT INTO foo (id) VALUES (1),(3),(3)

InsertExpr provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression InsertExpr

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.Insert

Methods

toRawSql :: InsertExpr -> RawSql

unsafeFromRawSql :: RawSql -> InsertExpr

insertExpr :: Qualified TableName -> Maybe InsertColumnList -> InsertSource -> Maybe ReturningExpr -> InsertExpr

Create an InsertExpr for the given TableName, limited to the specific columns if given. Callers of this likely want to use a function to create the InsertSource to ensure the input values are correctly used as parameters. This function does not include that protection itself.

Since: 1.0.0.0

data InsertColumnList

Type to represent the SQL columns list for an insert statement. E.G.

(foo,bar,baz)

InsertColumnList provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression InsertColumnList

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.Insert

Methods

toRawSql :: InsertColumnList -> RawSql

unsafeFromRawSql :: RawSql -> InsertColumnList

insertColumnList :: [ColumnName] -> InsertColumnList

Create an InsertColumnList for the given ColumnNames, making sure the columns are wrapped in parens and commas are used to separate.

Since: 1.0.0.0

data InsertSource

Type to represent the SQL for the source of data for an insert statement. E.G.

VALUES ('Bob',32),('Cindy',33)

InsertSource provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression InsertSource

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.Insert

Methods

toRawSql :: InsertSource -> RawSql

unsafeFromRawSql :: RawSql -> InsertSource

insertSqlValues :: [[SqlValue]] -> InsertSource

Create an InsertSource for the given SqlValues. This ensures that all input values are used as parameters and comma-separated in the generated SQL.

Since: 1.0.0.0

data RowValues

Type to represent a SQL row literal. For example, a single row to insert in a VALUES clause. E.G.

('Cindy',33)

RowValues provides a SqlExpression instance. See unsafeSqlExpression for how to construct a value with your own custom SQL.

Since: 1.0.0.0

Instances

SqlExpression RowValues

Since: 1.0.0.0

Defined in Orville.PostgreSQL.Expr.Insert

Methods

toRawSql :: RowValues -> RawSql

unsafeFromRawSql :: RawSql -> RowValues

rowValues :: [SqlValue] -> RowValues

Create a RowValues for the given SqlValues. This ensures that all input values are used as parameters and comma-separated in the generated SQL.

Since: 1.0.0.0