Skip to main content

Critical Query Catalog

Bu dosya, indeks kararlarinda baz alinacak kritik sorgu kimliklerini tanimlar.

CQ-001 Device Latest Stream​

SELECT id, device_id, stream_time
FROM streams
WHERE device_id = $1
ORDER BY stream_time DESC
LIMIT 1;

CQ-002 Device Time Range Streams​

SELECT id, device_id, stream_time
FROM streams
WHERE device_id = $1
	AND stream_time BETWEEN $2 AND $3
ORDER BY stream_time DESC;

CQ-003 Unread Inbox By User​

SELECT mrs.message_id, mrs.status, i.create_time
FROM message_read_state mrs
JOIN inbox i ON i.id = mrs.message_id
WHERE mrs.user_id = $1
	AND mrs.status = 'unread'
ORDER BY i.create_time DESC
LIMIT $2;

CQ-004 Rule Events By Device Range​

SELECT id, device_id, rule_group_id, create_time
FROM rule_events
WHERE device_id = $1
	AND create_time BETWEEN $2 AND $3
ORDER BY create_time DESC;

CQ-005 Active Rule Assignment Lookup​

SELECT rule_group_id
FROM device_rule_assignments
WHERE device_id = $1
	AND is_active = true;

CQ-006 Finance List By Device Time​

SELECT id, device_id, transaction_time, amount
FROM finances
WHERE device_id = $1
	AND transaction_time BETWEEN $2 AND $3
ORDER BY transaction_time DESC;

CQ-007 Logs By Device Time​

SELECT id, device_id, level_id, create_time
FROM logs
WHERE device_id = $1
	AND create_time BETWEEN $2 AND $3
ORDER BY create_time DESC
LIMIT $4;

CQ-008 Synth Assignment Resolution​

SELECT id, rule_id, scope_type, device_id, group_id, priority_override
FROM synthesis_assignments
WHERE rule_id = $1
	AND is_active = true
ORDER BY priority_override NULLS LAST, id DESC;