ExportQuery
class ExportQuery extends ExportQuery
Skeleton subclass for performing query and update operations on the 'export' 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\ExportQuery object.
Returns a new ChildExportQuery 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 exportcategoryid 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\ExportCategory object
Adds a JOIN clause to the query using the ExportCategory relation
Use the ExportCategory relation ExportCategory object
Filter the query by a related \Thelia\Model\ExportI18n object
Adds a JOIN clause to the query using the ExportI18n relation
Use the ExportI18n relation ExportI18n object
Deletes all rows from the export table.
Performs a DELETE on the database, given a ChildExport 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 exportcategoryid 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 ExportCategory relation
Adds a RIGHT JOIN clause to the query using the ExportCategory relation
Adds a INNER JOIN clause to the query using the ExportCategory relation
Adds a LEFT JOIN clause to the query using the ExportI18n relation
Adds a RIGHT JOIN clause to the query using the ExportI18n relation
Adds a INNER JOIN clause to the query using the ExportI18n relation
Return the first ChildExport matching the query
Return the first ChildExport matching the query, or a new ChildExport object populated from the query conditions when no match is found
Return the first ChildExport filtered by the id column
Return the first ChildExport filtered by the ref column
Return the first ChildExport filtered by the position column
Return the first ChildExport filtered by the exportcategoryid column
Return the first ChildExport filtered by the handle_class column
Return the first ChildExport filtered by the created_at column
Return the first ChildExport filtered by the updated_at column
Return ChildExport objects filtered by the ref column
Return ChildExport objects filtered by the position column
Return ChildExport objects filtered by the exportcategoryid column
Return ChildExport objects filtered by the handle_class column
Return ChildExport objects filtered by the created_at column
Return ChildExport objects filtered by the updated_at column
Details
in
ExportQuery at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Export',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ExportQuery object.
in
ExportQuery at line 96
static
ExportQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildExportQuery object.
in
ExportQuery at line 126
Export|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
ExportQuery 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
ExportQuery at line 229
ExportQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
ExportQuery at line 242
ExportQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
ExportQuery at line 266
ExportQuery
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
ExportQuery at line 304
ExportQuery
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
ExportQuery at line 336
ExportQuery
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
ExportQuery at line 379
ExportQuery
filterByExportCategoryId(
mixed $exportCategoryId = null,
string $comparison = null)
Filter the query on the exportcategoryid column
Example usage:
$query->filterByExportCategoryId(1234); // WHERE exportcategoryid = 1234
$query->filterByExportCategoryId(array(12, 34)); // WHERE exportcategoryid IN (12, 34)
$query->filterByExportCategoryId(array('min' => 12)); // WHERE exportcategoryid > 12
in
ExportQuery at line 417
ExportQuery
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
ExportQuery at line 451
ExportQuery
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
ExportQuery at line 494
ExportQuery
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
ExportQuery at line 525
ExportQuery
filterByExportCategory(
ExportCategory|ObjectCollection $exportCategory,
string $comparison = null)
Filter the query by a related \Thelia\Model\ExportCategory object
in
ExportQuery at line 550
ExportQuery
joinExportCategory(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ExportCategory relation
in
ExportQuery at line 585
ExportCategoryQuery
useExportCategoryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ExportCategory relation ExportCategory object
in
ExportQuery at line 600
ExportQuery
filterByExportI18n(
ExportI18n|ObjectCollection $exportI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ExportI18n object
in
ExportQuery at line 623
ExportQuery
joinExportI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ExportI18n relation
in
ExportQuery at line 658
ExportI18nQuery
useExportI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ExportI18n relation ExportI18n object
in
ExportQuery at line 672
ExportQuery
prune(
Export $export = null)
Exclude object from result
in
ExportQuery at line 687
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the export table.
in
ExportQuery at line 724
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildExport or Criteria object OR a primary key value.
in
ExportQuery at line 765
ExportQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
ExportQuery at line 777
ExportQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
ExportQuery at line 787
ExportQuery
lastUpdatedFirst()
Order by update date desc
in
ExportQuery at line 797
ExportQuery
firstUpdatedFirst()
Order by update date asc
in
ExportQuery at line 807
ExportQuery
lastCreatedFirst()
Order by create date desc
in
ExportQuery at line 817
ExportQuery
firstCreatedFirst()
Order by create date asc
in
ExportQuery at line 833
ExportQuery
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
ExportQuery at line 851
ExportQuery
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
ExportQuery at line 872
ExportI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
ExportQuery at line 73
ChildExportQuery
orderById($order = Criteria::ASC)
Order by the id column
in
ExportQuery at line 73
ChildExportQuery
orderByRef($order = Criteria::ASC)
Order by the ref column
in
ExportQuery at line 73
ChildExportQuery
orderByPosition($order = Criteria::ASC)
Order by the position column
in
ExportQuery at line 73
ChildExportQuery
orderByExportCategoryId($order = Criteria::ASC)
Order by the exportcategoryid column
in
ExportQuery at line 73
ChildExportQuery
orderByHandleClass($order = Criteria::ASC)
Order by the handle_class column
in
ExportQuery at line 73
ChildExportQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
ExportQuery at line 73
ChildExportQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
ExportQuery at line 73
ChildExportQuery
groupById()
Group by the id column
in
ExportQuery at line 73
ChildExportQuery
groupByRef()
Group by the ref column
in
ExportQuery at line 73
ChildExportQuery
groupByPosition()
Group by the position column
in
ExportQuery at line 73
ChildExportQuery
groupByExportCategoryId()
Group by the exportcategoryid column
in
ExportQuery at line 73
ChildExportQuery
groupByHandleClass()
Group by the handle_class column
in
ExportQuery at line 73
ChildExportQuery
groupByCreatedAt()
Group by the created_at column
in
ExportQuery at line 73
ChildExportQuery
groupByUpdatedAt()
Group by the updated_at column
in
ExportQuery at line 73
ChildExportQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
ExportQuery at line 73
ChildExportQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
ExportQuery at line 73
ChildExportQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
ExportQuery at line 73
ChildExportQuery
leftJoinExportCategory($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ExportCategory relation
in
ExportQuery at line 73
ChildExportQuery
rightJoinExportCategory($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ExportCategory relation
in
ExportQuery at line 73
ChildExportQuery
innerJoinExportCategory($relationAlias = null)
Adds a INNER JOIN clause to the query using the ExportCategory relation
in
ExportQuery at line 73
ChildExportQuery
leftJoinExportI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ExportI18n relation
in
ExportQuery at line 73
ChildExportQuery
rightJoinExportI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ExportI18n relation
in
ExportQuery at line 73
ChildExportQuery
innerJoinExportI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ExportI18n relation
in
ExportQuery at line 73
ChildExport
findOne(
ConnectionInterface $con = null)
Return the first ChildExport matching the query
in
ExportQuery at line 73
ChildExport
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildExport matching the query, or a new ChildExport object populated from the query conditions when no match is found
in
ExportQuery at line 73
ChildExport
findOneById(
int $id)
Return the first ChildExport filtered by the id column
in
ExportQuery at line 73
ChildExport
findOneByRef(
string $ref)
Return the first ChildExport filtered by the ref column
in
ExportQuery at line 73
ChildExport
findOneByPosition(
int $position)
Return the first ChildExport filtered by the position column
in
ExportQuery at line 73
ChildExport
findOneByExportCategoryId(
int $export_category_id)
Return the first ChildExport filtered by the exportcategoryid column
in
ExportQuery at line 73
ChildExport
findOneByHandleClass(
string $handle_class)
Return the first ChildExport filtered by the handle_class column
in
ExportQuery at line 73
ChildExport
findOneByCreatedAt(
string $created_at)
Return the first ChildExport filtered by the created_at column
in
ExportQuery at line 73
ChildExport
findOneByUpdatedAt(
string $updated_at)
Return the first ChildExport filtered by the updated_at column
in
ExportQuery at line 73
array
findById(
int $id)
Return ChildExport objects filtered by the id column
in
ExportQuery at line 73
array
findByRef(
string $ref)
Return ChildExport objects filtered by the ref column
in
ExportQuery at line 73
array
findByPosition(
int $position)
Return ChildExport objects filtered by the position column
in
ExportQuery at line 73
array
findByExportCategoryId(
int $export_category_id)
Return ChildExport objects filtered by the exportcategoryid column
in
ExportQuery at line 73
array
findByHandleClass(
string $handle_class)
Return ChildExport objects filtered by the handle_class column
in
ExportQuery at line 73
array
findByCreatedAt(
string $created_at)
Return ChildExport objects filtered by the created_at column
in
ExportQuery at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildExport objects filtered by the updated_at column