/*
 * 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 LatestDataProductionTokenQuery {

    private final Connection connection;
    private final String referentielVersion;
    private final String codeTypeFichier;

    public LatestDataProductionTokenQuery(Connection connection, String referentielVersion, String codeTypeFichier) {
        this.connection = connection;
        this.referentielVersion = referentielVersion;
        this.codeTypeFichier = codeTypeFichier;
    }

    public String execute() throws SQLException {
        try ( PreparedStatement stmt = connection.prepareStatement(queryString())) {
            stmt.setString(1, codeTypeFichier);
            stmt.setString(2, referentielVersion);
            stmt.setString(3, codeTypeFichier);
            stmt.setString(4, referentielVersion);

            ResultSet result = stmt.executeQuery();

            if (result.next()) {
                return result.getString(1);
            }
            return null;
        }
    }

    private String queryString() {
        String subQuery = "SELECT MAX(id) FROM dataproduction WHERE codetypefichier = ?"
                + " AND referentielversion = ? ";
        return "SELECT token FROM dataproduction WHERE codetypefichier = ?"
                + " AND referentielversion = ? AND ID IN (" + subQuery + ")";
    }
}