ConfigQuery
class ConfigQuery extends ModelCriteria
Base class that represents a query for the 'config' table.
Methods
Initializes internal state of \Thelia\Model\Base\ConfigQuery object.
Returns a new ChildConfigQuery object.
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
Filter the query on the name column
Filter the query on the value column
Filter the query on the secured column
Filter the query on the hidden column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query by a related \Thelia\Model\ConfigI18n object
Adds a JOIN clause to the query using the ConfigI18n relation
Use the ConfigI18n relation ConfigI18n object
Deletes all rows from the config table.
Performs a DELETE on the database, given a ChildConfig 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.
Use the I18n relation query object
Order by the id column
Order by the name column
Order by the value column
Order by the secured column
Order by the hidden column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the name column
Group by the value column
Group by the secured column
Group by the hidden 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 ConfigI18n relation
Adds a RIGHT JOIN clause to the query using the ConfigI18n relation
Adds a INNER JOIN clause to the query using the ConfigI18n relation
Return the first ChildConfig matching the query
Return the first ChildConfig matching the query, or a new ChildConfig object populated from the query conditions when no match is found
Return the first ChildConfig filtered by the id column
Return the first ChildConfig filtered by the name column
Return the first ChildConfig filtered by the value column
Return the first ChildConfig filtered by the secured column
Return the first ChildConfig filtered by the hidden column
Return the first ChildConfig filtered by the created_at column
Return the first ChildConfig filtered by the updated_at column
Return ChildConfig objects filtered by the id column
Return ChildConfig objects filtered by the name column
Return ChildConfig objects filtered by the value column
Return ChildConfig objects filtered by the secured column
Return ChildConfig objects filtered by the hidden column
Return ChildConfig objects filtered by the created_at column
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.
at line 92
static
ConfigQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildConfigQuery object.
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);
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);
at line 225
ConfigQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 238
ConfigQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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%'
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%'
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
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
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'
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'
at line 519
ConfigQuery
filterByConfigI18n(
ConfigI18n|ObjectCollection $configI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ConfigI18n object
at line 542
ConfigQuery
joinConfigI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ConfigI18n relation
at line 577
ConfigI18nQuery
useConfigI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ConfigI18n relation ConfigI18n object
at line 591
ConfigQuery
prune(
Config $config = null)
Exclude object from result
at line 606
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the config table.
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.
at line 684
ConfigQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 696
ConfigQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 706
ConfigQuery
lastUpdatedFirst()
Order by update date desc
at line 716
ConfigQuery
firstUpdatedFirst()
Order by update date asc
at line 726
ConfigQuery
lastCreatedFirst()
Order by create date desc
at line 736
ConfigQuery
firstCreatedFirst()
Order by create date asc
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
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()
at line 791
ConfigI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 69
ChildConfigQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 69
ChildConfigQuery
orderByName($order = Criteria::ASC)
Order by the name column
at line 69
ChildConfigQuery
orderByValue($order = Criteria::ASC)
Order by the value column
at line 69
ChildConfigQuery
orderBySecured($order = Criteria::ASC)
Order by the secured column
at line 69
ChildConfigQuery
orderByHidden($order = Criteria::ASC)
Order by the hidden column
at line 69
ChildConfigQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 69
ChildConfigQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 69
ChildConfigQuery
groupById()
Group by the id column
at line 69
ChildConfigQuery
groupByName()
Group by the name column
at line 69
ChildConfigQuery
groupByValue()
Group by the value column
at line 69
ChildConfigQuery
groupBySecured()
Group by the secured column
at line 69
ChildConfigQuery
groupByHidden()
Group by the hidden column
at line 69
ChildConfigQuery
groupByCreatedAt()
Group by the created_at column
at line 69
ChildConfigQuery
groupByUpdatedAt()
Group by the updated_at column
at line 69
ChildConfigQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 69
ChildConfigQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 69
ChildConfigQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 69
ChildConfigQuery
leftJoinConfigI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ConfigI18n relation
at line 69
ChildConfigQuery
rightJoinConfigI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ConfigI18n relation
at line 69
ChildConfigQuery
innerJoinConfigI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ConfigI18n relation
at line 69
ChildConfig
findOne(
ConnectionInterface $con = null)
Return the first ChildConfig matching the query
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
at line 69
ChildConfig
findOneById(
int $id)
Return the first ChildConfig filtered by the id column
at line 69
ChildConfig
findOneByName(
string $name)
Return the first ChildConfig filtered by the name column
at line 69
ChildConfig
findOneByValue(
string $value)
Return the first ChildConfig filtered by the value column
at line 69
ChildConfig
findOneBySecured(
int $secured)
Return the first ChildConfig filtered by the secured column
at line 69
ChildConfig
findOneByHidden(
int $hidden)
Return the first ChildConfig filtered by the hidden column
at line 69
ChildConfig
findOneByCreatedAt(
string $created_at)
Return the first ChildConfig filtered by the created_at column
at line 69
ChildConfig
findOneByUpdatedAt(
string $updated_at)
Return the first ChildConfig filtered by the updated_at column
at line 69
array
findById(
int $id)
Return ChildConfig objects filtered by the id column
at line 69
array
findByName(
string $name)
Return ChildConfig objects filtered by the name column
at line 69
array
findByValue(
string $value)
Return ChildConfig objects filtered by the value column
at line 69
array
findBySecured(
int $secured)
Return ChildConfig objects filtered by the secured column
at line 69
array
findByHidden(
int $hidden)
Return ChildConfig objects filtered by the hidden column
at line 69
array
findByCreatedAt(
string $created_at)
Return ChildConfig objects filtered by the created_at column
at line 69
array
findByUpdatedAt(
string $updated_at)
Return ChildConfig objects filtered by the updated_at column