class CategoryI18nQuery extends ModelCriteria

Base class that represents a query for the 'category_i18n' table.

Methods

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

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

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

Returns a new ChildCategoryI18nQuery object.

CategoryI18n|array|mixed
findPk($key, $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(array(12, 56), array(832, 123), array(123, 456)), $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

filterByLocale( string $locale = null, string $comparison = null)

Filter the query on the locale column

filterByTitle( string $title = null, string $comparison = null)

Filter the query on the title column

filterByDescription( string $description = null, string $comparison = null)

Filter the query on the description column

filterByChapo( string $chapo = null, string $comparison = null)

Filter the query on the chapo column

filterByPostscriptum( string $postscriptum = null, string $comparison = null)

Filter the query on the postscriptum column

filterByMetaTitle( string $metaTitle = null, string $comparison = null)

Filter the query on the meta_title column

filterByMetaDescription( string $metaDescription = null, string $comparison = null)

Filter the query on the meta_description column

filterByMetaKeywords( string $metaKeywords = null, string $comparison = null)

Filter the query on the meta_keywords column

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

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

joinCategory( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the Category relation

useCategoryQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the Category relation Category object

prune( CategoryI18n $categoryI18n = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the category_i18n table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildCategoryI18n or Criteria object OR a primary key value.

ChildCategoryI18nQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildCategoryI18nQuery
orderByLocale($order = Criteria::ASC)

Order by the locale column

ChildCategoryI18nQuery
orderByTitle($order = Criteria::ASC)

Order by the title column

ChildCategoryI18nQuery
orderByDescription($order = Criteria::ASC)

Order by the description column

ChildCategoryI18nQuery
orderByChapo($order = Criteria::ASC)

Order by the chapo column

ChildCategoryI18nQuery
orderByPostscriptum($order = Criteria::ASC)

Order by the postscriptum column

ChildCategoryI18nQuery
orderByMetaTitle($order = Criteria::ASC)

Order by the meta_title column

ChildCategoryI18nQuery
orderByMetaDescription($order = Criteria::ASC)

Order by the meta_description column

ChildCategoryI18nQuery
orderByMetaKeywords($order = Criteria::ASC)

Order by the meta_keywords column

ChildCategoryI18nQuery
groupById()

Group by the id column

ChildCategoryI18nQuery
groupByLocale()

Group by the locale column

ChildCategoryI18nQuery
groupByTitle()

Group by the title column

ChildCategoryI18nQuery
groupByDescription()

Group by the description column

ChildCategoryI18nQuery
groupByChapo()

Group by the chapo column

ChildCategoryI18nQuery
groupByPostscriptum()

Group by the postscriptum column

ChildCategoryI18nQuery
groupByMetaTitle()

Group by the meta_title column

ChildCategoryI18nQuery
groupByMetaDescription()

Group by the meta_description column

ChildCategoryI18nQuery
groupByMetaKeywords()

Group by the meta_keywords column

ChildCategoryI18nQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCategoryI18nQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCategoryI18nQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCategoryI18nQuery
leftJoinCategory($relationAlias = null)

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

ChildCategoryI18nQuery
rightJoinCategory($relationAlias = null)

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

ChildCategoryI18nQuery
innerJoinCategory($relationAlias = null)

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

ChildCategoryI18n
findOne( ConnectionInterface $con = null)

Return the first ChildCategoryI18n matching the query

ChildCategoryI18n
findOneOrCreate( ConnectionInterface $con = null)

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

ChildCategoryI18n
findOneById( int $id)

Return the first ChildCategoryI18n filtered by the id column

ChildCategoryI18n
findOneByLocale( string $locale)

Return the first ChildCategoryI18n filtered by the locale column

ChildCategoryI18n
findOneByTitle( string $title)

Return the first ChildCategoryI18n filtered by the title column

ChildCategoryI18n
findOneByDescription( string $description)

Return the first ChildCategoryI18n filtered by the description column

ChildCategoryI18n
findOneByChapo( string $chapo)

Return the first ChildCategoryI18n filtered by the chapo column

ChildCategoryI18n
findOneByPostscriptum( string $postscriptum)

Return the first ChildCategoryI18n filtered by the postscriptum column

ChildCategoryI18n
findOneByMetaTitle( string $meta_title)

Return the first ChildCategoryI18n filtered by the meta_title column

ChildCategoryI18n
findOneByMetaDescription( string $meta_description)

Return the first ChildCategoryI18n filtered by the meta_description column

ChildCategoryI18n
findOneByMetaKeywords( string $meta_keywords)

Return the first ChildCategoryI18n filtered by the meta_keywords column

array
findById( int $id)

Return ChildCategoryI18n objects filtered by the id column

array
findByLocale( string $locale)

Return ChildCategoryI18n objects filtered by the locale column

array
findByTitle( string $title)

Return ChildCategoryI18n objects filtered by the title column

array
findByDescription( string $description)

Return ChildCategoryI18n objects filtered by the description column

array
findByChapo( string $chapo)

Return ChildCategoryI18n objects filtered by the chapo column

array
findByPostscriptum( string $postscriptum)

Return ChildCategoryI18n objects filtered by the postscriptum column

array
findByMetaTitle( string $meta_title)

Return ChildCategoryI18n objects filtered by the meta_title column

array
findByMetaDescription( string $meta_description)

Return ChildCategoryI18n objects filtered by the meta_description column

array
findByMetaKeywords( string $meta_keywords)

Return ChildCategoryI18n objects filtered by the meta_keywords column

Details

at line 86
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\CategoryI18n', string $modelAlias = null)

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

at line 99
static CategoryI18nQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCategoryI18nQuery object.

Parameters

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

Return Value

CategoryI18nQuery

at line 129
CategoryI18n|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);

Parameters

$key
$con

Return Value

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

at line 212
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);

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

at line 233
CategoryI18nQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 248
CategoryI18nQuery 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

CategoryI18nQuery The current query, for fluid interface

at line 283
CategoryI18nQuery 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

CategoryI18nQuery The current query, for fluid interface

See also

filterByCategory()

at line 321
CategoryI18nQuery filterByLocale( string $locale = null, string $comparison = null)

Filter the query on the locale column

Example usage: $query->filterByLocale('fooValue'); // WHERE locale = 'fooValue' $query->filterByLocale('%fooValue%'); // WHERE locale LIKE '%fooValue%'

Parameters

string $locale The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 350
CategoryI18nQuery filterByTitle( string $title = null, string $comparison = null)

Filter the query on the title column

Example usage: $query->filterByTitle('fooValue'); // WHERE title = 'fooValue' $query->filterByTitle('%fooValue%'); // WHERE title LIKE '%fooValue%'

Parameters

string $title The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 379
CategoryI18nQuery filterByDescription( string $description = null, string $comparison = null)

Filter the query on the description column

Example usage: $query->filterByDescription('fooValue'); // WHERE description = 'fooValue' $query->filterByDescription('%fooValue%'); // WHERE description LIKE '%fooValue%'

Parameters

string $description The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 408
CategoryI18nQuery filterByChapo( string $chapo = null, string $comparison = null)

Filter the query on the chapo column

Example usage: $query->filterByChapo('fooValue'); // WHERE chapo = 'fooValue' $query->filterByChapo('%fooValue%'); // WHERE chapo LIKE '%fooValue%'

Parameters

string $chapo The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 437
CategoryI18nQuery filterByPostscriptum( string $postscriptum = null, string $comparison = null)

Filter the query on the postscriptum column

Example usage: $query->filterByPostscriptum('fooValue'); // WHERE postscriptum = 'fooValue' $query->filterByPostscriptum('%fooValue%'); // WHERE postscriptum LIKE '%fooValue%'

Parameters

string $postscriptum The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 466
CategoryI18nQuery filterByMetaTitle( string $metaTitle = null, string $comparison = null)

Filter the query on the meta_title column

Example usage: $query->filterByMetaTitle('fooValue'); // WHERE metatitle = 'fooValue' $query->filterByMetaTitle('%fooValue%'); // WHERE metatitle LIKE '%fooValue%'

Parameters

string $metaTitle The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 495
CategoryI18nQuery filterByMetaDescription( string $metaDescription = null, string $comparison = null)

Filter the query on the meta_description column

Example usage: $query->filterByMetaDescription('fooValue'); // WHERE metadescription = 'fooValue' $query->filterByMetaDescription('%fooValue%'); // WHERE metadescription LIKE '%fooValue%'

Parameters

string $metaDescription The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 524
CategoryI18nQuery filterByMetaKeywords( string $metaKeywords = null, string $comparison = null)

Filter the query on the meta_keywords column

Example usage: $query->filterByMetaKeywords('fooValue'); // WHERE metakeywords = 'fooValue' $query->filterByMetaKeywords('%fooValue%'); // WHERE metakeywords LIKE '%fooValue%'

Parameters

string $metaKeywords The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 546
CategoryI18nQuery 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

CategoryI18nQuery The current query, for fluid interface

at line 571
CategoryI18nQuery joinCategory( string $relationAlias = null, string $joinType = 'LEFT 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

CategoryI18nQuery The current query, for fluid interface

at line 606
CategoryQuery useCategoryQuery( string $relationAlias = null, string $joinType = 'LEFT 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()

at line 620
CategoryI18nQuery prune( CategoryI18n $categoryI18n = null)

Exclude object from result

Parameters

CategoryI18n $categoryI18n Object to remove from the list of results

Return Value

CategoryI18nQuery The current query, for fluid interface

at line 637
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the category_i18n table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

at line 674
int delete( ConnectionInterface $con = null)

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

at line 76
ChildCategoryI18nQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByLocale($order = Criteria::ASC)

Order by the locale column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByTitle($order = Criteria::ASC)

Order by the title column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByDescription($order = Criteria::ASC)

Order by the description column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByChapo($order = Criteria::ASC)

Order by the chapo column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByPostscriptum($order = Criteria::ASC)

Order by the postscriptum column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByMetaTitle($order = Criteria::ASC)

Order by the meta_title column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByMetaDescription($order = Criteria::ASC)

Order by the meta_description column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery orderByMetaKeywords($order = Criteria::ASC)

Order by the meta_keywords column

Parameters

$order

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupById()

Group by the id column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByLocale()

Group by the locale column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByTitle()

Group by the title column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByDescription()

Group by the description column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByChapo()

Group by the chapo column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByPostscriptum()

Group by the postscriptum column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByMetaTitle()

Group by the meta_title column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByMetaDescription()

Group by the meta_description column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery groupByMetaKeywords()

Group by the meta_keywords column

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery leftJoinCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery rightJoinCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18nQuery innerJoinCategory($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCategoryI18nQuery

at line 76
ChildCategoryI18n findOne( ConnectionInterface $con = null)

Return the first ChildCategoryI18n matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneById( int $id)

Return the first ChildCategoryI18n filtered by the id column

Parameters

int $id

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByLocale( string $locale)

Return the first ChildCategoryI18n filtered by the locale column

Parameters

string $locale

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByTitle( string $title)

Return the first ChildCategoryI18n filtered by the title column

Parameters

string $title

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByDescription( string $description)

Return the first ChildCategoryI18n filtered by the description column

Parameters

string $description

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByChapo( string $chapo)

Return the first ChildCategoryI18n filtered by the chapo column

Parameters

string $chapo

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByPostscriptum( string $postscriptum)

Return the first ChildCategoryI18n filtered by the postscriptum column

Parameters

string $postscriptum

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByMetaTitle( string $meta_title)

Return the first ChildCategoryI18n filtered by the meta_title column

Parameters

string $meta_title

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByMetaDescription( string $meta_description)

Return the first ChildCategoryI18n filtered by the meta_description column

Parameters

string $meta_description

Return Value

ChildCategoryI18n

at line 76
ChildCategoryI18n findOneByMetaKeywords( string $meta_keywords)

Return the first ChildCategoryI18n filtered by the meta_keywords column

Parameters

string $meta_keywords

Return Value

ChildCategoryI18n

at line 76
array findById( int $id)

Return ChildCategoryI18n objects filtered by the id column

Parameters

int $id

Return Value

array

at line 76
array findByLocale( string $locale)

Return ChildCategoryI18n objects filtered by the locale column

Parameters

string $locale

Return Value

array

at line 76
array findByTitle( string $title)

Return ChildCategoryI18n objects filtered by the title column

Parameters

string $title

Return Value

array

at line 76
array findByDescription( string $description)

Return ChildCategoryI18n objects filtered by the description column

Parameters

string $description

Return Value

array

at line 76
array findByChapo( string $chapo)

Return ChildCategoryI18n objects filtered by the chapo column

Parameters

string $chapo

Return Value

array

at line 76
array findByPostscriptum( string $postscriptum)

Return ChildCategoryI18n objects filtered by the postscriptum column

Parameters

string $postscriptum

Return Value

array

at line 76
array findByMetaTitle( string $meta_title)

Return ChildCategoryI18n objects filtered by the meta_title column

Parameters

string $meta_title

Return Value

array

at line 76
array findByMetaDescription( string $meta_description)

Return ChildCategoryI18n objects filtered by the meta_description column

Parameters

string $meta_description

Return Value

array

at line 76
array findByMetaKeywords( string $meta_keywords)

Return ChildCategoryI18n objects filtered by the meta_keywords column

Parameters

string $meta_keywords

Return Value

array