protected override ISqlNode OnChildNode(ISqlNode node) { if (node is ObjectNameNode) { TableName = ((ObjectNameNode)node).Name; } else if (node.NodeName == "column_set_list") { Columns = node.FindNodes <UpdateColumnNode>(); } else if (node.NodeName == "update_where") { WhereExpression = node.FindNode <IExpressionNode>(); } else if (node.NodeName == "limit_opt") { var child = node.FindNode <IntegerLiteralNode>(); if (child != null) { Limit = (int)child.Value; } } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName == "drop_procedure_trigger") { var idNode = node.FindNode <ObjectNameNode>(); if (idNode == null) { throw new SqlParseException("Could not find the name of the trigger to delete."); } TriggerName = idNode.Name; } else if (node.NodeName == "drop_callback_trigger") { CallbackTrigger = true; var tableNameNode = node.FindNode <ObjectNameNode>(); if (tableNameNode == null) { throw new SqlParseException("Could not find the name of the table in a DROP CALLBACK TRIGGER"); } TableName = tableNameNode.Name; } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node is ObjectNameNode) { SequenceName = ((ObjectNameNode)node).Name; } else if (node.NodeName.Equals("start_opt")) { StartWith = node.FindNode <IExpressionNode>(); } else if (node.NodeName.Equals("increment_opt")) { IncrementBy = node.FindNode <IExpressionNode>(); } else if (node.NodeName.Equals("minvalue_opt")) { MinValue = node.FindNode <IExpressionNode>(); } else if (node.NodeName.Equals("maxvalue_opt")) { MaxValue = node.FindNode <IExpressionNode>(); } else if (node.NodeName.Equals("cycle_opt")) { Cycle = node.ChildNodes.Any(); } else if (node.NodeName.Equals("cache_opt")) { Cache = node.FindNode <IExpressionNode>(); } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("label_opt")) { Label = node.FindNode<StringLiteralNode>().Value; } else if (node.NodeName.Equals("when_opt")) { WhenExpression = node.FindNode<IExpressionNode>(); } return base.OnChildNode(node); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("label_opt")) { Label = node.FindNode<IdentifierNode>().Text; } else if (node.NodeName.Equals("when_opt")) { WhenExpression = node.FindNode<IExpressionNode>(); } return base.OnChildNode(node); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("label_opt")) { Label = node.FindNode <IdentifierNode>().Text; } else if (node.NodeName.Equals("when_opt")) { WhenExpression = node.FindNode <IExpressionNode>(); } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("label_opt")) { Label = node.FindNode <StringLiteralNode>().Value; } else if (node.NodeName.Equals("when_opt")) { WhenExpression = node.FindNode <IExpressionNode>(); } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node is ObjectNameNode) { TableName = ((ObjectNameNode) node).Name; } else if (node.NodeName == "column_set_list") { Columns = node.FindNodes<UpdateColumnNode>(); } else if (node.NodeName == "update_where") { WhereExpression = node.FindNode<IExpressionNode>(); } else if (node.NodeName == "limit_opt") { var child = node.FindNode<IntegerLiteralNode>(); if (child != null) Limit = (int) child.Value; } return base.OnChildNode(node); }
/// <inheritdoc/> protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName == "join_type") { GetJoinType(node); } else if (node is IFromSourceNode) { Source = (IFromSourceNode)node; } else if (node.NodeName == "from_source") { Source = (IFromSourceNode)node.ChildNodes.FirstOrDefault(); } else if (node.NodeName == "on_opt") { OnExpression = node.FindNode <IExpressionNode>(); } else if (node.NodeName == "join_opt") { var join = node.ChildNodes.FirstOrDefault(); if (join != null) { NextJoin = (JoinNode)join; } } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node is ObjectNameNode) { TableName = ((ObjectNameNode) node).Name; } else if (node.NodeName.Equals("insert_source")) { var colNode = node.FindByName("column_list_opt"); if (colNode != null) ColumnNames = colNode.FindNodes<IdentifierNode>().Select(x => x.Text); ValuesInsert = node.FindNode<ValuesInsertNode>(); SetInsert = node.FindNode<SetInsertNode>(); QueryInsert = node.FindNode<QueryInsertNode>(); } return base.OnChildNode(node); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("exception_name_opt")) ExceptionName = node.FindNode<IdentifierNode>().Text; return base.OnChildNode(node); }
private void GetFromCursor(ISqlNode node) { var idNode = node.FindNode<IdentifierNode>(); if (idNode != null) { FromCursor = true; CursorName = idNode.Text; } }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("exception_name_opt")) { ExceptionName = node.FindNode <IdentifierNode>().Text; } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node is IdentifierNode) { UserName = ((IdentifierNode) node).Text; } else if (node.NodeName.Equals("identified")) { Identificator = node.FindNode<IUserIdentificatorNode>(); } return base.OnChildNode(node); }
private void GetFromCursor(ISqlNode node) { var idNode = node.FindNode <IdentifierNode>(); if (idNode != null) { FromCursor = true; CursorName = idNode.Text; } }
private void GetUserType(ISqlNode node) { IsPrimitive = false; TypeName = node.FindNode <ObjectNameNode>().Name; var optMetaList = node.FindByName("user_type_meta_opt"); if (optMetaList != null) { GetMeta(optMetaList.ChildNodes.FirstOrDefault()); } }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node is ObjectNameNode) { SequenceName = ((ObjectNameNode) node).Name; } else if (node.NodeName.Equals("start_opt")) { StartWith = node.FindNode<IExpressionNode>(); } else if (node.NodeName.Equals("increment_opt")) { IncrementBy = node.FindNode<IExpressionNode>(); } else if (node.NodeName.Equals("minvalue_opt")) { MinValue = node.FindNode<IExpressionNode>(); } else if (node.NodeName.Equals("maxvalue_opt")) { MaxValue = node.FindNode<IExpressionNode>(); } else if (node.NodeName.Equals("cycle_opt")) { Cycle = node.ChildNodes.Any(); } else if (node.NodeName.Equals("cache_opt")) { Cache = node.FindNode<IExpressionNode>(); } return base.OnChildNode(node); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName == "drop_procedure_trigger") { var idNode = node.FindNode<ObjectNameNode>(); if (idNode == null) throw new SqlParseException("Could not find the name of the trigger to delete."); TriggerName = idNode.Name; } else if (node.NodeName == "drop_callback_trigger") { CallbackTrigger = true; var tableNameNode = node.FindNode<ObjectNameNode>(); if (tableNameNode == null) throw new SqlParseException("Could not find the name of the table in a DROP CALLBACK TRIGGER"); TableName = tableNameNode.Name; } return base.OnChildNode(node); }
public static TNode FindNode <TNode>(this ISqlNode node) where TNode : class, ISqlNode { var foundNode = node.FindNode(typeof(TNode)); if (foundNode == null) { return(null); } return((TNode)foundNode); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node is ObjectNameNode) { TableName = ((ObjectNameNode)node).Name; } else if (node.NodeName.Equals("insert_source")) { var colNode = node.FindByName("column_list_opt"); if (colNode != null) { ColumnNames = colNode.FindNodes <IdentifierNode>().Select(x => x.Text); } ValuesInsert = node.FindNode <ValuesInsertNode>(); SetInsert = node.FindNode <SetInsertNode>(); QueryInsert = node.FindNode <QueryInsertNode>(); } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node is IdentifierNode) { UserName = ((IdentifierNode)node).Text; } else if (node.NodeName.Equals("identified")) { Identificator = node.FindNode <IUserIdentificatorNode>(); } return(base.OnChildNode(node)); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("plsql_label_opt")) { var labelNode = node.FindNode<LabelNode>(); if (labelNode != null) Label = labelNode.Text; } else if (node.NodeName.Equals("declare_statement_opt")) { Declarations = node.FindNodes<IDeclareNode>(); } else if (node is PlSqlCodeBlockNode) { CodeBlock = (PlSqlCodeBlockNode) node; } return base.OnChildNode(node); }
protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName.Equals("plsql_label_opt")) { var labelNode = node.FindNode <LabelNode>(); if (labelNode != null) { Label = labelNode.Text; } } else if (node.NodeName.Equals("declare_statement_opt")) { Declarations = node.FindNodes <IDeclareNode>(); } else if (node is PlSqlCodeBlockNode) { CodeBlock = (PlSqlCodeBlockNode)node; } return(base.OnChildNode(node)); }
/// <inheritdoc/> protected override ISqlNode OnChildNode(ISqlNode node) { if (node.NodeName == "join_type") { GetJoinType(node); } else if (node is IFromSourceNode) { Source = (IFromSourceNode) node; } else if (node.NodeName == "from_source") { Source = (IFromSourceNode) node.ChildNodes.FirstOrDefault(); } else if (node.NodeName == "on_opt") { OnExpression = node.FindNode<IExpressionNode>(); } else if (node.NodeName == "join_opt") { var join = node.ChildNodes.FirstOrDefault(); if (join != null) NextJoin = (JoinNode) join; } return base.OnChildNode(node); }
private void GetUserType(ISqlNode node) { IsPrimitive = false; TypeName = node.FindNode<ObjectNameNode>().Name; var optMetaList = node.FindByName("user_type_meta_opt"); if (optMetaList != null) { GetMeta(optMetaList.ChildNodes.FirstOrDefault()); } }