Laravel truncating table causing error during test

Question

I'm trying to truncate a table, but everytime I try to run it through a test I get a PDOException: There is no active transaction

I'm using the RefreshDatabase trait.

My code looks like this:

Model::query()->truncate();

Why are you truncating if the trait does it already for you ? — matiaslauriti, Mar 28 '21 at 02:07
@matiaslauriti I have actual logic doing truncate that I'm trying to test — Ezrab_, Mar 28 '21 at 14:08
Out of curiosity, why are you truncating a table in live code ? Why would you need to do that ? — matiaslauriti, Mar 28 '21 at 22:27

score 11 · Accepted Answer · answered Mar 30 '21 at 02:40

11

the error is caused by the truncate action

when you execute a truncate statement the transaction is committed and then the TRUNCATE is executed and cannot be undone.

This affects the RefreshDatabase trait which uses a transaction for each and every test.

here's how it runs

RefreshDatabase creates a transactions
You do something here with the database
you execute truncate
Truncate commits the transaction
RefreshDatabase tries to commit a transaction but will not be able to because it's already committed causing an error There is no active transaction

answered Mar 30 '21 at 02:40

Sean Reyes

Thank you for this answer, this makes sense. So how would one implement replacing all records in a database if truncate is not a good testing solution. – Ezrab_ Apr 01 '21 at 08:11
1

@Ezrab_ Are you using truncate to reset Incrementing ID? if NOT you can just use `DB::table('table_name')->delete();` which deletes all records in the database. – Sean Reyes Apr 05 '21 at 05:19
How we can prevent that? I need to reset autoincrement also – keizah7 Feb 22 '22 at 08:51

score 4 · Answer 2 · answered Oct 01 '21 at 09:10

4

Try to use the trait DatabaseMigrations instead of RefreshDatabase

answered Oct 01 '21 at 09:10

digout

2 Answers2