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

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

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

        String nextStr;
        nextStr = filebuf.readLine();
        
			
		while (!nextStr.equals("SOUND-MIX LIST")){
		nextStr = filebuf.readLine();
        }	
			
		nextStr = filebuf.readLine();
        nextStr = filebuf.readLine();
        
        
        	
			
     	while (nextStr!=null){
     		   if (nextStr.equals("--------------------------------------------------------------------------------")){
        	System.out.println("Soundmix inseriti nel db");
        	break;
        }
     
        	
         nextStr=nextStr.replace("'","");
        	
         res=nextStr.split("\t");
        
          for (int x=1; x<res.length; x++){
         
          if (!res[x].equals("\t") && !res[x].startsWith("(")){
          	secondo= res[x];
          }
        
      	 }
       	
      
       	
        primo=res[0];
        	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(secondo);
        */
        
    			
    			   
  					out.println("UPDATE movies SET sound='"+secondo+"' WHERE title='"+primo+"'and year='"+year+"';");
		
   		
           
       
       
       nextStr = filebuf.readLine();// legge una riga del file 
    
           }
           
       
       filebuf.close();  // chiude il file    
        out.close();   
       }
		
		
		
	}