package com.missiondata.dbtest.containerTest;

//UserContainerTest

import junit.extensions.TestSetup;
import junit.framework.*;
import java.sql.*;
import com.missiondata.dbtest.container.UserContainer;
import com.missiondata.dbtest.model.User;

public class UserContainerTest extends TestCase
{

  static Connection connection;

  /**
   * Set up work to be done before test cases.
   */
  public void setUp()
  {
    try
    {
      Class.forName("org.gjt.mm.mysql.Driver");
      String url = "jdbc:mysql://localhost/junit_test";
      connection = DriverManager.getConnection(url,"","");
      if ( connection == null )
      {
        System.err.println( "connection was null!" );
      }
    }
    catch (SQLException se)
    {
      System.err.println( "SQLException in setUp(): " + se.getMessage() );
    }
    catch (ClassNotFoundException cnfe)
    {
      System.err.println( "ClassNotFoundException in setUp(): " + cnfe.getMessage() );
    }
  }

  //--------------------------------------------------------------------------//

  protected void tearDown()
  {
    try
    {
      connection.close();
    }
    catch (Exception e)
    {
    }
  }

  //--------------------------------------------------------------------------//

  public void testGetUserByName()
  {
    String username = "user1";
    String password = "user1p";
    String email    = "user1@missiondata.com";
    try
    {
      User user = UserContainer.getUserByName(connection,username);
      assertEquals("username", username, user.getUsername() );
      assertEquals("password", password, user.getPassword() );
      assertEquals("email",    email,    user.getEmail() );
    }
    catch (SQLException se)
    {
    }
  }

  //--------------------------------------------------------------------------//

  public void testExceptionThrowing()
  {
    try
    {
      User user = UserContainer.getUserByName(null,null);
      fail("You should never see this.");
    }
    catch (NullPointerException npe)
    {
    }
    catch (SQLException se)
    {
    }
  }

  //--------------------------------------------------------------------------//

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

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

  /**
   * add one line here for each test in the suite
   */
  public static Test suite()
  {
    TestSuite suite = new TestSuite();

    // run tests manually
    //suite.addTest( new UserContainerTest("testNumericAddress1") );
    //return suite;
/*
    TestSetup wrapper = new TestSetup(suite) {
      public void setUp()
      {
        try
        {
          Class.forName("org.gjt.mm.mysql.Driver");
          String url = "jdbc:mysql://localhost/junit_test";
          connection = DriverManager.getConnection(url,"","");
        }
        catch (SQLException se)
        {
          System.err.println( "SQLException in setUp(): " + se.getMessage() );
        }
        catch (ClassNotFoundException cnfe)
        {
          System.err.println( "ClassNotFoundException in setUp(): " + cnfe.getMessage() );
        }
      }
    };
*/
    // or, run tests dynamically
    return new TestSuite(UserContainerTest.class);
  }

}