공식 문서 : https://orkhan.gitbook.io/typeorm/readme_ko

1. install

pnpm install @nestjs/typeorm typeorm mysql

설치 해줌니다

2. configuration

src/common/database/configuation.ts

import { TypeOrmModuleOptions } from'@nestjs/typeorm';

const configuration: TypeOrmModuleOptions = {
  type: 'mariadb',
  host: '127.0.0.1',
  port: 3306,
  username: 'root',
  password: 'ghdcoalss33',
  database: 'live-pulse',
  logging:true,
  entities: ['./dist/**/**/*.entity{.ts,.js}'],
  synchronize:true,
};

export default configuration;

• 설정 톺아보기

만든 configuration 설정을 메인 모듈에 추가해줌니다

app.module.ts

@Module({
  imports: [BroadModule, TypeOrmModule.forRoot(configuration)],
  controllers: [AppController],
})
export class AppModule {}

3. Entity 정의

base 엔티티를 만들어줍니다

src/common/entities/base.entity.ts

export class BaseEntity {
  @PrimaryGeneratedColumn()
  id: number;

  @CreateDateColumn({ name: 'created_at' })
  createdAt: Date;

  @UpdateDateColumn({ name: 'updated_at' })
  updatedAt: Date;
}