ProfileResourceQuery
class ProfileResourceQuery extends ModelCriteria
Base class that represents a query for the 'profile_resource' table.
Methods
Initializes internal state of \Thelia\Model\Base\ProfileResourceQuery object.
Returns a new ChildProfileResourceQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(array(12, 56), array(832, 123), array(123, 456)), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the profile_id column
Filter the query on the resource_id column
Filter the query on the access 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\Profile object
Adds a JOIN clause to the query using the Profile relation
Use the Profile relation Profile object
Filter the query by a related \Thelia\Model\Resource object
Adds a JOIN clause to the query using the Resource relation
Use the Resource relation Resource object
Deletes all rows from the profile_resource table.
Performs a DELETE on the database, given a ChildProfileResource 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
Order by the profile_id column
Order by the resource_id column
Order by the access column
Order by the created_at column
Order by the updated_at column
Group by the profile_id column
Group by the resource_id column
Group by the access 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 Profile relation
Adds a RIGHT JOIN clause to the query using the Profile relation
Adds a INNER JOIN clause to the query using the Profile relation
Adds a LEFT JOIN clause to the query using the Resource relation
Adds a RIGHT JOIN clause to the query using the Resource relation
Adds a INNER JOIN clause to the query using the Resource relation
Return the first ChildProfileResource matching the query
Return the first ChildProfileResource matching the query, or a new ChildProfileResource object populated from the query conditions when no match is found
Return the first ChildProfileResource filtered by the profile_id column
Return the first ChildProfileResource filtered by the resource_id column
Return the first ChildProfileResource filtered by the access column
Return the first ChildProfileResource filtered by the created_at column
Return the first ChildProfileResource filtered by the updated_at column
Return ChildProfileResource objects filtered by the profile_id column
Return ChildProfileResource objects filtered by the resource_id column
Return ChildProfileResource objects filtered by the access column
Return ChildProfileResource objects filtered by the created_at column
Return ChildProfileResource objects filtered by the updated_at column
Details
at line 74
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\ProfileResource',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProfileResourceQuery object.
at line 87
static
ProfileResourceQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProfileResourceQuery object.
at line 117
ProfileResource|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);
at line 200
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);
at line 221
ProfileResourceQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 236
ProfileResourceQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
at line 271
ProfileResourceQuery
filterByProfileId(
mixed $profileId = null,
string $comparison = null)
Filter the query on the profile_id column
Example usage:
$query->filterByProfileId(1234); // WHERE profileid = 1234
$query->filterByProfileId(array(12, 34)); // WHERE profileid IN (12, 34)
$query->filterByProfileId(array('min' => 12)); // WHERE profile_id > 12
at line 314
ProfileResourceQuery
filterByResourceId(
mixed $resourceId = null,
string $comparison = null)
Filter the query on the resource_id column
Example usage:
$query->filterByResourceId(1234); // WHERE resourceid = 1234
$query->filterByResourceId(array(12, 34)); // WHERE resourceid IN (12, 34)
$query->filterByResourceId(array('min' => 12)); // WHERE resource_id > 12
at line 355
ProfileResourceQuery
filterByAccess(
mixed $access = null,
string $comparison = null)
Filter the query on the access column
Example usage:
$query->filterByAccess(1234); // WHERE access = 1234
$query->filterByAccess(array(12, 34)); // WHERE access IN (12, 34)
$query->filterByAccess(array('min' => 12)); // WHERE access > 12
at line 398
ProfileResourceQuery
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 441
ProfileResourceQuery
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 472
ProfileResourceQuery
filterByProfile(
Profile|ObjectCollection $profile,
string $comparison = null)
Filter the query by a related \Thelia\Model\Profile object
at line 497
ProfileResourceQuery
joinProfile(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Profile relation
at line 532
ProfileQuery
useProfileQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Profile relation Profile object
at line 547
ProfileResourceQuery
filterByResource(
Resource|ObjectCollection $resource,
string $comparison = null)
Filter the query by a related \Thelia\Model\Resource object
at line 572
ProfileResourceQuery
joinResource(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Resource relation
at line 607
ResourceQuery
useResourceQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Resource relation Resource object
at line 621
ProfileResourceQuery
prune(
ProfileResource $profileResource = null)
Exclude object from result
at line 638
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the profile_resource table.
at line 675
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildProfileResource or Criteria object OR a primary key value.
at line 716
ProfileResourceQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 728
ProfileResourceQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 738
ProfileResourceQuery
lastUpdatedFirst()
Order by update date desc
at line 748
ProfileResourceQuery
firstUpdatedFirst()
Order by update date asc
at line 758
ProfileResourceQuery
lastCreatedFirst()
Order by create date desc
at line 768
ProfileResourceQuery
firstCreatedFirst()
Order by create date asc
at line 64
ChildProfileResourceQuery
orderByProfileId($order = Criteria::ASC)
Order by the profile_id column
at line 64
ChildProfileResourceQuery
orderByResourceId($order = Criteria::ASC)
Order by the resource_id column
at line 64
ChildProfileResourceQuery
orderByAccess($order = Criteria::ASC)
Order by the access column
at line 64
ChildProfileResourceQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 64
ChildProfileResourceQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 64
ChildProfileResourceQuery
groupByProfileId()
Group by the profile_id column
at line 64
ChildProfileResourceQuery
groupByResourceId()
Group by the resource_id column
at line 64
ChildProfileResourceQuery
groupByAccess()
Group by the access column
at line 64
ChildProfileResourceQuery
groupByCreatedAt()
Group by the created_at column
at line 64
ChildProfileResourceQuery
groupByUpdatedAt()
Group by the updated_at column
at line 64
ChildProfileResourceQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 64
ChildProfileResourceQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 64
ChildProfileResourceQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 64
ChildProfileResourceQuery
leftJoinProfile($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Profile relation
at line 64
ChildProfileResourceQuery
rightJoinProfile($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Profile relation
at line 64
ChildProfileResourceQuery
innerJoinProfile($relationAlias = null)
Adds a INNER JOIN clause to the query using the Profile relation
at line 64
ChildProfileResourceQuery
leftJoinResource($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Resource relation
at line 64
ChildProfileResourceQuery
rightJoinResource($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Resource relation
at line 64
ChildProfileResourceQuery
innerJoinResource($relationAlias = null)
Adds a INNER JOIN clause to the query using the Resource relation
at line 64
ChildProfileResource
findOne(
ConnectionInterface $con = null)
Return the first ChildProfileResource matching the query
at line 64
ChildProfileResource
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildProfileResource matching the query, or a new ChildProfileResource object populated from the query conditions when no match is found
at line 64
ChildProfileResource
findOneByProfileId(
int $profile_id)
Return the first ChildProfileResource filtered by the profile_id column
at line 64
ChildProfileResource
findOneByResourceId(
int $resource_id)
Return the first ChildProfileResource filtered by the resource_id column
at line 64
ChildProfileResource
findOneByAccess(
int $access)
Return the first ChildProfileResource filtered by the access column
at line 64
ChildProfileResource
findOneByCreatedAt(
string $created_at)
Return the first ChildProfileResource filtered by the created_at column
at line 64
ChildProfileResource
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProfileResource filtered by the updated_at column
at line 64
array
findByProfileId(
int $profile_id)
Return ChildProfileResource objects filtered by the profile_id column
at line 64
array
findByResourceId(
int $resource_id)
Return ChildProfileResource objects filtered by the resource_id column
at line 64
array
findByAccess(
int $access)
Return ChildProfileResource objects filtered by the access column
at line 64
array
findByCreatedAt(
string $created_at)
Return ChildProfileResource objects filtered by the created_at column
at line 64
array
findByUpdatedAt(
string $updated_at)
Return ChildProfileResource objects filtered by the updated_at column