Skip to main content

Update

Simple​

SQL:

UPDATE films SET "kind" = $1 WHERE (kind = $2)

Args:

  • "Dramatic"
  • "Drama"

Code:

psql.Update(
  um.Table("films"),
  um.SetCol("kind").ToArg("Dramatic"),
  um.Where(psql.Quote("kind").EQ(psql.Arg("Drama"))),
)

With From​

SQL:

UPDATE employees SET "sales_count" = sales_count + 1 FROM accounts
WHERE (accounts.name = $1)
AND (employees.id = accounts.sales_person)

Args:

  • "Acme Corporation"

Code:

psql.Update(
  um.Table("employees"),
  um.SetCol("sales_count").To("sales_count + 1"),
  um.From("accounts"),
  um.Where(psql.Quote("accounts", "name").EQ(psql.Arg("Acme Corporation"))),
  um.Where(psql.Quote("employees", "id").EQ(psql.Quote("accounts", "sales_person"))),
)

With Sub-Select​

SQL:

UPDATE employees SET "sales_count" = sales_count + 1 WHERE (id =
(SELECT sales_person FROM accounts WHERE (name = $1)))

Args:

  • "Acme Corporation"

Code:

psql.Update(
  um.Table("employees"),
  um.SetCol("sales_count").To("sales_count + 1"),
  um.Where(psql.Quote("id").EQ(psql.Group(psql.Select(
    sm.Columns("sales_person"),
    sm.From("accounts"),
    sm.Where(psql.Quote("name").EQ(psql.Arg("Acme Corporation"))),
  )))),
)