class ConfigQuery extends ModelCriteria

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

Methods

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

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

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

Returns a new ChildConfigQuery object.

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

filterByName( string $name = null, string $comparison = null)

Filter the query on the name column

filterByValue( string $value = null, string $comparison = null)

Filter the query on the value column

filterBySecured( mixed $secured = null, string $comparison = null)

Filter the query on the secured column

filterByHidden( mixed $hidden = null, string $comparison = null)

Filter the query on the hidden 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

filterByConfigI18n( ConfigI18n|ObjectCollection $configI18n, string $comparison = null)

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

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

Adds a JOIN clause to the query using the ConfigI18n relation

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

Use the ConfigI18n relation ConfigI18n object

prune( Config $config = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the config table.

int
delete( ConnectionInterface $con = null)

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

joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

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

useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

ChildConfigQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildConfigQuery
orderByName($order = Criteria::ASC)

Order by the name column

ChildConfigQuery
orderByValue($order = Criteria::ASC)

Order by the value column

ChildConfigQuery
orderBySecured($order = Criteria::ASC)

Order by the secured column

ChildConfigQuery
orderByHidden($order = Criteria::ASC)

Order by the hidden column

ChildConfigQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildConfigQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildConfigQuery
groupById()

Group by the id column

ChildConfigQuery
groupByName()

Group by the name column

ChildConfigQuery
groupByValue()

Group by the value column

ChildConfigQuery
groupBySecured()

Group by the secured column

ChildConfigQuery
groupByHidden()

Group by the hidden column

ChildConfigQuery
groupByCreatedAt()

Group by the created_at column

ChildConfigQuery
groupByUpdatedAt()

Group by the updated_at column

ChildConfigQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildConfigQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildConfigQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildConfigQuery
leftJoinConfigI18n($relationAlias = null)

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

ChildConfigQuery
rightJoinConfigI18n($relationAlias = null)

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

ChildConfigQuery
innerJoinConfigI18n($relationAlias = null)

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

ChildConfig
findOne( ConnectionInterface $con = null)

Return the first ChildConfig matching the query

ChildConfig
findOneOrCreate( ConnectionInterface $con = null)

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

ChildConfig
findOneById( int $id)

Return the first ChildConfig filtered by the id column

ChildConfig
findOneByName( string $name)

Return the first ChildConfig filtered by the name column

ChildConfig
findOneByValue( string $value)

Return the first ChildConfig filtered by the value column

ChildConfig
findOneBySecured( int $secured)

Return the first ChildConfig filtered by the secured column

ChildConfig
findOneByHidden( int $hidden)

Return the first ChildConfig filtered by the hidden column

ChildConfig
findOneByCreatedAt( string $created_at)

Return the first ChildConfig filtered by the created_at column

ChildConfig
findOneByUpdatedAt( string $updated_at)

Return the first ChildConfig filtered by the updated_at column

array
findById( int $id)

Return ChildConfig objects filtered by the id column

array
findByName( string $name)

Return ChildConfig objects filtered by the name column

array
findByValue( string $value)

Return ChildConfig objects filtered by the value column

array
findBySecured( int $secured)

Return ChildConfig objects filtered by the secured column

array
findByHidden( int $hidden)

Return ChildConfig objects filtered by the hidden column

array
findByCreatedAt( string $created_at)

Return ChildConfig objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildConfig objects filtered by the updated_at column

Details

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

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

Returns a new ChildConfigQuery object.

Parameters

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

Return Value

ConfigQuery

at line 122
Config|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

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

at line 204
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 225
ConfigQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

ConfigQuery The current query, for fluid interface

at line 238
ConfigQuery 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

ConfigQuery The current query, for fluid interface

at line 262
ConfigQuery 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

ConfigQuery The current query, for fluid interface

at line 300
ConfigQuery filterByName( string $name = null, string $comparison = null)

Filter the query on the name column

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

Parameters

string $name 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

ConfigQuery The current query, for fluid interface

at line 329
ConfigQuery filterByValue( string $value = null, string $comparison = null)

Filter the query on the value column

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

Parameters

string $value 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

ConfigQuery The current query, for fluid interface

at line 361
ConfigQuery filterBySecured( mixed $secured = null, string $comparison = null)

Filter the query on the secured column

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

Parameters

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

ConfigQuery The current query, for fluid interface

at line 402
ConfigQuery filterByHidden( mixed $hidden = null, string $comparison = null)

Filter the query on the hidden column

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

Parameters

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

ConfigQuery The current query, for fluid interface

at line 445
ConfigQuery 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

ConfigQuery The current query, for fluid interface

at line 488
ConfigQuery 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

ConfigQuery The current query, for fluid interface

at line 519
ConfigQuery filterByConfigI18n( ConfigI18n|ObjectCollection $configI18n, string $comparison = null)

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

Parameters

ConfigI18n|ObjectCollection $configI18n the related object to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ConfigQuery The current query, for fluid interface

at line 542
ConfigQuery joinConfigI18n( string $relationAlias = null, string $joinType = 'LEFT JOIN')

Adds a JOIN clause to the query using the ConfigI18n relation

Parameters

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

Return Value

ConfigQuery The current query, for fluid interface

at line 577
ConfigI18nQuery useConfigI18nQuery( string $relationAlias = null, string $joinType = 'LEFT JOIN')

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

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

See also

useQuery()

at line 591
ConfigQuery prune( Config $config = null)

Exclude object from result

Parameters

Config $config Object to remove from the list of results

Return Value

ConfigQuery The current query, for fluid interface

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

Deletes all rows from the config table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

at line 643
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildConfig 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 684
ConfigQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

ConfigQuery The current query, for fluid interface

at line 696
ConfigQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

ConfigQuery The current query, for fluid interface

at line 706
ConfigQuery lastUpdatedFirst()

Order by update date desc

Return Value

ConfigQuery The current query, for fluid interface

at line 716
ConfigQuery firstUpdatedFirst()

Order by update date asc

Return Value

ConfigQuery The current query, for fluid interface

at line 726
ConfigQuery lastCreatedFirst()

Order by create date desc

Return Value

ConfigQuery The current query, for fluid interface

at line 736
ConfigQuery firstCreatedFirst()

Order by create date asc

Return Value

ConfigQuery The current query, for fluid interface

at line 752
ConfigQuery joinI18n( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Adds a JOIN clause to the query using the i18n relation

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

ConfigQuery The current query, for fluid interface

at line 770
ConfigQuery joinWithI18n( string $locale = 'en_US', string $joinType = Criteria::LEFT_JOIN)

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

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

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

ConfigQuery The current query, for fluid interface

at line 791
ConfigI18nQuery useI18nQuery( string $locale = 'en_US', string $relationAlias = null, string $joinType = Criteria::LEFT_JOIN)

Use the I18n relation query object

Parameters

string $locale Locale to use for the join condition, e.g. 'fr_FR'
string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'. Defaults to left join.

Return Value

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

See also

useQuery()

at line 69
ChildConfigQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery orderByName($order = Criteria::ASC)

Order by the name column

Parameters

$order

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery orderByValue($order = Criteria::ASC)

Order by the value column

Parameters

$order

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery orderBySecured($order = Criteria::ASC)

Order by the secured column

Parameters

$order

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery orderByHidden($order = Criteria::ASC)

Order by the hidden column

Parameters

$order

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery groupById()

Group by the id column

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery groupByName()

Group by the name column

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery groupByValue()

Group by the value column

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery groupBySecured()

Group by the secured column

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery groupByHidden()

Group by the hidden column

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery leftJoinConfigI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery rightJoinConfigI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildConfigQuery

at line 69
ChildConfigQuery innerJoinConfigI18n($relationAlias = null)

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

Parameters

$relationAlias

Return Value

ChildConfigQuery

at line 69
ChildConfig findOne( ConnectionInterface $con = null)

Return the first ChildConfig matching the query

Parameters

ConnectionInterface $con

Return Value

ChildConfig

at line 69
ChildConfig findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildConfig

at line 69
ChildConfig findOneById( int $id)

Return the first ChildConfig filtered by the id column

Parameters

int $id

Return Value

ChildConfig

at line 69
ChildConfig findOneByName( string $name)

Return the first ChildConfig filtered by the name column

Parameters

string $name

Return Value

ChildConfig

at line 69
ChildConfig findOneByValue( string $value)

Return the first ChildConfig filtered by the value column

Parameters

string $value

Return Value

ChildConfig

at line 69
ChildConfig findOneBySecured( int $secured)

Return the first ChildConfig filtered by the secured column

Parameters

int $secured

Return Value

ChildConfig

at line 69
ChildConfig findOneByHidden( int $hidden)

Return the first ChildConfig filtered by the hidden column

Parameters

int $hidden

Return Value

ChildConfig

at line 69
ChildConfig findOneByCreatedAt( string $created_at)

Return the first ChildConfig filtered by the created_at column

Parameters

string $created_at

Return Value

ChildConfig

at line 69
ChildConfig findOneByUpdatedAt( string $updated_at)

Return the first ChildConfig filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildConfig

at line 69
array findById( int $id)

Return ChildConfig objects filtered by the id column

Parameters

int $id

Return Value

array

at line 69
array findByName( string $name)

Return ChildConfig objects filtered by the name column

Parameters

string $name

Return Value

array

at line 69
array findByValue( string $value)

Return ChildConfig objects filtered by the value column

Parameters

string $value

Return Value

array

at line 69
array findBySecured( int $secured)

Return ChildConfig objects filtered by the secured column

Parameters

int $secured

Return Value

array

at line 69
array findByHidden( int $hidden)

Return ChildConfig objects filtered by the hidden column

Parameters

int $hidden

Return Value

array

at line 69
array findByCreatedAt( string $created_at)

Return ChildConfig objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 69
array findByUpdatedAt( string $updated_at)

Return ChildConfig objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array