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

public class Test {

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

  public void go() { 
    System.out.println("Running Test");

    try {
      // Create a division
      long divisionId = 0;
      Division division = new Division();
      division.setDivisionName("North America");
      divisionId = division.store();

      //Create a Region and put it in division above
      long regionId = 0;
      Region region = new Region();
      region.setRegionName("New England");
      region.setDivisionId(divisionId);
      regionId = region.store();

      //Create a location and put it in region above
      Location location = new Location();
      location.setName("Boston");
      location.setRegionId(regionId);     //Region and division exist already
      long locationId = 0;
      locationId = location.store(); 

      //Print out details of location
      Location l = new Location(locationId);
      System.out.println("Location name = " + l.getName() ); 
      System.out.println("Region this location is in  = "  + l.getRegionName() ); 
      System.out.println("Division this location is in = " + l.getDivisionName() ); 

    }
    catch (Exception exp) {
      System.err.println("Exception: " + exp);
      exp.printStackTrace();
    }


  }

}