Seed permanent data in typeORM v.0.3.6 with DataSource

Question

Is there a simple way to seed data in typeORM v.0.3.6 with DataSource ? typeorm-seeding seems to use Connection which is deprecated.

Answer 1

I used "typeorm-seeding": "^1.6.1" and the following were the steps I took.

1. Create an ormconfig.ts file with the content below

require('dotenv').config();

module.exports = {
    type: "postgres",
    host: process.env.DB_HOST,
    port: 5432,
    username: process.env.DB_USERNAME,
    password: process.env.DB_PASSWORD,
    database: process.env.DB_NAME,
    entities: ["src/db/entities/**/*.ts"],
    seeds: ['src/db/seeds/**/*{.ts,.js}'],
    factories: ['src/db/factories/**/*{.ts,.js}'],
}

2. You have your entity defined in src/db/entities according to the above ormconfig.ts and assuming you have your User.ts entity defined there with the following content

@Entity()
export class User {

    @PrimaryGeneratedColumn("uuid")
    id: string

    @Column()
    firstName: string

    @Column()
    lastName: string

    @IsEmail()
    @Column({
        unique: true,
    })
    email: string

    @Column()
    password: string
}

3. Create your seeder file src/db/seeds/createUser.ts

import { Factory, Seeder } from 'typeorm-seeding'
import { DataSource } from 'typeorm'
import { User } from '../entities/User'
import * as bcrypt from "bcrypt"

export default class CreateUsers implements Seeder {
    public async run(factory: Factory, datasource: DataSource): Promise<any> {
        const salt = 10
        const password = await bcrypt.hash("password", salt)
        await datasource
            .createQueryBuilder()
            .insert()
            .into(User)
            .values([
                { firstName: 'Timber', lastName: 'Saw', email: "[email protected]", password },
                { firstName: 'Phantom', lastName: 'Lancer', email: "[email protected]", password},
            ])
            .execute()
    }
}

4. With the command npm run seed:run then your seeder is done

You can check Typeorm Seeding Link for more information.