AttributeQuery
class AttributeQuery extends AttributeQuery
Skeleton subclass for performing query and update operations on the 'attribute' table.
You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.
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 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.
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 position column
Order by the created_at column
Order by the updated_at column
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
in
AttributeQuery at line 79
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Attribute',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\AttributeQuery object.
in
AttributeQuery at line 92
static
AttributeQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildAttributeQuery object.
in
AttributeQuery 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);
in
AttributeQuery 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);
in
AttributeQuery at line 225
AttributeQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
AttributeQuery at line 238
AttributeQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
AttributeQuery 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
in
AttributeQuery 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
in
AttributeQuery 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'
in
AttributeQuery 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'
in
AttributeQuery at line 420
AttributeQuery
filterByAttributeAv(
AttributeAv|ObjectCollection $attributeAv,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeAv object
in
AttributeQuery at line 443
AttributeQuery
joinAttributeAv(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeAv relation
in
AttributeQuery at line 478
AttributeAvQuery
useAttributeAvQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeAv relation AttributeAv object
in
AttributeQuery at line 493
AttributeQuery
filterByAttributeCombination(
AttributeCombination|ObjectCollection $attributeCombination,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeCombination object
in
AttributeQuery at line 516
AttributeQuery
joinAttributeCombination(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeCombination relation
in
AttributeQuery at line 551
AttributeCombinationQuery
useAttributeCombinationQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeCombination relation AttributeCombination object
in
AttributeQuery at line 566
AttributeQuery
filterByAttributeTemplate(
AttributeTemplate|ObjectCollection $attributeTemplate,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeTemplate object
in
AttributeQuery at line 589
AttributeQuery
joinAttributeTemplate(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the AttributeTemplate relation
in
AttributeQuery at line 624
AttributeTemplateQuery
useAttributeTemplateQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the AttributeTemplate relation AttributeTemplate object
in
AttributeQuery at line 639
AttributeQuery
filterByAttributeI18n(
AttributeI18n|ObjectCollection $attributeI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\AttributeI18n object
in
AttributeQuery at line 662
AttributeQuery
joinAttributeI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the AttributeI18n relation
in
AttributeQuery at line 697
AttributeI18nQuery
useAttributeI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the AttributeI18n relation AttributeI18n object
in
AttributeQuery 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
in
AttributeQuery at line 728
AttributeQuery
prune(
Attribute $attribute = null)
Exclude object from result
in
AttributeQuery at line 743
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the attribute table.
in
AttributeQuery 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.
in
AttributeQuery at line 821
AttributeQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
AttributeQuery at line 833
AttributeQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
AttributeQuery at line 843
AttributeQuery
lastUpdatedFirst()
Order by update date desc
in
AttributeQuery at line 853
AttributeQuery
firstUpdatedFirst()
Order by update date asc
in
AttributeQuery at line 863
AttributeQuery
lastCreatedFirst()
Order by create date desc
in
AttributeQuery at line 873
AttributeQuery
firstCreatedFirst()
Order by create date asc
in
AttributeQuery 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
in
AttributeQuery 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()
in
AttributeQuery at line 928
AttributeI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
AttributeQuery at line 69
ChildAttributeQuery
orderById($order = Criteria::ASC)
Order by the id column
in
AttributeQuery at line 69
ChildAttributeQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
AttributeQuery at line 69
ChildAttributeQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
AttributeQuery at line 69
ChildAttributeQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
AttributeQuery at line 69
ChildAttributeQuery
groupById()
Group by the id column
in
AttributeQuery at line 69
ChildAttributeQuery
groupByPosition()
Group by the position column
in
AttributeQuery at line 69
ChildAttributeQuery
groupByCreatedAt()
Group by the created_at column
in
AttributeQuery at line 69
ChildAttributeQuery
groupByUpdatedAt()
Group by the updated_at column
in
AttributeQuery at line 69
ChildAttributeQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
AttributeQuery at line 69
ChildAttributeQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
AttributeQuery at line 69
ChildAttributeQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
AttributeQuery at line 69
ChildAttributeQuery
leftJoinAttributeAv($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeAv relation
in
AttributeQuery at line 69
ChildAttributeQuery
rightJoinAttributeAv($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeAv relation
in
AttributeQuery at line 69
ChildAttributeQuery
innerJoinAttributeAv($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeAv relation
in
AttributeQuery at line 69
ChildAttributeQuery
leftJoinAttributeCombination($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeCombination relation
in
AttributeQuery at line 69
ChildAttributeQuery
rightJoinAttributeCombination($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeCombination relation
in
AttributeQuery at line 69
ChildAttributeQuery
innerJoinAttributeCombination($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeCombination relation
in
AttributeQuery at line 69
ChildAttributeQuery
leftJoinAttributeTemplate($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeTemplate relation
in
AttributeQuery at line 69
ChildAttributeQuery
rightJoinAttributeTemplate($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeTemplate relation
in
AttributeQuery at line 69
ChildAttributeQuery
innerJoinAttributeTemplate($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeTemplate relation
in
AttributeQuery at line 69
ChildAttributeQuery
leftJoinAttributeI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the AttributeI18n relation
in
AttributeQuery at line 69
ChildAttributeQuery
rightJoinAttributeI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the AttributeI18n relation
in
AttributeQuery at line 69
ChildAttributeQuery
innerJoinAttributeI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the AttributeI18n relation
in
AttributeQuery at line 69
ChildAttribute
findOne(
ConnectionInterface $con = null)
Return the first ChildAttribute matching the query
in
AttributeQuery 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
in
AttributeQuery at line 69
ChildAttribute
findOneById(
int $id)
Return the first ChildAttribute filtered by the id column
in
AttributeQuery at line 69
ChildAttribute
findOneByPosition(
int $position)
Return the first ChildAttribute filtered by the position column
in
AttributeQuery at line 69
ChildAttribute
findOneByCreatedAt(
string $created_at)
Return the first ChildAttribute filtered by the created_at column
in
AttributeQuery at line 69
ChildAttribute
findOneByUpdatedAt(
string $updated_at)
Return the first ChildAttribute filtered by the updated_at column
in
AttributeQuery at line 69
array
findById(
int $id)
Return ChildAttribute objects filtered by the id column
in
AttributeQuery at line 69
array
findByPosition(
int $position)
Return ChildAttribute objects filtered by the position column
in
AttributeQuery at line 69
array
findByCreatedAt(
string $created_at)
Return ChildAttribute objects filtered by the created_at column
in
AttributeQuery at line 69
array
findByUpdatedAt(
string $updated_at)
Return ChildAttribute objects filtered by the updated_at column