package org.openslx.satellitedaemon.db;

public class DbUser
{

	public final String userId;
	public final String firstName;
	public final String lastName;
	public final String email;
	public final String institution;
	
	public DbUser(String userId, String firstName, String lastName, String email, String institution) {
		this.userId = userId;
		this.firstName = firstName;
		this.lastName = lastName;
		this.email = email;
		this.institution = institution;
	}
	
	/**
	 * Returns DbUser with given userId.
	 * @param userId
	 * @return DbUser with userId.
	 */
	public static DbUser getUserById(String userId) {
		return MySQL.findUniqueOrNull( DbUser.class, "SELECT user.userID, user.Vorname AS firstName, " +
				"user.Nachname AS lastName, user.mail AS email, user.institution " +
				"FROM m_user user " +
				"WHERE userID = ?", userId );
	}
}