theevilbit · August 27, 2024 09:42 · andrebsb · Aug 5, 2025 · theevilbit · Aug 6, 2025
diff --git a/parse_notificationdb_records.sh b/parse_notificationdb_records.sh
 #!/bin/bash

 # Check if the database path is provided as an argument
 if [ -z "$1" ]; then
    echo "Usage: $0 /path/to/your/database.sqlite"
    exit 1
 fi

 # Use the first argument as the database file path
 DB_PATH="$1"

 # Query to select the data column as hex from the record table
 SQL_QUERY="SELECT hex(data) FROM record;"

 # Execute the query and process each row
 sqlite3 "$DB_PATH" "$SQL_QUERY" | while read -r HEXDATA; do
    # Convert hex to binary and then to plist format
    echo "$HEXDATA" | xxd -r -p - | plutil -p -
 done
	#!/bin/bash

	# Check if the database path is provided as an argument
	if [ -z "$1" ]; then
	echo "Usage: $0 /path/to/your/database.sqlite"
	exit 1
	fi

	# Use the first argument as the database file path
	DB_PATH="$1"

	# Query to select the data column as hex from the record table
	SQL_QUERY="SELECT hex(data) FROM record;"

	# Execute the query and process each row
	sqlite3 "$DB_PATH" "$SQL_QUERY" \| while read -r HEXDATA; do
	# Convert hex to binary and then to plist format
	echo "$HEXDATA" \| xxd -r -p - \| plutil -p -
	done
No results found