Add ability to create new database per test case

[Ghost-str]

Description

Add ability to create and delete new database per test case for isolation purpose.

Expected Behavior

#[tokio::test]
async fn  test_name() {
   configure_insta!();
   let uuid = uuid();
   let appConfig= testing::create_test_database_with_postfix(&uuid).await.unwraup;
   let boot = testing::boot_test_with_custom_config::<App>(appConfig).await.unwrap;

   ... test body ....

   testing::remove_test_database_with_postfix(&uuid).await.unwraup;
}

Environment:

test

[kaplanelad]

Could you please clarify the reasoning behind this request?

[Ghost-str]

If you remove #[serial] for tests, then the tests begin to influence each other.
I think it would be more convenient if for each element of the infrastructure it was possible to isolate the application when running tests.
I think that over long distances this will help to perform tests faster

[NexVeridian]

we should probably use #[sqlx::test]

it seems to be working ok for #1204

some info from here, Under the hood, this is [what sqlx does]:

It connects to the database specified in the DATABASE_URL environment variable.
It creates a new database with a random name.
(Optional) It runs all the migrations in the migrations directory.
It creates a connection pool to the new database.
It passes the connection pool to your test function.
It waits for the test to complete.
It deletes the database.