Solved thread

This post is marked as solved. If you think the information contained on this thread must be part of the official documentation, please contribute submitting a pull request to its repository.

Use Model\Query object from Model`s static methods

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:

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


1.4k
Accepted
answer

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


1.1k

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