mirror of
https://github.com/ckaczor/HomeMonitor.git
synced 2026-01-14 09:59:13 -05:00
16 lines
307 B
Plaintext
16 lines
307 B
Plaintext
INSERT INTO device(
|
|
name,
|
|
last_updated,
|
|
stopped_reporting
|
|
)
|
|
VALUES (
|
|
@Name,
|
|
@LastUpdated,
|
|
false
|
|
)
|
|
ON CONFLICT (name)
|
|
DO UPDATE
|
|
SET last_updated = EXCLUDED.last_updated,
|
|
stopped_reporting = false
|
|
RETURNING
|
|
(SELECT stopped_reporting FROM device WHERE name = @Name); |