DropUniqueConstraintWizardPanel1.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package com.wcs.netbeans.liquiface.ui.wizards.dropunique;

/*
 * #%L
 * Liquiface - GUI for Liquibase
 * %%
 * Copyright (C) 2013 Webstar Csoport Kft.
 * %%
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as
 * published by the Free Software Foundation, either version 3 of the 
 * License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public 
 * License along with this program.  If not, see
 * <http://www.gnu.org/licenses/gpl-3.0.html>.
 * #L%
 */

import com.wcs.netbeans.liquiface.facade.ModelFacade;
import com.wcs.netbeans.liquiface.model.ForeignKeyConstraint;
import com.wcs.netbeans.liquiface.model.Table;
import com.wcs.netbeans.liquiface.model.UniqueConstraint;
import com.wcs.netbeans.liquiface.ui.wizards.AbstractWizardPanel;
import java.util.List;
import org.openide.WizardDescriptor;
import org.openide.WizardValidationException;

public class DropUniqueConstraintWizardPanel1 extends AbstractWizardPanel{

    /**
     * The visual component that displays this panel. If you need to access the component from this class, just use
     * getComponent().
     */
    private DropUniqueConstraintVisualPanel1 component;
    private String tableName;

    public DropUniqueConstraintWizardPanel1(String tableName) {
        this.tableName = tableName;
    }

    // Get the visual component for the panel. In this template, the component
    // is kept separate. This can be more efficient: if the wizard is created
    // but never displayed, or not all panels are displayed, it is better to
    // create only those which really need to be visible.
    @Override
    public DropUniqueConstraintVisualPanel1 getComponent() {
        if (component == null) {
            component = new DropUniqueConstraintVisualPanel1(tableName);
        }
        return component;
    }

    @Override
    public void storeSettings(WizardDescriptor wiz) {
        wiz.putProperty(DropUniqueConstraintWizardConstants.CONSTRAINT_NAME, getComponent().getSelectedUcField().getSelectedItem());
    }

    @Override
    public void validate() throws WizardValidationException {
        String ucName = (String) component.getSelectedUcField().getSelectedItem();
        if (ucName.equals("")){
            throw new WizardValidationException(null, "The name is required!", null);
        }
        Table table = ModelFacade.getInstance().getTableByName(tableName);
        UniqueConstraint uc = table.getUniqueConstraintByName(ucName);
        List<ForeignKeyConstraint> foreignKeyList = ModelFacade.getInstance().getReferencingForeignKeys(tableName, uc.getColumns());
        if (!foreignKeyList.isEmpty()) {
            String errorMsg = "The constraint can't be dropped, because the following foreign key constraints reference it:\n";
            for (ForeignKeyConstraint fk : foreignKeyList) {
                errorMsg += "- " + fk.getName() + " (by " + fk.getBaseTable().getName() + " table)\n";
            }
            throw new WizardValidationException(null, errorMsg, null);
        }
    }
}