UNALE可以连接到Typeorm的Postgres

Question

我正在使用Nestjs将TypeOm作为数据库软件包连接到数据库。 我的Postgres正在Docker运行，IP 172.17.0.3：5432

sudo docker run -name postgre -e postgres_user = admin -e -e postgres_password =密码-P 5432：5432 -V /data/postgres：/var/lib/postgresql/data -d postgres

这是我的存储模块文件：

import { Module } from '@nestjs/common';
import { storageConfig, StorageService } from './storage.service';
import { TypeOrmModule} from '@nestjs/typeorm'
import { User } from './entities/user.entity';

@Module({
  providers: [StorageService],
  imports: [
    TypeOrmModule.forRoot({
      driver: 'pg',
      type: 'postgres',
      host: '172.17.0.3',
      port: 5432,
    
      username: 'admin',
      password: 'password',
      database: 'user_storage',
      schema: 'public',    
      entities: [User]    
    })
  ]
})
export class StorageModule {}

现在，我尝试导入users.module.ts

import { Module } from '@nestjs/common';
import { UsersService } from './users.service';
import { UsersController } from './users.controller';
import { TypeOrmModule } from '@nestjs/typeorm'

@Module({
  imports: [TypeOrmModule.forRoot()],
  controllers: [UsersController],
  providers: [UsersService]
})
export class UsersModule {}

，我在服务中使用存储库：

import { Injectable } from '@nestjs/common';
import { UserRequest, UserResponse } from './user.models';
import {DataSource, Repository } from 'typeorm'
import { User } from 'src/storage/entities/user.entity';



@Injectable()
export class UsersService {
  private readonly _users: Repository<User> 

  constructor(private ds: DataSource) { 
    this._users = this.ds.getRepository(User)
  }

  async create(req: UserRequest) {
    const user = this._users.create()

    user.id = 1
    user.name = req.name
    user.age = req.age
    user.address = req.address
    user.notes = ''

    const saveduser = await this._users.save(user)

    return saveduser.id;
  }
}

但是我随时会遇到此错误我运行：

[Nest] 36982  - 07/05/2022, 12:02:19 PM     LOG [NestFactory] Starting Nest application... 
[Nest] 36982  - 07/05/2022, 12:02:20 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)... MissingDriverError: Wrong driver: "undefined" given. Supported drivers are: "aurora-mysql", "aurora-postgres", "better-sqlite3", "capacitor", "cockroachdb", "cordova", "expo", "mariadb", "mongodb", "mssql", "mysql", "nativescript", "oracle", "postgres", "react-native", "sap", "sqlite", "sqljs", "spanner".
    at DriverFactory.create (/projects/hw/src/driver/DriverFactory.ts:72:23)
    at new DataSource (/projects/hw/src/data-source/DataSource.ts:139:43)
    at createTypeormDataSource (/projects/hw/node_modules/@nestjs/typeorm/dist/typeorm-core.module.js:172:23)
    at Function.<anonymous> (/projects/hw/node_modules/@nestjs/typeorm/dist/typeorm-core.module.js:176:46)
    at Generator.next (<anonymous>)
    at /projects/hw/node_modules/@nestjs/typeorm/dist/typeorm-core.module.js:20:71
    at new Promise (<anonymous>)
    at __awaiter (/projects/hw/node_modules/@nestjs/typeorm/dist/typeorm-core.module.js:16:12)
    at /projects/hw/node_modules/@nestjs/typeorm/dist/typeorm-core.module.js:174:76
    at Observable._subscribe (/projects/hw/node_modules/rxjs/src/internal/observable/defer.ts:55:15) [Nest] 36982  - 07/05/2022, 12:02:20 PM   ERROR [TypeOrmModule] Unable to connect to the database. Retrying (1)... TypeError: this.postgres.Pool is not a constructor
    at PostgresDriver.createPool (/projects/hw/src/driver/postgres/PostgresDriver.ts:1461:22)
    at PostgresDriver.connect (/projects/hw/src/driver/postgres/PostgresDriver.ts:340:38)
    at DataSource.initialize (/projects/hw/src/data-source/DataSource.ts:232:27)
    at Function.<anonymous> (/projects/hw/node_modules/@nestjs/typeorm/dist/typeorm-core.module.js:179:38)
    at Generator.next (<anonymous>)

是什么原因引起了这个问题，该如何解决？

Answer 1

对于仍在挣扎的任何人来说，另一个解决方案是使用commonjs语法导入您的ormconfig.js模块，并将其插入Typeorm的第一个参数。发生这种情况的原因是因为Typeorm在应用这些设置时不支持Typescript，因此使用关键字 import 导入ormconfig.js模块不起作用，因为在Vanilla nodejs中这样做的正确方法是使用要求。另外，不要忘记更改您的ormconfig.ts-＆gt; ormconfig.js：

import { Module } from '@nestjs/common';
import { TypeOrmModule } from '@nestjs/typeorm';
import { AppController } from './app.controller';
import { ConfigModule, ConfigService } from '@nestjs/config';
import { AppService } from './app.service';
import { UsersModule } from './users/users.module';
import { ReportsModule } from './reports/reports.module';
const settings = require('../ormconfig.js');


@Module({
  imports: [
    ConfigModule.forRoot({
      isGlobal: true,
      envFilePath: `.env.${process.env.NODE_ENV}`,
    }),
    TypeOrmModule.forRoot(settings),
    UsersModule,
    ReportsModule,
  ],
  controllers: [AppController],
  providers: [AppService],
})
export class AppModule {}

Answer 2

经过大量调试，我能够找到自己的错误。在users.module.ts中，我有此代码：

@Module({
  imports: [TypeOrmModule.forRoot()],
  controllers: [UsersController],
  providers: [UsersService]
})
export class UsersModule {}

我用typeormmodule.forroot（）用storageModule 开始工作。问题在于，使用typeormmodule.forroot（）作为空白，它无法使用storageModule中提供的任何配置
正确的一个：

@Module({
  imports: [StorageModule],
  controllers: [UsersController],
  providers: [UsersService]
})
export class UsersModule {}