class AttributeTemplateQuery extends AttributeTemplateQuery

Skeleton subclass for performing query and update operations on the 'attribute_template' 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

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\AttributeTemplate', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\AttributeTemplateQuery object.

create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildAttributeTemplateQuery object.

AttributeTemplate|array|mixed
findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByAttributeId( mixed $attributeId = null, string $comparison = null)

Filter the query on the attribute_id column

filterByTemplateId( mixed $templateId = null, string $comparison = null)

Filter the query on the template_id column

filterByPosition( mixed $position = null, string $comparison = null)

Filter the query on the position column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByAttribute( Attribute|ObjectCollection $attribute, string $comparison = null)

Filter the query by a related \Thelia\Model\Attribute object

joinAttribute( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Attribute relation

useAttributeQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Attribute relation Attribute object

filterByTemplate( Template|ObjectCollection $template, string $comparison = null)

Filter the query by a related \Thelia\Model\Template object

joinTemplate( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Template relation

useTemplateQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Template relation Template object

prune( AttributeTemplate $attributeTemplate = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the attribute_template table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildAttributeTemplate or Criteria object OR a primary key value.

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

ChildAttributeTemplateQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildAttributeTemplateQuery
orderByAttributeId($order = Criteria::ASC)

Order by the attribute_id column

ChildAttributeTemplateQuery
orderByTemplateId($order = Criteria::ASC)

Order by the template_id column

ChildAttributeTemplateQuery
orderByPosition($order = Criteria::ASC)

Order by the position column

ChildAttributeTemplateQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildAttributeTemplateQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildAttributeTemplateQuery
groupById()

Group by the id column

ChildAttributeTemplateQuery
groupByAttributeId()

Group by the attribute_id column

ChildAttributeTemplateQuery
groupByTemplateId()

Group by the template_id column

ChildAttributeTemplateQuery
groupByPosition()

Group by the position column

ChildAttributeTemplateQuery
groupByCreatedAt()

Group by the created_at column

ChildAttributeTemplateQuery
groupByUpdatedAt()

Group by the updated_at column

ChildAttributeTemplateQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildAttributeTemplateQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildAttributeTemplateQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildAttributeTemplateQuery
leftJoinAttribute($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Attribute relation

ChildAttributeTemplateQuery
rightJoinAttribute($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Attribute relation

ChildAttributeTemplateQuery
innerJoinAttribute($relationAlias = null)

Adds a INNER JOIN clause to the query using the Attribute relation

ChildAttributeTemplateQuery
leftJoinTemplate($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Template relation

ChildAttributeTemplateQuery
rightJoinTemplate($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Template relation

ChildAttributeTemplateQuery
innerJoinTemplate($relationAlias = null)

Adds a INNER JOIN clause to the query using the Template relation

ChildAttributeTemplate
findOne( ConnectionInterface $con = null)

Return the first ChildAttributeTemplate matching the query

ChildAttributeTemplate
findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildAttributeTemplate matching the query, or a new ChildAttributeTemplate object populated from the query conditions when no match is found

ChildAttributeTemplate
findOneById( int $id)

Return the first ChildAttributeTemplate filtered by the id column

ChildAttributeTemplate
findOneByAttributeId( int $attribute_id)

Return the first ChildAttributeTemplate filtered by the attribute_id column

ChildAttributeTemplate
findOneByTemplateId( int $template_id)

Return the first ChildAttributeTemplate filtered by the template_id column

ChildAttributeTemplate
findOneByPosition( int $position)

Return the first ChildAttributeTemplate filtered by the position column

ChildAttributeTemplate
findOneByCreatedAt( string $created_at)

Return the first ChildAttributeTemplate filtered by the created_at column

ChildAttributeTemplate
findOneByUpdatedAt( string $updated_at)

Return the first ChildAttributeTemplate filtered by the updated_at column

array
findById( int $id)

Return ChildAttributeTemplate objects filtered by the id column

array
findByAttributeId( int $attribute_id)

Return ChildAttributeTemplate objects filtered by the attribute_id column

array
findByTemplateId( int $template_id)

Return ChildAttributeTemplate objects filtered by the template_id column

array
findByPosition( int $position)

Return ChildAttributeTemplate objects filtered by the position column

array
findByCreatedAt( string $created_at)

Return ChildAttributeTemplate objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildAttributeTemplate objects filtered by the updated_at column

Details

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\AttributeTemplate', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\AttributeTemplateQuery object.

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

static AttributeTemplateQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildAttributeTemplateQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

AttributeTemplateQuery

in AttributeTemplateQuery at line 121
AttributeTemplate|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);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

AttributeTemplate|array|mixed the result, formatted by the current formatter

in AttributeTemplateQuery at line 203
ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

in AttributeTemplateQuery at line 224
AttributeTemplateQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 237
AttributeTemplateQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 261
AttributeTemplateQuery 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

Parameters

mixed $id The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 304
AttributeTemplateQuery filterByAttributeId( mixed $attributeId = null, string $comparison = null)

Filter the query on the attribute_id column

Example usage: $query->filterByAttributeId(1234); // WHERE attributeid = 1234 $query->filterByAttributeId(array(12, 34)); // WHERE attributeid IN (12, 34) $query->filterByAttributeId(array('min' => 12)); // WHERE attribute_id > 12

Parameters

mixed $attributeId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

See also

filterByAttribute()

in AttributeTemplateQuery at line 347
AttributeTemplateQuery filterByTemplateId( mixed $templateId = null, string $comparison = null)

Filter the query on the template_id column

Example usage: $query->filterByTemplateId(1234); // WHERE templateid = 1234 $query->filterByTemplateId(array(12, 34)); // WHERE templateid IN (12, 34) $query->filterByTemplateId(array('min' => 12)); // WHERE template_id > 12

Parameters

mixed $templateId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

See also

filterByTemplate()

in AttributeTemplateQuery at line 388
AttributeTemplateQuery 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

Parameters

mixed $position The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 431
AttributeTemplateQuery 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'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 474
AttributeTemplateQuery 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'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 505
AttributeTemplateQuery filterByAttribute( Attribute|ObjectCollection $attribute, string $comparison = null)

Filter the query by a related \Thelia\Model\Attribute object

Parameters

Attribute|ObjectCollection $attribute The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 530
AttributeTemplateQuery joinAttribute( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Attribute relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 565
AttributeQuery useAttributeQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Attribute relation Attribute object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AttributeQuery A secondary query class using the current class as primary query

See also

useQuery()

in AttributeTemplateQuery at line 580
AttributeTemplateQuery filterByTemplate( Template|ObjectCollection $template, string $comparison = null)

Filter the query by a related \Thelia\Model\Template object

Parameters

Template|ObjectCollection $template The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 605
AttributeTemplateQuery joinTemplate( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Template relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 640
TemplateQuery useTemplateQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Template relation Template object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

TemplateQuery A secondary query class using the current class as primary query

See also

useQuery()

in AttributeTemplateQuery at line 654
AttributeTemplateQuery prune( AttributeTemplate $attributeTemplate = null)

Exclude object from result

Parameters

AttributeTemplate $attributeTemplate Object to remove from the list of results

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 669
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the attribute_template table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

in AttributeTemplateQuery at line 706
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildAttributeTemplate or Criteria object OR a primary key value.

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

in AttributeTemplateQuery at line 747
AttributeTemplateQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 759
AttributeTemplateQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 769
AttributeTemplateQuery lastUpdatedFirst()

Order by update date desc

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 779
AttributeTemplateQuery firstUpdatedFirst()

Order by update date asc

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 789
AttributeTemplateQuery lastCreatedFirst()

Order by create date desc

Return Value

AttributeTemplateQuery The current query, for fluid interface

in AttributeTemplateQuery at line 799
AttributeTemplateQuery firstCreatedFirst()

Order by create date asc

Return Value

AttributeTemplateQuery The current query, for fluid interface

ChildAttributeTemplateQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery orderByAttributeId($order = Criteria::ASC)

Order by the attribute_id column

Parameters

$order

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery orderByTemplateId($order = Criteria::ASC)

Order by the template_id column

Parameters

$order

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery orderByPosition($order = Criteria::ASC)

Order by the position column

Parameters

$order

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery groupById()

Group by the id column

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery groupByAttributeId()

Group by the attribute_id column

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery groupByTemplateId()

Group by the template_id column

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery groupByPosition()

Group by the position column

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery leftJoinAttribute($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Attribute relation

Parameters

$relationAlias

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery rightJoinAttribute($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Attribute relation

Parameters

$relationAlias

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery innerJoinAttribute($relationAlias = null)

Adds a INNER JOIN clause to the query using the Attribute relation

Parameters

$relationAlias

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery leftJoinTemplate($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Template relation

Parameters

$relationAlias

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery rightJoinTemplate($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Template relation

Parameters

$relationAlias

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplateQuery innerJoinTemplate($relationAlias = null)

Adds a INNER JOIN clause to the query using the Template relation

Parameters

$relationAlias

Return Value

ChildAttributeTemplateQuery

ChildAttributeTemplate findOne( ConnectionInterface $con = null)

Return the first ChildAttributeTemplate matching the query

Parameters

ConnectionInterface $con

Return Value

ChildAttributeTemplate

ChildAttributeTemplate findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildAttributeTemplate matching the query, or a new ChildAttributeTemplate object populated from the query conditions when no match is found

Parameters

ConnectionInterface $con

Return Value

ChildAttributeTemplate

ChildAttributeTemplate findOneById( int $id)

Return the first ChildAttributeTemplate filtered by the id column

Parameters

int $id

Return Value

ChildAttributeTemplate

ChildAttributeTemplate findOneByAttributeId( int $attribute_id)

Return the first ChildAttributeTemplate filtered by the attribute_id column

Parameters

int $attribute_id

Return Value

ChildAttributeTemplate

ChildAttributeTemplate findOneByTemplateId( int $template_id)

Return the first ChildAttributeTemplate filtered by the template_id column

Parameters

int $template_id

Return Value

ChildAttributeTemplate

ChildAttributeTemplate findOneByPosition( int $position)

Return the first ChildAttributeTemplate filtered by the position column

Parameters

int $position

Return Value

ChildAttributeTemplate

ChildAttributeTemplate findOneByCreatedAt( string $created_at)

Return the first ChildAttributeTemplate filtered by the created_at column

Parameters

string $created_at

Return Value

ChildAttributeTemplate

ChildAttributeTemplate findOneByUpdatedAt( string $updated_at)

Return the first ChildAttributeTemplate filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildAttributeTemplate

array findById( int $id)

Return ChildAttributeTemplate objects filtered by the id column

Parameters

int $id

Return Value

array

array findByAttributeId( int $attribute_id)

Return ChildAttributeTemplate objects filtered by the attribute_id column

Parameters

int $attribute_id

Return Value

array

array findByTemplateId( int $template_id)

Return ChildAttributeTemplate objects filtered by the template_id column

Parameters

int $template_id

Return Value

array

array findByPosition( int $position)

Return ChildAttributeTemplate objects filtered by the position column

Parameters

int $position

Return Value

array

array findByCreatedAt( string $created_at)

Return ChildAttributeTemplate objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

array findByUpdatedAt( string $updated_at)

Return ChildAttributeTemplate objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array