Maccy recover cleared clipboards

[spekkii]

Hi everyone!

I cleared my clipboard, which had important info that I needed to save. Is there any way to recover the deleted clipboard history?

[spekkii]

I used #809 to get the Storage.sqlite and Storage.sqlite-wal files, as the cleared clipboard history should still be in the Storage.sqlite-wal.

1. I then copied the folder ('/Users/xxxx/Library/Containers/org.p0deje.Maccy/Data/Library/Application Support/Maccy) and committed the WAL changes to the main database by running the command in the copied folder:
   sqlite3 Storage.sqlite "PRAGMA wal_checkpoint(FULL);"
2. Next, I opened the Storage.sqlite. I used DB Browser for SQLite.
3. Open the ZHISTORYITEMCONTENT table and filter by ZTYPE according to the type of copy it was (mine was plain text, so I filtered by public.utf8-plain-text).

That's how I recovered it, in case someone else might need to do the same!