void setup(){
  
  // screen

  size(1400,768);
  background(255);
  frameRate(60);
  smooth();
  

  // font

  gFont = createFont("Helvetica", 34);
  gFont2 = createFont("Helvetica", 22);
  gFont3 = createFont("Helvetica", 12);
  gFont4 = createFont("Helvetica-bold", 16);
  

  // fetch result

  pResult_Div10a_Apple     = new Integer[10];
  pResult_Div10b_Apple     = new Integer[10];
  pResult_Div10a_Microsoft = new Integer[10];
  pResult_Div10b_Microsoft = new Integer[10];
//  pResult_Div100a_Apple     = new Integer[100];
//  pResult_Div100b_Apple     = new Integer[100];
//  pResult_Div100a_Microsoft = new Integer[100];
//  pResult_Div100b_Microsoft = new Integer[100];
  
  
  // variables
  String[] Filenames = {
    "apple_10.txt",
    "apple_20012011_10.txt",
    "microsoft_10.txt",
    "microsoft_20012011_10.txt" };
  
  String[] QueryStrings = {
    "apple",
    "apple",
    "microsoft",
    "microsoft" };
  
  int[] QueryDivs = {
    100,
    100,
    100,
    100 };
    
  boolean[] QueryYearCond = {
    false,
    true,
    false,
    true  };
    
  Integer[][] pDataMatrices = {
    pResult_Div10a_Apple,
    pResult_Div10b_Apple,
    pResult_Div10a_Microsoft,
    pResult_Div10b_Microsoft  };
    
  for( int i=0; i<pDataMatrices.length; i++ )  {
    for( int j=0; j<pDataMatrices[i].length; j++ )  {
      pDataMatrices[i][j] = new Integer(0);
    }
  }
  
  // fetch result from text data
  
  //apple_dewey_num  = new int[10];
  

  // bring text files data
  
  for (int i=0; i<Filenames.length; i++ )  {
    
    // try to read local file
    try
    {
      println("reading "+Filenames[i]+"...");
      
      String [] textData = loadStrings(Filenames[i]);

      for( int j=0; j<textData.length; j++ )  {
        
        String textSplitted[] = split(textData[j], ",");
        int idx = (int)Integer.parseInt(textSplitted[0]);
        int val = (int)Integer.parseInt(textSplitted[1]);
        
        pDataMatrices[i][idx] = val;
        
      }
      
    // if file is not loadable, then query data
    } catch(Exception e) {
      
      // connect
      if( msql == null )  {
        println("connecting to database ...");
      
        msql = new MySQL( this, MySQL_host, MySQL_database, MySQL_user, MySQL_pass ); //host, database, user, password
        assert( msql!=null && msql.connect() );
      }
      
      // query
      println("querying ...");}
    
     /* if( !QueryYearCond[i] )
        msql.query( getSearchQuery(QueryStrings[i], QueryDivs[i]) );  
      else
        msql.query( getSearchBetweenYearsQuery(QueryStrings[i], 2001, 2011, QueryDivs[i]) );  
        
      String[] textSave = null;

      while( msql.next() ) {
        
        pDataMatrices[i][msql.getInt(1)] = msql.getInt(2);
        
        String textRow = msql.getString(1) + "," + msql.getString(2);
        
        if( textSave == null )  {
          textSave = new String[1];
          textSave[0] = textRow;
        }
        else
          textSave = append(textSave, textRow);
          
      }
      
      // save for further use
      println("saving data to file ...");
      
      saveStrings(Filenames[i], textSave);
        
    }*/
    
  }
  
//  String apple_dewey[] = loadStrings("apple_10.txt");
//  
//   for (int i = 0; i < apple_dewey.length; i++){
//   String apple_dewey_num[] = split(apple_dewey[i], ",");
////   println(Integer.parseInt(apple_dewey_num[1]));
//   pResult_Div10a_Apple[(int)Integer.parseInt(apple_dewey_num[0])] = (int)Integer.parseInt(apple_dewey_num[1]);
//  }
//  
//
//
//
//  // connecting to the KRAKEN database
//
////  println("connecting to database ...");
////
////  msql = new MySQL( this, MySQL_host, MySQL_database, MySQL_user, MySQL_pass ); //host, database, user, password
////  assert( msql!=null && msql.connect() );
//
//
//  // fetching results (10)
//
//  println("querying: count result by 'apple' keyword");
//
//  msql.query( getSearchQuery("apple", 100) );  
//  while( msql.next() ) {
//    pResult_Div10a_Apple[msql.getInt(1)] = msql.getInt(2);
//  }
//  
//  println("querying: count result by 'apple' keyword between 2001 and 2011");
//
//  msql.query( getSearchBetweenYearsQuery("apple", 2001, 2011, 100) ); 
//  while( msql.next() ) {
//    pResult_Div10b_Apple[msql.getInt(1)] = msql.getInt(2);
//  }
//
//  println("querying: count result by 'microsoft' keyword");
//
//  msql.query( getSearchQuery("microsoft", 100) );
//  while( msql.next() )  {
//    pResult_Div10a_Microsoft[msql.getInt(1)] = msql.getInt(2);
//  }
//  
//  println("querying: count result by 'microsoft' keyword between 2001 and 2011");
//
//  msql.query( getSearchBetweenYearsQuery("microsoft", 2001, 2011, 100) );
//  while( msql.next() ) {
//    pResult_Div10b_Microsoft[msql.getInt(1)] = msql.getInt(2);
//  }
//
//
//  // fetching results (100)
//
//  println("querying: count result by 'apple' keyword");
//
//  msql.query( getSearchQuery("apple", 10) );  
//  while( msql.next() ) {
//    pResult_Div100a_Apple[msql.getInt(1)] = msql.getInt(2);
//  }
//  
//  println("querying: count result by 'apple' keyword between 2001 and 2011");
//
//  msql.query( getSearchBetweenYearsQuery("apple", 2001, 2011, 10) );  
//  while( msql.next() ) {
//    pResult_Div100b_Apple[msql.getInt(1)] = msql.getInt(2);
//  }
//
//  println("querying: count result by 'microsoft' keyword");
//
//  msql.query( getSearchQuery("microsoft", 10) );
//  while( msql.next() )  {
//    pResult_Div100a_Microsoft[msql.getInt(1)] = msql.getInt(2);
//  }
//  
//  println("querying: count result by 'microsoft' keyword between 2001 and 2011");
//
//  msql.query( getSearchBetweenYearsQuery("microsoft", 2001, 2011, 10) );
//  while( msql.next() ) {
//    pResult_Div100b_Microsoft[msql.getInt(1)] = msql.getInt(2);
//  }
  
  
  // mode change
  fAnimateMode1Ratio1 = .0f;
  fAnimateMode1Ratio2 = .0f;
  nTimeStart = millis();
  displayMode = 1;
  
  
  // end
}