export function writeOneOffSignup()

in src/create-reminder-signup/lib/db.ts [5:48]

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

export function writeOneOffSignup(
	signup: OneOffSignup,
	pool: Pool,
): Promise<QueryResult> {
	const query: QueryConfig = {
		text: `
			INSERT INTO one_off_reminder_signups(
				identity_id,
				country,
				reminder_period,
				reminder_created_at,
				reminder_platform,
				reminder_component,
				reminder_stage,
				reminder_option
			) VALUES (
				$1, $2, $3, $4, $5, $6, $7, $8
			)
			ON CONFLICT ON CONSTRAINT one_off_reminder_signups_identity_id_reminder_period_key
			DO
				UPDATE SET
					country = $2,
					reminder_created_at = $4,
					reminder_platform = $5,
					reminder_component = $6,
					reminder_stage = $7,
					reminder_option = $8,
					reminder_cancelled_at = NULL
			RETURNING *;
		`,
		values: [
			signup.identity_id,
			signup.country,
			signup.reminder_period,
			signup.reminder_created_at,
			signup.reminder_platform,
			signup.reminder_component,
			signup.reminder_stage,
			signup.reminder_option,
		],
	};

	return runWithLogging(query, pool);
}