Ubiquity\orm\traits$DAOUQueries This class is part of Ubiquity. More...

Inheritance diagram for DAOUQueries:

Static Public Member Functions
static	uGetAll ($className, $ucondition='', $included=true, $parameters=null, $useCache=null)
	Returns an array of $className objects from the database.

static	uCount ($className, $ucondition='', $parameters=null)
	Returns the number of objects of $className from the database respecting the condition possibly passed as parameter.

static	uAggregate (string $className, string $ucondition='', ?array $parameters=null, ?array $groupBy=null, string $function='COUNT', string $field=' *', bool $distinct=false)

static	uCountGroupBy (string $className, string $ucondition='', ?array $parameters=null, ?array $groupBy=null, string $countField=' *', bool $distinct=false)

static	uAvgGroupBy (string $className, string $avgField, string $ucondition='', ?array $parameters=null, ?array $groupBy=null)

static	uSumGroupBy (string $className, string $sumField, string $ucondition='', ?array $parameters=null, ?array $groupBy=null)

static	uMinGroupBy (string $className, string $minField, string $ucondition='', ?array $parameters=null, ?array $groupBy=null)

static	uMaxGroupBy (string $className, string $maxField, string $ucondition='', ?array $parameters=null, ?array $groupBy=null)

static	uGetOne ($className, $ucondition, $included=true, $parameters=null, $useCache=null)
	Returns an instance of $className from the database, from $keyvalues values of the primary key.

Static Protected Member Functions
static	_getAll (Database $db, $className, ConditionParser $conditionParser, $included=true, $useCache=null)

static	_getOne (Database $db, $className, ConditionParser $conditionParser, $included, $useCache)

static	uParse ($db, $className, &$ucondition, $quote, &$fields=null)

static	uParseExpression ($db, $className, $expression, &$expressionArray, &$condition, &$ucondition, &$aliases, $quote, &$fields=null)

static	getAnnotFieldsInRelations ($className)

static	uGetExpressions ($condition)

Static Protected Attributes
static	$annotFieldsInRelations = []

Detailed Description

Ubiquity\orm\traits$DAOUQueries This class is part of Ubiquity.

Author: jc

Version: 1.0.3

Definition at line 18 of file DAOUQueries.php.

Member Function Documentation

◆ _getAll()

static _getAll	(	Database	$db,
			$className,
		ConditionParser	$conditionParser,
			$included = `true`,
			$useCache = `null`
	)

staticabstractprotected

Reimplemented in SDAO.

◆ _getOne()

static _getOne	(	Database	$db,
			$className,
		ConditionParser	$conditionParser,
			$included,
			$useCache
	)

staticabstractprotected

Reimplemented in SDAO.

◆ getAnnotFieldsInRelations()

static getAnnotFieldsInRelations ( $className )

staticprotected

Definition at line 51 of file DAOUQueries.php.

◆ uAggregate()

static uAggregate	(	string	$className,
		string	$ucondition = `''`,
		?array	$parameters = `null`,
		?array	$groupBy = `null`,
		string	$function = `'COUNT'`,
		string	$field = `'*'`,
		bool	$distinct = `false`
	)

static

Parameters

string	$className
string	$ucondition
array \| null	$parameters
array \| null	$groupBy
string	$function
string	$field
bool	$distinct

Returns: array

Definition at line 113 of file DAOUQueries.php.

◆ uAvgGroupBy()

static uAvgGroupBy	(	string	$className,
		string	$avgField,
		string	$ucondition = `''`,
		?array	$parameters = `null`,
		?array	$groupBy = `null`
	)

static

Parameters

string	$className
string	$avgField
string	$ucondition
array \| null	$parameters
array \| null	$groupBy

Returns: array

Definition at line 166 of file DAOUQueries.php.

◆ uCount()

static uCount	(	$className,
		$ucondition = `''`,
		$parameters = `null`
	)

static

Returns the number of objects of $className from the database respecting the condition possibly passed as parameter.

Parameters

string	$className	complete classname of the model to load
string	$ucondition	Part following the WHERE of an SQL statement
array \| null	$parameters	The query parameters

Returns: int|boolean count of objects

Definition at line 91 of file DAOUQueries.php.

◆ uCountGroupBy()

static uCountGroupBy	(	string	$className,
		string	$ucondition = `''`,
		?array	$parameters = `null`,
		?array	$groupBy = `null`,
		string	$countField = `'*'`,
		bool	$distinct = `false`
	)

static

Parameters

string	$className
string	$ucondition
array \| null	$parameters
array \| null	$groupBy
string	$countField
bool	$distinct

Returns: array

Definition at line 154 of file DAOUQueries.php.

◆ uGetAll()

static uGetAll	(	$className,
		$ucondition = `''`,
		$included = `true`,
		$parameters = `null`,
		$useCache = `null`
	)

static

Returns an array of $className objects from the database.

Parameters

string	$className	class name of the model to load
string	$ucondition	UQL condition
boolean \| array	$included	if true, loads associated members with associations, if array, example : ["client.*","commands"]
array \| null	$parameters	the request parameters
boolean	$useCache	use the active cache if true

Returns: array

Definition at line 77 of file DAOUQueries.php.

◆ uGetExpressions()

static uGetExpressions ( $condition )

staticprotected

Definition at line 58 of file DAOUQueries.php.

◆ uGetOne()

static uGetOne	(	$className,
		$ucondition,
		$included = `true`,
		$parameters = `null`,
		$useCache = `null`
	)

static

Returns an instance of $className from the database, from $keyvalues values of the primary key.

Parameters

String	$className	complete classname of the model to load
Array \| string	$ucondition	primary key values or condition (UQL)
boolean \| array	$included	if true, charges associated members with association
array \| null	$parameters	the request parameters
boolean	$useCache	use cache if true

Returns: object the instance loaded or null if not found

Definition at line 216 of file DAOUQueries.php.

◆ uMaxGroupBy()

static uMaxGroupBy	(	string	$className,
		string	$maxField,
		string	$ucondition = `''`,
		?array	$parameters = `null`,
		?array	$groupBy = `null`
	)

static

Parameters

string	$className
string	$maxField
string	$ucondition
array \| null	$parameters
array \| null	$groupBy

Returns: array

Definition at line 202 of file DAOUQueries.php.

◆ uMinGroupBy()

static uMinGroupBy	(	string	$className,
		string	$minField,
		string	$ucondition = `''`,
		?array	$parameters = `null`,
		?array	$groupBy = `null`
	)

static

Parameters

string	$className
string	$minField
string	$ucondition
array \| null	$parameters
array \| null	$groupBy

Returns: array

Definition at line 190 of file DAOUQueries.php.

◆ uParse()

static uParse	(		$db,
			$className,
		&	$ucondition,
			$quote,
		&	$fields = `null`
	)

staticprotected

Definition at line 25 of file DAOUQueries.php.

◆ uParseExpression()

static uParseExpression	(		$db,
			$className,
			$expression,
		&	$expressionArray,
		&	$condition,
		&	$ucondition,
		&	$aliases,
			$quote,
		&	$fields = `null`
	)

staticprotected

Definition at line 36 of file DAOUQueries.php.

◆ uSumGroupBy()

static uSumGroupBy	(	string	$className,
		string	$sumField,
		string	$ucondition = `''`,
		?array	$parameters = `null`,
		?array	$groupBy = `null`
	)

static

Parameters

string	$className
string	$sumField
string	$ucondition
array \| null	$parameters
array \| null	$groupBy

Returns: array

Definition at line 178 of file DAOUQueries.php.

Field Documentation

◆ $annotFieldsInRelations

$annotFieldsInRelations = []

staticprotected

Definition at line 19 of file DAOUQueries.php.

The documentation for this class was generated from the following file:

C:/Users/myadd/Documents/GitHub/ubiquity-doc-api/vendor/phpmv/ubiquity/src/Ubiquity/orm/traits/DAOUQueries.php

Static Public Member Functions

Static Protected Member Functions

Static Protected Attributes

Detailed Description

Member Function Documentation

◆ _getAll()

◆ _getOne()

◆ getAnnotFieldsInRelations()

◆ uAggregate()

◆ uAvgGroupBy()

◆ uCount()

◆ uCountGroupBy()

◆ uGetAll()

◆ uGetExpressions()

◆ uGetOne()

◆ uMaxGroupBy()

◆ uMinGroupBy()

◆ uParse()

◆ uParseExpression()

◆ uSumGroupBy()

Field Documentation

◆ $annotFieldsInRelations