How to truncate a table within the execution of an action?

[michaelklopf]

I have an import action that truncates a table and fills in all the data from an Excel file.

The action looks like this:

    /**
     * Perform the action on the given models.
     *
     * @return mixed
     */
    public function handle(ActionFields $fields, Collection $models)
    {
        DB::table('table_name')->truncate();

        Excel::import(new DataImport, $fields->fileField);
    }

The truncate is a DB transaction that is immediately executed. The handle method is wrapped by the framework in a DB::transaction statement (at least that's the impression I got when going through the framework code). This will result in the 500 error There is no active transaction. I have found the reason why that is in this issue laravel/framework#38260

Despite this, the items are all imported, but I see the error message in Nova and need to refresh the page to see the changes.

I know I can only delete items in the table, but I want the auto increment to be set back. This feels cleaner and more appropriate for the task that is done.

Is it possible to truncate the table outside of the DB::transaction context of the action? Something like a beforeActionIsExecuted?

[michaelklopf]

Push.