package io.hexlet.dao;

import io.hexlet.model.Course;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class CourseDAO {

    private Connection connection;

    public CourseDAO(Connection connection) {
        this.connection = connection;
    }

    public void save(Course course) {
        // Метод для сохранения курса в таблицу courses
    }

    public Course findById(Long id) {
        // Метод для поиска курса по идентификатору в таблице courses
        return null;
    }

    public List<Course> getEntities() {
        List<Course> courses = new ArrayList<>();
        String query = "SELECT * FROM courses";

        try (PreparedStatement statement = connection.prepareStatement(query);
             ResultSet resultSet = statement.executeQuery()) {

            while (resultSet.next()) {
                Long id = resultSet.getLong("id");
                String name = resultSet.getString("name");
                String description = resultSet.getString("description");
                Course course = new Course(id, name, description);
                courses.add(course);
            }

        } catch (SQLException e) {
            e.printStackTrace();
        }

        return courses;
    }
}