summaryrefslogtreecommitdiffstats
path: root/src/main/java/org/openslx/imagemaster/db/DbUser.java
diff options
context:
space:
mode:
authorNils Schwabe2014-04-23 15:10:36 +0200
committerNils Schwabe2014-04-23 15:10:36 +0200
commitf71e8a5bcd2d7f85f58fedf3f6ea8dc8c7f89b63 (patch)
tree5a79e7f320e6ca76ade3cf8039079d182f0178ad /src/main/java/org/openslx/imagemaster/db/DbUser.java
parentFix some issues with FtpCredentialsScheduler (diff)
downloadmasterserver-f71e8a5bcd2d7f85f58fedf3f6ea8dc8c7f89b63.tar.gz
masterserver-f71e8a5bcd2d7f85f58fedf3f6ea8dc8c7f89b63.tar.xz
masterserver-f71e8a5bcd2d7f85f58fedf3f6ea8dc8c7f89b63.zip
Reformat all files with simon's new layout
Diffstat (limited to 'src/main/java/org/openslx/imagemaster/db/DbUser.java')
-rw-r--r--src/main/java/org/openslx/imagemaster/db/DbUser.java45
1 files changed, 26 insertions, 19 deletions
diff --git a/src/main/java/org/openslx/imagemaster/db/DbUser.java b/src/main/java/org/openslx/imagemaster/db/DbUser.java
index 774917d..45cbb2a 100644
--- a/src/main/java/org/openslx/imagemaster/db/DbUser.java
+++ b/src/main/java/org/openslx/imagemaster/db/DbUser.java
@@ -3,27 +3,31 @@ package org.openslx.imagemaster.db;
import org.apache.log4j.Logger;
import org.openslx.imagemaster.session.User;
-public class DbUser extends User {
+public class DbUser extends User
+{
+
private static Logger log = Logger.getLogger( DbUser.class );
-
+
public DbUser(int userId, String username, String password, String organization,
String firstName, String lastName, String eMail,
- String satelliteAddress) {
- super(userId, username, password, organization, firstName, lastName, eMail,
- satelliteAddress);
+ String satelliteAddress)
+ {
+ super( userId, username, password, organization, firstName, lastName, eMail,
+ satelliteAddress );
}
/**
* Query database for user with given login
*
* @param login
- * (user@organization)
+ * (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)
+ public static DbUser forLogin( final String login )
+ {
+ final String[] parts = login.split( "@" );
+ if ( parts.length != 2 )
return null;
return MySQL
.findUniqueOrNull(
@@ -31,24 +35,27 @@ public class DbUser extends User {
"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",
- parts[0], parts[1]);
+ parts[0], parts[1] );
}
- public static boolean insertOrUpdate(User user) {
- log.debug("Inserted user '" + user.username + "' into db.");
- MySQL.update("INSERT INTO user (username, password, organization, firstname, lastname, email) VALUES (?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE password=VALUES(password), organization=VALUES(organization), firstname=VALUES(firstname), lastname=VALUES(lastname), email=VALUES(email)",
- user.username, user.password, user.organization, user.firstName, user.lastName, user.eMail);
+ public static boolean insertOrUpdate( User user )
+ {
+ log.debug( "Inserted user '" + user.username + "' into db." );
+ MySQL.update(
+ "INSERT INTO user (username, password, organization, firstname, lastname, email) VALUES (?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE password=VALUES(password), organization=VALUES(organization), firstname=VALUES(firstname), lastname=VALUES(lastname), email=VALUES(email)",
+ user.username, user.password, user.organization, user.firstName, user.lastName, user.eMail );
return false;
}
-
- public static int getUserIdByName(String username) {
- DbUser user = MySQL
+
+ public static int getUserIdByName( String username )
+ {
+ DbUser user = 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 = ? LIMIT 1", username);
- if (user != null) {
+ + " WHERE user.username = ? LIMIT 1", username );
+ if ( user != null ) {
return user.userId;
} else {
return 0;