Get Command query results as models instead of associative arrays, or turn them into it, in Yii2

Question

I want to run a prepared query in Yii using createCommand, but get results as models instead of associative arrays.

class Fruit extends ActiveRecord {
    public function eat() {return this;};
}

// This will be an extremely complicated query so I need
// to write it raw without any kind of query builder
$rows = Yii::$app->db->createCommand('SELECT * FROM fruits WHERE color = :color')
    ->bindValue('color', 'blue')->queryAll();

$fruits = magicallyTurnIntoFruit($rows);

$fruits[0]->eat()->save();

How do accomplish this?

why dont you use `ActiveQuery` like `Fruits::find()->all()` – Muhammad Omer Aslam Feb 05 '18 at 00:25 — Muhammad Omer Aslam, Feb 05 '18 at 00:25
I want to run a sql query without any kind of query builder – A. Ding Feb 05 '18 at 00:35 — A. Ding, Feb 05 '18 at 00:35

Ali MasudianPour · Accepted Answer · 2018-02-05T06:11:38.497

0

You can use findBySql as official doc describes it here.

As an example:

$customers = Customer::findBySql('SELECT * FROM customer')->all();

In case you need to create your SQL using QueryBuilder, and use it in findBySql, you can refer to this question or similar!

edited Feb 05 '18 at 06:11

answered Feb 05 '18 at 04:50

Ali MasudianPour

14,329
3
60
62

1

That is it! Thank you! – A. Ding Feb 05 '18 at 13:49

Get Command query results as models instead of associative arrays, or turn them into it, in Yii2

1 Answers1