mysqler 0.0.3

table manager for aiomysql.

MySQLer

Install

pip install MySQLer

Example

from mysqler import Table, StrColumn, IntColumn
from aiomysql import connect
import asyncio

class FavoritefoodTable(Table):
    user = IntColumn()
    food = StrColumn()
    
async def main():
    conn = await connect(host="127.0.0.1", password="", user="")
    async with conn.cursor() as cur:
        table = FavoritefoodTable()
        await cur.execute(table.create)
        await cur.execute(table.insert(user=938194919392, food="steak"))
        await conn.commit()
        await cur.execute(table.select(user=938194919392))
        print(await cur.fetchall())
        
    await conn.close()
    
asyncio.run(main())