• Главная
• lithium
• data
• source
• Database

PHP Класс lithium\data\source\Database

Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство	Тип	Описание
$connection	PD\PDO	Holds the current connection.

Защищенные свойства (Protected)

Свойство	Тип	Описание
$_cachedNames	array	Holds cached names.
$_classes	array	Classes used by Database.
$_columns	array	The supported column types and their default values
$_constraintTypes
$_operators	array	List of SQL operators, paired with handling options.
$_quotes	array	A pair of opening/closing quote characters used for quoting identifiers in SQL queries.
$_strategies	array	Array of named callable objects representing different strategies for performing specific types of queries.
$_strings	array	Strings used to render the given statement

Открытые методы

Метод	Описание
__construct ( array $config = [] ) : void	Constructor.
alias ( $alias, $context )
applyStrategy ( array $options, object $context )	Applying a strategy to a lithium\data\model\Query object
calculation ( string $type, mixed $query, array $options = [] ) : integer | null	Executes calculation-related queries, such as those required for count and other aggregates.
cast ( $entity, array $data, array $options = [] )
column ( $field ) : string	Generate a database-native column schema string
comment ( string $comment ) : string	Adds formatting to SQL comments before they're embedded in queries.
conditions ( string | array $conditions, object $context, array $options = [] ) : string	Returns a string of formatted conditions to be inserted into the query statement. If the query conditions are defined as an array, key pairs are converted to SQL strings.
connect ( ) : boolean	Connects to the database by creating a PDO intance using the constructed DSN string.
constraints ( string | array $constraints, Query $context, array $options = [] ) : string	Returns a string of formatted constraints to be inserted into the query statement.
create ( object $query, array $options = [] ) : boolean	Inserts a new record into the database based on a the Query. The record is updated with the id of the insert.
createSchema ( string $source, object $schema ) : boolean	Create a database-native schema
delete ( object $query, array $options = [] ) : boolean	Deletes a record in the database based on the given Query.
disconnect ( ) : boolean	Disconnects the adapter from the database.
dropSchema ( string $source, boolean $soft = true ) : boolean	Drops a table.
encoding ( mixed $encoding = null ) : mixed.	Getter/Setter for the connection's encoding Abstract. Must be defined by child class.
error ( )	Return the last errors produced by a the execution of a query.
fields ( array $fields, object $context ) : string	Returns a string of formatted fields to be inserted into the query statement.
group ( string | array $group, object $context ) : string | null	Return formatted clause for GROUP BY with known fields escaped.
having ( string | array $conditions, object $context, array $options = [] ) : string	Returns a string of formatted havings to be inserted into the query statement. If the query havings are defined as an array, key pairs are converted to SQL strings.
join ( object $context, object $rel, string $fromAlias = null, string $toAlias = null, mixed $constraints = [] )	Set a query's join according a Relationship.
joins ( array $joins, Query $context ) : string	Returns a join statement for given array of query objects
limit ( integer $limit, Query $context ) : string	Returns a LIMIT statement from the given limit and the offset of the context object.
methods ( ) : array	Determines the set of methods to be used when exporting query values.
name ( string $name ) : string	Field name handler to ensure proper escaping.
on ( object $rel, $aliasFrom = null, $aliasTo = null, array $constraints = [] ) : array	Build the ON constraints from a Relationship instance
order ( string | array $order, object $context ) : string | null	Return formatted clause for ORDER BY with known fields escaped and directions normalized to uppercase. When order direction is missing or unrecognized defaults to ASC.
read ( string | object $query, array $options = [] ) : mixed	Reads records from a database using a lithium\data\model\Query object or raw SQL string.
relationship ( string $class, string $type, string $name, array $config = [] ) : array	Defines or modifies the default settings of a relationship between two models.
renderCommand ( string $type, string $data = null, string $context = null ) : string	Returns a given type statement for the given data, rendered from Database::$_strings.
schema ( Query $query, Result | null $resource = null, object | null $context = null ) : array	Builds an array of keyed on the fully-namespaced Model with array of fields as values for the given Query
update ( object $query, array $options = [] ) : boolean	Updates a record in the database based on the given Query.
value ( mixed $value, array $schema = [] ) : mixed	Converts a given value into the proper type based on a given schema definition.

Защищенные методы

Метод	Описание
_aliasing ( string $name, string $alias, array $map = [] ) : string	Helper which add an alias basename to a field name if necessary
_buildConstraints ( array $constraints, type $schema = null, type $joiner = ' ', $primary = false ) : string	Helper for building columns constraints
_buildMetas ( $type, array $metas, array $names = null, type $joiner = ' ' ) : string	Helper for building columns metas
_cast ( string $type, string $value, array $column, array $schema = [] ) : mixed	Cast a value according to a column type, used by Database::value().
_conditions ( string | array $conditions, object $context, array $options = [] ) : string	Returns a string of formatted conditions to be inserted into the query statement.
_constraint ( string $name, mixed $value, object $schema = null ) : string	Build a SQL column constraint
_constraints ( array $constraints ) : array	Auto escape string value to a field name value
_createFields ( array $data, array $schema, object $context ) : array	Renders the fields part for _create_ queries.
_entityName ( string $entity, array $options = [] ) : string	Returns a fully-qualified table name (i.e. with prefix), quoted.
_error ( string $sql )	Throw a QueryException error
_execute ( string $sql ) : Result	Execute a given query Abstract. Must be defined by child class.
_fieldName ( string $field ) : string	Return the field name from a conditions key.
_fields ( array $fields, object $context ) : array	Reformats fields to be alias based.
_fieldsQuote ( string $alias, string $field ) : string	Quotes fields, also handles aliased fields.
_fieldsReturn ( string $type, object $context, array $fields, array $schema ) : string | array	Renders the fields SQL fragment for queries.
_formatters ( ) : array	Provide an associative array of Closures to be used as the 'formatter' key inside of the Database::$_columns specification. Each Closure should return the appropriately quoted or unquoted value and accept one or two parameters: $format, the format to apply to value and $value, the value to be formatted.
_init ( )	Initializer. Initializes properties like Database::$_strategies because closures cannot be created within the class definition.
_insertId ( $query ) : void	Get the last insert id from the database.
_introspectType ( mixed $value ) : string	Attempts to automatically determine the column type of a value. Used by the value() method of various database adapters to determine how to prepare a value if the schema is not specified.
_meta ( string $type, string $name, mixed $value ) : string	Build a SQL column/table meta.
_on ( array $constraints, $aliasFrom, $aliasTo, $mapAlias = [] )
_operator ( string $key, mixed $value, array $schema = [], array $options = [] ) : string	Handles conversion of SQL operator keys to SQL statements.
_processConditions ( $key, $value, $context, $schema = null, $glue = 'AND' )
_processOperator ( $key, $value, $fieldMeta, $glue ) : mixed	Helper method used by _processConditions.
_queryExport ( object $query ) : array	Helper method for Database::read() to export query while handling additional joins when using relationships and limited result sets. Filters conditions on subsequent queries to just the ones applying to the relation.
_schema ( Query $query, array | null $fields = null ) : array	Helper method for data\model\Database::shema()
_splitFieldname ( string $field ) : array	Return the alias and the field name from an identifier name.
_toBoolean ( mixed $value ) : boolean	Casts a value which is being written or compared to a boolean-type database column.
_updateFields ( array $data, array $schema, object $context ) : string	Renders the fields part for _update_ queries.

Описание методов

Описание свойств