CategoryVersionQuery
class CategoryVersionQuery extends CategoryVersionQuery
Skeleton subclass for performing query and update operations on the 'category_version' 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\CategoryVersionQuery object.
Returns a new ChildCategoryVersionQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $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 parent column
Filter the query on the visible column
Filter the query on the position column
Filter the query on the defaulttemplateid column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query on the version column
Filter the query on the versioncreatedat column
Filter the query on the versioncreatedby column
Filter the query by a related \Thelia\Model\Category object
Adds a JOIN clause to the query using the Category relation
Use the Category relation Category object
Deletes all rows from the category_version table.
Performs a DELETE on the database, given a ChildCategoryVersion or Criteria object OR a primary key value.
Order by the id column
Order by the parent column
Order by the visible column
Order by the position column
Order by the defaulttemplateid column
Order by the created_at column
Order by the updated_at column
Order by the version column
Order by the versioncreatedat column
Order by the versioncreatedby column
Group by the defaulttemplateid column
Group by the created_at column
Group by the updated_at column
Group by the versioncreatedat column
Group by the versioncreatedby 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 Category relation
Adds a RIGHT JOIN clause to the query using the Category relation
Adds a INNER JOIN clause to the query using the Category relation
Return the first ChildCategoryVersion matching the query
Return the first ChildCategoryVersion matching the query, or a new ChildCategoryVersion object populated from the query conditions when no match is found
Return the first ChildCategoryVersion filtered by the id column
Return the first ChildCategoryVersion filtered by the parent column
Return the first ChildCategoryVersion filtered by the visible column
Return the first ChildCategoryVersion filtered by the position column
Return the first ChildCategoryVersion filtered by the defaulttemplateid column
Return the first ChildCategoryVersion filtered by the created_at column
Return the first ChildCategoryVersion filtered by the updated_at column
Return the first ChildCategoryVersion filtered by the version column
Return the first ChildCategoryVersion filtered by the versioncreatedat column
Return the first ChildCategoryVersion filtered by the versioncreatedby column
Return ChildCategoryVersion objects filtered by the id column
Return ChildCategoryVersion objects filtered by the parent column
Return ChildCategoryVersion objects filtered by the visible column
Return ChildCategoryVersion objects filtered by the position column
Return ChildCategoryVersion objects filtered by the defaulttemplateid column
Return ChildCategoryVersion objects filtered by the created_at column
Return ChildCategoryVersion objects filtered by the updated_at column
Return ChildCategoryVersion objects filtered by the version column
Return ChildCategoryVersion objects filtered by the versioncreatedat column
Return ChildCategoryVersion objects filtered by the versioncreatedby column
Details
in
CategoryVersionQuery at line 90
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CategoryVersion',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CategoryVersionQuery object.
in
CategoryVersionQuery at line 103
static
CategoryVersionQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCategoryVersionQuery object.
in
CategoryVersionQuery at line 133
CategoryVersion|array|mixed
findPk($key, $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(array(12, 34), $con);
in
CategoryVersionQuery at line 216
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);
in
CategoryVersionQuery at line 237
CategoryVersionQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
CategoryVersionQuery at line 252
CategoryVersionQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
CategoryVersionQuery at line 287
CategoryVersionQuery
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
CategoryVersionQuery at line 328
CategoryVersionQuery
filterByParent(
mixed $parent = null,
string $comparison = null)
Filter the query on the parent column
Example usage:
$query->filterByParent(1234); // WHERE parent = 1234
$query->filterByParent(array(12, 34)); // WHERE parent IN (12, 34)
$query->filterByParent(array('min' => 12)); // WHERE parent > 12
in
CategoryVersionQuery at line 369
CategoryVersionQuery
filterByVisible(
mixed $visible = null,
string $comparison = null)
Filter the query on the visible column
Example usage:
$query->filterByVisible(1234); // WHERE visible = 1234
$query->filterByVisible(array(12, 34)); // WHERE visible IN (12, 34)
$query->filterByVisible(array('min' => 12)); // WHERE visible > 12
in
CategoryVersionQuery at line 410
CategoryVersionQuery
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
CategoryVersionQuery at line 451
CategoryVersionQuery
filterByDefaultTemplateId(
mixed $defaultTemplateId = null,
string $comparison = null)
Filter the query on the defaulttemplateid column
Example usage:
$query->filterByDefaultTemplateId(1234); // WHERE defaulttemplateid = 1234
$query->filterByDefaultTemplateId(array(12, 34)); // WHERE defaulttemplateid IN (12, 34)
$query->filterByDefaultTemplateId(array('min' => 12)); // WHERE defaulttemplateid > 12
in
CategoryVersionQuery at line 494
CategoryVersionQuery
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
CategoryVersionQuery at line 537
CategoryVersionQuery
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
CategoryVersionQuery at line 578
CategoryVersionQuery
filterByVersion(
mixed $version = null,
string $comparison = null)
Filter the query on the version column
Example usage:
$query->filterByVersion(1234); // WHERE version = 1234
$query->filterByVersion(array(12, 34)); // WHERE version IN (12, 34)
$query->filterByVersion(array('min' => 12)); // WHERE version > 12
in
CategoryVersionQuery at line 621
CategoryVersionQuery
filterByVersionCreatedAt(
mixed $versionCreatedAt = null,
string $comparison = null)
Filter the query on the versioncreatedat column
Example usage:
$query->filterByVersionCreatedAt('2011-03-14'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt('now'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt(array('max' => 'yesterday')); // WHERE versioncreatedat > '2011-03-13'
in
CategoryVersionQuery at line 659
CategoryVersionQuery
filterByVersionCreatedBy(
string $versionCreatedBy = null,
string $comparison = null)
Filter the query on the versioncreatedby column
Example usage:
$query->filterByVersionCreatedBy('fooValue'); // WHERE versioncreatedby = 'fooValue'
$query->filterByVersionCreatedBy('%fooValue%'); // WHERE versioncreatedby LIKE '%fooValue%'
in
CategoryVersionQuery at line 681
CategoryVersionQuery
filterByCategory(
Category|ObjectCollection $category,
string $comparison = null)
Filter the query by a related \Thelia\Model\Category object
in
CategoryVersionQuery at line 706
CategoryVersionQuery
joinCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Category relation
in
CategoryVersionQuery at line 741
CategoryQuery
useCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Category relation Category object
in
CategoryVersionQuery at line 755
CategoryVersionQuery
prune(
CategoryVersion $categoryVersion = null)
Exclude object from result
in
CategoryVersionQuery at line 772
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the category_version table.
in
CategoryVersionQuery at line 809
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCategoryVersion or Criteria object OR a primary key value.
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderById($order = Criteria::ASC)
Order by the id column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByParent($order = Criteria::ASC)
Order by the parent column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByDefaultTemplateId($order = Criteria::ASC)
Order by the defaulttemplateid column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupById()
Group by the id column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByParent()
Group by the parent column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByVisible()
Group by the visible column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByPosition()
Group by the position column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByDefaultTemplateId()
Group by the defaulttemplateid column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByCreatedAt()
Group by the created_at column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByUpdatedAt()
Group by the updated_at column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByVersion()
Group by the version column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
leftJoinCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Category relation
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
rightJoinCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Category relation
in
CategoryVersionQuery at line 80
ChildCategoryVersionQuery
innerJoinCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the Category relation
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOne(
ConnectionInterface $con = null)
Return the first ChildCategoryVersion matching the query
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCategoryVersion matching the query, or a new ChildCategoryVersion object populated from the query conditions when no match is found
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneById(
int $id)
Return the first ChildCategoryVersion filtered by the id column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByParent(
int $parent)
Return the first ChildCategoryVersion filtered by the parent column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByVisible(
int $visible)
Return the first ChildCategoryVersion filtered by the visible column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByPosition(
int $position)
Return the first ChildCategoryVersion filtered by the position column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByDefaultTemplateId(
int $default_template_id)
Return the first ChildCategoryVersion filtered by the defaulttemplateid column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByCreatedAt(
string $created_at)
Return the first ChildCategoryVersion filtered by the created_at column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCategoryVersion filtered by the updated_at column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByVersion(
int $version)
Return the first ChildCategoryVersion filtered by the version column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildCategoryVersion filtered by the versioncreatedat column
in
CategoryVersionQuery at line 80
ChildCategoryVersion
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildCategoryVersion filtered by the versioncreatedby column
in
CategoryVersionQuery at line 80
array
findById(
int $id)
Return ChildCategoryVersion objects filtered by the id column
in
CategoryVersionQuery at line 80
array
findByParent(
int $parent)
Return ChildCategoryVersion objects filtered by the parent column
in
CategoryVersionQuery at line 80
array
findByVisible(
int $visible)
Return ChildCategoryVersion objects filtered by the visible column
in
CategoryVersionQuery at line 80
array
findByPosition(
int $position)
Return ChildCategoryVersion objects filtered by the position column
in
CategoryVersionQuery at line 80
array
findByDefaultTemplateId(
int $default_template_id)
Return ChildCategoryVersion objects filtered by the defaulttemplateid column
in
CategoryVersionQuery at line 80
array
findByCreatedAt(
string $created_at)
Return ChildCategoryVersion objects filtered by the created_at column
in
CategoryVersionQuery at line 80
array
findByUpdatedAt(
string $updated_at)
Return ChildCategoryVersion objects filtered by the updated_at column
in
CategoryVersionQuery at line 80
array
findByVersion(
int $version)
Return ChildCategoryVersion objects filtered by the version column
in
CategoryVersionQuery at line 80
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildCategoryVersion objects filtered by the versioncreatedat column
in
CategoryVersionQuery at line 80
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildCategoryVersion objects filtered by the versioncreatedby column