lib/multiwoven/integrations/source/salesforce_consumer_goods_cloud/schema_helper.rb



# frozen_string_literal: true

module Multiwoven
  module Integrations
    module Source
      module SalesforceConsumerGoodsCloud
        module SchemaHelper
          include Core::Constants

          module_function

          def salesforce_field_to_json_schema_type(sf_field) # rubocop:disable Metrics/MethodLength, Metrics/PerceivedComplexity
            case sf_field["type"]
            when "string", "Email", "Phone", "Text", "TextArea", "TextEncrypted", "URL", "Picklist (Single)"
              if sf_field["nillable"]
                { "type": %w[string null] }
              else
                { "type": "string" }
              end
            when "double", "Currency", "Percent"
              if sf_field["nillable"]
                { "type": %w[number null] }
              else
                { "type": "number" }
              end
            when "boolean", "Checkbox"
              if sf_field["nillable"]
                { "type": %w[boolean null] }
              else
                { "type": "boolean" }
              end
            when "int", "AutoNumber"
              if sf_field["nillable"]
                { "type": %w[integer null] }
              else
                { "type": "integer" }
              end
            when "date"
              if sf_field["nillable"]
                { "type": %w[string null], "format": "date" }
              else
                { "type": "string", "format": "date" }
              end
            when "datetime", "DateTime"
              if sf_field["nillable"]
                { "type": %w[string null], "format": "date-time" }
              else
                { "type": "string", "format": "date-time" }
              end
            when "time"
              if sf_field["nillable"]
                { "type": %w[string null], "format": "time" }
              else
                { "type": "string", "format": "time" }
              end
            when "textarea", "Text Area (Long)", "Text Area (Rich)"
              if sf_field["nillable"]
                { "type": %w[string null] }
              else
                { "type": "string" }
              end
            when "picklist", "multipicklist", "Picklist (Multi-select)"
              if sf_field[:picklistValues] && sf_field["nillable"]
                enum_values = sf_field[:picklistValues].map { |val| val["value"] }
                { "type": %w[string null], "items": { "type": "string" }, "enum": enum_values }
              elsif sf_field[:picklistValues]
                enum_values = sf_field[:picklistValues].map { |val| val["value"] }
                { "type": "string", "items": { "type": "string" }, "enum": enum_values }
              else
                { "type": "string", "items": { "type": "string" } }
              end
            when "reference", "Reference (Lookup & Master-Detail)"
              if sf_field["nillable"]
                { "type": %w[string null] }
              else
                { "type": "string" }
              end
            when "location", "Geolocation"
              if sf_field["nillable"]
                { "type": %w[object null], "properties": { "latitude": { "type": "number" }, "longitude": { "type": "number" } } }
              else
                { "type": "object", "properties": { "latitude": { "type": "number" }, "longitude": { "type": "number" } } }
              end
            else
              if sf_field["nillable"]
                { "type": %w[string null] }
              else
                { "type": "string" }
              end
            end
          end

          def create_json_schema_for_object(metadata)
            fields_schema = metadata["fields"].map do |field|
              {
                "#{field[:name]}": salesforce_field_to_json_schema_type(field)
              }
            end.reduce(:merge)

            json_schema = {
              "$schema": "http://json-schema.org/draft-07/schema#",
              "title": metadata["name"],
              "type": "object",
              "additionalProperties": true,
              "properties": fields_schema
            }

            required = metadata["fields"].map do |field|
              field["name"] if field["nillable"] == false
            end.compact
            primary_key = metadata["fields"].map do |field|
              field["name"] if field["nillable"] == false && field["unique"] == true
            end.compact

            {
              "name": metadata["name"],
              "action": "create",
              "json_schema": json_schema,
              "required": required,
              "supported_sync_modes": %w[incremental],
              "source_defined_primary_key": [primary_key],
              "source_defined_cursor": false,
              "default_cursor_field": nil
            }
          end
        end
      end
    end
  end
end