ApiQuery

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

Returns a new ChildApiQuery object.

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);

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

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

Filter the query on the label column

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

Filter the query on the api_key column

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

Filter the query on the profile_id column

Example usage: $query->filterByProfileId(1234); // WHERE profileid = 1234 $query->filterByProfileId(array(12, 34)); // WHERE profileid IN (12, 34) $query->filterByProfileId(array('min' => 12)); // WHERE profile_id > 12

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'

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'

Filter the query by a related \Thelia\Model\Profile object

Adds a JOIN clause to the query using the Profile relation

Use the Profile relation Profile object

Exclude object from result

Deletes all rows from the api table.

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

Order by the api_key column

Order by the profile_id column

Order by the created_at column

Order by the updated_at column

Group by the id column

Group by the label column

Group by the api_key column

Group by the profile_id 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

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

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

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

Return the first ChildApi matching the query

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

Return the first ChildApi filtered by the id column

Return the first ChildApi filtered by the label column

Return the first ChildApi filtered by the api_key column

Return the first ChildApi filtered by the profile_id column

Return the first ChildApi filtered by the created_at column

Return the first ChildApi filtered by the updated_at column

Return ChildApi objects filtered by the id column

Return ChildApi objects filtered by the label column

Return ChildApi objects filtered by the api_key column

Return ChildApi objects filtered by the profile_id column

Return ChildApi objects filtered by the created_at column

Return ChildApi objects filtered by the updated_at column