AttributeQuery
class AttributeQuery extends ModelCriteria
Base class that represents a query for the 'attribute' table.
Methods
Initializes internal state of \Thelia\Model\Base\AttributeQuery object.
Returns a new ChildAttributeQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the id column
Filter the query on the position column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query by a related \Thelia\Model\AttributeAv object
Adds a JOIN clause to the query using the AttributeAv relation
Use the AttributeAv relation AttributeAv object
Filter the query by a related \Thelia\Model\AttributeCombination object
Adds a JOIN clause to the query using the AttributeCombination relation
Use the AttributeCombination relation AttributeCombination object
Filter the query by a related \Thelia\Model\AttributeTemplate object
Adds a JOIN clause to the query using the AttributeTemplate relation
Use the AttributeTemplate relation AttributeTemplate object
Filter the query by a related \Thelia\Model\AttributeI18n object
Adds a JOIN clause to the query using the AttributeI18n relation
Use the AttributeI18n relation AttributeI18n object
Filter the query by a related Template object using the attribute_template table as cross reference
Deletes all rows from the attribute table.
Performs a DELETE on the database, given a ChildAttribute or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
Order by update date desc
Order by update date asc
Order by create date desc
Order by create date asc
Adds a JOIN clause to the query using the i18n relation
Adds a JOIN clause to the query and hydrates the related I18n object.
Use the I18n relation query object
Order by the id column
Order by the position column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the position column
Group by the created_at column
Group by the updated_at column
Adds a LEFT JOIN clause to the query
Adds a RIGHT JOIN clause to the query
Adds a INNER JOIN clause to the query
Adds a LEFT JOIN clause to the query using the AttributeAv relation
Adds a RIGHT JOIN clause to the query using the AttributeAv relation
Adds a INNER JOIN clause to the query using the AttributeAv relation
Adds a LEFT JOIN clause to the query using the AttributeCombination relation
Adds a RIGHT JOIN clause to the query using the AttributeCombination relation
Adds a INNER JOIN clause to the query using the AttributeCombination relation
Adds a LEFT JOIN clause to the query using the AttributeTemplate relation
Adds a RIGHT JOIN clause to the query using the AttributeTemplate relation
Adds a INNER JOIN clause to the query using the AttributeTemplate relation
Adds a LEFT JOIN clause to the query using the AttributeI18n relation
Adds a RIGHT JOIN clause to the query using the AttributeI18n relation
Adds a INNER JOIN clause to the query using the AttributeI18n relation
Return the first ChildAttribute matching the query
Return the first ChildAttribute matching the query, or a new ChildAttribute object populated from the query conditions when no match is found
Return the first ChildAttribute filtered by the id column
Return the first ChildAttribute filtered by the position column
Return the first ChildAttribute filtered by the created_at column
Return the first ChildAttribute filtered by the updated_at column
Return ChildAttribute objects filtered by the id column
Return ChildAttribute objects filtered by the position column
Return ChildAttribute objects filtered by the created_at column
Return ChildAttribute objects filtered by the updated_at column
Details
at line 79
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Attribute',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\AttributeQuery object.
at line 92
static
AttributeQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildAttributeQuery object.
at line 122
Attribute|array|mixed
findPk(
mixed $key,
ConnectionInterface $con = null)
Find object by primary key.
Propel uses the instance pool to skip the database if the object exists. Go fast if the query is untouched.
$obj = $c->findPk(12, $con);
at line 204
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 225
AttributeQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 238
AttributeQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 262
AttributeQuery
filterById(
mixed $id = null,
string $comparison = null)
Filter the query on the id column
Example usage:
$query->filterById(1234); // WHERE id = 1234
$query->filterById(array(12, 34)); // WHERE id IN (12, 34)
$query->filterById(array('min' => 12)); // WHERE id > 12
at line 303
AttributeQuery
filterByPosition(
mixed $position = null,
string $comparison = null)
Filter the query on the position column
Example usage:
$query->filterByPosition(1234); // WHERE position = 1234
$query->filterByPosition(array(12, 34)); // WHERE position IN (12, 34)
$query->filterByPosition(array('min' => 12)); // WHERE position > 12
at line 346
AttributeQuery
filterByCreatedAt(
mixed $createdAt = null,
string $comparison = null)
Filter the query on the created_at column
Example usage:
$query->filterByCreatedAt('2011-03-14'); // WHERE createdat = '2011-03-14'
$query->filterByCreatedAt('now'); // WHERE createdat = '2011-03-14'
$query->filterByCreatedAt(array('max' => 'yesterday')); // WHERE created_at > '2011-03-13'
at line 389
AttributeQuery
filterByUpdatedAt(
mixed $updatedAt = null,
string $comparison = null)
Filter the query on the updated_at column
Example usage:
$query->filterByUpdatedAt('2011-03-14'); // WHERE updatedat = '2011-03-14'
$query->filterByUpdatedAt('now'); // WHERE updatedat = '2011-03-14'
$query->filterByUpdatedAt(array('max' => 'yesterday')); // WHERE updated_at > '2011-03-13'
at line 420
AttributeQuery
filterByAttributeAv(
AttributeAv|ObjectCollection $attributeAv,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeAv object
at line 443
AttributeQuery
joinAttributeAv(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeAv relation
at line 478
AttributeAvQuery
useAttributeAvQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeAv relation AttributeAv object
at line 493
AttributeQuery
filterByAttributeCombination(
AttributeCombination|ObjectCollection $attributeCombination,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeCombination object
at line 516
AttributeQuery
joinAttributeCombination(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeCombination relation
at line 551
AttributeCombinationQuery
useAttributeCombinationQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeCombination relation AttributeCombination object
at line 566
AttributeQuery
filterByAttributeTemplate(
AttributeTemplate|ObjectCollection $attributeTemplate,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeTemplate object
at line 589
AttributeQuery
joinAttributeTemplate(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeTemplate relation
at line 624
AttributeTemplateQuery
useAttributeTemplateQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeTemplate relation AttributeTemplate object
at line 639
AttributeQuery
filterByAttributeI18n(
AttributeI18n|ObjectCollection $attributeI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeI18n object
at line 662
AttributeQuery
joinAttributeI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the AttributeI18n relation
at line 697
AttributeI18nQuery
useAttributeI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the AttributeI18n relation AttributeI18n object
at line 713
AttributeQuery
filterByTemplate(
Template $template,
string $comparison = Criteria::EQUAL)
Filter the query by a related Template object using the attribute_template table as cross reference
at line 728
AttributeQuery
prune(
Attribute $attribute = null)
Exclude object from result
at line 743
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the attribute table.
at line 780
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildAttribute or Criteria object OR a primary key value.
at line 821
AttributeQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 833
AttributeQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 843
AttributeQuery
lastUpdatedFirst()
Order by update date desc
at line 853
AttributeQuery
firstUpdatedFirst()
Order by update date asc
at line 863
AttributeQuery
lastCreatedFirst()
Order by create date desc
at line 873
AttributeQuery
firstCreatedFirst()
Order by create date asc
at line 889
AttributeQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
at line 907
AttributeQuery
joinWithI18n(
string $locale = 'en_US',
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query and hydrates the related I18n object.
Shortcut for $c->joinI18n($locale)->with()
at line 928
AttributeI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 69
ChildAttributeQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 69
ChildAttributeQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 69
ChildAttributeQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 69
ChildAttributeQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 69
ChildAttributeQuery
groupById()
Group by the id column
at line 69
ChildAttributeQuery
groupByPosition()
Group by the position column
at line 69
ChildAttributeQuery
groupByCreatedAt()
Group by the created_at column
at line 69
ChildAttributeQuery
groupByUpdatedAt()
Group by the updated_at column
at line 69
ChildAttributeQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 69
ChildAttributeQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 69
ChildAttributeQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 69
ChildAttributeQuery
leftJoinAttributeAv($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeAv relation
at line 69
ChildAttributeQuery
rightJoinAttributeAv($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeAv relation
at line 69
ChildAttributeQuery
innerJoinAttributeAv($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeAv relation
at line 69
ChildAttributeQuery
leftJoinAttributeCombination($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeCombination relation
at line 69
ChildAttributeQuery
rightJoinAttributeCombination($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeCombination relation
at line 69
ChildAttributeQuery
innerJoinAttributeCombination($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeCombination relation
at line 69
ChildAttributeQuery
leftJoinAttributeTemplate($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeTemplate relation
at line 69
ChildAttributeQuery
rightJoinAttributeTemplate($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeTemplate relation
at line 69
ChildAttributeQuery
innerJoinAttributeTemplate($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeTemplate relation
at line 69
ChildAttributeQuery
leftJoinAttributeI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeI18n relation
at line 69
ChildAttributeQuery
rightJoinAttributeI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeI18n relation
at line 69
ChildAttributeQuery
innerJoinAttributeI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeI18n relation
at line 69
ChildAttribute
findOne(
ConnectionInterface $con = null)
Return the first ChildAttribute matching the query
at line 69
ChildAttribute
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildAttribute matching the query, or a new ChildAttribute object populated from the query conditions when no match is found
at line 69
ChildAttribute
findOneById(
int $id)
Return the first ChildAttribute filtered by the id column
at line 69
ChildAttribute
findOneByPosition(
int $position)
Return the first ChildAttribute filtered by the position column
at line 69
ChildAttribute
findOneByCreatedAt(
string $created_at)
Return the first ChildAttribute filtered by the created_at column
at line 69
ChildAttribute
findOneByUpdatedAt(
string $updated_at)
Return the first ChildAttribute filtered by the updated_at column
at line 69
array
findById(
int $id)
Return ChildAttribute objects filtered by the id column
at line 69
array
findByPosition(
int $position)
Return ChildAttribute objects filtered by the position column
at line 69
array
findByCreatedAt(
string $created_at)
Return ChildAttribute objects filtered by the created_at column
at line 69
array
findByUpdatedAt(
string $updated_at)
Return ChildAttribute objects filtered by the updated_at column