ImportQuery
class ImportQuery extends ImportQuery
Skeleton subclass for performing query and update operations on the 'import' 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\ImportQuery object.
Returns a new ChildImportQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
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 importcategoryid column
Filter the query on the handle_class 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\ImportCategory object
Adds a JOIN clause to the query using the ImportCategory relation
Use the ImportCategory relation ImportCategory object
Filter the query by a related \Thelia\Model\ImportI18n object
Adds a JOIN clause to the query using the ImportI18n relation
Use the ImportI18n relation ImportI18n object
Deletes all rows from the import table.
Performs a DELETE on the database, given a ChildImport or Criteria object OR a primary key value.
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 position column
Order by the importcategoryid column
Order by the handle_class column
Order by the created_at column
Order by the updated_at column
Adds a LEFT JOIN clause to the query using the ImportCategory relation
Adds a RIGHT JOIN clause to the query using the ImportCategory relation
Adds a INNER JOIN clause to the query using the ImportCategory relation
Adds a LEFT JOIN clause to the query using the ImportI18n relation
Adds a RIGHT JOIN clause to the query using the ImportI18n relation
Adds a INNER JOIN clause to the query using the ImportI18n relation
Return the first ChildImport matching the query
Return the first ChildImport matching the query, or a new ChildImport object populated from the query conditions when no match is found
Return the first ChildImport filtered by the id column
Return the first ChildImport filtered by the ref column
Return the first ChildImport filtered by the position column
Return the first ChildImport filtered by the importcategoryid column
Return the first ChildImport filtered by the handle_class column
Return the first ChildImport filtered by the created_at column
Return the first ChildImport filtered by the updated_at column
Return ChildImport objects filtered by the ref column
Return ChildImport objects filtered by the position column
Return ChildImport objects filtered by the importcategoryid column
Return ChildImport objects filtered by the handle_class column
Return ChildImport objects filtered by the created_at column
Return ChildImport objects filtered by the updated_at column
Details
in
ImportQuery at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Import',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ImportQuery object.
in
ImportQuery at line 96
static
ImportQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildImportQuery object.
in
ImportQuery at line 126
Import|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
ImportQuery 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
ImportQuery at line 229
ImportQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
ImportQuery at line 242
ImportQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
ImportQuery at line 266
ImportQuery
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
ImportQuery at line 304
ImportQuery
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%'
in
ImportQuery at line 336
ImportQuery
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
ImportQuery at line 379
ImportQuery
filterByImportCategoryId(
mixed $importCategoryId = null,
string $comparison = null)
Filter the query on the importcategoryid column
Example usage:
$query->filterByImportCategoryId(1234); // WHERE importcategoryid = 1234
$query->filterByImportCategoryId(array(12, 34)); // WHERE importcategoryid IN (12, 34)
$query->filterByImportCategoryId(array('min' => 12)); // WHERE importcategoryid > 12
in
ImportQuery at line 417
ImportQuery
filterByHandleClass(
string $handleClass = null,
string $comparison = null)
Filter the query on the handle_class column
Example usage:
$query->filterByHandleClass('fooValue'); // WHERE handleclass = 'fooValue'
$query->filterByHandleClass('%fooValue%'); // WHERE handleclass LIKE '%fooValue%'
in
ImportQuery at line 451
ImportQuery
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
ImportQuery at line 494
ImportQuery
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
ImportQuery at line 525
ImportQuery
filterByImportCategory(
ImportCategory|ObjectCollection $importCategory,
string $comparison = null)
Filter the query by a related \Thelia\Model\ImportCategory object
in
ImportQuery at line 550
ImportQuery
joinImportCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ImportCategory relation
in
ImportQuery at line 585
ImportCategoryQuery
useImportCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ImportCategory relation ImportCategory object
in
ImportQuery at line 600
ImportQuery
filterByImportI18n(
ImportI18n|ObjectCollection $importI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ImportI18n object
in
ImportQuery at line 623
ImportQuery
joinImportI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ImportI18n relation
in
ImportQuery at line 658
ImportI18nQuery
useImportI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ImportI18n relation ImportI18n object
in
ImportQuery at line 672
ImportQuery
prune(
Import $import = null)
Exclude object from result
in
ImportQuery at line 687
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the import table.
in
ImportQuery at line 724
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildImport or Criteria object OR a primary key value.
in
ImportQuery at line 765
ImportQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
ImportQuery at line 777
ImportQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
ImportQuery at line 787
ImportQuery
lastUpdatedFirst()
Order by update date desc
in
ImportQuery at line 797
ImportQuery
firstUpdatedFirst()
Order by update date asc
in
ImportQuery at line 807
ImportQuery
lastCreatedFirst()
Order by create date desc
in
ImportQuery at line 817
ImportQuery
firstCreatedFirst()
Order by create date asc
in
ImportQuery at line 833
ImportQuery
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
ImportQuery at line 851
ImportQuery
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
ImportQuery at line 872
ImportI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
ImportQuery at line 73
ChildImportQuery
orderById($order = Criteria::ASC)
Order by the id column
in
ImportQuery at line 73
ChildImportQuery
orderByRef($order = Criteria::ASC)
Order by the ref column
in
ImportQuery at line 73
ChildImportQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
ImportQuery at line 73
ChildImportQuery
orderByImportCategoryId($order = Criteria::ASC)
Order by the importcategoryid column
in
ImportQuery at line 73
ChildImportQuery
orderByHandleClass($order = Criteria::ASC)
Order by the handle_class column
in
ImportQuery at line 73
ChildImportQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
ImportQuery at line 73
ChildImportQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
ImportQuery at line 73
ChildImportQuery
groupById()
Group by the id column
in
ImportQuery at line 73
ChildImportQuery
groupByRef()
Group by the ref column
in
ImportQuery at line 73
ChildImportQuery
groupByPosition()
Group by the position column
in
ImportQuery at line 73
ChildImportQuery
groupByImportCategoryId()
Group by the importcategoryid column
in
ImportQuery at line 73
ChildImportQuery
groupByHandleClass()
Group by the handle_class column
in
ImportQuery at line 73
ChildImportQuery
groupByCreatedAt()
Group by the created_at column
in
ImportQuery at line 73
ChildImportQuery
groupByUpdatedAt()
Group by the updated_at column
in
ImportQuery at line 73
ChildImportQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
ImportQuery at line 73
ChildImportQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
ImportQuery at line 73
ChildImportQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
ImportQuery at line 73
ChildImportQuery
leftJoinImportCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ImportCategory relation
in
ImportQuery at line 73
ChildImportQuery
rightJoinImportCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ImportCategory relation
in
ImportQuery at line 73
ChildImportQuery
innerJoinImportCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the ImportCategory relation
in
ImportQuery at line 73
ChildImportQuery
leftJoinImportI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ImportI18n relation
in
ImportQuery at line 73
ChildImportQuery
rightJoinImportI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ImportI18n relation
in
ImportQuery at line 73
ChildImportQuery
innerJoinImportI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ImportI18n relation
in
ImportQuery at line 73
ChildImport
findOne(
ConnectionInterface $con = null)
Return the first ChildImport matching the query
in
ImportQuery at line 73
ChildImport
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildImport matching the query, or a new ChildImport object populated from the query conditions when no match is found
in
ImportQuery at line 73
ChildImport
findOneById(
int $id)
Return the first ChildImport filtered by the id column
in
ImportQuery at line 73
ChildImport
findOneByRef(
string $ref)
Return the first ChildImport filtered by the ref column
in
ImportQuery at line 73
ChildImport
findOneByPosition(
int $position)
Return the first ChildImport filtered by the position column
in
ImportQuery at line 73
ChildImport
findOneByImportCategoryId(
int $import_category_id)
Return the first ChildImport filtered by the importcategoryid column
in
ImportQuery at line 73
ChildImport
findOneByHandleClass(
string $handle_class)
Return the first ChildImport filtered by the handle_class column
in
ImportQuery at line 73
ChildImport
findOneByCreatedAt(
string $created_at)
Return the first ChildImport filtered by the created_at column
in
ImportQuery at line 73
ChildImport
findOneByUpdatedAt(
string $updated_at)
Return the first ChildImport filtered by the updated_at column
in
ImportQuery at line 73
array
findById(
int $id)
Return ChildImport objects filtered by the id column
in
ImportQuery at line 73
array
findByRef(
string $ref)
Return ChildImport objects filtered by the ref column
in
ImportQuery at line 73
array
findByPosition(
int $position)
Return ChildImport objects filtered by the position column
in
ImportQuery at line 73
array
findByImportCategoryId(
int $import_category_id)
Return ChildImport objects filtered by the importcategoryid column
in
ImportQuery at line 73
array
findByHandleClass(
string $handle_class)
Return ChildImport objects filtered by the handle_class column
in
ImportQuery at line 73
array
findByCreatedAt(
string $created_at)
Return ChildImport objects filtered by the created_at column
in
ImportQuery at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildImport objects filtered by the updated_at column