typeorm连库

33 阅读1分钟

1、安装包 数据库用的postgresql,所以要安装pg。

 npm i  @nestjs/typeorm typeorm pg

2、连接库 app.module.ts:

import { Module } from '@nestjs/common';
import { AppController } from './app.controller';
import { AppService } from './app.service';
import { NewsModule } from './news/news.module';
import { TypeOrmModule } from '@nestjs/typeorm';
import { CateModule } from './cate/cate.module';
@Module({
  imports: [TypeOrmModule.forRoot({
    "type": "postgres",
    "host": "localhost",
    "port": 5432,
    "password": "admin",
    "username": "postgres",
    "database": "test",
    synchronize:true,
    autoLoadEntities:true
  }),NewsModule, CateModule],
  controllers: [AppController],
  providers: [AppService],
})
export class AppModule {}

3、定义实体 news.entity.ts:

import { Column, PrimaryGeneratedColumn,Entity, CreateDateColumn } from "typeorm";
@Entity({
    name: 'news'
})
export class News {
    @PrimaryGeneratedColumn('uuid')
    id:string
    @Column()
    name:string
    // 开始时间
    @Column('timestamp')
    startTime: Date
    @CreateDateColumn()
    createTime: Date
}

news.module.ts:

import { Module } from '@nestjs/common';
import { NewsService } from './news.service';
import { NewsController } from './news.controller';
import { TypeOrmModule } from '@nestjs/typeorm';
import { News } from './entities/news.entity';
@Module({
  imports:[TypeOrmModule.forFeature([News])],
  controllers: [NewsController],
  providers: [NewsService],
})
export class NewsModule {}