gudusoft.gsqlparser.resolver2.model

Class ColumnSourceWithReferences

Object

gudusoft.gsqlparser.resolver2.model.ColumnSourceWithReferences

public class ColumnSourceWithReferences
extends Object

Enhanced column source that supports multiple reference traceability.

A normalized column name may correspond to multiple original references in SQL. For example, in Oracle SQL SELECT "Column1", column1 FROM dual:

• Both "Column1" and column1 normalize to COLUMN1
• This class stores the canonical ColumnSource plus all original references
• Output shows one column (deduplication)
• All original positions can be traced back

Design pattern: Aggregator for Many-to-One mapping

• Multiple original identifiers (different syntax) → One semantic identifier
• Maintains link from semantic identifier back to all original identifiers

Since:

3.1.0.9

Constructor Summary

Constructors

Constructor and Description
ColumnSourceWithReferences(String normalizedName, ColumnSource canonicalSource) Create a new column source with references.

Method Summary

Modifier and Type	Method and Description
void	addReference(ColumnReference ref) Add an original reference.
List<String>	getAllOriginalTexts() Get all original texts from all references.
List<ColumnReference>	getAllReferences() Get all original references.
ColumnReference	getCanonicalReference() Get the first (canonical) reference.
ColumnSource	getCanonicalSource() Get the canonical column source.
String	getNormalizedName() Get the normalized name.
int	getReferenceCount() Get the number of references.
boolean	hasMultipleReferences() Check if there are multiple references (indicating deduplication occurred).
String	toString()

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

ColumnSourceWithReferences

public ColumnSourceWithReferences(String normalizedName,
                                  ColumnSource canonicalSource)

Create a new column source with references.

Parameters:

normalizedName - normalized column name

canonicalSource - the canonical column source

Method Detail

addReference

public void addReference(ColumnReference ref)

Add an original reference.

Parameters:

ref - the column reference to add

getAllReferences

public List<ColumnReference> getAllReferences()

Get all original references.

Returns:

unmodifiable list of all references in order of appearance

getReferenceCount

public int getReferenceCount()

Get the number of references.

Returns:

reference count

hasMultipleReferences

public boolean hasMultipleReferences()

Check if there are multiple references (indicating deduplication occurred).

Returns:

true if more than one reference exists

getCanonicalReference

public ColumnReference getCanonicalReference()

Get the first (canonical) reference.

Returns:

the first reference, or null if none

getNormalizedName

public String getNormalizedName()

Get the normalized name.

Returns:

normalized column name

getCanonicalSource

public ColumnSource getCanonicalSource()

Get the canonical column source.

Returns:

the column source for resolution

getAllOriginalTexts

public List<String> getAllOriginalTexts()

Get all original texts from all references.

Returns:

list of original text strings

toString

public String toString()

Overrides:

toString in class Object