It can’t work

[adk23333]

class ForumExecutor(MysqlExecutor):
    async def create_table_forum(self) -> None:
        """
        create forum
        """
        query = "CREATE TABLE IF NOT EXISTS `forum` (`fid` INT PRIMARY KEY, `fname` VARCHAR(36) UNIQUE NOT NULL)"
        await self.execute(query)

class MyTestCase(unittest.TestCase):
    loop = asyncio.get_event_loop()
    async def run_i(self, dsn: str = ""):
        try:
            mayim = Mayim(dsn=dsn, executors=[ForumExecutor])
            forum_executor = Mayim.get(ForumExecutor)
            await forum_executor.create_table_forum()
            return True
        except Exception as err:
            traceback.print_exc()
            return False

    def test_forum(self):
        self.loop.run_until_complete(self.run_i(dsn="mysql://root:[email protected]:3306/aiotieba"))


if __name__ == '__main__':
    unittest.main()

Traceback (most recent call last):
  File "E:\pythonProject\aiotieba-reviewer-orm\test_mayim_database.py", line 18, in run_i
    await forum_executor.create_table_forum()
  File "E:\pythonProject\aiotieba-reviewer-orm\aiotieba_reviewer\_database.py", line 21, in create_table_forum
    await self.execute(query)
  File "E:\pythonProject\tiebaAdmin\tiebaAdmin-api\venv\Lib\site-packages\mayim\sql\executor.py", line 92, in _execute
    model, _ = self._context.get()
               ^^^^^^^^^^^^^^^^^^^
LookupError: <ContextVar name='_context' at 0x000002E17FDD1AD0>

How do I solve it?

[ahopkins]

Take a look at the simple example here: https://ahopkins.github.io/mayim/guide/#how

from mayim import query

class ForumExecutor(MysqlExecutor):
	@query("CREATE TABLE IF NOT EXISTS `forum` (`fid` INT PRIMARY KEY, `fname` VARCHAR(36) UNIQUE NOT NULL)")
    async def create_table_forum(self) -> None:
        """
        create forum
        """

[adk23333]

Take a look at the simple example here: https://ahopkins.github.io/mayim/guide/#how

The guide did not mention that connecting to the SQL server requires these