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 BaseBiomaterialpropQuery

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

ModelCriteria
Extended by cli_db\propel\om\BaseBiomaterialpropQuery

Direct known subclasses

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

Initializes internal state of BaseBiomaterialpropQuery object.

Initializes internal state of BaseBiomaterialpropQuery 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\BiomaterialpropQuery
# create( string $modelAlias = null, cli_db\propel\BiomaterialpropQuery|Criteria $criteria = null )

Returns a new BiomaterialpropQuery object.

Returns a new BiomaterialpropQuery object.

Parameters

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

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\Biomaterialprop|cli_db\propel\Biomaterialprop[]|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\Biomaterialprop|cli_db\propel\Biomaterialprop[]|mixed
the result, formatted by the current formatter
public cli_db\propel\Biomaterialprop
# findOneByBiomaterialpropId( 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\Biomaterialprop
A model object, or null if the key is not found

Throws

PropelException
protected cli_db\propel\Biomaterialprop
# 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\Biomaterialprop
A model object, or null if the key is not found

Throws

PropelException
protected cli_db\propel\Biomaterialprop|cli_db\propel\Biomaterialprop[]|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\Biomaterialprop|cli_db\propel\Biomaterialprop[]|mixed
the result, formatted by the current formatter
public PropelObjectCollection|cli_db\propel\Biomaterialprop[]|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\Biomaterialprop[]|mixed
the list of results, formatted by the current formatter
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
The current query, for fluid interface
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
The current query, for fluid interface
public cli_db\propel\BiomaterialpropQuery
# filterByBiomaterialpropId( mixed $biomaterialpropId = null, string $comparison = null )

Filter the query on the biomaterialprop_id column

Filter the query on the biomaterialprop_id column

Example usage:

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

Parameters

$biomaterialpropId
mixed
$biomaterialpropId 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\BiomaterialpropQuery
The current query, for fluid interface
public cli_db\propel\BiomaterialpropQuery
# filterByBiomaterialId( mixed $biomaterialId = null, string $comparison = null )

Filter the query on the biomaterial_id column

Filter the query on the biomaterial_id column

Example usage:

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

Parameters

$biomaterialId
mixed
$biomaterialId 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\BiomaterialpropQuery
The current query, for fluid interface

See

cli_db\propel\om\BaseBiomaterialpropQuery::filterByBiomaterial()
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
The current query, for fluid interface

See

cli_db\propel\om\BaseBiomaterialpropQuery::filterByCvterm()
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
The current query, for fluid interface
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
The current query, for fluid interface
public cli_db\propel\BiomaterialpropQuery
# filterByBiomaterial( cli_db\propel\Biomaterial|PropelObjectCollection $biomaterial, string $comparison = null )

Filter the query by a related Biomaterial object

Filter the query by a related Biomaterial object

Parameters

$biomaterial
cli_db\propel\Biomaterial|PropelObjectCollection
$biomaterial 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\BiomaterialpropQuery
The current query, for fluid interface

Throws

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

Adds a JOIN clause to the query using the Biomaterial relation

Adds a JOIN clause to the query using the Biomaterial 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\BiomaterialpropQuery
The current query, for fluid interface
public cli_db\propel\BiomaterialQuery
# useBiomaterialQuery( string $relationAlias = null, string $joinType = cli_db\propel\om\Criteria::INNER_JOIN )

Use the Biomaterial relation Biomaterial object

Use the Biomaterial relation Biomaterial 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\BiomaterialQuery
A secondary query class using the current class as primary query

See

useQuery()
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
The current query, for fluid interface

Throws

PropelException
- if the provided filter is invalid.
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
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\BiomaterialpropQuery
# prune( cli_db\propel\Biomaterialprop $biomaterialprop = null )

Exclude object from result

Exclude object from result

Parameters

$biomaterialprop
cli_db\propel\Biomaterialprop
$biomaterialprop Object to remove from the list of results

Returns

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

Order by the biomaterialprop_id column

Order by the biomaterialprop_id column

Parameters

$order
mixed
$order

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# orderByBiomaterialId( mixed $order = cli_db\propel\om\Criteria::ASC )

Order by the biomaterial_id column

Order by the biomaterial_id column

Parameters

$order
mixed
$order

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# groupByBiomaterialpropId( )

Group by the biomaterialprop_id column

Group by the biomaterialprop_id column

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# groupByBiomaterialId( )

Group by the biomaterial_id column

Group by the biomaterial_id column

Returns

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

Group by the type_id column

Group by the type_id column

Returns

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

Group by the value column

Group by the value column

Returns

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

Group by the rank column

Group by the rank column

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# leftJoinBiomaterial( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# rightJoinBiomaterial( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# innerJoinBiomaterial( mixed $relationAlias = null )

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

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

Parameters

$relationAlias
mixed
$relationAlias

Returns

cli_db\propel\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\BiomaterialpropQuery
# 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\BiomaterialpropQuery
public cli_db\propel\Biomaterialprop
# findOne( PropelPDO $con = null )

Return the first Biomaterialprop matching the query

Return the first Biomaterialprop matching the query

Parameters

$con
PropelPDO
$con

Returns

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

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

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

Parameters

$con
PropelPDO
$con

Returns

cli_db\propel\Biomaterialprop
public cli_db\propel\Biomaterialprop
# findOneByBiomaterialId( integer $biomaterial_id = )

Return the first Biomaterialprop filtered by the biomaterial_id column

Return the first Biomaterialprop filtered by the biomaterial_id column

Parameters

$biomaterial_id
integer
$biomaterial_id

Returns

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

Return the first Biomaterialprop filtered by the type_id column

Return the first Biomaterialprop filtered by the type_id column

Parameters

$type_id
integer
$type_id

Returns

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

Return the first Biomaterialprop filtered by the value column

Return the first Biomaterialprop filtered by the value column

Parameters

$value
string
$value

Returns

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

Return the first Biomaterialprop filtered by the rank column

Return the first Biomaterialprop filtered by the rank column

Parameters

$rank
integer
$rank

Returns

cli_db\propel\Biomaterialprop
public array
# findByBiomaterialpropId( integer $biomaterialprop_id = )

Return Biomaterialprop objects filtered by the biomaterialprop_id column

Return Biomaterialprop objects filtered by the biomaterialprop_id column

Parameters

$biomaterialprop_id
integer
$biomaterialprop_id

Returns

array
public array
# findByBiomaterialId( integer $biomaterial_id = )

Return Biomaterialprop objects filtered by the biomaterial_id column

Return Biomaterialprop objects filtered by the biomaterial_id column

Parameters

$biomaterial_id
integer
$biomaterial_id

Returns

array
public array
# findByTypeId( integer $type_id = )

Return Biomaterialprop objects filtered by the type_id column

Return Biomaterialprop objects filtered by the type_id column

Parameters

$type_id
integer
$type_id

Returns

array
public array
# findByValue( string $value = )

Return Biomaterialprop objects filtered by the value column

Return Biomaterialprop objects filtered by the value column

Parameters

$value
string
$value

Returns

array
public array
# findByRank( integer $rank = )

Return Biomaterialprop objects filtered by the rank column

Return Biomaterialprop objects filtered by the rank column

Parameters

$rank
integer
$rank

Returns

array
tbro API documentation generated by ApiGen 2.8.0