import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.concurrent.TimeUnit;

public final class SqlPathDemo {
    public static void main(String[] args) throws Exception {
        String url = requiredVariable("DB_URL");
        String user = requiredVariable("DB_USER");
        String password = requiredVariable("DB_PASSWORD");
        String sql = """
                SELECT id, customer_id, amount, created_at
                FROM kb01_order
                WHERE customer_id = ?
                ORDER BY created_at DESC, id DESC
                LIMIT ?
                """;

        long startedAt = System.nanoTime();
        long connectedAt;
        long executeStartedAt;
        long resultReturnedAt;
        long consumedAt;
        int rows = 0;

        try (Connection connection = DriverManager.getConnection(url, user, password)) {
            connectedAt = System.nanoTime();
            try (PreparedStatement statement = connection.prepareStatement(sql)) {
                statement.setLong(1, 1001L);
                statement.setInt(2, 20);
                statement.setQueryTimeout(3);
                executeStartedAt = System.nanoTime();
                try (ResultSet result = statement.executeQuery()) {
                    resultReturnedAt = System.nanoTime();
                    while (result.next()) {
                        result.getLong("id");
                        result.getLong("customer_id");
                        result.getBigDecimal("amount");
                        result.getTimestamp("created_at");
                        rows++;
                    }
                }
                consumedAt = System.nanoTime();
            }
        }
        long closedAt = System.nanoTime();
        System.out.printf(
                "connect=%d ms, prepare=%d ms, executeQuery=%d ms, consume=%d ms, total=%d ms, rows=%d%n",
                millis(startedAt, connectedAt),
                millis(connectedAt, executeStartedAt),
                millis(executeStartedAt, resultReturnedAt),
                millis(resultReturnedAt, consumedAt),
                millis(startedAt, closedAt),
                rows);
    }

    private static String requiredVariable(String name) {
        String value = System.getenv(name);
        if (value == null || value.isBlank()) {
            throw new IllegalArgumentException("Missing environment variable: " + name);
        }
        return value;
    }

    private static long millis(long start, long end) {
        return TimeUnit.NANOSECONDS.toMillis(end - start);
    }
}
