package org.openslx.imagemaster.db;

import java.sql.Timestamp;
import java.util.List;


public class DbFtpUser
{
	public final String username;
	public final String password;
	public final String mode;
	public final String filename;
	public final String sessionId;
	public final Timestamp timestamp;
	
	public DbFtpUser(String username, String password, String mode, String filename, String sessionId, Timestamp timestamp)
	{
		this.username = username;
		this.password = password;
		this.mode = mode;
		this.filename = filename;
		this.sessionId = sessionId;
		this.timestamp = timestamp;
	}
	
	public static List<DbFtpUser> getAllUsers()
	{
		return MySQL.findAll( DbFtpUser.class, "SELECT username, password, mode, filename, sessionid, timestamp from ftpUser" );
	}
	
	public static void addUser(DbFtpUser user)
	{
		MySQL.update( "INSERT INTO ftpUser (username, password, mode, filename, sessionid, timestamp) VALUES (?, ?, ?, ?, ?, ?)",
				user.username, user.password, user.mode, user.filename, user.sessionId, user.timestamp); 
	}
	
	public static DbFtpUser getUserByName(String username)
	{
		return MySQL.findUniqueOrNull( DbFtpUser.class, "SELECT username, password, mode, filename, sessionid, timestamp FROM ftpUser WHERE username=?", username );
	}
	
	public static boolean removeUserByName(String username)
	{
		int result = MySQL.update( "DELETE FROM ftpUser WHERE username=? LIMIT 1", username );
		return result == 1;
	}
}