Method clear

packages/sql/src/schema/SqlSchemaGenerator.ts:184–220

(options?: ClearDatabaseOptions)

  }

  override async clear(options?: ClearDatabaseOptions): Promise<void> {
    // truncate by default, so no value is considered as true
    /* v8 ignore next */
    if (options?.truncate === false) {
      return super.clear(options);
    }

    if (this.options.disableForeignKeysForClear) {
      await this.execute(this.helper.disableForeignKeysSQL());
    }

    const schema = options?.schema ?? this.config.get('schema', this.platform.getDefaultSchemaName());

    for (const meta of this.getOrderedMetadataForClear(schema).reverse()) {
      try {
        await this.driver
          .createQueryBuilder(meta.class, this.em?.getTransactionContext(), 'write', false)
          .withSchema(schema)
          .truncate()
          .execute();
      } catch (e) {
        if (this.platform.getExceptionConverter().convertException(e as Error) instanceof TableNotFoundException) {
          continue;
        }

        throw e;
      }
    }

    if (this.options.disableForeignKeysForClear) {
      await this.execute(this.helper.enableForeignKeysSQL());
    }

    if (options?.clearIdentityMap ?? true) {
      this.clearIdentityMap();
    }
  }

  override async getDropSchemaSQL(options: Omit<DropSchemaOptions, 'dropDb'> = {}): Promise<string> {
    await this.ensureDatabase();