View Source Testing With Sqlite
Testing resources with SQLite generally requires passing async?: false to
your tests, due to SQLite's limitation of having a single write transaction
open at any one time.
This should be coupled with to make sure that Ash does not spawn any tasks.
config :ash, :disable_async?, true