/* Copyright (c) 2005 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.  
 */

import com.ricebridge.csvman.*;


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

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


/** Test class to demonstrate use of MaxMindManager.
 *    Note that JUnit is required by this class. And, yes, 
 *  we know there are no actual tests in this class, but
 *  using the JUnit framwork just makes it easier to run the examples.
 */
public class MaxMindTest extends TestCase {

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

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

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

  
  // test methods

  /** Insert all CSV data in database table IPLookup.
   *    Assumes data is in file data.csv
   */
  public void testInsert() throws Exception { 
    MaxMindManager mmm = new MaxMindManager();
    Connection     conn = mmm.getConnection();
    mmm.insert( new File("data.csv"), conn );
    conn.close();
  }


  /** Lookup a country code using an IP address. */
  public void testLookup() throws Exception { 
    MaxMindManager mmm = new MaxMindManager();
    Connection     conn = mmm.getConnection();
    String ip = "62.58.170.201";
    String cc = mmm.findCountry( ip, conn );
    System.out.println( "ip:"+ip+" cc:"+cc );
    conn.close();
  }


  /** Update existing database with new records in file update.csv. */ 
  public void testUpdate() throws Exception { 
    MaxMindManager mmm = new MaxMindManager();
    Connection     conn = mmm.getConnection();
    mmm.update( new File("update.csv"), conn );
    conn.close();
  }

}