How to test database interaction? Using TypeORM with MySQL for a forum project, looking for guidance on writing tests which involves the database.

Namely "I input this data, this row is expected to exist in this table", "I navigate to this page, this row from this table is expected to display in such a way on the page", etc. What are some guidelines / recommended practices I should consider in writing tests which involve the database? Should I make a separate copy of the real database(s) for testing purposes? Any guidance on how to approach database testing in Node, particularly with MySQL, would be much appreciated.

Submitted April 13, 2019 at 10:33PM by beefyjon