class ProductI18nQuery extends ProductI18nQuery

Skeleton subclass for performing query and update operations on the 'product_i18n' 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\\ProductI18n', string $modelAlias = null)

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

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

Returns a new ChildProductI18nQuery object.

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

filterByProduct( Product|ObjectCollection $product, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Product relation

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

Use the Product relation Product object

prune( ProductI18n $productI18n = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the product_i18n table.

int
delete( ConnectionInterface $con = null)

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

ChildProductI18nQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildProductI18nQuery
orderByLocale($order = Criteria::ASC)

Order by the locale column

ChildProductI18nQuery
orderByTitle($order = Criteria::ASC)

Order by the title column

ChildProductI18nQuery
orderByDescription($order = Criteria::ASC)

Order by the description column

ChildProductI18nQuery
orderByChapo($order = Criteria::ASC)

Order by the chapo column

ChildProductI18nQuery
orderByPostscriptum($order = Criteria::ASC)

Order by the postscriptum column

ChildProductI18nQuery
orderByMetaTitle($order = Criteria::ASC)

Order by the meta_title column

ChildProductI18nQuery
orderByMetaDescription($order = Criteria::ASC)

Order by the meta_description column

ChildProductI18nQuery
orderByMetaKeywords($order = Criteria::ASC)

Order by the meta_keywords column

ChildProductI18nQuery
groupById()

Group by the id column

ChildProductI18nQuery
groupByLocale()

Group by the locale column

ChildProductI18nQuery
groupByTitle()

Group by the title column

ChildProductI18nQuery
groupByDescription()

Group by the description column

ChildProductI18nQuery
groupByChapo()

Group by the chapo column

ChildProductI18nQuery
groupByPostscriptum()

Group by the postscriptum column

ChildProductI18nQuery
groupByMetaTitle()

Group by the meta_title column

ChildProductI18nQuery
groupByMetaDescription()

Group by the meta_description column

ChildProductI18nQuery
groupByMetaKeywords()

Group by the meta_keywords column

ChildProductI18nQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildProductI18nQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildProductI18nQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildProductI18nQuery
leftJoinProduct($relationAlias = null)

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

ChildProductI18nQuery
rightJoinProduct($relationAlias = null)

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

ChildProductI18nQuery
innerJoinProduct($relationAlias = null)

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

ChildProductI18n
findOne( ConnectionInterface $con = null)

Return the first ChildProductI18n matching the query

ChildProductI18n
findOneOrCreate( ConnectionInterface $con = null)

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

ChildProductI18n
findOneById( int $id)

Return the first ChildProductI18n filtered by the id column

ChildProductI18n
findOneByLocale( string $locale)

Return the first ChildProductI18n filtered by the locale column

ChildProductI18n
findOneByTitle( string $title)

Return the first ChildProductI18n filtered by the title column

ChildProductI18n
findOneByDescription( string $description)

Return the first ChildProductI18n filtered by the description column

ChildProductI18n
findOneByChapo( string $chapo)

Return the first ChildProductI18n filtered by the chapo column

ChildProductI18n
findOneByPostscriptum( string $postscriptum)

Return the first ChildProductI18n filtered by the postscriptum column

ChildProductI18n
findOneByMetaTitle( string $meta_title)

Return the first ChildProductI18n filtered by the meta_title column

ChildProductI18n
findOneByMetaDescription( string $meta_description)

Return the first ChildProductI18n filtered by the meta_description column

ChildProductI18n
findOneByMetaKeywords( string $meta_keywords)

Return the first ChildProductI18n filtered by the meta_keywords column

array
findById( int $id)

Return ChildProductI18n objects filtered by the id column

array
findByLocale( string $locale)

Return ChildProductI18n objects filtered by the locale column

array
findByTitle( string $title)

Return ChildProductI18n objects filtered by the title column

array
findByDescription( string $description)

Return ChildProductI18n objects filtered by the description column

array
findByChapo( string $chapo)

Return ChildProductI18n objects filtered by the chapo column

array
findByPostscriptum( string $postscriptum)

Return ChildProductI18n objects filtered by the postscriptum column

array
findByMetaTitle( string $meta_title)

Return ChildProductI18n objects filtered by the meta_title column

array
findByMetaDescription( string $meta_description)

Return ChildProductI18n objects filtered by the meta_description column

array
findByMetaKeywords( string $meta_keywords)

Return ChildProductI18n objects filtered by the meta_keywords column

Details

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

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

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

Returns a new ChildProductI18nQuery object.

Parameters

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

Return Value

ProductI18nQuery

in ProductI18nQuery at line 129
ProductI18n|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

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

in ProductI18nQuery 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

in ProductI18nQuery at line 233
ProductI18nQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 248
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 283
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

See also

filterByProduct()

in ProductI18nQuery at line 321
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 350
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 379
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 408
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 437
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 466
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 495
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 524
ProductI18nQuery 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

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 546
ProductI18nQuery filterByProduct( Product|ObjectCollection $product, string $comparison = null)

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

Parameters

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

Return Value

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 571
ProductI18nQuery joinProduct( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the Product relation

Parameters

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

Return Value

ProductI18nQuery The current query, for fluid interface

in ProductI18nQuery at line 606
ProductQuery useProductQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

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

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

See also

useQuery()

in ProductI18nQuery at line 620
ProductI18nQuery prune( ProductI18n $productI18n = null)

Exclude object from result

Parameters

ProductI18n $productI18n Object to remove from the list of results

Return Value

ProductI18nQuery The current query, for fluid interface

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

Deletes all rows from the product_i18n table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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

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

in ProductI18nQuery at line 76
ChildProductI18nQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByLocale($order = Criteria::ASC)

Order by the locale column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByTitle($order = Criteria::ASC)

Order by the title column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByDescription($order = Criteria::ASC)

Order by the description column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByChapo($order = Criteria::ASC)

Order by the chapo column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByPostscriptum($order = Criteria::ASC)

Order by the postscriptum column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByMetaTitle($order = Criteria::ASC)

Order by the meta_title column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByMetaDescription($order = Criteria::ASC)

Order by the meta_description column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery orderByMetaKeywords($order = Criteria::ASC)

Order by the meta_keywords column

Parameters

$order

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupById()

Group by the id column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByLocale()

Group by the locale column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByTitle()

Group by the title column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByDescription()

Group by the description column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByChapo()

Group by the chapo column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByPostscriptum()

Group by the postscriptum column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByMetaTitle()

Group by the meta_title column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByMetaDescription()

Group by the meta_description column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery groupByMetaKeywords()

Group by the meta_keywords column

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery leftJoinProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery rightJoinProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18nQuery innerJoinProduct($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildProductI18nQuery

in ProductI18nQuery at line 76
ChildProductI18n findOne( ConnectionInterface $con = null)

Return the first ChildProductI18n matching the query

Parameters

ConnectionInterface $con

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneById( int $id)

Return the first ChildProductI18n filtered by the id column

Parameters

int $id

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByLocale( string $locale)

Return the first ChildProductI18n filtered by the locale column

Parameters

string $locale

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByTitle( string $title)

Return the first ChildProductI18n filtered by the title column

Parameters

string $title

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByDescription( string $description)

Return the first ChildProductI18n filtered by the description column

Parameters

string $description

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByChapo( string $chapo)

Return the first ChildProductI18n filtered by the chapo column

Parameters

string $chapo

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByPostscriptum( string $postscriptum)

Return the first ChildProductI18n filtered by the postscriptum column

Parameters

string $postscriptum

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByMetaTitle( string $meta_title)

Return the first ChildProductI18n filtered by the meta_title column

Parameters

string $meta_title

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByMetaDescription( string $meta_description)

Return the first ChildProductI18n filtered by the meta_description column

Parameters

string $meta_description

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
ChildProductI18n findOneByMetaKeywords( string $meta_keywords)

Return the first ChildProductI18n filtered by the meta_keywords column

Parameters

string $meta_keywords

Return Value

ChildProductI18n

in ProductI18nQuery at line 76
array findById( int $id)

Return ChildProductI18n objects filtered by the id column

Parameters

int $id

Return Value

array

in ProductI18nQuery at line 76
array findByLocale( string $locale)

Return ChildProductI18n objects filtered by the locale column

Parameters

string $locale

Return Value

array

in ProductI18nQuery at line 76
array findByTitle( string $title)

Return ChildProductI18n objects filtered by the title column

Parameters

string $title

Return Value

array

in ProductI18nQuery at line 76
array findByDescription( string $description)

Return ChildProductI18n objects filtered by the description column

Parameters

string $description

Return Value

array

in ProductI18nQuery at line 76
array findByChapo( string $chapo)

Return ChildProductI18n objects filtered by the chapo column

Parameters

string $chapo

Return Value

array

in ProductI18nQuery at line 76
array findByPostscriptum( string $postscriptum)

Return ChildProductI18n objects filtered by the postscriptum column

Parameters

string $postscriptum

Return Value

array

in ProductI18nQuery at line 76
array findByMetaTitle( string $meta_title)

Return ChildProductI18n objects filtered by the meta_title column

Parameters

string $meta_title

Return Value

array

in ProductI18nQuery at line 76
array findByMetaDescription( string $meta_description)

Return ChildProductI18n objects filtered by the meta_description column

Parameters

string $meta_description

Return Value

array

in ProductI18nQuery at line 76
array findByMetaKeywords( string $meta_keywords)

Return ChildProductI18n objects filtered by the meta_keywords column

Parameters

string $meta_keywords

Return Value

array