jimgreat/sanic_mysql

Mysql support for sanic

sanic_mysql's Issues

enable mogrify for query func

Hi there.

I think we can enable the mogrify func of pymysql.
It's more safe than just passing the string

Misunderstanding example in the README.md

Hi!

val = await request.app.mysql.query('select 10')

When I first saw this line, I felt strange about the use of request.app . Later I tried to remove the request and it works out fine.

Without docs, I think it should be recorrected for less misunderstandings.

ImportError: cannot import name 'log'

Running the example code...

from sanic import Sanic
from sanic.response import text
from sanic_mysql import SanicMysql 

app = Sanic(__name__)

app.config.update(dict(MYSQL=dict(host='127.0.0.1', port=3306,
                        user='root', password='pwd',
                        db='mysql')))

SanicMysql(app)

@app.route("/mysql")
async def mysq(request):
    val = await request.app.mysql.query('select 10')
    return text(val)
                        
app.run(host="0.0.0.0", port=8000, debug=True, workers=1)

... gives me the following error...

Traceback (most recent call last):
  File "main.py", line 4, in <module>
    from sanic_mysql import SanicMysql 
  File "/home/ubuntu/.local/lib/python3.6/site-packages/sanic_mysql/__init__.py", line 2, in <module>
    from .core import SanicMysql
  File "/home/ubuntu/.local/lib/python3.6/site-packages/sanic_mysql/core.py", line 1, in <module>
    from sanic.log import log
ImportError: cannot import name 'log'

what did i miss?