/*
 * Click nbfs://nbhost/SystemFileSystem/Templates/Licenses/license-default.txt to change this license
 * Click nbfs://nbhost/SystemFileSystem/Templates/Classes/Class.java to edit this template
 */
package com.megatim.fdxcommons.tools.database.queries;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * @author ASUS
 */
public class SelectDataProductionQuery {

    private final Connection connection;

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

    public boolean dataProductionExists(Long id) throws SQLException {
        String query = "SELECT COUNT(*) FROM DATAPRODUCTION WHERE id = " + id;

        try ( PreparedStatement statement = connection.prepareStatement(query)) {
            ResultSet resultSet = statement.executeQuery();
            if (resultSet.next()) {
                return resultSet.getLong(1) > 0;
            }
            return false;
        }
    }
}