class StateI18nQuery extends StateI18nQuery

Skeleton subclass for performing query and update operations on the 'state_i18n' 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\\StateI18n', string $modelAlias = null)

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

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

Returns a new ChildStateI18nQuery object.

StateI18n|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

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

Filter the query on the id column

filterByLocale( string $locale = null, string $comparison = null)

Filter the query on the locale column

filterByTitle( string $title = null, string $comparison = null)

Filter the query on the title column

filterByState( State|ObjectCollection $state, string $comparison = null)

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

joinState( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the State relation

useStateQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Use the State relation State object

prune( StateI18n $stateI18n = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the state_i18n table.

int
delete( ConnectionInterface $con = null)

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

ChildStateI18nQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildStateI18nQuery
orderByLocale($order = Criteria::ASC)

Order by the locale column

ChildStateI18nQuery
orderByTitle($order = Criteria::ASC)

Order by the title column

ChildStateI18nQuery
groupById()

Group by the id column

ChildStateI18nQuery
groupByLocale()

Group by the locale column

ChildStateI18nQuery
groupByTitle()

Group by the title column

ChildStateI18nQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildStateI18nQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildStateI18nQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildStateI18nQuery
leftJoinState($relationAlias = null)

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

ChildStateI18nQuery
rightJoinState($relationAlias = null)

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

ChildStateI18nQuery
innerJoinState($relationAlias = null)

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

ChildStateI18n
findOne( ConnectionInterface $con = null)

Return the first ChildStateI18n matching the query

ChildStateI18n
findOneOrCreate( ConnectionInterface $con = null)

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

ChildStateI18n
findOneById( int $id)

Return the first ChildStateI18n filtered by the id column

ChildStateI18n
findOneByLocale( string $locale)

Return the first ChildStateI18n filtered by the locale column

ChildStateI18n
findOneByTitle( string $title)

Return the first ChildStateI18n filtered by the title column

array
findById( int $id)

Return ChildStateI18n objects filtered by the id column

array
findByLocale( string $locale)

Return ChildStateI18n objects filtered by the locale column

array
findByTitle( string $title)

Return ChildStateI18n objects filtered by the title column

Details

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

Initializes internal state of \Thelia\Model\Base\StateI18nQuery 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 StateI18nQuery at line 75
static StateI18nQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildStateI18nQuery object.

Parameters

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

Return Value

StateI18nQuery

in StateI18nQuery at line 105
StateI18n|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

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

in StateI18nQuery 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 StateI18nQuery at line 209
StateI18nQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

StateI18nQuery The current query, for fluid interface

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

StateI18nQuery The current query, for fluid interface

in StateI18nQuery at line 259
StateI18nQuery 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

StateI18nQuery The current query, for fluid interface

See also

filterByState()

in StateI18nQuery at line 297
StateI18nQuery filterByLocale( string $locale = null, string $comparison = null)

Filter the query on the locale column

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

Parameters

string $locale The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

StateI18nQuery The current query, for fluid interface

in StateI18nQuery at line 326
StateI18nQuery filterByTitle( string $title = null, string $comparison = null)

Filter the query on the title column

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

Parameters

string $title The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

StateI18nQuery The current query, for fluid interface

in StateI18nQuery at line 348
StateI18nQuery filterByState( State|ObjectCollection $state, string $comparison = null)

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

Parameters

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

Return Value

StateI18nQuery The current query, for fluid interface

in StateI18nQuery at line 373
StateI18nQuery joinState( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the State relation

Parameters

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

Return Value

StateI18nQuery The current query, for fluid interface

in StateI18nQuery at line 408
StateQuery useStateQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

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

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

See also

useQuery()

in StateI18nQuery at line 422
StateI18nQuery prune( StateI18n $stateI18n = null)

Exclude object from result

Parameters

StateI18n $stateI18n Object to remove from the list of results

Return Value

StateI18nQuery The current query, for fluid interface

in StateI18nQuery at line 439
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the state_i18n table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

in StateI18nQuery at line 476
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildStateI18n 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 StateI18nQuery at line 52
ChildStateI18nQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery orderByLocale($order = Criteria::ASC)

Order by the locale column

Parameters

$order

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery orderByTitle($order = Criteria::ASC)

Order by the title column

Parameters

$order

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery groupById()

Group by the id column

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery groupByLocale()

Group by the locale column

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery groupByTitle()

Group by the title column

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery leftJoinState($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery rightJoinState($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18nQuery innerJoinState($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildStateI18nQuery

in StateI18nQuery at line 52
ChildStateI18n findOne( ConnectionInterface $con = null)

Return the first ChildStateI18n matching the query

Parameters

ConnectionInterface $con

Return Value

ChildStateI18n

in StateI18nQuery at line 52
ChildStateI18n findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildStateI18n

in StateI18nQuery at line 52
ChildStateI18n findOneById( int $id)

Return the first ChildStateI18n filtered by the id column

Parameters

int $id

Return Value

ChildStateI18n

in StateI18nQuery at line 52
ChildStateI18n findOneByLocale( string $locale)

Return the first ChildStateI18n filtered by the locale column

Parameters

string $locale

Return Value

ChildStateI18n

in StateI18nQuery at line 52
ChildStateI18n findOneByTitle( string $title)

Return the first ChildStateI18n filtered by the title column

Parameters

string $title

Return Value

ChildStateI18n

in StateI18nQuery at line 52
array findById( int $id)

Return ChildStateI18n objects filtered by the id column

Parameters

int $id

Return Value

array

in StateI18nQuery at line 52
array findByLocale( string $locale)

Return ChildStateI18n objects filtered by the locale column

Parameters

string $locale

Return Value

array

in StateI18nQuery at line 52
array findByTitle( string $title)

Return ChildStateI18n objects filtered by the title column

Parameters

string $title

Return Value

array