Examples with User uk.ac.bris.cs.rfideasalreadytaken.lumberjack.database.data.User used on opensource projects

Example 6 with User

use of uk.ac.bris.cs.rfideasalreadytaken.lumberjack.database.data.User in project lumberjack by fn-ctional.

the class DatabaseUsers method loadUserFromResultSet.

public User loadUserFromResultSet(ResultSet rs) throws SQLException {
    if (rs.next()) {
        User user = new User();
        user.setCanRemove(rs.getBoolean("CanRemove"));
        user.setDeviceLimit(rs.getInt("DeviceLimit"));
        user.setDevicesRemoved(rs.getInt("DevicesRemoved"));
        user.setId(rs.getString("id"));
        user.setScanValue(rs.getString("ScanValue"));
        user.setGroupId(rs.getString("GroupID"));
        return user;
    }
    return null;
}

Example 7 with User

use of uk.ac.bris.cs.rfideasalreadytaken.lumberjack.database.data.User in project lumberjack by fn-ctional.

the class CardReaderBackendTests method testRemoveDevice.

@Test
public void testRemoveDevice() throws Exception {
    ScanDTO scan = new ScanDTO();
    scan.setUser("1314831486");
    scan.setDevice("36109839730967812");
    int removed = database.databaseUsers.loadUser(scan).getDevicesRemoved();
    ScanReturn result = database.databaseCardReader.scanReceived(scan);
    User user = database.databaseUsers.loadUser(scan);
    Device device = database.databaseDevices.loadDevice(scan);
    Assignment assignment = database.databaseAssignments.loadAssignment(device);
    assertEquals(result, ScanReturn.SUCCESSREMOVAL);
    assertEquals(device.isCurrentlyAssigned(), true);
    assertEquals(user.getDevicesRemoved(), removed + 1);
    assertEquals(assignment.getDeviceID(), device.getId());
    assertEquals(assignment.getUserID(), user.getId());
}

Example 8 with User

use of uk.ac.bris.cs.rfideasalreadytaken.lumberjack.database.data.User in project lumberjack by fn-ctional.

the class CardReaderBackendTests method testReturnDeviceByCorrectUser.

@Test
public void testReturnDeviceByCorrectUser() throws Exception {
    ScanDTO scan = new ScanDTO();
    scan.setUser("457436545");
    scan.setDevice("23482364326842334");
    int removed = database.databaseUsers.loadUser(scan).getDevicesRemoved();
    ScanReturn result = database.databaseCardReader.scanReceived(scan);
    User user = database.databaseUsers.loadUser(scan);
    Device device = database.databaseDevices.loadDevice(scan);
    Assignment assignment = database.databaseAssignments.loadAssignment(device);
    AssignmentHistory history = database.databaseAssignments.loadAssignmentHistory(device);
    assertEquals(result, ScanReturn.SUCCESSRETURN);
    assertEquals(device.isCurrentlyAssigned(), false);
    assertEquals(user.getDevicesRemoved(), removed - 1);
    assertNull(assignment);
    assertEquals(history.getUserID(), user.getId());
    assertEquals(history.getDeviceID(), device.getId());
}

Example 9 with User

use of uk.ac.bris.cs.rfideasalreadytaken.lumberjack.database.data.User in project lumberjack by fn-ctional.

the class WebBackend method getUsers.

// Tested
public List<User> getUsers() throws SQLException {
    List<User> users = new ArrayList<User>();
    PreparedStatement stmt = databaseConnection.getConnection().prepareStatement("SELECT * FROM Users");
    ResultSet rs = stmt.executeQuery();
    rs.last();
    int total = rs.getRow();
    rs.beforeFirst();
    for (int i = 0; i < total; i++) {
        users.add(databaseUsers.loadUserFromResultSet(rs));
    }
    return users;
}