consumer/src/db/sql/threadgate_upsert.sql at nix · quilling.dev/parakeet

quilling.dev / parakeet

Rust AppView - highly experimental!

parakeet / consumer / src / db / sql / threadgate_upsert.sql

at nix 514 B view raw

1INSERT INTO threadgates (at_uri, cid, post_uri, hidden_replies, allow, allowed_lists, record, created_at)
2VALUES ($1, $2, $3, $4, $5, $6, $7, $8)
3ON CONFLICT (at_uri) DO UPDATE SET cid=EXCLUDED.cid,
4                                   hidden_replies=EXCLUDED.hidden_replies,
5                                   allow=EXCLUDED.allow,
6                                   allowed_lists=EXCLUDED.allowed_lists,
7                                   record=EXCLUDED.record,
8                                   indexed_at=NOW()