CategoryImageQuery
class CategoryImageQuery extends CategoryImageQuery
Skeleton subclass for performing query and update operations on the 'category_image' 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
Initializes internal state of \Thelia\Model\Base\CategoryImageQuery object.
Returns a new ChildCategoryImageQuery 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 category_id column
Filter the query on the file column
Filter the query on the visible 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\Category object
Adds a JOIN clause to the query using the Category relation
Use the Category relation Category object
Filter the query by a related \Thelia\Model\CategoryImageI18n object
Adds a JOIN clause to the query using the CategoryImageI18n relation
Use the CategoryImageI18n relation CategoryImageI18n object
Deletes all rows from the category_image table.
Performs a DELETE on the database, given a ChildCategoryImage or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
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 category_id column
Order by the file column
Order by the visible column
Order by the position column
Order by the created_at column
Order 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 Category relation
Adds a RIGHT JOIN clause to the query using the Category relation
Adds a INNER JOIN clause to the query using the Category relation
Adds a LEFT JOIN clause to the query using the CategoryImageI18n relation
Adds a RIGHT JOIN clause to the query using the CategoryImageI18n relation
Adds a INNER JOIN clause to the query using the CategoryImageI18n relation
Return the first ChildCategoryImage matching the query
Return the first ChildCategoryImage matching the query, or a new ChildCategoryImage object populated from the query conditions when no match is found
Return the first ChildCategoryImage filtered by the id column
Return the first ChildCategoryImage filtered by the category_id column
Return the first ChildCategoryImage filtered by the file column
Return the first ChildCategoryImage filtered by the visible column
Return the first ChildCategoryImage filtered by the position column
Return the first ChildCategoryImage filtered by the created_at column
Return the first ChildCategoryImage filtered by the updated_at column
Return ChildCategoryImage objects filtered by the id column
Return ChildCategoryImage objects filtered by the category_id column
Return ChildCategoryImage objects filtered by the file column
Return ChildCategoryImage objects filtered by the visible column
Return ChildCategoryImage objects filtered by the position column
Return ChildCategoryImage objects filtered by the created_at column
Return ChildCategoryImage objects filtered by the updated_at column
Details
in
CategoryImageQuery at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CategoryImage',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CategoryImageQuery object.
in
CategoryImageQuery at line 96
static
CategoryImageQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCategoryImageQuery object.
in
CategoryImageQuery at line 126
CategoryImage|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);
in
CategoryImageQuery at line 208
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
CategoryImageQuery at line 229
CategoryImageQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
CategoryImageQuery at line 242
CategoryImageQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
CategoryImageQuery at line 266
CategoryImageQuery
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
in
CategoryImageQuery at line 309
CategoryImageQuery
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
in
CategoryImageQuery at line 347
CategoryImageQuery
filterByFile(
string $file = null,
string $comparison = null)
Filter the query on the file column
Example usage:
$query->filterByFile('fooValue'); // WHERE file = 'fooValue'
$query->filterByFile('%fooValue%'); // WHERE file LIKE '%fooValue%'
in
CategoryImageQuery at line 379
CategoryImageQuery
filterByVisible(
mixed $visible = null,
string $comparison = null)
Filter the query on the visible column
Example usage:
$query->filterByVisible(1234); // WHERE visible = 1234
$query->filterByVisible(array(12, 34)); // WHERE visible IN (12, 34)
$query->filterByVisible(array('min' => 12)); // WHERE visible > 12
in
CategoryImageQuery at line 420
CategoryImageQuery
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
in
CategoryImageQuery at line 463
CategoryImageQuery
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'
in
CategoryImageQuery at line 506
CategoryImageQuery
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'
in
CategoryImageQuery at line 537
CategoryImageQuery
filterByCategory(
Category|ObjectCollection $category,
string $comparison = null)
Filter the query by a related \Thelia\Model\Category object
in
CategoryImageQuery at line 562
CategoryImageQuery
joinCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Category relation
in
CategoryImageQuery at line 597
CategoryQuery
useCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Category relation Category object
in
CategoryImageQuery at line 612
CategoryImageQuery
filterByCategoryImageI18n(
CategoryImageI18n|ObjectCollection $categoryImageI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\CategoryImageI18n object
in
CategoryImageQuery at line 635
CategoryImageQuery
joinCategoryImageI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the CategoryImageI18n relation
in
CategoryImageQuery at line 670
CategoryImageI18nQuery
useCategoryImageI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the CategoryImageI18n relation CategoryImageI18n object
in
CategoryImageQuery at line 684
CategoryImageQuery
prune(
CategoryImage $categoryImage = null)
Exclude object from result
in
CategoryImageQuery at line 699
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the category_image table.
in
CategoryImageQuery at line 736
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCategoryImage or Criteria object OR a primary key value.
in
CategoryImageQuery at line 777
CategoryImageQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
CategoryImageQuery at line 789
CategoryImageQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
CategoryImageQuery at line 799
CategoryImageQuery
lastUpdatedFirst()
Order by update date desc
in
CategoryImageQuery at line 809
CategoryImageQuery
firstUpdatedFirst()
Order by update date asc
in
CategoryImageQuery at line 819
CategoryImageQuery
lastCreatedFirst()
Order by create date desc
in
CategoryImageQuery at line 829
CategoryImageQuery
firstCreatedFirst()
Order by create date asc
in
CategoryImageQuery at line 845
CategoryImageQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
in
CategoryImageQuery at line 863
CategoryImageQuery
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()
in
CategoryImageQuery at line 884
CategoryImageI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
orderById($order = Criteria::ASC)
Order by the id column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
orderByCategoryId($order = Criteria::ASC)
Order by the category_id column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
orderByFile($order = Criteria::ASC)
Order by the file column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
orderByVisible($order = Criteria::ASC)
Order by the visible column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
groupById()
Group by the id column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
groupByCategoryId()
Group by the category_id column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
groupByFile()
Group by the file column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
groupByVisible()
Group by the visible column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
groupByPosition()
Group by the position column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
groupByCreatedAt()
Group by the created_at column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
groupByUpdatedAt()
Group by the updated_at column
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
leftJoinCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Category relation
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
rightJoinCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Category relation
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
innerJoinCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the Category relation
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
leftJoinCategoryImageI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the CategoryImageI18n relation
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
rightJoinCategoryImageI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the CategoryImageI18n relation
in
CategoryImageQuery at line 73
ChildCategoryImageQuery
innerJoinCategoryImageI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the CategoryImageI18n relation
in
CategoryImageQuery at line 73
ChildCategoryImage
findOne(
ConnectionInterface $con = null)
Return the first ChildCategoryImage matching the query
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCategoryImage matching the query, or a new ChildCategoryImage object populated from the query conditions when no match is found
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneById(
int $id)
Return the first ChildCategoryImage filtered by the id column
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneByCategoryId(
int $category_id)
Return the first ChildCategoryImage filtered by the category_id column
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneByFile(
string $file)
Return the first ChildCategoryImage filtered by the file column
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneByVisible(
int $visible)
Return the first ChildCategoryImage filtered by the visible column
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneByPosition(
int $position)
Return the first ChildCategoryImage filtered by the position column
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneByCreatedAt(
string $created_at)
Return the first ChildCategoryImage filtered by the created_at column
in
CategoryImageQuery at line 73
ChildCategoryImage
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCategoryImage filtered by the updated_at column
in
CategoryImageQuery at line 73
array
findById(
int $id)
Return ChildCategoryImage objects filtered by the id column
in
CategoryImageQuery at line 73
array
findByCategoryId(
int $category_id)
Return ChildCategoryImage objects filtered by the category_id column
in
CategoryImageQuery at line 73
array
findByFile(
string $file)
Return ChildCategoryImage objects filtered by the file column
in
CategoryImageQuery at line 73
array
findByVisible(
int $visible)
Return ChildCategoryImage objects filtered by the visible column
in
CategoryImageQuery at line 73
array
findByPosition(
int $position)
Return ChildCategoryImage objects filtered by the position column
in
CategoryImageQuery at line 73
array
findByCreatedAt(
string $created_at)
Return ChildCategoryImage objects filtered by the created_at column
in
CategoryImageQuery at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildCategoryImage objects filtered by the updated_at column