Interface IMessagesDAO

interface IMessagesDAO {
    checkIfMessageExists(message_id: number): Promise<boolean>;
    countChatMessages(stream_id: number): Promise<number>;
    countMessageEdits(message_id: number): Promise<number>;
    createChatMessage(
        stream_id: number,
        user_id: number,
        content: string,
    ): Promise<Message | null>;
    deleteChatMessage(message_id: number): Promise<boolean>;
    editChatMessage(message_id: number, newContent: string): Promise<boolean>;
    getAllMessagesPaginated(
        stream_id: number,
        limit?: number,
        offset?: number,
    ): Promise<Message[]>;
    getChatMessages(
        stream_id: number,
        limit?: number,
        offset?: number,
    ): Promise<Message[]>;
    getDeletedMessages(stream_id: number): Promise<Message[]>;
    getDeletedMessagesPaginated(
        stream_id: number,
        limit?: number,
        offset?: number,
    ): Promise<Message[]>;
    getLastMessage(stream_id: number): Promise<Message | null>;
    getMessageEditHistory(message_id: number): Promise<OldMessageRecord[]>;
    getMessageEditHistoryPaginated(
        message_id: number,
        limit?: number,
        offset?: number,
    ): Promise<OldMessageRecord[]>;
    getUserMessagesPaginated(
        stream_id: number,
        user_id: number,
        limit?: number,
        offset?: number,
    ): Promise<Message[]>;
    hardDeleteChatMessage(message_id: number): Promise<boolean>;
    isUserMessageAuthor(message_id: number, user_id: number): Promise<boolean>;
    undeleteAllChatMessages(stream_id: number): Promise<number>;
    undeleteChatMessage(message_id: number): Promise<boolean>;
}