CountryQuery

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

Returns a new ChildCountryQuery object.

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

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

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

Filter the query on the visible column

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

Filter the query on the isocode column

Example usage: $query->filterByIsocode('fooValue'); // WHERE isocode = 'fooValue' $query->filterByIsocode('%fooValue%'); // WHERE isocode LIKE '%fooValue%'

Filter the query on the isoalpha2 column

Example usage: $query->filterByIsoalpha2('fooValue'); // WHERE isoalpha2 = 'fooValue' $query->filterByIsoalpha2('%fooValue%'); // WHERE isoalpha2 LIKE '%fooValue%'

Filter the query on the isoalpha3 column

Example usage: $query->filterByIsoalpha3('fooValue'); // WHERE isoalpha3 = 'fooValue' $query->filterByIsoalpha3('%fooValue%'); // WHERE isoalpha3 LIKE '%fooValue%'

Filter the query on the has_states column

Example usage: $query->filterByHasStates(1234); // WHERE hasstates = 1234 $query->filterByHasStates(array(12, 34)); // WHERE hasstates IN (12, 34) $query->filterByHasStates(array('min' => 12)); // WHERE has_states > 12

Filter the query on the needzipcode column

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

Filter the query on the zipcodeformat column

Example usage: $query->filterByZipCodeFormat('fooValue'); // WHERE zipcodeformat = 'fooValue' $query->filterByZipCodeFormat('%fooValue%'); // WHERE zipcodeformat LIKE '%fooValue%'

Filter the query on the by_default column

Example usage: $query->filterByByDefault(1234); // WHERE bydefault = 1234 $query->filterByByDefault(array(12, 34)); // WHERE bydefault IN (12, 34) $query->filterByByDefault(array('min' => 12)); // WHERE by_default > 12

Filter the query on the shop_country column

Example usage: $query->filterByShopCountry(true); // WHERE shopcountry = true $query->filterByShopCountry('yes'); // WHERE shopcountry = true

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'

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'

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

Adds a JOIN clause to the query using the TaxRuleCountry relation

Use the TaxRuleCountry relation TaxRuleCountry object

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

Adds a JOIN clause to the query using the Address relation

Use the Address relation Address object

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

Adds a JOIN clause to the query using the OrderAddress relation

Use the OrderAddress relation OrderAddress object

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

Adds a JOIN clause to the query using the CouponCountry relation

Use the CouponCountry relation CouponCountry object

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

Adds a JOIN clause to the query using the OrderCouponCountry relation

Use the OrderCouponCountry relation OrderCouponCountry object

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

Adds a JOIN clause to the query using the CountryArea relation

Use the CountryArea relation CountryArea object

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

Adds a JOIN clause to the query using the State relation

Use the State relation State object

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

Adds a JOIN clause to the query using the CountryI18n relation

Use the CountryI18n relation CountryI18n object

Filter the query by a related Coupon object using the coupon_country table as cross reference

Filter the query by a related OrderCoupon object using the ordercouponcountry table as cross reference

Filter the query by a related Area object using the country_area table as cross reference

Exclude object from result

Deletes all rows from the country table.

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

Filter by the latest updated

Filter by the latest created

Order by update date desc

Order by update date asc

Order by create date desc

Order by create date asc

Adds a JOIN clause to the query using the i18n relation

Adds a JOIN clause to the query and hydrates the related I18n object.

Shortcut for $c->joinI18n($locale)->with()

Use the I18n relation query object

Order by the id column

Order by the visible column

Order by the isocode column

Order by the isoalpha2 column

Order by the isoalpha3 column

Order by the has_states column

Order by the needzipcode column

Order by the zipcodeformat column

Order by the by_default column

Order by the shop_country column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the visible column

Group by the isocode column

Group by the isoalpha2 column

Group by the isoalpha3 column

Group by the has_states column

Group by the needzipcode column

Group by the zipcodeformat column

Group by the by_default column

Group by the shop_country column

Group by the created_at column

Group 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 TaxRuleCountry relation

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Return the first ChildCountry matching the query

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

Return the first ChildCountry filtered by the id column

Return the first ChildCountry filtered by the visible column

Return the first ChildCountry filtered by the isocode column

Return the first ChildCountry filtered by the isoalpha2 column

Return the first ChildCountry filtered by the isoalpha3 column

Return the first ChildCountry filtered by the has_states column

Return the first ChildCountry filtered by the needzipcode column

Return the first ChildCountry filtered by the zipcodeformat column

Return the first ChildCountry filtered by the by_default column

Return the first ChildCountry filtered by the shop_country column

Return the first ChildCountry filtered by the created_at column

Return the first ChildCountry filtered by the updated_at column

Return ChildCountry objects filtered by the id column

Return ChildCountry objects filtered by the visible column

Return ChildCountry objects filtered by the isocode column

Return ChildCountry objects filtered by the isoalpha2 column

Return ChildCountry objects filtered by the isoalpha3 column

Return ChildCountry objects filtered by the has_states column

Return ChildCountry objects filtered by the needzipcode column

Return ChildCountry objects filtered by the zipcodeformat column

Return ChildCountry objects filtered by the by_default column

Return ChildCountry objects filtered by the shop_country column

Return ChildCountry objects filtered by the created_at column

Return ChildCountry objects filtered by the updated_at column