package com.megatim.fdxcommons.tools.database.queries;

import com.megatim.fdxcommons.model.dataproduction.CommonDataProduction;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

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

    private final Connection connection;
    private final CommonDataProduction dataProduction;

    public UpdateDataProductionQuery(CommonDataProduction dataProduction, Connection connection) {
        this.connection = connection;
        this.dataProduction = dataProduction;
    }

    public void execute() throws SQLException {
        try (PreparedStatement statement = connection.prepareStatement(queryString())) {
            statement.setString(1, dataProduction.getStatutDataProduction().name());
            statement.setLong(2, dataProduction.getNbreElements());
            statement.setLong(3, dataProduction.getId());
            statement.executeUpdate();
        }
    }

    private String queryString() {
        String query = "UPDATE dataproduction SET statutdataproduction  = ? , nbreelements = ? WHERE id = ?";
        return query;
    }
}