Class common\models\ItaliaComuniQuery
This is the ActiveQuery class for common\models\ItaliaComuni.
See also common\models\ItaliaComuni.
Public Properties
| Property | Type | Description | Defined By |
|---|---|---|---|
| $asArray | boolean | Whether to return each record as an array. | yii\db\ActiveQueryTrait |
| $behaviors | yii\base\Behavior[] | List of behaviors attached to this component | yii\base\Component |
| $distinct | boolean | Whether to select distinct rows of data only. | yii\db\Query |
| $emulateExecution | boolean | Whether to emulate the actual query execution, returning empty or false results. | yii\db\QueryTrait |
| $from | array | The table(s) to be selected from. | yii\db\Query |
| $groupBy | array | How to group the query results. | yii\db\Query |
| $having | string|array|yii\db\Expression | The condition to be applied in the GROUP BY clause. | yii\db\Query |
| $indexBy | string|callable | The name of the column by which the query results should be indexed by. | yii\db\QueryTrait |
| $inverseOf | string | The name of the relation that is the inverse of this relation. | yii\db\ActiveRelationTrait |
| $join | array | How to join with other tables. | yii\db\Query |
| $joinWith | array | A list of relations that this query should be joined with | yii\db\ActiveQuery |
| $limit | integer|yii\db\Expression | Maximum number of records to be returned. | yii\db\QueryTrait |
| $link | array | The columns of the primary and foreign tables that establish a relation. | yii\db\ActiveRelationTrait |
| $modelClass | string | The name of the ActiveRecord class. | yii\db\ActiveQueryTrait |
| $multiple | boolean | Whether this query represents a relation to more than one record. | yii\db\ActiveRelationTrait |
| $offset | integer|yii\db\Expression | Zero-based offset from where the records are to be returned. | yii\db\QueryTrait |
| $on | string|array | The join condition to be used when this query is used in a relational context. | yii\db\ActiveQuery |
| $orderBy | array | How to sort the query results. | yii\db\QueryTrait |
| $params | array | List of query parameter values indexed by parameter placeholders. | yii\db\Query |
| $primaryModel | yii\db\ActiveRecord | The primary model of a relational query. | yii\db\ActiveRelationTrait |
| $select | array | The columns being selected. | yii\db\Query |
| $selectOption | string | Additional option that should be appended to the 'SELECT' keyword. | yii\db\Query |
| $sql | string | The SQL statement to be executed for retrieving AR records. | yii\db\ActiveQuery |
| $tablesUsedInFrom | string[] | Table names indexed by aliases | yii\db\ActiveQuery |
| $union | array | This is used to construct the UNION clause(s) in a SQL statement. | yii\db\Query |
| $via | array|object | The query associated with the junction table. | yii\db\ActiveRelationTrait |
| $where | string|array | Query condition. | yii\db\QueryTrait |
| $with | array | A list of relations that this query should be performed with | yii\db\ActiveQueryTrait |
Public Methods
| Method | Description | Defined By |
|---|---|---|
| __call() | Calls the named method which is not a class method. | yii\base\Component |
| __clone() | Clones internal objects. | yii\db\ActiveRelationTrait |
| __construct() | Constructor. | yii\db\ActiveQuery |
| __get() | Returns the value of a component property. | yii\base\Component |
| __isset() | Checks if a property is set, i.e. defined and not null. | yii\base\Component |
| __set() | Sets the value of a component property. | yii\base\Component |
| __unset() | Sets a component property to be null. | yii\base\Component |
| addGroupBy() | Adds additional group-by columns to the existing ones. | yii\db\Query |
| addOrderBy() | Adds additional ORDER BY columns to the query. | yii\db\QueryTrait |
| addParams() | Adds additional parameters to be bound to the query. | yii\db\Query |
| addSelect() | Add more columns to the SELECT part of the query. | yii\db\Query |
| alias() | Define an alias for the table defined in $modelClass. | yii\db\ActiveQuery |
| all() | Executes query and returns all results as an array. | common\models\ItaliaComuniQuery |
| andFilterCompare() | Adds a filtering condition for a specific column and allow the user to choose a filter operator. | yii\db\Query |
| andFilterHaving() | Adds an additional HAVING condition to the existing one but ignores empty operands. | yii\db\Query |
| andFilterWhere() | Adds an additional WHERE condition to the existing one but ignores empty operands. | yii\db\QueryTrait |
| andHaving() | Adds an additional HAVING condition to the existing one. | yii\db\Query |
| andOnCondition() | Adds an additional ON condition to the existing one. | yii\db\ActiveQuery |
| andWhere() | Adds an additional WHERE condition to the existing one. | yii\db\QueryTrait |
| asArray() | Sets the asArray() property. | yii\db\ActiveQueryTrait |
| attachBehavior() | Attaches a behavior to this component. | yii\base\Component |
| attachBehaviors() | Attaches a list of behaviors to the component. | yii\base\Component |
| average() | Returns the average of the specified column values. | yii\db\Query |
| batch() | Starts a batch query. | yii\db\Query |
| behaviors() | Returns a list of behaviors that this component should behave as. | yii\base\Component |
| canGetProperty() | Returns a value indicating whether a property can be read. | yii\base\Component |
| canSetProperty() | Returns a value indicating whether a property can be set. | yii\base\Component |
| className() | Returns the fully qualified name of this class. | yii\base\Object |
| column() | Executes the query and returns the first column of the result. | yii\db\Query |
| count() | Returns the number of records. | yii\db\Query |
| create() | Creates a new Query object and copies its property values from an existing one. | yii\db\Query |
| createCommand() | Creates a DB command that can be used to execute this query. | yii\db\ActiveQuery |
| detachBehavior() | Detaches a behavior from the component. | yii\base\Component |
| detachBehaviors() | Detaches all behaviors from the component. | yii\base\Component |
| distinct() | Sets the value indicating whether to SELECT DISTINCT or not. | yii\db\Query |
| each() | Starts a batch query and retrieves data row by row. | yii\db\Query |
| emulateExecution() | Sets whether to emulate query execution, preventing any interaction with data storage. | yii\db\QueryTrait |
| ensureBehaviors() | Makes sure that the behaviors declared in behaviors() are attached to this component. | yii\base\Component |
| exists() | Returns a value indicating whether the query result contains any row of data. | yii\db\Query |
| filterHaving() | Sets the HAVING part of the query but ignores empty operands. | yii\db\Query |
| filterWhere() | Sets the WHERE part of the query but ignores empty operands. | yii\db\QueryTrait |
| findFor() | Finds the related records for the specified primary record. | yii\db\ActiveRelationTrait |
| findWith() | Finds records corresponding to one or multiple relations and populates them into the primary models. | yii\db\ActiveQueryTrait |
| from() | Sets the FROM part of the query. | yii\db\Query |
| getBehavior() | Returns the named behavior object. | yii\base\Component |
| getBehaviors() | Returns all behaviors attached to this component. | yii\base\Component |
| getTablesUsedInFrom() | Returns table names used in from() indexed by aliases. | yii\db\ActiveQuery |
| groupBy() | Sets the GROUP BY part of the query. | yii\db\Query |
| hasEventHandlers() | Returns a value indicating whether there is any handler attached to the named event. | yii\base\Component |
| hasMethod() | Returns a value indicating whether a method is defined. | yii\base\Component |
| hasProperty() | Returns a value indicating whether a property is defined for this component. | yii\base\Component |
| having() | Sets the HAVING part of the query. | yii\db\Query |
| indexBy() | Sets the indexBy() property. | yii\db\QueryTrait |
| init() | Initializes the object. | yii\db\ActiveQuery |
| innerJoin() | Appends an INNER JOIN part to the query. | yii\db\Query |
| innerJoinWith() | Inner joins with the specified relations. | yii\db\ActiveQuery |
| inverseOf() | Sets the name of the relation that is the inverse of this relation. | yii\db\ActiveRelationTrait |
| join() | Appends a JOIN part to the query. | yii\db\Query |
| joinWith() | Joins with the specified relations. | yii\db\ActiveQuery |
| leftJoin() | Appends a LEFT OUTER JOIN part to the query. | yii\db\Query |
| limit() | Sets the LIMIT part of the query. | yii\db\QueryTrait |
| max() | Returns the maximum of the specified column values. | yii\db\Query |
| min() | Returns the minimum of the specified column values. | yii\db\Query |
| off() | Detaches an existing event handler from this component. | yii\base\Component |
| offset() | Sets the OFFSET part of the query. | yii\db\QueryTrait |
| on() | Attaches an event handler to an event. | yii\base\Component |
| onCondition() | Sets the ON condition for a relational query. | yii\db\ActiveQuery |
| one() | Executes query and returns a single row of result. | common\models\ItaliaComuniQuery |
| orFilterHaving() | Adds an additional HAVING condition to the existing one but ignores empty operands. | yii\db\Query |
| orFilterWhere() | Adds an additional WHERE condition to the existing one but ignores empty operands. | yii\db\QueryTrait |
| orHaving() | Adds an additional HAVING condition to the existing one. | yii\db\Query |
| orOnCondition() | Adds an additional ON condition to the existing one. | yii\db\ActiveQuery |
| orWhere() | Adds an additional WHERE condition to the existing one. | yii\db\QueryTrait |
| orderBy() | Sets the ORDER BY part of the query. | yii\db\QueryTrait |
| params() | Sets the parameters to be bound to the query. | yii\db\Query |
| populate() | Converts the raw query results into the format as specified by this query. | yii\db\ActiveQuery |
| populateRelation() | Finds the related records and populates them into the primary models. | yii\db\ActiveRelationTrait |
| prepare() | Prepares for building SQL. | yii\db\ActiveQuery |
| rightJoin() | Appends a RIGHT OUTER JOIN part to the query. | yii\db\Query |
| scalar() | Returns the query result as a scalar value. | yii\db\Query |
| select() | Sets the SELECT part of the query. | yii\db\Query |
| sum() | Returns the sum of the specified column values. | yii\db\Query |
| trigger() | Triggers an event. | yii\base\Component |
| union() | Appends a SQL statement using UNION operator. | yii\db\Query |
| via() | Specifies the relation associated with the junction table. | yii\db\ActiveRelationTrait |
| viaTable() | Specifies the junction table for a relational query. | yii\db\ActiveQuery |
| where() | Sets the WHERE part of the query. | yii\db\QueryTrait |
| with() | Specifies the relations with which this query should be performed. | yii\db\ActiveQueryTrait |
Protected Methods
| Method | Description | Defined By |
|---|---|---|
| createModels() | Converts found rows into model instances | yii\db\ActiveQueryTrait |
| filterCondition() | Removes empty operands from the given query condition. | yii\db\QueryTrait |
| getPrimaryTableName() | yii\db\ActiveQuery | |
| isEmpty() | Returns a value indicating whether the give value is "empty". | yii\db\QueryTrait |
| normalizeOrderBy() | Normalizes format of ORDER BY data | yii\db\QueryTrait |
| queryScalar() | Queries a scalar value by setting select() first. | yii\db\ActiveQuery |
Events
| Event | Type | Description | Defined By |
|---|---|---|---|
| EVENT_INIT | \yii\db\Event | An event that is triggered when the query is initialized via init(). | yii\db\ActiveQuery |
Method Details
Executes query and returns all results as an array.
| public common\models\ItaliaComuni[]|array all ( $db = null ) | ||
| $db | yii\db\Connection | The DB connection used to create the DB command. If null, the DB connection returned by $modelClass will be used. |
| return | common\models\ItaliaComuni[]|array | The query results. If the query results in nothing, an empty array will be returned. |
|---|---|---|
Executes query and returns a single row of result.
| public common\models\ItaliaComuni|array|null one ( $db = null ) | ||
| $db | yii\db\Connection|null | The DB connection used to create the DB command.
If |
| return | common\models\ItaliaComuni|array|null | A single row of query result. Depending on the setting of asArray(),
the query result may be either an array or an ActiveRecord object. |
|---|---|---|