class MetaDataQuery extends MetaDataQuery

Skeleton subclass for performing query and update operations on the 'meta_data' table.

You should add additional methods to this class to meet the application requirements. This class will only be generated as long as it does not already exist in the output directory.

Methods

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

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

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

Returns a new ChildMetaDataQuery object.

MetaData|array|mixed
findPk( mixed $key, ConnectionInterface $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(12, 56, 832), $con);

filterByPrimaryKey( mixed $key)

Filter the query by primary key

filterByPrimaryKeys( array $keys)

Filter the query by a list of primary keys

filterById( mixed $id = null, string $comparison = null)

Filter the query on the id column

filterByMetaKey( string $metaKey = null, string $comparison = null)

Filter the query on the meta_key column

filterByElementKey( string $elementKey = null, string $comparison = null)

Filter the query on the element_key column

filterByElementId( mixed $elementId = null, string $comparison = null)

Filter the query on the element_id column

filterByIsSerialized( boolean|string $isSerialized = null, string $comparison = null)

Filter the query on the is_serialized column

filterByValue( string $value = null, string $comparison = null)

Filter the query on the value 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

prune( MetaData $metaData = null)

Exclude object from result

int
doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the meta_data table.

int
delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildMetaData 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

ChildMetaDataQuery
orderById($order = Criteria::ASC)

Order by the id column

ChildMetaDataQuery
orderByMetaKey($order = Criteria::ASC)

Order by the meta_key column

ChildMetaDataQuery
orderByElementKey($order = Criteria::ASC)

Order by the element_key column

ChildMetaDataQuery
orderByElementId($order = Criteria::ASC)

Order by the element_id column

ChildMetaDataQuery
orderByIsSerialized($order = Criteria::ASC)

Order by the is_serialized column

ChildMetaDataQuery
orderByValue($order = Criteria::ASC)

Order by the value column

ChildMetaDataQuery
orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

ChildMetaDataQuery
orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

ChildMetaDataQuery
groupById()

Group by the id column

ChildMetaDataQuery
groupByMetaKey()

Group by the meta_key column

ChildMetaDataQuery
groupByElementKey()

Group by the element_key column

ChildMetaDataQuery
groupByElementId()

Group by the element_id column

ChildMetaDataQuery
groupByIsSerialized()

Group by the is_serialized column

ChildMetaDataQuery
groupByValue()

Group by the value column

ChildMetaDataQuery
groupByCreatedAt()

Group by the created_at column

ChildMetaDataQuery
groupByUpdatedAt()

Group by the updated_at column

ChildMetaDataQuery
leftJoin($relation)

Adds a LEFT JOIN clause to the query

ChildMetaDataQuery
rightJoin($relation)

Adds a RIGHT JOIN clause to the query

ChildMetaDataQuery
innerJoin($relation)

Adds a INNER JOIN clause to the query

ChildMetaData
findOne( ConnectionInterface $con = null)

Return the first ChildMetaData matching the query

ChildMetaData
findOneOrCreate( ConnectionInterface $con = null)

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

ChildMetaData
findOneById( int $id)

Return the first ChildMetaData filtered by the id column

ChildMetaData
findOneByMetaKey( string $meta_key)

Return the first ChildMetaData filtered by the meta_key column

ChildMetaData
findOneByElementKey( string $element_key)

Return the first ChildMetaData filtered by the element_key column

ChildMetaData
findOneByElementId( int $element_id)

Return the first ChildMetaData filtered by the element_id column

ChildMetaData
findOneByIsSerialized( boolean $is_serialized)

Return the first ChildMetaData filtered by the is_serialized column

ChildMetaData
findOneByValue( string $value)

Return the first ChildMetaData filtered by the value column

ChildMetaData
findOneByCreatedAt( string $created_at)

Return the first ChildMetaData filtered by the created_at column

ChildMetaData
findOneByUpdatedAt( string $updated_at)

Return the first ChildMetaData filtered by the updated_at column

array
findById( int $id)

Return ChildMetaData objects filtered by the id column

array
findByMetaKey( string $meta_key)

Return ChildMetaData objects filtered by the meta_key column

array
findByElementKey( string $element_key)

Return ChildMetaData objects filtered by the element_key column

array
findByElementId( int $element_id)

Return ChildMetaData objects filtered by the element_id column

array
findByIsSerialized( boolean $is_serialized)

Return ChildMetaData objects filtered by the is_serialized column

array
findByValue( string $value)

Return ChildMetaData objects filtered by the value column

array
findByCreatedAt( string $created_at)

Return ChildMetaData objects filtered by the created_at column

array
findByUpdatedAt( string $updated_at)

Return ChildMetaData objects filtered by the updated_at column

static  mixed
getVal($metaKey, $elementKey, $elementId, $default = null)

No description

static  array
getAllVal( string $elementKey, int $elementId)

No description

static 
setVal($metaKey, $elementKey, $elementId, $value)

Add or update the MetaData element

Details

in MetaDataQuery at line 75
__construct( string $dbName = 'thelia', string $modelName = '\\Thelia\\Model\\MetaData', string $modelAlias = null)

Initializes internal state of \Thelia\Model\Base\MetaDataQuery 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'

in MetaDataQuery at line 88
static MetaDataQuery create( string $modelAlias = null, Criteria $criteria = null)

Returns a new ChildMetaDataQuery object.

Parameters

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

Return Value

MetaDataQuery

in MetaDataQuery at line 118
MetaData|array|mixed findPk( mixed $key, ConnectionInterface $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 $key Primary key to use for the query
ConnectionInterface $con an optional connection object

Return Value

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

in MetaDataQuery at line 200
ObjectCollection|array|mixed findPks( array $keys, ConnectionInterface $con = null)

Find objects by primary key $objs = $c->findPks(array(12, 56, 832), $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

in MetaDataQuery at line 221
MetaDataQuery filterByPrimaryKey( mixed $key)

Filter the query by primary key

Parameters

mixed $key Primary key to use for the query

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 234
MetaDataQuery 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

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 258
MetaDataQuery filterById( mixed $id = null, string $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

Parameters

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

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 296
MetaDataQuery filterByMetaKey( string $metaKey = null, string $comparison = null)

Filter the query on the meta_key column

Example usage: $query->filterByMetaKey('fooValue'); // WHERE metakey = 'fooValue' $query->filterByMetaKey('%fooValue%'); // WHERE metakey LIKE '%fooValue%'

Parameters

string $metaKey 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

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 325
MetaDataQuery filterByElementKey( string $elementKey = null, string $comparison = null)

Filter the query on the element_key column

Example usage: $query->filterByElementKey('fooValue'); // WHERE elementkey = 'fooValue' $query->filterByElementKey('%fooValue%'); // WHERE elementkey LIKE '%fooValue%'

Parameters

string $elementKey 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

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 357
MetaDataQuery filterByElementId( mixed $elementId = null, string $comparison = null)

Filter the query on the element_id column

Example usage: $query->filterByElementId(1234); // WHERE elementid = 1234 $query->filterByElementId(array(12, 34)); // WHERE elementid IN (12, 34) $query->filterByElementId(array('min' => 12)); // WHERE element_id > 12

Parameters

mixed $elementId 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

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 398
MetaDataQuery filterByIsSerialized( boolean|string $isSerialized = null, string $comparison = null)

Filter the query on the is_serialized column

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

Parameters

boolean|string $isSerialized The 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 $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 422
MetaDataQuery filterByValue( string $value = null, string $comparison = null)

Filter the query on the value column

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

Parameters

string $value 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

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 456
MetaDataQuery 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

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 499
MetaDataQuery 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

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 529
MetaDataQuery prune( MetaData $metaData = null)

Exclude object from result

Parameters

MetaData $metaData Object to remove from the list of results

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 544
int doDeleteAll( ConnectionInterface $con = null)

Deletes all rows from the meta_data table.

Parameters

ConnectionInterface $con the connection to use

Return Value

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

in MetaDataQuery at line 581
int delete( ConnectionInterface $con = null)

Performs a DELETE on the database, given a ChildMetaData 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.

in MetaDataQuery at line 622
MetaDataQuery recentlyUpdated( int $nbDays = 7)

Filter by the latest updated

Parameters

int $nbDays Maximum age of the latest update in days

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 634
MetaDataQuery recentlyCreated( int $nbDays = 7)

Filter by the latest created

Parameters

int $nbDays Maximum age of in days

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 644
MetaDataQuery lastUpdatedFirst()

Order by update date desc

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 654
MetaDataQuery firstUpdatedFirst()

Order by update date asc

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 664
MetaDataQuery lastCreatedFirst()

Order by create date desc

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 674
MetaDataQuery firstCreatedFirst()

Order by create date asc

Return Value

MetaDataQuery The current query, for fluid interface

in MetaDataQuery at line 65
ChildMetaDataQuery orderById($order = Criteria::ASC)

Order by the id column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery orderByMetaKey($order = Criteria::ASC)

Order by the meta_key column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery orderByElementKey($order = Criteria::ASC)

Order by the element_key column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery orderByElementId($order = Criteria::ASC)

Order by the element_id column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery orderByIsSerialized($order = Criteria::ASC)

Order by the is_serialized column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery orderByValue($order = Criteria::ASC)

Order by the value column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery orderByCreatedAt($order = Criteria::ASC)

Order by the created_at column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery orderByUpdatedAt($order = Criteria::ASC)

Order by the updated_at column

Parameters

$order

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupById()

Group by the id column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupByMetaKey()

Group by the meta_key column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupByElementKey()

Group by the element_key column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupByElementId()

Group by the element_id column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupByIsSerialized()

Group by the is_serialized column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupByValue()

Group by the value column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupByCreatedAt()

Group by the created_at column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery groupByUpdatedAt()

Group by the updated_at column

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery leftJoin($relation)

Adds a LEFT JOIN clause to the query

Parameters

$relation

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery rightJoin($relation)

Adds a RIGHT JOIN clause to the query

Parameters

$relation

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaDataQuery innerJoin($relation)

Adds a INNER JOIN clause to the query

Parameters

$relation

Return Value

ChildMetaDataQuery

in MetaDataQuery at line 65
ChildMetaData findOne( ConnectionInterface $con = null)

Return the first ChildMetaData matching the query

Parameters

ConnectionInterface $con

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneOrCreate( ConnectionInterface $con = null)

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

Parameters

ConnectionInterface $con

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneById( int $id)

Return the first ChildMetaData filtered by the id column

Parameters

int $id

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneByMetaKey( string $meta_key)

Return the first ChildMetaData filtered by the meta_key column

Parameters

string $meta_key

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneByElementKey( string $element_key)

Return the first ChildMetaData filtered by the element_key column

Parameters

string $element_key

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneByElementId( int $element_id)

Return the first ChildMetaData filtered by the element_id column

Parameters

int $element_id

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneByIsSerialized( boolean $is_serialized)

Return the first ChildMetaData filtered by the is_serialized column

Parameters

boolean $is_serialized

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneByValue( string $value)

Return the first ChildMetaData filtered by the value column

Parameters

string $value

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneByCreatedAt( string $created_at)

Return the first ChildMetaData filtered by the created_at column

Parameters

string $created_at

Return Value

ChildMetaData

in MetaDataQuery at line 65
ChildMetaData findOneByUpdatedAt( string $updated_at)

Return the first ChildMetaData filtered by the updated_at column

Parameters

string $updated_at

Return Value

ChildMetaData

in MetaDataQuery at line 65
array findById( int $id)

Return ChildMetaData objects filtered by the id column

Parameters

int $id

Return Value

array

in MetaDataQuery at line 65
array findByMetaKey( string $meta_key)

Return ChildMetaData objects filtered by the meta_key column

Parameters

string $meta_key

Return Value

array

in MetaDataQuery at line 65
array findByElementKey( string $element_key)

Return ChildMetaData objects filtered by the element_key column

Parameters

string $element_key

Return Value

array

in MetaDataQuery at line 65
array findByElementId( int $element_id)

Return ChildMetaData objects filtered by the element_id column

Parameters

int $element_id

Return Value

array

in MetaDataQuery at line 65
array findByIsSerialized( boolean $is_serialized)

Return ChildMetaData objects filtered by the is_serialized column

Parameters

boolean $is_serialized

Return Value

array

in MetaDataQuery at line 65
array findByValue( string $value)

Return ChildMetaData objects filtered by the value column

Parameters

string $value

Return Value

array

in MetaDataQuery at line 65
array findByCreatedAt( string $created_at)

Return ChildMetaData objects filtered by the created_at column

Parameters

string $created_at

Return Value

array

in MetaDataQuery at line 65
array findByUpdatedAt( string $updated_at)

Return ChildMetaData objects filtered by the updated_at column

Parameters

string $updated_at

Return Value

array

at line 27
static mixed getVal($metaKey, $elementKey, $elementId, $default = null)

Parameters

$metaKey
$elementKey
$elementId
$default

Return Value

mixed the value affected to this element

at line 54
static array getAllVal( string $elementKey, int $elementId)

Parameters

string $elementKey the element Key : product, category, ...
int $elementId the element id

Return Value

array all meta data affected to this element

at line 81
static setVal($metaKey, $elementKey, $elementId, $value)

Add or update the MetaData element

Parameters

$metaKey
$elementKey
$elementId
$value