Use Model\Query object from Model`s static methods

Question

Use Model\Query object from Model`s static methods

Armen May '14

Created May '14	Last Reply May '14	Replies 1	Views 1066	Votes 0

Armen 1.7k

May '14

Hi,

public static function deleteAll(){
    $queryString = sprintf('DELETE FROM %s', self::getClass());

    $query = new Model\Query($queryString);
    $query->execute();
}

The code above does not works (because $query has no DI object). It doesnt throw errors eather, just silently drops request.

But if we use Model\Query\Builder to get Query object, $query will have proper DI object. So, this works:

public static function deleteAll(){
    $queryString = sprintf('DELETE FROM %s', self::getClass());

    $builder = new Model\Query\Builder();
    $mocQuery = $builder->from(self::getClass())->getQuery();

    $query = new Model\Query($queryString);
    $query->setDi($mocQuery->GetDi())
    $query->execute();
}

My questions is:

Where Model\Query\Builder gets DI object?
What is the correct way to make queries to DB from static methods like find or findFirst?

Ak-Army
2.0k

Accepted
answer

May '14

I was a problem too wiuth this, and than i found a working code:

$query = new Phalcon\Mvc\Model\Query("DELETE FROM Articles WHERE presence_id=:presence_id:", \Phalcon\DI\FactoryDefault::getDefault());
$query->execute(array('presence_id' => $presenceId));

Armen · Answer 1 · 2014-05-29T06:52:09-07:00

Indeed, this will work just as I want.

I need to be more attentitive. I just missed this part from Builders source code

if (Z_TYPE_P(dependency_injector) != IS_OBJECT) {
    dependency_injector = NULL;
    PHALCON_CALL_CE_STATIC(&dependency_injector, phalcon_di_ce, "getdefault");