Module: OrientSupport::Support

Included in:
ActiveOrient::API, ActiveOrient::OrientDB, ModelClass, Array, Hash, MatchConnection, MatchStatement, OrientQuery
Defined in:
lib/support/orientquery.rb

Instance Method Summary collapse

Instance Method Details

#as(a = nil) ⇒ Object 



93
94
95
96
97
98
99
100
101
102
103
 
# File 'lib/support/orientquery.rb', line 93

def as a=nil
	if a
		@q[:as] = a   # subsequent calls overwrite older entries
	else
		if @q[:as].blank?
			nil
		else
			"as: #{ @q[:as] }"
		end
	end
end

#compose_where(*arg, &b) ⇒ Object 



20
21
22
23
24
25
26
27
 
# File 'lib/support/orientquery.rb', line 20

def compose_where *arg , &b
			arg = arg.flatten.compact

			unless arg.blank? 
g= generate_sql_list( arg , &b)
"where #{g}" unless g.empty?
			end
end

#generate_sql_list(attributes = {}, &b) ⇒ Object

designs a list of “Key = Value” pairs combined by “and” or the binding provided by the block

ORD.generate_sql_list  where: 25 , upper: '65' 
 => "where = 25 and upper = '65'"
ORD.generate_sql_list(  con_id: 25 , symbol: :G) { ',' } 
 => "con_id = 25 , symbol = 'G'"

If »NULL« should be addressed, { key: nil } is translated to “key = NULL” (used by set: in update and upsert), { key: [nil] } is translated to “key is NULL” ( used by where )



40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
 
# File 'lib/support/orientquery.rb', line 40

def generate_sql_list attributes = {},  &b
	fill = block_given? ? yield : 'and'
	case attributes 
	when ::Hash
		attributes.map do |key, value|
			case value
			when nil
				"#{key} =  NULL"
			when ::Array
				if value == [nil]
				"#{key} is NULL"
				else	
				"#{key} in #{value.to_orient}"
				end
			when Range
				"#{key} between #{value.first} and #{value.last} " 
			else #  String, Symbol, Time, Trueclass, Falseclass ...
				"#{key} = #{value.to_or}"
			end
		end.join(" #{fill} ")
	when ::Array
		attributes.map{|y| generate_sql_list y, &b }.join( " #{fill} " )
	when String
		attributes
	when Symbol, Numeric
		attributes.to_s
	end		
end

#where(value = nil) ⇒ Object

:nodoc:



80
81
82
83
84
85
86
87
88
89
90
91
 
# File 'lib/support/orientquery.rb', line 80

def where  value=nil     # :nodoc:
	if value.present?
		if value.is_a?( Hash ) && value.size >1
										value.each {| a,b| where( {a => b} ) }
		else
			@q[:where] <<  value
		end
		self
	elsif @q[:where].present?
		"where #{ generate_sql_list( @q[:where] ){ @fill || 'and' } }"
	end
end

#while_s(value = nil) ⇒ Object

while and where depend on @q, a struct



72
73
74
75
76
77
78
79
 
# File 'lib/support/orientquery.rb', line 72

def while_s  value=nil     # :nodoc:
	if value.present?
		@q[:while] << value
		self
	elsif @q[:while].present?
		"while #{ generate_sql_list( @q[:while] ) }"
	end
end