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

public class Test {

  public static void main(String args[] ) { 
    Test t = new Test();
    t.doIt();
  }

  public void doIt() { 
    System.out.println("Running Test");
    Iterator iterator = null;
    long key = 0;
    Driver d = null;

    d = new Driver();

    d.setFirstName("Peter");
    d.setMiddleName("Maurice");
    d.setLastName("Parker");
    d.setGender("M");
    d.setLicensePoints(2.0f);
    TimeZone timezone = TimeZone.getDefault();
    GregorianCalendar gc = new GregorianCalendar(timezone);
    gc.add(Calendar.YEAR, -20);
    d.setDateOfBirth(gc);
    d.setAddressLine1("10 Main st");
    d.setAddressLine2("");
    d.setCity("Brooklyn");
    d.setState("NY");
    d.setZip("12233");
    d.setHomePhone("718-123-45678");
    d.setWorkPhone("212-444-5555");
    d.setEmailAddress("pp@ff.org");

    try {
      key = d.store(); 
    }
    catch (Exception exp) {
      System.err.println("The store of Driver failed: " + exp.getMessage());
      exp.printStackTrace();
    }

    // Update this driver
    d = new Driver(key);
    d.setMiddleName("paul");
    d.setAddressLine1("1 Fifth Ave");
    d.setWorkPhone("516-444-5555");
    float points = d.getLicensePoints();    
    points += 1.5f;                         // got a ticket worth 1.5 points
    d.setLicensePoints(points);
    try {
      d.store(); 
    }
    catch (Exception exp) {
      System.err.println("The store of Driver failed: " + exp.getMessage());
      exp.printStackTrace();
    }


    // add a car owned by this driver
    Car c = new Car();
		c.setMake("Ford");
    c.setModel("Escort");
    c.setYear("1999");
    c.setMileage(10000);
    try {
      d.addCar(c); 
    }
    catch (Exception exp) {
      System.err.println("The add of Car failed: " + exp.getMessage());
      exp.printStackTrace();
    }

    // add a car owned by this driver
    c = new Car();
		c.setMake("Chevy");
    c.setModel("Nova");
    c.setYear("1967");
    c.setMileage(140000);
    try {
      d.addCar(c); 
    }
    catch (Exception exp) {
      System.err.println("The add of Car failed: " + exp.getMessage());
      exp.printStackTrace();
    }


    // Remove any Chevys that this driver owns
    // key = 1;           // Need to know the primary key of the driver
    // d = new Driver(key);
    // System.out.println("Removing any chevys owned by this driver:");
    // iterator = d.listCars();
    // while (iterator.hasNext() ) { 
    //   Car car  = (Car)iterator.next();
    //   if ( car.getMake().equalsIgnoreCase("chevy") ) { 
    //     try {
    //      d.removeCar(car);
    //     }
    //     catch (Exception exp) {
    //       System.err.println("The add of Car failed: " + exp.getMessage());
    //       exp.printStackTrace();
    //     } 
    //   } 
    // } 

    // Delete a driver, and all dependent address, contact info, and cars
    // key = 1;           // Need to know the primary key of the driver
    // d = new Driver(key);
    // try {
    //   d.delete(); 
    // }
    // catch (Exception exp) {
    //   System.err.println("The delete of Driver failed: " + exp.getMessage());
    //   exp.printStackTrace();
    // }


    // Display a driver
    d = new Driver(key);
    System.out.println("\n\n\n Displaying a Driver:");
    System.out.println("  firstName     = " + d.getFirstName() );
    System.out.println("  middleName    = " + d.getMiddleName() );
    System.out.println("  lastName      = " + d.getLastName() );
    System.out.println("  gender        = " + d.getGender() );
    System.out.println("  licensePoints = " + d.getLicensePoints() );
    System.out.println("  dateOfBirth   = " + (d.getDateOfBirth().getTime().toString()) );

    System.out.println("  address_line1 = " + d.getAddressLine1() );
    System.out.println("  address_line2 = " + d.getAddressLine2() );
    System.out.println("  city          = " + d.getCity() );
    System.out.println("  state         = " + d.getState() );
    System.out.println("  zip           = " + d.getZip() );
    System.out.println("  home_phone    = " + d.getHomePhone() );
    System.out.println("  work_phone    = " + d.getWorkPhone() );
    System.out.println("  email_address = " + d.getEmailAddress() );

    System.out.println("  Cars owned by this Driver:");
    iterator = d.listCars();
    while (iterator.hasNext() ) { 
      Car car  = (Car)iterator.next();
      System.out.println("    make      = " + car.getMake() );
      System.out.println("    model     = " + car.getModel() );
      System.out.println("    year      = " + car.getYear() );
      System.out.println("    mileage   = " + car.getMileage() );
    }
 

  }


}