On 01/09/2022 20:00, Jonathan Vanasco wrote:

 > Create an empty schema from the models using create_all?

This is what I usually do with smaller projects.

When taking this approach, how do you ensure the accumulated schema migrations end up with a database that matches the one that create_all gives you?

When using unittest, some tests will use a fresh DB per test-run, others per-class, and others per-test.

Yeah, pytest fixture scoping gives a great way to set these up.

Sometimes the tests dictate that, other times I control that with env vars.  That gives us the flexibility to work on a small section and do efficient test runs during development.

Creating a database for every unit test feels like something that would be slow enough to be annoying. How are you creating databases such that it's fast enough for this not to be the case?

Chris

--
SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/d779d7ad-1eff-e4e8-1f9c-9979b80a9146%40withers.org.

Reply via email to