This is a repository for basic practing with SQLAlchemy Core.
In session 3, I learn how to use SQLAlchemy Core with AsyncIO. Especially in orm.py file, run corouting and async with to connect to database using ORM.
Note: connect_core.py is the core routine to connect to database and run asynchrounousIO.
coroutine is a function that can suspend its execution before reaching return, and it can resume from the same point later. It can be used to write asynchronous code in a synchronous style.
AsyncIO is a library to write concurrent code using the async/await syntax. IO means input and output, and the library is designed to be used for input and output operations. It is often used to write servers and other networked programs.
❓ QA: Why and how can we be able to close connection in SQLAlchemy Core in case we have been able to connect to our SQL Alchemy using AsyncIO?
We provide with a method that we call that is going to help us to close our connection after connecting to our database using SQLAlchemy and AsyncIO. That method is going to be the dispose method so if you want to access that dispose method what you shall have to do within a coroutine is to call the dispose method on the engine object.
await engine.dispose()if you set connect is false, you can use async with to close the connection automatically.
🈯 If you are interested other SQLAlchemy tutorial I recommended, check my previous practice.