Skip to main content

Get original and actual filename MacOS Photo Library - SQL to link ZASSET with ZADDITIONALASSETATTRIBUTES. -

 

SELECT 
    a.ZDIRECTORY || '/' || a.ZFILENAME LocationOnFileSystem 
    , att.ZORIGINALFILENAME FROM ZADDITIONALASSETATTRIBUTES att
JOIN ZASSET a ON att.ZASSET = a.Z_PK
    -- WHERE att.ZORIGINALFILENAME = 'IMG_0938.JPG'
    WHERE a.ZFILENAME = '6E44872E-FA7C-424A-9136-6B0DC24D7E8F.jpeg'

NB: the photo is located at:
/Users/username/Pictures/Photos Library.photoslibrary/originals

The sqlite file is at:
/Users/username/Pictures/Photos Library.photoslibrary/database/Photos.sqlite


If you want the time, just grab , a.ZDATECREATED
This is the seconds since Monday, 1 January 2001 12:00:00 AM or 
"Apple Cocoa Core Data timestamp"

Comments

Post a Comment

Popular posts from this blog

Javascript Form Validation

It's real simple. All you need to do is call a javascript function in a html  " onsubmit " in the form tag as a javascript return, like this       <form method="post" action="dosomething.php" onsubmit="return validateForm();"> If the code completes ok, the form is then sent to the page listed in "action" http://www.w3schools.com/js/js_form_validation.asp If the function specified in the onsubmit returns false, then the form is not sent to the page mentioned in action.
Post a Comment
Read more