/* Copyright (c) 2005-2006 Ricebridge. All Rights Reserved.
 *
 * This file is available under the terms and conditions of the
 * Ricebridge "Open Source API" policy; Ricebridge grants use of this
 * copyrighted work under the terms of a BSD-style license only. See
 * http://www.opensource.org/licenses/bsd-license.php for more
 * information.
 * 
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions
 * are met:
 * 
 *  - Redistributions of source code must retain the above copyright
 *  notice, this list of conditions and the following disclaimer.
 *
 *  - Redistributions in binary form must reproduce the above
 *  copyright notice, this list of conditions and the following
 *  disclaimer in the documentation and/or other materials provided
 *  with the distribution.
 *
 *  - Neither the name of the Ricebridge nor the names of its
 *  contributors may be used to endorse or promote products derived
 *  from this software without specific prior written permission.
 * 
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
 * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
 * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
 * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
 * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
 * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT,
 * STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED
 * OF THE POSSIBILITY OF SUCH DAMAGE.  
 */

package com.ricebridge.csvman.test;


import com.ricebridge.csvman.*;

import org.jostraca.util.*;

import junit.framework.*;
import junit.textui.*;

import javax.swing.table.*;
import java.sql.ResultSet;
import java.util.*;
import java.io.*;


/** Test cases for CSV field quoting.
 *    <p>The <b><a href="QuoteTest.java.html">Source Code</a></b> of this Java class 
 *    is available under a <a href="http://www.opensource.org/licenses/bsd-license.php">BSD-style license</a>.</p>
 */
public class QuoteTest extends TestCase {

  // standard test methods
  
  public QuoteTest( String pName ) {
    super( pName );
  }

  public static TestSuite suite() {
    return new TestSuite( QuoteTest.class );
  }

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


  public void testSaveQuoting() throws Exception {
    ArrayList    data   = new ArrayList();
    data.add( new String[] {"a","b","c"}  );
    data.add( new String[] {"a\"a","b,b","c\nc"}  );
    data.add( new String[] {"\"aa\"",",b,","\nc\n"}  );
    data.add( new String[] {"a\ra","b\nb","c\r\nc"}  );
    data.add( new String[] {"a\ta","b","c"}  );

    // test standard
    CsvManager   csvm   = new CsvManager();
    csvm.setCsvSpec( csvm.makeExcelSpec() );
    CsvSpec cs = csvm.getCsvSpec();    
    assertTrue( !cs.getUseEscape() );
    assertTrue( !cs.getUseEscapeMap() );
    String       out    = csvm.saveToString( data );
    out = out.replace('\r','R'); out = out.replace('\n','N'); out = out.replace('"','\''); out = out.replace('\\','/');
    String expect = "a,b,cRN'a''a','b,b','cNc'RN'''aa''',',b,','NcN'RN'aRa','bNb','cRNc'RNa\ta,b,cRN";
    assertEquals( expect, out );

    // test escape
    // note: commas not escaped as quoted, double quotes still used, but internal newlines ARE escaped
    cs = csvm.getCsvSpec();
    cs.setUseEscape( true );
    assertTrue( cs.getUseEscape() );
    assertTrue( cs.getUseEscapeMap() );
    out = csvm.saveToString( data );
    out = out.replace('\r','R'); out = out.replace('\n','N'); out = out.replace('"','\''); out = out.replace('\\','/');
    expect = "a,b,cRN'a''a','b,b','c/nc'RN'''aa''',',b,','/nc/n'RN'a/ra','b/nb','c/r/nc'RNa/ta,b,cRN";
    assertEquals( expect, out );

    // test escape on quotes
    cs = csvm.getCsvSpec();
    cs.setDoubleQuote( false );
    assertTrue( cs.getUseQuote() );
    assertTrue( !cs.getDoubleQuote() );
    assertTrue( cs.getUseEscape() );
    assertTrue( cs.getUseEscapeMap() );
    out = csvm.saveToString( data );
    out = out.replace('\r','R'); out = out.replace('\n','N'); out = out.replace('"','\''); out = out.replace('\\','/');
    expect = "a,b,cRN'a/'a','b,b','c/nc'RN'/'aa/'',',b,','/nc/n'RN'a/ra','b/nb','c/r/nc'RNa/ta,b,cRN";
    assertEquals( expect, out );


    // test escape, with no quotes, so commas get escaped
    cs = csvm.getCsvSpec();
    cs.setUseQuote( false );
    assertTrue( !cs.getUseQuote() );
    assertTrue( !cs.getDoubleQuote() );
    assertTrue( cs.getUseEscape() );
    assertTrue( cs.getUseEscapeMap() );
    out = csvm.saveToString( data );
    out = out.replace('\r','R'); out = out.replace('\n','N'); out = out.replace('"','\''); out = out.replace('\\','/');
    expect = "a,b,cRNa'a,b/,b,c/ncRN'aa',/,b/,,/nc/nRNa/ra,b/nb,c/r/ncRNa/ta,b,cRN";
    assertEquals( expect, out );
  }




}