from sanic_aioorm import AioOrm, AioModel
from peewee import Proxy, CharField
db = Proxy()

@AioOrm.regist
class User(AioModel):
    username = CharField()
    class Meta:
        database = db

from sanic import Sanic
from sanic.response import json
from sanic_aioorm import AioOrm
from ex_model import User, db
app = Sanic()
AioOrm.SetConfig(app, defaultdb="mysql://root:hsz881224@localhost:3306/test")
orm = AioOrm(app)
orm.init_proxys(defaultdb=db)
orm.create_tables(User=[{'username': "hsz"}, {'username': "jojo"}])

@app.get("/")
async def testget(request):
    try:
        users = await User.select()
    except Exception as e:
        return json({"error": str(e)})
    else:
        return json({"hello": [await u.to_dict() for u in users]})

@app.post("/")
async def testpost(request):
    try:
        users = await User.create(request.json)
    except Exception as e:
        return json({"error": str(e)})
    else:
        return json({"hello": [u.to_dict() for u in users]})

if __name__ == "__main__":
    app.run(host="0.0.0.0", port=4500)