Last active
September 17, 2024 19:46
-
-
Save will/d01b0014024aa59bcd68fc724baa9476 to your computer and use it in GitHub Desktop.
apple photos favorites
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # copy database to avoid locks and messing up real database | |
| $ cd /tmp | |
| $ cp ~/Pictures/Photos\ Library.photoslibrary/database/Photos.sqlite photosdbcopy | |
| # get favorites | |
| $ sqlite3 photosdbcopy 'select a.ZUUID, cm.ZORIGINALFILENAME from ZASSET a JOIN ZCLOUDMASTER cm ON a.ZMASTER = cm.Z_PK where a.ZFAVORITE=1 limit 10;' | |
| E34F59CF-332D-40EB-80B2-48EDD30D5122|IMG_0125.JPG | |
| BFDEF572-1E73-4187-99CD-F3B22A8A0349|IMG_0444.JPG | |
| 21D1788D-D0A0-4C03-BD8E-BE32B11C179D|IMG_0490.JPG | |
| 12755BB5-C836-4ED0-8915-2E0BE685E9B4|IMG_0521.JPG | |
| 62AE5F04-337D-459A-A01F-495BD5631C1E|IMG_0601.JPG | |
| 8AD15346-9179-4C0A-9EBD-5C39CE6B7BF2|IMG_0804.JPG | |
| BADD3BBB-DF21-4083-8074-C969067F05F5|IMG_0854.JPG | |
| CC9A7035-9DBB-4ED9-A0B6-3049FEF94D0E|IMG_0888.JPG | |
| 9E84DA97-0AAC-4088-A613-C9B7DC788BFC|IMG_0906.PNG | |
| DE1572D9-00C9-494E-9DBD-C84BC5BA9C48|IMG_0913.JPG | |
| # open first | |
| $ open ~/Pictures/Photos\ Library.photoslibrary/originals/E/E34F59CF-332D-40EB-80B2-48EDD30D5122.jpeg |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment