DeveelDB  20151217
complete SQL database system, primarly developed for .NET/Mono frameworks
Classes | Enumerations
Deveel.Data.Sql.Expressions Namespace Reference

Classes

class  AggregateChecker
 
class  ConstantVisitor
 
class  EvaluateContext
 Encapsulates the elements needed to evaluate an SqlExpression More...
 
class  ExpressionEvaluateException
 An error occurring while evaluating an SqlExpression. More...
 
class  ExpressionEvaluatorVisitor
 
class  ExpressionStringBuilder
 
class  FromClause
 A container for the FROM clause of a select statement. More...
 
class  FromTable
 Describes a single table declaration in the from clause of a table expression (SELECT). More...
 
interface  IExpressionPreparer
 An interface used to prepare a SqlExpression object. More...
 
interface  IPreparable
 A contract for objects that participate to a SqlExpression.Prepare phase of an expression evaluation. More...
 
class  JoinPart
 
class  PreparerVisitor
 
class  QueryReferenceExpression
 
class  ReturnTypeVisitor
 
class  SelectColumn
 Represents a column selected to be in the output of a select statement. More...
 
class  SqlAssignExpression
 
class  SqlBetweenEspressionTests
 
class  SqlBinaryExpression
 
class  SqlBinaryExpressionTests
 
class  SqlCastExpression
 An SqlExpression that will cast a value retrieved by the evaluation of another expression into a given SQL data type. More...
 
class  SqlCastExpressionTests
 
class  SqlConditionalExpression
 
class  SqlConstantExpression
 An expression that holds a constant value. More...
 
class  SqlDateExpressionTests
 
class  SqlExpression
 Defines the base class for instances that represent SQL expression tree nodes. More...
 
class  SqlExpressionException
 
class  SqlExpressionExtensions
 Extension methods to SqlExpression More...
 
class  SqlExpressionParseException
 
class  SqlExpressionSerializers
 
class  SqlExpressionTypeExtensions
 
class  SqlExpressionVisitor
 A visitor for SqlExpression objects. More...
 
class  SqlFunctionCallExpression
 
class  SqlFunctionCallExpressionTests
 
class  SqlQueryBuilder
 
class  SqlQueryExpression
 
class  SqlQueryExpressionTests
 
class  SqlReferenceExpression
 An expression that references an object within a context. More...
 
class  SqlTupleExpression
 
class  SqlUnaryExpression
 Handles expressions computed against an unary operator. More...
 
class  SqlUnaryExpressionTests
 
class  SqlVariableReferenceExpression
 

Enumerations

enum  ExpressionErrorCodes : int {
  ExpressionErrorCodes.Unknown = 0x450000, ExpressionErrorCodes.EvaluateError = 0x06770440, ExpressionErrorCodes.UnableToReduce = 0x03999400, ExpressionErrorCodes.VariableNotFound = 0x03004003,
  ExpressionErrorCodes.CannotParse = 0x08778290
}
 Lists all the codes of errors in the expressions domain More...
 
enum  JoinType {
  JoinType.Inner = 1, JoinType.Left = 2, JoinType.Right = 3, JoinType.Full = 4,
  JoinType.None = -1
}
 Enumerates the kind of group join in a selection query. More...
 
enum  SqlExpressionType {
  SqlExpressionType.Constant, SqlExpressionType.FunctionCall, SqlExpressionType.Cast, SqlExpressionType.Conditional,
  SqlExpressionType.And, SqlExpressionType.Or, SqlExpressionType.XOr, SqlExpressionType.AnyEqual,
  SqlExpressionType.AnyNotEqual, SqlExpressionType.AnyGreaterThan, SqlExpressionType.AnyGreaterOrEqualThan, SqlExpressionType.AnySmallerThan,
  SqlExpressionType.AnySmallerOrEqualThan, SqlExpressionType.AllEqual, SqlExpressionType.AllNotEqual, SqlExpressionType.AllGreaterThan,
  SqlExpressionType.AllGreaterOrEqualThan, SqlExpressionType.AllSmallerThan, SqlExpressionType.AllSmallerOrEqualThan, SqlExpressionType.Add,
  SqlExpressionType.Subtract, SqlExpressionType.Multiply, SqlExpressionType.Divide, SqlExpressionType.Modulo,
  SqlExpressionType.Equal, SqlExpressionType.NotEqual, SqlExpressionType.Is, SqlExpressionType.IsNot,
  SqlExpressionType.SmallerThan, SqlExpressionType.GreaterThan, SqlExpressionType.SmallerOrEqualThan, SqlExpressionType.GreaterOrEqualThan,
  SqlExpressionType.Like, SqlExpressionType.NotLike, SqlExpressionType.Not, SqlExpressionType.UnaryPlus,
  SqlExpressionType.Negate, SqlExpressionType.Reference, SqlExpressionType.VariableReference, SqlExpressionType.Assign,
  SqlExpressionType.Tuple, SqlExpressionType.Query
}
 All the possible type of SqlExpression supported More...
 

Enumeration Type Documentation

Lists all the codes of errors in the expressions domain

Enumerator
Unknown 

An unknown error that was not handled.

EvaluateError 

An error occurred while evaluating the expression.

UnableToReduce 

The evaluator was not able to reduce the expression to a simpler form.

VariableNotFound 

A variable defined in a SqlReferenceExpression was not found within the execution context.

CannotParse 

The expression parser could not parse a given input string

Definition at line 23 of file ExpressionErrorCodes.cs.

23  : int {
27  Unknown = 0x450000,
28 
32  EvaluateError = 0x06770440,
33 
38  UnableToReduce = 0x03999400,
39 
44  VariableNotFound = 0x03004003,
45 
49  CannotParse = 0x08778290
50  }
An error occurred while evaluating the expression.
The evaluator was not able to reduce the expression to a simpler form.
The expression parser could not parse a given input string
An unknown error that was not handled.
A variable defined in a SqlReferenceExpression was not found within the execution context...

Enumerates the kind of group join in a selection query.

Enumerator
Inner 

A join that requires both sources joined to have matching records.

Left 

Returns all the records in the left side of the join, even if the other side has no corresponding records.

Right 

Returns all the records in the right side of the join, even if the other side has no corresponding records.

Full 
None 

Defaults to the natural join between two sources.

Definition at line 23 of file JoinType.cs.

23  {
28  Inner = 1,
29 
34  Left = 2,
35 
40  Right = 3,
41 
45  Full = 4,
46 
50  None = -1,
51  }
Returns all the records in the left side of the join, even if the other side has no corresponding rec...
Returns all the records in the right side of the join, even if the other side has no corresponding re...
A join that requires both sources joined to have matching records.

All the possible type of SqlExpression supported

Enumerator
Constant 

Represents an expression which has a constant value

See also
SqlConstantExpression
FunctionCall 
Cast 
Conditional 
And 
Or 
XOr 
AnyEqual 
AnyNotEqual 
AnyGreaterThan 
AnyGreaterOrEqualThan 
AnySmallerThan 
AnySmallerOrEqualThan 
AllEqual 
AllNotEqual 
AllGreaterThan 
AllGreaterOrEqualThan 
AllSmallerThan 
AllSmallerOrEqualThan 
Add 
Subtract 
Multiply 
Divide 
Modulo 
Equal 
NotEqual 
Is 
IsNot 
SmallerThan 
GreaterThan 
SmallerOrEqualThan 
GreaterOrEqualThan 
Like 
NotLike 
Not 
UnaryPlus 
Negate 
Reference 

An expression that references an object on the database (that is a Column, Table, Sequence, another database object).

VariableReference 

References a variable in a context.

Assign 

A variable or reference assignment expression.

Tuple 
Query 

A query to the database to select data from a set of tables and columns.

Definition at line 23 of file SqlExpressionType.cs.

23  {
28  Constant,
29 
31  Cast,
33 
34  // Logical / Conditional Binary
35  And,
36  Or,
37  XOr,
38 
39  // Sub-query
40  AnyEqual,
46 
47  AllEqual,
53 
54  // Multiplicative Binary
55  Add,
56  Subtract,
57  Multiply,
58  Divide,
59  Modulo,
60 
61  // Comparison Binary
62  Equal,
63  NotEqual,
64  Is,
65  IsNot,
70  Like,
71  NotLike,
72 
73  // Unary
74  Not,
75  UnaryPlus,
76  Negate,
77 
82  Reference,
83 
88 
92  Assign,
93  Tuple,
94 
99  Query,
100  }
A query to the database to select data from a set of tables and columns.
Represents an expression which has a constant value
An expression that references an object on the database (that is a Column, Table, Sequence...
A variable or reference assignment expression.