ImportCategoryQuery
class ImportCategoryQuery extends ModelCriteria
Base class that represents a query for the 'import_category' table.
Methods
Initializes internal state of \Thelia\Model\Base\ImportCategoryQuery object.
Returns a new ChildImportCategoryQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the id column
Filter the query on the ref column
Filter the query on the position column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query by a related \Thelia\Model\Import object
Adds a JOIN clause to the query using the Import relation
Use the Import relation Import object
Filter the query by a related \Thelia\Model\ImportCategoryI18n object
Adds a JOIN clause to the query using the ImportCategoryI18n relation
Use the ImportCategoryI18n relation ImportCategoryI18n object
Deletes all rows from the import_category table.
Performs a DELETE on the database, given a ChildImportCategory or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
Order by update date desc
Order by update date asc
Order by create date desc
Order by create date asc
Adds a JOIN clause to the query using the i18n relation
Adds a JOIN clause to the query and hydrates the related I18n object.
Use the I18n relation query object
Order by the id column
Order by the ref column
Order by the position column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the ref column
Group by the position column
Group by the created_at column
Group by the updated_at column
Adds a LEFT JOIN clause to the query
Adds a RIGHT JOIN clause to the query
Adds a INNER JOIN clause to the query
Adds a LEFT JOIN clause to the query using the Import relation
Adds a RIGHT JOIN clause to the query using the Import relation
Adds a INNER JOIN clause to the query using the Import relation
Adds a LEFT JOIN clause to the query using the ImportCategoryI18n relation
Adds a RIGHT JOIN clause to the query using the ImportCategoryI18n relation
Adds a INNER JOIN clause to the query using the ImportCategoryI18n relation
Return the first ChildImportCategory matching the query
Return the first ChildImportCategory matching the query, or a new ChildImportCategory object populated from the query conditions when no match is found
Return the first ChildImportCategory filtered by the id column
Return the first ChildImportCategory filtered by the ref column
Return the first ChildImportCategory filtered by the position column
Return the first ChildImportCategory filtered by the created_at column
Return the first ChildImportCategory filtered by the updated_at column
Return ChildImportCategory objects filtered by the id column
Return ChildImportCategory objects filtered by the ref column
Return ChildImportCategory objects filtered by the position column
Return ChildImportCategory objects filtered by the created_at column
Return ChildImportCategory objects filtered by the updated_at column
Details
at line 75
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\ImportCategory',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ImportCategoryQuery object.
at line 88
static
ImportCategoryQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildImportCategoryQuery object.
at line 118
ImportCategory|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);
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);
at line 221
ImportCategoryQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 234
ImportCategoryQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 258
ImportCategoryQuery
filterById(
mixed $id = null,
string $comparison = null)
Filter the query on the id column
Example usage:
$query->filterById(1234); // WHERE id = 1234
$query->filterById(array(12, 34)); // WHERE id IN (12, 34)
$query->filterById(array('min' => 12)); // WHERE id > 12
at line 296
ImportCategoryQuery
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%'
at line 328
ImportCategoryQuery
filterByPosition(
mixed $position = null,
string $comparison = null)
Filter the query on the position column
Example usage:
$query->filterByPosition(1234); // WHERE position = 1234
$query->filterByPosition(array(12, 34)); // WHERE position IN (12, 34)
$query->filterByPosition(array('min' => 12)); // WHERE position > 12
at line 371
ImportCategoryQuery
filterByCreatedAt(
mixed $createdAt = null,
string $comparison = null)
Filter the query on the created_at column
Example usage:
$query->filterByCreatedAt('2011-03-14'); // WHERE createdat = '2011-03-14'
$query->filterByCreatedAt('now'); // WHERE createdat = '2011-03-14'
$query->filterByCreatedAt(array('max' => 'yesterday')); // WHERE created_at > '2011-03-13'
at line 414
ImportCategoryQuery
filterByUpdatedAt(
mixed $updatedAt = null,
string $comparison = null)
Filter the query on the updated_at column
Example usage:
$query->filterByUpdatedAt('2011-03-14'); // WHERE updatedat = '2011-03-14'
$query->filterByUpdatedAt('now'); // WHERE updatedat = '2011-03-14'
$query->filterByUpdatedAt(array('max' => 'yesterday')); // WHERE updated_at > '2011-03-13'
at line 445
ImportCategoryQuery
filterByImport(
Import|ObjectCollection $import,
string $comparison = null)
Filter the query by a related \Thelia\Model\Import object
at line 468
ImportCategoryQuery
joinImport(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Import relation
at line 503
ImportQuery
useImportQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Import relation Import object
at line 518
ImportCategoryQuery
filterByImportCategoryI18n(
ImportCategoryI18n|ObjectCollection $importCategoryI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ImportCategoryI18n object
at line 541
ImportCategoryQuery
joinImportCategoryI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ImportCategoryI18n relation
at line 576
ImportCategoryI18nQuery
useImportCategoryI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ImportCategoryI18n relation ImportCategoryI18n object
at line 590
ImportCategoryQuery
prune(
ImportCategory $importCategory = null)
Exclude object from result
at line 605
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the import_category table.
at line 642
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildImportCategory or Criteria object OR a primary key value.
at line 683
ImportCategoryQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 695
ImportCategoryQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 705
ImportCategoryQuery
lastUpdatedFirst()
Order by update date desc
at line 715
ImportCategoryQuery
firstUpdatedFirst()
Order by update date asc
at line 725
ImportCategoryQuery
lastCreatedFirst()
Order by create date desc
at line 735
ImportCategoryQuery
firstCreatedFirst()
Order by create date asc
at line 751
ImportCategoryQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
at line 769
ImportCategoryQuery
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()
at line 790
ImportCategoryI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 65
ChildImportCategoryQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 65
ChildImportCategoryQuery
orderByRef($order = Criteria::ASC)
Order by the ref column
at line 65
ChildImportCategoryQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
at line 65
ChildImportCategoryQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 65
ChildImportCategoryQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 65
ChildImportCategoryQuery
groupById()
Group by the id column
at line 65
ChildImportCategoryQuery
groupByRef()
Group by the ref column
at line 65
ChildImportCategoryQuery
groupByPosition()
Group by the position column
at line 65
ChildImportCategoryQuery
groupByCreatedAt()
Group by the created_at column
at line 65
ChildImportCategoryQuery
groupByUpdatedAt()
Group by the updated_at column
at line 65
ChildImportCategoryQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 65
ChildImportCategoryQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 65
ChildImportCategoryQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 65
ChildImportCategoryQuery
leftJoinImport($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Import relation
at line 65
ChildImportCategoryQuery
rightJoinImport($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Import relation
at line 65
ChildImportCategoryQuery
innerJoinImport($relationAlias = null)
Adds a INNER JOIN clause to the query using the Import relation
at line 65
ChildImportCategoryQuery
leftJoinImportCategoryI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ImportCategoryI18n relation
at line 65
ChildImportCategoryQuery
rightJoinImportCategoryI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ImportCategoryI18n relation
at line 65
ChildImportCategoryQuery
innerJoinImportCategoryI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ImportCategoryI18n relation
at line 65
ChildImportCategory
findOne(
ConnectionInterface $con = null)
Return the first ChildImportCategory matching the query
at line 65
ChildImportCategory
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildImportCategory matching the query, or a new ChildImportCategory object populated from the query conditions when no match is found
at line 65
ChildImportCategory
findOneById(
int $id)
Return the first ChildImportCategory filtered by the id column
at line 65
ChildImportCategory
findOneByRef(
string $ref)
Return the first ChildImportCategory filtered by the ref column
at line 65
ChildImportCategory
findOneByPosition(
int $position)
Return the first ChildImportCategory filtered by the position column
at line 65
ChildImportCategory
findOneByCreatedAt(
string $created_at)
Return the first ChildImportCategory filtered by the created_at column
at line 65
ChildImportCategory
findOneByUpdatedAt(
string $updated_at)
Return the first ChildImportCategory filtered by the updated_at column
at line 65
array
findById(
int $id)
Return ChildImportCategory objects filtered by the id column
at line 65
array
findByRef(
string $ref)
Return ChildImportCategory objects filtered by the ref column
at line 65
array
findByPosition(
int $position)
Return ChildImportCategory objects filtered by the position column
at line 65
array
findByCreatedAt(
string $created_at)
Return ChildImportCategory objects filtered by the created_at column
at line 65
array
findByUpdatedAt(
string $updated_at)
Return ChildImportCategory objects filtered by the updated_at column