class CountryAreaQuery extends ModelCriteria

Base class that represents a query for the 'country_area' table.

Methods

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\CountryArea', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\CountryAreaQuery object.

static  CountryAreaQuery
create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCountryAreaQuery object.

CountryArea|array|mixed
findPk( mixed $key, ConnectionInterface $con = null)

Find object by primary key.

ObjectCollection|array|mixed
findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByCountryId( mixed $countryId = null, string $comparison = null)

Filter the query on the country_id column

filterByStateId( mixed $stateId = null, string $comparison = null)

Filter the query on the state_id column

filterByAreaId( mixed $areaId = null, string $comparison = null)

Filter the query on the area_id column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByArea( Area|ObjectCollection $area, string $comparison = null)

Filter the query by a related \Thelia\Model\Area object

joinArea( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Area relation

useAreaQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Area relation Area object

filterByCountry( Country|ObjectCollection $country, string $comparison = null)

Filter the query by a related \Thelia\Model\Country object

joinCountry( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Country relation

useCountryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Country relation Country object

prune( CountryArea $countryArea = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the country_area table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildCountryArea or Criteria object OR a primary key value.

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

ChildCountryAreaQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildCountryAreaQuery
orderByCountryId($order = Criteria::ASC)

Order by the country_id column

ChildCountryAreaQuery
orderByStateId($order = Criteria::ASC)

Order by the state_id column

ChildCountryAreaQuery
orderByAreaId($order = Criteria::ASC)

Order by the area_id column

ChildCountryAreaQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildCountryAreaQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildCountryAreaQuery
groupById()

Group by the id column

ChildCountryAreaQuery
groupByCountryId()

Group by the country_id column

ChildCountryAreaQuery
groupByStateId()

Group by the state_id column

ChildCountryAreaQuery
groupByAreaId()

Group by the area_id column

ChildCountryAreaQuery
groupByCreatedAt()

Group by the created_at column

ChildCountryAreaQuery
groupByUpdatedAt()

Group by the updated_at column

ChildCountryAreaQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCountryAreaQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCountryAreaQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCountryAreaQuery
leftJoinArea($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Area relation

ChildCountryAreaQuery
rightJoinArea($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Area relation

ChildCountryAreaQuery
innerJoinArea($relationAlias = null)

Adds a INNER JOIN clause to the query using the Area relation

ChildCountryAreaQuery
leftJoinCountry($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Country relation

ChildCountryAreaQuery
rightJoinCountry($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Country relation

ChildCountryAreaQuery
innerJoinCountry($relationAlias = null)

Adds a INNER JOIN clause to the query using the Country relation

ChildCountryArea
findOne( ConnectionInterface $con = null)

Return the first ChildCountryArea matching the query

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

ChildCountryArea
findOneById( int $id)

Return the first ChildCountryArea filtered by the id column

ChildCountryArea
findOneByCountryId( int $country_id)

Return the first ChildCountryArea filtered by the country_id column

ChildCountryArea
findOneByStateId( int $state_id)

Return the first ChildCountryArea filtered by the state_id column

ChildCountryArea
findOneByAreaId( int $area_id)

Return the first ChildCountryArea filtered by the area_id column

ChildCountryArea
findOneByCreatedAt( string $created_at)

Return the first ChildCountryArea filtered by the created_at column

ChildCountryArea
findOneByUpdatedAt( string $updated_at)

Return the first ChildCountryArea filtered by the updated_at column

array
findById( int $id)

Return ChildCountryArea objects filtered by the id column

array
findByCountryId( int $country_id)

Return ChildCountryArea objects filtered by the country_id column

array
findByStateId( int $state_id)

Return ChildCountryArea objects filtered by the state_id column

array
findByAreaId( int $area_id)

Return ChildCountryArea objects filtered by the area_id column

array
findByCreatedAt( string $created_at)

Return ChildCountryArea objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildCountryArea objects filtered by the updated_at column

Details

at line 78
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\CountryArea', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\CountryAreaQuery object.

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

at line 91
static CountryAreaQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCountryAreaQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

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);

Parameters

mixed $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

CountryArea|array|mixed the result, formatted by the current formatter

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);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

at line 224
CountryAreaQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CountryAreaQuery The current query, for fluid interface

at line 237
CountryAreaQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

CountryAreaQuery The current query, for fluid interface

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

Parameters

mixed $id The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

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

Parameters

mixed $countryId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

See also

filterByCountry()

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

Parameters

mixed $stateId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

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

Parameters

mixed $areaId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

See also

filterByArea()

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'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

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'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

at line 505
CountryAreaQuery filterByArea( Area|ObjectCollection $area, string $comparison = null)

Filter the query by a related \Thelia\Model\Area object

Parameters

Area|ObjectCollection $area The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

at line 530
CountryAreaQuery joinArea( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Area relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

CountryAreaQuery The current query, for fluid interface

at line 565
AreaQuery useAreaQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Area relation Area object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

AreaQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 580
CountryAreaQuery filterByCountry( Country|ObjectCollection $country, string $comparison = null)

Filter the query by a related \Thelia\Model\Country object

Parameters

Country|ObjectCollection $country The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

CountryAreaQuery The current query, for fluid interface

at line 605
CountryAreaQuery joinCountry( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Country relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

CountryAreaQuery The current query, for fluid interface

at line 640
CountryQuery useCountryQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Country relation Country object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

CountryQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 654
CountryAreaQuery prune( CountryArea $countryArea = null)

Exclude object from result

Parameters

CountryArea $countryArea Object to remove from the list of results

Return Value

CountryAreaQuery The current query, for fluid interface

at line 669
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the country_area table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

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.

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

at line 747
CountryAreaQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

CountryAreaQuery The current query, for fluid interface

at line 759
CountryAreaQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

CountryAreaQuery The current query, for fluid interface

at line 769
CountryAreaQuery lastUpdatedFirst()

Order by update date desc

Return Value

CountryAreaQuery The current query, for fluid interface

at line 779
CountryAreaQuery firstUpdatedFirst()

Order by update date asc

Return Value

CountryAreaQuery The current query, for fluid interface

at line 789
CountryAreaQuery lastCreatedFirst()

Order by create date desc

Return Value

CountryAreaQuery The current query, for fluid interface

at line 799
CountryAreaQuery firstCreatedFirst()

Order by create date asc

Return Value

CountryAreaQuery The current query, for fluid interface

at line 68
ChildCountryAreaQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery orderByCountryId($order = Criteria::ASC)

Order by the country_id column

Parameters

$order

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery orderByStateId($order = Criteria::ASC)

Order by the state_id column

Parameters

$order

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery orderByAreaId($order = Criteria::ASC)

Order by the area_id column

Parameters

$order

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery groupById()

Group by the id column

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery groupByCountryId()

Group by the country_id column

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery groupByStateId()

Group by the state_id column

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery groupByAreaId()

Group by the area_id column

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery leftJoinArea($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Area relation

Parameters

$relationAlias

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery rightJoinArea($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Area relation

Parameters

$relationAlias

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery innerJoinArea($relationAlias = null)

Adds a INNER JOIN clause to the query using the Area relation

Parameters

$relationAlias

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery leftJoinCountry($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Country relation

Parameters

$relationAlias

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery rightJoinCountry($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Country relation

Parameters

$relationAlias

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryAreaQuery innerJoinCountry($relationAlias = null)

Adds a INNER JOIN clause to the query using the Country relation

Parameters

$relationAlias

Return Value

ChildCountryAreaQuery

at line 68
ChildCountryArea findOne( ConnectionInterface $con = null)

Return the first ChildCountryArea matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCountryArea

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

Parameters

ConnectionInterface $con

Return Value

ChildCountryArea

at line 68
ChildCountryArea findOneById( int $id)

Return the first ChildCountryArea filtered by the id column

Parameters

int $id

Return Value

ChildCountryArea

at line 68
ChildCountryArea findOneByCountryId( int $country_id)

Return the first ChildCountryArea filtered by the country_id column

Parameters

int $country_id

Return Value

ChildCountryArea

at line 68
ChildCountryArea findOneByStateId( int $state_id)

Return the first ChildCountryArea filtered by the state_id column

Parameters

int $state_id

Return Value

ChildCountryArea

at line 68
ChildCountryArea findOneByAreaId( int $area_id)

Return the first ChildCountryArea filtered by the area_id column

Parameters

int $area_id

Return Value

ChildCountryArea

at line 68
ChildCountryArea findOneByCreatedAt( string $created_at)

Return the first ChildCountryArea filtered by the created_at column

Parameters

string $created_at

Return Value

ChildCountryArea

at line 68
ChildCountryArea findOneByUpdatedAt( string $updated_at)

Return the first ChildCountryArea filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildCountryArea

at line 68
array findById( int $id)

Return ChildCountryArea objects filtered by the id column

Parameters

int $id

Return Value

array

at line 68
array findByCountryId( int $country_id)

Return ChildCountryArea objects filtered by the country_id column

Parameters

int $country_id

Return Value

array

at line 68
array findByStateId( int $state_id)

Return ChildCountryArea objects filtered by the state_id column

Parameters

int $state_id

Return Value

array

at line 68
array findByAreaId( int $area_id)

Return ChildCountryArea objects filtered by the area_id column

Parameters

int $area_id

Return Value

array

at line 68
array findByCreatedAt( string $created_at)

Return ChildCountryArea objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 68
array findByUpdatedAt( string $updated_at)

Return ChildCountryArea objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array