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

public class genre {
	
	
	public static void main (String[] args) throws Exception
       {
       	
       	
       	
       	String movie,year,genre;
		
		
		
        FileWriter fi = new FileWriter("G:\\Documents and Settings\\cristiano\\Desktop\\tesina seminario\\tesina\\finalScripts\\genre.sql");
		PrintWriter out=new PrintWriter(fi);
		  
       	FileReader f = new FileReader("G:\\Documents and Settings\\cristiano\\Desktop\\tesina seminario\\tesina\\file IMDB\\genres.txt");
        BufferedReader filebuf = new BufferedReader(f); 
      

        String nextStr;
        nextStr = filebuf.readLine();
        
			
		while (!nextStr.equals("8: THE GENRES LIST")){
		nextStr = filebuf.readLine();
        }	
			
		nextStr = filebuf.readLine();
        nextStr = filebuf.readLine();
        nextStr = filebuf.readLine();
        
        				
		
     	while (nextStr!=null){
     		
     		if (nextStr.equals("--------------------------------------------------------------------------------")){
        	System.out.println("Genres inseriti nel db");
        	break;
        }
        
     	 nextStr = nextStr.replace("'","");
        	
        	
        int tab= nextStr.indexOf("\t");
        
        
        movie=nextStr.substring(0,tab);
        
        genre=nextStr.substring(tab+1);	
        	
   
        
        if (movie.contains("(")){
          	int fine2=movie.indexOf(")");
    		int inizio2=movie.indexOf("(");
    		year = movie.substring(inizio2+1,fine2);
    		movie=movie.substring(0,inizio2);     
    	}
    	
    	else {
    		
    		year=null;
    	}
    	
    	
    	
    	if (genre.contains("(")){
    		
    		int chiusa=genre.indexOf("(");
    		
    		genre=genre.substring(0,chiusa);
    		
    		
    	}
    	
    	
        /*
        System.out.println("***************");
        System.out.println(primo);
      	System.out.println(secondo);
      	*/
      	
    	genre=genre.replace("\t","");		
    			    
    			    
  					out.println("UPDATE movies SET genre='"+genre+"' WHERE title='"+movie+"' and year='"+year+"';");
			
		
       
       nextStr = filebuf.readLine();// legge una riga del file 
    
           }
           
       
       filebuf.close();  // chiude il file    
       out.close();    
       }
		
		
		
	}