Method create

lib/models/user.ts:234–270

(
    user: User,
    verificationId: string,
    type: VerificationCode['verification']['type'],
  )

export class VerificationCodeModel {
  static async create(
    user: User,
    verificationId: string,
    type: VerificationCode['verification']['type'],
  ) {
    const inThirtyMinutes = new Date(new Date().setUTCMinutes(new Date().getUTCMinutes() + 30));

    const code = generateRandomCode();

    const newVerificationCode: Omit<VerificationCode, 'id' | 'created_at'> = {
      user_id: user.id,
      code,
      expires_at: inThirtyMinutes,
      verification: {
        id: verificationId,
        type,
      },
    };

    await db.query(
      sql`INSERT INTO "bewcloud_verification_codes" (
        "user_id",
        "code",
        "expires_at",
        "verification"
      ) VALUES ($1, $2, $3, $4)
        RETURNING "id"`,
      [
        newVerificationCode.user_id,
        newVerificationCode.code,
        newVerificationCode.expires_at,
        JSON.stringify(newVerificationCode.verification),
      ],
    );

    return code;
  }

  static async validate(
    user: User,