protected override void OnNodeInit()
{
Expression = ChildNodes.OfType<IExpressionNode>().FirstOrDefault();
Name = ChildNodes.OfType<ObjectNameNode>().FirstOrDefault();
var aliasNode = this.FindByName("select_as_opt");
if (aliasNode != null)
Alias = aliasNode.FindNode<IdentifierNode>();
}
/// <inheritdoc/>
protected override ISqlNode OnChildNode(ISqlNode node)
{
if (node is ObjectNameNode) {
TableName = (ObjectNameNode)node;
} else if (node.NodeName == "select_as_opt") {
Alias = (IdentifierNode)node.ChildNodes.FirstOrDefault();
}
return base.OnChildNode(node);
}
/// <inheritdoc/>
protected override ISqlNode OnChildNode(ISqlNode node)
{
if (node is ObjectNameNode)
{
TableName = (ObjectNameNode)node;
}
else if (node.NodeName == "select_as_opt")
{
Alias = (IdentifierNode)node.ChildNodes.FirstOrDefault();
}
return(base.OnChildNode(node));
}
protected override ISqlNode OnChildNode(ISqlNode node)
{
if (node.NodeName == "column_list_opt") {
GetColumnList(node);
} else if (node.NodeName == "or_replace_opt") {
if (node.ChildNodes.Any())
ReplaceIfExists = true;
} else if (node is ObjectNameNode) {
ViewName = (ObjectNameNode) node;
} else if (node is SqlQueryExpressionNode) {
QueryExpression = (SqlQueryExpressionNode) node;
}
return base.OnChildNode(node);
}
/// <inheritdoc/>
protected override ISqlNode OnChildNode(ISqlNode node)
{
Reference = (ObjectNameNode) node;
return base.OnChildNode(node);
}
protected override ISqlNode OnChildNode(ISqlNode node)
{
if (node is SqlKeyNode) {
var keyNode = (SqlKeyNode) node;
if (String.Equals(keyNode.Text, "NULL", StringComparison.OrdinalIgnoreCase)) {
if (notSeen) {
ConstraintType = ConstraintTypeNames.NotNull;
} else {
ConstraintType = ConstraintTypeNames.Null;
}
} else if (String.Equals(keyNode.Text, "NOT", StringComparison.OrdinalIgnoreCase)) {
notSeen = true;
} else if (String.Equals(keyNode.Text, "REFERENCES", StringComparison.OrdinalIgnoreCase)) {
ConstraintType = ConstraintTypeNames.ForeignKey;
} else if (String.Equals(keyNode.Text, "CHECK", StringComparison.OrdinalIgnoreCase)) {
ConstraintType = ConstraintTypeNames.Check;
} else if (String.Equals(keyNode.Text, "PRIMARY", StringComparison.OrdinalIgnoreCase)) {
ConstraintType = ConstraintTypeNames.PrimaryKey;
} else if (String.Equals(keyNode.Text, "UNIQUE", StringComparison.OrdinalIgnoreCase)) {
ConstraintType = ConstraintTypeNames.UniqueKey;
}
} else if (node is IExpressionNode) {
CheckExpression = (IExpressionNode) node;
} else if (node is ObjectNameNode) {
if (!String.Equals(ConstraintType, ConstraintTypeNames.ForeignKey, StringComparison.OrdinalIgnoreCase))
throw new InvalidOperationException();
ReferencedTable = ((ObjectNameNode) node);
}
return base.OnChildNode(node);
}
/// <inheritdoc/>
protected override ISqlNode OnChildNode(ISqlNode node)
{
Reference = (ObjectNameNode)node;
return(base.OnChildNode(node));
}