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
- #make_json_null ⇒ Object
-
#make_json_string(expr) ⇒ Object
Escape properly the string expression expr.
- #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
606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 606 def json_value(o,v) case o.type_of_node(v) when :string Arel.when(v.is_null).then(make_json_null).else(make_json_string(v)) when :date s = v.format('%Y-%m-%d') Arel.when(s.is_null).then(make_json_null).else(make_json_string(s)) when :datetime s = v.format('%Y-%m-%dT%H:%M:%S') Arel.when(s.is_null).then(make_json_null).else(make_json_string(s)) when :time s = v.format('%H:%M:%S') Arel.when(s.is_null).then(make_json_null).else(make_json_string(s)) when :nil make_json_null else ArelExtensions::Nodes::Cast.new([v, :string]).coalesce(make_json_null) end end |
#make_json_null ⇒ Object
16 17 18 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 16 def make_json_null Arel::Nodes.build_quoted("null") end |
#make_json_string(expr) ⇒ Object
Escape properly the string expression expr. Take care of escaping.
8 9 10 11 12 13 14 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 8 def make_json_string expr Arel::Nodes.build_quoted('"') \ + expr .coalesce('') .replace('\\','\\\\').replace('"','\"').replace("\n", '\n') \ + '"' end |
#visit_Arel_Nodes_And(o, collector) ⇒ Object
567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 567 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
355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 355 def visit_Arel_Nodes_As o, collector if o.left.respond_to?(:alias) o.left.alias = nil end 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
535 536 537 538 539 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 535 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
380 381 382 383 384 385 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 380 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
587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 587 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
372 373 374 375 376 377 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 372 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
444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 444 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
21 22 23 24 25 26 27 28 29 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 21 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
252 253 254 255 256 257 258 259 260 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 252 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
501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 501 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
525 526 527 528 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 525 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
518 519 520 521 522 523 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 518 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
294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 294 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
31 32 33 34 35 36 37 38 39 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 31 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
321 322 323 324 325 326 327 328 329 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 321 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
96 97 98 99 100 101 102 103 104 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 96 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
434 435 436 437 438 439 440 441 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 434 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
331 332 333 334 335 336 337 338 339 340 341 342 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 331 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
344 345 346 347 348 349 350 351 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 344 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
202 203 204 205 206 207 208 209 210 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 202 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
182 183 184 185 186 187 188 189 190 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 182 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
41 42 43 44 45 46 47 48 49 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 41 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
272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 272 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
530 531 532 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 530 def visit_ArelExtensions_Nodes_FormattedNumber o, collector visit o.left, collector end |
#visit_ArelExtensions_Nodes_GroupConcat(o, collector) ⇒ Object
106 107 108 109 110 111 112 113 114 115 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 106 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
397 398 399 400 401 402 403 404 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 397 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
387 388 389 390 391 392 393 394 395 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 387 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
413 414 415 416 417 418 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 413 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
406 407 408 409 410 411 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 406 def visit_ArelExtensions_Nodes_IsNull o, collector collector << "ISNULL(" collector = visit o.expr, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Json(o, collector) ⇒ Object
626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 626 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 += make_json_string(ArelExtensions::Nodes::Cast.new([k, :string])) + ': ' 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
655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 655 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 = make_json_string(ArelExtensions::Nodes::Cast.new([k, :string])) + ': ' 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
124 125 126 127 128 129 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 124 def visit_ArelExtensions_Nodes_Length o, collector collector << "#{o.bytewise ? '' : 'CHAR_'}LENGTH(" collector = visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_LevenshteinDistance(o, collector) ⇒ Object
555 556 557 558 559 560 561 562 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 555 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
131 132 133 134 135 136 137 138 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 131 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
71 72 73 74 75 76 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 71 def visit_ArelExtensions_Nodes_Log10 o, collector collector << "LOG10(" collector = visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Ltrim(o, collector) ⇒ Object
232 233 234 235 236 237 238 239 240 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 232 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
117 118 119 120 121 122 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 117 def visit_ArelExtensions_Nodes_MD5 o, collector collector << "MD5(" collector = visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_NotBlank(o, collector) ⇒ Object
262 263 264 265 266 267 268 269 270 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 262 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
78 79 80 81 82 83 84 85 86 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 78 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
51 52 53 54 55 56 57 58 59 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 51 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
161 162 163 164 165 166 167 168 169 170 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 161 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
172 173 174 175 176 177 178 179 180 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 172 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
150 151 152 153 154 155 156 157 158 159 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 150 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
61 62 63 64 65 66 67 68 69 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 61 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
242 243 244 245 246 247 248 249 250 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 242 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
192 193 194 195 196 197 198 199 200 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 192 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
541 542 543 544 545 546 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 541 def visit_ArelExtensions_Nodes_Std o, collector collector << "STD(" visit o.left, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Substring(o, collector) ⇒ Object
140 141 142 143 144 145 146 147 148 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 140 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
88 89 90 91 92 93 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 88 def visit_ArelExtensions_Nodes_Sum o, collector collector << "SUM(" collector = visit o.expr, collector collector << ")" collector end |
#visit_ArelExtensions_Nodes_Then(o, collector) ⇒ Object
420 421 422 423 424 425 426 427 428 429 430 431 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 420 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
222 223 224 225 226 227 228 229 230 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 222 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
487 488 489 490 491 492 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 487 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
494 495 496 497 498 499 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 494 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
212 213 214 215 216 217 218 219 220 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 212 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
548 549 550 551 552 553 |
# File 'lib/arel_extensions/visitors/to_sql.rb', line 548 def visit_ArelExtensions_Nodes_Variance o, collector collector << "VARIANCE(" visit o.left, collector collector << ")" collector end |