Phinx: Add Table::truncate() && AdapterInterface::truncateTable() methods

Created on 3 Dec 2015 · 9Comments · Source: cakephp/phinx

According to the wiki: It was officially introduced in the SQL:2008 standard.
And supported by all main database vendors / drivers.
Do Phinx need this feature?

feature

Source

samizdam

👍6

Most helpful comment

For those stumbling upon this issue (while this MR is not accepted), use this:

It's essentially what the MR from @edsonmedina does.

<?php
/* ... seed stuff ... */

$tableName = 'seed_table_name';
$table = $this->table($tableName);

// truncate table
$table->getAdapter()->execute(
    'TRUNCATE TABLE ' . $table->getAdapter()->quoteTableName($tableName)
);

// seed..
$table->insert($data)->save();

Techworker on 25 Jan 2017

👍2

All 9 comments

Phinx only needs this feature if it turns out to be increasingly popular amongst users. It might come in handy with Seeders, but i'll leave it for now.

robmorgan on 9 Dec 2015

@robmorgan I just found myself here because I need to truncate a table in a migration too. I'll hand roll mine for now, but could submit a PR for this feature if you wanted to reopen the issue?

WillGibson on 4 Mar 2016

👍1

@robmorgan nice work BTW. I'm here also as I need to truncate before running some seeders.

rickbolton on 13 Aug 2016

@WillGibson sure, feel free to contribute something! I think I have a use for this as well.

robmorgan on 15 Aug 2016

There is an active PR for this?

andretefras on 20 Oct 2016

Still waiting for this.

burnhamrobertp on 27 Dec 2016

👍2

For those stumbling upon this issue (while this MR is not accepted), use this:

It's essentially what the MR from @edsonmedina does.

<?php
/* ... seed stuff ... */

$tableName = 'seed_table_name';
$table = $this->table($tableName);

// truncate table
$table->getAdapter()->execute(
    'TRUNCATE TABLE ' . $table->getAdapter()->quoteTableName($tableName)
);

// seed..
$table->insert($data)->save();

Techworker on 25 Jan 2017

👍2

There is now a PR https://github.com/robmorgan/phinx/pull/978 for this feature.