Class: Arel::Visitors::ToSql
- Inherits:
-
Object
- Object
- Arel::Visitors::ToSql
- Defined in:
- lib/arel_extensions/visitors/to_sql.rb
Constant Summary collapse
- COMMA =
', '
Instance Method Summary collapse
- #json_value(o, v) ⇒ Object
- #visit_Arel_Nodes_And(o, collector) ⇒ Object
- #visit_Arel_Nodes_As(o, collector) ⇒ Object
- #visit_Arel_Nodes_LessThan(o, collector) ⇒ Object
- #visit_Arel_Nodes_NotRegexp(o, collector) ⇒ Object
- #visit_Arel_Nodes_Or(o, collector) ⇒ Object
- #visit_Arel_Nodes_Regexp(o, collector) ⇒ Object
- #visit_ArelExtensions_InsertManager_BulkValues(o, collector) ⇒ Object
-
#visit_ArelExtensions_Nodes_Abs(o, collector) ⇒ Object
Math Functions.
- #visit_ArelExtensions_Nodes_Blank(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Case(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Case_Else(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Case_When(o, collector) ⇒ Object
-
#visit_ArelExtensions_Nodes_Cast(o, collector) ⇒ Object
comparators.
- #visit_ArelExtensions_Nodes_Ceil(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Coalesce(o, collector) ⇒ Object
-
#visit_ArelExtensions_Nodes_Concat(o, collector) ⇒ Object
String functions.
-
#visit_ArelExtensions_Nodes_DateAdd(o, collector) ⇒ Object
Date operations.
- #visit_ArelExtensions_Nodes_DateDiff(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_DateSub(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Downcase(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_FindInSet(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Floor(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Format(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_FormattedNumber(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_GroupConcat(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_IDoesNotMatch(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_IMatches(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_IsNotNull(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_IsNull(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Json(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_JsonGroup(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Length(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_LevenshteinDistance(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Locate(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Log10(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Ltrim(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_MD5(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_NotBlank(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Power(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Rand(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_RegexpReplace(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Repeat(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Replace(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Round(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Rtrim(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Soundex(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Std(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Substring(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Sum(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Then(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Trim(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Union(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_UnionAll(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Upcase(o, collector) ⇒ Object
- #visit_ArelExtensions_Nodes_Variance(o, collector) ⇒ Object
Instance Method Details
#json_value(o, v) ⇒ Object
589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 589 def json_value(o,v) case o.type_of_node(v) when :string Arel.when(v.is_null).then(Arel::Nodes.build_quoted("null")).else(Arel::Nodes.build_quoted('"') + v.replace('\\','\\\\').replace('"','\"') + '"') when :date s = v.format('%Y-%m-%d') Arel.when(s.is_null).then(Arel::Nodes.build_quoted("null")).else(Arel::Nodes.build_quoted('"') + s + '"') when :datetime s = v.format('%Y-%m-%dT%H:%M:%S') Arel.when(s.is_null).then(Arel::Nodes.build_quoted("null")).else(Arel::Nodes.build_quoted('"') + s + '"') when :time s = v.format('%H:%M:%S') Arel.when(s.is_null).then(Arel::Nodes.build_quoted("null")).else(Arel::Nodes.build_quoted('"') + s + '"') when :nil Arel::Nodes.build_quoted("null") else ArelExtensions::Nodes::Cast.new([v, :string]).coalesce("null") end end |
#visit_Arel_Nodes_And(o, collector) ⇒ Object
550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 550 def visit_Arel_Nodes_And o, collector case o.children.length when 0 collector << '1 = 1' # but this should not happen when 1 collector = visit o.children[0], collector else collector << '(' o.children.each_with_index { |arg, i| if i != 0 collector << ') AND (' end collector = visit arg, collector } collector << ')' end collector end |
#visit_Arel_Nodes_As(o, collector) ⇒ Object
341 342 343 344 345 346 347 348 349 350 351 352 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 341 def visit_Arel_Nodes_As o, collector if o.left.is_a?(Arel::Nodes::Binary) collector << '(' collector = visit o.left, collector collector << ')' else collector = visit o.left, collector end collector << " AS " collector = visit o.right, collector collector end |
#visit_Arel_Nodes_LessThan(o, collector) ⇒ Object
518 519 520 521 522 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 518 def visit_Arel_Nodes_LessThan o, collector collector = visit o.left, collector collector << " < " visit o.right, collector end |
#visit_Arel_Nodes_NotRegexp(o, collector) ⇒ Object
363 364 365 366 367 368 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 363 def visit_Arel_Nodes_NotRegexp o, collector collector = visit o.left, collector collector << " NOT REGEXP " collector = visit o.right, collector collector end |
#visit_Arel_Nodes_Or(o, collector) ⇒ Object
570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 570 def visit_Arel_Nodes_Or o, collector case o.children.length when 0 collector << '1 = 0' # but this should not happen when 1 collector = visit o.children[0], collector else collector << '(' o.children.each_with_index { |arg, i| if i != 0 collector << ') OR (' end collector = visit arg, collector } collector << ')' end collector end |
#visit_Arel_Nodes_Regexp(o, collector) ⇒ Object
355 356 357 358 359 360 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 355 def visit_Arel_Nodes_Regexp o, collector collector = visit o.left, collector collector << " REGEXP " collector = visit o.right, collector collector end |
#visit_ArelExtensions_InsertManager_BulkValues(o, collector) ⇒ Object
427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 427 def visit_ArelExtensions_InsertManager_BulkValues o, collector collector << 'VALUES ' row_nb = o.left.length o.left.each_with_index do |row, idx| collector << '(' len = row.length - 1 row.zip(o.cols).each_with_index { |(value, attr), i| case value when Arel::Nodes::SqlLiteral, Arel::Nodes::BindParam collector = visit value, collector else collector << quote(value, attr && column_for(attr)).to_s end collector << COMMA unless i == len } collector << (idx == row_nb-1 ? ')' : '), ') end collector end |
#visit_ArelExtensions_Nodes_Abs(o, collector) ⇒ Object
Math Functions
7 8 9 10 11 12 13 14 15 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 7 def visit_ArelExtensions_Nodes_Abs o, collector collector << "ABS(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Blank(o, collector) ⇒ Object
238 239 240 241 242 243 244 245 246 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 238 def visit_ArelExtensions_Nodes_Blank o, collector # visit o.left.coalesce('').trim.length.eq(0), collector collector << 'LENGTH(TRIM(COALESCE(' collector = visit o.expr, collector collector << COMMA collector = visit Arel::Nodes.build_quoted(''), collector collector << "))) = 0" collector end |
#visit_ArelExtensions_Nodes_Case(o, collector) ⇒ Object
484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 484 def visit_ArelExtensions_Nodes_Case o, collector collector << "CASE " if o.case visit o.case, collector collector << " " end o.conditions.each do |condition| visit condition, collector collector << " " end if o.default visit o.default, collector collector << " " end collector << "END" end |
#visit_ArelExtensions_Nodes_Case_Else(o, collector) ⇒ Object
508 509 510 511 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 508 def visit_ArelExtensions_Nodes_Case_Else o, collector collector << "ELSE " visit Arel::Nodes.build_quoted(o.expr), collector end |
#visit_ArelExtensions_Nodes_Case_When(o, collector) ⇒ Object
501 502 503 504 505 506 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 501 def visit_ArelExtensions_Nodes_Case_When o, collector collector << "WHEN " visit Arel::Nodes.build_quoted(o.left), collector collector << " THEN " visit Arel::Nodes.build_quoted(o.right), collector end |
#visit_ArelExtensions_Nodes_Cast(o, collector) ⇒ Object
comparators
280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 280 def visit_ArelExtensions_Nodes_Cast o, collector collector << "CAST(" collector = visit o.left, collector collector << " AS " case o.as_attr when :string as_attr = Arel::Nodes::SqlLiteral.new('char') when :int as_attr = Arel::Nodes::SqlLiteral.new('int') when :decimal, :float, :number as_attr = Arel::Nodes::SqlLiteral.new('float') when :datetime as_attr = Arel::Nodes::SqlLiteral.new('datetime') when :time as_attr = Arel::Nodes::SqlLiteral.new('time') when :binary as_attr = Arel::Nodes::SqlLiteral.new('binary') when :text, :ntext as_attr = Arel::Nodes::SqlLiteral.new('text') else as_attr = Arel::Nodes::SqlLiteral.new(o.as_attr.to_s) end collector = visit as_attr, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Ceil(o, collector) ⇒ Object
17 18 19 20 21 22 23 24 25 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 17 def visit_ArelExtensions_Nodes_Ceil o, collector collector << "CEIL(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Coalesce(o, collector) ⇒ Object
307 308 309 310 311 312 313 314 315 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 307 def visit_ArelExtensions_Nodes_Coalesce o, collector collector << "COALESCE(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Concat(o, collector) ⇒ Object
String functions
82 83 84 85 86 87 88 89 90 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 82 def visit_ArelExtensions_Nodes_Concat o, collector collector << "CONCAT(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_DateAdd(o, collector) ⇒ Object
Date operations
417 418 419 420 421 422 423 424 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 417 def visit_ArelExtensions_Nodes_DateAdd o, collector collector << "DATE_ADD(" collector = visit o.left, collector collector << COMMA collector = visit o.sqlite_value(o.right), collector collector << ')' collector end |
#visit_ArelExtensions_Nodes_DateDiff(o, collector) ⇒ Object
317 318 319 320 321 322 323 324 325 326 327 328 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 317 def visit_ArelExtensions_Nodes_DateDiff o, collector collector << if o.left_node_type == :ruby_time || o.left_node_type == :datetime || o.left_node_type == :time 'TIMEDIFF(' else 'DATEDIFF(' end collector = visit o.left, collector collector << COMMA collector = visit o.right, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_DateSub(o, collector) ⇒ Object
330 331 332 333 334 335 336 337 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 330 def visit_ArelExtensions_Nodes_DateSub o, collector collector << "DATE_SUB(" collector = visit o.left, collector collector << COMMA collector = visit o.right, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Downcase(o, collector) ⇒ Object
188 189 190 191 192 193 194 195 196 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 188 def visit_ArelExtensions_Nodes_Downcase o, collector collector << "LOWER(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_FindInSet(o, collector) ⇒ Object
168 169 170 171 172 173 174 175 176 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 168 def visit_ArelExtensions_Nodes_FindInSet o, collector collector << "FIND_IN_SET(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Floor(o, collector) ⇒ Object
27 28 29 30 31 32 33 34 35 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 27 def visit_ArelExtensions_Nodes_Floor o, collector collector << "FLOOR(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Format(o, collector) ⇒ Object
258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 258 def visit_ArelExtensions_Nodes_Format o, collector case o.col_type when :date, :datetime, :time collector << "STRFTIME(" collector = visit o.right, collector collector << COMMA collector = visit o.left, collector collector << ")" when :integer, :float, :decimal collector << "FORMAT(" collector = visit o.left, collector collector << COMMA collector = visit o.right, collector collector << ")" else collector = visit o.left, collector end collector end |
#visit_ArelExtensions_Nodes_FormattedNumber(o, collector) ⇒ Object
513 514 515 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 513 def visit_ArelExtensions_Nodes_FormattedNumber o, collector visit o.left, collector end |
#visit_ArelExtensions_Nodes_GroupConcat(o, collector) ⇒ Object
92 93 94 95 96 97 98 99 100 101 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 92 def visit_ArelExtensions_Nodes_GroupConcat o, collector collector << "GROUP_CONCAT(" collector = visit o.left, collector if o.separator && o.separator != 'NULL' collector << COMMA collector = visit o.separator, collector end collector << ")" collector end |
#visit_ArelExtensions_Nodes_IDoesNotMatch(o, collector) ⇒ Object
380 381 382 383 384 385 386 387 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 380 def visit_ArelExtensions_Nodes_IDoesNotMatch o, collector collector = infix_value o, collector, ' NOT ILIKE ' if o.escape collector << ' ESCAPE ' collector = visit o.escape, collector end collector end |
#visit_ArelExtensions_Nodes_IMatches(o, collector) ⇒ Object
370 371 372 373 374 375 376 377 378 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 370 def visit_ArelExtensions_Nodes_IMatches o, collector collector = infix_value o, collector, ' ILIKE ' if o.escape collector << ' ESCAPE ' visit o.escape, collector else collector end end |
#visit_ArelExtensions_Nodes_IsNotNull(o, collector) ⇒ Object
396 397 398 399 400 401 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 396 def visit_ArelExtensions_Nodes_IsNotNull o, collector collector << "NOT ISNULL(" collector = visit o.expr, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_IsNull(o, collector) ⇒ Object
389 390 391 392 393 394 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 389 def visit_ArelExtensions_Nodes_IsNull o, collector collector << "ISNULL(" collector = visit o.expr, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Json(o, collector) ⇒ Object
609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 609 def visit_ArelExtensions_Nodes_Json o,collector case o.dict when Array res = Arel::Nodes.build_quoted('[') o.dict.each.with_index do |v,i| if i != 0 res += ', ' end res += json_value(o,v) end res += ']' collector = visit res, collector when Hash res = Arel::Nodes.build_quoted('{') o.dict.each.with_index do |(k,v),i| if i != 0 res += ', ' end res += Arel::Nodes.build_quoted('"') + ArelExtensions::Nodes::Cast.new([k, :string]).coalesce("").replace('\\','\\\\').replace('"','\"') + '": ' res += json_value(o,v) end res += '}' collector = visit res, collector else collector = visit o.dict, collector end collector end |
#visit_ArelExtensions_Nodes_JsonGroup(o, collector) ⇒ Object
638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 638 def visit_ArelExtensions_Nodes_JsonGroup o, collector if o.as_array res = Arel::Nodes.build_quoted('[') + (o.orders ? o.dict.group_concat(', ', order: Array(o.orders)) : o.dict.group_concat(', ')).coalesce('') + ']' collector = visit res, collector else res = Arel::Nodes.build_quoted('{') orders = o.orders || o.dict.keys o.dict.each.with_index do |(k,v),i| if i != 0 res = res + ', ' end kv = Arel::Nodes.build_quoted('"') + ArelExtensions::Nodes::Cast.new([k, :string]).coalesce("").replace('\\','\\\\').replace('"','\"') + '": ' kv += json_value(o,v) res = res + kv.group_concat(', ', order: Array(orders)).coalesce('') end res = res + '}' collector = visit res, collector end collector end |
#visit_ArelExtensions_Nodes_Length(o, collector) ⇒ Object
110 111 112 113 114 115 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 110 def visit_ArelExtensions_Nodes_Length o, collector collector << "LENGTH(" collector = visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_LevenshteinDistance(o, collector) ⇒ Object
538 539 540 541 542 543 544 545 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 538 def visit_ArelExtensions_Nodes_LevenshteinDistance o, collector collector << "LEVENSHTEIN_DISTANCE(" collector = visit o.left, collector collector << COMMA collector = visit o.right, collector collector << ')' collector end |
#visit_ArelExtensions_Nodes_Locate(o, collector) ⇒ Object
117 118 119 120 121 122 123 124 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 117 def visit_ArelExtensions_Nodes_Locate o, collector collector << "LOCATE(" collector = visit o.right, collector collector << COMMA collector = visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Log10(o, collector) ⇒ Object
57 58 59 60 61 62 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 57 def visit_ArelExtensions_Nodes_Log10 o, collector collector << "LOG10(" collector = visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Ltrim(o, collector) ⇒ Object
218 219 220 221 222 223 224 225 226 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 218 def visit_ArelExtensions_Nodes_Ltrim o, collector collector << "LTRIM(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_MD5(o, collector) ⇒ Object
103 104 105 106 107 108 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 103 def visit_ArelExtensions_Nodes_MD5 o, collector collector << "MD5(" collector = visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_NotBlank(o, collector) ⇒ Object
248 249 250 251 252 253 254 255 256 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 248 def visit_ArelExtensions_Nodes_NotBlank o, collector # visit o.left.coalesce('').trim.length.gt(0), collector collector << 'LENGTH(TRIM(COALESCE(' collector = visit o.expr, collector collector << COMMA collector = visit Arel::Nodes.build_quoted(''), collector collector << "))) > 0" collector end |
#visit_ArelExtensions_Nodes_Power(o, collector) ⇒ Object
64 65 66 67 68 69 70 71 72 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 64 def visit_ArelExtensions_Nodes_Power o, collector collector << "POW(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Rand(o, collector) ⇒ Object
37 38 39 40 41 42 43 44 45 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 37 def visit_ArelExtensions_Nodes_Rand o, collector collector << "RAND(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_RegexpReplace(o, collector) ⇒ Object
147 148 149 150 151 152 153 154 155 156 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 147 def visit_ArelExtensions_Nodes_RegexpReplace o, collector collector << "REGEXP_REPLACE(" visit o.left, collector collector << COMMA visit Arel::Nodes.build_quoted(o.pattern.to_s), collector collector << COMMA visit o.substitute, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Repeat(o, collector) ⇒ Object
158 159 160 161 162 163 164 165 166 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 158 def visit_ArelExtensions_Nodes_Repeat o, collector collector << "REPEAT(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Replace(o, collector) ⇒ Object
136 137 138 139 140 141 142 143 144 145 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 136 def visit_ArelExtensions_Nodes_Replace o, collector collector << "REPLACE(" visit o.left, collector collector << COMMA visit o.pattern, collector collector << COMMA visit o.substitute, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Round(o, collector) ⇒ Object
47 48 49 50 51 52 53 54 55 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 47 def visit_ArelExtensions_Nodes_Round o, collector collector << "ROUND(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Rtrim(o, collector) ⇒ Object
228 229 230 231 232 233 234 235 236 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 228 def visit_ArelExtensions_Nodes_Rtrim o, collector collector << "RTRIM(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Soundex(o, collector) ⇒ Object
178 179 180 181 182 183 184 185 186 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 178 def visit_ArelExtensions_Nodes_Soundex o, collector collector << "SOUNDEX(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Std(o, collector) ⇒ Object
524 525 526 527 528 529 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 524 def visit_ArelExtensions_Nodes_Std o, collector collector << "STD(" visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Substring(o, collector) ⇒ Object
126 127 128 129 130 131 132 133 134 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 126 def visit_ArelExtensions_Nodes_Substring o, collector collector << "SUBSTRING(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Sum(o, collector) ⇒ Object
74 75 76 77 78 79 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 74 def visit_ArelExtensions_Nodes_Sum o, collector collector << "SUM(" collector = visit o.expr, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Then(o, collector) ⇒ Object
403 404 405 406 407 408 409 410 411 412 413 414 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 403 def visit_ArelExtensions_Nodes_Then o, collector collector << "CASE WHEN (" collector = visit o.left, collector collector << ") THEN " collector = visit o.right, collector if o.expressions[2] collector << " ELSE " collector = visit o.expressions[2], collector end collector << " END" collector end |
#visit_ArelExtensions_Nodes_Trim(o, collector) ⇒ Object
208 209 210 211 212 213 214 215 216 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 208 def visit_ArelExtensions_Nodes_Trim o, collector collector << "TRIM(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Union(o, collector) ⇒ Object
470 471 472 473 474 475 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 470 def visit_ArelExtensions_Nodes_Union o, collector collector = visit o.left, collector collector << " UNION " collector = visit o.right, collector collector end |
#visit_ArelExtensions_Nodes_UnionAll(o, collector) ⇒ Object
477 478 479 480 481 482 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 477 def visit_ArelExtensions_Nodes_UnionAll o, collector collector = visit o.left, collector collector << " UNION ALL " collector = visit o.right, collector collector end |
#visit_ArelExtensions_Nodes_Upcase(o, collector) ⇒ Object
198 199 200 201 202 203 204 205 206 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 198 def visit_ArelExtensions_Nodes_Upcase o, collector collector << "UPPER(" o.expressions.each_with_index { |arg, i| collector << COMMA if i != 0 collector = visit arg, collector } collector << ")" collector end |
#visit_ArelExtensions_Nodes_Variance(o, collector) ⇒ Object
531 532 533 534 535 536 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 531 def visit_ArelExtensions_Nodes_Variance o, collector collector << "VARIANCE(" visit o.left, collector collector << ")" collector end |