defmodule Ami.AffiliateLogo do use Ecto.Schema # import Ecto.Query alias Ami.{ Course } schema "affiliate_logos" do field(:file, :string) field(:name, :string) belongs_to(:course, Course, foreign_key: :course_id) end def affiliate_logo_for_course(logos_list) do logo = List.last(logos_list) if logo != nil, do: "https://ami-aws-s3.s3.amazonaws.com/uploads/affiliate_logo/file/#{logo.id}/#{logo.file}" end end