package org.openslx.imagemaster.db;

import org.openslx.imagemaster.session.User;


public class DbUser extends User
{
	public DbUser(String username, String password, String organization, String firstName, String lastName, String eMail,
			String satelliteAddress)
	{
		super( username, password, organization, firstName, lastName, eMail, satelliteAddress );
	}

	/**
	 * Query database for user with given login
	 * @param login (user@organization)
	 * @return instance of DbUser for matching entry from DB, or null if not found
	 */
	public static DbUser forLogin( final String login )
	{
		final String[] parts = login.split( "@" );
		if ( parts.length != 2 )
			return null;
		return MySQL.findUniqueOrNull( DbUser.class,
				"SELECT user.username, user.password, user.organization, user.firstname, user.lastname, user.email, satellite.address FROM user" +
				" LEFT JOIN satellite USING (organization)" +
				" WHERE user.username = ? AND user.organization = ? LIMIT 1", parts[0], parts[1] );
	}

}