Breaking News: Grepper is joining You.com. Read the official announcement!

typeorm

Add Answer

Restu Wahyu Saputra answered on November 24, 2020 Popularity 10/10 Helpfulness 2/10

answer typeorm

related typeorm

related typeorm IN

related typeorm

typeorm

Comment

import {
  Column,
  Entity,
  PrimaryGeneratedColumn,
  CreateDateColumn,
  DeleteDateColumn,
  UpdateDateColumn,
  BeforeInsert,
  BeforeUpdate,
  JoinColumn,
  ManyToOne
} from 'typeorm'

import { IUsers } from '@interfaces/interface.users'
import { Roles } from '@models/model.roles'
import { Bcrypt } from '@libs/lib.bcrypt'

/**
* old style writing model schema using typeorm by default, if you check documentation
**/

@Entity()
export class Users implements IUsers {
  @PrimaryGeneratedColumn({ type: 'integer', unsigned: true })
  id!: number

  @Column({ name: 'last_name', type: 'varchar', nullable: false })
  name!: string

  @Column({ type: 'varchar', unique: true, nullable: false })
  email!: string

  @Column({ type: 'varchar', unique: true, unsigned: true, nullable: false })
  phone!: string

  @Column({ type: 'varchar', nullable: false })
  password!: string

  @CreateDateColumn({ name: 'created_at', type: 'timestamp', default: new Date() })
  createdAt?: Date

  @UpdateDateColumn({ name: 'updated_at', type: 'timestamp', default: new Date() })
  updatedAt?: Date

  @DeleteDateColumn({ name: 'deleted_at', type: 'timestamp', nullable: true })
  deletedAt?: Date

  @BeforeInsert()
  protected beforeInserthashPassword() {
    this.password = Bcrypt.hashPassword(this.password)
  }

  @BeforeUpdate()
  protected beforeUpdateHashPassword() {
    this.password = Bcrypt.hashPassword(this.password)
  }

  @ManyToOne(() => Roles, (relation) => relation.users, { onDelete: 'CASCADE' })
  @JoinColumn({ name: 'role_id' })
  role: Roles
}

/**
* my style writing model schema using typeorm, easy to maintance and easy to read
**/

class DatabaseRelations {
  @ManyToOne(() => Roles, (relation) => relation.users, { onDelete: 'CASCADE' })
  @JoinColumn({ name: 'role_id' })
  role: Roles
}

class DatabaseSchema extends DatabaseRelations {
  @PrimaryGeneratedColumn({ type: 'integer', unsigned: true })
  id!: number

  @Column({ name: 'last_name', type: 'varchar', nullable: false })
  name!: string

  @Column({ type: 'varchar', unique: true, nullable: false })
  email!: string

  @Column({ type: 'varchar', unique: true, unsigned: true, nullable: false })
  phone!: string

  @Column({ type: 'varchar', nullable: false })
  password!: string

  @CreateDateColumn({ name: 'created_at', type: 'timestamp', default: new Date() })
  createdAt?: Date

  @UpdateDateColumn({ name: 'updated_at', type: 'timestamp', default: new Date() })
  updatedAt?: Date

  @DeleteDateColumn({ name: 'deleted_at', type: 'timestamp', nullable: true })
  deletedAt?: Date
}

class DatabaseHooks extends DatabaseSchema {
  @BeforeInsert()
  protected beforeInserthashPassword() {
    this.password = Bcrypt.hashPassword(this.password)
  }

  @BeforeUpdate()
  protected beforeUpdateHashPassword() {
    this.password = Bcrypt.hashPassword(this.password)
  }
}

@Entity()
export class Users extends DatabaseHooks implements IUsers {}

Popularity 10/10 Helpfulness 2/10 Language typescript

Source: Grepper

Tags: schema typeorm typescript

Link to this answer
Share Copy Link

Contributed on Jun 01 2022

Restu Wahyu Saputra

0 Answers Avg Quality 2/10

Closely Related Answers

typeorm

Comment

npm install typeorm -g
typeorm init --name MyProject --database mysql

Popularity 10/10 Helpfulness 2/10 Language shell

Source: typeorm.io

Tags: shell shel

Link to this answer
Share Copy Link

Contributed on Nov 24 2020

Breakable Bison

0 Answers Avg Quality 2/10

typeorm IN

Comment

.where("user.name IN (:...names)", { names: [ "Timber", "Cristal", "Lina" ] })

Popularity 10/10 Helpfulness 2/10 Language javascript

Source: Grepper

Tags: javascript j

Link to this answer
Share Copy Link

Contributed on Jan 12 2022

Drab Dormouse

0 Answers Avg Quality 2/10

typeorm

Comment

npx typeorm init --name MyProject --database postgres

Initiate a project using typeorm cli. Project will be named 'MyProject' and use 'postgres' for its database.

Popularity 10/10 Helpfulness 1/10 Language javascript

Source: typeorm.io

Tags: javascript j

Link to this answer
Share Copy Link

Contributed on Jun 02 2023

Hapless Hacker

0 Answers Avg Quality 2/10

typeorm

Comment

import "reflect-metadata"
import { DataSource } from "typeorm"
import { User } from "./entity/User"

export const AppDataSource = new DataSource({
    type: "pg",
    host: "localhost",
    port: 3306,
    username: "test",
    password: "test",
    database: "testdb",
    synchronize: true,
    logging: false,
    entities: [User],
    migrations: [],
    subscribers: [],
})

Popularity 10/10 Helpfulness 1/10 Language whatever

Source: blog.logrocket.com

Tags: typeorm

Link to this answer
Share Copy Link

Contributed on May 18 2022

Proud Parrot

0 Answers Avg Quality 2/10

typeorm

Contents

More Related Answers

typeorm

Closely Related Answers

typeorm

typeorm IN

typeorm

typeorm

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.