Currently in the process of constructing a GraphQL API using TypeORM and Nexus Schema. I have set up various entities with relationships between them including Product, Brand, and User. The challenge I'm encountering is that when querying the Product entity through GraphQL, fields like category_id and brand_id are coming back as null even though there is data stored in the database.
Below is a snippet of the GraphQL Nexus Schema:
// ProductType.ts
import { objectType } from 'nexus';
import { context } from './context';
import { User } from './User';
export const ProductType = objectType({
name: 'Product',
definition(t) {
t.nonNull.int('id');
t.nonNull.string('name');
t.int('creatorId');
t.nonNull.int('category_id');
t.nonNull.int('brand_id');
t.field('createdBy', {
type: 'User',
resolve(parent, _args, _context: context, _info): Promise<User | null> {
return User.findOne({ where: { id: parent.creatorId } });
},
});
},
});
Brand Entity:
//brand.ts
import {
BaseEntity,
Entity,
Column,
CreateDateColumn,
UpdateDateColumn,
PrimaryGeneratedColumn,
ManyToOne,
OneToMany,
} from 'typeorm';
import { User } from './User';
import { Product } from './Product';
import { OrderItem } from './OrderItem';
@Entity()
export class Brand extends BaseEntity {
@PrimaryGeneratedColumn()
id!: number;
@Column({ unique: true })
name!: string;
@OneToMany(() => Product, (product) => product.brand)
products: Product[];
@CreateDateColumn()
createdAt: Date;
@UpdateDateColumn()
updatedAt: Date;
}
Product Entity:
import {
BaseEntity,
Entity,
Column,
CreateDateColumn,
UpdateDateColumn,
PrimaryGeneratedColumn,
OneToMany,
ManyToOne,
JoinColumn,
} from 'typeorm';
import { User } from './User';
import { Wishlist } from './Wishlist';
import { Review } from './Review';
import { OrderItem } from './OrderItem';
import { Brand } from './Brand';
import { Category } from './Category';
import { ProductImage } from './ProductImage';
// Code for Product entity here...
After double-checking the database, it is confirmed that both category_id and brand_id contain data. Nevertheless, these fields are returning null when querying the Product entity. I've reviewed my entity associations and definitions but am unable to identify the root cause of this issue.
If anyone can shed light on why the related fields are showing null values despite the database having the necessary information, your assistance would be greatly appreciated. Any advice or suggestions will be valuable. Thank you!