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()

 

init()

 

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)

 

init(_ dateFormat: String, _ datetimeFormat: String, _ doubleQuoteStrings: Boolean, _ expressionGenerator: ISqlExpressionGenerator)

 

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)

 

func AddVariable(_ name: String) -> SqlMacroVariable

 

Function AddVariable(name As String) As SqlMacroVariable

Parameters:

  • name:

ClearMacros    (declared in SqlMacroProcessor)

 

method ClearMacros

 

void ClearMacros()

 

func ClearMacros()

 

Sub ClearMacros()

ClearVariables    (declared in SqlMacroProcessor)

 

method ClearVariables

 

void ClearVariables()

 

func ClearVariables()

 

Sub ClearVariables()

CustomMacroHandler    (declared in SqlMacroProcessor)

 

property CustomMacroHandler: SqlMacroCallback read write;

 

SqlMacroCallback CustomMacroHandler { get; set; }

 

var CustomMacroHandler: SqlMacroCallback { 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; }

 

var DateFormat: String { 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; }

 

var DateTimeFormat: String { 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; }

 

var DoubleQuoteStrings: Boolean { get{} }

 

ReadOnly Property DoubleQuoteStrings() As Boolean

EvalToken    (declared in SqlMacroProcessor)

 

method EvalToken(source: String): String

 

String EvalToken(String source)

 

func EvalToken(_ source: String) -> String

 

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 = ')

 

func Evaluate(_ source: String, _ delimiter: Char = ') -> String

 

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)

 

func FindVariable(_ name: String) -> SqlMacroVariable

 

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()

 

func GetNewInstance() -> ISqlMacroProcessor

 

Function GetNewInstance() As ISqlMacroProcessor

RegisterMacro    (declared in SqlMacroProcessor)

 

method RegisterMacro(macro: SqlMacroProcedure)

 

void RegisterMacro(SqlMacroProcedure macro)

 

func RegisterMacro(_ macro: SqlMacroProcedure)

 

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()

 

func RegisterMacros()

 

Sub RegisterMacros()

Session  protected    (declared in SqlMacroProcessor)

 

method Session(sessionValueName: String): String

 

String Session(String sessionValueName)

 

func Session(_ sessionValueName: String) -> String

 

Function Session(sessionValueName As String) As String

Parameters:

  • sessionValueName:

SqlExpressionGenerator    (declared in SqlMacroProcessor)

 

property SqlExpressionGenerator: ISqlExpressionGenerator read;

 

ISqlExpressionGenerator SqlExpressionGenerator { get; }

 

var SqlExpressionGenerator: ISqlExpressionGenerator { get{} }

 

ReadOnly Property SqlExpressionGenerator() As ISqlExpressionGenerator

TrimParametersProvider  protected    (declared in SqlMacroProcessor)

 

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

 

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

 

func TrimParametersProvider(_ args: IList<String>) -> IList<String>

 

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

Parameters:

  • args:

 

CustomMacroHandler    (declared in SqlMacroProcessor)

 

property CustomMacroHandler: SqlMacroCallback read write;

 

SqlMacroCallback CustomMacroHandler { get; set; }

 

var CustomMacroHandler: SqlMacroCallback { 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; }

 

var DateFormat: String { 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; }

 

var DateTimeFormat: String { 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; }

 

var DoubleQuoteStrings: Boolean { get{} }

 

ReadOnly Property DoubleQuoteStrings() As Boolean

SqlExpressionGenerator    (declared in SqlMacroProcessor)

 

property SqlExpressionGenerator: ISqlExpressionGenerator read;

 

ISqlExpressionGenerator SqlExpressionGenerator { get; }

 

var SqlExpressionGenerator: ISqlExpressionGenerator { get{} }

 

ReadOnly Property SqlExpressionGenerator() As ISqlExpressionGenerator

 

constructor

Creates a new instance of the MSSQL2005MacroProcessor class.

 

constructor

 

MSSQL2005MacroProcessor()

 

init()

 

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)

 

init(_ dateFormat: String, _ datetimeFormat: String, _ doubleQuoteStrings: Boolean, _ expressionGenerator: ISqlExpressionGenerator)

 

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)

 

func AddVariable(_ name: String) -> SqlMacroVariable

 

Function AddVariable(name As String) As SqlMacroVariable

Parameters:

  • name:

ClearMacros    (declared in SqlMacroProcessor)

 

method ClearMacros

 

void ClearMacros()

 

func ClearMacros()

 

Sub ClearMacros()

ClearVariables    (declared in SqlMacroProcessor)

 

method ClearVariables

 

void ClearVariables()

 

func ClearVariables()

 

Sub ClearVariables()

EvalToken    (declared in SqlMacroProcessor)

 

method EvalToken(source: String): String

 

String EvalToken(String source)

 

func EvalToken(_ source: String) -> String

 

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 = ')

 

func Evaluate(_ source: String, _ delimiter: Char = ') -> String

 

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)

 

func FindVariable(_ name: String) -> SqlMacroVariable

 

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()

 

func GetNewInstance() -> ISqlMacroProcessor

 

Function GetNewInstance() As ISqlMacroProcessor

RegisterMacro    (declared in SqlMacroProcessor)

 

method RegisterMacro(macro: SqlMacroProcedure)

 

void RegisterMacro(SqlMacroProcedure macro)

 

func RegisterMacro(_ macro: SqlMacroProcedure)

 

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()

 

func RegisterMacros()

 

Sub RegisterMacros()

Session  protected    (declared in SqlMacroProcessor)

 

method Session(sessionValueName: String): String

 

String Session(String sessionValueName)

 

func Session(_ sessionValueName: String) -> String

 

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)

 

func TrimParametersProvider(_ args: IList<String>) -> IList<String>

 

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

Parameters:

  • args: