yii2 - how to truncate a table from console

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

Answer 2

Using yii2 migrate that default function

yii2 migrate

Step 1. Create a migrate

yii migrate/create truncate_table_xxx

Step2. Edit file xxx_truncate_table_xxx

Some thing like that

class m150101_185401_truncate_table_xxx extends Migration
{
   $this->dropTable('xxx')
}