I am using tap framework for testing my node application. While running the test I am making some changes in the database.
I want to revert all the changes made in the database after testing. Can anyone help me out of this?
Asked
Active
Viewed 459 times
0
-
You have followed the wrong approach, you put changes without backup the database, that is wrong. by the way which Database are you using? – Deep Kakkar Feb 20 '20 at 06:46
-
I'm using Postgres database – Alex Isaac Feb 20 '20 at 06:54
-
Is there any option for that in the tap framework itself? – Alex Isaac Feb 20 '20 at 06:56
-
No, I don't think there is any option. well what kind of changes you have done? – Deep Kakkar Feb 20 '20 at 06:59
-
I have created a new record in the table and deleted one record – Alex Isaac Feb 20 '20 at 07:05
-
I have posted an answer to your problem. Please check. – Deep Kakkar Feb 20 '20 at 07:46
1 Answers
0
No, you can't undo, rollback or reverse a commit.
Basically, restore from backup. If you can't, you might be able to recover with **pg_dirtyread**.
If you don't have backups, stop the whole server, take a disk image of the drive, and contact a $lots data recovery expert.
If you have committed the transaction, you cannot rollback or undo the update. Please find the detailed answer here.
There is one article about this pg_dirtyread here on medium.
Can I rollback a transaction I've already committed? (data loss)
Deep Kakkar
- 5,831
- 4
- 39
- 75