\Lqdt\OrmJson\Database\DriverDatFieldMysql

queryTranslator()

queryTranslator(  $type) 

Parameters

prepare()

prepare(  $query) 

Parameters

_joinedFieldsConverter()

_joinedFieldsConverter(array  $joints, \Cake\Database\Query  $query) 

Parameters

_removeOrderingFields()

_removeOrderingFields(  $row, array  $aliases) 

Parameters

_registerDatFieldForSorting()

_registerDatFieldForSorting(\Lqdt\OrmJson\Database\Dialect\string  $datfield, \Lqdt\OrmJson\Database\Dialect\string  $model, array  $aliases, \Cake\Database\Query  $query) 

Parameters

_orderedFieldsConverter()

_orderedFieldsConverter(\Cake\Database\Expression\OrderByExpression  $order, \Cake\Database\Query  $query) 

Parameters

_decorateSelectedDatFields()

_decorateSelectedDatFields(array  $row, array  $filteredFields) 

Parameters

_decorateExtractedDatFields()

_decorateExtractedDatFields(  $row, \Lqdt\OrmJson\Database\Dialect\string  $separator, \Lqdt\OrmJson\Database\Dialect\bool  $keepNestedOnExtract) 

Parameters

_selectRegularField()

_selectRegularField(\Lqdt\OrmJson\Database\Dialect\string  $field, \Lqdt\OrmJson\Database\Dialect\string  $alias, array  $fields) 

Parameters

_selectDatField()

_selectDatField(\Lqdt\OrmJson\Database\Dialect\string  $datfield, array  $fields, array  $filteredFields, \Cake\Database\Query  $query) 

Parameters

_extractDatField()

_extractDatField(\Lqdt\OrmJson\Database\Dialect\string  $datfield, \Lqdt\OrmJson\Database\Dialect\string  $alias, array  $fields, \Cake\Database\Query  $query) 

Parameters

_selectedFieldsConverter()

_selectedFieldsConverter(array  $fields, \Cake\Database\Query  $query) 

Parameters

_filtersConverter()

_filtersConverter(string|\Cake\Database\ExpressionInterface  $expression, \Cake\Database\Query  $query) 

Returns the appropriate ExpressionInterface regarding the incoming one

Parameters

_rawSqlConverter()

_rawSqlConverter(string  $expression, \Cake\Database\Query  $query) : \Cake\Database\Expression\QueryExpression

Returns a new QueryExpression built upon the parsing of the expression to update datfield names

Parameters

Returns

QueryExpression

_comparisonConverter()

_comparisonConverter(\Cake\Database\Expression\Comparison  $expression, \Cake\Database\Query  $query) : \Cake\Database\Expression\Comparison|\Cake\Database\Expression\QueryExpression

Update or replace the Comparison expression to perform comparisons on datFields. In some cases, PDO limitations implies to replace the expression with a raw SQL fragment. It can be a bit dangerous when using raw user input to perform global matching in `array` mode.

Regular fields expressions are left as is.

Parameters

Returns

Updated expression

_unaryExpressionConverter()

_unaryExpressionConverter(\Cake\Database\Expression\UnaryExpression  $expression, \Cake\Database\Query  $query) : \Cake\Database\Expression\UnaryExpression

Parses the unary expression to apply conversions on childrens and returns an updated UnaryExpression

Note : This a VERY hacky way because the UnaryExpression class doesn't expose getter/setter for protected _value property.

In this implementation, it causes an infinite loop when used directly with a SQL fragment :

['NOT' => 'sub.prop@datfield like "%buggy%"]

That's why, an exception is thrown as soon as $value is extracted

Parameters

Returns

New expression

_queryExpressionConverter()

_queryExpressionConverter(\Cake\Database\Expression\QueryExpression  $expression, \Cake\Database\Query  $query) : \Cake\Database\Expression\QueryExpression

Iterates over a QueryExpression and replace Comparison expressions to handle JSON comparison in datfields.

Parameters

Returns

Updated QueryExpression

_removeAliasesFromConditions()

_removeAliasesFromConditions(  $query) 

We need to override this method from SqlDialectTrait as it breaks apart datfields with delete

Parameters