C# Class Tiraggo.MySqlClientProvider.QueryBuilder

Afficher le fichier Open project: BrewDawg/Tiraggo

Méthodes publiques

Méthode	Description
PrepareCommand ( tgDataRequest request ) : MySqlCommand

Méthodes protégées

Méthode	Description
ApplyWhereSubOperations ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgComparison comparisonData ) : string
BuildQuery ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
BuildSubOperationsSql ( StandardProviderParameters std, string columnName, List subOperators ) : string
GetCaseWhenThenEnd ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgCase caseWhenThen ) : string
GetCastSql ( tgCastType castType ) : string
GetColumnName ( tgColumnItem column ) : string
GetComparisonStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query, List items, string prefix ) : string
GetExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgExpression expression, bool inExpression, bool useAlias ) : string
GetFromStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetGroupByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetJoinStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetMathmaticalExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgMathmaticalExpression mathmaticalExpression ) : string
GetMathmaticalExpressionLiteralType ( StandardProviderParameters std, tgMathmaticalExpression mathmaticalExpression ) : string
GetOrderByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetSelectStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
GetSetOperationStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
esArithmeticOperatorToString ( tgMathmaticalExpression mathmaticalExpression, bool &isConcat ) : string

Private Methods

Méthode	Description
GetSubquerySearchCondition ( tgDynamicQuerySerializable query ) : string
NextParamIndex ( IDbCommand cmd ) : int

Method Details

ApplyWhereSubOperations() protected static méthode

protected static ApplyWhereSubOperations ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgComparison comparisonData ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
comparisonData	Tiraggo.DynamicQuery.tgComparison
Résultat	string

BuildQuery() protected static méthode

protected static BuildQuery ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
Résultat	string

BuildSubOperationsSql() protected static méthode

protected static BuildSubOperationsSql ( StandardProviderParameters std, string columnName, List subOperators ) : string
std	StandardProviderParameters
columnName	string
subOperators	List
Résultat	string

GetCaseWhenThenEnd() protected static méthode

protected static GetCaseWhenThenEnd ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgCase caseWhenThen ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
caseWhenThen	Tiraggo.DynamicQuery.tgCase
Résultat	string

GetCastSql() protected static méthode

protected static GetCastSql ( tgCastType castType ) : string
castType	tgCastType
Résultat	string

GetColumnName() protected static méthode

protected static GetColumnName ( tgColumnItem column ) : string
column	Tiraggo.DynamicQuery.tgColumnItem
Résultat	string

GetComparisonStatement() protected static méthode

protected static GetComparisonStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query, List items, string prefix ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
items	List
prefix	string
Résultat	string

GetExpressionColumn() protected static méthode

protected static GetExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgExpression expression, bool inExpression, bool useAlias ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
expression	Tiraggo.DynamicQuery.tgExpression
inExpression	bool
useAlias	bool
Résultat	string

GetFromStatement() protected static méthode

protected static GetFromStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
Résultat	string

GetGroupByStatement() protected static méthode

protected static GetGroupByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
Résultat	string

GetJoinStatement() protected static méthode

protected static GetJoinStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
Résultat	string

GetMathmaticalExpressionColumn() protected static méthode

protected static GetMathmaticalExpressionColumn ( StandardProviderParameters std, tgDynamicQuerySerializable query, tgMathmaticalExpression mathmaticalExpression ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
mathmaticalExpression	Tiraggo.DynamicQuery.tgMathmaticalExpression
Résultat	string

GetMathmaticalExpressionLiteralType() protected static méthode

protected static GetMathmaticalExpressionLiteralType ( StandardProviderParameters std, tgMathmaticalExpression mathmaticalExpression ) : string
std	StandardProviderParameters
mathmaticalExpression	Tiraggo.DynamicQuery.tgMathmaticalExpression
Résultat	string

GetOrderByStatement() protected static méthode

protected static GetOrderByStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
Résultat	string

GetSelectStatement() protected static méthode

protected static GetSelectStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
Résultat	string

GetSetOperationStatement() protected static méthode

protected static GetSetOperationStatement ( StandardProviderParameters std, tgDynamicQuerySerializable query ) : string
std	StandardProviderParameters
query	tgDynamicQuerySerializable
Résultat	string

PrepareCommand() public static méthode

public static PrepareCommand ( tgDataRequest request ) : MySqlCommand
request	Tiraggo.Interfaces.tgDataRequest
Résultat	MySql.Data.MySqlClient.MySqlCommand

esArithmeticOperatorToString() protected static méthode

protected static esArithmeticOperatorToString ( tgMathmaticalExpression mathmaticalExpression, bool &isConcat ) : string
mathmaticalExpression	Tiraggo.DynamicQuery.tgMathmaticalExpression
isConcat	bool
Résultat	string