我正在尝试使用NestJS和TypeORM为我的数据库添加种子。
我有一个创建exercise表的迁移文件和一个将ExerciseEntity插入到表中的种子文件。这些文件之间的主要区别是迁移文件直接运行查询:
public async up(queryRunner: QueryRunner): Promise<any> {
await queryRunner.query(
`CREATE TABLE ...`
);
}当种子文件获得存储库时:
public async up(queryRunner: QueryRunner): Promise<any> {
await queryRunner.manager.getRepository<ExerciseEntity>(ExerciseEntity).save(
someExerciseEntity
);
}这个getRepository是创建错误的那个。
RepositoryNotFoundError: No repository for "ExerciseEntity" was found. Looks like this entity is not registered in current "default" connection?
at new RepositoryNotFoundError (C:\Users\Dev\Documents\team-management\src\error\RepositoryNotFoundError.ts:10:9)
at EntityManager.getRepository (C:\Users\Dev\Documents\team-management\src\entity-manager\EntityManager.ts:1194:19)
at SeedExercises1584903747780.<anonymous> (C:\Users\Dev\Documents\team-management\dist\apps\api\_seeds\dev\webpack:\_seeds\dev\1584903747780-SeedExercises.ts:7:31)在服务中,我获得存储库并保存实体,而不存在任何问题。这个问题只会在播种时发生。
我注册TypeORM的方式如下:
// app.module.ts
@Module({})
export class AppModule implements NestModule {
static forRoot(): DynamicModule {
return {
module: AppModule,
imports: [
ConfigModule.forRoot({
envFilePath: '.env.dev',
validationSchema: validationSchema()
}),
TypeOrmModule.forRootAsync({
imports: [ConfigModule],
inject: [ConfigService],
useFactory: async (configService: ConfigService) => databaseProviders(configService)
}),
ExercisesModule.forRoot()
]
};
}
}其中:
// database.provider.ts
export const databaseProviders = (configService: ConfigService) => {
const normalizePath = (_path: string) => (path.normalize(path.join(__dirname, _path)));
const commonDB: TypeOrmModuleOptions = {
type: 'sqlite',
entities: [...exercisesEntities]
};
// exerciseEntities comes from an index.ts in an exercise library
// import { ExerciseEntity } from './exercise.entity';
// export const exercisesEntities = [ExerciseEntity];
const defaultDB: TypeOrmModuleOptions = {
...commonDB,
database: path.join(
configService.get('APP_ROOT_PATH', '.'),
configService.get('TYPEORM_DATABASE', 'gym-dev.sqlite')
),
logging: configService.get<boolean>('TYPEORM_ENABLE_LOGGING', true) ? ['query', 'error'] : [],
cache: true,
synchronize: configService.get<boolean>('TYPEORM_SYNCHRONIZE', false),
migrations: [normalizePath('_migrations/*.js'), normalizePath('_seeds/dev/*.js')],
migrationsRun: configService.get<boolean>('TYPEORM_MIGRATIONS_RUN', true),
dropSchema: configService.get<boolean>('DROP_SCHEMA', false)
};
return defaultDB;
};我使用nrwl/nx编译和服务应用程序,使用以下webpack配置:
module.exports = function(config, context) {
const baseDirectory = path.resolve(config.output.path);
const entityPaths = ['libs/feature/api/**/entities/*.js'];
const migrationPaths = ['_migrations/*.js', '_seeds/**/*.js'];
config.entry = {
...config.entry,
...getEntityEntries(entityPaths),
...getMigrationEntries(migrationPaths)
};
// getEntries functions allows the compilation of entities and migrations
// Output
config.output = {
path: baseDirectory,
filename: '[name].js',
libraryTarget: 'commonjs'
};
return config;
};我的dist结构最终是:
dist
|-apps
|-api
|-_migrations // contains compiled migrations
|-_seeds // contains compiled seeders
|-lib
|-entities // contains compiled entities
|-main.js正如在app.module.ts中所看到的,我使用TypeOrmModule.forRootAsync来注入配置服务。我怀疑,当种子者被执行时,储存库还没有注册。这将解释以后,在运行web应用程序时,服务可以访问存储库。
知道我怎么解决这个问题吗?
我的配置是错的还是遗漏了什么?如果存在问题,播种机中是否有一种方法可以等待存储库被注册?
编辑:
它与TypeOrmModule.forRootAsync没有任何关系。我做了以下修改:
// app.module.ts
@Module({})
export class AppModule implements NestModule {
static forRoot(): DynamicModule {
return {
module: AppModule,
imports: [
ConfigModule.forRoot({
envFilePath: '.env.dev',
validationSchema: validationSchema()
}),
TypeOrmModule.forRoot(databaseProvidersSync()),
ExercisesModule.forRoot()
]
};
}
}// database.providers.ts
export const databaseProvidersSync = () => {
const normalizePath = (_path: string) => (path.normalize(path.join(__dirname, _path)));
const defaultDB: TypeOrmModuleOptions = {
type: 'sqlite',
entities: [...exercisesEntities],
database: path.normalize(`C:\\Users\\Dev\\Documents\\team-management\\gym-dev.sqlite`),
logging: ['query', 'error'],
cache: true,
synchronize: false,
migrations: [normalizePath('_migrations/*.js'), normalizePath('_seeds/dev/*.js')],
migrationsRun: true,
dropSchema: true
}
return defaultDB;
}错误是一样的。
发布于 2020-03-29 17:32:36
问题来自于当前的TypeORM版本(0.2.24)。
我切换到0.2.22,它起了作用,没有改变任何其他东西。
下面是我用这篇文章打开的问题,最后问他们希望什么时候修复:https://github.com/typeorm/typeorm/issues/5781
这里有些问题似乎在上一个版本中谈到了这个问题:
https://stackoverflow.com/questions/60917454
复制相似问题