AccessoryQuery
class AccessoryQuery extends ModelCriteria
Base class that represents a query for the 'accessory' table.
Methods
Initializes internal state of \Thelia\Model\Base\AccessoryQuery object.
Returns a new ChildAccessoryQuery 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 product_id column
Filter the query on the accessory 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\Product object
Adds a JOIN clause to the query using the ProductRelatedByProductId relation
Use the ProductRelatedByProductId relation Product object
Filter the query by a related \Thelia\Model\Product object
Adds a JOIN clause to the query using the ProductRelatedByAccessory relation
Use the ProductRelatedByAccessory relation Product object
Deletes all rows from the accessory table.
Performs a DELETE on the database, given a ChildAccessory 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
Order by the id column
Order by the product_id column
Order by the accessory 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 product_id column
Group by the accessory 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 ProductRelatedByProductId relation
Adds a RIGHT JOIN clause to the query using the ProductRelatedByProductId relation
Adds a INNER JOIN clause to the query using the ProductRelatedByProductId relation
Adds a LEFT JOIN clause to the query using the ProductRelatedByAccessory relation
Adds a RIGHT JOIN clause to the query using the ProductRelatedByAccessory relation
Adds a INNER JOIN clause to the query using the ProductRelatedByAccessory relation
Return the first ChildAccessory matching the query
Return the first ChildAccessory matching the query, or a new ChildAccessory object populated from the query conditions when no match is found
Return the first ChildAccessory filtered by the id column
Return the first ChildAccessory filtered by the product_id column
Return the first ChildAccessory filtered by the accessory column
Return the first ChildAccessory filtered by the position column
Return the first ChildAccessory filtered by the created_at column
Return the first ChildAccessory filtered by the updated_at column
Return ChildAccessory objects filtered by the id column
Return ChildAccessory objects filtered by the product_id column
Return ChildAccessory objects filtered by the accessory column
Return ChildAccessory objects filtered by the position column
Return ChildAccessory objects filtered by the created_at column
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.
at line 91
static
AccessoryQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildAccessoryQuery object.
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);
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);
at line 224
AccessoryQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 237
AccessoryQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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
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
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
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'
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'
at line 505
AccessoryQuery
filterByProductRelatedByProductId(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
at line 530
AccessoryQuery
joinProductRelatedByProductId(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductRelatedByProductId relation
at line 565
ProductQuery
useProductRelatedByProductIdQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductRelatedByProductId relation Product object
at line 580
AccessoryQuery
filterByProductRelatedByAccessory(
Product|ObjectCollection $product,
string $comparison = null)
Filter the query by a related \Thelia\Model\Product object
at line 605
AccessoryQuery
joinProductRelatedByAccessory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProductRelatedByAccessory relation
at line 640
ProductQuery
useProductRelatedByAccessoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProductRelatedByAccessory relation Product object
at line 654
AccessoryQuery
prune(
Accessory $accessory = null)
Exclude object from result
at line 669
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the accessory table.
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.
at line 747
AccessoryQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 759
AccessoryQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 769
AccessoryQuery
lastUpdatedFirst()
Order by update date desc
at line 779
AccessoryQuery
firstUpdatedFirst()
Order by update date asc
at line 789
AccessoryQuery
lastCreatedFirst()
Order by create date desc
at line 799
AccessoryQuery
firstCreatedFirst()
Order by create date asc
at line 68
ChildAccessoryQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 68
ChildAccessoryQuery
orderByProductId($order = Criteria::ASC)
Order by the product_id column
at line 68
ChildAccessoryQuery
orderByAccessory($order = Criteria::ASC)
Order by the accessory column
at line 68
ChildAccessoryQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 68
ChildAccessoryQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 68
ChildAccessoryQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 68
ChildAccessoryQuery
groupById()
Group by the id column
at line 68
ChildAccessoryQuery
groupByProductId()
Group by the product_id column
at line 68
ChildAccessoryQuery
groupByAccessory()
Group by the accessory column
at line 68
ChildAccessoryQuery
groupByPosition()
Group by the position column
at line 68
ChildAccessoryQuery
groupByCreatedAt()
Group by the created_at column
at line 68
ChildAccessoryQuery
groupByUpdatedAt()
Group by the updated_at column
at line 68
ChildAccessoryQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 68
ChildAccessoryQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 68
ChildAccessoryQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 68
ChildAccessoryQuery
leftJoinProductRelatedByProductId($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductRelatedByProductId relation
at line 68
ChildAccessoryQuery
rightJoinProductRelatedByProductId($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductRelatedByProductId relation
at line 68
ChildAccessoryQuery
innerJoinProductRelatedByProductId($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductRelatedByProductId relation
at line 68
ChildAccessoryQuery
leftJoinProductRelatedByAccessory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProductRelatedByAccessory relation
at line 68
ChildAccessoryQuery
rightJoinProductRelatedByAccessory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProductRelatedByAccessory relation
at line 68
ChildAccessoryQuery
innerJoinProductRelatedByAccessory($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProductRelatedByAccessory relation
at line 68
ChildAccessory
findOne(
ConnectionInterface $con = null)
Return the first ChildAccessory matching the query
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
at line 68
ChildAccessory
findOneById(
int $id)
Return the first ChildAccessory filtered by the id column
at line 68
ChildAccessory
findOneByProductId(
int $product_id)
Return the first ChildAccessory filtered by the product_id column
at line 68
ChildAccessory
findOneByAccessory(
int $accessory)
Return the first ChildAccessory filtered by the accessory column
at line 68
ChildAccessory
findOneByPosition(
int $position)
Return the first ChildAccessory filtered by the position column
at line 68
ChildAccessory
findOneByCreatedAt(
string $created_at)
Return the first ChildAccessory filtered by the created_at column
at line 68
ChildAccessory
findOneByUpdatedAt(
string $updated_at)
Return the first ChildAccessory filtered by the updated_at column
at line 68
array
findById(
int $id)
Return ChildAccessory objects filtered by the id column
at line 68
array
findByProductId(
int $product_id)
Return ChildAccessory objects filtered by the product_id column
at line 68
array
findByAccessory(
int $accessory)
Return ChildAccessory objects filtered by the accessory column
at line 68
array
findByPosition(
int $position)
Return ChildAccessory objects filtered by the position column
at line 68
array
findByCreatedAt(
string $created_at)
Return ChildAccessory objects filtered by the created_at column
at line 68
array
findByUpdatedAt(
string $updated_at)
Return ChildAccessory objects filtered by the updated_at column