rapila
Public Member Functions | Static Public Member Functions | Protected Member Functions | List of all members
BaseLinkQuery Class Reference
Inheritance diagram for BaseLinkQuery:
LinkQuery

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)
 
 filterByName ($name=null, $comparison=null)
 
 filterByUrl ($url=null, $comparison=null)
 
 filterByDescription ($description=null, $comparison=null)
 
 filterByLanguageId ($languageId=null, $comparison=null)
 
 filterByOwnerId ($ownerId=null, $comparison=null)
 
 filterByLinkCategoryId ($linkCategoryId=null, $comparison=null)
 
 filterBySort ($sort=null, $comparison=null)
 
 filterByIsPrivate ($isPrivate=null, $comparison=null)
 
 filterByCreatedAt ($createdAt=null, $comparison=null)
 
 filterByUpdatedAt ($updatedAt=null, $comparison=null)
 
 filterByCreatedBy ($createdBy=null, $comparison=null)
 
 filterByUpdatedBy ($updatedBy=null, $comparison=null)
 
 filterByLanguage ($language, $comparison=null)
 
 joinLanguage ($relationAlias=null, $joinType=Criteria::LEFT_JOIN)
 
 useLanguageQuery ($relationAlias=null, $joinType=Criteria::LEFT_JOIN)
 
 filterByUserRelatedByOwnerId ($user, $comparison=null)
 
 joinUserRelatedByOwnerId ($relationAlias=null, $joinType=Criteria::INNER_JOIN)
 
 useUserRelatedByOwnerIdQuery ($relationAlias=null, $joinType=Criteria::INNER_JOIN)
 
 filterByLinkCategory ($linkCategory, $comparison=null)
 
 joinLinkCategory ($relationAlias=null, $joinType=Criteria::LEFT_JOIN)
 
 useLinkCategoryQuery ($relationAlias=null, $joinType=Criteria::LEFT_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 ($link=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)
 

Constructor & Destructor Documentation

BaseLinkQuery::__construct (   $dbName = null,
  $modelName = null,
  $modelAlias = null 
)

Initializes internal state of BaseLinkQuery object.

Parameters
string$dbNameThe dabase name
string$modelNameThe phpName of a model, e.g. 'Book'
string$modelAliasThe alias for the model in this query, e.g. 'b'

Member Function Documentation

static BaseLinkQuery::create (   $modelAlias = null,
  $criteria = null 
)
static

Returns a new LinkQuery object.

Parameters
string$modelAliasThe alias of a model in the query
LinkQuery | Criteria$criteriaOptional Criteria to build the query from
Returns
LinkQuery
BaseLinkQuery::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'

Parameters
mixed$createdAtThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::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

See also
filterByUserRelatedByCreatedBy()
Parameters
mixed$createdByThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByDescription (   $description = null,
  $comparison = null 
)

Filter the query on the description column

Example usage: $query->filterByDescription('fooValue'); // WHERE description = 'fooValue' $query->filterByDescription('fooValue'); // WHERE description LIKE 'fooValue'

Parameters
string$descriptionThe value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::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

Parameters
mixed$idThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByIsPrivate (   $isPrivate = null,
  $comparison = null 
)

Filter the query on the is_private column

Example usage: $query->filterByIsPrivate(true); // WHERE is_private = true $query->filterByIsPrivate('yes'); // WHERE is_private = true

Parameters
boolean | string$isPrivateThe value to use as filter. Non-boolean arguments are converted using the following rules:
  • 1, '1', 'true', 'on', and 'yes' are converted to boolean true
  • 0, '0', 'false', 'off', and 'no' are converted to boolean false Check on string values is case insensitive (so 'FaLsE' is seen as 'false').
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByLanguage (   $language,
  $comparison = null 
)

Filter the query by a related Language object

Parameters
Language | PropelObjectCollection$languageThe related object(s) to use as filter
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
Exceptions
PropelException- if the provided filter is invalid.
BaseLinkQuery::filterByLanguageId (   $languageId = null,
  $comparison = null 
)

Filter the query on the language_id column

Example usage: $query->filterByLanguageId('fooValue'); // WHERE language_id = 'fooValue' $query->filterByLanguageId('fooValue'); // WHERE language_id LIKE 'fooValue'

Parameters
string$languageIdThe value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByLinkCategory (   $linkCategory,
  $comparison = null 
)

Filter the query by a related LinkCategory object

Parameters
LinkCategory | PropelObjectCollection$linkCategoryThe related object(s) to use as filter
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
Exceptions
PropelException- if the provided filter is invalid.
BaseLinkQuery::filterByLinkCategoryId (   $linkCategoryId = null,
  $comparison = null 
)

Filter the query on the link_category_id column

Example usage: $query->filterByLinkCategoryId(1234); // WHERE link_category_id = 1234 $query->filterByLinkCategoryId(array(12, 34)); // WHERE link_category_id IN (12, 34) $query->filterByLinkCategoryId(array('min' => 12)); // WHERE link_category_id >= 12 $query->filterByLinkCategoryId(array('max' => 12)); // WHERE link_category_id <= 12

See also
filterByLinkCategory()
Parameters
mixed$linkCategoryIdThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByName (   $name = null,
  $comparison = null 
)

Filter the query on the name column

Example usage: $query->filterByName('fooValue'); // WHERE name = 'fooValue' $query->filterByName('fooValue'); // WHERE name LIKE 'fooValue'

Parameters
string$nameThe value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByOwnerId (   $ownerId = null,
  $comparison = null 
)

Filter the query on the owner_id column

Example usage: $query->filterByOwnerId(1234); // WHERE owner_id = 1234 $query->filterByOwnerId(array(12, 34)); // WHERE owner_id IN (12, 34) $query->filterByOwnerId(array('min' => 12)); // WHERE owner_id >= 12 $query->filterByOwnerId(array('max' => 12)); // WHERE owner_id <= 12

See also
filterByUserRelatedByOwnerId()
Parameters
mixed$ownerIdThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByPrimaryKey (   $key)

Filter the query by primary key

Parameters
mixed$keyPrimary key to use for the query
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByPrimaryKeys (   $keys)

Filter the query by a list of primary keys

Parameters
array$keysThe list of primary key to use for the query
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterBySort (   $sort = null,
  $comparison = null 
)

Filter the query on the sort column

Example usage: $query->filterBySort(1234); // WHERE sort = 1234 $query->filterBySort(array(12, 34)); // WHERE sort IN (12, 34) $query->filterBySort(array('min' => 12)); // WHERE sort >= 12 $query->filterBySort(array('max' => 12)); // WHERE sort <= 12

Parameters
mixed$sortThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::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'

Parameters
mixed$updatedAtThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::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

See also
filterByUserRelatedByUpdatedBy()
Parameters
mixed$updatedByThe 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$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByUrl (   $url = null,
  $comparison = null 
)

Filter the query on the url column

Example usage: $query->filterByUrl('fooValue'); // WHERE url = 'fooValue' $query->filterByUrl('fooValue'); // WHERE url LIKE 'fooValue'

Parameters
string$urlThe value to use as filter. Accepts wildcards (* and % trigger a LIKE)
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::filterByUserRelatedByCreatedBy (   $user,
  $comparison = null 
)

Filter the query by a related User object

Parameters
User | PropelObjectCollection$userThe related object(s) to use as filter
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
Exceptions
PropelException- if the provided filter is invalid.
BaseLinkQuery::filterByUserRelatedByOwnerId (   $user,
  $comparison = null 
)

Filter the query by a related User object

Parameters
User | PropelObjectCollection$userThe related object(s) to use as filter
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
Exceptions
PropelException- if the provided filter is invalid.
BaseLinkQuery::filterByUserRelatedByUpdatedBy (   $user,
  $comparison = null 
)

Filter the query by a related User object

Parameters
User | PropelObjectCollection$userThe related object(s) to use as filter
string$comparisonOperator to use for the column comparison, defaults to Criteria::EQUAL
Returns
LinkQuery The current query, for fluid interface
Exceptions
PropelException- if the provided filter is invalid.
BaseLinkQuery::findOneById (   $key,
  $con = null 
)

Alias of findPk to use instance pooling

Parameters
mixed$keyPrimary key to use for the query
PropelPDO$conA connection object
Returns
Link A model object, or null if the key is not found
Exceptions
PropelException
BaseLinkQuery::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);

Parameters
mixed$keyPrimary key to use for the query
PropelPDO$conan optional connection object
Returns
Link|Link[]|mixed the result, formatted by the current formatter
BaseLinkQuery::findPkComplex (   $key,
  $con 
)
protected

Find object by primary key.

Parameters
mixed$keyPrimary key to use for the query
PropelPDO$conA connection object
Returns
Link|Link[]|mixed the result, formatted by the current formatter
BaseLinkQuery::findPks (   $keys,
  $con = null 
)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $con);

Parameters
array$keysPrimary keys to use for the query
PropelPDO$conan optional connection object
Returns
PropelObjectCollection|Link[]|mixed the list of results, formatted by the current formatter
BaseLinkQuery::findPkSimple (   $key,
  $con 
)
protected

Find object by primary key using raw SQL to go fast. Bypass doSelect() and the object formatter by using generated code.

Parameters
mixed$keyPrimary key to use for the query
PropelPDO$conA connection object
Returns
Link A model object, or null if the key is not found
Exceptions
PropelException
BaseLinkQuery::firstCreatedFirst ( )

Order by create date asc

Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::firstUpdatedFirst ( )

Order by update date asc

Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::joinLanguage (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Adds a JOIN clause to the query using the Language relation

Parameters
string$relationAliasoptional alias for the relation
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::joinLinkCategory (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Adds a JOIN clause to the query using the LinkCategory relation

Parameters
string$relationAliasoptional alias for the relation
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::joinUserRelatedByCreatedBy (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Adds a JOIN clause to the query using the UserRelatedByCreatedBy relation

Parameters
string$relationAliasoptional alias for the relation
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::joinUserRelatedByOwnerId (   $relationAlias = null,
  $joinType = Criteria::INNER_JOIN 
)

Adds a JOIN clause to the query using the UserRelatedByOwnerId relation

Parameters
string$relationAliasoptional alias for the relation
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::joinUserRelatedByUpdatedBy (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Adds a JOIN clause to the query using the UserRelatedByUpdatedBy relation

Parameters
string$relationAliasoptional alias for the relation
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::lastCreatedFirst ( )

Order by create date desc

Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::lastUpdatedFirst ( )

Order by update date desc

Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::prune (   $link = null)

Exclude object from result

Parameters
Link$linkObject to remove from the list of results
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::recentlyCreated (   $nbDays = 7)

Filter by the latest created

Parameters
int$nbDaysMaximum age of in days
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::recentlyUpdated (   $nbDays = 7)

Filter by the latest updated

Parameters
int$nbDaysMaximum age of the latest update in days
Returns
LinkQuery The current query, for fluid interface
BaseLinkQuery::useLanguageQuery (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Use the Language relation Language object

See also
useQuery()
Parameters
string$relationAliasoptional alias for the relation, to be used as main alias in the secondary query
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
LanguageQuery A secondary query class using the current class as primary query
BaseLinkQuery::useLinkCategoryQuery (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Use the LinkCategory relation LinkCategory object

See also
useQuery()
Parameters
string$relationAliasoptional alias for the relation, to be used as main alias in the secondary query
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
LinkCategoryQuery A secondary query class using the current class as primary query
BaseLinkQuery::useUserRelatedByCreatedByQuery (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Use the UserRelatedByCreatedBy relation User object

See also
useQuery()
Parameters
string$relationAliasoptional alias for the relation, to be used as main alias in the secondary query
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
UserQuery A secondary query class using the current class as primary query
BaseLinkQuery::useUserRelatedByOwnerIdQuery (   $relationAlias = null,
  $joinType = Criteria::INNER_JOIN 
)

Use the UserRelatedByOwnerId relation User object

See also
useQuery()
Parameters
string$relationAliasoptional alias for the relation, to be used as main alias in the secondary query
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
UserQuery A secondary query class using the current class as primary query
BaseLinkQuery::useUserRelatedByUpdatedByQuery (   $relationAlias = null,
  $joinType = Criteria::LEFT_JOIN 
)

Use the UserRelatedByUpdatedBy relation User object

See also
useQuery()
Parameters
string$relationAliasoptional alias for the relation, to be used as main alias in the secondary query
string$joinTypeAccepted values are null, 'left join', 'right join', 'inner join'
Returns
UserQuery A secondary query class using the current class as primary query

The documentation for this class was generated from the following file: