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

public class movies {
	
	
	public static void main (String[] args) throws Exception
       {
       	
       	
       	
       	String primo,secondo;
		secondo = null;
		int movieid=0;
		
       	String[]res;

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

        String nextStr;
        nextStr = filebuf.readLine();
        
        while (!nextStr.equals("MOVIES LIST")){
		nextStr = filebuf.readLine();
        }	
			
		nextStr = filebuf.readLine();
        nextStr = filebuf.readLine();
        
         					
        out.print("INSERT IGNORE INTO movies VALUES\n");
        

     	 while (nextStr!=null){
     	 
     	 	if (nextStr.equals("-----------------------------------------------------------------------------")){
        	System.out.println("Movies inseriti nel db");
        	break;
        }
        
        	
        nextStr=nextStr.replace("'","");
        	
        res=nextStr.split("\t");
        
          for (int x=1; x<res.length; x++){
         
          if (!res[x].equals("\t")){
          	secondo= res[x];
          }
        
      	 }
       	
      
       	
        primo=res[0];
        
 	  	if (primo.contains("(")){
 	  		int indice = primo.indexOf("(");
 	  		
 	  		primo = primo.substring(0,indice);
 	  	//	primo=primo.replace("\"","");
 	  	}
 	  	
 	  	/*
        System.out.println("***************");
        System.out.println(primo);
      	System.out.println(secondo);
        */
        
    		
    			    
  				
  			 		out.append("('"+movieid+"','"+primo+"','"+secondo+"',null,null,null,null,null,null,null,null,null),\n");
		 	  
   				
  				
        
        
       
       
       nextStr = filebuf.readLine();// legge una riga del file 
    	movieid++;
           }
           
    	
    	

    	
	   	
		
		     
       filebuf.close();  // chiude il file    
       out.close(); 
       
        
             

           
           	 
       }
		
		
		
	}