class AccessoryQuery extends ModelCriteria

Base class that represents a query for the 'accessory' table.

Methods

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

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

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

Returns a new ChildAccessoryQuery object.

Accessory|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

filterByProductId( mixed $productId = null, string $comparison = null)

Filter the query on the product_id column

filterByAccessory( mixed $accessory = null, string $comparison = null)

Filter the query on the accessory 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

filterByProductRelatedByProductId( Product|ObjectCollection $product, string $comparison = null)

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

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

Adds a JOIN clause to the query using the ProductRelatedByProductId relation

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

Use the ProductRelatedByProductId relation Product object

filterByProductRelatedByAccessory( Product|ObjectCollection $product, string $comparison = null)

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

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

Adds a JOIN clause to the query using the ProductRelatedByAccessory relation

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

Use the ProductRelatedByAccessory relation Product object

prune( Accessory $accessory = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the accessory table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildAccessory 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

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

ChildAccessoryQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildAccessoryQuery
orderByProductId($order = Criteria::ASC)

Order by the product_id column

ChildAccessoryQuery
orderByAccessory($order = Criteria::ASC)

Order by the accessory column

ChildAccessoryQuery
orderByPosition($order = Criteria::ASC)

Order by the position column

ChildAccessoryQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildAccessoryQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildAccessoryQuery
groupById()

Group by the id column

ChildAccessoryQuery
groupByProductId()

Group by the product_id column

ChildAccessoryQuery
groupByAccessory()

Group by the accessory column

ChildAccessoryQuery
groupByPosition()

Group by the position column

ChildAccessoryQuery
groupByCreatedAt()

Group by the created_at column

ChildAccessoryQuery
groupByUpdatedAt()

Group by the updated_at column

ChildAccessoryQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildAccessoryQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildAccessoryQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildAccessoryQuery
leftJoinProductRelatedByProductId($relationAlias = null)

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

ChildAccessoryQuery
rightJoinProductRelatedByProductId($relationAlias = null)

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

ChildAccessoryQuery
innerJoinProductRelatedByProductId($relationAlias = null)

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

ChildAccessoryQuery
leftJoinProductRelatedByAccessory($relationAlias = null)

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

ChildAccessoryQuery
rightJoinProductRelatedByAccessory($relationAlias = null)

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

ChildAccessoryQuery
innerJoinProductRelatedByAccessory($relationAlias = null)

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

ChildAccessory
findOne( ConnectionInterface $con = null)

Return the first ChildAccessory matching the query

ChildAccessory
findOneOrCreate( ConnectionInterface $con = null)

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

ChildAccessory
findOneById( int $id)

Return the first ChildAccessory filtered by the id column

ChildAccessory
findOneByProductId( int $product_id)

Return the first ChildAccessory filtered by the product_id column

ChildAccessory
findOneByAccessory( int $accessory)

Return the first ChildAccessory filtered by the accessory column

ChildAccessory
findOneByPosition( int $position)

Return the first ChildAccessory filtered by the position column

ChildAccessory
findOneByCreatedAt( string $created_at)

Return the first ChildAccessory filtered by the created_at column

ChildAccessory
findOneByUpdatedAt( string $updated_at)

Return the first ChildAccessory filtered by the updated_at column

array
findById( int $id)

Return ChildAccessory objects filtered by the id column

array
findByProductId( int $product_id)

Return ChildAccessory objects filtered by the product_id column

array
findByAccessory( int $accessory)

Return ChildAccessory objects filtered by the accessory column

array
findByPosition( int $position)

Return ChildAccessory objects filtered by the position column

array
findByCreatedAt( string $created_at)

Return ChildAccessory objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildAccessory objects filtered by the updated_at column

Details

at line 78
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\Accessory', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\AccessoryQuery 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'

at line 91
static AccessoryQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildAccessoryQuery object.

Parameters

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

Return Value

AccessoryQuery

at line 121
Accessory|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

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

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

at line 224
AccessoryQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

AccessoryQuery The current query, for fluid interface

at line 237
AccessoryQuery 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

AccessoryQuery The current query, for fluid interface

at line 261
AccessoryQuery 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

AccessoryQuery The current query, for fluid interface

at line 304
AccessoryQuery filterByProductId( mixed $productId = null, string $comparison = null)

Filter the query on the product_id column

Example usage: $query->filterByProductId(1234); // WHERE productid = 1234 $query->filterByProductId(array(12, 34)); // WHERE productid IN (12, 34) $query->filterByProductId(array('min' => 12)); // WHERE product_id > 12

Parameters

mixed $productId 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

AccessoryQuery The current query, for fluid interface

See also

filterByProductRelatedByProductId()

at line 347
AccessoryQuery filterByAccessory( mixed $accessory = null, string $comparison = null)

Filter the query on the accessory column

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

Parameters

mixed $accessory 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

AccessoryQuery The current query, for fluid interface

See also

filterByProductRelatedByAccessory()

at line 388
AccessoryQuery 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

AccessoryQuery The current query, for fluid interface

at line 431
AccessoryQuery 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

AccessoryQuery The current query, for fluid interface

at line 474
AccessoryQuery 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

AccessoryQuery The current query, for fluid interface

at line 505
AccessoryQuery filterByProductRelatedByProductId( Product|ObjectCollection $product, string $comparison = null)

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

Parameters

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

Return Value

AccessoryQuery The current query, for fluid interface

at line 530
AccessoryQuery joinProductRelatedByProductId( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductRelatedByProductId relation

Parameters

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

Return Value

AccessoryQuery The current query, for fluid interface

at line 565
ProductQuery useProductRelatedByProductIdQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductRelatedByProductId relation Product 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

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

See also

useQuery()

at line 580
AccessoryQuery filterByProductRelatedByAccessory( Product|ObjectCollection $product, string $comparison = null)

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

Parameters

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

Return Value

AccessoryQuery The current query, for fluid interface

at line 605
AccessoryQuery joinProductRelatedByAccessory( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the ProductRelatedByAccessory relation

Parameters

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

Return Value

AccessoryQuery The current query, for fluid interface

at line 640
ProductQuery useProductRelatedByAccessoryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the ProductRelatedByAccessory relation Product 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

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

See also

useQuery()

at line 654
AccessoryQuery prune( Accessory $accessory = null)

Exclude object from result

Parameters

Accessory $accessory Object to remove from the list of results

Return Value

AccessoryQuery The current query, for fluid interface

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

Deletes all rows from the accessory table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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

Performs a DELETE on the database, given a ChildAccessory 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.

at line 747
AccessoryQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

AccessoryQuery The current query, for fluid interface

at line 759
AccessoryQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

AccessoryQuery The current query, for fluid interface

at line 769
AccessoryQuery lastUpdatedFirst()

Order by update date desc

Return Value

AccessoryQuery The current query, for fluid interface

at line 779
AccessoryQuery firstUpdatedFirst()

Order by update date asc

Return Value

AccessoryQuery The current query, for fluid interface

at line 789
AccessoryQuery lastCreatedFirst()

Order by create date desc

Return Value

AccessoryQuery The current query, for fluid interface

at line 799
AccessoryQuery firstCreatedFirst()

Order by create date asc

Return Value

AccessoryQuery The current query, for fluid interface

at line 68
ChildAccessoryQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery orderByProductId($order = Criteria::ASC)

Order by the product_id column

Parameters

$order

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery orderByAccessory($order = Criteria::ASC)

Order by the accessory column

Parameters

$order

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery orderByPosition($order = Criteria::ASC)

Order by the position column

Parameters

$order

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery groupById()

Group by the id column

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery groupByProductId()

Group by the product_id column

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery groupByAccessory()

Group by the accessory column

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery groupByPosition()

Group by the position column

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery leftJoinProductRelatedByProductId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery rightJoinProductRelatedByProductId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery innerJoinProductRelatedByProductId($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery leftJoinProductRelatedByAccessory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery rightJoinProductRelatedByAccessory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAccessoryQuery

at line 68
ChildAccessoryQuery innerJoinProductRelatedByAccessory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildAccessoryQuery

at line 68
ChildAccessory findOne( ConnectionInterface $con = null)

Return the first ChildAccessory matching the query

Parameters

ConnectionInterface $con

Return Value

ChildAccessory

at line 68
ChildAccessory findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildAccessory

at line 68
ChildAccessory findOneById( int $id)

Return the first ChildAccessory filtered by the id column

Parameters

int $id

Return Value

ChildAccessory

at line 68
ChildAccessory findOneByProductId( int $product_id)

Return the first ChildAccessory filtered by the product_id column

Parameters

int $product_id

Return Value

ChildAccessory

at line 68
ChildAccessory findOneByAccessory( int $accessory)

Return the first ChildAccessory filtered by the accessory column

Parameters

int $accessory

Return Value

ChildAccessory

at line 68
ChildAccessory findOneByPosition( int $position)

Return the first ChildAccessory filtered by the position column

Parameters

int $position

Return Value

ChildAccessory

at line 68
ChildAccessory findOneByCreatedAt( string $created_at)

Return the first ChildAccessory filtered by the created_at column

Parameters

string $created_at

Return Value

ChildAccessory

at line 68
ChildAccessory findOneByUpdatedAt( string $updated_at)

Return the first ChildAccessory filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildAccessory

at line 68
array findById( int $id)

Return ChildAccessory objects filtered by the id column

Parameters

int $id

Return Value

array

at line 68
array findByProductId( int $product_id)

Return ChildAccessory objects filtered by the product_id column

Parameters

int $product_id

Return Value

array

at line 68
array findByAccessory( int $accessory)

Return ChildAccessory objects filtered by the accessory column

Parameters

int $accessory

Return Value

array

at line 68
array findByPosition( int $position)

Return ChildAccessory objects filtered by the position column

Parameters

int $position

Return Value

array

at line 68
array findByCreatedAt( string $created_at)

Return ChildAccessory objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 68
array findByUpdatedAt( string $updated_at)

Return ChildAccessory objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array