使用 Nestjs 设计 RBAC 权限系统：分步指南

<code class="sql">CREATE DATABASE `nest-database` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;</code>

<code class="bash">nest new nest-project</code>

<code class="bash">npm install --save @nestjs/typeorm typeorm mysql2</code>

<code class="typescript">import { Module } from '@nestjs/common';
import { AppController } from './app.controller';
import { AppService } from './app.service';
import { TypeOrmModule } from '@nestjs/typeorm';

@Module({
  imports: [
    TypeOrmModule.forRoot({
      type: 'mysql',
      host: 'localhost',
      port: 3306,
      username: 'root',
      password: 'password',
      database: 'nest-database',
      synchronize: true,
      logging: true,
      entities: [__dirname + '/**/*.entity{.ts,.js}'],
      poolSize: 10,
      connectorPackage: 'mysql2',
    }),
  ],
  controllers: [AppController],
  providers: [AppService],
})
export class AppModule {}</code>

<code class="typescript">// ... (import statements)

@Entity()
export class User {
  // ... (fields and relationships)
}</code>

<code class="typescript">// ... (import statements)

@Entity()
export class Role {
  // ... (fields and relationships)
}</code>

<code class="typescript">// ... (import statements)

@Entity()
export class Permission {
  // ... (fields)
}</code>