Application: gvSIG desktop

package org.gvsig.expressionevaluator.impl;

import java.util.HashMap;

import java.util.Iterator;

import java.util.Map;

import org.gvsig.expressionevaluator.Function;

import org.gvsig.expressionevaluator.impl.function.operator.AddOperator;

import org.gvsig.expressionevaluator.impl.function.operator.AndOperator;

import org.gvsig.expressionevaluator.impl.function.operator.DivOperator;

import org.gvsig.expressionevaluator.impl.function.operator.EqOperator;

import org.gvsig.expressionevaluator.impl.function.operator.GeOperator;

import org.gvsig.expressionevaluator.impl.function.operator.GtOperator;

import org.gvsig.expressionevaluator.impl.function.operator.LeOperator;

import org.gvsig.expressionevaluator.impl.function.operator.LtOperator;

import org.gvsig.expressionevaluator.impl.function.operator.ModOperator;

import org.gvsig.expressionevaluator.impl.function.operator.MulOperator;

import org.gvsig.expressionevaluator.impl.function.operator.NeOperator;

import org.gvsig.expressionevaluator.impl.function.operator.NotOperator;

import org.gvsig.expressionevaluator.impl.function.operator.OrOperator;

import org.gvsig.expressionevaluator.impl.function.operator.SubstOperator;

import org.gvsig.expressionevaluator.impl.function.predicate.IlikeOperator;

import org.gvsig.expressionevaluator.impl.function.predicate.LikeOperator;

import org.gvsig.expressionevaluator.SymbolTable;

import org.gvsig.expressionevaluator.impl.function.numeric.ACosFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.ASinFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.ATanFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.AbsFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.BitAndFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.BitOrFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.BitXorFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.CeilFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.CosFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.CoshFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.CotFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.DegreesFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.ExpFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.FloorFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.Log10Function;

import org.gvsig.expressionevaluator.impl.function.numeric.LogFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.PiFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.PowFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.RadiansFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.RandFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.RoundFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.SignFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.SinFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.SinhFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.SqrtFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.TanFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.TanhFunction;

import org.gvsig.expressionevaluator.impl.function.numeric.ZeroFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STAreaFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STAsTextFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STBufferFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STCentroidFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STContainsFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STConvexHullFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STCoveredByFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STCoversFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STCrossesFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STDifferenceFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STDimensionFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STDisjointFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STDistanceFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STEndPointFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STEnvelopeFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STGeomFromTextFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STGeometryNFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STIntersectionFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STIntersectsFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STIsSimpleFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STIsValidFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STNumGeometriesFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STNumPointsFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STOverlapsFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STPointNFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STStartPointFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STTouchesFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STUnionFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STWithinFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STXFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STYFunction;

import org.gvsig.expressionevaluator.impl.function.spatial.STZFunction;

import org.gvsig.expressionevaluator.impl.function.string.AsciiFunction;

import org.gvsig.expressionevaluator.impl.function.string.CharFunction;

import org.gvsig.expressionevaluator.impl.function.string.ConcatFunction;

import org.gvsig.expressionevaluator.impl.function.string.InstrFunction;

import org.gvsig.expressionevaluator.impl.function.string.LTrimFunction;

import org.gvsig.expressionevaluator.impl.function.string.LeftFunction;

import org.gvsig.expressionevaluator.impl.function.string.LengthFunction;

import org.gvsig.expressionevaluator.impl.function.string.LocateFunction;

import org.gvsig.expressionevaluator.impl.function.string.LowerFunction;

import org.gvsig.expressionevaluator.impl.function.string.LpadFunction;

import org.gvsig.expressionevaluator.impl.function.string.PositionFunction;

import org.gvsig.expressionevaluator.impl.function.string.RTrimFunction;

import org.gvsig.expressionevaluator.impl.function.string.RepeatFunction;

import org.gvsig.expressionevaluator.impl.function.string.ReplaceFunction;

import org.gvsig.expressionevaluator.impl.function.string.RightFunction;

import org.gvsig.expressionevaluator.impl.function.string.RpadFunction;

import org.gvsig.expressionevaluator.impl.function.string.SpaceFunction;

import org.gvsig.expressionevaluator.impl.function.string.SubstringFunction;

import org.gvsig.expressionevaluator.impl.function.string.TrimFunction;

import org.gvsig.expressionevaluator.impl.function.string.UpperFunction;

public class SQLSymbolTable implements SymbolTable {

    private final Map<String,Function> functions;

    private static SQLSymbolTable instance = null;

    public static SQLSymbolTable getInstance() {

        if( instance == null ) {

            instance = new SQLSymbolTable();

        }

        return instance;

    }

    private SQLSymbolTable() {

        this.functions = new HashMap<>();

        addFunction(new AndOperator());

        addFunction(new AddOperator());

        addFunction(new DivOperator());

        addFunction(new EqOperator());

        addFunction(new GeOperator());

        addFunction(new GtOperator());

        addFunction(new LeOperator());

        addFunction(new LtOperator());

        addFunction(new ModOperator());

        addFunction(new NeOperator());

        addFunction(new ModOperator());

        addFunction(new MulOperator());

        addFunction(new NeOperator());

        addFunction(new NotOperator());

        addFunction(new OrOperator());

        addFunction(new SubstOperator());

        addFunction(new IlikeOperator());

        addFunction(new LikeOperator());

        addFunction(new ACosFunction());

        addFunction(new ASinFunction());

        addFunction(new ATanFunction());

        addFunction(new AbsFunction());

        addFunction(new BitAndFunction());

        addFunction(new BitOrFunction());

        addFunction(new BitXorFunction());

        addFunction(new CeilFunction());

        addFunction(new CosFunction());

        addFunction(new CoshFunction());

        addFunction(new CotFunction());

        addFunction(new DegreesFunction());

        addFunction(new ExpFunction());

        addFunction(new FloorFunction());

        addFunction(new Log10Function());

        addFunction(new LogFunction());

        addFunction(new PiFunction());

        addFunction(new PowFunction());

        addFunction(new RadiansFunction());

        addFunction(new RandFunction());

        addFunction(new RoundFunction());

        addFunction(new SignFunction());

        addFunction(new SinFunction());

        addFunction(new SinhFunction());

        addFunction(new SqrtFunction());

        addFunction(new TanFunction());

        addFunction(new TanhFunction());

        addFunction(new ZeroFunction());

        addFunction(new LogFunction());

        addFunction(new AsciiFunction());

        addFunction(new CharFunction());

        addFunction(new ConcatFunction());

        addFunction(new InstrFunction());

        addFunction(new LTrimFunction());

        addFunction(new LeftFunction());

        addFunction(new LengthFunction());

        addFunction(new LocateFunction());

        addFunction(new LowerFunction());

        addFunction(new LpadFunction());

        addFunction(new PositionFunction());

        addFunction(new RTrimFunction());

        addFunction(new RepeatFunction());

        addFunction(new ReplaceFunction());

        addFunction(new RightFunction());

        addFunction(new RpadFunction());

        addFunction(new SpaceFunction());

        addFunction(new SubstringFunction());

        addFunction(new TrimFunction());

        addFunction(new UpperFunction());

        addFunction(new STAreaFunction());

        addFunction(new STAsTextFunction());

        addFunction(new STBufferFunction());

        addFunction(new STCentroidFunction());

        addFunction(new STContainsFunction());

        addFunction(new STConvexHullFunction());

        addFunction(new STCoveredByFunction());

        addFunction(new STCoversFunction());

        addFunction(new STCrossesFunction());

        addFunction(new STDifferenceFunction());

        addFunction(new STDimensionFunction());

        addFunction(new STDisjointFunction());

        addFunction(new STDistanceFunction());

        addFunction(new STEndPointFunction());

        addFunction(new STEnvelopeFunction());

        addFunction(new STGeomFromTextFunction());

        addFunction(new STGeometryNFunction());

        addFunction(new STIntersectionFunction());

        addFunction(new STIntersectsFunction());

        addFunction(new STIsSimpleFunction());

        addFunction(new STIsValidFunction());

        addFunction(new STNumGeometriesFunction());

        addFunction(new STNumPointsFunction());

        addFunction(new STOverlapsFunction());

        addFunction(new STPointNFunction());

        addFunction(new STStartPointFunction());

        addFunction(new STTouchesFunction());

        addFunction(new STUnionFunction());

        addFunction(new STWithinFunction());

        addFunction(new STXFunction());

        addFunction(new STYFunction());

        addFunction(new STZFunction());

    }

    @Override

    @SuppressWarnings("CloneDoesntCallSuperClone")

    public SymbolTable clone() throws CloneNotSupportedException {

        // SQLSymbolTable is singleton and immutable, so we just return 

        // the same instance.

        return this;

    }

    private void addFunction(Function function) {

        this.functions.put(function.name().toLowerCase(), function);

    }

    @Override

    public Function function(String name) {

        return this.functions.get(name.toLowerCase());

    }

    @Override

    public boolean exists(String name) {

        return false;

    }

    @Override

    public Object value(String name) {

        return null;

    }

    @Override

    public Iterator<String> itervars() {

        return new Iterator<String>() {

            @Override

            public boolean hasNext() {

                return false;

            }

            @Override

            public String next() {

                return null;

            }

        };

    }

    @Override

    public Iterator<Function> iterfuncs() {

        return this.functions.values().iterator();

    }

    @Override

    public Iterator<Function> iterator() {

        return iterfuncs();

    }

}