Package org.hibernate.dialect.function

Examples of org.hibernate.dialect.function.AnsiTrimEmulationFunction.render()

46
47
48
49
50
51
52
53
54
55
56
    final String expectedTrimPrep = "replace(replace(a.column,' ','${space}$'),'-',' ')";
    final String expectedPostTrimPrefix = "replace(replace(";
    final String expectedPostTrimSuffix = ",' ','-'),'${space}$',' ')";

    // -> trim(LEADING '-' FROM a.column)
    String rendered = function.render( null, argList( "LEADING", "'-'", "FROM", trimSource ), null );
    String expected = expectedPostTrimPrefix + "ltrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(TRAILING '-' FROM a.column)
    rendered = function.render( null, argList( "TRAILING", "'-'", "FROM", trimSource ), null );
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
    String rendered = function.render( null, argList( "LEADING", "'-'", "FROM", trimSource ), null );
    String expected = expectedPostTrimPrefix + "ltrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(TRAILING '-' FROM a.column)
    rendered = function.render( null, argList( "TRAILING", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "rtrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(BOTH '-' FROM a.column)
    rendered = function.render( null, argList( "BOTH", "'-'", "FROM", trimSource ), null );
View Full Code Here
56
57
58
59
60
61
62
63
64
65
66
    rendered = function.render( null, argList( "TRAILING", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "rtrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(BOTH '-' FROM a.column)
    rendered = function.render( null, argList( "BOTH", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "ltrim(rtrim(" + expectedTrimPrep + "))" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim('-' FROM a.column)
    rendered = function.render( null, argList( "'-'", "FROM", trimSource ), null );
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    rendered = function.render( null, argList( "BOTH", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "ltrim(rtrim(" + expectedTrimPrep + "))" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim('-' FROM a.column)
    rendered = function.render( null, argList( "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "ltrim(rtrim(" + expectedTrimPrep + "))" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );
  }

  public void testBasicSybaseProcessing() {
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
    final String expectedTrimPrep = "str_replace(str_replace(a.column,' ','${space}$'),'-',' ')";
    final String expectedPostTrimPrefix = "str_replace(str_replace(";
    final String expectedPostTrimSuffix = ",' ','-'),'${space}$',' ')";

    // -> trim(LEADING '-' FROM a.column)
    String rendered = function.render( null, argList( "LEADING", "'-'", "FROM", trimSource ), null );
    String expected = expectedPostTrimPrefix + "ltrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(TRAILING '-' FROM a.column)
    rendered = function.render( null, argList( "TRAILING", "'-'", "FROM", trimSource ), null );
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
    String rendered = function.render( null, argList( "LEADING", "'-'", "FROM", trimSource ), null );
    String expected = expectedPostTrimPrefix + "ltrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(TRAILING '-' FROM a.column)
    rendered = function.render( null, argList( "TRAILING", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "rtrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(BOTH '-' FROM a.column)
    rendered = function.render( null, argList( "BOTH", "'-'", "FROM", trimSource ), null );
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
    rendered = function.render( null, argList( "TRAILING", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "rtrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(BOTH '-' FROM a.column)
    rendered = function.render( null, argList( "BOTH", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "ltrim(rtrim(" + expectedTrimPrep + "))" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim('-' FROM a.column)
    rendered = function.render( null, argList( "'-'", "FROM", trimSource ), null );
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
    rendered = function.render( null, argList( "BOTH", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "ltrim(rtrim(" + expectedTrimPrep + "))" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim('-' FROM a.column)
    rendered = function.render( null, argList( "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "ltrim(rtrim(" + expectedTrimPrep + "))" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );
  }

  private void performBasicSpaceTrimmingTests(AnsiTrimEmulationFunction function) {
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
    final String expectedTrimPrep = "replace(replace(a.column,' ','${space}$'),'-',' ')";
    final String expectedPostTrimPrefix = "replace(replace(";
    final String expectedPostTrimSuffix = ",' ','-'),'${space}$',' ')";

    // -> trim(LEADING '-' FROM a.column)
    String rendered = function.render( argList( "LEADING", "'-'", "FROM", trimSource ), null );
    String expected = expectedPostTrimPrefix + "ltrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(TRAILING '-' FROM a.column)
    rendered = function.render( argList( "TRAILING", "'-'", "FROM", trimSource ), null );
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
    String rendered = function.render( argList( "LEADING", "'-'", "FROM", trimSource ), null );
    String expected = expectedPostTrimPrefix + "ltrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(TRAILING '-' FROM a.column)
    rendered = function.render( argList( "TRAILING", "'-'", "FROM", trimSource ), null );
    expected = expectedPostTrimPrefix + "rtrim(" + expectedTrimPrep + ")" + expectedPostTrimSuffix;
    assertEquals( expected, rendered );

    // -> trim(BOTH '-' FROM a.column)
    rendered = function.render( argList( "BOTH", "'-'", "FROM", trimSource ), null );
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.