Application: gvSIG desktop

package org.gvsig.expresionevaluator.impl;

import org.gvsig.expressionevaluator.impl.SQLLexicalAnalyzer;

import org.gvsig.expressionevaluator.impl.DefaultCompiler;

import junit.framework.TestCase;

import org.gvsig.expressionevaluator.LexicalAnalyzer;

import org.gvsig.expressionevaluator.Compiler;

import org.gvsig.expressionevaluator.Code;

public class TestCompiler extends TestCase {

    public TestCompiler(String testName) {

        super(testName);

    }

    @Override

    protected void setUp() throws Exception {

        super.setUp();

    }

    @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() {

        SQLLexicalAnalyzer lexer = new SQLLexicalAnalyzer();

        return lexer;

    }

    protected Compiler createCompiler() {

        Compiler compiler = new DefaultCompiler();

        compiler.setLexicalAnalyzer(createLexicalAnalyzer());

        return compiler;

    }

    public void testIdentifier1() {

        String source = "precio";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("[precio]", code.toString());

    }

    public void testIdentifier2() {

        String source = "[precio]";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("[precio]", code.toString());

    }

    public void testIdentifier3() {

        String source = "\"precio\"";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("[precio]", code.toString());

    }

    public void testTrue() {

        String source = "true";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("true", code.toString());

    }

    public void testFalse() {

        String source = "false";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("false", code.toString());

    }

    public void testNull() {

        String source = "null";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("null", code.toString());

    }

    public void testNotTrue() {

        String source = "not true";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("not(true)", code.toString());

    }

    public void testInteger() {

        String source = "23";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("23", code.toString());

    }

    public void operator(String operatorName) {

        String source = "precio " + operatorName + " 23";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals(operatorName+"([precio], 23)", code.toString());

    }

    public void testOperators() {

        operator("=");

        operator("<>");

        operator(">");

        operator(">=");

        operator("<");

        operator("<=");

        operator("like");

        operator("ilike");

        operator("+");

        operator("-");

        operator("*");

//        operator("^");

        operator("or");

        operator("and");

        operator("%");

        operator("is");

    }

    public void testAddMul() {

        String source = "precio + 10 * 2 + 20 + 30";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("+(+(+([precio], *(10, 2)), 20), 30)", code.toString());

    }

    public void testAddMulPar() {

        String source = "(precio + 10) * 2 + 20 + 30";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("+(+(*(+([precio], 10), 2), 20), 30)", code.toString());

    }

    public void testAbs() {

        String source = "precio + abs(10)";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("+([precio], abs(10))", code.toString());

    }

    public void testAbs2() {

        String source = "precio + abs(-10)";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("+([precio], abs(-10))", code.toString());

    }

    public void testPI() {

        String source = "precio + PI()";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("+([precio], PI())", code.toString());

    }

    public void testCeil() {

        String source = "precio + CEIL(PI())";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("+([precio], CEIL(PI()))", code.toString());

    }

    public void testConcat() {

        String source = "CONCAT(precio,' euros')";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("CONCAT([precio], ' euros')", code.toString());

    }

    public void test1() {

        String source = "NOMBRE03 = 'Torre d''En Besora (la)'";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("=([NOMBRE03], 'Torre d'En Besora (la)')", code.toString());

    }

    public void test2() {

        String source = "[1990] = 0.168873933773767";

        Compiler compiler = createCompiler();

        Code code = compiler.compileExpression(source);

        assertEquals("=([1990], 0.168873933773767)", code.toString());

    }

}