private void ProcessTableReference(TableReference TableRef)
{
string Type = GetFragmentType(TableRef);
switch (Type)
{
case "FullTextTableReference":
break;
case "NamedTableReference":
var NamedTableRef = (NamedTableReference)TableRef;
var Naming = NamedTableRef.SchemaObject;
string ObjectName = (Naming.DatabaseIdentifier == null ? this.databaseName : Naming.DatabaseIdentifier.Value) + "." +
(Naming.SchemaIdentifier == null ? this.schemaName : Naming.SchemaIdentifier.Value) + "." +
(Naming.BaseIdentifier == null ? "" : Naming.BaseIdentifier.Value);
addSourcetoCurrentObject(ObjectName);
break;
case "QueryDerivedTable":
QueryDerivedTable qdt = (QueryDerivedTable)TableRef;
ProcessQueryExpression(qdt.QueryExpression);
break;
case "QualifiedJoin":
QualifiedJoin qj = (QualifiedJoin)TableRef;
ProcessTableReference(qj.FirstTableReference);
ProcessTableReference(qj.SecondTableReference);
break;
case "UnqualifiedJoin":
UnqualifiedJoin uqj = (UnqualifiedJoin)TableRef;
ProcessTableReference(uqj.FirstTableReference);
ProcessTableReference(uqj.SecondTableReference);
break;
case "SchemaObjectFunctionTableReference":
SchemaObjectFunctionTableReference ftr = (SchemaObjectFunctionTableReference)TableRef;
break;
case "PivotedTableReference":
PivotedTableReference pvt = (PivotedTableReference)TableRef;
ProcessTableReference(pvt.TableReference);
break;
default:
break;
}
}
private void recursifRecuperationProjection(QuerySpecification node)
{
bool starExpression = false;
if (node.SelectElements != null)
{
foreach (TSqlFragment selectElement in node.SelectElements)
{
if (selectElement is SelectStarExpression)
{
starExpression = true;
if (node.SelectElements.Count > 1)
{
//Lever une exception qui dit que c'est non géré*
break;
}
else
{
if (node.FromClause != null)
{
foreach (TSqlFragment fromElement in node.FromClause.TableReferences)
{
if (fromElement is NamedTableReference)
{
String namedTableReferenceText = GetNodeTokenText(fromElement);
projectionList.AddRange(GetProjectionsFromTablesReference(namedTableReferenceText));
}
if (fromElement is QualifiedJoin)
{
QualifiedJoin currQualifiedJoin = (QualifiedJoin)fromElement;
if (currQualifiedJoin.FirstTableReference is NamedTableReference && currQualifiedJoin.SecondTableReference is NamedTableReference)
{
String namedTableReferenceText1 = GetNodeTokenText(currQualifiedJoin.FirstTableReference);
projectionList.AddRange(GetProjectionsFromTablesReference(namedTableReferenceText1));
String namedTableReferenceText2 = GetNodeTokenText(currQualifiedJoin.SecondTableReference);
projectionList.AddRange(GetProjectionsFromTablesReference(namedTableReferenceText2));
}
}
if (fromElement is PivotedTableReference)
{
PivotedTableReference currPivotedTable = (PivotedTableReference)fromElement;
if (currPivotedTable.TableReference is NamedTableReference)
{
String namedTableReferenceText = GetNodeTokenText(currPivotedTable.TableReference);
projectionList.AddRange(GetProjectionsFromTablesReference(namedTableReferenceText));
}
}
if (fromElement is QueryDerivedTable)
{
QueryDerivedTable currQueryDerivedTable = (QueryDerivedTable)fromElement;
if (currQueryDerivedTable.QueryExpression is QuerySpecification)
{
QuerySpecification currQuerySpecification = (QuerySpecification)currQueryDerivedTable.QueryExpression;
recursifRecuperationProjection(currQuerySpecification);
}
if (currQueryDerivedTable.QueryExpression is BinaryQueryExpression)
{
//BinaryQueryExpression représente un union entre deux requête donc si on veut les projections dans le cas ou
//Il y à un * il faut prendre les projections de la première requête d'union ou intersection
BinaryQueryExpression currBinaryQueryExpression = (BinaryQueryExpression)currQueryDerivedTable.QueryExpression;
while (currBinaryQueryExpression.FirstQueryExpression is BinaryQueryExpression)
{
currBinaryQueryExpression = (BinaryQueryExpression)currBinaryQueryExpression.FirstQueryExpression;
}
if (currBinaryQueryExpression.FirstQueryExpression is QuerySpecification)
{
QuerySpecification currQuerySpecification = (QuerySpecification)currBinaryQueryExpression.FirstQueryExpression;
recursifRecuperationProjection(currQuerySpecification);
}
}
}
}
}
}
}
}
if (starExpression == false)
{
foreach (SelectElement selectElement in node.SelectElements)
{
projectionList.Add(GetNodeTokenText(selectElement));
}
}
}
}
public override void Visit(PivotedTableReference node) { this.action(node); }
public override void ExplicitVisit(PivotedTableReference fragment)
{
_fragments.Add(fragment);
}
public QsiTableNode VisitPivotedTableReference(PivotedTableReference pivotedTableReference)
{
// TODO: Implement
throw TreeHelper.NotSupportedFeature("Pivot table");
}
