Class SIQLCommands

Contains all SIQL-Commands. If a command ends with _PREP, it is prepared for use with place-holders for using with string.format.

Inheritance

System.Object

SIQLCommands

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: SqlDotNet.Compiler

Assembly: SqlDotNet.dll

Syntax

public static class SIQLCommands

Fields

| Improve this Doc View Source

CALL_FUNCTION

Call a function

Declaration

public const string CALL_FUNCTION = "call"

Field Value

Type	Description
System.String

| Improve this Doc View Source

CALL_FUNCTION_PREP

CALL_FUNCTION .{0} {1} {0}: Call function type. for example f or _insert_into (internal example) {1}: Name of the function {2}: Parameter

Declaration

public const string CALL_FUNCTION_PREP = "call.{0} {1} ({2})"

Field Value

Type	Description
System.String

| Improve this Doc View Source

CURSOR_FILTER

Defines a cursor filter

Declaration

public const string CURSOR_FILTER = "filter"

Field Value

Type	Description
System.String

| Improve this Doc View Source

CURSOR_FILTER_PREP

CURSOR_FILTER {0} {0}: Cursor which will be filtered

Declaration

public const string CURSOR_FILTER_PREP = "filter {0}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

CURSOR_OPEN

Open a cursor for iterating over sources/values and generate results

Declaration

public const string CURSOR_OPEN = "ocur"

Field Value

Type	Description
System.String

| Improve this Doc View Source

CURSOR_OPEN_PREP

CURSOR_OPEN .{0} {1} ({2}) {0}: Cursor type, currently only table {1}: Name of the cursor. Should start with curx (x is the number) {2}: Name of possible return columns

Declaration

public const string CURSOR_OPEN_PREP = "ocur.{0} {1} ({2})"

Field Value

Type	Description
System.String

| Improve this Doc View Source

CURSOR_SOURCE

Defines the source, which fills the query based on the query type from ocur. Is only required if open cursor type is not none (first parameter)

Declaration

public const string CURSOR_SOURCE = "cursrc"

Field Value

Type	Description
System.String

| Improve this Doc View Source

CURSOR_SOURCE_PREP

CURSOR_SOURCE .{0} {1} {0}: Cursoe name {1}: Table name

Declaration

public const string CURSOR_SOURCE_PREP = "cursrc.{0} {1}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_ARGUMENT

Push from stack to argument stack

Declaration

public const string LOAD_ARGUMENT = "ldarg"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_ARGUMENT_PREP

LOAD_ARGUMENT .{0} {0}: Arugment number

Declaration

public const string LOAD_ARGUMENT_PREP = "ldarg.{0}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_COLUMN

Load column onto the stack

Declaration

public const string LOAD_COLUMN = "ldcol"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_COLUMN_PREP

LOAD_COLUMN {0} {0}: Full qualified column name

Declaration

public const string LOAD_COLUMN_PREP = "ldcol {0}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_CONST

Load a constant value onto the stack

Declaration

public const string LOAD_CONST = "ldc"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_CONST_PREP

LOAD_CONST with .{0} {1} {0}: Data type {1}: Value

Declaration

public const string LOAD_CONST_PREP = "ldc.{0} {1}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_PARAMETER

Load parameter onto the stack

Declaration

public const string LOAD_PARAMETER = "ldp"

Field Value

Type	Description
System.String

| Improve this Doc View Source

LOAD_PARAMETER_PREP

LOAD_PARAMETER {0} Load parameter onto the stack

Declaration

public const string LOAD_PARAMETER_PREP = "ldp {0}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_ADD

Add operator

Declaration

public const string OP_ADD = "add"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_AND

And boolean operator

Declaration

public const string OP_AND = "and"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_DIV

Divide operator

Declaration

public const string OP_DIV = "div"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_EQ

Equal boolean operator

Declaration

public const string OP_EQ = "eq"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_GT

Greater boolean operator

Declaration

public const string OP_GT = "gt"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_GTEQ

Greater-Equal boolean operator

Declaration

public const string OP_GTEQ = "gteq"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_MUL

Multiply operator

Declaration

public const string OP_MUL = "mul"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_OR

Or boolean operator

Declaration

public const string OP_OR = "or"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_SM

Smaller boolean operator

Declaration

public const string OP_SM = "sm"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_SMEQ

Smaller-Equal boolean operator

Declaration

public const string OP_SMEQ = "smeq"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_SUB

Subtract operator

Declaration

public const string OP_SUB = "sub"

Field Value

Type	Description
System.String

| Improve this Doc View Source

OP_UEQ

Unquel boolean operator

Declaration

public const string OP_UEQ = "ueq"

Field Value

Type	Description
System.String

| Improve this Doc View Source

RESULTSET_CREATE_ROW

Create a new row in a result set

Declaration

public const string RESULTSET_CREATE_ROW = "crow"

Field Value

Type	Description
System.String

| Improve this Doc View Source

RESULTSET_FILL

Defines a term which will be used to fill a result set

Declaration

public const string RESULTSET_FILL = "fresset"

Field Value

Type	Description
System.String

| Improve this Doc View Source

RESULTSET_FILL_PREP

RESULTSET_FILL.{0} (1) {0}: Name of the result set {1}: List of cursoers

Declaration

public const string RESULTSET_FILL_PREP = "fresset.{0} {1}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

RESULTSET_OPEN

Open a new result set, which will be filled e.g. by a cursor

Declaration

public const string RESULTSET_OPEN = "oresset"

Field Value

Type	Description
System.String

| Improve this Doc View Source

RESULTSET_OPEN_PREP

RESULTSET_OPEN {0} {0}: Name of the result-set. In general starts with resX (X is increasing number)

Declaration

public const string RESULTSET_OPEN_PREP = "oresset {0}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

RESULTSET_POP_TO_NEXT_COLUMN

Pop the value on the stack to the next column in the result-set

Declaration

public const string RESULTSET_POP_TO_NEXT_COLUMN = "pnxc"

Field Value

Type	Description
System.String

| Improve this Doc View Source

RESULTSET_POP_TO_NEXT_COLUMN_REP

RESULTSET_POP_TO_NEXT_COLUMN {0} {0}: Alias of the column

Declaration

public const string RESULTSET_POP_TO_NEXT_COLUMN_REP = "pnxc {0}"

Field Value

Type	Description
System.String

| Improve this Doc View Source

SIQL_TAG

Returns @siql is is the beginning of every siql "program"

Declaration

public const string SIQL_TAG = "@siql"

Field Value

Type	Description
System.String