Search in sources :

Example 6 with JdbcResultRow

use of com.adaptris.jdbc.JdbcResultRow in project interlok by adaptris.

the class IntegerColumnTranslatorTest method testFormattedInteger.

@Test
public void testFormattedInteger() throws Exception {
    translator.setFormat("%05d");
    Integer intVal = Integer.valueOf("123");
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", intVal, Types.INTEGER);
    {
        String translated = translator.translate(row, 0);
        assertEquals(expected, translated);
    }
    {
        String translated = translator.translate(row, "testField");
        assertEquals(expected, translated);
    }
}
Also used : JdbcResultRow(com.adaptris.jdbc.JdbcResultRow) Test(org.junit.Test)

Example 7 with JdbcResultRow

use of com.adaptris.jdbc.JdbcResultRow in project interlok by adaptris.

the class IntegerColumnTranslatorTest method testFormattedFloat.

@Test
public void testFormattedFloat() throws Exception {
    translator.setFormat("%05d");
    Float intVal = Float.valueOf("123");
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", intVal, Types.INTEGER);
    try {
        translator.translate(row, 0);
        fail();
    } catch (Exception ex) {
    // expected
    }
    try {
        translator.translate(row, "testField");
        fail();
    } catch (Exception ex) {
    // expected
    }
}
Also used : JdbcResultRow(com.adaptris.jdbc.JdbcResultRow) Test(org.junit.Test)

Example 8 with JdbcResultRow

use of com.adaptris.jdbc.JdbcResultRow in project interlok by adaptris.

the class StringColumnTranslatorTest method testStringWrite.

@Test
public void testStringWrite() throws Exception {
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", "SomeData", Types.VARCHAR);
    StringWriter writer = new StringWriter();
    try (OutputStream out = new WriterOutputStream(writer)) {
        translator.write(row, 0, out);
    }
    String translated = writer.toString();
    assertEquals("SomeData", translated);
}
Also used : StringWriter(java.io.StringWriter) JdbcResultRow(com.adaptris.jdbc.JdbcResultRow) OutputStream(java.io.OutputStream) WriterOutputStream(org.apache.commons.io.output.WriterOutputStream) WriterOutputStream(org.apache.commons.io.output.WriterOutputStream) Test(org.junit.Test)

Example 9 with JdbcResultRow

use of com.adaptris.jdbc.JdbcResultRow in project interlok by adaptris.

the class StringColumnTranslatorTest method testAsByteTranslator.

@Test
public void testAsByteTranslator() throws Exception {
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", "111".getBytes(), Types.VARCHAR);
    {
        String translated = translator.translate(row, 0);
        assertEquals("111", translated);
    }
    {
        String translated = translator.translate(row, "testField");
        assertEquals("111", translated);
    }
}
Also used : JdbcResultRow(com.adaptris.jdbc.JdbcResultRow) Test(org.junit.Test)

Example 10 with JdbcResultRow

use of com.adaptris.jdbc.JdbcResultRow in project interlok by adaptris.

the class StringColumnTranslatorTest method testStringTranslator.

@Test
public void testStringTranslator() throws Exception {
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", "111", Types.VARCHAR);
    {
        String translated = translator.translate(row, 0);
        assertEquals("111", translated);
    }
    {
        String translated = translator.translate(row, "testField");
        assertEquals("111", translated);
    }
}
Also used : JdbcResultRow(com.adaptris.jdbc.JdbcResultRow) Test(org.junit.Test)

Aggregations

JdbcResultRow (com.adaptris.jdbc.JdbcResultRow)69 Test (org.junit.Test)65 OutputStream (java.io.OutputStream)9 StringWriter (java.io.StringWriter)9 WriterOutputStream (org.apache.commons.io.output.WriterOutputStream)9 SQLException (java.sql.SQLException)5 Clob (java.sql.Clob)4 SerialClob (javax.sql.rowset.serial.SerialClob)4 JdbcResultSet (com.adaptris.jdbc.JdbcResultSet)3 ByteArrayOutputStream (java.io.ByteArrayOutputStream)3 ArrayList (java.util.ArrayList)3 CoreException (com.adaptris.core.CoreException)2 MetadataElement (com.adaptris.core.MetadataElement)2 AdaptrisMessage (com.adaptris.core.AdaptrisMessage)1 ServiceException (com.adaptris.core.ServiceException)1 NoSuchElementException (java.util.NoSuchElementException)1 Document (org.w3c.dom.Document)1 Element (org.w3c.dom.Element)1