iphonebackuptools icon indicating copy to clipboard operation
iphonebackuptools copied to clipboard

Improvements to notes parsing

Open newtrawl opened this issue 1 year ago • 0 comments

This PR fixes some bugs with how notes were handled and adds support for the newer protocol buffer based ZDATA column.

Some of the old SQL queries were using incorrect join conditions and one of them was invalid SQL due to a typo. The new queries are based on information from https://github.com/threeplanetssoftware/apple_cloud_notes_parser/blob/master/lib/AppleNoteStore.rb and work correctly for the backups I have available for testing.

The newly added notestore.proto file needed for parsing the ZDATA column is copied from https://github.com/threeplanetssoftware/apple_cloud_notes_parser/blob/master/proto/notestore.proto and under MIT license.

I believe this PR resolves issue #50.

newtrawl avatar Mar 08 '23 23:03 newtrawl