| gvSIG desktop 1

package org.gvsig.remoteservices.conf.mapserver.test;

import java.io.DataInputStream;

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileWriter;

import java.io.IOException;

import java.util.Vector;

public class DDF2postgres{

        public static void main(String[] args){

                String path="/home/david/pruebas";

                String squema="";

                File f=new File(path);

                File sql=null;

                DataInputStream read = null;

                FileWriter write = null;

                File aux[]=f.listFiles();

                int i;

                sql=new File(path+"/sql");

                sql.deleteOnExit();

                sql.mkdir();

                for(i=0;i<aux.length;i++){

                        Vector data=new Vector();

                        String s3=null;

                        int contd=0;

                        int contf=0;

                        sql=new File(path+"/"+"sql/"+aux[i].getName().split(".ddf")[0]+".sql");

                        String table=sql.getName().split(".sql")[0];

                        System.out.println(table);

                        System.out.println(sql.getName());

                        try{

                                read = new DataInputStream(new FileInputStream(aux[i]));

                                write = new FileWriter(sql);

                                String s=read.readLine();

                                String s2[]=null;

                                if(args[0]==null){

                                        s3="INSERT INTO "+table.toLowerCase()+"(";

                                }

                                else{

                                        s3="INSERT INTO "+args[0]+"."+table.toLowerCase()+"(";

                                }

                                String s4="";

                                String s5=null;

                                while(s.compareTo("[FIELDS]")!=0){

                                        s=read.readLine();

                                }

                                s=read.readLine();

                                while(s.compareTo("")!=0){

                                        s2=s.split(",");

                                        contd++;

                                        data.addElement(s2[0]);

                                        System.out.println(s2[0]);

                                        s=read.readLine();

                                }

                                s4=s3;

                                int j;

                                for(j=0;j<data.size()-1;j++){

                                        s4=s4+data.elementAt(j)+",";

                                }

                                s4=s4+data.elementAt(data.size()-1)+") VALUES(";

                                while(s.compareTo("[DATA]")!=0){

                                        s=read.readLine();

                                }

                                s=read.readLine();

                                s5=s4;

                                while(s!=null){

                                        s2=s.split("\t");

                                        contf=s2.length;

                                        int k;

                                        write.write(s5);

                                        for(k=0;k<s2.length-1;k++){

                                                if(s2[k].compareTo("")==0){

                                                        write.write("null,");

                                                        System.out.print(s2[k]);

                                                }

                                                else{

                                                        write.write("\'"+s2[k]+"\',");

                                                        System.out.print(s2[k]);

                                                }

                                        }

                                        write.write("\'"+s2[s2.length-1]+"\'");

                                        if(contd-contf>0){

                                                int l;

                                                write.write(",");

                                                for(l=0;l<(contd-contf)-1;l++){

                                                        write.write("null,");

                                                }

                                                write.write("null");

                                        }

                                        write.write(");\n");

                                        System.out.println();

                                        s=read.readLine();

                                        if(s!=null){

                                                if(s.compareTo("")==0){

                                                        s=read.readLine();

                                                }

                                        }

                                }

                                write.close();

                        }

                        catch(FileNotFoundException e1){

                                System.out.println("File not found.");

                        }

                        catch(IOException e){

                                System.out.println("I/O error.");

                        }

                }

        }

}