error at execution

[jpsaunier]

Hi !

I have this error at execution of './pyinnodb.sh --fn cagnotteTransaction.ibd tosql --mode sql'

Traceback (most recent call last):
  File "/usr/lib/python3.10/runpy.py", line 196, in _run_module_as_main
    return _run_code(code, main_globals, None,
  File "/usr/lib/python3.10/runpy.py", line 86, in _run_code
    exec(code, run_globals)
  File "/home/jpierre85/ibd/./pyinnodb.sh/__main__.py", line 2, in <module>
  File "/home/jpierre85/ibd/./pyinnodb.sh/pyinnodb/cli/__init__.py", line 3, in <module>
  File "<frozen importlib._bootstrap>", line 1027, in _find_and_load
  File "<frozen importlib._bootstrap>", line 1002, in _find_and_load_unlocked
  File "<frozen importlib._bootstrap>", line 945, in _find_spec
  File "<frozen importlib._bootstrap_external>", line 1439, in find_spec
  File "<frozen importlib._bootstrap_external>", line 1411, in _get_spec
  File "<frozen zipimport>", line 170, in find_spec
  File "<frozen importlib._bootstrap>", line 431, in spec_from_loader
  File "<frozen importlib._bootstrap_external>", line 741, in spec_from_file_location
  File "<frozen zipimport>", line 229, in get_filename
  File "<frozen zipimport>", line 767, in _get_module_code
  File "<frozen zipimport>", line 696, in _compile_source
  File "/home/jpierre85/ibd/./pyinnodb.sh/pyinnodb/cli/sql.py", line 73
    f"INSERT INTO {table_name}({','.join(
    ^
SyntaxError: unterminated string literal (detected at line 73)

[WinChua]

@jpsaunier Thanks for your feedback. It's because of python3.10 not support multiline f-string. The problem has been fixed at the latest version.

Try to download the latest version with

wget https://github.com/WinChua/pyinnodb/releases/latest/download/pyinnodb.sh
chmod a+x pyinnodb.sh

Make sure that the version of pyinnodb.sh is 0.0.20

./pyinnodb.sh --version
0.0.20

Meanwhile, the mode option only support: "ddl", "dump", "sdi", so the cmdline you used should be:

./pyinnodb.sh --fn cagnotteTransaction.ibd tosql --mode dump