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

quilling.dev / parakeet

Rust AppView - highly experimental!

parakeet / consumer / src / db / sql / label_defs_upsert.sql

at main 408 B view raw

1INSERT INTO labeler_defs (labeler, label_identifier, severity, blurs, default_setting, adult_only, locales)
2VALUES ($1, $2, $3, $4, $5, $6, $7)
3ON CONFLICT (labeler, label_identifier) DO UPDATE
4    SET severity=EXCLUDED.severity,
5        blurs=EXCLUDED.blurs,
6        default_setting=EXCLUDED.default_setting,
7        adult_only=EXCLUDED.adult_only,
8        locales=EXCLUDED.locales,
9        indexed_at=NOW()