Module: ArelExtensions::StringFunctions
- Included in:
- Arel::Nodes::Equality, Arel::Nodes::Function, Arel::Nodes::Grouping, Attributes, Nodes::Case
- Defined in:
- lib/arel_extensions/string_functions.rb
Instance Method Summary collapse
-
#&(other) ⇒ Object
*FindInSet function .……
- #[](start, ind = nil) ⇒ Object
- #ai_collate ⇒ Object
-
#ai_imatches(other) ⇒ Object
accent insensitive & case insensitive.
-
#ai_matches(other) ⇒ Object
accent insensitive & case sensitive.
- #blank ⇒ Object
- #ci_collate ⇒ Object
- #collate(ai = false, ci = false, option = nil) ⇒ Object
- #concat(other) ⇒ Object
- #downcase ⇒ Object
- #edit_distance(other) ⇒ Object
-
#group_concat(sep = nil, *orders, group: nil, order: nil) ⇒ Object
concat elements of a group, separated by sep and ordered by a list of Ascending or Descending.
- #idoes_not_match(others, escape = nil) ⇒ Object
- #idoes_not_match_all(others, escape = nil) ⇒ Object
- #idoes_not_match_any(others, escape = nil) ⇒ Object
- #imatches(others, escape = nil) ⇒ Object
-
#imatches_all(others, escape = nil) ⇒ Object
def grouping_any method, others, *extra puts “*******************” puts method puts others.inspect puts extra.inspect puts “——————-” res = super(method,others,*extra) puts res.to_sql puts res.inspect puts “*******************” res end.
- #imatches_any(others, escape = nil) ⇒ Object
-
#length ⇒ Object
LENGTH function returns the length of the value in a text field.
- #levenshtein_distance(other) ⇒ Object
-
#locate(val) ⇒ Object
LOCATE function returns the first starting position of a string in another string.
- #ltrim(other = ' ') ⇒ Object
- #md5 ⇒ Object
- #not_blank ⇒ Object
- #regexp_replace(pattern, substitute) ⇒ Object
- #repeat(other = 1) ⇒ Object
-
#replace(pattern, substitute) ⇒ Object
REPLACE function replaces a sequence of characters in a string with another set of characters, not case-sensitive.
- #rtrim(other = ' ') ⇒ Object
-
#smatches(other) ⇒ Object
accent sensitive & case sensitive.
-
#soundex ⇒ Object
SOUNDEX function returns a character string containing the phonetic representation of char.
- #substring(start, len = nil) ⇒ Object
-
#trim(other = ' ') ⇒ Object
Function returns a string after removing left, right or the both prefixes or suffixes int argument.
- #upcase ⇒ Object
Instance Method Details
#&(other) ⇒ Object
*FindInSet function .……
24 25 26 |
# File 'lib/arel_extensions/string_functions.rb', line 24 def &(other) ArelExtensions::Nodes::FindInSet.new [other, self] end |
#[](start, ind = nil) ⇒ Object
43 44 45 46 47 48 49 50 51 52 |
# File 'lib/arel_extensions/string_functions.rb', line 43 def [](start, ind = nil) start += 1 if start.is_a?(Integer) if start.is_a?(Range) ArelExtensions::Nodes::Substring.new [self, start.begin + 1, start.end - start.begin + 1] elsif start.is_a?(Integer) && !ind ArelExtensions::Nodes::Substring.new [self, start, 1] else ArelExtensions::Nodes::Substring.new [self, start, ind - start + 1] end end |
#ai_collate ⇒ Object
108 109 110 |
# File 'lib/arel_extensions/string_functions.rb', line 108 def ai_collate ArelExtensions::Nodes::Collate.new(self,nil,true,false) end |
#ai_imatches(other) ⇒ Object
accent insensitive & case insensitive
100 101 102 |
# File 'lib/arel_extensions/string_functions.rb', line 100 def ai_imatches other # accent insensitive & case insensitive ArelExtensions::Nodes::AiIMatches.new(self,other) end |
#ai_matches(other) ⇒ Object
accent insensitive & case sensitive
96 97 98 |
# File 'lib/arel_extensions/string_functions.rb', line 96 def ai_matches other # accent insensitive & case sensitive ArelExtensions::Nodes::AiMatches.new(self,other) end |
#blank ⇒ Object
173 174 175 |
# File 'lib/arel_extensions/string_functions.rb', line 173 def blank ArelExtensions::Nodes::Blank.new [self] end |
#ci_collate ⇒ Object
112 113 114 |
# File 'lib/arel_extensions/string_functions.rb', line 112 def ci_collate ArelExtensions::Nodes::Collate.new(self,nil,false,true) end |
#collate(ai = false, ci = false, option = nil) ⇒ Object
116 117 118 |
# File 'lib/arel_extensions/string_functions.rb', line 116 def collate ai = false,ci = false, option = nil ArelExtensions::Nodes::Collate.new(self,option,ai,ci) end |
#concat(other) ⇒ Object
133 134 135 |
# File 'lib/arel_extensions/string_functions.rb', line 133 def concat other ArelExtensions::Nodes::Concat.new [self, other] end |
#downcase ⇒ Object
165 166 167 |
# File 'lib/arel_extensions/string_functions.rb', line 165 def downcase ArelExtensions::Nodes::Downcase.new [self] end |
#edit_distance(other) ⇒ Object
189 190 191 |
# File 'lib/arel_extensions/string_functions.rb', line 189 def edit_distance other ArelExtensions::Nodes::LevenshteinDistance.new [self, other] end |
#group_concat(sep = nil, *orders, group: nil, order: nil) ⇒ Object
concat elements of a group, separated by sep and ordered by a list of Ascending or Descending
138 139 140 141 142 143 144 145 146 147 148 149 150 |
# File 'lib/arel_extensions/string_functions.rb', line 138 def group_concat(sep = nil, *orders, group: nil, order: nil) if orders.present? warn("Warning : ArelExtensions: group_concat: you should now use the kwarg 'order' to specify an order in the group_concat.") end order_tabs = [orders].flatten.map{ |o| if o.is_a?(Arel::Nodes::Ascending) || o.is_a?(Arel::Nodes::Descending) o elsif o.respond_to?(:asc) o.asc end }.compact ArelExtensions::Nodes::GroupConcat.new(self, sep, group: group, order: (order || order_tabs)) end |
#idoes_not_match(others, escape = nil) ⇒ Object
84 85 86 |
# File 'lib/arel_extensions/string_functions.rb', line 84 def idoes_not_match others, escape = nil ArelExtensions::Nodes::IDoesNotMatch.new self, others, escape end |
#idoes_not_match_all(others, escape = nil) ⇒ Object
92 93 94 |
# File 'lib/arel_extensions/string_functions.rb', line 92 def idoes_not_match_all others, escape = nil grouping_all :idoes_not_match, others, escape end |
#idoes_not_match_any(others, escape = nil) ⇒ Object
88 89 90 |
# File 'lib/arel_extensions/string_functions.rb', line 88 def idoes_not_match_any others, escape = nil grouping_any :idoes_not_match, others, escape end |
#imatches(others, escape = nil) ⇒ Object
59 60 61 |
# File 'lib/arel_extensions/string_functions.rb', line 59 def imatches others, escape = nil ArelExtensions::Nodes::IMatches.new self, others, escape end |
#imatches_all(others, escape = nil) ⇒ Object
def grouping_any method, others, *extra
puts "*******************"
puts method
puts others.inspect
puts extra.inspect
puts "-------------------"
res = super(method,others,*extra)
puts res.to_sql
puts res.inspect
puts "*******************"
res
end
80 81 82 |
# File 'lib/arel_extensions/string_functions.rb', line 80 def imatches_all others, escape = nil grouping_all :imatches, others, escape, escape end |
#imatches_any(others, escape = nil) ⇒ Object
63 64 65 |
# File 'lib/arel_extensions/string_functions.rb', line 63 def imatches_any others, escape = nil grouping_any :imatches, others, escape end |
#length ⇒ Object
LENGTH function returns the length of the value in a text field.
29 30 31 |
# File 'lib/arel_extensions/string_functions.rb', line 29 def length ArelExtensions::Nodes::Length.new [self] end |
#levenshtein_distance(other) ⇒ Object
185 186 187 |
# File 'lib/arel_extensions/string_functions.rb', line 185 def levenshtein_distance other ArelExtensions::Nodes::LevenshteinDistance.new [self, other] end |
#locate(val) ⇒ Object
LOCATE function returns the first starting position of a string in another string. If string1 or string2 is NULL then it returns NULL. If string1 not found in string2 then it returns 0.
35 36 37 |
# File 'lib/arel_extensions/string_functions.rb', line 35 def locate val ArelExtensions::Nodes::Locate.new [self, val] end |
#ltrim(other = ' ') ⇒ Object
157 158 159 |
# File 'lib/arel_extensions/string_functions.rb', line 157 def ltrim other = ' ' ArelExtensions::Nodes::Ltrim.new [self, other] end |
#md5 ⇒ Object
193 194 195 |
# File 'lib/arel_extensions/string_functions.rb', line 193 def md5 ArelExtensions::Nodes::MD5.new [self] end |
#not_blank ⇒ Object
177 178 179 |
# File 'lib/arel_extensions/string_functions.rb', line 177 def not_blank ArelExtensions::Nodes::NotBlank.new [self] end |
#regexp_replace(pattern, substitute) ⇒ Object
129 130 131 |
# File 'lib/arel_extensions/string_functions.rb', line 129 def regexp_replace pattern, substitute ArelExtensions::Nodes::RegexpReplace.new self, pattern, substitute end |
#repeat(other = 1) ⇒ Object
181 182 183 |
# File 'lib/arel_extensions/string_functions.rb', line 181 def repeat other = 1 ArelExtensions::Nodes::Repeat.new [self, other] end |
#replace(pattern, substitute) ⇒ Object
REPLACE function replaces a sequence of characters in a string with another set of characters, not case-sensitive.
121 122 123 124 125 126 127 |
# File 'lib/arel_extensions/string_functions.rb', line 121 def replace pattern, substitute if pattern.is_a? Regexp ArelExtensions::Nodes::RegexpReplace.new self, pattern, substitute else ArelExtensions::Nodes::Replace.new self, pattern, substitute end end |
#rtrim(other = ' ') ⇒ Object
161 162 163 |
# File 'lib/arel_extensions/string_functions.rb', line 161 def rtrim other = ' ' ArelExtensions::Nodes::Rtrim.new [self, other] end |
#smatches(other) ⇒ Object
accent sensitive & case sensitive
104 105 106 |
# File 'lib/arel_extensions/string_functions.rb', line 104 def smatches other # accent sensitive & case sensitive ArelExtensions::Nodes::SMatches.new(self,other) end |
#soundex ⇒ Object
SOUNDEX function returns a character string containing the phonetic representation of char.
55 56 57 |
# File 'lib/arel_extensions/string_functions.rb', line 55 def soundex ArelExtensions::Nodes::Soundex.new [self] end |
#substring(start, len = nil) ⇒ Object
39 40 41 |
# File 'lib/arel_extensions/string_functions.rb', line 39 def substring start, len = nil ArelExtensions::Nodes::Substring.new [self, start, len] end |
#trim(other = ' ') ⇒ Object
Function returns a string after removing left, right or the both prefixes or suffixes int argument
153 154 155 |
# File 'lib/arel_extensions/string_functions.rb', line 153 def trim other = ' ' ArelExtensions::Nodes::Trim.new [self, other] end |
#upcase ⇒ Object
169 170 171 |
# File 'lib/arel_extensions/string_functions.rb', line 169 def upcase ArelExtensions::Nodes::Upcase.new [self] end |