Easy to use MySQL for sanic.
Project description
sanic-aiomysql
setup
install
pip install git+https://github.com/tuna2134/sanic-aiomysql.git
Use
from sanic import Sanic, response
from sanic_mysql import ExtendMySQL
app = Sanic("app")
ExtendMySQL(app, auto=True, user="root", host=127.0.0.1, password="hello", autocommit=True)
@app.get("/")
async def main(request):
await request.ctx.cursor.execute("CREATE TABLE data(name TEXT, value BIGINT)")
return response.text("create a table")
app.run()
or
from sanic import Sanic, response
from sanic_mysql import ExtendMySQL
app = Sanic("app")
ExtendMySQL(app, user="root", host=127.0.0.1, password="hello", autocommit=True)
@app.get("/")
async def main(request):
async with request.ctx.pool.acquire() as conn:
async with conn.cursor() as cursor:
await cursor.execute("CREATE TABLE data(name TEXT, value BIGINT)")
return response.text("create a table")
app.run()
or
from sanic import Sanic, response
from sanic_mysql import ExtendMySQL, cursor
app = Sanic("app")
ExtendMySQL(app, user="root", host=127.0.0.1, password="hello", autocommit=True)
@app.get("/")
@cursor()
async def main(request, connection, cursor):
await cursor.execute("CREATE TABLE data(name TEXT, value BIGINT)")
return response.text("create a table")
app.run()
