DeveelDB  20151217
complete SQL database system, primarly developed for .NET/Mono frameworks
OrderByNode.cs
Go to the documentation of this file.
1 //
2 // Copyright 2010-2015 Deveel
3 //
4 // Licensed under the Apache License, Version 2.0 (the "License");
5 // you may not use this file except in compliance with the License.
6 // You may obtain a copy of the License at
7 //
8 // http://www.apache.org/licenses/LICENSE-2.0
9 //
10 // Unless required by applicable law or agreed to in writing, software
11 // distributed under the License is distributed on an "AS IS" BASIS,
12 // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
13 // See the License for the specific language governing permissions and
14 // limitations under the License.
15 //
16 
17 using System;
18 using System.Linq;
19 
20 namespace Deveel.Data.Sql.Parser {
25  class OrderByNode : SqlNode {
26  internal OrderByNode() {
27  }
28 
32  public IExpressionNode Expression { get; private set; }
33 
38  public bool Ascending { get; private set; }
39 
41  protected override ISqlNode OnChildNode(ISqlNode node) {
42  if (node.NodeName == "sql_reference_expression") {
43  Expression = (IExpressionNode) node;
44  } else if (node.NodeName == "sql_expression") {
45  Expression = (IExpressionNode) node;
46  } else if (node.NodeName == "sort_order") {
47  GetOrder(node);
48  }
49 
50  return base.OnChildNode(node);
51  }
52 
53  private void GetOrder(ISqlNode node) {
54  var child = node.ChildNodes.FirstOrDefault();
55  if (child is SqlKeyNode) {
56  var keyNode = (SqlKeyNode) child;
57  if (String.Equals(keyNode.Text, "ASC", StringComparison.OrdinalIgnoreCase)) {
58  Ascending = true;
59  } else if (String.Equals(keyNode.Text, "DESC", StringComparison.OrdinalIgnoreCase)) {
60  Ascending = false;
61  }
62  }
63  }
64  }
65 }
Within an SQL query node, this describes the ordering criteria that will be applied when returning th...
Definition: OrderByNode.cs:25
Defines the contract for nodes in an AST model for a SQL grammar analysis and parsing.
Definition: ISqlNode.cs:25
Represents a keyword found during the compilation of a source text.
Definition: SqlKeyNode.cs:25
string NodeName
Gets the name of the node analyzed from the parser.
Definition: ISqlNode.cs:29
void GetOrder(ISqlNode node)
Definition: OrderByNode.cs:53
IEnumerable< ISqlNode > ChildNodes
Gets a read-only enumeration of the children nodes, if any.
Definition: ISqlNode.cs:39
override ISqlNode OnChildNode(ISqlNode node)
During the initialization of the node from the parser, this method is called for every child node add...
Definition: OrderByNode.cs:41
This interface acts like a marker that indicates if a ISqlNode represents a SQL expression.
The default implementation of ISqlNode, that is a node in the text analysis parsing of SQL commands...
Definition: SqlNode.cs:32