Package org.springframework.xd.test.fixtures

Examples of org.springframework.xd.test.fixtures.JdbcSink

131
132
133
134
135
136
137
138
139
140
141
   */
  public JdbcSink jdbc() {
    if (environment.getDataSource() == null) {
      return null;
    }
    jdbcSink = new JdbcSink(environment.getDataSource());

    if (!jdbcSink.isReady()) {
      throw new IllegalStateException("Unable to connecto to database.");
    }
    return jdbcSink;
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
*/
public class JdbcModulesTests extends AbstractStreamIntegrationTest {

  @Test
  public void testJdbcSinkWith1InsertionAndDefaultConfiguration() throws Exception {
    JdbcSink jdbcSink = newJdbcSink();

    HttpSource httpSource = newHttpSource();


    String streamName = generateStreamName().replaceAll("-", "_");
    stream().create(streamName, "%s | %s", httpSource, jdbcSink);
    httpSource.ensureReady().postData("Hi there!");

    String query = String.format("SELECT payload FROM %s", streamName);
    assertEquals(
        "Hi there!",
        jdbcSink.getJdbcTemplate().queryForObject(query, String.class));
  }
View Full Code Here
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
        jdbcSink.getJdbcTemplate().queryForObject(query, String.class));
  }

  @Test
  public void testJdbcSinkWith2InsertionsAndDefaultConfiguration() throws Exception {
    JdbcSink jdbcSink = newJdbcSink();

    HttpSource httpSource = newHttpSource();


    String streamName = generateStreamName().replaceAll("-", "_");
    stream().create(streamName, "%s | %s", httpSource, jdbcSink);
    httpSource.ensureReady().postData("Hi there!");
    httpSource.postData("How are you?");

    String query = String.format("SELECT payload FROM %s", streamName);
    List<String> result = jdbcSink.getJdbcTemplate().queryForList(query, String.class);
    assertThat(result, contains("Hi there!", "How are you?"));
  }
View Full Code Here
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
  }

  @Test
  public void testJdbcSinkWithCustomTableName() throws Exception {
    String tableName = "foobar";
    JdbcSink jdbcSink = newJdbcSink().tableName(tableName);

    HttpSource httpSource = newHttpSource();

    stream().create(generateStreamName(), "%s | %s", httpSource, jdbcSink);
    httpSource.ensureReady().postData("Hi there!");

    String query = String.format("SELECT payload FROM %s", tableName);
    assertEquals(
        "Hi there!",
        jdbcSink.getJdbcTemplate().queryForObject(query, String.class));
  }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
        jdbcSink.getJdbcTemplate().queryForObject(query, String.class));
  }

  @Test
  public void testJdbcSinkWithCustomColumnNames() throws Exception {
    JdbcSink jdbcSink = newJdbcSink().columns("foo,bar");

    HttpSource httpSource = newHttpSource();


    String streamName = generateStreamName().replaceAll("-", "_");
    stream().create(streamName, "%s | %s", httpSource, jdbcSink);
    String json = "{\"foo\":5, \"bar\": \"hello\"}";
    httpSource.ensureReady().postData(json);

    String query = String.format("SELECT foo, bar FROM %s", streamName);
    Result result = jdbcSink.getJdbcTemplate().queryForObject(query, new BeanPropertyRowMapper<>(Result.class));
    assertEquals("hello", result.getBar());
    assertEquals(5, result.getFoo());
  }
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
    assertEquals(5, result.getFoo());
  }

  @Test
  public void testJdbcSinkWithCustomColumnNamesWithUnderscores() throws Exception {
    JdbcSink jdbcSink = newJdbcSink().columns("foo_bar,bar_foo,bar_baz");

    HttpSource httpSource = newHttpSource();

    String streamName = generateStreamName().replaceAll("-", "_");
    stream().create(streamName, "%s | %s", httpSource, jdbcSink);
    String json = "{\"fooBar\":5, \"barFoo\": \"hello\", \"bar_baz\": \"good_bye\"}";
    httpSource.ensureReady().postData(json);

    String query = String.format("SELECT foo_bar, bar_foo, bar_baz FROM %s", streamName);
    Map<String, Object> result = jdbcSink.getJdbcTemplate().queryForMap(query);
    assertEquals("hello", result.get("bar_foo"));
    assertEquals("5", result.get("foo_bar"));
    assertEquals("good_bye", result.get("bar_baz"));
  }
View Full Code Here
102
103
104
105
106
107
108
    disposables.add(tcpSink);
    return tcpSink;
  }

  protected JdbcSink newJdbcSink() {
    return new JdbcSink(createDataSource());
  }
View Full Code Here
TOP

Related Classes of org.springframework.xd.test.fixtures.JdbcSink

  • org.springframework.jdbc.core.JdbcTemplate
  • org.springframework.xd.integration.fixtures.Sinks
  • org.springframework.xd.shell.command.AbstractStreamIntegrationTest
  • org.springframework.xd.shell.command.JdbcModulesTests
  • java.sql.Connection
    • Copyright © 2018 www.massapicom. 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.