SqlHelper

SqlHelper abstract class is used to handle database. Specific classes used to generate SQL queries and inheriting this class help generate individual queries without employing syntax of specific database.

Methods included into this class result in a database string.

Queries to the following namespace:

Returns instance of a descendant from Entity that matches database type.

Method	Description	Available from version
construct	Method - constructor
addSecondsToDateTime	Returns SQL function for adding seconds to the specified time interval.	14.0.0
castToChar	Returns CAST expression for converted field or string expression.	16.0.10
convertFromDb	Returns parameter value converted to required type.	14.5.2
convertToDb	Converts value to the string corresponding to the column type used in SQL query.	14.5.2
formatDate	Returns database statement for conversion	14.0.0
forSql	Escapes special characters in a string for use in a SQL statement.
getAliasLength	Returns maximum length of an alias in a sel ect statement.	14.0.0
getAscendingOrder	Returns ascending order specifier.	14.5.0
getCharToDateFunction	Returns function for converting string value into datetime.	14.0.18
getColumnTypeByField	Returns a column type according to ScalarField object.	14.5.2
getConcatFunction	Returns function for concatenating database fields or expressions.
getConverter	Returns callback to be called for a field value on fetch.	15.0.1
getCurrentDateFunction	Returns SQL function for getting current date only.
getCurrentDateTimeFunction	Returns SQL function for getting current time.
getDatetimeToDateFunction	Returns SQL function passing datetime database value.
getDateToCharFunction	Returns SQL function for converting database fields and expressions into string.	14.0.18
getDescendingOrder	Returns descending order.	14.5.0
getFieldByColumnType	Returns descendant exception fr om `Entity\ScalarField` that matches the database type.	14.5.2
getIsNullFunction	Returns SQL function for checking database fields and statements against NULL value.
getLeftQuote	Returns an identificator escaping left character.	14.0.0
getLengthFunction	Returns SQL function for getting length of database field or expression.
getQueryDelimiter	Returns database specific query delimiter for batch processing..
getRightQuote	Returns an identificator escaping right character.	14.0.0
getSubstrFunction	Returns SQL function for getting part of string.
getTopSql	Transforms SQL query according to specified parameter values.	14.0.0
prepareAssignment	Builds a string for assigning SQL statement to the specified column.	14.0.0
prepareInsert	Builds string for SQL INSERT command for the specified table.
prepareMerge	Builds string for SQL MERGE command for the specified table.	15.5.0
prepareUpdate	Builds string for SQL UPDATE command for the specified table.
quote	Returns quoted identifier.	14.0.0
softCastTextToChar	Return expression for text field used when grouping or sorting.	16.5.7