yii2 - 如何从控制台截断表

Question

I have created a console command and I need to truncate a table.

Reading the Class reference: http://www.yiiframework.com/doc-2.0/yii-db-command.html#truncateTable()-detail I am not able to understand what files I need to include in order to execute this command.

I am including:

use yii\db\Command;
use yii\db\Connection;

but not sure which one is correct.

And I have tried to execute:

$command = Yii::$app->db->truncateTable('user');

which gives me the following error:

Exception 'yii\base\UnknownMethodException' with message 'Calling unknown method: yii\db\Connection::truncateTable()'

and:

Yii::$connection->createCommand()->truncateTable('user');

which gives me the following error:

PHP Fatal Error 'yii\base\ErrorException' with message 'Access to undeclared static property: Yii::$connection'

I really don't understand what I need to do.

Answer 1

Yii::$app->db->createCommand()->truncateTable('user')->execute();