export function getCreatedOrCancelledRecurringSignupsFromYesterday()

in src/signup-exports/lib/db.ts [33:59]

• 25 lines of code
• 1 McCabe index (conditional complexity)

export function getCreatedOrCancelledRecurringSignupsFromYesterday(
	pool: Pool,
): Promise<QueryResult> {
	const yesterday = getYesterday();

	const query: QueryConfig = {
		text: `
			SELECT
				identity_id,
				country,
				reminder_frequency_months,
				reminder_created_at::text,
				reminder_cancelled_at::text,
				reminder_platform,
				reminder_component,
				reminder_stage,
				reminder_option
			FROM
				recurring_reminder_signups
			WHERE
				DATE(updated_at) = DATE($1)
        `,
		values: [yesterday],
	};

	return runWithLogging(query, pool);
}