Skip to content

Instantly share code, notes, and snippets.

@will

will/favs.sh

Last active September 26, 2024 07:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save will/d01b0014024aa59bcd68fc724baa9476 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save will/d01b0014024aa59bcd68fc724baa9476 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. will revised this gist Sep 17, 2024. 1 changed file with 14 additions and 4 deletions.
    18 changes: 14 additions & 4 deletions favs.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -1,9 +1,19 @@
    # copy database to avoid locks and messing up real database
    cd /tmp
    cp ~/Pictures/Photos\ Library.photoslibrary/database/Photos.sqlite photosdbcopy
    $ 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;'
    $ 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
    $ open ~/Pictures/Photos\ Library.photoslibrary/originals/E/E34F59CF-332D-40EB-80B2-48EDD30D5122.jpeg
  2. will created this gist Sep 17, 2024.
    9 changes: 9 additions & 0 deletions favs.sh
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,9 @@
    # 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;'

    # open first
    open ~/Pictures/Photos\ Library.photoslibrary/originals/E/E34F59CF-332D-40EB-80B2-48EDD30D5122.jpeg