TypeError: this.subQuery is not a function about typeorm-seeding HOT 10 CLOSED

Hi @brunoti
Could you please provide me your entity ApplicationToken for a full analysis.

Try to change the path to your entity. Maybe it can't find your entitiy.
from:

import { ApplicationToken } from '@backend/entities/ApplicationToken';

to static:

import { ApplicationToken } from '../entities/ApplicationToken';

from typeorm-seeding.

This also happened to me, fixed that by setting the TYPEORM_ENTITIES environment variable.

from typeorm-seeding.

The error TypeError: this.subQuery is not a function is because typeorm could not find any entities.

Please check your paths in your config file

from typeorm-seeding.

Hi @NMontilva

Sure the path to your entites is correct?

"entity/*.ts" should this be "src/**/*.entity{.ts,.js}"

from typeorm-seeding.

Hello @hirsch88

Thank you! That was it.

from typeorm-seeding.

I'm using ormconfig.json and I'm getting the same error as @brunoti
I already set the entities variable in the .json and nothing. Same error

Here is my ormconfig.json

{ "type": "mysql", "host": "localhost", "port": 3306, "username": "a_username", "password": "a_password", "database": "a_db", "entities": ["entity/*.ts","dist/**/*.entity{.ts,.js}"], "synchronize": true, "seeds": ["src/database/seeds/**/*.seed.ts"] }

UPDATE:

I downgraded typeorm to 0.2.22 and it's working again.

from typeorm-seeding.

I had the same issue

from typeorm-seeding.

Relatable, exactly the same error here!

#53 (comment) Downgrading typeorm to 0.2.22 doesn't work either

There are how my files look like:

maratona.entity.ts

import { Entity, Column, CreateDateColumn, PrimaryGeneratedColumn } from 'typeorm';

@Entity({ name: 'maratonas' })
export class Maratona {
  @PrimaryGeneratedColumn('uuid')
  id: string;

  @Column()
  title: string;

  @Column()
  date: Date;

  @CreateDateColumn()
  created_at?: Date;
}

maratona.seed.ts

import { Connection } from 'typeorm';
import { Factory, Seeder } from 'typeorm-seeding';

import { Maratona } from '../entities/maratona.entity';

export default class CreateUsers implements Seeder {
  public async run(factory: Factory, connection: Connection): Promise<any> {
    return await connection
      .createQueryBuilder()
      .insert()
      .into(Maratona)
      .values([
        { title: 'Full Cycle: Arquitetura e Estudo de Caso', date: `${new Date('04/05/2020')}` }
      ])
      .execute();
  }
}

.env

TYPEORM_CONNECTION=sqlite
TYPEORM_DATABASE=database.sqlite
TYPEORM_ENTITIES=src/**/*.entity{.ts,.js}
TYPEORM_MIGRATIONS=src/database/migrations/**/*.ts
TYPEORM_MIGRATIONS_DIR=src/database/migrations
TYPEORM_SEEDING_FACTORIES=src/database/factories/**/*{.ts,.js}
TYPEORM_SEEDING_SEEDS=src/database/seeds/**/*{.ts,.js}

from typeorm-seeding.

In addition to the path in ormconfig, check if your entities were imported in your module.

from typeorm-seeding.

For posterity: If you're using e.g. entities/index.ts to list your entities, make sure it is being exported there.

from typeorm-seeding.