I am currently working on building a graphQL query system using Apollo, typescript, and TypeOrm. At the moment, I only have one table called users in my database. I am creating a getUsers GraphQL query which retrieves all users from the table. With the help of typeOrm, I retrieve users in my resolver function using the find() method. My main concern is whether it is possible to have optional filters for the users table in TypeOrm or Apollo. This way, I can pass an optional id parameter or no parameter at all to return all users within the same query. Are there any methods available to handle optional filters without needing to execute multiple queries? Thank you for your guidance.
Below are examples of the queries I would like to execute:
query noFilters {
getUsers {
id
firstName
}
}
## Return all users
query withFilters {
getUsers (filters: {id: [1]}) {
id
firstName
}
}
## Return user with ID 1 only
User entity structure:
import {Entity, PrimaryGeneratedColumn, Column, BaseEntity} from "typeorm";
@Entity()
export class User extends BaseEntity{
@PrimaryGeneratedColumn({name: "user_id"})
id: number;
@Column({name: "first_name" })
firstName: string;
}
Resolver function:
export const resolvers = {
Query: {
getUsers: async (_: any, args: any) => {
const { id } = args;
return await User.find({where: {}});
}
}
};
Types definition:
export const typeDefs = gql`
type Query {
getUsers(id: [Int!]): [User]
}
type User {
id: Int!
firstName: String!
}
`;