diff options
Diffstat (limited to 'src/main/java/org/openslx/imagemaster/db/DbUser.java')
-rw-r--r-- | src/main/java/org/openslx/imagemaster/db/DbUser.java | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/src/main/java/org/openslx/imagemaster/db/DbUser.java b/src/main/java/org/openslx/imagemaster/db/DbUser.java index 8cf4b55..ffc9d1a 100644 --- a/src/main/java/org/openslx/imagemaster/db/DbUser.java +++ b/src/main/java/org/openslx/imagemaster/db/DbUser.java @@ -71,4 +71,24 @@ public class DbUser extends User return user.username; } + /** + * Checks if a user with id (userid@organization) exists + * @param id + * @return whether ther user exists + */ + public static boolean exists( String id ) + { + String user = id.split( "@" )[0]; + String organization = id.split( "@" )[1]; + + DbUser dbUser = MySQL.findUniqueOrNull( DbUser.class, + "SELECT user.userid, 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", user, organization); + + if ( dbUser == null ) return false; + + return true; + } + } |