org.cloudfoundry.identity.uaa.user.JdbcUaaUserDatabase Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of cloudfoundry-identity-common Show documentation
Cloud Foundry User Account and Authentication
There is a newer version: 2.7.4.9
Show newest version
/*******************************************************************************
 *     Cloud Foundry
 *     Copyright (c) [2009-2014] Pivotal Software, Inc. All Rights Reserved.
 *
 *     This product is licensed to you under the Apache License, Version 2.0 (the "License").
 *     You may not use this product except in compliance with the License.
 *
 *     This product includes a number of subcomponents with
 *     separate copyright notices and license terms. Your use of these
 *     subcomponents is subject to the terms and conditions of the
 *     subcomponent's license, as noted in the LICENSE file.
 *******************************************************************************/
package org.cloudfoundry.identity.uaa.user;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Collections;
import java.util.HashSet;
import java.util.List;
import java.util.Locale;
import java.util.Set;

import org.cloudfoundry.identity.uaa.zone.IdentityZoneHolder;
import org.springframework.dao.EmptyResultDataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.security.core.GrantedAuthority;
import org.springframework.security.core.authority.AuthorityUtils;
import org.springframework.security.core.userdetails.UsernameNotFoundException;
import org.springframework.util.Assert;
import org.springframework.util.StringUtils;

/**
 * @author Luke Taylor
 * @author Dave Syer
 * @author Vidya Valmikinathan
 */
public class JdbcUaaUserDatabase implements UaaUserDatabase {

    public static final String USER_FIELDS = "id,username,password,email,givenName,familyName,created,lastModified,authorities,origin,external_id,verified,identity_zone_id,salt,passwd_lastmodified ";

    public static final String DEFAULT_USER_BY_USERNAME_QUERY = "select " + USER_FIELDS + "from users "
                    + "where lower(username) = ? and active=? and origin=? and identity_zone_id=?";

    public static final String DEFAULT_USER_BY_ID_QUERY = "select " + USER_FIELDS + "from users "
        + "where id = ? and active=?";

    private String userAuthoritiesQuery = null;

    private String userByUserNameQuery = DEFAULT_USER_BY_USERNAME_QUERY;

    private JdbcTemplate jdbcTemplate;

    private final RowMapper mapper = new UaaUserRowMapper();

    private Set defaultAuthorities = new HashSet();

    public void setUserByUserNameQuery(String userByUserNameQuery) {
        this.userByUserNameQuery = userByUserNameQuery;
    }

    public void setUserAuthoritiesQuery(String userAuthoritiesQuery) {
        this.userAuthoritiesQuery = userAuthoritiesQuery;
    }

    public void setDefaultAuthorities(Set defaultAuthorities) {
        this.defaultAuthorities = defaultAuthorities;
    }

    public JdbcUaaUserDatabase(JdbcTemplate jdbcTemplate) {
        Assert.notNull(jdbcTemplate);
        this.jdbcTemplate = jdbcTemplate;
    }

    @Override
    public UaaUser retrieveUserByName(String username, String origin) throws UsernameNotFoundException {
        try {
            return jdbcTemplate.queryForObject(userByUserNameQuery, mapper, username.toLowerCase(Locale.US), true, origin, IdentityZoneHolder.get().getId());
        } catch (EmptyResultDataAccessException e) {
            throw new UsernameNotFoundException(username);
        }
    }

    @Override
    public UaaUser retrieveUserById(String id) throws UsernameNotFoundException {
        try {
            return jdbcTemplate.queryForObject(DEFAULT_USER_BY_ID_QUERY, mapper, id, true);
        } catch (EmptyResultDataAccessException e) {
            throw new UsernameNotFoundException(id);
        }
    }

    private final class UaaUserRowMapper implements RowMapper {
        @Override
        public UaaUser mapRow(ResultSet rs, int rowNum) throws SQLException {
            String id = rs.getString(1);
            if (userAuthoritiesQuery == null) {
                return new UaaUser(id, rs.getString(2), rs.getString(3), rs.getString(4),
                                getDefaultAuthorities(rs.getString(9)), rs.getString(5), rs.getString(6),
                                rs.getTimestamp(7), rs.getTimestamp(8), rs.getString(10), rs.getString(11), rs.getBoolean(12), rs.getString(13), rs.getString(14),rs.getTimestamp(15));
            } else {
                List authorities = AuthorityUtils
                                .commaSeparatedStringToAuthorityList(getAuthorities(id));
                return new UaaUser(id, rs.getString(2), rs.getString(3), rs.getString(4),
                                authorities, rs.getString(5), rs.getString(6),
                                rs.getTimestamp(7), rs.getTimestamp(8), rs.getString(10), rs.getString(11), rs.getBoolean(12), rs.getString(13), rs.getString(14),rs.getTimestamp(15));
            }
        }

        private List getDefaultAuthorities(String defaultAuth) {
            List authorities = new ArrayList();
            authorities.addAll(StringUtils.commaDelimitedListToSet(defaultAuth));
            authorities.addAll(defaultAuthorities);
            String authsString = StringUtils.collectionToCommaDelimitedString(new HashSet(authorities));
            return AuthorityUtils.commaSeparatedStringToAuthorityList(authsString);
        }

        private String getAuthorities(final String userId) {
            List authorities;
            try {
                authorities = jdbcTemplate.queryForList(userAuthoritiesQuery, String.class, userId);
            } catch (EmptyResultDataAccessException ex) {
                authorities = Collections. emptyList();
            }
            authorities.addAll(defaultAuthorities);
            return StringUtils.collectionToCommaDelimitedString(new HashSet(authorities));
        }
    }
}