fucko.js

export function getMessagesQuery(roomId: number, userId: number, responseId: number, timestamp: moment.Moment) {
    let query = 'SELECT * FROM messages';
    let queryObjects = [];

    if (isNaN(roomId) && isNaN(userId) && isNaN(responseId) && !timestamp.isValid()) {
        return query;
    }

    if (roomId !== undefined) {
        queryObjects.push(`room_id = ${roomId}`);
    }

    if (userId !== undefined) {
        queryObjects.push(`message_id = ${userId}`);
    }

    if (responseId !== undefined) {
        queryObjects.push(`response_id = ${responseId}`);
    }

    if (timestamp.isValid()) {
        queryObjects.push(`timestamp = '${timestamp.format('YYYY-MM-DD')}'`);
    }
    
    query += ' WHERE ';
    query += queryObjects.join(' AND ');

    return query;
}