Automatizando la generacin de datos ficticios con Seed, Factory, Faker y TypeORM en NestJS

npm install --save @nestjs/typeorm [email protected] typeorm-extension

npm install pg --save

npm install --save @nestjs/config @types/bcrypt bcrypt

import { hash } from 'bcrypt';import { setSeederFactory } from 'typeorm-extension';import { User, UserRole } from 'src/user/entities/user.entity';export default setSeederFactory(User, async (faker) => {  const user = new User();  user.firstName = faker.name.firstName();  user.lastName = faker.name.lastName();  user.userName = faker.internet.userName(user.firstName, user.lastName);  user.email = faker.internet.email(user.firstName, user.lastName);  user.password = await hash(faker.internet.password(), 10);  user.phone = faker.phone.number();  user.avatar = faker.image.avatar();  user.role = faker.helpers.arrayElement([    UserRole.ADMIN,    UserRole.EDITOR,    UserRole.GHOST,  ]);  user.isActivated = faker.datatype.boolean();  return user;});

import { hash } from 'bcrypt';import { User, UserRole } from 'src/user/entities/user.entity';import { DataSource } from 'typeorm';import { Seeder, SeederFactoryManager } from 'typeorm-extension';export default class UserSeeder implements Seeder {  public async run(    dataSource: DataSource,    factoryManager: SeederFactoryManager,  ): Promise<any> {    const repository = dataSource.getRepository(User);    const data = {      userName: 'admin',      password: await hash('admin', 10),      role: UserRole.ADMIN,      isActivated: true,    };    const user = await repository.findOneBy({ userName: data.userName });    // Insert only one record with this username.    if (!user) {      await repository.insert([data]);    }    // ---------------------------------------------------    const userFactory = await factoryManager.get(User);    // Insert only one record.    await userFactory.save();    // Insert many records in database.    await userFactory.saveMany(40);  }}

import { Post } from 'src/post/entities/post.entity';import { User } from 'src/user/entities/user.entity';import { DataSource } from 'typeorm';import { Seeder, SeederFactoryManager } from 'typeorm-extension';export default class PostSeeder implements Seeder {  public async run(    dataSource: DataSource,    factoryManager: SeederFactoryManager,  ): Promise<any> {    const repository = dataSource.getRepository(User);    const user = await repository.findOneBy({      userName: 'admin',    });    const postFactory = await factoryManager.get(Post);    await postFactory.saveMany(2, { user });  }}

import { DataSource } from 'typeorm';import { runSeeders, Seeder, SeederFactoryManager } from 'typeorm-extension';import postFactory from 'database/factories/post.factory';import userFactory from 'database/factories/user.factory';import PostSeeder from './post.seeder';import UserSeeder from './user.seeder';export default class InitSeeder implements Seeder {  public async run(    dataSource: DataSource,    factoryManager: SeederFactoryManager,  ): Promise<any> {    await runSeeders(dataSource, {      seeds: [UserSeeder, PostSeeder],      factories: [userFactory, postFactory],    });  }}

import { ConfigModule } from '@nestjs/config';import { DataSource } from 'typeorm';import { SeederOptions } from 'typeorm-extension';import { DataSourceOptions } from 'typeorm/data-source';import InitSeeder from '../seeds/init.seeder';ConfigModule.forRoot({  envFilePath: '.env',});const options = {  type: 'postgres',  host: process.env.DATABASE_HOST || 'localhost',  port: parseInt(String(process.env.DATABASE_PORT), 10) || 5432,  username: process.env.DATABASE_USERNAME,  password: process.env.DATABASE_PASSWORD,  database: process.env.DATABASE_DATABASE,  entities: [__dirname + '/../../src/**/*.entity.ts'],  migrationsTableName: 'migrations',  migrations: [__dirname + '/../migrations/**/*.ts'],  seeds: [InitSeeder],};export const source = new DataSource(  options as DataSourceOptions & SeederOptions,);

DATABASE_HOST=localhostDATABASE_PORT=5432DATABASE_USERNAME=postgresDATABASE_PASSWORD=rootDATABASE_DATABASE=test

"scripts": {  ...  "typeorm": "ts-node -r tsconfig-paths/register node_modules/typeorm/cli.js -d database/config/typeorm.config.ts",  "mig-gen": "npm run typeorm migration:generate -- ",  "mig-run": "npm run typeorm migration:run",  "mig-rev": "npm run typeorm migration:revert",  "seed": "ts-node -r tsconfig-paths/register node_modules/typeorm-extension/dist/cli/index.js seed -d database/config/typeorm.config.ts"},

npm run mig-gen -- database/migrations/init

npm run mig-run

npm run seed