ProfileQuery
class ProfileQuery extends ProfileQuery
Skeleton subclass for performing query and update operations on the 'profile' 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
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 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.
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 created_at column
Order by the updated_at column
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 code column
Return ChildProfile objects filtered by the created_at column
Return ChildProfile objects filtered by the updated_at column
No description
Details
in
ProfileQuery at line 83
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Profile',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProfileQuery object.
in
ProfileQuery at line 96
static
ProfileQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProfileQuery object.
in
ProfileQuery 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);
in
ProfileQuery 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);
in
ProfileQuery at line 229
ProfileQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
ProfileQuery at line 242
ProfileQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
ProfileQuery 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
in
ProfileQuery 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%'
in
ProfileQuery 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'
in
ProfileQuery 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'
in
ProfileQuery at line 412
ProfileQuery
filterByAdmin(
Admin|ObjectCollection $admin,
string $comparison = null)
Filter the query by a related \Thelia\Model\Admin object
in
ProfileQuery at line 435
ProfileQuery
joinAdmin(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Admin relation
in
ProfileQuery at line 470
AdminQuery
useAdminQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Admin relation Admin object
in
ProfileQuery at line 485
ProfileQuery
filterByProfileResource(
ProfileResource|ObjectCollection $profileResource,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProfileResource object
in
ProfileQuery at line 508
ProfileQuery
joinProfileResource(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProfileResource relation
in
ProfileQuery at line 543
ProfileResourceQuery
useProfileResourceQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProfileResource relation ProfileResource object
in
ProfileQuery at line 558
ProfileQuery
filterByProfileModule(
ProfileModule|ObjectCollection $profileModule,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProfileModule object
in
ProfileQuery at line 581
ProfileQuery
joinProfileModule(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the ProfileModule relation
in
ProfileQuery at line 616
ProfileModuleQuery
useProfileModuleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the ProfileModule relation ProfileModule object
in
ProfileQuery at line 631
ProfileQuery
filterByApi(
Api|ObjectCollection $api,
string $comparison = null)
Filter the query by a related \Thelia\Model\Api object
in
ProfileQuery at line 654
ProfileQuery
joinApi(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the Api relation
in
ProfileQuery at line 689
ApiQuery
useApiQuery(
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the Api relation Api object
in
ProfileQuery at line 704
ProfileQuery
filterByProfileI18n(
ProfileI18n|ObjectCollection $profileI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\ProfileI18n object
in
ProfileQuery at line 727
ProfileQuery
joinProfileI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the ProfileI18n relation
in
ProfileQuery at line 762
ProfileI18nQuery
useProfileI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the ProfileI18n relation ProfileI18n object
in
ProfileQuery 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
in
ProfileQuery at line 793
ProfileQuery
prune(
Profile $profile = null)
Exclude object from result
in
ProfileQuery at line 808
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the profile table.
in
ProfileQuery 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.
in
ProfileQuery at line 886
ProfileQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
ProfileQuery at line 898
ProfileQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
ProfileQuery at line 908
ProfileQuery
lastUpdatedFirst()
Order by update date desc
in
ProfileQuery at line 918
ProfileQuery
firstUpdatedFirst()
Order by update date asc
in
ProfileQuery at line 928
ProfileQuery
lastCreatedFirst()
Order by create date desc
in
ProfileQuery at line 938
ProfileQuery
firstCreatedFirst()
Order by create date asc
in
ProfileQuery 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
in
ProfileQuery 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()
in
ProfileQuery at line 993
ProfileI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
ProfileQuery at line 73
ChildProfileQuery
orderById($order = Criteria::ASC)
Order by the id column
in
ProfileQuery at line 73
ChildProfileQuery
orderByCode($order = Criteria::ASC)
Order by the code column
in
ProfileQuery at line 73
ChildProfileQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
ProfileQuery at line 73
ChildProfileQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
ProfileQuery at line 73
ChildProfileQuery
groupById()
Group by the id column
in
ProfileQuery at line 73
ChildProfileQuery
groupByCode()
Group by the code column
in
ProfileQuery at line 73
ChildProfileQuery
groupByCreatedAt()
Group by the created_at column
in
ProfileQuery at line 73
ChildProfileQuery
groupByUpdatedAt()
Group by the updated_at column
in
ProfileQuery at line 73
ChildProfileQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
ProfileQuery at line 73
ChildProfileQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
ProfileQuery at line 73
ChildProfileQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
ProfileQuery at line 73
ChildProfileQuery
leftJoinAdmin($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Admin relation
in
ProfileQuery at line 73
ChildProfileQuery
rightJoinAdmin($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Admin relation
in
ProfileQuery at line 73
ChildProfileQuery
innerJoinAdmin($relationAlias = null)
Adds a INNER JOIN clause to the query using the Admin relation
in
ProfileQuery at line 73
ChildProfileQuery
leftJoinProfileResource($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProfileResource relation
in
ProfileQuery at line 73
ChildProfileQuery
rightJoinProfileResource($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProfileResource relation
in
ProfileQuery at line 73
ChildProfileQuery
innerJoinProfileResource($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProfileResource relation
in
ProfileQuery at line 73
ChildProfileQuery
leftJoinProfileModule($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProfileModule relation
in
ProfileQuery at line 73
ChildProfileQuery
rightJoinProfileModule($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProfileModule relation
in
ProfileQuery at line 73
ChildProfileQuery
innerJoinProfileModule($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProfileModule relation
in
ProfileQuery at line 73
ChildProfileQuery
leftJoinApi($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Api relation
in
ProfileQuery at line 73
ChildProfileQuery
rightJoinApi($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Api relation
in
ProfileQuery at line 73
ChildProfileQuery
innerJoinApi($relationAlias = null)
Adds a INNER JOIN clause to the query using the Api relation
in
ProfileQuery at line 73
ChildProfileQuery
leftJoinProfileI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the ProfileI18n relation
in
ProfileQuery at line 73
ChildProfileQuery
rightJoinProfileI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the ProfileI18n relation
in
ProfileQuery at line 73
ChildProfileQuery
innerJoinProfileI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the ProfileI18n relation
in
ProfileQuery at line 73
ChildProfile
findOne(
ConnectionInterface $con = null)
Return the first ChildProfile matching the query
in
ProfileQuery 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
in
ProfileQuery at line 73
ChildProfile
findOneById(
int $id)
Return the first ChildProfile filtered by the id column
in
ProfileQuery at line 73
ChildProfile
findOneByCode(
string $code)
Return the first ChildProfile filtered by the code column
in
ProfileQuery at line 73
ChildProfile
findOneByCreatedAt(
string $created_at)
Return the first ChildProfile filtered by the created_at column
in
ProfileQuery at line 73
ChildProfile
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProfile filtered by the updated_at column
in
ProfileQuery at line 73
array
findById(
int $id)
Return ChildProfile objects filtered by the id column
in
ProfileQuery at line 73
array
findByCode(
string $code)
Return ChildProfile objects filtered by the code column
in
ProfileQuery at line 73
array
findByCreatedAt(
string $created_at)
Return ChildProfile objects filtered by the created_at column
in
ProfileQuery at line 73
array
findByUpdatedAt(
string $updated_at)
Return ChildProfile objects filtered by the updated_at column