[Misc]: Integration testing with resources

[jonaro00]

#[shuttle_runtime::test] macro and cargo shuttle test that allows integration tests with the same resources as the main function gets.
An alternative approach could be to use testcontainers.

Related:

• #1547
• #1479

---

_{This issue is a part of the Product Feature Poll (all issues). React with 👍 if you want this feature. Comment if you have suggestions related to this feature.}