Application: gvSIG desktop

package com.hardcode.gdbms.control;

import java.io.BufferedReader;

import java.io.ByteArrayInputStream;

import java.io.File;

import java.io.IOException;

import java.io.InputStreamReader;

import javax.xml.transform.TransformerConfigurationException;

import javax.xml.transform.TransformerFactory;

import javax.xml.transform.sax.SAXTransformerFactory;

import javax.xml.transform.sax.TransformerHandler;

import javax.xml.transform.stream.StreamResult;

import org.xml.sax.SAXException;

import com.hardcode.driverManager.Driver;

import com.hardcode.driverManager.DriverLoadException;

import com.hardcode.driverManager.DriverManager;

import com.hardcode.driverManager.DriverValidation;

import com.hardcode.gdbms.engine.data.DBDriver;

import com.hardcode.gdbms.engine.data.DataSource;

import com.hardcode.gdbms.engine.data.DataSourceFactory;

import com.hardcode.gdbms.engine.data.DriverException;

import com.hardcode.gdbms.engine.data.FileDriver;

import com.hardcode.gdbms.engine.instruction.Adapter;

import com.hardcode.gdbms.engine.instruction.SelectAdapter;

import com.hardcode.gdbms.engine.instruction.SemanticException;

import com.hardcode.gdbms.engine.instruction.UnionAdapter;

import com.hardcode.gdbms.engine.instruction.Utilities;

import com.hardcode.gdbms.gui.Frame;

import com.hardcode.gdbms.gui.GDBMSAdapterTreeModel;

import com.hardcode.gdbms.gui.GDBMSParseTreeModel;

import com.hardcode.gdbms.gui.GDBMSTableModel;

import com.hardcode.gdbms.gui.ParseTreeFrame;

import com.hardcode.gdbms.parser.Node;

import com.hardcode.gdbms.parser.ParseException;

import com.hardcode.gdbms.parser.SQLEngine;

import com.hardcode.gdbms.parser.SimpleNode;

/**

 * Aplicaci?n principal

 *

 * @author Fernando Gonz?lez Cort?s

 */

public class GDBMSMain {

    /**

     * Inicializa los subsistemas

     *

     * @throws IOException Si se produce alg?n error al inicializar los drivers

     * @throws InstantiationException Si se produce alg?n error al inicializar

     *         los drivers

     * @throws IllegalAccessException Si se produce alg?n error al inicializar

     *         los drivers

     * @throws ClassNotFoundException Si se produce alg?n error al inicializar

     *         los drivers

     * @throws DriverLoadException

     */

    private void setup()

        throws IOException, InstantiationException, IllegalAccessException, 

            ClassNotFoundException, DriverLoadException {

        //Setup de los drivers

        DriverManager dm = new DriverManager();

        dm.setValidation(new DriverValidation() {

                public boolean validate(Driver d) {

                    return (d instanceof FileDriver) || (d instanceof DBDriver);

                }

            });

        dm.loadDrivers(new File(".\\drivers\\"));

        //Setup del factory de DataSources

        DataSourceFactory.setDriverManager(dm);

    }

    /**

     * Muestra por la consola el contenido de un DataSource

     *

     * @param ds DataSource a mostrar

     *

     * @throws IOException Si hay un error leyendo del DataSource

     */

    private void mostrar(DataSource ds) throws DriverException {

        //Se muestra la tabla

        ds.start();

        ds.getRowCount();

        Frame f = new Frame();

        f.setTableModel(new GDBMSTableModel(ds));

        f.show();

/*                

        StringBuffer aux = new StringBuffer();

        int fc = ds.getFieldCount();

        int rc = ds.getRowCount();

        for (int i = 0; i < fc; i++) {

            aux.append(ds.getFieldName(i)).append("\t");

        }

        System.out.println(aux);

        try {

            for (int row = 0; row < rc; row++) {

                aux.setLength(0);

                for (int j = 0; j < fc; j++) {

                    aux.append(ds.getFieldValue(row, j)).append("\t");

                }

                //System.out.println(aux);

            }

        } catch (Throwable t) {

            t.printStackTrace();

        } finally {

            ds.close();

        }

  */  }

    /**

     * Bucle principal

     *

     * @throws SAXException

     * @throws IOException

     * @throws InstantiationException

     * @throws IllegalAccessException

     * @throws ClassNotFoundException

     * @throws DriverLoadException

     */

    private void run()

        throws DriverException, SAXException, IOException, InstantiationException, IllegalAccessException, ClassNotFoundException, DriverLoadException {

        setup();

        BufferedReader in = new BufferedReader(new InputStreamReader(System.in));

        String sql = "";

        System.out.print("> ");

        sql = in.readLine();

        while (!sql.equals("quit")) {

                long t1 = System.currentTimeMillis();

            ByteArrayInputStream bytes = new ByteArrayInputStream(sql.getBytes());

            SQLEngine parser = new SQLEngine(bytes);

            try {

                parser.SQLStatement();

            } catch (ParseException e) {

                e.printStackTrace();

            }

            Node root = parser.getRootNode();

            Adapter rootAdapter = Utilities.buildTree(root.jjtGetChild(0));

            ParseTreeFrame parseTree = new ParseTreeFrame();

            parseTree.setTreeModel(new GDBMSParseTreeModel((SimpleNode)root));

            parseTree.show();

            ParseTreeFrame parseTree2 = new ParseTreeFrame();

            parseTree2.setTreeModel(new GDBMSAdapterTreeModel(rootAdapter));

            parseTree2.show();

            Utilities.simplify(rootAdapter);

/*            ParseTreeFrame parseTree3 = new ParseTreeFrame();

            parseTree3.setTreeModel(new GDBMSAdapterTreeModel(rootAdapter));

            parseTree3.show();

*/

/*            obtenerXML(root);

                        InstructionHandler handler = new InstructionHandler();

                        SemanticParser sp = new SemanticParser();

                        sp.setContentHandler(handler);

                        sp.parse(root);

                        SelectInstruction s = handler.getInstr();

            */

            DataSource result = null;

            long t2 = System.currentTimeMillis();

            try {

                if (rootAdapter instanceof SelectAdapter) {

                    result = DataSourceFactory.createRandomDataSource((SelectAdapter) rootAdapter);

                } else if (rootAdapter instanceof UnionAdapter) {

                    result = DataSourceFactory.createRandomDataSource((UnionAdapter) rootAdapter);

                }

                if (result != null) {

                    mostrar(result);

                }

            } catch (SemanticException e1) {

                e1.printStackTrace();

            }

            long t3 = System.currentTimeMillis();

            System.out.println("Tiempo de parseado: " + ((t2 - t1)/1000.0)+" segundos");

            System.out.println("Tiempo de ejecuci?n: " + ((t3 - t2)/1000.0)+" segundos");

            System.out.println("Tiempo de parseado y ejecuci?n: " + ((t3 - t1)/1000.0)+" segundos");

            System.out.print("> ");

            sql = in.readLine();

        }

    }

    /**

     * DOCUMENT ME!

     *

     * @param root

     */

    private void obtenerXML(Node root) {

        TransformerFactory transFact = TransformerFactory.newInstance();

        if (transFact.getFeature(SAXTransformerFactory.FEATURE)) {

            SAXTransformerFactory saxTransFact = (SAXTransformerFactory) transFact;

            TransformerHandler transHand = null;

            try {

                transHand = saxTransFact.newTransformerHandler();

                transHand.setResult(new StreamResult(System.out));

                SemanticParser sp = new SemanticParser();

                sp.setContentHandler(transHand);

                sp.parse(root);

            } catch (TransformerConfigurationException e) {

                e.printStackTrace();

            } catch (SAXException e) {

                e.printStackTrace();

            }

        } else {

            System.err.println("SAXTransformerFactory is not supported.");

            System.exit(1);

        }

    }

    /**

     * Hace que el visitor sp visite el nodo actual y cada uno de sus hijos

     *

     * @param root nodo raiz que se va a visitar

     * @param sp visitante

     */

    private void parse(Node root, SemanticParser sp) {

        root.jjtAccept(sp, null);

        for (int i = 0; i < root.jjtGetNumChildren(); i++) {

            parse(root.jjtGetChild(i), sp);

        }

    }

    /**

     * metodo de entrada

     *

     * @param args Si se produce alg?n error al inicializar los drivers

     * @throws DriverException

     * @throws SAXException

     * @throws IOException

     * @throws InstantiationException

     * @throws IllegalAccessException

     * @throws ClassNotFoundException

     * @throws DriverLoadException

     */

    public static void main(String[] args)

        throws DriverException, SAXException, IOException, InstantiationException, IllegalAccessException, ClassNotFoundException, DriverLoadException {

        GDBMSMain db = new GDBMSMain();

        db.run();

    }

}