class ExportCategoryQuery extends ModelCriteria

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

Methods

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

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

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

Returns a new ChildExportCategoryQuery object.

ExportCategory|array|mixed
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

filterByRef( string $ref = null, string $comparison = null)

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

filterByExport( Export|ObjectCollection $export, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Export relation

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

Use the Export relation Export object

filterByExportCategoryI18n( ExportCategoryI18n|ObjectCollection $exportCategoryI18n, string $comparison = null)

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

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

Adds a JOIN clause to the query using the ExportCategoryI18n relation

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

Use the ExportCategoryI18n relation ExportCategoryI18n object

prune( ExportCategory $exportCategory = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the export_category table.

int
delete( ConnectionInterface $con = null)

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

joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query and hydrates the related I18n object.

useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

ChildExportCategoryQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildExportCategoryQuery
orderByRef($order = Criteria::ASC)

Order by the ref column

ChildExportCategoryQuery
orderByPosition($order = Criteria::ASC)

Order by the position column

ChildExportCategoryQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildExportCategoryQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildExportCategoryQuery
groupById()

Group by the id column

ChildExportCategoryQuery
groupByRef()

Group by the ref column

ChildExportCategoryQuery
groupByPosition()

Group by the position column

ChildExportCategoryQuery
groupByCreatedAt()

Group by the created_at column

ChildExportCategoryQuery
groupByUpdatedAt()

Group by the updated_at column

ChildExportCategoryQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildExportCategoryQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildExportCategoryQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildExportCategoryQuery
leftJoinExport($relationAlias = null)

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

ChildExportCategoryQuery
rightJoinExport($relationAlias = null)

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

ChildExportCategoryQuery
innerJoinExport($relationAlias = null)

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

ChildExportCategoryQuery
leftJoinExportCategoryI18n($relationAlias = null)

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

ChildExportCategoryQuery
rightJoinExportCategoryI18n($relationAlias = null)

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

ChildExportCategoryQuery
innerJoinExportCategoryI18n($relationAlias = null)

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

ChildExportCategory
findOne( ConnectionInterface $con = null)

Return the first ChildExportCategory matching the query

ChildExportCategory
findOneOrCreate( ConnectionInterface $con = null)

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

ChildExportCategory
findOneById( int $id)

Return the first ChildExportCategory filtered by the id column

ChildExportCategory
findOneByRef( string $ref)

Return the first ChildExportCategory filtered by the ref column

ChildExportCategory
findOneByPosition( int $position)

Return the first ChildExportCategory filtered by the position column

ChildExportCategory
findOneByCreatedAt( string $created_at)

Return the first ChildExportCategory filtered by the created_at column

ChildExportCategory
findOneByUpdatedAt( string $updated_at)

Return the first ChildExportCategory filtered by the updated_at column

array
findById( int $id)

Return ChildExportCategory objects filtered by the id column

array
findByRef( string $ref)

Return ChildExportCategory objects filtered by the ref column

array
findByPosition( int $position)

Return ChildExportCategory objects filtered by the position column

array
findByCreatedAt( string $created_at)

Return ChildExportCategory objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildExportCategory objects filtered by the updated_at column

Details

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

Initializes internal state of \Thelia\Model\Base\ExportCategoryQuery 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 88
static ExportCategoryQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildExportCategoryQuery object.

Parameters

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

Return Value

ExportCategoryQuery

at line 118
ExportCategory|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

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

at line 200
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

at line 221
ExportCategoryQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 234
ExportCategoryQuery 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

ExportCategoryQuery The current query, for fluid interface

at line 258
ExportCategoryQuery 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

ExportCategoryQuery The current query, for fluid interface

at line 296
ExportCategoryQuery filterByRef( string $ref = null, string $comparison = null)

Filter the query on the ref column

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

Parameters

string $ref 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

ExportCategoryQuery The current query, for fluid interface

at line 328
ExportCategoryQuery 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

ExportCategoryQuery The current query, for fluid interface

at line 371
ExportCategoryQuery 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

ExportCategoryQuery The current query, for fluid interface

at line 414
ExportCategoryQuery 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

ExportCategoryQuery The current query, for fluid interface

at line 445
ExportCategoryQuery filterByExport( Export|ObjectCollection $export, string $comparison = null)

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

Parameters

Export|ObjectCollection $export the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 468
ExportCategoryQuery joinExport( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Export relation

Parameters

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

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 503
ExportQuery useExportQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

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

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

See also

useQuery()

at line 518
ExportCategoryQuery filterByExportCategoryI18n( ExportCategoryI18n|ObjectCollection $exportCategoryI18n, string $comparison = null)

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

Parameters

ExportCategoryI18n|ObjectCollection $exportCategoryI18n the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 541
ExportCategoryQuery joinExportCategoryI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the ExportCategoryI18n relation

Parameters

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

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 576
ExportCategoryI18nQuery useExportCategoryI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

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

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

See also

useQuery()

at line 590
ExportCategoryQuery prune( ExportCategory $exportCategory = null)

Exclude object from result

Parameters

ExportCategory $exportCategory Object to remove from the list of results

Return Value

ExportCategoryQuery The current query, for fluid interface

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

Deletes all rows from the export_category table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

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

Performs a DELETE on the database, given a ChildExportCategory 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 685
ExportCategoryQuery joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 703
ExportCategoryQuery joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query and hydrates the related I18n object.

Shortcut for $c->joinI18n($locale)->with()

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 724
ExportCategoryI18nQuery useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

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

See also

useQuery()

at line 740
ExportCategoryQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 752
ExportCategoryQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 762
ExportCategoryQuery lastUpdatedFirst()

Order by update date desc

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 772
ExportCategoryQuery firstUpdatedFirst()

Order by update date asc

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 782
ExportCategoryQuery lastCreatedFirst()

Order by create date desc

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 792
ExportCategoryQuery firstCreatedFirst()

Order by create date asc

Return Value

ExportCategoryQuery The current query, for fluid interface

at line 65
ChildExportCategoryQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery orderByRef($order = Criteria::ASC)

Order by the ref column

Parameters

$order

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery orderByPosition($order = Criteria::ASC)

Order by the position column

Parameters

$order

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery groupById()

Group by the id column

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery groupByRef()

Group by the ref column

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery groupByPosition()

Group by the position column

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery leftJoinExport($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery rightJoinExport($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery innerJoinExport($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery leftJoinExportCategoryI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery rightJoinExportCategoryI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategoryQuery innerJoinExportCategoryI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildExportCategoryQuery

at line 65
ChildExportCategory findOne( ConnectionInterface $con = null)

Return the first ChildExportCategory matching the query

Parameters

ConnectionInterface $con

Return Value

ChildExportCategory

at line 65
ChildExportCategory findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildExportCategory

at line 65
ChildExportCategory findOneById( int $id)

Return the first ChildExportCategory filtered by the id column

Parameters

int $id

Return Value

ChildExportCategory

at line 65
ChildExportCategory findOneByRef( string $ref)

Return the first ChildExportCategory filtered by the ref column

Parameters

string $ref

Return Value

ChildExportCategory

at line 65
ChildExportCategory findOneByPosition( int $position)

Return the first ChildExportCategory filtered by the position column

Parameters

int $position

Return Value

ChildExportCategory

at line 65
ChildExportCategory findOneByCreatedAt( string $created_at)

Return the first ChildExportCategory filtered by the created_at column

Parameters

string $created_at

Return Value

ChildExportCategory

at line 65
ChildExportCategory findOneByUpdatedAt( string $updated_at)

Return the first ChildExportCategory filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildExportCategory

at line 65
array findById( int $id)

Return ChildExportCategory objects filtered by the id column

Parameters

int $id

Return Value

array

at line 65
array findByRef( string $ref)

Return ChildExportCategory objects filtered by the ref column

Parameters

string $ref

Return Value

array

at line 65
array findByPosition( int $position)

Return ChildExportCategory objects filtered by the position column

Parameters

int $position

Return Value

array

at line 65
array findByCreatedAt( string $created_at)

Return ChildExportCategory objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 65
array findByUpdatedAt( string $updated_at)

Return ChildExportCategory objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array