nestjs连接远程mysql_Nestjs 链接mysql

下插件

λ yarn add @nestjs/typeorm typeorm mysql

创建 cats模块， 控制器，service

λ nest g mo cats

λ nest g co cats

λ nest g s cats cats/

Client does not support authentication protocol requested by server; consider u pgrading MySQL client 如果出现这个错误 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的数据库密码';

// app.module.ts

import { Module } from '@nestjs/common';

import { AppController } from './app.controller';

import { AppService } from './app.service';

import { TypeOrmModule } from '@nestjs/typeorm'; #

import { Connection } from 'typeorm'; #

import { CatsModule } from './cats/cats.module';

@Module({

imports: [

TypeOrmModule.forRoot({

type: 'mysql',

host: 'localhost',

port: 3306,

username: 'root',

password: 'mysql登录密码',

database: 'nest',

entities: [__dirname + '/**/*.entity{.ts,.js}'],

synchronize: true,

}), #

CatsModule

],

controllers: [AppController],

providers: [AppService],

})

export class AppModule {

constructor(private readonly connection: Connection) {} #

}

编辑 entity

// cats.entity.ts

import { PrimaryGeneratedColumn, Column, Entity } from "typeorm";

@Entity()

export class Cats {

@PrimaryGeneratedColumn()

id: number;

@Column({length: 45})

name: string;

@Column('int')

age: number;

}

在cats.module.ts 中使用

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

import { Cats } from './cats.entity';

@Module({

imports: [TypeOrmModule.forFeature([Cats])],

})

export class CatsModule {}

注入 cats.service.ts

import { Injectable } from '@nestjs/common';

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

import { Cats } from './cats.entity';

import { Repository } from 'typeorm';

@Injectable()

export class CatsService {

constructor(

@InjectRepository(Cats)

private readonly catsRepository: Repository

) { }

find(){

return this.catsRepository.find()

}

getCat(name:string): Promise {

return this.catsRepository.find({ name });

}

}