Overview

Namespaces

  • cli_db
    • propel
      • map
      • om
  • cli_import
  • LoggedPDO
  • None
  • PHP
  • webservices
    • cart
    • combisearch
    • details
      • annotations
        • feature
    • graphs
      • barplot
      • genome
    • listing
    • queue

Classes

  • BaseAcquisition
  • BaseAcquisitionPeer
  • BaseAcquisitionQuery
  • BaseAnalysis
  • BaseAnalysisPeer
  • BaseAnalysisQuery
  • BaseAssay
  • BaseAssayBiomaterial
  • BaseAssayBiomaterialPeer
  • BaseAssayBiomaterialQuery
  • BaseAssayPeer
  • BaseAssayQuery
  • BaseBiomaterial
  • BaseBiomaterialPeer
  • BaseBiomaterialprop
  • BaseBiomaterialpropPeer
  • BaseBiomaterialpropQuery
  • BaseBiomaterialQuery
  • BaseBiomaterialRelationship
  • BaseBiomaterialRelationshipPeer
  • BaseBiomaterialRelationshipQuery
  • BaseContact
  • BaseContactPeer
  • BaseContactQuery
  • BaseCv
  • BaseCvPeer
  • BaseCvQuery
  • BaseCvterm
  • BaseCvtermPeer
  • BaseCvtermQuery
  • BaseDb
  • BaseDbPeer
  • BaseDbQuery
  • BaseDbxref
  • BaseDbxrefPeer
  • BaseDbxrefQuery
  • BaseFeature
  • BaseFeatureCvterm
  • BaseFeatureCvtermDbxref
  • BaseFeatureCvtermDbxrefPeer
  • BaseFeatureCvtermDbxrefQuery
  • BaseFeatureCvtermPeer
  • BaseFeatureCvtermprop
  • BaseFeatureCvtermpropPeer
  • BaseFeatureCvtermpropQuery
  • BaseFeatureCvtermPub
  • BaseFeatureCvtermPubPeer
  • BaseFeatureCvtermPubQuery
  • BaseFeatureCvtermQuery
  • BaseFeatureDbxref
  • BaseFeatureDbxrefPeer
  • BaseFeatureDbxrefQuery
  • BaseFeaturePeer
  • BaseFeaturePub
  • BaseFeaturePubPeer
  • BaseFeaturePubQuery
  • BaseFeatureQuery
  • BaseFeatureSynonym
  • BaseFeatureSynonymPeer
  • BaseFeatureSynonymQuery
  • BaseOrganism
  • BaseOrganismPeer
  • BaseOrganismQuery
  • BaseProtocol
  • BaseProtocolPeer
  • BaseProtocolQuery
  • BasePub
  • BasePubauthor
  • BasePubauthorPeer
  • BasePubauthorQuery
  • BasePubDbxref
  • BasePubDbxrefPeer
  • BasePubDbxrefQuery
  • BasePubPeer
  • BasePubprop
  • BasePubpropPeer
  • BasePubpropQuery
  • BasePubQuery
  • BasePubRelationship
  • BasePubRelationshipPeer
  • BasePubRelationshipQuery
  • BaseQuantification
  • BaseQuantificationPeer
  • BaseQuantificationQuery
  • BaseSynonym
  • BaseSynonymPeer
  • BaseSynonymQuery
  • Overview
  • Namespace
  • Class
  • Tree

Class BasePubpropQuery

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

ModelCriteria
Extended by cli_db\propel\om\BasePubpropQuery

Direct known subclasses

cli_db\propel\PubpropQuery
Abstract
Namespace: cli_db\propel\om
Package: propel\generator\cli\db\om
Located at src/cli/db/propel-classes/cli_db/om/BasePubpropQuery.php
Methods summary
public
# __construct( string $dbName = 'cli_db', string $modelName = 'cli_db\\propel\\Pubprop', string $modelAlias = null )

Initializes internal state of BasePubpropQuery object.

Initializes internal state of BasePubpropQuery object.

Parameters

$dbName
string
$dbName The dabase name
$modelName
string
$modelName The phpName of a model, e.g. 'Book'
$modelAlias
string
$modelAlias The alias for the model in this query, e.g. 'b'
public static cli_db\propel\PubpropQuery
# create( string $modelAlias = null, cli_db\propel\PubpropQuery|Criteria $criteria = null )

Returns a new PubpropQuery object.

Returns a new PubpropQuery object.

Parameters

$modelAlias
string
$modelAlias The alias of a model in the query
$criteria
cli_db\propel\PubpropQuery|Criteria
$criteria Optional Criteria to build the query from

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\Pubprop|cli_db\propel\Pubprop[]|mixed
# findPk( mixed $key, PropelPDO $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.

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

$key
mixed
$key Primary key to use for the query
$con
PropelPDO
$con an optional connection object

Returns

cli_db\propel\Pubprop|cli_db\propel\Pubprop[]|mixed
the result, formatted by the current formatter
public cli_db\propel\Pubprop
# findOneByPubpropId( mixed $key, PropelPDO $con = null )

Alias of findPk to use instance pooling

Alias of findPk to use instance pooling

Parameters

$key
mixed
$key Primary key to use for the query
$con
PropelPDO
$con A connection object

Returns

cli_db\propel\Pubprop
A model object, or null if the key is not found

Throws

PropelException
protected cli_db\propel\Pubprop
# findPkSimple( mixed $key, PropelPDO $con )

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

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

Parameters

$key
mixed
$key Primary key to use for the query
$con
PropelPDO
$con A connection object

Returns

cli_db\propel\Pubprop
A model object, or null if the key is not found

Throws

PropelException
protected cli_db\propel\Pubprop|cli_db\propel\Pubprop[]|mixed
# findPkComplex( mixed $key, PropelPDO $con )

Find object by primary key.

Find object by primary key.

Parameters

$key
mixed
$key Primary key to use for the query
$con
PropelPDO
$con A connection object

Returns

cli_db\propel\Pubprop|cli_db\propel\Pubprop[]|mixed
the result, formatted by the current formatter
public PropelObjectCollection|cli_db\propel\Pubprop[]|mixed
# findPks( array $keys, PropelPDO $con = null )

Find objects by primary key

$objs = $c->findPks(array(12, 56, 832), $con);

Find objects by primary key

$objs = $c->findPks(array(12, 56, 832), $con);

Parameters

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

Returns

PropelObjectCollection|cli_db\propel\Pubprop[]|mixed
the list of results, formatted by the current formatter
public cli_db\propel\PubpropQuery
# filterByPrimaryKey( mixed $key )

Filter the query by primary key

Filter the query by primary key

Parameters

$key
mixed
$key Primary key to use for the query

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
public cli_db\propel\PubpropQuery
# filterByPrimaryKeys( array $keys )

Filter the query by a list of primary keys

Filter the query by a list of primary keys

Parameters

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

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
public cli_db\propel\PubpropQuery
# filterByPubpropId( mixed $pubpropId = null, string $comparison = null )

Filter the query on the pubprop_id column

Filter the query on the pubprop_id column

Example usage:

$query->filterByPubpropId(1234); // WHERE pubprop_id = 1234
$query->filterByPubpropId(array(12, 34)); // WHERE pubprop_id IN (12, 34)
$query->filterByPubpropId(array('min' => 12)); // WHERE pubprop_id >= 12
$query->filterByPubpropId(array('max' => 12)); // WHERE pubprop_id <= 12

Parameters

$pubpropId
mixed
$pubpropId 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.
$comparison
string
$comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
public cli_db\propel\PubpropQuery
# filterByPubId( mixed $pubId = null, string $comparison = null )

Filter the query on the pub_id column

Filter the query on the pub_id column

Example usage:

$query->filterByPubId(1234); // WHERE pub_id = 1234
$query->filterByPubId(array(12, 34)); // WHERE pub_id IN (12, 34)
$query->filterByPubId(array('min' => 12)); // WHERE pub_id >= 12
$query->filterByPubId(array('max' => 12)); // WHERE pub_id <= 12

Parameters

$pubId
mixed
$pubId 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.
$comparison
string
$comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface

See

cli_db\propel\om\BasePubpropQuery::filterByPub()
public cli_db\propel\PubpropQuery
# filterByTypeId( mixed $typeId = null, string $comparison = null )

Filter the query on the type_id column

Filter the query on the type_id column

Example usage:

$query->filterByTypeId(1234); // WHERE type_id = 1234
$query->filterByTypeId(array(12, 34)); // WHERE type_id IN (12, 34)
$query->filterByTypeId(array('min' => 12)); // WHERE type_id >= 12
$query->filterByTypeId(array('max' => 12)); // WHERE type_id <= 12

Parameters

$typeId
mixed
$typeId 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.
$comparison
string
$comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface

See

cli_db\propel\om\BasePubpropQuery::filterByCvterm()
public cli_db\propel\PubpropQuery
# filterByValue( string $value = null, string $comparison = null )

Filter the query on the value column

Filter the query on the value column

Example usage:

$query->filterByValue('fooValue');   // WHERE value = 'fooValue'
$query->filterByValue('%fooValue%'); // WHERE value LIKE '%fooValue%'

Parameters

$value
string
$value The value to use as filter. Accepts wildcards (* and % trigger a LIKE)
$comparison
string
$comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
public cli_db\propel\PubpropQuery
# filterByRank( mixed $rank = null, string $comparison = null )

Filter the query on the rank column

Filter the query on the rank column

Example usage:

$query->filterByRank(1234); // WHERE rank = 1234
$query->filterByRank(array(12, 34)); // WHERE rank IN (12, 34)
$query->filterByRank(array('min' => 12)); // WHERE rank >= 12
$query->filterByRank(array('max' => 12)); // WHERE rank <= 12

Parameters

$rank
mixed
$rank 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.
$comparison
string
$comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
public cli_db\propel\PubpropQuery
# filterByPub( cli_db\propel\Pub|PropelObjectCollection $pub, string $comparison = null )

Filter the query by a related Pub object

Filter the query by a related Pub object

Parameters

$pub
cli_db\propel\Pub|PropelObjectCollection
$pub The related object(s) to use as filter
$comparison
string
$comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface

Throws

PropelException
- if the provided filter is invalid.
public cli_db\propel\PubpropQuery
# joinPub( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::INNER_JOIN )

Adds a JOIN clause to the query using the Pub relation

Adds a JOIN clause to the query using the Pub relation

Parameters

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

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
public cli_db\propel\PubQuery
# usePubQuery( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::INNER_JOIN )

Use the Pub relation Pub object

Use the Pub relation Pub object

Parameters

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

Returns

cli_db\propel\PubQuery
A secondary query class using the current class as primary query

See

useQuery()
public cli_db\propel\PubpropQuery
# filterByCvterm( cli_db\propel\Cvterm|PropelObjectCollection $cvterm, string $comparison = null )

Filter the query by a related Cvterm object

Filter the query by a related Cvterm object

Parameters

$cvterm
cli_db\propel\Cvterm|PropelObjectCollection
$cvterm The related object(s) to use as filter
$comparison
string
$comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface

Throws

PropelException
- if the provided filter is invalid.
public cli_db\propel\PubpropQuery
# joinCvterm( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::INNER_JOIN )

Adds a JOIN clause to the query using the Cvterm relation

Adds a JOIN clause to the query using the Cvterm relation

Parameters

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

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
public cli_db\propel\CvtermQuery
# useCvtermQuery( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::INNER_JOIN )

Use the Cvterm relation Cvterm object

Use the Cvterm relation Cvterm object

Parameters

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

Returns

cli_db\propel\CvtermQuery
A secondary query class using the current class as primary query

See

useQuery()
public cli_db\propel\PubpropQuery
# prune( cli_db\propel\Pubprop $pubprop = null )

Exclude object from result

Exclude object from result

Parameters

$pubprop
cli_db\propel\Pubprop
$pubprop Object to remove from the list of results

Returns

cli_db\propel\PubpropQuery
The current query, for fluid interface
Magic methods summary
public cli_db\propel\PubpropQuery
# orderByPubpropId( mixed $order = cli_db\propel\om\Criteria::ASC )

Order by the pubprop_id column

Order by the pubprop_id column

Parameters

$order
mixed
$order

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# orderByPubId( mixed $order = cli_db\propel\om\Criteria::ASC )

Order by the pub_id column

Order by the pub_id column

Parameters

$order
mixed
$order

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# orderByTypeId( mixed $order = cli_db\propel\om\Criteria::ASC )

Order by the type_id column

Order by the type_id column

Parameters

$order
mixed
$order

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# orderByValue( mixed $order = cli_db\propel\om\Criteria::ASC )

Order by the value column

Order by the value column

Parameters

$order
mixed
$order

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# orderByRank( mixed $order = cli_db\propel\om\Criteria::ASC )

Order by the rank column

Order by the rank column

Parameters

$order
mixed
$order

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# groupByPubpropId( )

Group by the pubprop_id column

Group by the pubprop_id column

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# groupByPubId( )

Group by the pub_id column

Group by the pub_id column

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# groupByTypeId( )

Group by the type_id column

Group by the type_id column

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# groupByValue( )

Group by the value column

Group by the value column

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# groupByRank( )

Group by the rank column

Group by the rank column

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# leftJoin( mixed $relation = )

Adds a LEFT JOIN clause to the query

Adds a LEFT JOIN clause to the query

Parameters

$relation
mixed
$relation

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# rightJoin( mixed $relation = )

Adds a RIGHT JOIN clause to the query

Adds a RIGHT JOIN clause to the query

Parameters

$relation
mixed
$relation

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# innerJoin( mixed $relation = )

Adds a INNER JOIN clause to the query

Adds a INNER JOIN clause to the query

Parameters

$relation
mixed
$relation

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# leftJoinPub( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# rightJoinPub( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# innerJoinPub( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# leftJoinCvterm( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# rightJoinCvterm( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\PubpropQuery
# innerJoinCvterm( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\PubpropQuery
public cli_db\propel\Pubprop
# findOne( PropelPDO $con = null )

Return the first Pubprop matching the query

Return the first Pubprop matching the query

Parameters

$con
PropelPDO
$con

Returns

cli_db\propel\Pubprop
public cli_db\propel\Pubprop
# findOneOrCreate( PropelPDO $con = null )

Return the first Pubprop matching the query, or a new Pubprop object populated from the query conditions when no match is found

Return the first Pubprop matching the query, or a new Pubprop object populated from the query conditions when no match is found

Parameters

$con
PropelPDO
$con

Returns

cli_db\propel\Pubprop
public cli_db\propel\Pubprop
# findOneByPubId( integer $pub_id = )

Return the first Pubprop filtered by the pub_id column

Return the first Pubprop filtered by the pub_id column

Parameters

$pub_id
integer
$pub_id

Returns

cli_db\propel\Pubprop
public cli_db\propel\Pubprop
# findOneByTypeId( integer $type_id = )

Return the first Pubprop filtered by the type_id column

Return the first Pubprop filtered by the type_id column

Parameters

$type_id
integer
$type_id

Returns

cli_db\propel\Pubprop
public cli_db\propel\Pubprop
# findOneByValue( string $value = )

Return the first Pubprop filtered by the value column

Return the first Pubprop filtered by the value column

Parameters

$value
string
$value

Returns

cli_db\propel\Pubprop
public cli_db\propel\Pubprop
# findOneByRank( integer $rank = )

Return the first Pubprop filtered by the rank column

Return the first Pubprop filtered by the rank column

Parameters

$rank
integer
$rank

Returns

cli_db\propel\Pubprop
public array
# findByPubpropId( integer $pubprop_id = )

Return Pubprop objects filtered by the pubprop_id column

Return Pubprop objects filtered by the pubprop_id column

Parameters

$pubprop_id
integer
$pubprop_id

Returns

array
public array
# findByPubId( integer $pub_id = )

Return Pubprop objects filtered by the pub_id column

Return Pubprop objects filtered by the pub_id column

Parameters

$pub_id
integer
$pub_id

Returns

array
public array
# findByTypeId( integer $type_id = )

Return Pubprop objects filtered by the type_id column

Return Pubprop objects filtered by the type_id column

Parameters

$type_id
integer
$type_id

Returns

array
public array
# findByValue( string $value = )

Return Pubprop objects filtered by the value column

Return Pubprop objects filtered by the value column

Parameters

$value
string
$value

Returns

array
public array
# findByRank( integer $rank = )

Return Pubprop objects filtered by the rank column

Return Pubprop objects filtered by the rank column

Parameters

$rank
integer
$rank

Returns

array
tbro API documentation generated by ApiGen 2.8.0