consumer/src/db/sql/postgate_upsert.sql at main · quilling.dev/parakeet

quilling.dev / parakeet

Rust AppView - highly experimental!

parakeet / consumer / src / db / sql / postgate_upsert.sql

at main 394 B view raw

1INSERT INTO postgates (at_uri, cid, post_uri, detached, rules, created_at)
2VALUES ($1, $2, $3, $4, $5, $6)
3ON CONFLICT (at_uri) DO UPDATE SET cid=EXCLUDED.cid,
4                                   post_uri=EXCLUDED.post_uri,
5                                   detached=EXCLUDED.detached,
6                                   rules=EXCLUDED.rules,
7                                   indexed_at=NOW()