PyBitmessage icon indicating copy to clipboard operation
PyBitmessage copied to clipboard
verified publisher icon Bitmessage

Quick workaround for BLOB as TEXT problem (#2247)

Open kashikoibumi opened this issue 1 year ago • 1 comments

Quick workaround for BLOB as TEXT problem (#2247).

This patch fixes each SQL query to be both workable with BLOB-keys and TEXT-keys. In each query, it tries first BLOB-key by using sqlite3.Binary() function. When it failed, then it tries next TEXT-key by using CAST(? AS TEXT) syntax.

The modifications are all around the code base where SQL queries exist, but the logic is simple.

kashikoibumi avatar May 30 '24 09:05 kashikoibumi

I have added a script to revert the BLOB-keys into TEXT-keys.

  • revert_blob_to_text.sh

By applying this script, old version of PyBitmessage before this patch can be run again.

kashikoibumi avatar May 30 '24 12:05 kashikoibumi