Application: gvSIG desktop

package org.gvsig.sqlite.dal;

import java.io.File;

import java.util.Properties;

import org.apache.commons.io.FilenameUtils;

import org.apache.commons.lang3.BooleanUtils;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.fmap.dal.DataParameters;

import org.gvsig.fmap.dal.exception.ValidateDataParametersException;

import org.gvsig.fmap.dal.resource.db.DBParameters;

import org.gvsig.fmap.dal.store.jdbc.JDBCConnectionParameters;

public class SQLiteConnectionParametersHelper {

    private final JDBCConnectionParameters parameters;

    private static final String ENABLE_SHARED_CACHE = "enable_shared_cache";

    private static final String ENABLE_LOAD_EXTENSION = "enable_load_extension";

    private static final String DATABASE_FILE = "database_file";

    public SQLiteConnectionParametersHelper(JDBCConnectionParameters parameters) {

        this.parameters = parameters;

    }

    public String getUrl() {

        String url = (String) this.getDynValue(JDBCConnectionParameters.URL_PARAMTER_NAME);

        if( StringUtils.isBlank(url) ) {

            url = SQLiteUtils.getConnectionURL((SQLiteConnectionParameters) this.parameters);

            this.setDynValue(JDBCConnectionParameters.URL_PARAMTER_NAME,url);

        }

        return url;

    }

    public void validate() throws ValidateDataParametersException {

        if (this.getDynValue(JDBCConnectionParameters.JDBC_DRIVER_CLASS_PARAMTER_NAME) == null) {

            this.setDynValue(JDBCConnectionParameters.JDBC_DRIVER_CLASS_PARAMTER_NAME,

                    SQLiteUtils.SQLITE_JDBC_DRIVER

            );

        }

        if (getFile() == null) {

            throw new ValidateDataParametersException();

        }

    }

    private Object getDynValue(String name) {

        return ((DataParameters)this.parameters).getDynValue(name);

    }

    private void setDynValue(String name, Object value) {

        ((DataParameters)this.parameters).setDynValue(name,value);

    }

    public boolean getEnableLoadExtension() {

        return (boolean) this.getDynValue(ENABLE_LOAD_EXTENSION);

    }

    public boolean getEnableSharedCache() {

        return (boolean) this.getDynValue(ENABLE_SHARED_CACHE);

    }

    public void setEnableLoadExtension(boolean v) {

        this.setDynValue(ENABLE_LOAD_EXTENSION, v);

    }

    public void setEnableSharedCache(boolean v) {

        this.setDynValue(ENABLE_SHARED_CACHE, v);

    }

    public File getFile() {

        File f = (File) this.getDynValue(DATABASE_FILE);

        if( this.getDynValue(DBParameters.DBNAME_PARAMTER_NAME)==null &&

            f != null ) {

            String dbname = FilenameUtils.getBaseName(f.getName());

            this.setDynValue(DBParameters.DBNAME_PARAMTER_NAME, dbname);

        }

        return f;

    }

    public void setFile(File database) {

        this.setDynValue(DATABASE_FILE, database);

        if( this.getDynValue(DBParameters.DBNAME_PARAMTER_NAME)==null &&

            database != null ) {

            String dbname = FilenameUtils.getBaseName(database.getName());

            this.setDynValue(DBParameters.DBNAME_PARAMTER_NAME, dbname);

        }

    }

    public Properties getProperties() {

        Properties props = new Properties();

        props.setProperty("enable_shared_cache", BooleanUtils.toStringTrueFalse(getEnableSharedCache()));

        props.setProperty("enable_load_extension", BooleanUtils.toStringTrueFalse(getEnableLoadExtension()));

        return props;

    }    

}