'use strict'; /* DELETE /messages/:id. Removes the caller's own copy only (sender copy or recipient copy). When nobody has a copy * left the row is purged. Deleting an already deleted copy is a no-op; a message you never saw is not_found. */ const { GameError } = require('../errors'); module.exports = function messageDelete(ctx, { userId, messageId }) { const { db, now } = ctx; const m = db.get('SELECT m.id, m.sender_id, m.sender_deleted_at, o.user_id AS suid FROM messages m JOIN operators o ON o.id = m.sender_id WHERE m.id = ?', messageId); if (!m) throw new GameError('not_found', { what: 'message' }); let changed = false; if (m.suid === userId) { changed = !m.sender_deleted_at; if (changed) db.run('UPDATE messages SET sender_deleted_at = ? WHERE id = ?', now, m.id); } else { const r = db.get(`SELECT r.operator_id, r.deleted_at FROM message_recipients r JOIN operators o ON o.id = r.operator_id WHERE r.message_id = ? AND o.user_id = ?`, m.id, userId); if (!r) throw new GameError('not_found', { what: 'message' }); changed = !r.deleted_at; if (changed) db.run('UPDATE message_recipients SET deleted_at = ? WHERE message_id = ? AND operator_id = ?', now, m.id, r.operator_id); } const left = db.get(`SELECT (SELECT sender_deleted_at IS NULL FROM messages WHERE id = ?) AS s, (SELECT COUNT(*) FROM message_recipients WHERE message_id = ? AND deleted_at IS NULL) AS r`, m.id, m.id); if (!left.s && !left.r) { db.run('DELETE FROM message_recipients WHERE message_id = ?', m.id); db.run('DELETE FROM messages WHERE id = ?', m.id); } return { changed }; };