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