class ProfileModuleQuery extends ModelCriteria

Base class that represents a query for the 'profile_module' table.

Methods

__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\ProfileModule', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\ProfileModuleQuery object.

create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildProfileModuleQuery object.

ProfileModule|array|mixed
findPk($key, $con = null)

Find object by primary key.

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);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterByProfileId( mixed $profileId = null, string $comparison = null)

Filter the query on the profile_id column

filterByModuleId( mixed $moduleId = null, string $comparison = null)

Filter the query on the module_id column

filterByAccess( mixed $access = null, string $comparison = null)

Filter the query on the access column

filterByCreatedAt( mixed $createdAt = null, string $comparison = null)

Filter the query on the created_at column

filterByUpdatedAt( mixed $updatedAt = null, string $comparison = null)

Filter the query on the updated_at column

filterByProfile( Profile|ObjectCollection $profile, string $comparison = null)

Filter the query by a related \Thelia\Model\Profile object

joinProfile( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Profile relation

useProfileQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Profile relation Profile object

filterByModule( Module|ObjectCollection $module, string $comparison = null)

Filter the query by a related \Thelia\Model\Module object

joinModule( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Module relation

useModuleQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Module relation Module object

prune( ProfileModule $profileModule = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the profile_module table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildProfileModule or Criteria object OR a primary key value.

recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

recentlyCreated( int $nbDays = 7)

Filter by the latest created

lastUpdatedFirst()

Order by update date desc

firstUpdatedFirst()

Order by update date asc

lastCreatedFirst()

Order by create date desc

firstCreatedFirst()

Order by create date asc

ChildProfileModuleQuery
orderByProfileId($order = Criteria::ASC)

Order by the profile_id column

ChildProfileModuleQuery
orderByModuleId($order = Criteria::ASC)

Order by the module_id column

ChildProfileModuleQuery
orderByAccess($order = Criteria::ASC)

Order by the access column

ChildProfileModuleQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildProfileModuleQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildProfileModuleQuery
groupByProfileId()

Group by the profile_id column

ChildProfileModuleQuery
groupByModuleId()

Group by the module_id column

ChildProfileModuleQuery
groupByAccess()

Group by the access column

ChildProfileModuleQuery
groupByCreatedAt()

Group by the created_at column

ChildProfileModuleQuery
groupByUpdatedAt()

Group by the updated_at column

ChildProfileModuleQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildProfileModuleQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildProfileModuleQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildProfileModuleQuery
leftJoinProfile($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Profile relation

ChildProfileModuleQuery
rightJoinProfile($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Profile relation

ChildProfileModuleQuery
innerJoinProfile($relationAlias = null)

Adds a INNER JOIN clause to the query using the Profile relation

ChildProfileModuleQuery
leftJoinModule($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Module relation

ChildProfileModuleQuery
rightJoinModule($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Module relation

ChildProfileModuleQuery
innerJoinModule($relationAlias = null)

Adds a INNER JOIN clause to the query using the Module relation

ChildProfileModule
findOne( ConnectionInterface $con = null)

Return the first ChildProfileModule matching the query

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

ChildProfileModule
findOneByProfileId( int $profile_id)

Return the first ChildProfileModule filtered by the profile_id column

ChildProfileModule
findOneByModuleId( int $module_id)

Return the first ChildProfileModule filtered by the module_id column

ChildProfileModule
findOneByAccess( int $access)

Return the first ChildProfileModule filtered by the access column

ChildProfileModule
findOneByCreatedAt( string $created_at)

Return the first ChildProfileModule filtered by the created_at column

ChildProfileModule
findOneByUpdatedAt( string $updated_at)

Return the first ChildProfileModule filtered by the updated_at column

array
findByProfileId( int $profile_id)

Return ChildProfileModule objects filtered by the profile_id column

array
findByModuleId( int $module_id)

Return ChildProfileModule objects filtered by the module_id column

array
findByAccess( int $access)

Return ChildProfileModule objects filtered by the access column

array
findByCreatedAt( string $created_at)

Return ChildProfileModule objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildProfileModule objects filtered by the updated_at column

Details

at line 74
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\ProfileModule', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\ProfileModuleQuery object.

Parameters

string $dbName The database name
string $modelName The phpName of a model, e.g. 'Book'
string $modelAlias The alias for the model in this query, e.g. 'b'

at line 87
static ProfileModuleQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildProfileModuleQuery object.

Parameters

string $modelAlias The alias of a model in the query
Criteria $criteria Optional Criteria to build the query from

Return Value

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);

Parameters

$key
$con

Return Value

ProfileModule|array|mixed the result, formatted by the current formatter

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);

Parameters

array $keys Primary keys to use for the query
ConnectionInterface $con an optional connection object

Return Value

ObjectCollection|array|mixed the list of results, formatted by the current formatter

at line 221
ProfileModuleQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 236
ProfileModuleQuery filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

Parameters

array $keys The list of primary key to use for the query

Return Value

ProfileModuleQuery The current query, for fluid interface

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

Parameters

mixed $profileId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProfileModuleQuery The current query, for fluid interface

See also

filterByProfile()

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

Parameters

mixed $moduleId The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProfileModuleQuery The current query, for fluid interface

See also

filterByModule()

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

Parameters

mixed $access The value to use as filter. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProfileModuleQuery The current query, for fluid interface

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'

Parameters

mixed $createdAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProfileModuleQuery The current query, for fluid interface

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'

Parameters

mixed $updatedAt The value to use as filter. Values can be integers (unix timestamps), DateTime objects, or strings. Empty strings are treated as NULL. Use scalar values for equality. Use array values for in_array() equivalent. Use associative array('min' => $minValue, 'max' => $maxValue) for intervals.
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 472
ProfileModuleQuery filterByProfile( Profile|ObjectCollection $profile, string $comparison = null)

Filter the query by a related \Thelia\Model\Profile object

Parameters

Profile|ObjectCollection $profile The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 497
ProfileModuleQuery joinProfile( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Profile relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 532
ProfileQuery useProfileQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Profile relation Profile object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProfileQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 547
ProfileModuleQuery filterByModule( Module|ObjectCollection $module, string $comparison = null)

Filter the query by a related \Thelia\Model\Module object

Parameters

Module|ObjectCollection $module The related object(s) to use as filter
string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 572
ProfileModuleQuery joinModule( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Adds a JOIN clause to the query using the Module relation

Parameters

string $relationAlias optional alias for the relation
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 607
ModuleQuery useModuleQuery( string $relationAlias = null, string $joinType = Criteria::INNER_JOIN)

Use the Module relation Module object

Parameters

string $relationAlias optional alias for the relation, to be used as main alias in the secondary query
string $joinType Accepted values are null, 'left join', 'right join', 'inner join'

Return Value

ModuleQuery A secondary query class using the current class as primary query

See also

useQuery()

at line 621
ProfileModuleQuery prune( ProfileModule $profileModule = null)

Exclude object from result

Parameters

ProfileModule $profileModule Object to remove from the list of results

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 638
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the profile_module table.

Parameters

ConnectionInterface $con the connection to use

Return Value

int The number of affected rows (if supported by underlying database driver).

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.

Parameters

ConnectionInterface $con

Return Value

int The number of affected rows (if supported by underlying database driver). This includes CASCADE-related rows if supported by native driver or if emulated using Propel.

Exceptions

PropelException Any exceptions caught during processing will be rethrown wrapped into a PropelException.

at line 716
ProfileModuleQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 728
ProfileModuleQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 738
ProfileModuleQuery lastUpdatedFirst()

Order by update date desc

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 748
ProfileModuleQuery firstUpdatedFirst()

Order by update date asc

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 758
ProfileModuleQuery lastCreatedFirst()

Order by create date desc

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 768
ProfileModuleQuery firstCreatedFirst()

Order by create date asc

Return Value

ProfileModuleQuery The current query, for fluid interface

at line 64
ChildProfileModuleQuery orderByProfileId($order = Criteria::ASC)

Order by the profile_id column

Parameters

$order

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery orderByModuleId($order = Criteria::ASC)

Order by the module_id column

Parameters

$order

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery orderByAccess($order = Criteria::ASC)

Order by the access column

Parameters

$order

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery groupByProfileId()

Group by the profile_id column

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery groupByModuleId()

Group by the module_id column

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery groupByAccess()

Group by the access column

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery leftJoinProfile($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Profile relation

Parameters

$relationAlias

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery rightJoinProfile($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Profile relation

Parameters

$relationAlias

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery innerJoinProfile($relationAlias = null)

Adds a INNER JOIN clause to the query using the Profile relation

Parameters

$relationAlias

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery leftJoinModule($relationAlias = null)

Adds a LEFT JOIN clause to the query using the Module relation

Parameters

$relationAlias

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery rightJoinModule($relationAlias = null)

Adds a RIGHT JOIN clause to the query using the Module relation

Parameters

$relationAlias

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModuleQuery innerJoinModule($relationAlias = null)

Adds a INNER JOIN clause to the query using the Module relation

Parameters

$relationAlias

Return Value

ChildProfileModuleQuery

at line 64
ChildProfileModule findOne( ConnectionInterface $con = null)

Return the first ChildProfileModule matching the query

Parameters

ConnectionInterface $con

Return Value

ChildProfileModule

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

Parameters

ConnectionInterface $con

Return Value

ChildProfileModule

at line 64
ChildProfileModule findOneByProfileId( int $profile_id)

Return the first ChildProfileModule filtered by the profile_id column

Parameters

int $profile_id

Return Value

ChildProfileModule

at line 64
ChildProfileModule findOneByModuleId( int $module_id)

Return the first ChildProfileModule filtered by the module_id column

Parameters

int $module_id

Return Value

ChildProfileModule

at line 64
ChildProfileModule findOneByAccess( int $access)

Return the first ChildProfileModule filtered by the access column

Parameters

int $access

Return Value

ChildProfileModule

at line 64
ChildProfileModule findOneByCreatedAt( string $created_at)

Return the first ChildProfileModule filtered by the created_at column

Parameters

string $created_at

Return Value

ChildProfileModule

at line 64
ChildProfileModule findOneByUpdatedAt( string $updated_at)

Return the first ChildProfileModule filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildProfileModule

at line 64
array findByProfileId( int $profile_id)

Return ChildProfileModule objects filtered by the profile_id column

Parameters

int $profile_id

Return Value

array

at line 64
array findByModuleId( int $module_id)

Return ChildProfileModule objects filtered by the module_id column

Parameters

int $module_id

Return Value

array

at line 64
array findByAccess( int $access)

Return ChildProfileModule objects filtered by the access column

Parameters

int $access

Return Value

array

at line 64
array findByCreatedAt( string $created_at)

Return ChildProfileModule objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

at line 64
array findByUpdatedAt( string $updated_at)

Return ChildProfileModule objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array