From 23a46b4be35277e06ec89f48730eeb694e686be8 Mon Sep 17 00:00:00 2001
From: Kenmegne <stephanie.kenmegne@gmail.com>
Date: Thu, 18 Jun 2026 15:40:06 +0000
Subject: [PATCH] add fdx-commons and fdx-consultation
---
fdx-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/tables/FdxTableName.java | 89 ++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 89 insertions(+), 0 deletions(-)
diff --git a/fdx-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/tables/FdxTableName.java b/fdx-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/tables/FdxTableName.java
new file mode 100644
index 0000000..e18338d
--- /dev/null
+++ b/fdx-commons/fdxcommons-tools/src/main/java/com/megatim/fdxcommons/tools/database/tables/FdxTableName.java
@@ -0,0 +1,89 @@
+package com.megatim.fdxcommons.tools.database.tables;
+
+import com.megatim.fdxcommons.tools.database.contrat.TableName;
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Objects;
+
+/**
+ *
+ * @author Gabuntu
+ */
+public class FdxTableName implements TableName {
+
+ private final String referentielVersion;
+ private final String codeTypeFichier;
+ private String refVersionToUse = null;
+
+ public FdxTableName(String referentielVersion, String codeTypeFichier) {
+ this.referentielVersion = referentielVersion;
+ this.codeTypeFichier = codeTypeFichier;
+ }
+
+ @Override
+ public String name(Connection connection) throws SQLException {
+ if (refVersionToUse == null) {
+ refVersionToUse(connection);
+ }
+ return refVersionToUse != null && !refVersionToUse.isEmpty()
+ ? "ref" + refVersionToUse.toLowerCase() + "_" + codeTypeFichier.toLowerCase()
+ : "ref" + referentielVersion.toLowerCase() + "_" + codeTypeFichier.toLowerCase();
+ }
+
+ private void refVersionToUse(Connection connection) throws SQLException {
+
+ try ( PreparedStatement statement = connection.prepareStatement(query())) {
+ ResultSet resultSet = statement.executeQuery();
+
+ while (resultSet.next()) {
+ refVersionToUse = resultSet.getString(1);
+ }
+ } catch (Exception ex) {
+ ex.printStackTrace();
+ }
+ }
+
+ @Override
+ public boolean equals(Object obj) {
+ if (this == obj) {
+ return true;
+ }
+ if (obj == null) {
+ return false;
+ }
+ if (getClass() != obj.getClass()) {
+ return false;
+ }
+ final FdxTableName other = (FdxTableName) obj;
+
+ if (refVersionToUse != null && other.getRefVersionToUse() != null) {
+ return refVersionToUse.equals(other.getRefVersionToUse());
+ } else {
+ return false;
+ }
+ }
+
+ @Override
+ public int hashCode() {
+ int hash = 3;
+ hash = 79 * hash + Objects.hashCode(this.referentielVersion);
+ hash = 79 * hash + Objects.hashCode(this.codeTypeFichier);
+ return hash;
+ }
+
+ public String getRefVersionToUse() {
+ return refVersionToUse;
+ }
+
+ private String query() {
+ return "SELECT DISTINCT r.referentielVersion"
+ + " FROM referentielIntegrationHistorique r"
+ + " JOIN ref_int_historique_depending_refs rd"
+ + " ON r.codetypefichier = rd.codetypefichier"
+ + " AND r.referentielVersion = rd.referentielVersion"
+ + " WHERE rd.dependingreferentiels = '" + referentielVersion + "'"
+ + " AND r.codetypefichier = '" + codeTypeFichier + "'";
+ }
+}
--
Gitblit v1.10.0