ch.inftec.ju.db.auth.repo.AuthUserRepo Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of ju-dbutil Show documentation

DB related utility functions

There is a newer version: 4.5.1-11

package ch.inftec.ju.db.auth.repo;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import ch.inftec.ju.db.auth.entity.AuthUser;

/**
 * Spring repository interface for the User entity.
 * @author Martin
 *
 */
public interface AuthUserRepo extends CrudRepository {
	@Query("select u from AuthUser u where u.name=?1")
	AuthUser getByName(String name);
	
	/**
	 * Gets all AuthUsers, ordered by the user name.
	 * @return
	 */
	@Query("select u from AuthUser u order by u.name")
	List findAll();
	
	/**
	 * Gets all user names, ordered alphabetically
	 * @return
	 */
	@Query("select u.name from AuthUser u order by u.name")
	List findAllNames();
}