consumer/src/db/sql/label_service_upsert.sql at feat-viewer-interactions

quilling.dev / parakeet

forked from parakeet.at/parakeet

fork atom

Rust AppView - highly experimental!

fork atom

parakeet / consumer / src / db / sql / label_service_upsert.sql

at feat-viewer-interactions 7 lines 413 B view raw

wrap content

mia.omg.lol feat(consumer): Consumer Performance Improvements 9mo ago

c2fc8913

1INSERT INTO labelers (did, cid, reasons, subject_types, subject_collections)
2VALUES ($1, $2, $3, $4, $5)
3ON CONFLICT (did) DO UPDATE SET cid=EXCLUDED.cid,
4                                reasons=EXCLUDED.reasons,
5                                subject_types=EXCLUDED.subject_types,
6                                subject_collections=EXCLUDED.subject_collections,
7                                indexed_at=NOW()