|
|
package org.openslx.imagemaster.db.mappers;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import org.apache.log4j.Logger;
import org.openslx.bwlp.thrift.iface.Role;
import org.openslx.bwlp.thrift.iface.TNotFoundException;
import org.openslx.bwlp.thrift.iface.UserInfo;
import org.openslx.imagemaster.db.Database;
import org.openslx.imagemaster.db.MysqlConnection;
import org.openslx.imagemaster.db.MysqlStatement;
import org.openslx.imagemaster.db.models.LocalUser;
import org.openslx.imagemaster.util.Sha512Crypt;
/**
* Represents a user that can login against the masterserver.
*/
public class DbUser
{
private static final Logger LOGGER = Logger.getLogger( DbUser.class );
private static final String localUserSql = "SELECT"
+ " user.userid, user.password, user.organizationid, user.firstname, user.lastname, user.email"
+ " FROM user";
private static LocalUser localFromRs( ResultSet rs ) throws SQLException
{
return new LocalUser( rs.getString( "userid" ), rs.getString( "password" ),
rs.getString( "organizationid" ), rs.getString( "firstname" ), rs.getString( "lastname" ), rs.getString( "email" ),
Role.TUTOR );
}
/**
* Query database for user with given user id
*
* @param login (global user-id, login@org for test-accounts)
* @return instance of DbUser for matching entry from DB, or null if not
* found
* @throws SQLException if the query fails
*/
public static LocalUser forUserId( final String login ) throws SQLException
{
try ( MysqlConnection connection = Database.getConnection() ) {
MysqlStatement stmt = connection.prepareStatement( localUserSql
+ " WHERE user.userid = :userid" );
stmt.setString( "userid", login );
ResultSet rs = stmt.executeQuery();
if ( !rs.next() )
return null;
return localFromRs( rs );
} catch ( SQLException e ) {
LOGGER.error( "Query failed in DbUser.forLogin()", e );
throw e;
}
}
public static LocalUser forUserId( String login, String password ) throws SQLException
{
LocalUser user = forUserId( login );
if ( user == null || !Sha512Crypt.verifyPassword( password, user.password ) )
return null;
return user;
}
public static UserInfo getUserInfo( final String login ) throws SQLException, TNotFoundException
{
LocalUser user = forUserId( login );
if ( user == null )
throw new TNotFoundException();
return user.toUserInfo();
}
public static List<UserInfo> findUser( String organizationId, String searchTerm )
{
// TODO Implement
return new ArrayList<>( 0 );
}
public static boolean exists( UserInfo user )
{
return exists( user, false );
}
public static boolean exists( UserInfo user, boolean withIdentity )
{
if ( user == null )
return false;
return exists( user.userId, withIdentity );
}
private static boolean exists( String userId, boolean withIdentitiy )
{
if ( userId == null )
return false;
try {
return forUserId( userId ) != null;
} catch ( SQLException e ) {
return false;
}
}
}
|