// This Source Code is in the Public Domain per: http://litesoft.org/License.txt
package org.litesoft.codec;

import java.sql.*;

import junit.framework.*;

import org.litesoft.core.simpletypes.temporal.*;
import org.litesoft.core.typeutils.*;

public class SqlDateTypedTerminatingCodecTest extends TestCase
{
    public static TestSuite suite()
    {
        return new TestSuite( SqlDateTypedTerminatingCodecTest.class );
    }

    public SqlDateTypedTerminatingCodecTest( String name )
    {
        super( name );
    }

    public static void main( String[] args )
    {
        junit.textui.TestRunner.run( suite() );
    }

    private static final TypedTerminatingCodec<Date> CODEC = SqlDateTypedTerminatingCodec.INSTANCE;

    public void testDateStuff()
    {
        System.out.println( "Date.UTC( 70, 0, 1, 0, 0, 0 ) == " + Date.UTC( 70, 0, 1, 0, 0, 0 ) );
        show( "Util.Date: ", new java.util.Date( 0 ) );
        show( " SQL.Date: ", new Date( 0 ) );
        show( " SQL.Time: ", new Time( 0 ) );
        show( "Timestamp: ", new Timestamp( 0 ) );
    }

    private void show( String pWhat, java.util.Date pDate )
    {
        System.out.println( pWhat + pDate.getTime() + " | " + pDate.getTimezoneOffset() );
        System.out.println( Strings.spaces( pWhat.length() ) + pDate + " | " + new Timestamp( pDate.getTime() ) );
        System.out.println( Strings.spaces( pWhat.length() ) + pDate.toGMTString() + " | " + new Timestamp( pDate.getTime() ).toGMTString() );
    }

    public void test_checkBadStrings()
    {
        try
        {
            decode( "~" );
            fail( "Bad Char OK?" );
        }
        catch ( IllegalArgumentException expected )
        {
            // OK
        }
        String zEncoded = encode( make( 0 ) );
        try
        {
            decode( zEncoded + AbstractTypedTerminatingCodec.NULL_AS_CHAR );
            fail( "Extra Char OK?" );
        }
        catch ( IllegalArgumentException expected )
        {
            // OK
        }
    }

    private Date make( long pLongMillisSinceEpoch )
    {
        java.util.Date zDate = new java.util.Date( pLongMillisSinceEpoch );

        return new SimpleDate( zDate ).toSQLvalue();
    }

    public void test_wierds()
            throws Exception
    {
        checkRT( null );
//        Timestamp zNow;
//        for ( zNow = Timestamps.now(); timeAllZeros( zNow ); zNow = Timestamps.now() )
//        {
//            Thread.sleep( 2 );
//        }
//        long zNowTSasLong = zNow.getTime();
//        Date zDate = new Date( zNowTSasLong );
//        assertEquals( zNowTSasLong, zDate.getTime() );
//        checkRT( SqlDate.POSITIVE_INFINITY );
//    }
//
//    @SuppressWarnings("deprecation")
//    private boolean timeAllZeros( Timestamp pTimestamp )
//    {
//        return (pTimestamp.getHours() == 0) && (pTimestamp.getMinutes() == 0) && (pTimestamp.getSeconds() == 0) && (pTimestamp.getNanos() == 0);
    }

    public void test_values()
            throws Exception
    {
//        checkRT( SqlDate.MIN_VALUE );
//        checkRT( SqlDate.MIN_VALUE + 1 );
//        checkRT( SqlDate.MIN_VALUE / 2 );
//
//        checkRT( -300.01234d );
//        checkRT( -65d );
//        checkRT( -64d );
//        checkRT( -63d );
//        checkRT( -33d );
//        checkRT( -32d );
//        checkRT( -31d );
//        checkRT( -17d );
//        checkRT( -16d );
//        checkRT( -15d );
//        checkRT( -3d );
//        checkRT( -1d );
//
//        checkRT( 0d );
//
//        checkRT( 1d );
//        checkRT( 3d );
//        checkRT( 15d );
//        checkRT( 16d );
//        checkRT( 17d );
//        checkRT( 31d );
//        checkRT( 32d );
//        checkRT( 33d );
//        checkRT( 63d );
//        checkRT( 64d );
//        checkRT( 65d );
//        checkRT( 300.01234d );
//
//        checkRT( SqlDate.MAX_VALUE / 2 );
//        checkRT( SqlDate.MAX_VALUE - 1 );
//        checkRT( SqlDate.MAX_VALUE );
    }

    private void checkRT( Date pValue )
    {
        String encoded = encode( pValue );
        Date rtValue = decode( encoded );
        assertEquals( "RT (" + encoded + ") ", pValue, rtValue );
        System.out.println( "RT " + pValue + ": " + encoded );
    }

    private Date decode( String pEncoded )
    {
        return CODEC.decode( pEncoded );
    }

    private String encode( Date pValue )
    {
        return CODEC.encode( pValue );
    }
}