ProfileModuleQuery
class ProfileModuleQuery extends ProfileModuleQuery
Skeleton subclass for performing query and update operations on the 'profile_module' 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\ProfileModuleQuery object.
Returns a new ChildProfileModuleQuery 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 module_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\Module object
Adds a JOIN clause to the query using the Module relation
Use the Module relation Module object
Deletes all rows from the profile_module table.
Performs a DELETE on the database, given a ChildProfileModule or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
Order by the profile_id column
Order by the module_id column
Order by the access column
Order by the created_at column
Order 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 Module relation
Adds a RIGHT JOIN clause to the query using the Module relation
Adds a INNER JOIN clause to the query using the Module relation
Return the first ChildProfileModule matching the query
Return the first ChildProfileModule matching the query, or a new ChildProfileModule object populated from the query conditions when no match is found
Return the first ChildProfileModule filtered by the profile_id column
Return the first ChildProfileModule filtered by the module_id column
Return the first ChildProfileModule filtered by the access column
Return the first ChildProfileModule filtered by the created_at column
Return the first ChildProfileModule filtered by the updated_at column
Return ChildProfileModule objects filtered by the profile_id column
Return ChildProfileModule objects filtered by the module_id column
Return ChildProfileModule objects filtered by the access column
Return ChildProfileModule objects filtered by the created_at column
Return ChildProfileModule objects filtered by the updated_at column
Details
in
ProfileModuleQuery at line 74
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\ProfileModule',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\ProfileModuleQuery object.
in
ProfileModuleQuery at line 87
static
ProfileModuleQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildProfileModuleQuery object.
in
ProfileModuleQuery at line 117
ProfileModule|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);
in
ProfileModuleQuery 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);
in
ProfileModuleQuery at line 221
ProfileModuleQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
ProfileModuleQuery at line 236
ProfileModuleQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
ProfileModuleQuery at line 271
ProfileModuleQuery
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
in
ProfileModuleQuery at line 314
ProfileModuleQuery
filterByModuleId(
mixed $moduleId = null,
string $comparison = null)
Filter the query on the module_id column
Example usage:
$query->filterByModuleId(1234); // WHERE moduleid = 1234
$query->filterByModuleId(array(12, 34)); // WHERE moduleid IN (12, 34)
$query->filterByModuleId(array('min' => 12)); // WHERE module_id > 12
in
ProfileModuleQuery at line 355
ProfileModuleQuery
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
in
ProfileModuleQuery at line 398
ProfileModuleQuery
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
ProfileModuleQuery at line 441
ProfileModuleQuery
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
ProfileModuleQuery at line 472
ProfileModuleQuery
filterByProfile(
Profile|ObjectCollection $profile,
string $comparison = null)
Filter the query by a related \Thelia\Model\Profile object
in
ProfileModuleQuery at line 497
ProfileModuleQuery
joinProfile(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Profile relation
in
ProfileModuleQuery at line 532
ProfileQuery
useProfileQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Profile relation Profile object
in
ProfileModuleQuery at line 547
ProfileModuleQuery
filterByModule(
Module|ObjectCollection $module,
string $comparison = null)
Filter the query by a related \Thelia\Model\Module object
in
ProfileModuleQuery at line 572
ProfileModuleQuery
joinModule(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the Module relation
in
ProfileModuleQuery at line 607
ModuleQuery
useModuleQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the Module relation Module object
in
ProfileModuleQuery at line 621
ProfileModuleQuery
prune(
ProfileModule $profileModule = null)
Exclude object from result
in
ProfileModuleQuery at line 638
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the profile_module table.
in
ProfileModuleQuery at line 675
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildProfileModule or Criteria object OR a primary key value.
in
ProfileModuleQuery at line 716
ProfileModuleQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
ProfileModuleQuery at line 728
ProfileModuleQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
ProfileModuleQuery at line 738
ProfileModuleQuery
lastUpdatedFirst()
Order by update date desc
in
ProfileModuleQuery at line 748
ProfileModuleQuery
firstUpdatedFirst()
Order by update date asc
in
ProfileModuleQuery at line 758
ProfileModuleQuery
lastCreatedFirst()
Order by create date desc
in
ProfileModuleQuery at line 768
ProfileModuleQuery
firstCreatedFirst()
Order by create date asc
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
orderByProfileId($order = Criteria::ASC)
Order by the profile_id column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
orderByModuleId($order = Criteria::ASC)
Order by the module_id column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
orderByAccess($order = Criteria::ASC)
Order by the access column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
groupByProfileId()
Group by the profile_id column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
groupByModuleId()
Group by the module_id column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
groupByAccess()
Group by the access column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
groupByCreatedAt()
Group by the created_at column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
groupByUpdatedAt()
Group by the updated_at column
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
leftJoinProfile($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Profile relation
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
rightJoinProfile($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Profile relation
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
innerJoinProfile($relationAlias = null)
Adds a INNER JOIN clause to the query using the Profile relation
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
leftJoinModule($relationAlias = null)
Adds a LEFT JOIN clause to the query using the Module relation
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
rightJoinModule($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the Module relation
in
ProfileModuleQuery at line 64
ChildProfileModuleQuery
innerJoinModule($relationAlias = null)
Adds a INNER JOIN clause to the query using the Module relation
in
ProfileModuleQuery at line 64
ChildProfileModule
findOne(
ConnectionInterface $con = null)
Return the first ChildProfileModule matching the query
in
ProfileModuleQuery at line 64
ChildProfileModule
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildProfileModule matching the query, or a new ChildProfileModule object populated from the query conditions when no match is found
in
ProfileModuleQuery at line 64
ChildProfileModule
findOneByProfileId(
int $profile_id)
Return the first ChildProfileModule filtered by the profile_id column
in
ProfileModuleQuery at line 64
ChildProfileModule
findOneByModuleId(
int $module_id)
Return the first ChildProfileModule filtered by the module_id column
in
ProfileModuleQuery at line 64
ChildProfileModule
findOneByAccess(
int $access)
Return the first ChildProfileModule filtered by the access column
in
ProfileModuleQuery at line 64
ChildProfileModule
findOneByCreatedAt(
string $created_at)
Return the first ChildProfileModule filtered by the created_at column
in
ProfileModuleQuery at line 64
ChildProfileModule
findOneByUpdatedAt(
string $updated_at)
Return the first ChildProfileModule filtered by the updated_at column
in
ProfileModuleQuery at line 64
array
findByProfileId(
int $profile_id)
Return ChildProfileModule objects filtered by the profile_id column
in
ProfileModuleQuery at line 64
array
findByModuleId(
int $module_id)
Return ChildProfileModule objects filtered by the module_id column
in
ProfileModuleQuery at line 64
array
findByAccess(
int $access)
Return ChildProfileModule objects filtered by the access column
in
ProfileModuleQuery at line 64
array
findByCreatedAt(
string $created_at)
Return ChildProfileModule objects filtered by the created_at column
in
ProfileModuleQuery at line 64
array
findByUpdatedAt(
string $updated_at)
Return ChildProfileModule objects filtered by the updated_at column