Application: gvSIG desktop

package org.gvsig.sqlite.dal.functions;

import java.sql.Connection;

import java.sql.SQLException;

import org.sqlite.SQLiteConnection;

/**

 *

 * @author jjdelcerro

 */

public class Functions {

    public static interface Function {

        public SQLiteConnection getConnection();        

        public String getName();        

        public org.sqlite.Function getFunction();

    }

    public static abstract class AbstractFunction extends org.sqlite.Function implements Function {

        private final SQLiteConnection conn;

        private final String name;

        public AbstractFunction(String name, SQLiteConnection conn) {

            this.conn = conn;

            this.name = name;

        }

        @Override

        public SQLiteConnection getConnection() {

            return this.conn;

        }

        @Override

        public String getName() {

            return this.name;

        }

        @Override

        public org.sqlite.Function getFunction() {

            return this;

        }

    }

    public static abstract class AbstractAggregate extends org.sqlite.Function.Aggregate implements Function {

        private final SQLiteConnection conn;

        private final String name;

        public AbstractAggregate(String name, SQLiteConnection conn) {

            this.conn = conn;

            this.name = name;

        }

        @Override

        public SQLiteConnection getConnection() {

            return this.conn;

        }

        @Override

        public String getName() {

            return this.name;

        }

        @Override

        public org.sqlite.Function.Aggregate getFunction() {

            return this;

        }

    }

    public static void register_all(SQLiteConnection conn) throws SQLException {

        Function[] functions = new Function[]{

            new Json_value(conn),

            new Reverse(conn),

            new Reverseinstr(conn),

            new ST_Intersects(conn),

            new ST_AsBinary(conn),

            new ST_MaxX(conn),

            new ST_MaxY(conn),

            new ST_MinX(conn),

            new ST_MinY(conn),

            new ST_GeomFromWKB(conn),

            new ST_Extent(conn),

            new ST_ExtentAggregate(conn)

        };

        for (Function function : functions) {

            org.sqlite.Function.create(conn, function.getName(), function.getFunction());

        }

    }

}