how can i get count of deleted rows with Typeorm delete function?

Question

using javascript and MS Sql Server. i have a delete function that i want to return the number of rows deleted.

await getRepository(tableName, 'connection')
      .createQueryBuilder()
      .delete()
      .where(`timeCreated BETWEEN '${startDate}' and '${endDate}'`)
      .execute();

Answer 1

Delete result should have number of rows affected property. However some database drivers may not support it, you can try it this way

const deleteResult = await getRepository(tableName, 'connection')
      .createQueryBuilder()
      .delete()
      .where(`timeCreated BETWEEN '${startDate}' and '${endDate}'`)
      .execute();

const affectedRows = deleteResult.affected;