MessageQuery
class MessageQuery extends MessageQuery
Skeleton subclass for performing query and update operations on the 'message' 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.
Properties
static | $isVersioningEnabled | Whether the versioning is enabled | from MessageQuery |
Methods
Initializes internal state of \Thelia\Model\Base\MessageQuery object.
Returns a new ChildMessageQuery 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 name column
Filter the query on the secured column
Filter the query on the textlayoutfile_name column
Filter the query on the texttemplatefile_name column
Filter the query on the htmllayoutfile_name column
Filter the query on the htmltemplatefile_name column
Filter the query on the created_at column
Filter the query on the updated_at column
Filter the query on the version column
Filter the query on the versioncreatedat column
Filter the query on the versioncreatedby column
Filter the query by a related \Thelia\Model\MessageI18n object
Adds a JOIN clause to the query using the MessageI18n relation
Use the MessageI18n relation MessageI18n object
Filter the query by a related \Thelia\Model\MessageVersion object
Adds a JOIN clause to the query using the MessageVersion relation
Use the MessageVersion relation MessageVersion object
Deletes all rows from the message table.
Performs a DELETE on the database, given a ChildMessage or Criteria object OR a primary key value.
Adds a JOIN clause to the query using the i18n relation
Adds a JOIN clause to the query and hydrates the related I18n object.
Use the I18n relation query object
Order by the secured column
Order by the textlayoutfile_name column
Order by the texttemplatefile_name column
Order by the htmllayoutfile_name column
Order by the htmltemplatefile_name column
Order by the created_at column
Order by the updated_at column
Order by the version column
Order by the versioncreatedat column
Order by the versioncreatedby column
Group by the textlayoutfile_name column
Group by the texttemplatefile_name column
Group by the htmllayoutfile_name column
Group by the htmltemplatefile_name column
Adds a LEFT JOIN clause to the query using the MessageI18n relation
Adds a RIGHT JOIN clause to the query using the MessageI18n relation
Adds a INNER JOIN clause to the query using the MessageI18n relation
Adds a LEFT JOIN clause to the query using the MessageVersion relation
Adds a RIGHT JOIN clause to the query using the MessageVersion relation
Adds a INNER JOIN clause to the query using the MessageVersion relation
Return the first ChildMessage matching the query
Return the first ChildMessage matching the query, or a new ChildMessage object populated from the query conditions when no match is found
Return the first ChildMessage filtered by the id column
Return the first ChildMessage filtered by the name column
Return the first ChildMessage filtered by the secured column
Return the first ChildMessage filtered by the textlayoutfile_name column
Return the first ChildMessage filtered by the texttemplatefile_name column
Return the first ChildMessage filtered by the htmllayoutfile_name column
Return the first ChildMessage filtered by the htmltemplatefile_name column
Return the first ChildMessage filtered by the created_at column
Return the first ChildMessage filtered by the updated_at column
Return the first ChildMessage filtered by the version column
Return the first ChildMessage filtered by the versioncreatedat column
Return the first ChildMessage filtered by the versioncreatedby column
Return ChildMessage objects filtered by the name column
Return ChildMessage objects filtered by the secured column
Return ChildMessage objects filtered by the textlayoutfile_name column
Return ChildMessage objects filtered by the texttemplatefile_name column
Return ChildMessage objects filtered by the htmllayoutfile_name column
Return ChildMessage objects filtered by the htmltemplatefile_name column
Return ChildMessage objects filtered by the created_at column
Return ChildMessage objects filtered by the updated_at column
Return ChildMessage objects filtered by the version column
Return ChildMessage objects filtered by the versioncreatedat column
Return ChildMessage objects filtered by the versioncreatedby column
Load a message from its name, throwing an excemtoipn is none is found.
Details
in
MessageQuery at line 110
__construct(
string $dbName = 'thelia',
string $modelName = '\\Thelia\\Model\\Message',
string $modelAlias = null)
Initializes internal state of \Thelia\Model\Base\MessageQuery object.
in
MessageQuery at line 123
static
MessageQuery
create(
string $modelAlias = null,
Criteria $criteria = null)
Returns a new ChildMessageQuery object.
in
MessageQuery at line 153
Message|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
MessageQuery at line 235
ObjectCollection|array|mixed
findPks(
array $keys,
ConnectionInterface $con = null)
Find objects by primary key
$objs = $c->findPks(array(12, 56, 832), $con);
in
MessageQuery at line 256
MessageQuery
filterByPrimaryKey(
mixed $key)
Filter the query by primary key
in
MessageQuery at line 269
MessageQuery
filterByPrimaryKeys(
array $keys)
Filter the query by a list of primary keys
in
MessageQuery at line 293
MessageQuery
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
MessageQuery at line 331
MessageQuery
filterByName(
string $name = null,
string $comparison = null)
Filter the query on the name column
Example usage:
$query->filterByName('fooValue'); // WHERE name = 'fooValue'
$query->filterByName('%fooValue%'); // WHERE name LIKE '%fooValue%'
in
MessageQuery at line 363
MessageQuery
filterBySecured(
mixed $secured = null,
string $comparison = null)
Filter the query on the secured column
Example usage:
$query->filterBySecured(1234); // WHERE secured = 1234
$query->filterBySecured(array(12, 34)); // WHERE secured IN (12, 34)
$query->filterBySecured(array('min' => 12)); // WHERE secured > 12
in
MessageQuery at line 401
MessageQuery
filterByTextLayoutFileName(
string $textLayoutFileName = null,
string $comparison = null)
Filter the query on the textlayoutfile_name column
Example usage:
$query->filterByTextLayoutFileName('fooValue'); // WHERE textlayoutfilename = 'fooValue'
$query->filterByTextLayoutFileName('%fooValue%'); // WHERE textlayoutfilename LIKE '%fooValue%'
in
MessageQuery at line 430
MessageQuery
filterByTextTemplateFileName(
string $textTemplateFileName = null,
string $comparison = null)
Filter the query on the texttemplatefile_name column
Example usage:
$query->filterByTextTemplateFileName('fooValue'); // WHERE texttemplatefilename = 'fooValue'
$query->filterByTextTemplateFileName('%fooValue%'); // WHERE texttemplatefilename LIKE '%fooValue%'
in
MessageQuery at line 459
MessageQuery
filterByHtmlLayoutFileName(
string $htmlLayoutFileName = null,
string $comparison = null)
Filter the query on the htmllayoutfile_name column
Example usage:
$query->filterByHtmlLayoutFileName('fooValue'); // WHERE htmllayoutfilename = 'fooValue'
$query->filterByHtmlLayoutFileName('%fooValue%'); // WHERE htmllayoutfilename LIKE '%fooValue%'
in
MessageQuery at line 488
MessageQuery
filterByHtmlTemplateFileName(
string $htmlTemplateFileName = null,
string $comparison = null)
Filter the query on the htmltemplatefile_name column
Example usage:
$query->filterByHtmlTemplateFileName('fooValue'); // WHERE htmltemplatefilename = 'fooValue'
$query->filterByHtmlTemplateFileName('%fooValue%'); // WHERE htmltemplatefilename LIKE '%fooValue%'
in
MessageQuery at line 522
MessageQuery
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
MessageQuery at line 565
MessageQuery
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
MessageQuery at line 606
MessageQuery
filterByVersion(
mixed $version = null,
string $comparison = null)
Filter the query on the version column
Example usage:
$query->filterByVersion(1234); // WHERE version = 1234
$query->filterByVersion(array(12, 34)); // WHERE version IN (12, 34)
$query->filterByVersion(array('min' => 12)); // WHERE version > 12
in
MessageQuery at line 649
MessageQuery
filterByVersionCreatedAt(
mixed $versionCreatedAt = null,
string $comparison = null)
Filter the query on the versioncreatedat column
Example usage:
$query->filterByVersionCreatedAt('2011-03-14'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt('now'); // WHERE versioncreatedat = '2011-03-14'
$query->filterByVersionCreatedAt(array('max' => 'yesterday')); // WHERE versioncreatedat > '2011-03-13'
in
MessageQuery at line 687
MessageQuery
filterByVersionCreatedBy(
string $versionCreatedBy = null,
string $comparison = null)
Filter the query on the versioncreatedby column
Example usage:
$query->filterByVersionCreatedBy('fooValue'); // WHERE versioncreatedby = 'fooValue'
$query->filterByVersionCreatedBy('%fooValue%'); // WHERE versioncreatedby LIKE '%fooValue%'
in
MessageQuery at line 709
MessageQuery
filterByMessageI18n(
MessageI18n|ObjectCollection $messageI18n,
string $comparison = null)
Filter the query by a related \Thelia\Model\MessageI18n object
in
MessageQuery at line 732
MessageQuery
joinMessageI18n(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Adds a JOIN clause to the query using the MessageI18n relation
in
MessageQuery at line 767
MessageI18nQuery
useMessageI18nQuery(
string $relationAlias = null,
string $joinType = 'LEFT JOIN')
Use the MessageI18n relation MessageI18n object
in
MessageQuery at line 782
MessageQuery
filterByMessageVersion(
MessageVersion|ObjectCollection $messageVersion,
string $comparison = null)
Filter the query by a related \Thelia\Model\MessageVersion object
in
MessageQuery at line 805
MessageQuery
joinMessageVersion(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Adds a JOIN clause to the query using the MessageVersion relation
in
MessageQuery at line 840
MessageVersionQuery
useMessageVersionQuery(
string $relationAlias = null,
string $joinType = Criteria::INNER_JOIN)
Use the MessageVersion relation MessageVersion object
in
MessageQuery at line 854
MessageQuery
prune(
Message $message = null)
Exclude object from result
in
MessageQuery at line 869
int
doDeleteAll(
ConnectionInterface $con = null)
Deletes all rows from the message table.
in
MessageQuery at line 906
int
delete(
ConnectionInterface $con = null)
Performs a DELETE on the database, given a ChildMessage or Criteria object OR a primary key value.
in
MessageQuery at line 947
MessageQuery
recentlyUpdated(
int $nbDays = 7)
Filter by the latest updated
in
MessageQuery at line 959
MessageQuery
recentlyCreated(
int $nbDays = 7)
Filter by the latest created
in
MessageQuery at line 969
MessageQuery
lastUpdatedFirst()
Order by update date desc
in
MessageQuery at line 979
MessageQuery
firstUpdatedFirst()
Order by update date asc
in
MessageQuery at line 989
MessageQuery
lastCreatedFirst()
Order by create date desc
in
MessageQuery at line 999
MessageQuery
firstCreatedFirst()
Order by create date asc
in
MessageQuery at line 1015
MessageQuery
joinI18n(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query using the i18n relation
in
MessageQuery at line 1033
MessageQuery
joinWithI18n(
string $locale = 'en_US',
string $joinType = Criteria::LEFT_JOIN)
Adds a JOIN clause to the query and hydrates the related I18n object.
Shortcut for $c->joinI18n($locale)->with()
in
MessageQuery at line 1054
MessageI18nQuery
useI18nQuery(
string $locale = 'en_US',
string $relationAlias = null,
string $joinType = Criteria::LEFT_JOIN)
Use the I18n relation query object
in
MessageQuery at line 1068
static
boolean
isVersioningEnabled()
Checks whether versioning is enabled
in
MessageQuery at line 1076
static
enableVersioning()
Enables versioning
in
MessageQuery at line 1084
static
disableVersioning()
Disables versioning
in
MessageQuery at line 93
ChildMessageQuery
orderById($order = Criteria::ASC)
Order by the id column
in
MessageQuery at line 93
ChildMessageQuery
orderByName($order = Criteria::ASC)
Order by the name column
in
MessageQuery at line 93
ChildMessageQuery
orderBySecured($order = Criteria::ASC)
Order by the secured column
in
MessageQuery at line 93
ChildMessageQuery
orderByTextLayoutFileName($order = Criteria::ASC)
Order by the textlayoutfile_name column
in
MessageQuery at line 93
ChildMessageQuery
orderByTextTemplateFileName($order = Criteria::ASC)
Order by the texttemplatefile_name column
in
MessageQuery at line 93
ChildMessageQuery
orderByHtmlLayoutFileName($order = Criteria::ASC)
Order by the htmllayoutfile_name column
in
MessageQuery at line 93
ChildMessageQuery
orderByHtmlTemplateFileName($order = Criteria::ASC)
Order by the htmltemplatefile_name column
in
MessageQuery at line 93
ChildMessageQuery
orderByCreatedAt($order = Criteria::ASC)
Order by the created_at column
in
MessageQuery at line 93
ChildMessageQuery
orderByUpdatedAt($order = Criteria::ASC)
Order by the updated_at column
in
MessageQuery at line 93
ChildMessageQuery
orderByVersion($order = Criteria::ASC)
Order by the version column
in
MessageQuery at line 93
ChildMessageQuery
orderByVersionCreatedAt($order = Criteria::ASC)
Order by the versioncreatedat column
in
MessageQuery at line 93
ChildMessageQuery
orderByVersionCreatedBy($order = Criteria::ASC)
Order by the versioncreatedby column
in
MessageQuery at line 93
ChildMessageQuery
groupById()
Group by the id column
in
MessageQuery at line 93
ChildMessageQuery
groupByName()
Group by the name column
in
MessageQuery at line 93
ChildMessageQuery
groupBySecured()
Group by the secured column
in
MessageQuery at line 93
ChildMessageQuery
groupByTextLayoutFileName()
Group by the textlayoutfile_name column
in
MessageQuery at line 93
ChildMessageQuery
groupByTextTemplateFileName()
Group by the texttemplatefile_name column
in
MessageQuery at line 93
ChildMessageQuery
groupByHtmlLayoutFileName()
Group by the htmllayoutfile_name column
in
MessageQuery at line 93
ChildMessageQuery
groupByHtmlTemplateFileName()
Group by the htmltemplatefile_name column
in
MessageQuery at line 93
ChildMessageQuery
groupByCreatedAt()
Group by the created_at column
in
MessageQuery at line 93
ChildMessageQuery
groupByUpdatedAt()
Group by the updated_at column
in
MessageQuery at line 93
ChildMessageQuery
groupByVersion()
Group by the version column
in
MessageQuery at line 93
ChildMessageQuery
groupByVersionCreatedAt()
Group by the versioncreatedat column
in
MessageQuery at line 93
ChildMessageQuery
groupByVersionCreatedBy()
Group by the versioncreatedby column
in
MessageQuery at line 93
ChildMessageQuery
leftJoin($relation)
Adds a LEFT JOIN clause to the query
in
MessageQuery at line 93
ChildMessageQuery
rightJoin($relation)
Adds a RIGHT JOIN clause to the query
in
MessageQuery at line 93
ChildMessageQuery
innerJoin($relation)
Adds a INNER JOIN clause to the query
in
MessageQuery at line 93
ChildMessageQuery
leftJoinMessageI18n($relationAlias = null)
Adds a LEFT JOIN clause to the query using the MessageI18n relation
in
MessageQuery at line 93
ChildMessageQuery
rightJoinMessageI18n($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the MessageI18n relation
in
MessageQuery at line 93
ChildMessageQuery
innerJoinMessageI18n($relationAlias = null)
Adds a INNER JOIN clause to the query using the MessageI18n relation
in
MessageQuery at line 93
ChildMessageQuery
leftJoinMessageVersion($relationAlias = null)
Adds a LEFT JOIN clause to the query using the MessageVersion relation
in
MessageQuery at line 93
ChildMessageQuery
rightJoinMessageVersion($relationAlias = null)
Adds a RIGHT JOIN clause to the query using the MessageVersion relation
in
MessageQuery at line 93
ChildMessageQuery
innerJoinMessageVersion($relationAlias = null)
Adds a INNER JOIN clause to the query using the MessageVersion relation
in
MessageQuery at line 93
ChildMessage
findOne(
ConnectionInterface $con = null)
Return the first ChildMessage matching the query
in
MessageQuery at line 93
ChildMessage
findOneOrCreate(
ConnectionInterface $con = null)
Return the first ChildMessage matching the query, or a new ChildMessage object populated from the query conditions when no match is found
in
MessageQuery at line 93
ChildMessage
findOneById(
int $id)
Return the first ChildMessage filtered by the id column
in
MessageQuery at line 93
ChildMessage
findOneByName(
string $name)
Return the first ChildMessage filtered by the name column
in
MessageQuery at line 93
ChildMessage
findOneBySecured(
int $secured)
Return the first ChildMessage filtered by the secured column
in
MessageQuery at line 93
ChildMessage
findOneByTextLayoutFileName(
string $text_layout_file_name)
Return the first ChildMessage filtered by the textlayoutfile_name column
in
MessageQuery at line 93
ChildMessage
findOneByTextTemplateFileName(
string $text_template_file_name)
Return the first ChildMessage filtered by the texttemplatefile_name column
in
MessageQuery at line 93
ChildMessage
findOneByHtmlLayoutFileName(
string $html_layout_file_name)
Return the first ChildMessage filtered by the htmllayoutfile_name column
in
MessageQuery at line 93
ChildMessage
findOneByHtmlTemplateFileName(
string $html_template_file_name)
Return the first ChildMessage filtered by the htmltemplatefile_name column
in
MessageQuery at line 93
ChildMessage
findOneByCreatedAt(
string $created_at)
Return the first ChildMessage filtered by the created_at column
in
MessageQuery at line 93
ChildMessage
findOneByUpdatedAt(
string $updated_at)
Return the first ChildMessage filtered by the updated_at column
in
MessageQuery at line 93
ChildMessage
findOneByVersion(
int $version)
Return the first ChildMessage filtered by the version column
in
MessageQuery at line 93
ChildMessage
findOneByVersionCreatedAt(
string $version_created_at)
Return the first ChildMessage filtered by the versioncreatedat column
in
MessageQuery at line 93
ChildMessage
findOneByVersionCreatedBy(
string $version_created_by)
Return the first ChildMessage filtered by the versioncreatedby column
in
MessageQuery at line 93
array
findById(
int $id)
Return ChildMessage objects filtered by the id column
in
MessageQuery at line 93
array
findByName(
string $name)
Return ChildMessage objects filtered by the name column
in
MessageQuery at line 93
array
findBySecured(
int $secured)
Return ChildMessage objects filtered by the secured column
in
MessageQuery at line 93
array
findByTextLayoutFileName(
string $text_layout_file_name)
Return ChildMessage objects filtered by the textlayoutfile_name column
in
MessageQuery at line 93
array
findByTextTemplateFileName(
string $text_template_file_name)
Return ChildMessage objects filtered by the texttemplatefile_name column
in
MessageQuery at line 93
array
findByHtmlLayoutFileName(
string $html_layout_file_name)
Return ChildMessage objects filtered by the htmllayoutfile_name column
in
MessageQuery at line 93
array
findByHtmlTemplateFileName(
string $html_template_file_name)
Return ChildMessage objects filtered by the htmltemplatefile_name column
in
MessageQuery at line 93
array
findByCreatedAt(
string $created_at)
Return ChildMessage objects filtered by the created_at column
in
MessageQuery at line 93
array
findByUpdatedAt(
string $updated_at)
Return ChildMessage objects filtered by the updated_at column
in
MessageQuery at line 93
array
findByVersion(
int $version)
Return ChildMessage objects filtered by the version column
in
MessageQuery at line 93
array
findByVersionCreatedAt(
string $version_created_at)
Return ChildMessage objects filtered by the versioncreatedat column
in
MessageQuery at line 93
array
findByVersionCreatedBy(
string $version_created_by)
Return ChildMessage objects filtered by the versioncreatedby column
at line 26
static
Message
getFromName(
string $messageName)
Load a message from its name, throwing an excemtoipn is none is found.