Current pytest code has resource exhaustion issues

[bymoye]

Another thing is.... In the current pytest, it seems that the connection is not disconnected in the end. So the resources are always occupied. (The connection is not released correctly)

Originally posted by @bymoye in https://github.com/psqlpy-python/psqlpy/issues/148#issuecomment-3032535612