CategoryVersionQuery
class CategoryVersionQuery extends ModelCriteria
Base class that represents a query for the 'category_version' table.
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 id column
Group by the parent column
Group by the visible column
Group by the position column
Group by the defaulttemplateid column
Group by the created_at column
Group by the updated_at column
Group by the version 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
at line 90
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CategoryVersion',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CategoryVersionQuery object.
at line 103
static
CategoryVersionQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCategoryVersionQuery object.
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);
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);
at line 237
CategoryVersionQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 252
CategoryVersionQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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
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
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
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
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'
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'
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
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'
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%'
at line 681
CategoryVersionQuery
filterByCategory(
Category|ObjectCollection $category,
string $comparison = null)
Filter the query by a related \Thelia\Model\Category object
at line 706
CategoryVersionQuery
joinCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Category relation
at line 741
CategoryQuery
useCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Category relation Category object
at line 755
CategoryVersionQuery
prune(
CategoryVersion $categoryVersion = null)
Exclude object from result
at line 772
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the category_version table.
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.
at line 80
ChildCategoryVersionQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 80
ChildCategoryVersionQuery
orderByParent($order = Criteria::ASC)
Order by the parent column
at line 80
ChildCategoryVersionQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
at line 80
ChildCategoryVersionQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 80
ChildCategoryVersionQuery
orderByDefaultTemplateId($order = Criteria::ASC)
Order by the defaulttemplateid column
at line 80
ChildCategoryVersionQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 80
ChildCategoryVersionQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 80
ChildCategoryVersionQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
at line 80
ChildCategoryVersionQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
at line 80
ChildCategoryVersionQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
at line 80
ChildCategoryVersionQuery
groupById()
Group by the id column
at line 80
ChildCategoryVersionQuery
groupByParent()
Group by the parent column
at line 80
ChildCategoryVersionQuery
groupByVisible()
Group by the visible column
at line 80
ChildCategoryVersionQuery
groupByPosition()
Group by the position column
at line 80
ChildCategoryVersionQuery
groupByDefaultTemplateId()
Group by the defaulttemplateid column
at line 80
ChildCategoryVersionQuery
groupByCreatedAt()
Group by the created_at column
at line 80
ChildCategoryVersionQuery
groupByUpdatedAt()
Group by the updated_at column
at line 80
ChildCategoryVersionQuery
groupByVersion()
Group by the version column
at line 80
ChildCategoryVersionQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
at line 80
ChildCategoryVersionQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
at line 80
ChildCategoryVersionQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 80
ChildCategoryVersionQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 80
ChildCategoryVersionQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 80
ChildCategoryVersionQuery
leftJoinCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Category relation
at line 80
ChildCategoryVersionQuery
rightJoinCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Category relation
at line 80
ChildCategoryVersionQuery
innerJoinCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the Category relation
at line 80
ChildCategoryVersion
findOne(
ConnectionInterface $con = null)
Return the first ChildCategoryVersion matching the query
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
at line 80
ChildCategoryVersion
findOneById(
int $id)
Return the first ChildCategoryVersion filtered by the id column
at line 80
ChildCategoryVersion
findOneByParent(
int $parent)
Return the first ChildCategoryVersion filtered by the parent column
at line 80
ChildCategoryVersion
findOneByVisible(
int $visible)
Return the first ChildCategoryVersion filtered by the visible column
at line 80
ChildCategoryVersion
findOneByPosition(
int $position)
Return the first ChildCategoryVersion filtered by the position column
at line 80
ChildCategoryVersion
findOneByDefaultTemplateId(
int $default_template_id)
Return the first ChildCategoryVersion filtered by the defaulttemplateid column
at line 80
ChildCategoryVersion
findOneByCreatedAt(
string $created_at)
Return the first ChildCategoryVersion filtered by the created_at column
at line 80
ChildCategoryVersion
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCategoryVersion filtered by the updated_at column
at line 80
ChildCategoryVersion
findOneByVersion(
int $version)
Return the first ChildCategoryVersion filtered by the version column
at line 80
ChildCategoryVersion
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildCategoryVersion filtered by the versioncreatedat column
at line 80
ChildCategoryVersion
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildCategoryVersion filtered by the versioncreatedby column
at line 80
array
findById(
int $id)
Return ChildCategoryVersion objects filtered by the id column
at line 80
array
findByParent(
int $parent)
Return ChildCategoryVersion objects filtered by the parent column
at line 80
array
findByVisible(
int $visible)
Return ChildCategoryVersion objects filtered by the visible column
at line 80
array
findByPosition(
int $position)
Return ChildCategoryVersion objects filtered by the position column
at line 80
array
findByDefaultTemplateId(
int $default_template_id)
Return ChildCategoryVersion objects filtered by the defaulttemplateid column
at line 80
array
findByCreatedAt(
string $created_at)
Return ChildCategoryVersion objects filtered by the created_at column
at line 80
array
findByUpdatedAt(
string $updated_at)
Return ChildCategoryVersion objects filtered by the updated_at column
at line 80
array
findByVersion(
int $version)
Return ChildCategoryVersion objects filtered by the version column
at line 80
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildCategoryVersion objects filtered by the versioncreatedat column
at line 80
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildCategoryVersion objects filtered by the versioncreatedby column