Search in sources :

Example 61 with JdbcResultRow

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

the class StringColumnTranslatorTest method testAsFloatTranslator.

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

Example 62 with JdbcResultRow

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

the class StringColumnTranslatorTest method testAsDoubleTranslator.

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

Example 63 with JdbcResultRow

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

the class TimeColumnTranslatorTest method testGregorianFormatted.

@Test
public void testGregorianFormatted() throws Exception {
    translator.setDateFormat("HH:mm:ss");
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", gDate, Types.TIME);
    {
        String translated = translator.translate(row, 0);
        assertEquals("12:12:12", translated);
    }
    {
        String translated = translator.translate(row, "testField");
        assertEquals("12:12:12", translated);
    }
}
Also used : JdbcResultRow(com.adaptris.jdbc.JdbcResultRow) Test(org.junit.Test)

Example 64 with JdbcResultRow

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

the class TimeColumnTranslatorTest method testDateFormatted.

@Test
public void testDateFormatted() throws Exception {
    translator.setDateFormat("HH:mm");
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", date, Types.TIME);
    {
        String translated = translator.translate(row, 0);
        assertEquals("12:12", translated);
    }
    {
        String translated = translator.translate(row, "testField");
        assertEquals("12:12", translated);
    }
}
Also used : JdbcResultRow(com.adaptris.jdbc.JdbcResultRow) Test(org.junit.Test)

Example 65 with JdbcResultRow

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

the class TimeColumnTranslatorTest method testDateNoFormat.

@Test
public void testDateNoFormat() throws Exception {
    JdbcResultRow row = new JdbcResultRow();
    row.setFieldValue("testField", date, Types.TIME);
    {
        String translated = translator.translate(row, 0);
        // starts with, being careful of timezone
        assertTrue(translated.startsWith("12:12:12"));
    }
    {
        String translated = translator.translate(row, "testField");
        // starts with, being careful of timezone
        assertTrue(translated.startsWith("12:12:12"));
    }
}
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