MetaDataQuery
class MetaDataQuery extends ModelCriteria
Base class that represents a query for the 'meta_data' table.
Methods
Initializes internal state of \Thelia\Model\Base\MetaDataQuery object.
Returns a new ChildMetaDataQuery object.
Find object by primary key.
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
Filter the query by primary key
Filter the query by a list of primary keys
Filter the query on the id column
Filter the query on the meta_key column
Filter the query on the element_key column
Filter the query on the element_id column
Filter the query on the is_serialized column
Filter the query on the value column
Filter the query on the created_at column
Filter the query on the updated_at column
Deletes all rows from the meta_data table.
Performs a DELETE on the database, given a ChildMetaData or Criteria object OR a primary key value.
Filter by the latest updated
Filter by the latest created
Order by update date desc
Order by update date asc
Order by create date desc
Order by create date asc
Order by the id column
Order by the meta_key column
Order by the element_key column
Order by the element_id column
Order by the is_serialized column
Order by the value column
Order by the created_at column
Order by the updated_at column
Group by the id column
Group by the meta_key column
Group by the element_key column
Group by the element_id column
Group by the is_serialized column
Group by the value column
Group by the created_at column
Group by the updated_at column
Adds a LEFT JOIN clause to the query
Adds a RIGHT JOIN clause to the query
Adds a INNER JOIN clause to the query
Return the first ChildMetaData matching the query
Return the first ChildMetaData matching the query, or a new ChildMetaData object populated from the query conditions when no match is found
Return the first ChildMetaData filtered by the id column
Return the first ChildMetaData filtered by the meta_key column
Return the first ChildMetaData filtered by the element_key column
Return the first ChildMetaData filtered by the element_id column
Return the first ChildMetaData filtered by the is_serialized column
Return the first ChildMetaData filtered by the value column
Return the first ChildMetaData filtered by the created_at column
Return the first ChildMetaData filtered by the updated_at column
Return ChildMetaData objects filtered by the id column
Return ChildMetaData objects filtered by the meta_key column
Return ChildMetaData objects filtered by the element_key column
Return ChildMetaData objects filtered by the element_id column
Return ChildMetaData objects filtered by the is_serialized column
Return ChildMetaData objects filtered by the value column
Return ChildMetaData objects filtered by the created_at column
Return ChildMetaData objects filtered by the updated_at column
Details
at line 75
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\MetaData',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\MetaDataQuery object.
at line 88
static
MetaDataQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildMetaDataQuery object.
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);
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);
at line 221
MetaDataQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
at line 234
MetaDataQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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%'
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%'
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
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
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%'
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'
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'
at line 529
MetaDataQuery
prune(
MetaData $metaData = null)
Exclude object from result
at line 544
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the meta_data table.
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.
at line 622
MetaDataQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
at line 634
MetaDataQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
at line 644
MetaDataQuery
lastUpdatedFirst()
Order by update date desc
at line 654
MetaDataQuery
firstUpdatedFirst()
Order by update date asc
at line 664
MetaDataQuery
lastCreatedFirst()
Order by create date desc
at line 674
MetaDataQuery
firstCreatedFirst()
Order by create date asc
at line 65
ChildMetaDataQuery
orderById($order = Criteria::ASC)
Order by the id column
at line 65
ChildMetaDataQuery
orderByMetaKey($order = Criteria::ASC)
Order by the meta_key column
at line 65
ChildMetaDataQuery
orderByElementKey($order = Criteria::ASC)
Order by the element_key column
at line 65
ChildMetaDataQuery
orderByElementId($order = Criteria::ASC)
Order by the element_id column
at line 65
ChildMetaDataQuery
orderByIsSerialized($order = Criteria::ASC)
Order by the is_serialized column
at line 65
ChildMetaDataQuery
orderByValue($order = Criteria::ASC)
Order by the value column
at line 65
ChildMetaDataQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
at line 65
ChildMetaDataQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
at line 65
ChildMetaDataQuery
groupById()
Group by the id column
at line 65
ChildMetaDataQuery
groupByMetaKey()
Group by the meta_key column
at line 65
ChildMetaDataQuery
groupByElementKey()
Group by the element_key column
at line 65
ChildMetaDataQuery
groupByElementId()
Group by the element_id column
at line 65
ChildMetaDataQuery
groupByIsSerialized()
Group by the is_serialized column
at line 65
ChildMetaDataQuery
groupByValue()
Group by the value column
at line 65
ChildMetaDataQuery
groupByCreatedAt()
Group by the created_at column
at line 65
ChildMetaDataQuery
groupByUpdatedAt()
Group by the updated_at column
at line 65
ChildMetaDataQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
at line 65
ChildMetaDataQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
at line 65
ChildMetaDataQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
at line 65
ChildMetaData
findOne(
ConnectionInterface $con = null)
Return the first ChildMetaData matching the query
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
at line 65
ChildMetaData
findOneById(
int $id)
Return the first ChildMetaData filtered by the id column
at line 65
ChildMetaData
findOneByMetaKey(
string $meta_key)
Return the first ChildMetaData filtered by the meta_key column
at line 65
ChildMetaData
findOneByElementKey(
string $element_key)
Return the first ChildMetaData filtered by the element_key column
at line 65
ChildMetaData
findOneByElementId(
int $element_id)
Return the first ChildMetaData filtered by the element_id column
at line 65
ChildMetaData
findOneByIsSerialized(
boolean $is_serialized)
Return the first ChildMetaData filtered by the is_serialized column
at line 65
ChildMetaData
findOneByValue(
string $value)
Return the first ChildMetaData filtered by the value column
at line 65
ChildMetaData
findOneByCreatedAt(
string $created_at)
Return the first ChildMetaData filtered by the created_at column
at line 65
ChildMetaData
findOneByUpdatedAt(
string $updated_at)
Return the first ChildMetaData filtered by the updated_at column
at line 65
array
findById(
int $id)
Return ChildMetaData objects filtered by the id column
at line 65
array
findByMetaKey(
string $meta_key)
Return ChildMetaData objects filtered by the meta_key column
at line 65
array
findByElementKey(
string $element_key)
Return ChildMetaData objects filtered by the element_key column
at line 65
array
findByElementId(
int $element_id)
Return ChildMetaData objects filtered by the element_id column
at line 65
array
findByIsSerialized(
boolean $is_serialized)
Return ChildMetaData objects filtered by the is_serialized column
at line 65
array
findByValue(
string $value)
Return ChildMetaData objects filtered by the value column
at line 65
array
findByCreatedAt(
string $created_at)
Return ChildMetaData objects filtered by the created_at column
at line 65
array
findByUpdatedAt(
string $updated_at)
Return ChildMetaData objects filtered by the updated_at column