class CouponCountryQuery extends CouponCountryQuery

Skeleton subclass for performing query and update operations on the 'coupon_country' 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

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

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

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

Returns a new ChildCouponCountryQuery object.

CouponCountry|array|mixed
findPk($key, $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(array(12, 56), array(832, 123), array(123, 456)), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterByCouponId( mixed $couponId = null, string $comparison = null)

Filter the query on the coupon_id column

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

Filter the query on the country_id column

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

filterByCoupon( Coupon|ObjectCollection $coupon, string $comparison = null)

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

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

Adds a JOIN clause to the query using the Coupon relation

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

Use the Coupon relation Coupon object

prune( CouponCountry $couponCountry = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the coupon_country table.

int
delete( ConnectionInterface $con = null)

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

ChildCouponCountryQuery
orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

ChildCouponCountryQuery
orderByCountryId($order = Criteria::ASC)

Order by the country_id column

ChildCouponCountryQuery
groupByCouponId()

Group by the coupon_id column

ChildCouponCountryQuery
groupByCountryId()

Group by the country_id column

ChildCouponCountryQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildCouponCountryQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildCouponCountryQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildCouponCountryQuery
leftJoinCountry($relationAlias = null)

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

ChildCouponCountryQuery
rightJoinCountry($relationAlias = null)

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

ChildCouponCountryQuery
innerJoinCountry($relationAlias = null)

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

ChildCouponCountryQuery
leftJoinCoupon($relationAlias = null)

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

ChildCouponCountryQuery
rightJoinCoupon($relationAlias = null)

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

ChildCouponCountryQuery
innerJoinCoupon($relationAlias = null)

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

ChildCouponCountry
findOne( ConnectionInterface $con = null)

Return the first ChildCouponCountry matching the query

ChildCouponCountry
findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildCouponCountry matching the query, or a new ChildCouponCountry object populated from the query conditions when no match is found

ChildCouponCountry
findOneByCouponId( int $coupon_id)

Return the first ChildCouponCountry filtered by the coupon_id column

ChildCouponCountry
findOneByCountryId( int $country_id)

Return the first ChildCouponCountry filtered by the country_id column

array
findByCouponId( int $coupon_id)

Return ChildCouponCountry objects filtered by the coupon_id column

array
findByCountryId( int $country_id)

Return ChildCouponCountry objects filtered by the country_id column

Details

in CouponCountryQuery at line 62
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\CouponCountry', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\CouponCountryQuery 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'

in CouponCountryQuery at line 75
static CouponCountryQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildCouponCountryQuery object.

Parameters

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

Return Value

CouponCountryQuery

in CouponCountryQuery at line 105
CouponCountry|array|mixed findPk($key, $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(array(12, 34), $con);

Parameters

$key
$con

Return Value

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

in CouponCountryQuery at line 188
ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $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

in CouponCountryQuery at line 209
CouponCountryQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

CouponCountryQuery The current query, for fluid interface

in CouponCountryQuery at line 224
CouponCountryQuery 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

CouponCountryQuery The current query, for fluid interface

in CouponCountryQuery at line 259
CouponCountryQuery filterByCouponId( mixed $couponId = null, string $comparison = null)

Filter the query on the coupon_id column

Example usage: $query->filterByCouponId(1234); // WHERE couponid = 1234 $query->filterByCouponId(array(12, 34)); // WHERE couponid IN (12, 34) $query->filterByCouponId(array('min' => 12)); // WHERE coupon_id > 12

Parameters

mixed $couponId 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

CouponCountryQuery The current query, for fluid interface

See also

filterByCoupon()

in CouponCountryQuery at line 302
CouponCountryQuery 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

CouponCountryQuery The current query, for fluid interface

See also

filterByCountry()

in CouponCountryQuery at line 333
CouponCountryQuery 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

CouponCountryQuery The current query, for fluid interface

in CouponCountryQuery at line 358
CouponCountryQuery 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

CouponCountryQuery The current query, for fluid interface

in CouponCountryQuery at line 393
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()

in CouponCountryQuery at line 408
CouponCountryQuery filterByCoupon( Coupon|ObjectCollection $coupon, string $comparison = null)

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

Parameters

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

Return Value

CouponCountryQuery The current query, for fluid interface

in CouponCountryQuery at line 433
CouponCountryQuery joinCoupon( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Coupon relation

Parameters

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

Return Value

CouponCountryQuery The current query, for fluid interface

in CouponCountryQuery at line 468
CouponQuery useCouponQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Coupon relation Coupon 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

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

See also

useQuery()

in CouponCountryQuery at line 482
CouponCountryQuery prune( CouponCountry $couponCountry = null)

Exclude object from result

Parameters

CouponCountry $couponCountry Object to remove from the list of results

Return Value

CouponCountryQuery The current query, for fluid interface

in CouponCountryQuery at line 499
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the coupon_country table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

in CouponCountryQuery at line 536
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildCouponCountry 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.

in CouponCountryQuery at line 52
ChildCouponCountryQuery orderByCouponId($order = Criteria::ASC)

Order by the coupon_id column

Parameters

$order

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery orderByCountryId($order = Criteria::ASC)

Order by the country_id column

Parameters

$order

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery groupByCouponId()

Group by the coupon_id column

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery groupByCountryId()

Group by the country_id column

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery leftJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery rightJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery innerJoinCountry($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery leftJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery rightJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountryQuery innerJoinCoupon($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildCouponCountryQuery

in CouponCountryQuery at line 52
ChildCouponCountry findOne( ConnectionInterface $con = null)

Return the first ChildCouponCountry matching the query

Parameters

ConnectionInterface $con

Return Value

ChildCouponCountry

in CouponCountryQuery at line 52
ChildCouponCountry findOneOrCreate( ConnectionInterface $con = null)

Return the first ChildCouponCountry matching the query, or a new ChildCouponCountry object populated from the query conditions when no match is found

Parameters

ConnectionInterface $con

Return Value

ChildCouponCountry

in CouponCountryQuery at line 52
ChildCouponCountry findOneByCouponId( int $coupon_id)

Return the first ChildCouponCountry filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

ChildCouponCountry

in CouponCountryQuery at line 52
ChildCouponCountry findOneByCountryId( int $country_id)

Return the first ChildCouponCountry filtered by the country_id column

Parameters

int $country_id

Return Value

ChildCouponCountry

in CouponCountryQuery at line 52
array findByCouponId( int $coupon_id)

Return ChildCouponCountry objects filtered by the coupon_id column

Parameters

int $coupon_id

Return Value

array

in CouponCountryQuery at line 52
array findByCountryId( int $country_id)

Return ChildCouponCountry objects filtered by the country_id column

Parameters

int $country_id

Return Value

array