psql

Documentation

Index

• Variables
• type DeleteMod
• type DeleteModApply
• type DeleteQuery
  • func Delete(mods ...DeleteMod) DeleteQuery
  • func DeleteRaw(rawQuery string, args ...any) DeleteQuery
  • func DeleteRawExpr(e litsql.Expression) DeleteQuery
• type InsertMod
• type InsertModApply
• type InsertQuery
  • func Insert(mods ...InsertMod) InsertQuery
  • func InsertRaw(rawQuery string, args ...any) InsertQuery
  • func InsertRawExpr(e litsql.Expression) InsertQuery
• type SelectMod
• type SelectModApply
• type SelectQuery
  • func Select(mods ...SelectMod) SelectQuery
  • func SelectRaw(rawQuery string, args ...any) SelectQuery
  • func SelectRawExpr(e litsql.Expression) SelectQuery
• type UpdateMod
• type UpdateModApply
• type UpdateQuery
  • func Update(mods ...UpdateMod) UpdateQuery
  • func UpdateRaw(rawQuery string, args ...any) UpdateQuery
  • func UpdateRawExpr(e litsql.Expression) UpdateQuery

Examples

• Select (LiteralJoin)
• Select (LiteralSimple)
• Select (LiteralSimpleInvalid)
• Select (LiteralWith)

Variables

var (
	Dialect dialect
)

Types

type DeleteMod

type DeleteMod = sq.QueryMod[tag.DeleteTag]

type DeleteModApply

type DeleteModApply = sq.QueryModApply[tag.DeleteTag]

type DeleteQuery

type DeleteQuery = sq.Query[tag.DeleteTag]

func Delete

func Delete(mods ...DeleteMod) DeleteQuery

func DeleteRaw

func DeleteRaw(rawQuery string, args ...any) DeleteQuery

func DeleteRawExpr

func DeleteRawExpr(e litsql.Expression) DeleteQuery

type InsertMod

type InsertMod = sq.QueryMod[tag.InsertTag]

type InsertModApply

type InsertModApply = sq.QueryModApply[tag.InsertTag]

type InsertQuery

type InsertQuery = sq.Query[tag.InsertTag]

func Insert

func Insert(mods ...InsertMod) InsertQuery

func InsertRaw

func InsertRaw(rawQuery string, args ...any) InsertQuery

func InsertRawExpr

func InsertRawExpr(e litsql.Expression) InsertQuery

type SelectMod

type SelectMod = sq.QueryMod[tag.SelectTag]

type SelectModApply

type SelectModApply = sq.QueryModApply[tag.SelectTag]

type SelectQuery

type SelectQuery = sq.Query[tag.SelectTag]

func Select

func Select(mods ...SelectMod) SelectQuery

Example (LiteralJoin)

Output:

SELECT orders.id AS order_id, orders.date, u.id AS user_id, u.name AS user_name
FROM orders
INNER JOIN users AS u ON orders.user_id = u.id
WHERE u.age > $1 AND u.deleted_at IS NOT NULL
ORDER BY orders.date DESC, u.name ASC
===
[32]

Example (LiteralSimple)

Output:

SELECT u.id, u.name, u.created_at, u.updated_at
FROM users AS u
WHERE u.age > $1 AND u.city_id = $2 AND u.deleted_at IS NOT NULL
ORDER BY u.name ASC, u.age DESC
===
[40 66]

Example (LiteralSimpleInvalid)

Output:

SELECT u.id, u.name of user
FROM users AND NOT users
WHERE CREATE TABLE users

Example (LiteralWith)

Output:

WITH regional_sales AS (
  SELECT region, SUM(amount) AS total_sales
  FROM orders
  GROUP BY region
),
top_regions AS (
  SELECT region
  FROM regional_sales
  WHERE total_sales > (
    SELECT SUM(total_sales)/10
    FROM regional_sales
  )
)
SELECT region, product, SUM(quantity) AS product_units, SUM(amount) AS product_sales
FROM orders
WHERE region IN (
  SELECT region
  FROM top_regions
)
GROUP BY region, product

func SelectRaw

func SelectRaw(rawQuery string, args ...any) SelectQuery

func SelectRawExpr

func SelectRawExpr(e litsql.Expression) SelectQuery

type UpdateMod

type UpdateMod = sq.QueryMod[tag.UpdateTag]

type UpdateModApply

type UpdateModApply = sq.QueryModApply[tag.UpdateTag]

type UpdateQuery

type UpdateQuery = sq.Query[tag.UpdateTag]

func Update

func Update(mods ...UpdateMod) UpdateQuery

func UpdateRaw

func UpdateRaw(rawQuery string, args ...any) UpdateQuery

func UpdateRawExpr

func UpdateRawExpr(e litsql.Expression) UpdateQuery