Implement Get mentors by category endpoint (Admin) #26

[sathudeva7]

Purpose

The purpose of this PR is to fix #26

Goals

This issue involves implementing an API to get mentors by category. The endpoint should allow Admin to make a GET request to {{baseUrl}}/api/admin/mentors?category={{category}}.

Approach

const mentors: Mentor[] = await mentorRepository .createQueryBuilder('mentor') .innerJoinAndSelect('mentor.category', 'category') .leftJoinAndSelect('mentor.profile', 'profile') .select([ 'mentor.uuid', 'category.category', 'mentor.application', 'profile.contact_email', 'profile.first_name', 'profile.last_name', 'profile.image_url', 'profile.linkedin_url' ]) .where('category.category ILIKE :name', { name: categoryQuery }) .getMany()

Screenshots

Checklist

• [x] This PR doesn't commit any keys, passwords, tokens, usernames, or other secrets.
• [x] I have read and understood the development best practices guidelines ( http://bit.ly/sef-best-practices )
• [ ] My code follows the style guidelines of this project
• [x] I have performed a self-review of my own code
• [ ] I have commented my code, particularly in hard-to-understand areas
• [ ] I have made corresponding changes to the documentation

Related PRs

## Test environment ## Learning

[sathudeva7]

@anjula-sack please review this

[anjula-sack]

Closing due to inactivity