gvSIG projects pool

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

import org.gvsig.vcsgis.lib.repository.localdb.tables.*;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

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 org.gvsig.vcsgis.lib.workspace.VCSGisWorkspace;

/**

 *

 * @author gvSIG Team

 */

@SuppressWarnings("UseSpecificCatch")

public class TopologyplanTable extends AbstractRepoTable {

    public static final String TABLE_NAME = "VCSGIS_TOPOLOGYPLANS";

    private static final String COD_TOPOLOGYPLAN = "COD_TOPOLOGYPLAN";

    private static final String TOPPLAN_NAME = "TOPP_NAME";

    private static final String TOPPLAN_DESCRIPTION = "TOPP_DESCRIPTION";

    private static final String TOPPLAN_DATA = "TOPP_DATA";

    public static final FeatureType featureType() {

        DataManager dataManager = DALLocator.getDataManager();

        EditableFeatureType ft = dataManager.createFeatureType();

        ft.setLabel("VCSGIS TopologyPlans");

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

        ft.add(COD_TOPOLOGYPLAN, DataTypes.STRING)

                .setSize(40)

                .setIsPrimaryKey(true)

                .setLabel("Code")

                .setReadOnly(true);

        ft.add(TOPPLAN_NAME, DataTypes.STRING)

                .setIsIndexed(true)

                .setAllowIndexDuplicateds(true)

                .setSize(50)

                .setLabel("Name");

        ft.add(TOPPLAN_DESCRIPTION, DataTypes.STRING)

                .setSize(10240)

                .setLabel("Description");        

        ft.add(TOPPLAN_DATA, DataTypes.STRING)

                .setSize(10240)

                .setLabel("Serialized topology plan in json.");

        return ft.getNotEditableCopy();

    }

    public TopologyplanTable() {

        super(TABLE_NAME, featureType());

    }

    public String getByCode(VCSGisWorkspace workspace, String topologyPlanCode) {

        FeatureStore store = null;

        try {

            store = workspace.getFeatureStore(TABLE_NAME);

            Feature f = store.findFirst("\""+COD_TOPOLOGYPLAN+"\"='"+topologyPlanCode+"'");

            if( f==null ) {

                return null;

            }

            return f.getString(TOPPLAN_DATA);

        } catch (Exception ex) {

            throw new RuntimeException("Can't retrieve topology plan '"+topologyPlanCode+"'.", ex);

        } finally {

            DisposeUtils.disposeQuietly(store);

        }

    }

}