MSSQL2005MacroProcessor

Overview

The MSSQL2005MacroProcessor class provides MS SQL 2005 specific definitions for SQL functions defined in the SqlMacroProcessor class.

The MSSQL2005MacroProcessor class does not actually override any macro-to-SQL methods of its ancestor, the MSSQLMacroProcessor class. It was introduced because MS SQL 2005 uses a separate connection profile which needs its own MacroProcessor definition.

Location

 

constructor

Creates a new instance of the MSSQL2005MacroProcessor class.

 

constructor

 

MSSQL2005MacroProcessor()

 

Sub New()

constructor (String, String, Boolean, ISqlExpressionGenerator)  protected    (declared in SqlMacroProcessor)

 

constructor(dateFormat: String; datetimeFormat: String; doubleQuoteStrings: Boolean; expressionGenerator: ISqlExpressionGenerator)

 

MSSQL2005MacroProcessor(String dateFormat, String datetimeFormat, Boolean doubleQuoteStrings, ISqlExpressionGenerator expressionGenerator)

 

Sub New(dateFormat As String, datetimeFormat As String, doubleQuoteStrings As Boolean, expressionGenerator As ISqlExpressionGenerator)

Parameters:

  • dateFormat:
  • datetimeFormat:
  • doubleQuoteStrings:
  • expressionGenerator:

AddVariable    (declared in SqlMacroProcessor)

 

method AddVariable(name: String): SqlMacroVariable

 

SqlMacroVariable AddVariable(String name)

 

Function AddVariable(name As String) As SqlMacroVariable

Parameters:

  • name:

ClearMacros    (declared in SqlMacroProcessor)

 

method ClearMacros

 

void ClearMacros()

 

Sub ClearMacros()

ClearVariables    (declared in SqlMacroProcessor)

 

method ClearVariables

 

void ClearVariables()

 

Sub ClearVariables()

CustomMacroHandler    (declared in SqlMacroProcessor)

 

property CustomMacroHandler: SqlMacroCallback read write;

 

SqlMacroCallback CustomMacroHandler { get; set; }

 

Property CustomMacroHandler() As SqlMacroCallback

DateFormat  protected    (declared in SqlMacroProcessor)

Gets the date format for the current database.

 

property DateFormat: String read;

 

String DateFormat { get; }

 

ReadOnly Property DateFormat() As String

DateTimeFormat  protected    (declared in SqlMacroProcessor)

Gets the datetime format for the current database.

 

property DateTimeFormat: String read;

 

String DateTimeFormat { get; }

 

ReadOnly Property DateTimeFormat() As String

DoubleQuoteStrings  protected    (declared in SqlMacroProcessor)

Gets the quote string for the date and datetime formats for the current database. If this property is true, the datetime format is represented as "datetime", otherwise as 'datetime'.

 

property DoubleQuoteStrings: Boolean read;

 

Boolean DoubleQuoteStrings { get; }

 

ReadOnly Property DoubleQuoteStrings() As Boolean

EvalToken    (declared in SqlMacroProcessor)

 

method EvalToken(source: String): String

 

String EvalToken(String source)

 

Function EvalToken(source As String) As String

Parameters:

  • source:

Evaluate    (declared in SqlMacroProcessor)

 

method Evaluate(source: String; delimiter: Char): String

 

String Evaluate(String source, Char delimiter)

 

Function Evaluate(source As String, delimiter As Char) As String

Parameters:

  • source:
  • delimiter:

FindVariable    (declared in SqlMacroProcessor)

 

method FindVariable(name: String): SqlMacroVariable

 

SqlMacroVariable FindVariable(String name)

 

Function FindVariable(name As String) As SqlMacroVariable

Parameters:

  • name:

GetNewInstance

Fabric method that creates a new instance of the MSSQL2005MacroProcessor class.

 

method GetNewInstance: ISqlMacroProcessor

 

ISqlMacroProcessor GetNewInstance()

 

Function GetNewInstance() As ISqlMacroProcessor

RegisterMacro    (declared in SqlMacroProcessor)

 

method RegisterMacro(macro: SqlMacroProcedure)

 

void RegisterMacro(SqlMacroProcedure macro)

 

Sub RegisterMacro(macro As SqlMacroProcedure)

Parameters:

  • macro:

RegisterMacros  protected    (declared in SqlMacroProcessor)

Registers the existing standard macros:

  • Date
  • DateTime
  • AddTime
  • FormatDateTime
  • FormatDate
  • Length
  • LowerCase
  • UpperCase
  • TrimLeft
  • TrimRight
  • Copy
  • NoLock

 

method RegisterMacros

 

void RegisterMacros()

 

Sub RegisterMacros()

Session  protected    (declared in SqlMacroProcessor)

 

method Session(sessionValueName: String): String

 

String Session(String sessionValueName)

 

Function Session(sessionValueName As String) As String

Parameters:

  • sessionValueName:

SqlExpressionGenerator    (declared in SqlMacroProcessor)

 

property SqlExpressionGenerator: ISqlExpressionGenerator read;

 

ISqlExpressionGenerator SqlExpressionGenerator { get; }

 

ReadOnly Property SqlExpressionGenerator() As ISqlExpressionGenerator

TrimParametersProvider  protected    (declared in SqlMacroProcessor)

 

method TrimParametersProvider(args: IList<String>): IList<String>

 

IList<String> TrimParametersProvider(IList<String> args)

 

Function TrimParametersProvider(args As IList<String>) As IList<String>

Parameters:

  • args:

 

CustomMacroHandler    (declared in SqlMacroProcessor)

 

property CustomMacroHandler: SqlMacroCallback read write;

 

SqlMacroCallback CustomMacroHandler { get; set; }

 

Property CustomMacroHandler() As SqlMacroCallback

DateFormat  protected    (declared in SqlMacroProcessor)

Gets the date format for the current database.

 

property DateFormat: String read;

 

String DateFormat { get; }

 

ReadOnly Property DateFormat() As String

DateTimeFormat  protected    (declared in SqlMacroProcessor)

Gets the datetime format for the current database.

 

property DateTimeFormat: String read;

 

String DateTimeFormat { get; }

 

ReadOnly Property DateTimeFormat() As String

DoubleQuoteStrings  protected    (declared in SqlMacroProcessor)

Gets the quote string for the date and datetime formats for the current database. If this property is true, the datetime format is represented as "datetime", otherwise as 'datetime'.

 

property DoubleQuoteStrings: Boolean read;

 

Boolean DoubleQuoteStrings { get; }

 

ReadOnly Property DoubleQuoteStrings() As Boolean

SqlExpressionGenerator    (declared in SqlMacroProcessor)

 

property SqlExpressionGenerator: ISqlExpressionGenerator read;

 

ISqlExpressionGenerator SqlExpressionGenerator { get; }

 

ReadOnly Property SqlExpressionGenerator() As ISqlExpressionGenerator

 

constructor

Creates a new instance of the MSSQL2005MacroProcessor class.

 

constructor

 

MSSQL2005MacroProcessor()

 

Sub New()

constructor (String, String, Boolean, ISqlExpressionGenerator)  protected    (declared in SqlMacroProcessor)

 

constructor(dateFormat: String; datetimeFormat: String; doubleQuoteStrings: Boolean; expressionGenerator: ISqlExpressionGenerator)

 

MSSQL2005MacroProcessor(String dateFormat, String datetimeFormat, Boolean doubleQuoteStrings, ISqlExpressionGenerator expressionGenerator)

 

Sub New(dateFormat As String, datetimeFormat As String, doubleQuoteStrings As Boolean, expressionGenerator As ISqlExpressionGenerator)

Parameters:

  • dateFormat:
  • datetimeFormat:
  • doubleQuoteStrings:
  • expressionGenerator:

AddVariable    (declared in SqlMacroProcessor)

 

method AddVariable(name: String): SqlMacroVariable

 

SqlMacroVariable AddVariable(String name)

 

Function AddVariable(name As String) As SqlMacroVariable

Parameters:

  • name:

ClearMacros    (declared in SqlMacroProcessor)

 

method ClearMacros

 

void ClearMacros()

 

Sub ClearMacros()

ClearVariables    (declared in SqlMacroProcessor)

 

method ClearVariables

 

void ClearVariables()

 

Sub ClearVariables()

EvalToken    (declared in SqlMacroProcessor)

 

method EvalToken(source: String): String

 

String EvalToken(String source)

 

Function EvalToken(source As String) As String

Parameters:

  • source:

Evaluate    (declared in SqlMacroProcessor)

 

method Evaluate(source: String; delimiter: Char): String

 

String Evaluate(String source, Char delimiter)

 

Function Evaluate(source As String, delimiter As Char) As String

Parameters:

  • source:
  • delimiter:

FindVariable    (declared in SqlMacroProcessor)

 

method FindVariable(name: String): SqlMacroVariable

 

SqlMacroVariable FindVariable(String name)

 

Function FindVariable(name As String) As SqlMacroVariable

Parameters:

  • name:

GetNewInstance

Fabric method that creates a new instance of the MSSQL2005MacroProcessor class.

 

method GetNewInstance: ISqlMacroProcessor

 

ISqlMacroProcessor GetNewInstance()

 

Function GetNewInstance() As ISqlMacroProcessor

RegisterMacro    (declared in SqlMacroProcessor)

 

method RegisterMacro(macro: SqlMacroProcedure)

 

void RegisterMacro(SqlMacroProcedure macro)

 

Sub RegisterMacro(macro As SqlMacroProcedure)

Parameters:

  • macro:

RegisterMacros  protected    (declared in SqlMacroProcessor)

Registers the existing standard macros:

  • Date
  • DateTime
  • AddTime
  • FormatDateTime
  • FormatDate
  • Length
  • LowerCase
  • UpperCase
  • TrimLeft
  • TrimRight
  • Copy
  • NoLock

 

method RegisterMacros

 

void RegisterMacros()

 

Sub RegisterMacros()

Session  protected    (declared in SqlMacroProcessor)

 

method Session(sessionValueName: String): String

 

String Session(String sessionValueName)

 

Function Session(sessionValueName As String) As String

Parameters:

  • sessionValueName:

TrimParametersProvider  protected    (declared in SqlMacroProcessor)

 

method TrimParametersProvider(args: IList<String>): IList<String>

 

IList<String> TrimParametersProvider(IList<String> args)

 

Function TrimParametersProvider(args As IList<String>) As IList<String>

Parameters:

  • args: