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

quilling.dev / parakeet

Rust AppView - highly experimental!

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

at main 413 B view raw

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()