Database Connection
sqlite
import asyncio
from aiopyql import data
async def main():
sqlite_db = await data.Database.create(
database="testdb",
cache_enabled=True
)
Postgres
import asyncio
from aiopyql import data
async def main():
mysql_db = await data.Database.create(
database='postgres_database',
user='postgres',
password='my-secret-pw',
host='localhost',
port=5432,
db_type='postgres'
)
asyncio.run(main())
Mysql
import asyncio
from aiopyql import data
async def main():
mysql_db = await data.Database.create(
database='mysql_database',
user='mysqluser',
password='my-secret-pw',
host='localhost',
port=3306,
db_type='mysql'
)
asyncio.run(main())
Schema Discovery
Existing tables schemas within databases are loaded when database object is instantiated via Database.create()