gvSIG projects pool

package org.gvsig.vcsgis.lib.workspace.tables;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.feature.EditableFeature;

import org.gvsig.fmap.dal.feature.EditableFeatureType;

import org.gvsig.fmap.dal.feature.Feature;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.tools.dataTypes.DataTypes;

import org.gvsig.tools.dispose.DisposeUtils;

import static org.gvsig.vcsgis.lib.VCSGisManager.VCSGISCODELEN;

import org.gvsig.vcsgis.lib.workspace.VCSGisWorkspace;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class VarsTable extends AbstractTable {

    public static final String TABLE_NAME = "VCSGIS_CONFIG";

    private static final String COD_CONFIG = "COD_CONFIG";

    private static final String VAR_NAME = "CFG_NAME";

    private static final String VAR_VALUE = "CFG_VALUE";

    public static class VarRow extends AbstractRow {

        public VarRow(VCSGisWorkspace workspace) {

            super(workspace, TABLE_NAME, VAR_NAME);

        }

        public VarRow(VCSGisWorkspace workspace, Feature feature) {

            super(workspace, TABLE_NAME, VAR_NAME, feature);

        }

        public String getName() {

            return this.getString(VAR_NAME);

        }

        public String getValue() {

            return this.getString(VAR_VALUE);

        }

        public void setName(String name) {

            this.set(VAR_NAME, name);

        }

        public void setValue(String value) {

            this.set(VAR_VALUE, value);

        }

    }

    public VarsTable() {

        super(TABLE_NAME, featureType());

    }

    public String get(VCSGisWorkspace workspace, String name) {

        FeatureStore store = null;

        try {

            store = workspace.getFeatureStore(TABLE_NAME);

            Feature f = store.findFirst("\""+VAR_NAME+"\"='" + name + "'");

            if (f == null) {

                return null;

            }

            return f.getString(VAR_VALUE);

        } catch (Exception ex) {

            return null;

        } finally {

            DisposeUtils.disposeQuietly(store);

        }

    }

    public void set(VCSGisWorkspace workspace, String name, String value) {

        FeatureStore store = null;

        try {

            store = workspace.getFeatureStore(TABLE_NAME);

            Feature f = store.findFirst("\""+VAR_NAME+"\"='" + name + "'");

            if (f == null) {

                store.edit(FeatureStore.MODE_APPEND);

                EditableFeature ef = store.createNewFeature();

                ef.set(VAR_NAME, name);

                ef.set(VAR_VALUE, value);

                store.insert(ef);

                store.finishEditing();

            } else {

                EditableFeature ef = f.getEditable();

                ef.set(VAR_VALUE, value);

                store.edit();

                store.update(ef);

                store.finishEditing();

            }

        } catch (Exception ex) {

            LOGGER.warn("Can't store value for '" + name + "'.", ex);

        } finally {

            if( store!=null && (store.isAppending() || store.isEditing()) ) {

                store.cancelEditingQuietly();

            }

            DisposeUtils.disposeQuietly(store);

        }

    }

    public void delete(VCSGisWorkspace workspace, String name) {

        FeatureStore store = null;

        try {

            store = workspace.getFeatureStore(TABLE_NAME);

            store.edit(FeatureStore.MODE_FULLEDIT);

            store.delete("\""+VAR_NAME+"\"='" + name + "'");

            store.finishEditing();

        } catch (Exception ex) {

            LOGGER.warn("Can't delete value for '" + name + "'.", ex);

        } finally {

            if( store!=null && (store.isAppending() || store.isEditing()) ) {

                store.cancelEditingQuietly();

            }

            DisposeUtils.disposeQuietly(store);

        }

    }

    public static final FeatureType featureType() {

        DataManager dataManager = DALLocator.getDataManager();

        EditableFeatureType ft = dataManager.createFeatureType();

        ft.setLabel("VCSGIS Config");

        ft.getTags().set("ID", TABLE_NAME);

        ft.add(COD_CONFIG, DataTypes.STRING)

                .setSize(VCSGISCODELEN)

                .setIsPrimaryKey(true)

                .setLabel("Code")

                .setReadOnly(false)

                .setDefaultFieldValue("<%=replace(UUID(),'-','')%>")

                .setHidden(true);

        ft.add(VAR_NAME, DataTypes.STRING)

                .setSize(100)

                .setIsIndexed(true)

                .setAllowIndexDuplicateds(false)

                .setLabel("Name");

        ft.add(VAR_VALUE, DataTypes.STRING)

                .setSize(10240)

                .setLabel("Value");

        return ft.getNotEditableCopy();

    }

}