irissqlcli magic is not working on jupyter notebook

[grongierisc]

On a jupyter notebook the magic function is not working :

it says :

Warning: Input is not a terminal (fd=0).

Server:  InterSystems IRIS Version 2022.3.0.589 xDBC Protocol Version 65
Version: 0.4.0

---------------------------------------------------------------------------
RuntimeError                              Traceback (most recent call last)
Cell In[2], line 1
----> 1 get_ipython().run_line_magic('irissqlcli', 'iris://fhirsql:password@1.1.1.1:1972/FHIRDB')

File ~/git/iris-fhirsqlbuilder/.venv/lib/python3.9/site-packages/IPython/core/interactiveshell.py:2369, in InteractiveShell.run_line_magic(self, magic_name, line, _stack_depth)
   2367     kwargs['local_ns'] = self.get_local_scope(stack_depth)
   2368 with self.builtin_trap:
-> 2369     result = fn(*args, **kwargs)
   2370 return result

File ~/git/iris-fhirsqlbuilder/.venv/lib/python3.9/site-packages/irissqlcli/magic.py:38, in irissqlcli_line_magic(line)
     35     conn._irissqlcli = irissqlcli
     37 try:
---> 38     irissqlcli.run_cli()
     39 except SystemExit:
     40     pass

File ~/git/iris-fhirsqlbuilder/.venv/lib/python3.9/site-packages/irissqlcli/main.py:677, in IRISSqlCli.run_cli(self)
    675 while True:
    676     try:
--> 677         text = self.prompt_app.prompt()
    678     except KeyboardInterrupt:
    679         continue

File ~/git/iris-fhirsqlbuilder/.venv/lib/python3.9/site-packages/prompt_toolkit/shortcuts/prompt.py:1034, in PromptSession.prompt(self, message, editing_mode, refresh_interval, vi_mode, lexer, completer, complete_in_thread, is_password, key_bindings, bottom_toolbar, style, color_depth, cursor, include_default_pygments_style, style_transformation, swap_light_and_dark_colors, rprompt, multiline, prompt_continuation, wrap_lines, enable_history_search, search_ignore_case, complete_while_typing, validate_while_typing, complete_style, auto_suggest, validator, clipboard, mouse_support, input_processors, placeholder, reserve_space_for_menu, enable_system_prompt, enable_suspend, enable_open_in_editor, tempfile_suffix, tempfile, default, accept_default, pre_run, set_exception_handler, handle_sigint, in_thread)
   1031     with self._dumb_prompt(self.message) as dump_app:
   1032         return dump_app.run(in_thread=in_thread, handle_sigint=handle_sigint)
-> 1034 return self.app.run(
   1035     set_exception_handler=set_exception_handler,
   1036     in_thread=in_thread,
   1037     handle_sigint=handle_sigint,
   1038 )

File ~/git/iris-fhirsqlbuilder/.venv/lib/python3.9/site-packages/prompt_toolkit/application/application.py:978, in Application.run(self, pre_run, set_exception_handler, handle_sigint, in_thread)
    975     loop = new_event_loop()
    976     set_event_loop(loop)
--> 978 return loop.run_until_complete(
    979     self.run_async(
    980         pre_run=pre_run,
    981         set_exception_handler=set_exception_handler,
    982         handle_sigint=handle_sigint,
    983     )
    984 )

File /usr/local/Cellar/python@3.9/3.9.12/Frameworks/Python.framework/Versions/3.9/lib/python3.9/asyncio/base_events.py:623, in BaseEventLoop.run_until_complete(self, future)
    612 """Run until the Future is done.
    613 
    614 If the argument is a coroutine, it is wrapped in a Task.
   (...)
    620 Return the Future's result, or raise its exception.
    621 """
    622 self._check_closed()
--> 623 self._check_running()
    625 new_task = not futures.isfuture(future)
    626 future = tasks.ensure_future(future, loop=self)

File /usr/local/Cellar/python@3.9/3.9.12/Frameworks/Python.framework/Versions/3.9/lib/python3.9/asyncio/base_events.py:583, in BaseEventLoop._check_running(self)
    581 def _check_running(self):
    582     if self.is_running():
--> 583         raise RuntimeError('This event loop is already running')
    584     if events._get_running_loop() is not None:
    585         raise RuntimeError(
    586             'Cannot run the event loop while another loop is running')

RuntimeError: This event loop is already running

For the more the ipython-sql dependency is missing : pip install ipython-sql==0.4.0