Connection pool is incompatible with Python 3.9 issue fix

[HorusTheSonOfOsiris]

What do these changes do?

The await with keyword is no longer supported in python and has been replaced with async keyword. This release fixes the connection pool is incompatible error which was raised while making a connection request to sql server.

According to the official documentation, the asyncio.Condition object should be handled using an async with construct instead of a with with an await expression as done in aiodbc.

#294

[HorusTheSonOfOsiris]

I have fixed the pool.py and code is working alright.

[singlecheeze]

:tada: Thank you!!!!

[ia-Simon]

Thank you very much, I just bumped into this problem. Someone accept this PR please!

[andreheringer]

I've just bumped into this same issue. Please either accept this PR or edit the documentation so it's clear that the project does not support Python 3.9 atm.

[apisarenco]

I'll just base my dependencies on this fork for now :P

Thank you very much for this fix, Horus, son of Osiris

[HorusTheSonOfOsiris]

I'll just base my dependencies on this fork for now :P

Thank you very much for this fix, Horus, son of Osiris

All good, mate.

[CoonCat21]

Will this be merged sometime soon?

[apisarenco]

The original project seems abandoned. I doubt that you're gonna get any more changes.

Consider using a fork like this one instead, or do what I eventually did - write my own code, based on the old one, that does the minimum needed features, with thanks to original developers, and attribution to their work. I hope they're fine and healthy.