query cache is not working in some functions

[ae2079]

When I was changing some code related to my issue, I realized that in some functions like this line:

impact-graph/src/repositories/donationRepository.ts

Lines 250 to 257 in 50b943b

	const donationsUsdAmount = await query.getRawOne();
	query.cache(
	`donationsTotalNumberPerDateRange-${fromDate || ''}-${toDate || ''}--${
	fromOptimismOnly || 'all'
	}-${onlyVerified || 'all'}`,
	300000,
	);

query.cache() method is called after the query execution, so the cache is not set, thus the cache does not work.

[ae2079]

@RamRamez
Do we need a QA test for this or we can move this issue to done state?

[RamRamez]

@ae2079 I think it's ok to move it to done

[ae2079]

Thank you @RamRamez