UserRepository.java

package org.ohdsi.webapi.shiro.Entities;

import java.util.Set;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

/**
 * Created by GMalikov on 24.08.2015.
 */
public interface UserRepository extends CrudRepository<UserEntity, Long> {

    public UserEntity findByLogin(String login);

    @Query("SELECT u.login FROM UserEntity u")
    public Set<String> getUserLogins();

    @Query("from UserEntity where login = 'testLogin'")
    public UserEntity getTestUser();
}