MetaDataQuery
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
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 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.
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
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 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
No description
No description
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.
in
MetaDataQuery at line 88
static
MetaDataQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildMetaDataQuery object.
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);
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);
in
MetaDataQuery at line 221
MetaDataQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
MetaDataQuery at line 234
MetaDataQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
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
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%'
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%'
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
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
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%'
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'
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'
in
MetaDataQuery at line 529
MetaDataQuery
prune(
MetaData $metaData = null)
Exclude object from result
in
MetaDataQuery at line 544
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the meta_data table.
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.
in
MetaDataQuery at line 622
MetaDataQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
MetaDataQuery at line 634
MetaDataQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
MetaDataQuery at line 644
MetaDataQuery
lastUpdatedFirst()
Order by update date desc
in
MetaDataQuery at line 654
MetaDataQuery
firstUpdatedFirst()
Order by update date asc
in
MetaDataQuery at line 664
MetaDataQuery
lastCreatedFirst()
Order by create date desc
in
MetaDataQuery at line 674
MetaDataQuery
firstCreatedFirst()
Order by create date asc
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderById($order = Criteria::ASC)
Order by the id column
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderByMetaKey($order = Criteria::ASC)
Order by the meta_key column
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderByElementKey($order = Criteria::ASC)
Order by the element_key column
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderByElementId($order = Criteria::ASC)
Order by the element_id column
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderByIsSerialized($order = Criteria::ASC)
Order by the is_serialized column
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderByValue($order = Criteria::ASC)
Order by the value column
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
MetaDataQuery at line 65
ChildMetaDataQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupById()
Group by the id column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupByMetaKey()
Group by the meta_key column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupByElementKey()
Group by the element_key column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupByElementId()
Group by the element_id column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupByIsSerialized()
Group by the is_serialized column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupByValue()
Group by the value column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupByCreatedAt()
Group by the created_at column
in
MetaDataQuery at line 65
ChildMetaDataQuery
groupByUpdatedAt()
Group by the updated_at column
in
MetaDataQuery at line 65
ChildMetaDataQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
MetaDataQuery at line 65
ChildMetaDataQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
MetaDataQuery at line 65
ChildMetaDataQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
MetaDataQuery at line 65
ChildMetaData
findOne(
ConnectionInterface $con = null)
Return the first ChildMetaData matching the query
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
in
MetaDataQuery at line 65
ChildMetaData
findOneById(
int $id)
Return the first ChildMetaData filtered by the id column
in
MetaDataQuery at line 65
ChildMetaData
findOneByMetaKey(
string $meta_key)
Return the first ChildMetaData filtered by the meta_key column
in
MetaDataQuery at line 65
ChildMetaData
findOneByElementKey(
string $element_key)
Return the first ChildMetaData filtered by the element_key column
in
MetaDataQuery at line 65
ChildMetaData
findOneByElementId(
int $element_id)
Return the first ChildMetaData filtered by the element_id column
in
MetaDataQuery at line 65
ChildMetaData
findOneByIsSerialized(
boolean $is_serialized)
Return the first ChildMetaData filtered by the is_serialized column
in
MetaDataQuery at line 65
ChildMetaData
findOneByValue(
string $value)
Return the first ChildMetaData filtered by the value column
in
MetaDataQuery at line 65
ChildMetaData
findOneByCreatedAt(
string $created_at)
Return the first ChildMetaData filtered by the created_at column
in
MetaDataQuery at line 65
ChildMetaData
findOneByUpdatedAt(
string $updated_at)
Return the first ChildMetaData filtered by the updated_at column
in
MetaDataQuery at line 65
array
findById(
int $id)
Return ChildMetaData objects filtered by the id column
in
MetaDataQuery at line 65
array
findByMetaKey(
string $meta_key)
Return ChildMetaData objects filtered by the meta_key column
in
MetaDataQuery at line 65
array
findByElementKey(
string $element_key)
Return ChildMetaData objects filtered by the element_key column
in
MetaDataQuery at line 65
array
findByElementId(
int $element_id)
Return ChildMetaData objects filtered by the element_id column
in
MetaDataQuery at line 65
array
findByIsSerialized(
boolean $is_serialized)
Return ChildMetaData objects filtered by the is_serialized column
in
MetaDataQuery at line 65
array
findByValue(
string $value)
Return ChildMetaData objects filtered by the value column
in
MetaDataQuery at line 65
array
findByCreatedAt(
string $created_at)
Return ChildMetaData objects filtered by the created_at column
in
MetaDataQuery at line 65
array
findByUpdatedAt(
string $updated_at)
Return ChildMetaData objects filtered by the updated_at column
at line 27
static
mixed
getVal($metaKey, $elementKey, $elementId, $default = null)
at line 54
static
array
getAllVal(
string $elementKey,
int $elementId)
at line 81
static
setVal($metaKey, $elementKey, $elementId, $value)
Add or update the MetaData element