Can not MultiByteStrDecoder is QueryItem #bug

[bindi-mo]

in execute_query method (core.py)

MultiByteStrDecoder(query) is ValueError

Please fix is MultiByteStrDecoder(str(query)).unicode_str

[thombashi]

@bindi-mo
Thank you for your report.
Unfortunately, I was not able to reproduce the error.
Could you provide some code to reproduce the error?

[bindi-mo]

query is str or QueryItem.

MultiByteStrDecoder(QueryItem) is ValueError

Checking instances are str or byte in MultiByteStrDecoder

isinstance(self.__encoded_str, (str, bytes)):

>>> from mbstrdecoder import MultiByteStrDecoder
>>> from simplesqlite.query import Select
>>> query = Select('*', 'article')
>>> MultiByteStrDecoder(query)
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "/home/bindi/.local/lib/python3.12/site-packages/mbstrdecoder/_mbstrdecoder.py", line 149, in __init__
    self.__validate_str()
  File "/home/bindi/.local/lib/python3.12/site-packages/mbstrdecoder/_mbstrdecoder.py", line 160, in __validate_str
    raise ValueError(f"value must be a string: actual={type(self.__encoded_str)}")
ValueError: value must be a string: actual=<class 'simplesqlite.query.Select'>
>>>

my fix code:

diff -ur simplesqlite/core.py /home/bindi/.local/lib/python3.12/site-packages/simplesqlite/core.py
--- simplesqlite/core.py        2025-02-18 22:45:25.619217434 +0900
+++ /home/bindi/.local/lib/python3.12/site-packages/simplesqlite/core.py        2025-01-20 22:10:13.084544748 +0900
@@ -353,13 +356,13 @@
             file_path, line_no, func_name = caller[:3]

             raise OperationalError(
-                message="\n".join(
+                "\n".join(
                     [
                         "failed to execute query at {:s}({:d}) {:s}".format(
                             file_path, line_no, func_name
                         ),
-                        f"  - query: {MultiByteStrDecoder(query).unicode_str}",
-                        f"  - msg:   {e}",
+                        f"  - query: {MultiByteStrDecoder(str(query)).unicode_str}",
+                        f"  - msg:   {str(e)}",
                         f"  - db:    {self.database_path}",
                     ]
                 )

[thombashi]

Fixed at SimpleSQLite 1.5.4