Class: Rfm::CompoundQuery

Inherits:
Array show all
Defined in:
lib/rfm/utilities/compound_query.rb

Overview

Class to build complex FMP queries. Perform Filemaker find using complex boolean logic (multiple value options for a single field), or create multiple find requests. Also allow find requests to be :omit.

Instance Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Methods inherited from Array

#_merge_object!, #rfm_extend_member, #rfm_extend_members, #rfm_extract_options!

Constructor Details

#initialize(query, options = {}) ⇒ CompoundQuery

New CompoundQuery objects expect one of 3 data types:

  • string/integer representing FMP internal record id

  • hash of find-criteria

  • array of find-criteria hashes

Returns self as [‘-fmpaction’, :key=>‘values’, :options=>‘hash’]



23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/rfm/utilities/compound_query.rb', line 23

def initialize(query, options={})
	@options = options
	@field_mapping = options.delete(:field_mapping) || {}
	@original_input = query
@key_values = {}
@key_arrays = []
@key_map = []
@key_map_string = ''
@key_counter = 0

	case query
when Hash
	if query.detect{|k,v| v.kind_of? Array or k == :omit}
		@query_type = 'mixed'
	else
		@query_type = 'standard'
	end
when Array
	@query_type = 'compound'
else
	@query_type = 'recid'
end
build_query
end

Instance Attribute Details

#field_mapping ⇒ Object

Returns the value of attribute field_mapping.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def field_mapping
  @field_mapping
end

#key_arrays ⇒ Object

Returns the value of attribute key_arrays.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def key_arrays
  @key_arrays
end

#key_counter ⇒ Object

Returns the value of attribute key_counter.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def key_counter
  @key_counter
end

#key_map ⇒ Object

Returns the value of attribute key_map.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def key_map
  @key_map
end

#key_map_string ⇒ Object

Returns the value of attribute key_map_string.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def key_map_string
  @key_map_string
end

#key_values ⇒ Object

Returns the value of attribute key_values.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def key_values
  @key_values
end

#original_input ⇒ Object

Returns the value of attribute original_input.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def original_input
  @original_input
end

#query_type ⇒ Object

Returns the value of attribute query_type.



11
12
13
 
# File 'lib/rfm/utilities/compound_query.rb', line 11

def query_type
  @query_type
end

Class Method Details

.build_test ⇒ Object 



13
14
15
 
# File 'lib/rfm/utilities/compound_query.rb', line 13

def self.build_test
	new([{:field1=>['val1a','val1b','val1c'], :field2=>'val2'},{:omit=>true, :field3=>'val3', :field4=>'val4'}, {:omit=>true, :field5=>['val5a','val5b'], :field6=>['val6a','val6b']}], {})
end

Instance Method Details

#build_key_map(key_array) ⇒ Object

Input array of arrays. Transform single key_array into key_map (array of requests). Creates all combinations of sub-arrays where each combination contains one element of each subarray.



96
97
98
99
100
101
102
103
 
# File 'lib/rfm/utilities/compound_query.rb', line 96

def build_key_map(key_array)
	key_array = key_array.clone
	omit = key_array.delete(:omit)
	len = key_array.length
	flat = key_array.flatten
	rslt = flat.combination(len).select{|c| key_array.all?{|a| (a & c).size > 0}}.each{|c| c.unshift(:omit) if omit}
	@key_map.concat rslt
end

#build_key_values(input_hash) ⇒ Object

Build key-value definitions and query map ‘-q1…’. Converts query_hash to fmresultset uri format for -findquery query type.



72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
 
# File 'lib/rfm/utilities/compound_query.rb', line 72

def build_key_values(input_hash)
	input_hash = input_hash.clone
	keyarray = []
	omit = input_hash.delete(:omit)
	input_hash.each do |key,val|
		query_tag = []
		val = val.rfm_force_array
		val.each do |v|
			@key_values["-q#{key_counter}"] = field_mapping[key] || key
			@key_values["-q#{key_counter}.value"] = v
			query_tag << "q#{key_counter}"
			@key_counter += 1
		end
		keyarray << query_tag
	end
	(keyarray << :omit) if omit
	@key_arrays << keyarray
	keyarray
end

#build_query(input = original_input) ⇒ Object

Master control method to build output



49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
 
# File 'lib/rfm/utilities/compound_query.rb', line 49

def build_query(input=original_input)
	case @query_type
	when 'mixed', 'compound'
		input.rfm_force_array.each do |hash|
			build_key_map(build_key_values(hash))
		end
		translate_key_map
		self.push '-findquery'
		self.push @key_values.merge('-query'=>@key_map_string)
	when 'standard'
		self.push '-find'
		self.push @original_input
	when 'recid'
		self.push '-find'
		self.push '-recid' => @original_input.to_s
	end
	self.push @options
	self
end

#translate_key_map(keymap = key_map) ⇒ Object

Translate @key_map to FMP -query string



106
107
108
109
110
111
 
# File 'lib/rfm/utilities/compound_query.rb', line 106

def translate_key_map(keymap=key_map)
	keymap = keymap.clone
	inner = keymap.collect {|a| "#{'!' if a.delete(:omit)}(#{a.join(',')})"}
	outter = inner.join(';')
	@key_map_string << outter
end