public QsiTableNode VisitTableReferenceWithAliasAndColumns(TableReferenceWithAliasAndColumns tableReferenceWithAliasAndColumns)
{
switch (tableReferenceWithAliasAndColumns)
{
// OPENROWSET (Bulk..)
case BulkOpenRowset bulkOpenRowset:
return(VisitBulkOpenRowset(bulkOpenRowset));
case ChangeTableChangesTableReference changeTableChangesTableReference:
return(VisitChangeTableChangesTableReference(changeTableChangesTableReference));
case ChangeTableVersionTableReference changeTableVersionTableReference:
return(VisitChangeTableVersionTableReference(changeTableVersionTableReference));
case DataModificationTableReference dataModificationTableReference:
return(VisitDataModificationTableReference(dataModificationTableReference));
case InlineDerivedTable inlineDerivedTable:
return(VisitInlineDerivedTable(inlineDerivedTable));
case QueryDerivedTable queryDerivedTable:
return(VisitQueryDerivedTable(queryDerivedTable));
case SchemaObjectFunctionTableReference schemaObjectFunctionTableReference:
return(VisitSchemaObjectFunctionTableReference(schemaObjectFunctionTableReference));
case VariableMethodCallTableReference variableMethodCallTableReference:
return(VisitVariableMethodCallTableReference(variableMethodCallTableReference));
}
throw TreeHelper.NotSupportedTree(tableReferenceWithAliasAndColumns);
}
public override void Visit(TableReferenceWithAliasAndColumns node)
{
if (node.Alias != null)
{
node.Alias.Value = node.Alias.Value.ToSnakeCase();
}
base.Visit(node);
}
public override void Visit(TableReferenceWithAliasAndColumns node)
{
//Postgresql doesn't like [columnname]
if (node.Alias != null)
{
if (node.Alias.QuoteType == QuoteType.SquareBracket)
{
node.Alias.QuoteType = QuoteType.NotQuoted;
}
node.Alias.Value = node.Alias.Value.ToSnakeCase();
}
base.Visit(node);
}
public override void Visit(TableReferenceWithAliasAndColumns node)
{
if (node.Alias != null)
{
var oldValue = node.Alias.Value;
var newValue = node.Alias.Value.ToSnakeCase();
if (string.Compare(oldValue, newValue, false) != 0)
{
_replacements.Add(new Replacement()
{
LineNumber = node.StartLine,
Column = node.Alias.QuoteType == QuoteType.NotQuoted ? node.StartColumn : node.StartColumn + 1,
Offset = node.Alias.QuoteType == QuoteType.NotQuoted ? node.StartOffset : node.StartOffset + 1,
OldValue = oldValue,
NewValue = newValue
});
}
}
base.Visit(node);
}
public override void ExplicitVisit(TableReferenceWithAliasAndColumns fragment)
{
_fragments.Add(fragment);
}
public sealed override void ExplicitVisit(TableReferenceWithAliasAndColumns node)
{
base.ExplicitVisit(node);
}
public override void ExplicitVisit(TableReferenceWithAliasAndColumns node) { this.action(node); }