Package gudusoft.gsqlparser.resolver2.inference

Class InferenceEvidence

Object

gudusoft.gsqlparser.resolver2.inference.InferenceEvidence

public class InferenceEvidence
extends Object

Represents a piece of evidence for column inference.

Evidence is collected from various sources in the SQL statement: - Column references in WHERE clauses - JOIN conditions - SELECT list expressions - INSERT statements (column lists) - etc.

Each piece of evidence has a confidence weight that contributes to the overall inference confidence.

Example:

 SELECT t1.* FROM t1 WHERE t1.id = 100
                              ^^
 Evidence: "id" exists in t1 (from WHERE clause, high confidence)
 

Constructor Summary

Constructors

Constructor	Description
InferenceEvidence(String columnName, String tableName, EvidenceType evidenceType, double confidence, TParseTreeNode sourceNode, String description)

Method Summary

Modifier and Type	Method	Description
boolean	equals(Object obj)
static InferenceEvidence	fromInsertColumns(String columnName, String tableName, TParseTreeNode sourceNode)	Create evidence from INSERT statement column list.
static InferenceEvidence	fromJoinCondition(String columnName, String tableName, TParseTreeNode sourceNode)	Create evidence from a JOIN condition.
static InferenceEvidence	fromQualifiedReference(String columnName, String tableName, TParseTreeNode sourceNode)	Create evidence from a qualified column reference.
static InferenceEvidence	fromSelectList(String columnName, String tableName, TParseTreeNode sourceNode)	Create evidence from SELECT list.
static InferenceEvidence	fromUnqualifiedReference(String columnName, String tableName, TParseTreeNode sourceNode, int tableCount)	Create evidence from an unqualified column reference.
static InferenceEvidence	fromUpdateSet(String columnName, String tableName, TParseTreeNode sourceNode)	Create evidence from UPDATE statement.
String	getColumnName()
double	getConfidence()
String	getDescription()
EvidenceType	getEvidenceType()
TParseTreeNode	getSourceNode()
String	getTableName()
int	hashCode()
String	toString()

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Constructor Details

InferenceEvidence

public InferenceEvidence(String columnName,
 String tableName,
 EvidenceType evidenceType,
 double confidence,
 TParseTreeNode sourceNode,
 String description)

Method Details

getColumnName

public String getColumnName()

getTableName

public String getTableName()

getEvidenceType

public EvidenceType getEvidenceType()

getConfidence

public double getConfidence()

getSourceNode

public TParseTreeNode getSourceNode()

getDescription

public String getDescription()

fromQualifiedReference

public static InferenceEvidence fromQualifiedReference(String columnName,
 String tableName,
 TParseTreeNode sourceNode)

Create evidence from a qualified column reference. Example: WHERE t1.id = 100

fromUnqualifiedReference

public static InferenceEvidence fromUnqualifiedReference(String columnName,
 String tableName,
 TParseTreeNode sourceNode,
 int tableCount)

Create evidence from an unqualified column reference. Example: WHERE id = 100 (when only one table in scope)

fromJoinCondition

public static InferenceEvidence fromJoinCondition(String columnName,
 String tableName,
 TParseTreeNode sourceNode)

Create evidence from a JOIN condition. Example: JOIN t2 ON t1.id = t2.t1_id

fromSelectList

public static InferenceEvidence fromSelectList(String columnName,
 String tableName,
 TParseTreeNode sourceNode)

Create evidence from SELECT list. Example: SELECT t1.name, t1.age FROM t1

fromInsertColumns

public static InferenceEvidence fromInsertColumns(String columnName,
 String tableName,
 TParseTreeNode sourceNode)

Create evidence from INSERT statement column list. Example: INSERT INTO t1 (id, name) VALUES (...)

fromUpdateSet

public static InferenceEvidence fromUpdateSet(String columnName,
 String tableName,
 TParseTreeNode sourceNode)

Create evidence from UPDATE statement. Example: UPDATE t1 SET name = 'value'

toString

public String toString()

Overrides:

toString in class Object

equals

public boolean equals(Object obj)

Overrides:

equals in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object