A query filtering generator for knex

index.js

const mapping = {
    userId: 'user_id',
    comment: 'comment',
    date: 'date',
    id: 'id',
    createdAt: 'created_at',
    updatedAt: 'updated_at',
};

// generate a where query with any filters matching a mapping
const handleFilters = (filters = {}) => query => {
    Object.keys(filters).map(key => {
        const mappedKey = mapping[key];
        const filter = filters[key];

        if (mappedKey !== undefined && filter !== null && filter !== undefined) {
            if (Array.isArray(filter)) {
                query.whereIn(mappedKey, filter);
            } else {
                query.where(mappedKey, filter);
            }
        }
    });
};


// usage => 

knex.select().from('table').where(handleFilters({userId: [1]}));