class DatabaseInsertDemo(ApiGhost):
    __urls = api_router(["/database/insert"])

    @api_method
    async def get(self):
        """

        插入一条数据到表格
        访问地址：/api/database/insert

        """
        service: mysql.MysqlService = await self.obtain("MysqlService")(self.obtain("MysqlPoolService"))
        await service.execute("insert into user (name, age) values ('Lisys',20)")
        return "插入一条数据"


class DatabaseSelectDemo(ApiGhost):
    __urls = api_router(["/database/select"])

    @api_method
    async def get(self):
        """

        插入一条数据到表格
        访问地址：/api/database/select

        """
        service: mysql.MysqlService = await self.obtain("MysqlService")(self.obtain("MysqlPoolService"))
        data = await service.queryall("select * from user")
        return data