export function getCreatedOrCancelledOneOffSignupsFromYesterday()

in src/signup-exports/lib/db.ts [5:31]

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

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

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

	return runWithLogging(query, pool);
}