module WolfCore::FkmOperations
def create_foreign_key(tenant:, source:, source_id:, destination:, destination_id:)
def create_foreign_key(tenant:, source:, source_id:, destination:, destination_id:) raise_service_error({ message: 'tenant is required to create a foreign key', tenant: tenant }) if tenant.blank? raise_service_error({ message: 'source is required to create a foreign key', source: source }) if source.blank? raise_service_error({ message: 'source_id is required to create a foreign key', source_id: source_id }) if source_id.blank? raise_service_error({ message: 'destination is required to create a foreign key', destination: destination }) if destination.blank? raise_service_error({ message: 'destination_id is required to create a foreign key', destination_id: destination_id }) if destination_id.blank? response = http_post( url: "#{ENV['FKM_URL']}/Prod/create", body: { tenant: tenant, source: source, source_id: source_id, destination: destination, destination_id: destination_id } ) response = parse_http_response(response) log_object response, title: 'create_foreign_key response is' validate_http_response(response: response, message: 'Error creating foreign key') parse_http_response(response).body end
def find_or_create_foreign_key(tenant:, source:, source_id:, destination:, destination_id:)
def find_or_create_foreign_key(tenant:, source:, source_id:, destination:, destination_id:) found_destination_id = get_foreign_key_destination_id( tenant: tenant, source: source, source_id: source_id, destination: destination ) log_object "find_or_create_foreign_key found_destination_id is #{found_destination_id}" return Result.success(data: { operation: :find }) if found_destination_id.present? create_foreign_key( tenant: tenant, source: source, source_id: source_id, destination: destination, destination_id: destination_id ) Result.success(data: { operation: :create }) end
def get_foreign_key_by_destination(tenant:, source:, source_id:, destination:)
def get_foreign_key_by_destination(tenant:, source:, source_id:, destination:) foreign_keys = get_foreign_keys(tenant: tenant, source: source, source_id: source_id) foreign_keys.find { |fk| fk['destination'] == destination } end
def get_foreign_key_destination_id(tenant:, source:, source_id:, destination:)
def get_foreign_key_destination_id(tenant:, source:, source_id:, destination:) foreign_key = get_foreign_key_by_destination( tenant: tenant, source: source, source_id: source_id, destination: destination ) foreign_key&.dig('destination_id') end
def get_foreign_keys(tenant:, source:, source_id:)
def get_foreign_keys(tenant:, source:, source_id:) response = http_get( url: "#{ENV['FKM_URL']}/Prod/lookup?tenant=#{tenant}&source=#{source}&source_id=#{source_id}" ) response = parse_http_response(response) log_object response, title: 'get_foreign_keys response is' validate_http_response(response: response, message: 'Error getting foreign keys') response.body end
def get_foreign_keys_by_destination(tenant:, destination:, destination_id:)
def get_foreign_keys_by_destination(tenant:, destination:, destination_id:) response = http_get( url: "#{ENV['FKM_URL']}/Prod/lookup?tenant=#{tenant}&destination=#{destination}&destination_id=#{destination_id}" ) response = parse_http_response(response) log_object response, title: 'get_foreign_keys_by_destination response is' validate_http_response(response: response, message: 'Error getting foreign keys by destination id') response.body end
def update_foreign_key(tenant:, auth_token:, uuid:, source: nil, source_id: nil, destination: nil, destination_id: nil)
def update_foreign_key(tenant:, auth_token:, uuid:, source: nil, source_id: nil, destination: nil, destination_id: nil) raise_service_error({ message: 'tenant is required to update a foreign key', tenant: tenant }) if tenant.blank? raise_service_error({ message: 'auth_token is required to update a foreign key', auth_token: auth_token }) if auth_token.blank? raise_service_error({ message: 'uuid is required to update a foreign key', uuid: uuid }) if uuid.blank? fields_to_update = { source: source, source_id: source_id, destination: destination, destination_id: destination_id, }.compact raise_service_error({ message: 'At least one field to update is required to update a foreign key', source: source }) if fields_to_update.blank? body = { tenant: tenant, authentication_token: auth_token, uuid: uuid, }.merge(fields_to_update) log_object body, title: 'update_foreign_key body is' response = safe_http_put( url: "#{ENV['FKM_URL']}/Prod/update", body: body, title: 'update_foreign_key response is', error_message: 'Error updating foreign key', ) response.body end
def upsert_foreign_key(tenant:, auth_token:, source:, source_id:, destination:, destination_id:)
def upsert_foreign_key(tenant:, auth_token:, source:, source_id:, destination:, destination_id:) foreign_key = get_foreign_key_by_destination( tenant: tenant, source: source, source_id: source_id, destination: destination ) if foreign_key.present? update_foreign_key( tenant: tenant, auth_token: auth_token, uuid: foreign_key['uuid'], source: source, source_id: source_id, destination: destination, destination_id: destination_id, ) else create_foreign_key( tenant: tenant, source: source, source_id: source_id, destination: destination, destination_id: destination_id ) end end