/*
 * 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.SQLException;
import java.sql.Timestamp;
import java.time.LocalDateTime;

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

    private final Connection connection;
    private final Long dataProductionId;

    public EchecIntegrationQueries(Connection connection, Long dataProductionId) {
        this.connection = connection;
        this.dataProductionId = dataProductionId;
    }

    public void save() throws SQLException {
        String query = "INSERT INTO ECHECINTEGRATION (dataproductionid, datecreation) values(?,?)";

        try ( PreparedStatement statement = connection.prepareStatement(query)) {
            statement.setLong(1, dataProductionId);
            statement.setTimestamp(2, Timestamp.valueOf(LocalDateTime.now()));

            statement.executeUpdate();
        }
    }
}