Skip to content

Implement message model #21

@Iiquidate

Description

@Iiquidate

Create apps/server/src/models/messageModel.ts with the database query functions for messages. This follows the same pattern as channelModel.ts.

Queries needed:

getMessagesByChannelId(channelId) - fetch messages for a given channel, ordered by created_at

createMessage(channelId, userId, content) — insert a new message

deleteMessage(messageId)
— delete a single message (for admin moderation)

purgeOldMessages(hours)
— delete messages older than a given threshold

Metadata

Metadata

Assignees

Labels

No labels
No labels

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions