ProfileQuery
class ProfileQuery extends ModelCriteria
Base class that represents a query for the 'profile' table.
Methods
Initializes internal state of \Thelia\Model\Base\ProfileQuery object.
Returns a new ChildProfileQuery object.
Find object by primary key.
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 code 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\Admin object
Adds a JOIN clause to the query using the Admin relation
Use the Admin relation Admin object
Filter the query by a related \Thelia\Model\ProfileResource object
Adds a JOIN clause to the query using the ProfileResource relation
Use the ProfileResource relation ProfileResource object
Filter the query by a related \Thelia\Model\ProfileModule object
Adds a JOIN clause to the query using the ProfileModule relation
Use the ProfileModule relation ProfileModule object
Filter the query by a related \Thelia\Model\Api object
Adds a JOIN clause to the query using the Api relation
Use the Api relation Api object
Filter the query by a related \Thelia\Model\ProfileI18n object
Adds a JOIN clause to the query using the ProfileI18n relation
Use the ProfileI18n relation ProfileI18n object
Filter the query by a related Resource object using the profile_resource table as cross reference
Deletes all rows from the profile table.
Performs a DELETE on the database, given a ChildProfile 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 code column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the code 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 Admin relation
Adds a RIGHT JOIN clause to the query using the Admin relation
Adds a INNER JOIN clause to the query using the Admin relation
Adds a LEFT JOIN clause to the query using the ProfileResource relation
Adds a RIGHT JOIN clause to the query using the ProfileResource relation
Adds a INNER JOIN clause to the query using the ProfileResource relation
Adds a LEFT JOIN clause to the query using the ProfileModule relation
Adds a RIGHT JOIN clause to the query using the ProfileModule relation
Adds a INNER JOIN clause to the query using the ProfileModule relation
Adds a LEFT JOIN clause to the query using the Api relation
Adds a RIGHT JOIN clause to the query using the Api relation
Adds a INNER JOIN clause to the query using the Api relation
Adds a LEFT JOIN clause to the query using the ProfileI18n relation
Adds a RIGHT JOIN clause to the query using the ProfileI18n relation
Adds a INNER JOIN clause to the query using the ProfileI18n relation
Return the first ChildProfile matching the query
Return the first ChildProfile matching the query, or a new ChildProfile object populated from the query conditions when no match is found
Return the first ChildProfile filtered by the id column
Return the first ChildProfile filtered by the code column
Return the first ChildProfile filtered by the created_at column
Return the first ChildProfile filtered by the updated_at column
Return ChildProfile objects filtered by the id column
Return ChildProfile objects filtered by the code column
Return ChildProfile objects filtered by the created_at column
Return ChildProfile objects filtered by the updated_at column
Details
at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Profile',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProfileQuery object.
at line 96
static
ProfileQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProfileQuery object.
at line 126
Profile|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 208
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
at line 229
ProfileQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 242
ProfileQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 266
ProfileQuery
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 304
ProfileQuery
filterByCode(
string $code = null,
string $comparison = null)
Filter the query on the code column
Example usage:
$query->filterByCode('fooValue'); // WHERE code = 'fooValue'
$query->filterByCode('%fooValue%'); // WHERE code LIKE '%fooValue%'
at line 338
ProfileQuery
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 381
ProfileQuery
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 412
ProfileQuery
filterByAdmin(
Admin|ObjectCollection $admin,
string $comparison = null)
Filter the query by a related \Thelia\Model\Admin object
at line 435
ProfileQuery
joinAdmin(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Admin relation
at line 470
AdminQuery
useAdminQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Admin relation Admin object
at line 485
ProfileQuery
filterByProfileResource(
ProfileResource|ObjectCollection $profileResource,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProfileResource object
at line 508
ProfileQuery
joinProfileResource(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProfileResource relation
at line 543
ProfileResourceQuery
useProfileResourceQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProfileResource relation ProfileResource object
at line 558
ProfileQuery
filterByProfileModule(
ProfileModule|ObjectCollection $profileModule,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProfileModule object
at line 581
ProfileQuery
joinProfileModule(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProfileModule relation
at line 616
ProfileModuleQuery
useProfileModuleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProfileModule relation ProfileModule object
at line 631
ProfileQuery
filterByApi(
Api|ObjectCollection $api,
string $comparison = null)
Filter the query by a related \Thelia\Model\Api object
at line 654
ProfileQuery
joinApi(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Api relation
at line 689
ApiQuery
useApiQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Api relation Api object
at line 704
ProfileQuery
filterByProfileI18n(
ProfileI18n|ObjectCollection $profileI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProfileI18n object
at line 727
ProfileQuery
joinProfileI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ProfileI18n relation
at line 762
ProfileI18nQuery
useProfileI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ProfileI18n relation ProfileI18n object
at line 778
ProfileQuery
filterByResource(
Resource $resource,
string $comparison = Criteria::EQUAL)
Filter the query by a related Resource object using the profile_resource table as cross reference
at line 793
ProfileQuery
prune(
Profile $profile = null)
Exclude object from result
at line 808
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the profile table.
at line 845
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildProfile or Criteria object OR a primary key value.
at line 886
ProfileQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 898
ProfileQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 908
ProfileQuery
lastUpdatedFirst()
Order by update date desc
at line 918
ProfileQuery
firstUpdatedFirst()
Order by update date asc
at line 928
ProfileQuery
lastCreatedFirst()
Order by create date desc
at line 938
ProfileQuery
firstCreatedFirst()
Order by create date asc
at line 954
ProfileQuery
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 972
ProfileQuery
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 993
ProfileI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
at line 73
ChildProfileQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 73
ChildProfileQuery
orderByCode($order = Criteria::ASC)
Order by the code column
at line 73
ChildProfileQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 73
ChildProfileQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 73
ChildProfileQuery
groupById()
Group by the id column
at line 73
ChildProfileQuery
groupByCode()
Group by the code column
at line 73
ChildProfileQuery
groupByCreatedAt()
Group by the created_at column
at line 73
ChildProfileQuery
groupByUpdatedAt()
Group by the updated_at column
at line 73
ChildProfileQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 73
ChildProfileQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 73
ChildProfileQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 73
ChildProfileQuery
leftJoinAdmin($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Admin relation
at line 73
ChildProfileQuery
rightJoinAdmin($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Admin relation
at line 73
ChildProfileQuery
innerJoinAdmin($relationAlias = null)
Adds a INNER JOIN clause to the query using the Admin relation
at line 73
ChildProfileQuery
leftJoinProfileResource($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProfileResource relation
at line 73
ChildProfileQuery
rightJoinProfileResource($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProfileResource relation
at line 73
ChildProfileQuery
innerJoinProfileResource($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProfileResource relation
at line 73
ChildProfileQuery
leftJoinProfileModule($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProfileModule relation
at line 73
ChildProfileQuery
rightJoinProfileModule($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProfileModule relation
at line 73
ChildProfileQuery
innerJoinProfileModule($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProfileModule relation
at line 73
ChildProfileQuery
leftJoinApi($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Api relation
at line 73
ChildProfileQuery
rightJoinApi($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Api relation
at line 73
ChildProfileQuery
innerJoinApi($relationAlias = null)
Adds a INNER JOIN clause to the query using the Api relation
at line 73
ChildProfileQuery
leftJoinProfileI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProfileI18n relation
at line 73
ChildProfileQuery
rightJoinProfileI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProfileI18n relation
at line 73
ChildProfileQuery
innerJoinProfileI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProfileI18n relation
at line 73
ChildProfile
findOne(
ConnectionInterface $con = null)
Return the first ChildProfile matching the query
at line 73
ChildProfile
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildProfile matching the query, or a new ChildProfile object populated from the query conditions when no match is found
at line 73
ChildProfile
findOneById(
int $id)
Return the first ChildProfile filtered by the id column
at line 73
ChildProfile
findOneByCode(
string $code)
Return the first ChildProfile filtered by the code column
at line 73
ChildProfile
findOneByCreatedAt(
string $created_at)
Return the first ChildProfile filtered by the created_at column
at line 73
ChildProfile
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProfile filtered by the updated_at column
at line 73
array
findById(
int $id)
Return ChildProfile objects filtered by the id column
at line 73
array
findByCode(
string $code)
Return ChildProfile objects filtered by the code column
at line 73
array
findByCreatedAt(
string $created_at)
Return ChildProfile objects filtered by the created_at column
at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildProfile objects filtered by the updated_at column