org.apereo.portal.i18n.RDBMLocaleStore.java Source code

Introduction

Here is the source code for org.apereo.portal.i18n.RDBMLocaleStore.java

Source

/**
 * Licensed to Apereo under one or more contributor license
 * agreements. See the NOTICE file distributed with this work
 * for additional information regarding copyright ownership.
 * Apereo licenses this file to you under the Apache 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 the following location:
 *
 *   http://www.apache.org/licenses/LICENSE-2.0
 *
 * 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.
 */
package org.apereo.portal.i18n;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Locale;

import javax.annotation.Resource;
import javax.sql.DataSource;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apereo.portal.jpa.BasePortalJpaDao;
import org.apereo.portal.security.IPerson;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.ConnectionCallback;
import org.springframework.jdbc.core.JdbcOperations;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.TransactionCallback;
import org.springframework.transaction.support.TransactionOperations;
import org.springframework.transaction.support.TransactionTemplate;

/**
 * Database implementation of locale storage interface.
 * @author Ken Weiner, kweiner@unicon.net
 * @version $Revision$
 */
@Repository("localeStore")
public class RDBMLocaleStore implements ILocaleStore {

    protected final Log logger = LogFactory.getLog(this.getClass());

    protected TransactionOperations transactionOperations;
    protected JdbcOperations jdbcOperations;

    @Autowired
    public void setPlatformTransactionManager(
            @Qualifier(BasePortalJpaDao.PERSISTENCE_UNIT_NAME) PlatformTransactionManager platformTransactionManager) {
        this.transactionOperations = new TransactionTemplate(platformTransactionManager);
    }

    @Resource(name = BasePortalJpaDao.PERSISTENCE_UNIT_NAME)
    public void setDataSource(DataSource dataSource) {
        this.jdbcOperations = new JdbcTemplate(dataSource);
    }

    @Override
    public Locale[] getUserLocales(final IPerson person) {
        return jdbcOperations.execute(new ConnectionCallback<Locale[]>() {
            @Override
            public Locale[] doInConnection(Connection con) throws SQLException, DataAccessException {

                final List<Locale> localeList = new ArrayList<Locale>();
                final String query = "SELECT * FROM UP_USER_LOCALE WHERE USER_ID=? ORDER BY PRIORITY";
                final PreparedStatement pstmt = con.prepareStatement(query);
                try {
                    pstmt.clearParameters();
                    pstmt.setInt(1, person.getID());
                    logger.debug(query);
                    final ResultSet rs = pstmt.executeQuery();
                    try {
                        while (rs.next()) {
                            final String localeString = rs.getString("LOCALE");
                            final Locale locale = LocaleManager.parseLocale(localeString);
                            localeList.add(locale);
                        }
                    } finally {
                        rs.close();
                    }
                } finally {
                    pstmt.close();
                }

                return localeList.toArray(new Locale[localeList.size()]);

            }
        });
    }

    @Override
    public void updateUserLocales(final IPerson person, final Locale[] locales) {
        this.transactionOperations.execute(new TransactionCallback<Object>() {
            @Override
            public Object doInTransaction(TransactionStatus status) {
                return jdbcOperations.execute(new ConnectionCallback<Object>() {
                    @Override
                    public Object doInConnection(Connection con) throws SQLException, DataAccessException {

                        // Delete the existing list of locales
                        final String delete = "DELETE FROM UP_USER_LOCALE WHERE USER_ID=?";
                        PreparedStatement pstmt = con.prepareStatement(delete);
                        try {
                            pstmt.clearParameters();
                            pstmt.setInt(1, person.getID());
                            logger.debug(delete);
                            pstmt.executeUpdate();

                        } finally {
                            pstmt.close();
                        }
                        // Insert the new list of locales
                        final String insert = "INSERT INTO UP_USER_LOCALE VALUES (?, ?, ?)";
                        pstmt = con.prepareStatement(insert);
                        try {
                            for (int i = 0; i < locales.length; i++) {
                                pstmt.clearParameters();
                                pstmt.setInt(1, person.getID());
                                pstmt.setString(2, locales[i].toString());
                                pstmt.setInt(3, i);
                                logger.debug(insert);
                                pstmt.executeUpdate();
                            }

                        } finally {
                            pstmt.close();
                        }

                        return null;
                    }
                });
            }
        });
    }
}