DateDataTypeTest.java

package net.sourceforge.mayfly.datastore.types;

import junit.framework.TestCase;

import net.sourceforge.mayfly.MayflyException;
import net.sourceforge.mayfly.datastore.DateCell;

public class DateDataTypeTest extends TestCase {

    public void testStringToDate() throws Exception {
        checkFailure("");
        checkFailure("123");
        checkFailure("12345");
        checkFailure("12345-01-01");
        checkFailure("x1234-01-01");
        checkFailure("1234-01-01x");
        check(1234, 1, 1, "1234-01-01");
        checkFailure("1066");
        checkFailure("1066x12-25");
        checkFailure("106612-25");
        check(1066, 12, 25, "1066-12-25");
        try {
            new DateDataType().stringToDate("1890-02-31");
            fail();
        }
        catch (org.joda.time.IllegalFieldValueException expected) {
            // I'm thinking it is probably a mistake for Mayfly
            // to wrap the exception just to hide the fact that
            // mayfly is implemented using Joda.  Is it important
            // that it get caught by the "catch SQLException" which
            // tends to wrap most people's JDBC calls?
        }
    }

    public void testQuotingInMessage() throws Exception {
        try {
            new DateDataType().stringToDate("don't");
            fail();
        }
        catch (MayflyException e) {
            assertEquals(
                "'don''t' is not in format yyyy-mm-dd", e.getMessage());
        }
    }

    private void check(int expectedYear, int expectedMonth, int expectedDay, 
        String input) {
        DateCell date = new DateDataType().stringToDate(input);
        assertEquals(expectedYear, date.year());
        assertEquals(expectedMonth, date.month());
        assertEquals(expectedDay, date.day());
    }

    private void checkFailure(String input) {
        try {
            new DateDataType().stringToDate(input);
            fail();
        }
        catch (MayflyException e) {
            assertEquals("'" +
                    input +
                    "' is not in format yyyy-mm-dd", e.getMessage());
        }
    }

}