EDIT

/**

* Copyright (C) 2016 EDIT

* European Distributed Institute of Taxonomy

* http://www.e-taxonomy.eu

*

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

import java.sql.ResultSet;

import java.sql.SQLException;

import eu.etaxonomy.cdm.common.CdmUtils;

import eu.etaxonomy.cdm.common.monitor.IProgressMonitor;

import eu.etaxonomy.cdm.database.ICdmDataSource;

import eu.etaxonomy.cdm.database.update.CaseType;

import eu.etaxonomy.cdm.strategy.cache.agent.PersonDefaultCacheStrategy;

/**

 * Updates the field Person.initials from Person.firstname.

 * @author a.mueller

 */

    /**

     * @return

     */

        return new InitialsUpdater(stepList);

    private static final String stepName = "Make Person initials from firstname";

    /**

     * @param stepName

     */

        super(stepList, stepName);

    @Override

            CaseType caseType, SchemaUpdateResult result) throws SQLException {

        try {

            PersonDefaultCacheStrategy formatter = PersonDefaultCacheStrategy.NewInstance();

            String sqlCopyFirstname = "UPDATE AgentBase SET initials = firstname WHERE DTYPE='Person'"

            ResultSet rs = datasource.executeQuery(sqlSelectInitials);

            while (rs.next()){

        } catch (Exception e) {

            String message = e.getMessage();

            monitor.warning(message, e);

            result.addException(e, message, this, "invoke");

        }

    }

     * @param datasource

     * @param formatter

     * @param sqlRemoveFirstname

     * @param rs

     * @param monitor

     * @throws SQLException

     */

        try {

            String firstname = rs.getString("firstname");

            String initialsForced = formatter.getInitialsFromGivenName(firstname, true);

            String firstnameSql;

            String initialsSql;

            if (CdmUtils.equalsIgnoreWS(firstname, initialsForced)){

                //firstname was initials

                firstnameSql = " null ";

                initialsSql = initialsForced;

            }else if (CdmUtils.equalsIgnoreWS(firstname, initialsAllow)){

                initialsSql = initialsAllow;

            }else {

                initialsSql = initialsForced;

            }

                initialsSql = initialsSql.replace("'", "\\'");

            }

            if (StringUtils.isBlank(firstname)){

                firstnameSql = " null ";

                initialsSql = " null ";

            }else {

                initialsSql = "'" + initialsSql + "'";

            }

            String sql = String.format(sqlRemoveFirstname, firstnameSql, initialsSql, id);

            //remove old relationship

            datasource.executeUpdate(sql);

            String message = e.getMessage();

            monitor.warning(message, e);

    }

}