Skip to main content

Update

Simple​

SQL:

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

Args:

  • "Dramatic"
  • "Drama"

Code:

sqlite.Update(
  um.Table("films"),
  um.SetCol("kind").ToArg("Dramatic"),
  um.Where(sqlite.Quote("kind").EQ(sqlite.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:

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

With Sub-Select​

SQL:

UPDATE employees AS "e" NOT INDEXED
SET "sales_count" = sales_count + 1
WHERE ("id" = (SELECT sales_person FROM accounts WHERE ("name" = ?1)))

Args:

  • "Acme Corporation"

Code:

sqlite.Update(
  um.TableAs("employees", "e"),
  um.TableNotIndexed(),
  um.SetCol("sales_count").To("sales_count + 1"),
  um.Where(sqlite.Quote("id").EQ(sqlite.Select(
    sm.Columns("sales_person"),
    sm.From("accounts"),
    sm.Where(sqlite.Quote("name").EQ(sqlite.Arg("Acme Corporation"))),
  ))),
)