-- name: ReserveKey :one INSERT INTO idempotency(user_id,chat_id,key,payload_hash,message_id,expires_at) VALUES($1,$2,$3,$4,$5,clock_timestamp()+interval '24 hours') ON CONFLICT(user_id,chat_id,key) DO UPDATE SET payload_hash=excluded.payload_hash, message_id=excluded.message_id,expires_at=excluded.expires_at WHERE idempotency.expires_at<=clock_timestamp() RETURNING message_id; -- name: ReplayMessage :one SELECT m.id,m.chat_id,m.sender_id,m.text,m.created_at,i.payload_hash FROM idempotency i JOIN messages m ON m.id=i.message_id WHERE i.user_id=$1 AND i.chat_id=$2 AND i.key=$3;