Create examples directory with examples on how to approach specific problems

[fizyk]

• The examples have to be tested on CI
• It'd be enough to run them on a single Python version (highest supported)
• Each example should be in its test file.
• Additional dependencies required for the examples should be added to the 'examples' dependency category in Pipfile

Add examples:

• Examples to use SQLAlchemy with pytest-postgresql
• Examples on using SQLAlchemy and load function (ie to create schema) https://github.com/ClearcodeHQ/pytest-postgresql?tab=readme-ov-file#using-sqlalchemy-to-initialise-basic-database-state

[robmsmt]

Hi @fizyk , I was trying to get pytest-postgres working with SQLmodel (with FastAPI) which uses SQLAlchemy but had some issues getting the tests running as there are many existing tests using SQLite currently. If I provide an example attempt i'd be happy to use that as an example for this ticket. If it's okay with you I will create a separate issue with my problem.

[fizyk]

Sure! A separate issue would be perfect :)

[fizyk]

@robmsmt could you also check https://github.com/fizyk/pyramid_fullauth/tree/main/tests ?