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

[samizdam]

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?

[robmorgan]

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.

[WillGibson]

@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?

[rickbolton]

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

[robmorgan]

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

[andre-pdassis]

There is an active PR for this?

[burnhamrobertp]

Still waiting for this.

[Techworker]

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

[piotr-cz]

There is now a PR #978 for this feature.

[robmorgan]

Merged to master in a10918d