[FIXED] CakePHP 3: Truncate a table

Issue

How can I truncate a table with CakePHP 3.x

I get the truncate query by this:

$this->Coupons->schema()->truncateSql($this->Coupons->connection());

but what is the best practice to execute it

Solution

This code working well, thanks to @ndm for his comment that helped the answer to be better.

    //In Coupons Controller
    $this->Coupons->connection()->transactional(function ($conn) {
        $sqls = $this->Coupons->schema()->truncateSql($this->Coupons->connection());
        foreach ($sqls as $sql) {
            $this->Coupons->connection()->execute($sql)->execute();
        }
    });

Answered By - Eymen Elkum