Initial Commit

1 files changed, 30 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
new file mode 100644
index 0000000..f8400a9
--- /dev/null
+++ b/src/main/java/org/openslx/imagemaster/db/DbUser.java
@@ -0,0 +1,30 @@
+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] );
+	}
+
+}