Building my own PostgresGUI with TypeORM+TypeGraphQl class generaion

I recently saw a job opening where they wanted a Nodejs ,TypeORM and GraphQL developer So I decided now would be a good time to brush up on those skills

Throw back to 3 years a go when Ben Awad was the predominant react influencer on YouTube when he dropped this absolute banger of an intermediate full-stack tutorial

But before starting with that I went back to do a Postgres refresher and tried out a freecodecamp video

In the video they ha a sample movies database which I decided to build an app around as practice and expose a GraphQL API of it

Checkout sample database setup part

Before we do anything , we'll walk over how we'll use TypeORM with GraphQL

The idea will be to

Create a GraphQl server with express and apollo-server-express
Using TypeORM as our ORM to talk to the database with and define the schema
Use type-graphql to define the GraphQ schema and resolvers for maximum type safety

The TypeORM + TypeGraphQl definition would be a class with respective annotations

typescript

1import { Entity, PrimaryGeneratedColumn, Column } from "typeorm"
2import { ObjectType, Field, Int, InputType } from 'type-graphql'
3import { registerEnumType } from "type-graphql";
4
5
6enum FilmRatings{
7PG13 = "PG-13",
8    NC17 = "NC-17",
9    R = "R",
10    G = "G",
11    PG = "PG"
12}
13
14
15registerEnumType(FilmRatings, {
16    name: "rating", // Mandatory
17    description: "The film rating", // Optional
18});
19
20@ObjectType()
21@InputType()
22@Entity()
23export class Film {
24    @Field(() => Int)
25    @PrimaryGeneratedColumn()
26    film_id: number;
27
28    @Field(()=>String)
29    @Column({ type: "text" })
30    title: string;
31
32    @Field(() => Int)
33    @Column({ type: "integer" })
34    release_year: number;
35
36    @Field(() => Int)
37    @Column({ type: "smallint" })
38    language_id: number;
39
40    @Field(() => Int)
41    @Column({ type: "smallint" })
42    rental_duration: number;
43
44    @Field(() => Int)
45    @Column({ type: "numeric" })
46    rental_rate: number;
47
48    @Field(() => Int)
49    @Column({ type: "smallint" })
50    length: number;
51
52    @Field(() => Int)
53    @Column({ type: "numeric" })
54    replacement_cost: number;
55
56    @Field(()=>FilmRatings)
57    @Column({ type: "enum",enumName: "rating" })
58    rating: FilmRatings
59
60    @Field(() => String)
61    @Column({ type: "timestamp without time zone" })
62    last_update: Date;
63
64    @Field(() => [String])
65    @Column({ type: "text", array: true })
66    special_features: string[];
67
68    @Field(()=>String)
69    @Column({ type: "text" })
70    fulltext: string;
71
72}
73
74