/**
 * Copyright 2005-2013 The Kuali Foundation
 *
 * Licensed under the Educational Community License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.opensource.org/licenses/ecl2.php
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
import java.sql.Connection

/**
 * DbCommand that emits SQL that will append the primary key to NM col of any KRIM_RSP_T
 * records with duplicate (NMSPC_CD,NM) fields
 */
class ResponsibilityNamespaceNameUniquifierCommand extends RecordUniquifier {
    def ResponsibilityNamespaceNameUniquifierCommand() {
        super("KRIM_RSP_T", "RSP_ID", {
          self, row ->
            [ NM: row['NM'] + " " + row[self.pk_col] ]
        }, ["NMSPC_CD", "NM"])
    }
}