CountryAreaQuery
class CountryAreaQuery extends CountryAreaQuery
Skeleton subclass for performing query and update operations on the 'country_area' 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\CountryAreaQuery object.
Returns a new ChildCountryAreaQuery 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 country_id column
Filter the query on the state_id column
Filter the query on the area_id 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\Area object
Adds a JOIN clause to the query using the Area relation
Use the Area relation Area object
Filter the query by a related \Thelia\Model\Country object
Adds a JOIN clause to the query using the Country relation
Use the Country relation Country object
Deletes all rows from the country_area table.
Performs a DELETE on the database, given a ChildCountryArea or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
Order by the id column
Order by the country_id column
Order by the state_id column
Order by the area_id 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 Area relation
Adds a RIGHT JOIN clause to the query using the Area relation
Adds a INNER JOIN clause to the query using the Area relation
Adds a LEFT JOIN clause to the query using the Country relation
Adds a RIGHT JOIN clause to the query using the Country relation
Adds a INNER JOIN clause to the query using the Country relation
Return the first ChildCountryArea matching the query
Return the first ChildCountryArea matching the query, or a new ChildCountryArea object populated from the query conditions when no match is found
Return the first ChildCountryArea filtered by the id column
Return the first ChildCountryArea filtered by the country_id column
Return the first ChildCountryArea filtered by the state_id column
Return the first ChildCountryArea filtered by the area_id column
Return the first ChildCountryArea filtered by the created_at column
Return the first ChildCountryArea filtered by the updated_at column
Return ChildCountryArea objects filtered by the id column
Return ChildCountryArea objects filtered by the country_id column
Return ChildCountryArea objects filtered by the state_id column
Return ChildCountryArea objects filtered by the area_id column
Return ChildCountryArea objects filtered by the created_at column
Return ChildCountryArea objects filtered by the updated_at column
No description
Details
in
CountryAreaQuery at line 78
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\CountryArea',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\CountryAreaQuery object.
in
CountryAreaQuery at line 91
static
CountryAreaQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildCountryAreaQuery object.
in
CountryAreaQuery at line 121
CountryArea|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
CountryAreaQuery at line 203
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
CountryAreaQuery at line 224
CountryAreaQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
CountryAreaQuery at line 237
CountryAreaQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
CountryAreaQuery at line 261
CountryAreaQuery
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
CountryAreaQuery at line 304
CountryAreaQuery
filterByCountryId(
mixed $countryId = null,
string $comparison = null)
Filter the query on the country_id column
Example usage:
$query->filterByCountryId(1234); // WHERE countryid = 1234
$query->filterByCountryId(array(12, 34)); // WHERE countryid IN (12, 34)
$query->filterByCountryId(array('min' => 12)); // WHERE country_id > 12
in
CountryAreaQuery at line 345
CountryAreaQuery
filterByStateId(
mixed $stateId = null,
string $comparison = null)
Filter the query on the state_id column
Example usage:
$query->filterByStateId(1234); // WHERE stateid = 1234
$query->filterByStateId(array(12, 34)); // WHERE stateid IN (12, 34)
$query->filterByStateId(array('min' => 12)); // WHERE state_id > 12
in
CountryAreaQuery at line 388
CountryAreaQuery
filterByAreaId(
mixed $areaId = null,
string $comparison = null)
Filter the query on the area_id column
Example usage:
$query->filterByAreaId(1234); // WHERE areaid = 1234
$query->filterByAreaId(array(12, 34)); // WHERE areaid IN (12, 34)
$query->filterByAreaId(array('min' => 12)); // WHERE area_id > 12
in
CountryAreaQuery at line 431
CountryAreaQuery
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
CountryAreaQuery at line 474
CountryAreaQuery
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
CountryAreaQuery at line 505
CountryAreaQuery
filterByArea(
Area|ObjectCollection $area,
string $comparison = null)
Filter the query by a related \Thelia\Model\Area object
in
CountryAreaQuery at line 530
CountryAreaQuery
joinArea(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Area relation
in
CountryAreaQuery at line 565
AreaQuery
useAreaQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Area relation Area object
in
CountryAreaQuery at line 580
CountryAreaQuery
filterByCountry(
Country|ObjectCollection $country,
string $comparison = null)
Filter the query by a related \Thelia\Model\Country object
in
CountryAreaQuery at line 605
CountryAreaQuery
joinCountry(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Country relation
in
CountryAreaQuery at line 640
CountryQuery
useCountryQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Country relation Country object
in
CountryAreaQuery at line 654
CountryAreaQuery
prune(
CountryArea $countryArea = null)
Exclude object from result
in
CountryAreaQuery at line 669
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the country_area table.
in
CountryAreaQuery at line 706
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildCountryArea or Criteria object OR a primary key value.
in
CountryAreaQuery at line 747
CountryAreaQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
CountryAreaQuery at line 759
CountryAreaQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
CountryAreaQuery at line 769
CountryAreaQuery
lastUpdatedFirst()
Order by update date desc
in
CountryAreaQuery at line 779
CountryAreaQuery
firstUpdatedFirst()
Order by update date asc
in
CountryAreaQuery at line 789
CountryAreaQuery
lastCreatedFirst()
Order by create date desc
in
CountryAreaQuery at line 799
CountryAreaQuery
firstCreatedFirst()
Order by create date asc
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
orderById($order = Criteria::ASC)
Order by the id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
orderByCountryId($order = Criteria::ASC)
Order by the country_id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
orderByStateId($order = Criteria::ASC)
Order by the state_id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
orderByAreaId($order = Criteria::ASC)
Order by the area_id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
groupById()
Group by the id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
groupByCountryId()
Group by the country_id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
groupByStateId()
Group by the state_id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
groupByAreaId()
Group by the area_id column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
groupByCreatedAt()
Group by the created_at column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
groupByUpdatedAt()
Group by the updated_at column
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
leftJoinArea($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Area relation
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
rightJoinArea($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Area relation
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
innerJoinArea($relationAlias = null)
Adds a INNER JOIN clause to the query using the Area relation
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
leftJoinCountry($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Country relation
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
rightJoinCountry($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Country relation
in
CountryAreaQuery at line 68
ChildCountryAreaQuery
innerJoinCountry($relationAlias = null)
Adds a INNER JOIN clause to the query using the Country relation
in
CountryAreaQuery at line 68
ChildCountryArea
findOne(
ConnectionInterface $con = null)
Return the first ChildCountryArea matching the query
in
CountryAreaQuery at line 68
ChildCountryArea
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildCountryArea matching the query, or a new ChildCountryArea object populated from the query conditions when no match is found
in
CountryAreaQuery at line 68
ChildCountryArea
findOneById(
int $id)
Return the first ChildCountryArea filtered by the id column
in
CountryAreaQuery at line 68
ChildCountryArea
findOneByCountryId(
int $country_id)
Return the first ChildCountryArea filtered by the country_id column
in
CountryAreaQuery at line 68
ChildCountryArea
findOneByStateId(
int $state_id)
Return the first ChildCountryArea filtered by the state_id column
in
CountryAreaQuery at line 68
ChildCountryArea
findOneByAreaId(
int $area_id)
Return the first ChildCountryArea filtered by the area_id column
in
CountryAreaQuery at line 68
ChildCountryArea
findOneByCreatedAt(
string $created_at)
Return the first ChildCountryArea filtered by the created_at column
in
CountryAreaQuery at line 68
ChildCountryArea
findOneByUpdatedAt(
string $updated_at)
Return the first ChildCountryArea filtered by the updated_at column
in
CountryAreaQuery at line 68
array
findById(
int $id)
Return ChildCountryArea objects filtered by the id column
in
CountryAreaQuery at line 68
array
findByCountryId(
int $country_id)
Return ChildCountryArea objects filtered by the country_id column
in
CountryAreaQuery at line 68
array
findByStateId(
int $state_id)
Return ChildCountryArea objects filtered by the state_id column
in
CountryAreaQuery at line 68
array
findByAreaId(
int $area_id)
Return ChildCountryArea objects filtered by the area_id column
in
CountryAreaQuery at line 68
array
findByCreatedAt(
string $created_at)
Return ChildCountryArea objects filtered by the created_at column
in
CountryAreaQuery at line 68
array
findByUpdatedAt(
string $updated_at)
Return ChildCountryArea objects filtered by the updated_at column