Application: gvSIG desktop

package org.gvsig.expressionevaluator;

import junit.framework.TestCase;

import org.gvsig.expressionevaluator.impl.expressionbuilder.formatters.DALFormatter;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.SQLBuilder;

import org.gvsig.fmap.dal.expressionevaluator.DALExpressionBuilder;

import org.gvsig.fmap.dal.expressionevaluator.DALExpressionBuilder.SelectBuilder;

import org.gvsig.fmap.dal.feature.spi.SQLBuilderBase;

import org.gvsig.tools.library.impl.DefaultLibrariesInitializer;

/**

 *

 * @author jjdelcerro

 */

public class TestExpressionBuilder extends TestCase {

    public TestExpressionBuilder(String testName) {

        super(testName);

    }

    @Override

    protected void setUp() throws Exception {

        super.setUp();

        new DefaultLibrariesInitializer().fullInitialize();

    }

    @Override

    protected void tearDown() throws Exception {

        super.tearDown();

    }

    // TODO add test methods here. The name must begin with 'test'. For example:

    // public void testHello() {}

    protected LexicalAnalyzer createLexicalAnalyzer() {

        ExpressionEvaluatorManager manager = ExpressionEvaluatorLocator.getManager();

        LexicalAnalyzer lexer = manager.createLexicalAnalyzer();

        return lexer;

    }

    protected org.gvsig.expressionevaluator.Compiler createCompiler() {

        ExpressionEvaluatorManager manager = ExpressionEvaluatorLocator.getManager();

        Compiler compiler = manager.createCompiler();

        compiler.setLexicalAnalyzer(createLexicalAnalyzer());

        return compiler;

    }

    protected SymbolTable createSymbolTable() {

        ExpressionEvaluatorManager manager = ExpressionEvaluatorLocator.getManager();

        MutableSymbolTable symbolTable = manager.createSymbolTable();

        return symbolTable;

    }

    protected Interpreter createInterpreter(SymbolTable symbolTable) {

        ExpressionEvaluatorManager manager = ExpressionEvaluatorLocator.getManager();

        Interpreter interpreter = manager.createInterpreter();

        interpreter.setSymbolTable(symbolTable);

        return interpreter;

    }

    private void link(Code code) {

      code.link(createSymbolTable());

    }

    public void testUseCase1() {

      DataManager dataManager = DALLocator.getDataManager();

      DALExpressionBuilder builder1 = dataManager.createDALExpressionBuilder();

      SQLBuilderBase builder = new SQLBuilderBase();

        SQLBuilder.SelectBuilder select = builder.select();

        select.column().name("LID_ACCIDENTE");

        select.from().table().name("ARENA2_VEHICULOS");

        select.where().value(

                builder.expression().and(

                        builder.expression().eq(

                                builder.expression().getattr("ARENA2_VEHICULOS","ID_ACCIDENTE"),

                                builder.expression().getattr("ARENA2_ACCIDENTES","LID_ACCIDENTE")

                        ),

                        builder.expression().eq(

                                builder.expression().column("MODELO"),

                                builder.expression().constant("307")

                        )

                )

        );

        select.limit(1);

        ExpressionBuilder.Value exists = builder1.exists(select, "EXISTS123");

        String filter = exists.toString(new DALFormatter());

        assertEquals("EXISTS(SELECT \"LID_ACCIDENTE\" FROM \"ARENA2_VEHICULOS\" WHERE (( (\"ARENA2_VEHICULOS\".\"ID_ACCIDENTE\") = (\"ARENA2_ACCIDENTES\".\"LID_ACCIDENTE\") ) AND ( (\"MODELO\") = ('307') )) LIMIT 1, 'EXISTS123')", filter);

        // Comprobamos que con el formatter por defecto obtenemos lo mismo.

        assertEquals(filter, exists.toString());

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(filter);

        link(code);

        assertEquals("EXISTS(SELECT(TUPLE(\"LID_ACCIDENTE\"), \"ARENA2_VEHICULOS\", ((\"ARENA2_VEHICULOS\".\"ID_ACCIDENTE\" = \"ARENA2_ACCIDENTES\".\"LID_ACCIDENTE\") AND (\"MODELO\" = '307')), TUPLE(), TUPLE(), 1), 'EXISTS123')", code.toString());

    }

    public void testForeintValue1() {

      DataManager dataManager = DALLocator.getDataManager();

      DALExpressionBuilder builder = dataManager.createDALExpressionBuilder();

      ExpressionBuilder.Function value = builder.foreing_value("SENTIDO", "DESCRIPCION");

      String s = value.toString(new DALFormatter());

      assertEquals("FOREING_VALUE('SENTIDO.DESCRIPCION')", s);

    }

}