module Support
  module Helpers
    class XML
      def self.custom_film_dms_query(dms)
        client = Support::DbClient.dd_client
        query = "SELECT dep.dms_master_master_id, ep.url
FROM encoding_profile ep
INNER JOIN dms_encoding_profile dep ON ep.encoding_profile_id = dep.encoding_profile_id
WHERE dep.dms_master_master_id = {dms_master_master_id}
AND ep.profile_type = 'metadata'
AND dep.product_type_id = 3
AND dep.order_type = 'release';"
        query = query.gsub("{dms_master_master_id}", dms)
        case dms
        when "1", "392", "564", "702", "731"
          client.query(query).first["url"]
        when "487"
          client.query(query).find { |x| x["url"].include? "movielabsbasicmetadata" }["url"]
        end
      end
    end
  end
end