import java.sql.*;
import java.net.*;
import java.io.*;
import java.lang.*;
import java.util.*;

public class times {
	
	
	public static void main (String[] args) throws Exception
       {
       	
       	
       	
       	String primo,secondo;
		secondo = null;
		String time=null;
		String year=null;
		
       	String[]res;

        FileWriter fi = new FileWriter("G:\\Documents and Settings\\cristiano\\Desktop\\tesina seminario\\tesina\\finalScripts\\times.sql");
		PrintWriter out=new PrintWriter(fi);
	      
       	FileReader f = new FileReader("G:\\Documents and Settings\\cristiano\\Desktop\\tesina seminario\\tesina\\file IMDB\\running-times.txt");
        BufferedReader filebuf = new BufferedReader(f); 
      

        String nextStr;
        nextStr = filebuf.readLine();
        
			
		while (!nextStr.equals("RUNNING TIMES LIST")){
		nextStr = filebuf.readLine();
        }	
			
		nextStr = filebuf.readLine();
        nextStr = filebuf.readLine();
        
         					
        
        	
			
     	while (nextStr!=null){
        
        	 if (nextStr.equals("--------------------------------------------------------------------------------")){
        	System.out.println("Times inseriti nel db");
        	break;
        }
       
        	
         nextStr=nextStr.replace("'","");
        	
         
         
         int tab =nextStr.indexOf("\t");
         
         primo=nextStr.substring(0,tab);
         
         secondo=nextStr.substring(tab);
        
        
        
          	if (secondo.contains(":") && !secondo.contains("(")){
          		
          		int inizio=secondo.indexOf(":");
          		
          		 time=secondo.substring(inizio+1);
          		  		
          		
          	}
          	
          	if (!secondo.contains(":") && secondo.contains("(") && !secondo.contains(",")){
          			int tonda3 = secondo.indexOf("(");
          			
          			time=secondo.substring(0,tonda3);
          			time=time.replace("\t","");
          		 
          	
          	} 
          	
          	if (secondo.contains(":") && secondo.contains("(") && !secondo.contains(",")){
          		
          		int inizio=secondo.indexOf(":");
          		int tonda4 = secondo.indexOf("(");
          		
          		
          		 time=secondo.substring(inizio+1,tonda4);
          		 time=time.replace("\t","");
          		  		
          		
          	}
          	
          	
          	if (!secondo.contains(":") && !secondo.contains("(") && !secondo.contains(",")){
          		
          			
          		 time=secondo;
          		 time=time.replace("\t","");
          		  		
          		
          	}
          	
          	if (secondo.contains(":") && secondo.contains("(") && secondo.contains(",")){
          		
          	int tonda4 = secondo.indexOf("(");
          		
          		
          		 time=secondo.substring(0,tonda4);
          		 time=time.replace("\t","");
          		  		
          		
          	}
          	
          
        
       	
      
       	
         if (primo.contains("(")){
 	  		int indice = primo.indexOf("(");
 	  		int fine = primo.indexOf(")");
 	  		year=primo.substring(indice+1,fine);
 	  		
 	  		primo = primo.substring(0,indice);
 	  		}
 	  	else
 	  	{
 	  		year=null;
 	  	}
 	  		
 	  		
 	  		
 	  	
 	  	
        //System.out.println("***************");
        //System.out.println(primo);
      	//System.out.println(time);
       
       	
    			    
  					
  				out.println("UPDATE movies SET runtimes='"+time+"' WHERE title='"+primo+"' and year='"+year+"';");
		
   					
   				
       
       
       nextStr = filebuf.readLine();// legge una riga del file 
    
           }
           
       
       filebuf.close();  // chiude il file    
       out.close();    
       }
		
		
		
	}