package PAI;

        import net.minidev.json.JSONArray;
        import net.minidev.json.JSONObject;

        import java.sql.ResultSet;
        import java.sql.SQLException;
        import java.util.LinkedList;
        import java.util.List;

public class UserList {

    private List<User> userList;
    private DatabaseConnection dbConnection = new DatabaseConnection();

    public UserList() throws SQLException {
        this.userList = new LinkedList<>();
        getUsersFromDB();
    }

    public void addUser(String name, String surname, String email, int age) throws SQLException {
        dbConnection.insertUser(name, surname, email, age);
        userList.add(new User(name, surname, email, age));
    }

    public JSONArray getUserList(){
        JSONArray userArray = new JSONArray();
        for(User u : userList){
            JSONObject currentUser = new JSONObject();
            currentUser.put("name", u.getName());
            currentUser.put("surname", u.getSurname());
            currentUser.put("email", u.getEmail());
            currentUser.put("age", u.getAge());
            userArray.add(currentUser);
        }
        return userArray;
    }

    private void getUsersFromDB() throws SQLException {
        ResultSet users = dbConnection.getUsersFromDB();
        while(users.next()){
            int id = users.getInt("id");
            String name = users.getString("name");
            String surname = users.getString("surname");
            String email = users.getString("email");
            int age = users.getInt("age");
            User temp = new User(name, surname, email, age);
            temp.setId(id);
            userList.add(temp);
        }
    }
}