![]() |
rapila
|
Public Member Functions | |
__construct ($dbName=null, $modelName=null, $modelAlias=null) | |
findPk ($key, $con=null) | |
findOneById ($key, $con=null) | |
findPks ($keys, $con=null) | |
filterByPrimaryKey ($key) | |
filterByPrimaryKeys ($keys) | |
filterById ($id=null, $comparison=null) | |
filterByRoleKey ($roleKey=null, $comparison=null) | |
filterByPageId ($pageId=null, $comparison=null) | |
filterByIsInherited ($isInherited=null, $comparison=null) | |
filterByMayEditPageDetails ($mayEditPageDetails=null, $comparison=null) | |
filterByMayEditPageContents ($mayEditPageContents=null, $comparison=null) | |
filterByMayDelete ($mayDelete=null, $comparison=null) | |
filterByMayCreateChildren ($mayCreateChildren=null, $comparison=null) | |
filterByMayViewPage ($mayViewPage=null, $comparison=null) | |
filterByCreatedAt ($createdAt=null, $comparison=null) | |
filterByUpdatedAt ($updatedAt=null, $comparison=null) | |
filterByCreatedBy ($createdBy=null, $comparison=null) | |
filterByUpdatedBy ($updatedBy=null, $comparison=null) | |
filterByRole ($role, $comparison=null) | |
joinRole ($relationAlias=null, $joinType=Criteria::INNER_JOIN) | |
useRoleQuery ($relationAlias=null, $joinType=Criteria::INNER_JOIN) | |
filterByPage ($page, $comparison=null) | |
joinPage ($relationAlias=null, $joinType=Criteria::INNER_JOIN) | |
usePageQuery ($relationAlias=null, $joinType=Criteria::INNER_JOIN) | |
filterByUserRelatedByCreatedBy ($user, $comparison=null) | |
joinUserRelatedByCreatedBy ($relationAlias=null, $joinType=Criteria::LEFT_JOIN) | |
useUserRelatedByCreatedByQuery ($relationAlias=null, $joinType=Criteria::LEFT_JOIN) | |
filterByUserRelatedByUpdatedBy ($user, $comparison=null) | |
joinUserRelatedByUpdatedBy ($relationAlias=null, $joinType=Criteria::LEFT_JOIN) | |
useUserRelatedByUpdatedByQuery ($relationAlias=null, $joinType=Criteria::LEFT_JOIN) | |
prune ($right=null) | |
recentlyUpdated ($nbDays=7) | |
lastUpdatedFirst () | |
firstUpdatedFirst () | |
recentlyCreated ($nbDays=7) | |
lastCreatedFirst () | |
firstCreatedFirst () | |
findMostRecentUpdate ($bAsTimestamp=false) | |
filterByPKArray ($pkArray) | |
filterByPKString ($pkString) | |
Static Public Member Functions | |
static | create ($modelAlias=null, $criteria=null) |
Protected Member Functions | |
findPkSimple ($key, $con) | |
findPkComplex ($key, $con) | |
BaseRightQuery::__construct | ( | $dbName = null , |
|
$modelName = null , |
|||
$modelAlias = null |
|||
) |
Initializes internal state of BaseRightQuery object.
string | $dbName | The dabase name |
string | $modelName | The phpName of a model, e.g. 'Book' |
string | $modelAlias | The alias for the model in this query, e.g. 'b' |
|
static |
Returns a new RightQuery object.
string | $modelAlias | The alias of a model in the query |
RightQuery | Criteria | $criteria | Optional Criteria to build the query from |
BaseRightQuery::filterByCreatedAt | ( | $createdAt = null , |
|
$comparison = null |
|||
) |
Filter the query on the created_at column
Example usage: $query->filterByCreatedAt('2011-03-14'); // WHERE created_at = '2011-03-14' $query->filterByCreatedAt('now'); // WHERE created_at = '2011-03-14' $query->filterByCreatedAt(array('max' => 'yesterday')); // WHERE created_at < '2011-03-13'
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 |
BaseRightQuery::filterByCreatedBy | ( | $createdBy = null , |
|
$comparison = null |
|||
) |
Filter the query on the created_by column
Example usage: $query->filterByCreatedBy(1234); // WHERE created_by = 1234 $query->filterByCreatedBy(array(12, 34)); // WHERE created_by IN (12, 34) $query->filterByCreatedBy(array('min' => 12)); // WHERE created_by >= 12 $query->filterByCreatedBy(array('max' => 12)); // WHERE created_by <= 12
mixed | $createdBy | 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 |
BaseRightQuery::filterById | ( | $id = null , |
|
$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 $query->filterById(array('max' => 12)); // WHERE id <= 12
mixed | $id | 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 |
BaseRightQuery::filterByIsInherited | ( | $isInherited = null , |
|
$comparison = null |
|||
) |
Filter the query on the is_inherited column
Example usage: $query->filterByIsInherited(true); // WHERE is_inherited = true $query->filterByIsInherited('yes'); // WHERE is_inherited = true
boolean | string | $isInherited | The value to use as filter. Non-boolean arguments are converted using the following rules:
|
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
BaseRightQuery::filterByMayCreateChildren | ( | $mayCreateChildren = null , |
|
$comparison = null |
|||
) |
Filter the query on the may_create_children column
Example usage: $query->filterByMayCreateChildren(true); // WHERE may_create_children = true $query->filterByMayCreateChildren('yes'); // WHERE may_create_children = true
boolean | string | $mayCreateChildren | The value to use as filter. Non-boolean arguments are converted using the following rules:
|
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
BaseRightQuery::filterByMayDelete | ( | $mayDelete = null , |
|
$comparison = null |
|||
) |
Filter the query on the may_delete column
Example usage: $query->filterByMayDelete(true); // WHERE may_delete = true $query->filterByMayDelete('yes'); // WHERE may_delete = true
boolean | string | $mayDelete | The value to use as filter. Non-boolean arguments are converted using the following rules:
|
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
BaseRightQuery::filterByMayEditPageContents | ( | $mayEditPageContents = null , |
|
$comparison = null |
|||
) |
Filter the query on the may_edit_page_contents column
Example usage: $query->filterByMayEditPageContents(true); // WHERE may_edit_page_contents = true $query->filterByMayEditPageContents('yes'); // WHERE may_edit_page_contents = true
boolean | string | $mayEditPageContents | The value to use as filter. Non-boolean arguments are converted using the following rules:
|
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
BaseRightQuery::filterByMayEditPageDetails | ( | $mayEditPageDetails = null , |
|
$comparison = null |
|||
) |
Filter the query on the may_edit_page_details column
Example usage: $query->filterByMayEditPageDetails(true); // WHERE may_edit_page_details = true $query->filterByMayEditPageDetails('yes'); // WHERE may_edit_page_details = true
boolean | string | $mayEditPageDetails | The value to use as filter. Non-boolean arguments are converted using the following rules:
|
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
BaseRightQuery::filterByMayViewPage | ( | $mayViewPage = null , |
|
$comparison = null |
|||
) |
Filter the query on the may_view_page column
Example usage: $query->filterByMayViewPage(true); // WHERE may_view_page = true $query->filterByMayViewPage('yes'); // WHERE may_view_page = true
boolean | string | $mayViewPage | The value to use as filter. Non-boolean arguments are converted using the following rules:
|
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
BaseRightQuery::filterByPage | ( | $page, | |
$comparison = null |
|||
) |
Filter the query by a related Page object
Page | PropelObjectCollection | $page | The related object(s) to use as filter |
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
PropelException | - if the provided filter is invalid. |
BaseRightQuery::filterByPageId | ( | $pageId = null , |
|
$comparison = null |
|||
) |
Filter the query on the page_id column
Example usage: $query->filterByPageId(1234); // WHERE page_id = 1234 $query->filterByPageId(array(12, 34)); // WHERE page_id IN (12, 34) $query->filterByPageId(array('min' => 12)); // WHERE page_id >= 12 $query->filterByPageId(array('max' => 12)); // WHERE page_id <= 12
mixed | $pageId | 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 |
BaseRightQuery::filterByPrimaryKey | ( | $key | ) |
Filter the query by primary key
mixed | $key | Primary key to use for the query |
BaseRightQuery::filterByPrimaryKeys | ( | $keys | ) |
Filter the query by a list of primary keys
array | $keys | The list of primary key to use for the query |
BaseRightQuery::filterByRole | ( | $role, | |
$comparison = null |
|||
) |
Filter the query by a related Role object
Role | PropelObjectCollection | $role | The related object(s) to use as filter |
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
PropelException | - if the provided filter is invalid. |
BaseRightQuery::filterByRoleKey | ( | $roleKey = null , |
|
$comparison = null |
|||
) |
Filter the query on the role_key column
Example usage: $query->filterByRoleKey('fooValue'); // WHERE role_key = 'fooValue' $query->filterByRoleKey('fooValue'); // WHERE role_key LIKE 'fooValue'
string | $roleKey | The value to use as filter. Accepts wildcards (* and % trigger a LIKE) |
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
BaseRightQuery::filterByUpdatedAt | ( | $updatedAt = null , |
|
$comparison = null |
|||
) |
Filter the query on the updated_at column
Example usage: $query->filterByUpdatedAt('2011-03-14'); // WHERE updated_at = '2011-03-14' $query->filterByUpdatedAt('now'); // WHERE updated_at = '2011-03-14' $query->filterByUpdatedAt(array('max' => 'yesterday')); // WHERE updated_at < '2011-03-13'
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 |
BaseRightQuery::filterByUpdatedBy | ( | $updatedBy = null , |
|
$comparison = null |
|||
) |
Filter the query on the updated_by column
Example usage: $query->filterByUpdatedBy(1234); // WHERE updated_by = 1234 $query->filterByUpdatedBy(array(12, 34)); // WHERE updated_by IN (12, 34) $query->filterByUpdatedBy(array('min' => 12)); // WHERE updated_by >= 12 $query->filterByUpdatedBy(array('max' => 12)); // WHERE updated_by <= 12
mixed | $updatedBy | 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 |
BaseRightQuery::filterByUserRelatedByCreatedBy | ( | $user, | |
$comparison = null |
|||
) |
Filter the query by a related User object
User | PropelObjectCollection | $user | The related object(s) to use as filter |
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
PropelException | - if the provided filter is invalid. |
BaseRightQuery::filterByUserRelatedByUpdatedBy | ( | $user, | |
$comparison = null |
|||
) |
Filter the query by a related User object
User | PropelObjectCollection | $user | The related object(s) to use as filter |
string | $comparison | Operator to use for the column comparison, defaults to Criteria::EQUAL |
PropelException | - if the provided filter is invalid. |
BaseRightQuery::findOneById | ( | $key, | |
$con = null |
|||
) |
Alias of findPk to use instance pooling
mixed | $key | Primary key to use for the query |
PropelPDO | $con | A connection object |
PropelException |
BaseRightQuery::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(12, $con);
mixed | $key | Primary key to use for the query |
PropelPDO | $con | an optional connection object |
|
protected |
Find object by primary key.
mixed | $key | Primary key to use for the query |
PropelPDO | $con | A connection object |
BaseRightQuery::findPks | ( | $keys, | |
$con = null |
|||
) |
Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);
array | $keys | Primary keys to use for the query |
PropelPDO | $con | an optional connection object |
|
protected |
Find object by primary key using raw SQL to go fast. Bypass doSelect() and the object formatter by using generated code.
mixed | $key | Primary key to use for the query |
PropelPDO | $con | A connection object |
PropelException |
BaseRightQuery::firstCreatedFirst | ( | ) |
Order by create date asc
BaseRightQuery::firstUpdatedFirst | ( | ) |
Order by update date asc
BaseRightQuery::joinPage | ( | $relationAlias = null , |
|
$joinType = Criteria::INNER_JOIN |
|||
) |
Adds a JOIN clause to the query using the Page relation
string | $relationAlias | optional alias for the relation |
string | $joinType | Accepted values are null, 'left join', 'right join', 'inner join' |
BaseRightQuery::joinRole | ( | $relationAlias = null , |
|
$joinType = Criteria::INNER_JOIN |
|||
) |
Adds a JOIN clause to the query using the Role relation
string | $relationAlias | optional alias for the relation |
string | $joinType | Accepted values are null, 'left join', 'right join', 'inner join' |
BaseRightQuery::joinUserRelatedByCreatedBy | ( | $relationAlias = null , |
|
$joinType = Criteria::LEFT_JOIN |
|||
) |
Adds a JOIN clause to the query using the UserRelatedByCreatedBy relation
string | $relationAlias | optional alias for the relation |
string | $joinType | Accepted values are null, 'left join', 'right join', 'inner join' |
BaseRightQuery::joinUserRelatedByUpdatedBy | ( | $relationAlias = null , |
|
$joinType = Criteria::LEFT_JOIN |
|||
) |
Adds a JOIN clause to the query using the UserRelatedByUpdatedBy relation
string | $relationAlias | optional alias for the relation |
string | $joinType | Accepted values are null, 'left join', 'right join', 'inner join' |
BaseRightQuery::lastCreatedFirst | ( | ) |
Order by create date desc
BaseRightQuery::lastUpdatedFirst | ( | ) |
Order by update date desc
BaseRightQuery::prune | ( | $right = null | ) |
Exclude object from result
Right | $right | Object to remove from the list of results |
BaseRightQuery::recentlyCreated | ( | $nbDays = 7 | ) |
Filter by the latest created
int | $nbDays | Maximum age of in days |
BaseRightQuery::recentlyUpdated | ( | $nbDays = 7 | ) |
Filter by the latest updated
int | $nbDays | Maximum age of the latest update in days |
BaseRightQuery::usePageQuery | ( | $relationAlias = null , |
|
$joinType = Criteria::INNER_JOIN |
|||
) |
Use the Page relation Page object
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' |
BaseRightQuery::useRoleQuery | ( | $relationAlias = null , |
|
$joinType = Criteria::INNER_JOIN |
|||
) |
Use the Role relation Role object
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' |
BaseRightQuery::useUserRelatedByCreatedByQuery | ( | $relationAlias = null , |
|
$joinType = Criteria::LEFT_JOIN |
|||
) |
Use the UserRelatedByCreatedBy relation User object
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' |
BaseRightQuery::useUserRelatedByUpdatedByQuery | ( | $relationAlias = null , |
|
$joinType = Criteria::LEFT_JOIN |
|||
) |
Use the UserRelatedByUpdatedBy relation User object
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' |