/* Copyright (c) 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 com.ricebridge.data.Text;

import org.jostraca.util.*;

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

import java.util.*;
import java.io.*;
import java.sql.*;


/** Test cases for {@link com.ricebridge.csvman.CsvManager} StringArray save handling.
 *    <p>The <b><a href="SaveTableModelTest.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 SaveTableModelTest extends TestCase {

  // test framework
  
  public SaveTableModelTest( String pName ) {
    super( pName );
  }

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

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



  // test cases

  public void testExample() throws Exception {
    File         csvFile    = TestUtil.getTextCsvFile( "save" );
    CsvManager   csvManager = new CsvManager();

    ArrayList    data       = new ArrayList();
    data.add( new String[] {"r1","f1","b1"} );
    data.add( new String[] {"r2","f2","b2"} );
    data.add( new String[] {"r3","f3","b3"} );
    CsvTableModel tm = new CsvTableModel( data );

    csvManager.save( csvFile, tm, false );
    assertEquals( "r1,f1,b1\nr2,f2,b2\nr3,f3,b3\n", FileUtil.readFile(csvFile) );

    csvManager.save( csvFile, tm, true );
    assertEquals( "Column 1,Column 2,Column 3\nr1,f1,b1\nr2,f2,b2\nr3,f3,b3\n", FileUtil.readFile(csvFile) );
  }


    

  public void testSingle() throws Exception {
    ArrayList data = new ArrayList();
    data.add( new String[] {"b1","q1"} );
    data.add( new String[] {"b2","q2"} );
    CsvTableModel tm = new CsvTableModel( data );

    String savecanon  = "b1,q1\nb2,q2\n";
    String savecanonh = "Column 1,Column 2\nb1,q1\nb2,q2\n";

    File csvFile = null;
    csvFile = TestUtil.getTextCsvFile( "save" );
    CsvManager csvManager = new CsvManager();


    // legacy methods

    FileUtil.writeFile(csvFile,"");
    csvManager.save( csvFile, tm, false );
    assertEquals( savecanon, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    csvManager.save( csvFile, tm, true );
    assertEquals( savecanonh, FileUtil.readFile(csvFile) );


    FileUtil.writeFile(csvFile,"");
    csvManager.save( csvFile.getAbsolutePath(), tm, false );
    assertEquals( savecanon, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    csvManager.save( csvFile.getAbsolutePath(), tm, true );
    assertEquals( savecanonh, FileUtil.readFile(csvFile) );


    OutputStream os = null;

    FileUtil.writeFile(csvFile,"");
    os = new FileOutputStream( csvFile );
    csvManager.save( os, tm, false );
    assertEquals( savecanon, FileUtil.readFile(csvFile) );
    os.close();

    FileUtil.writeFile(csvFile,"");
    os = new FileOutputStream( csvFile );
    csvManager.save( os, tm, true );
    assertEquals( savecanonh, FileUtil.readFile(csvFile) );
    os.close();


    // sink methods

    FileUtil.writeFile(csvFile,"");
    FileWriter fw = new FileWriter( csvFile );
    csvManager.saveTableModel( fw, tm );
    assertEquals( savecanon, FileUtil.readFile(csvFile) );
    fw.close();

    Text bt = new Text();
    csvManager.setCsvSpec( csvManager.makeUnixSpec() );
    csvManager.saveTableModel( bt, tm );
    assertEquals( savecanon, bt.getText() );


    // saveToString

    csvManager.setCsvSpec( csvManager.makeUnixSpec() );
    String out = null;

    out = csvManager.saveToString( tm, false );
    assertEquals( savecanon, out );

    out = csvManager.saveToString( tm, true );
    assertEquals( savecanonh, out );
  }




  public void testRepeats() throws Exception {
    ArrayList data1 = new ArrayList();
    data1.add( new String[] {"b1","q1"} );
    data1.add( new String[] {"b2","q2"} );
    CsvTableModel tm1 = new CsvTableModel( data1 );

    String savecanon1 = "b1,q1\nb2,q2\n";

    File csvFile = null;
    csvFile = TestUtil.getTextCsvFile( "saveTableModel" );

    CsvManager csvManager = new CsvManager();
    csvManager.setCsvSpec( csvManager.makeUnixSpec() );

    FileUtil.writeFile(csvFile,"");
    csvManager.saveTableModel( csvFile, tm1 );
    assertEquals( savecanon1, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    csvManager.saveTableModel( csvFile.getAbsolutePath(), tm1 );
    assertEquals( savecanon1, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    OutputStream os = new FileOutputStream( csvFile );
    csvManager.saveTableModel( os, tm1 );
    assertEquals( savecanon1, FileUtil.readFile(csvFile) );
    os.close();

    FileUtil.writeFile(csvFile,"");
    FileWriter fw = new FileWriter( csvFile );
    csvManager.saveTableModel( fw, tm1 );
    assertEquals( savecanon1, FileUtil.readFile(csvFile) );
    fw.close();

    Text text = new Text();
    csvManager.saveTableModel( text, tm1 );
    assertEquals( savecanon1, text.toString() );


    ArrayList data2 = new ArrayList();
    data2.add( new String[] {"2b1","2q1"} );
    data2.add( new String[] {"2b2","2q2"} );
    data2.add( new String[] {"2b3","2q3"} );
    CsvTableModel tm2 = new CsvTableModel( data2 );


    String savecanon2 = "2b1,2q1\n2b2,2q2\n2b3,2q3\n";

    FileUtil.writeFile(csvFile,"");
    csvManager.saveTableModel( csvFile, tm2 );
    assertEquals( savecanon2, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    csvManager.saveTableModel( csvFile.getAbsolutePath(), tm2 );
    assertEquals( savecanon2, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    os = new FileOutputStream( csvFile );
    csvManager.saveTableModel( os, tm2 );
    assertEquals( savecanon2, FileUtil.readFile(csvFile) );
    os.close();

    FileUtil.writeFile(csvFile,"");
    fw = new FileWriter( csvFile );
    csvManager.saveTableModel( fw, tm2 );
    assertEquals( savecanon2, FileUtil.readFile(csvFile) );
    fw.close();

    text = new Text();
    csvManager.saveTableModel( text, tm2 );
    assertEquals( savecanon2, text.toString() );


    ArrayList data3 = new ArrayList();
    data3.add( new String[] {"3b1","3q1"} );
    data3.add( new String[] {"3b2","3q2"} );
    data3.add( new String[] {"3b3","3q3"} );
    data3.add( new String[] {"3b4","3q4"} );
    CsvTableModel tm3 = new CsvTableModel( data3 );

    String savecanon3 = "3b1,3q1\n3b2,3q2\n3b3,3q3\n3b4,3q4\n";

    FileUtil.writeFile(csvFile,"");
    csvManager.saveTableModel( csvFile, tm3 );
    assertEquals( savecanon3, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    csvManager.saveTableModel( csvFile.getAbsolutePath(), tm3 );
    assertEquals( savecanon3, FileUtil.readFile(csvFile) );

    FileUtil.writeFile(csvFile,"");
    os = new FileOutputStream( csvFile );
    csvManager.saveTableModel( os, tm3 );
    assertEquals( savecanon3, FileUtil.readFile(csvFile) );
    os.close();

    FileUtil.writeFile(csvFile,"");
    fw = new FileWriter( csvFile );
    csvManager.saveTableModel( fw, tm3 );
    assertEquals( savecanon3, FileUtil.readFile(csvFile) );
    fw.close();

    text = new Text();
    csvManager.saveTableModel( text, tm3 );
    assertEquals( savecanon3, text.toString() );
  }

}