Skip to main content
Version: 1.x

The User & Todo Models

First of all, if you have downloaded the source code of the previous tutorial, compile and run the existing migrations.

npm run build:migrationsnpm run migration:run

The User Model#

Then open the user.entity.ts file from the src/app/entities directory. The User entity is the main class used by the framework's authentication system.

Add the email and password properties and the setPassword method.

import { hashPassword } from '@foal/core';import { Column, Entity, PrimaryGeneratedColumn } from 'typeorm';
@Entity()export class User {
  @PrimaryGeneratedColumn()  id: number;
  @Column({ unique: true })  email: string;
  @Column()  password: string;
  async setPassword(password: string) {    this.password = await hashPassword(password);  }
}

The setPassword method uses hashPassword to hash passwords before storing them in the database. You must use this method to set a password instead of directly assigning a value to the password attribute.

The Todo Model#

The Todo model defined in the previous tutorial now needs a owner property to know which user it belongs to.

Replace the content of todo.entity.ts.

import { Column, Entity, ManyToOne, PrimaryGeneratedColumn } from 'typeorm';import { User } from './user.entity';
@Entity()export class Todo {
  @PrimaryGeneratedColumn()  id: number;
  @Column()  text: string;
  @ManyToOne(type => User)  owner: User;
}

In the database the todo table will look like this:

+------------+-----------+-------------------------------------+|                             todo                             |+------------+-----------+-------------------------------------+| id         | integer   | PRIMARY KEY AUTO_INCREMENT NOT NULL || text       | varchar   | NOT NULL                            || ownerId    | integer   |                                     |+------------+-----------+-------------------------------------+

The Migrations#

The last step is to create/update the tables in the database. As in the first tutorial, you will use migrations for this.

Build the application.

npm run build:app

Generate the migrations from the entities.

npm run migration:generate -- --name=user-and-todo

A new file is added in src/migrations.

import {MigrationInterface, QueryRunner} from "typeorm";
export class userAndTodo1562765487944 implements MigrationInterface {
    public async up(queryRunner: QueryRunner): Promise<void> {        // SQL queries...    }
    public async down(queryRunner: QueryRunner): Promise<void> {        // SQL queries...    }
}

Then build and run the new migration file.

npm run build:migrationsnpm run migration:run