class CategoryAssociatedContentQuery extends CategoryAssociatedContentQuery

Skeleton subclass for performing query and update operations on the 'categoryassociatedcontent' 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

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

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

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

Returns a new ChildCategoryAssociatedContentQuery object.

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

filterByCategoryId( mixed $categoryId = null, string $comparison = null)

Filter the query on the category_id column

filterByContentId( mixed $contentId = null, string $comparison = null)

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

filterByCategory( Category|ObjectCollection $category, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Category relation

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

Use the Category relation Category object

filterByContent( Content|ObjectCollection $content, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Content relation

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

Use the Content relation Content object

prune( CategoryAssociatedContent $categoryAssociatedContent = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the categoryassociatedcontent table.

int
delete( ConnectionInterface $con = null)

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

ChildCategoryAssociatedContentQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildCategoryAssociatedContentQuery
orderByCategoryId($order = Criteria::ASC)

Order by the category_id column

ChildCategoryAssociatedContentQuery
orderByContentId($order = Criteria::ASC)

Order by the content_id column

ChildCategoryAssociatedContentQuery
orderByPosition($order = Criteria::ASC)

Order by the position column

ChildCategoryAssociatedContentQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildCategoryAssociatedContentQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildCategoryAssociatedContentQuery
groupById()

Group by the id column

ChildCategoryAssociatedContentQuery
groupByCategoryId()

Group by the category_id column

ChildCategoryAssociatedContentQuery
groupByContentId()

Group by the content_id column

ChildCategoryAssociatedContentQuery
groupByPosition()

Group by the position column

ChildCategoryAssociatedContentQuery
groupByCreatedAt()

Group by the created_at column

ChildCategoryAssociatedContentQuery
groupByUpdatedAt()

Group by the updated_at column

ChildCategoryAssociatedContentQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCategoryAssociatedContentQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCategoryAssociatedContentQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCategoryAssociatedContentQuery
leftJoinCategory($relationAlias = null)

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

ChildCategoryAssociatedContentQuery
rightJoinCategory($relationAlias = null)

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

ChildCategoryAssociatedContentQuery
innerJoinCategory($relationAlias = null)

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

ChildCategoryAssociatedContentQuery
leftJoinContent($relationAlias = null)

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

ChildCategoryAssociatedContentQuery
rightJoinContent($relationAlias = null)

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

ChildCategoryAssociatedContentQuery
innerJoinContent($relationAlias = null)

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

ChildCategoryAssociatedContent
findOne( ConnectionInterface $con = null)

Return the first ChildCategoryAssociatedContent matching the query

ChildCategoryAssociatedContent
findOneOrCreate( ConnectionInterface $con = null)

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

ChildCategoryAssociatedContent
findOneById( int $id)

Return the first ChildCategoryAssociatedContent filtered by the id column

ChildCategoryAssociatedContent
findOneByCategoryId( int $category_id)

Return the first ChildCategoryAssociatedContent filtered by the category_id column

ChildCategoryAssociatedContent
findOneByContentId( int $content_id)

Return the first ChildCategoryAssociatedContent filtered by the content_id column

ChildCategoryAssociatedContent
findOneByPosition( int $position)

Return the first ChildCategoryAssociatedContent filtered by the position column

ChildCategoryAssociatedContent
findOneByCreatedAt( string $created_at)

Return the first ChildCategoryAssociatedContent filtered by the created_at column

ChildCategoryAssociatedContent
findOneByUpdatedAt( string $updated_at)

Return the first ChildCategoryAssociatedContent filtered by the updated_at column

array
findById( int $id)

Return ChildCategoryAssociatedContent objects filtered by the id column

array
findByCategoryId( int $category_id)

Return ChildCategoryAssociatedContent objects filtered by the category_id column

array
findByContentId( int $content_id)

Return ChildCategoryAssociatedContent objects filtered by the content_id column

array
findByPosition( int $position)

Return ChildCategoryAssociatedContent objects filtered by the position column

array
findByCreatedAt( string $created_at)

Return ChildCategoryAssociatedContent objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildCategoryAssociatedContent objects filtered by the updated_at column

Details

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

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

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

Returns a new ChildCategoryAssociatedContentQuery object.

Parameters

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

Return Value

CategoryAssociatedContentQuery

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

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

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

CategoryAssociatedContentQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery 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

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery 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

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery filterByCategoryId( mixed $categoryId = null, string $comparison = null)

Filter the query on the category_id column

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

Parameters

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

CategoryAssociatedContentQuery The current query, for fluid interface

See also

filterByCategory()

CategoryAssociatedContentQuery filterByContentId( mixed $contentId = null, string $comparison = null)

Filter the query on the content_id column

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

Parameters

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

CategoryAssociatedContentQuery The current query, for fluid interface

See also

filterByContent()

CategoryAssociatedContentQuery 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

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery 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

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery 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

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery filterByCategory( Category|ObjectCollection $category, string $comparison = null)

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

Parameters

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

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

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

Adds a JOIN clause to the query using the Category relation

Parameters

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

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

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

Use the Category relation Category 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

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

See also

useQuery()

CategoryAssociatedContentQuery filterByContent( Content|ObjectCollection $content, string $comparison = null)

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

Parameters

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

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

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

Adds a JOIN clause to the query using the Content relation

Parameters

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

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

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

Use the Content relation Content 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

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

See also

useQuery()

CategoryAssociatedContentQuery prune( CategoryAssociatedContent $categoryAssociatedContent = null)

Exclude object from result

Parameters

CategoryAssociatedContent $categoryAssociatedContent Object to remove from the list of results

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the categoryassociatedcontent table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

int delete( ConnectionInterface $con = null)

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

CategoryAssociatedContentQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery lastUpdatedFirst()

Order by update date desc

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery firstUpdatedFirst()

Order by update date asc

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery lastCreatedFirst()

Order by create date desc

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

CategoryAssociatedContentQuery firstCreatedFirst()

Order by create date asc

Return Value

CategoryAssociatedContentQuery The current query, for fluid interface

ChildCategoryAssociatedContentQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery orderByCategoryId($order = Criteria::ASC)

Order by the category_id column

Parameters

$order

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery orderByContentId($order = Criteria::ASC)

Order by the content_id column

Parameters

$order

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery orderByPosition($order = Criteria::ASC)

Order by the position column

Parameters

$order

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery groupById()

Group by the id column

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery groupByCategoryId()

Group by the category_id column

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery groupByContentId()

Group by the content_id column

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery groupByPosition()

Group by the position column

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery leftJoinCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery rightJoinCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery innerJoinCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery leftJoinContent($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery rightJoinContent($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContentQuery innerJoinContent($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryAssociatedContentQuery

ChildCategoryAssociatedContent findOne( ConnectionInterface $con = null)

Return the first ChildCategoryAssociatedContent matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCategoryAssociatedContent

ChildCategoryAssociatedContent findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildCategoryAssociatedContent

ChildCategoryAssociatedContent findOneById( int $id)

Return the first ChildCategoryAssociatedContent filtered by the id column

Parameters

int $id

Return Value

ChildCategoryAssociatedContent

ChildCategoryAssociatedContent findOneByCategoryId( int $category_id)

Return the first ChildCategoryAssociatedContent filtered by the category_id column

Parameters

int $category_id

Return Value

ChildCategoryAssociatedContent

ChildCategoryAssociatedContent findOneByContentId( int $content_id)

Return the first ChildCategoryAssociatedContent filtered by the content_id column

Parameters

int $content_id

Return Value

ChildCategoryAssociatedContent

ChildCategoryAssociatedContent findOneByPosition( int $position)

Return the first ChildCategoryAssociatedContent filtered by the position column

Parameters

int $position

Return Value

ChildCategoryAssociatedContent

ChildCategoryAssociatedContent findOneByCreatedAt( string $created_at)

Return the first ChildCategoryAssociatedContent filtered by the created_at column

Parameters

string $created_at

Return Value

ChildCategoryAssociatedContent

ChildCategoryAssociatedContent findOneByUpdatedAt( string $updated_at)

Return the first ChildCategoryAssociatedContent filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildCategoryAssociatedContent

array findById( int $id)

Return ChildCategoryAssociatedContent objects filtered by the id column

Parameters

int $id

Return Value

array

array findByCategoryId( int $category_id)

Return ChildCategoryAssociatedContent objects filtered by the category_id column

Parameters

int $category_id

Return Value

array

array findByContentId( int $content_id)

Return ChildCategoryAssociatedContent objects filtered by the content_id column

Parameters

int $content_id

Return Value

array

array findByPosition( int $position)

Return ChildCategoryAssociatedContent objects filtered by the position column

Parameters

int $position

Return Value

array

array findByCreatedAt( string $created_at)

Return ChildCategoryAssociatedContent objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

array findByUpdatedAt( string $updated_at)

Return ChildCategoryAssociatedContent objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array