Application: gvSIG desktop

import static org.gvsig.fmap.dal.DataManager.FUNCTION_SELECT_COUNT_FROM_SELECTION;

import static org.gvsig.fmap.dal.DataManager.FUNCTION_SELECT_FROM_SELECTION;

            theGrammar.addStatement(createSelectCountFromSelectionStatement(theGrammar));

            theGrammar.addStatement(createSelectFromSelectionStatement(theGrammar));

    private Statement createSelectFromSelectionStatement(Grammar theGrammar) {

        Statement stmt;

//

//      SELECT * | (column1, column2,...) 

//          FROM SELECTION OF table_name

//          WHERE expression

//        

        ExpressionEvaluatorManager manager = ExpressionEvaluatorLocator.getManager();

        CodeBuilder codeBuilder = manager.createCodeBuilder();

        stmt = theGrammar.createStatement("SELECTFROMSELECTION");

        stmt.addRule(stmt.require_any_token("SELECT"));

        stmt.addRule(stmt.optional_any_token("*")

                .addRuleOnTrue(stmt.set_expression("COLUMNS", codeBuilder.tuple()))

                .addRuleOnFalse(stmt.require_identifiers(",").capture_as("COLUMNS"))

        );

        stmt.addRule(stmt.require_any_token("FROM"));

        stmt.addRule(stmt.require_any_token("SELECTION"));

        stmt.addRule(stmt.optional_any_token("IF")

                .addRuleOnTrue(stmt.require_tokens("NOT", "EMPTY").capture_as("IF_NOT_EMPTY"))

        );

        stmt.addRule(stmt.optional_any_token("OF"));

        stmt.addRule(stmt.require_expression().capture_as("TABLE"));

        stmt.addRule(stmt.optional_any_token("WHERE")

                .addRuleOnTrue(stmt.require_expression().capture_as("WHERE"))

        );

        stmt.addRule(stmt.optional_any_token("LIMIT")

                .addRuleOnTrue(stmt.require_expression().capture_as("LIMIT"))

        );

        stmt.addRule(stmt.optional_any_token(";"));

        stmt.code(

                FUNCTION_SELECT_FROM_SELECTION,

                stmt.args_names("COLUMNS", "TABLE", "WHERE", "LIMIT","IF_NOT_EMPTY")

        );

        return stmt;

    }

    private Statement createSelectCountFromSelectionStatement(Grammar theGrammar) {

        Statement stmt;

//

//      SELECT COUNT(*) FROM SELECTION IF NOT IS EMPTY OF table_name WHERE expression

//        

        stmt = theGrammar.createStatement("SELECT_COUNT_FROM_SELECTION");

        stmt.addRule(stmt.require_any_token("SELECT"));

        stmt.addRule(stmt.require_any_token("COUNT"));

        stmt.addRule(stmt.require_any_token("("));

        stmt.addRule(stmt.require_any_token("*"));

        stmt.addRule(stmt.require_any_token(")"));

        stmt.addRule(stmt.require_any_token("FROM"));

        stmt.addRule(stmt.require_any_token("SELECTION"));

        stmt.addRule(stmt.optional_any_token("IF")

                .addRuleOnTrue(stmt.require_tokens("NOT", "EMPTY").capture_as("IF_NOT_EMPTY"))

        );

        stmt.addRule(stmt.require_any_token("OF"));

        stmt.addRule(stmt.require_expression().capture_as("TABLE"));

        stmt.addRule(stmt.optional_any_token("WHERE")

                .addRuleOnTrue(stmt.require_expression().capture_as("WHERE"))

        );

        stmt.addRule(stmt.require_any_token(";"));

        stmt.code(

                FUNCTION_SELECT_COUNT_FROM_SELECTION,

                stmt.args_names("TABLE", "WHERE", "IF_NOT_EMPTY")

        );

        return stmt;

    }