-
|
Hello. The context. The question. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 15 replies
-
|
Hi @jefgoi It's not currently possible to do what you're asking but I believe it would be possible with a custom query function. I might be able to take a look at this later in the week. It shouldn't be difficult as each face has a unique ID and so the query would need to find all faces with no names then group these. In the meantime, the following will find all photos with unnamed faces and put them in the album "Unnamed Faces":
This downloads and runs the custom query function found here. |
Beta Was this translation helpful? Give feedback.
-
|
The PhotoDB.person_info property will give you a list of PersonInfo objects representing the people in the library. Each person will have a unique ID (uuid) so you can group persons by uuid. You can search for those that don't have a name defined then use the |
Beta Was this translation helpful? Give feedback.
-
|
Something like this should work to get the top 10: """Find unnamed faces by photo count"""
import osxphotos
def main():
photosdb = osxphotos.PhotosDB()
unnamed_persons = {}
for person in photosdb.person_info:
if person.name == "_UNKNOWN_":
try:
unnamed_persons[person.uuid] = len(person.photos)
except KeyError:
pass
top10 = sorted(unnamed_persons.items(), key=lambda x: x[1], reverse=True)[:10]
print(top10)
if __name__ == "__main__":
main()I had to put the try/except in there because there are people that don't have photos (for example, the photos were deleted but the person entry is still in the database). These caused an error when calling Also, "_UNKNOWN_" is a marker inserted by OSXPhotos for persons with no name. It's defined in |
Beta Was this translation helpful? Give feedback.
-
|
In general, with osxphotos you should not have to resort to the underlying SQL database when using OSXPhotos as the goal is to expose this data for you in a pythonic interface. Of course, there are some things that aren't implemented but you should find that almost everything you need is already exposed in OSXPhotos. See the API documentation |
Beta Was this translation helpful? Give feedback.
-
|
I decided this might actually be useful for me too so I whipped up a script that will find the top 10 unnamed faces and add them to albums automatically: """Find top 10 unnamed faces in Photos library and add them to albums."""
from osxphotos import PhotosDB
from osxphotos._constants import _UNKNOWN_PERSON
from osxphotos.photosalbum import PhotosAlbum
def get_person_photos(person_info):
"""Workaround for bug #1489 in osxphotos, will be fixed in next release"""
try:
return person_info.photos
except KeyError:
return []
def main():
"""Find top 10 unnamed faces in Photos library and add them to albums."""
photosdb = PhotosDB(verbose=print)
unnamed_persons = [p for p in photosdb.person_info if p.name == _UNKNOWN_PERSON]
print(f"Found {len(unnamed_persons)} unnamed persons")
top_10_unnamed = sorted(
unnamed_persons, key=lambda x: len(get_person_photos(x)), reverse=True
)[:10]
for p in top_10_unnamed:
photos = get_person_photos(p)
album_name = f"Unnamed person: {p.uuid} ({len(photos)})"
print(f"Creating album '{album_name}'")
album = PhotosAlbum(album_name)
album.add_list(photos)
if __name__ == "__main__":
main()This can be run directly from osxphotos via |
Beta Was this translation helpful? Give feedback.
-
|
Fantastic!!! Thanks a lot! PS Made small adjustment: I add only first 50 photos to the album. It’s enough to tag the person, and it works X times faster. |
Beta Was this translation helpful? Give feedback.
-
|
Thank you, this is great. |
Beta Was this translation helpful? Give feedback.
-
|
Hi @Conzpiral The following should work. This turned out to be a bit more complex that it should be because I discovered osxphotos doesn't give you access to manually added faces with no name (opened new issue #1493 to fix this). The following script which can be saved to "manually_added_faces.py" or downloaded from here can be run with You can also have osxphotos download the code and run it for you without saving it locally:
"""Find manually added faces in Photos library and add them to an album."""
import click
from osxphotos import PhotosDB
from osxphotos._constants import _DB_TABLE_NAMES
from osxphotos.photosalbum import PhotosAlbum
def get_person_photos(person_info):
"""Workaround for bug #1489 in osxphotos, will be fixed in next release"""
try:
return person_info.photos
except KeyError:
return []
@click.command()
@click.option(
"-u", "--unnamed", is_flag=True, help="Find only unnamed manually added faces"
)
@click.option(
"-a", "--album", help="Add photos to this album; default = 'Manual Faces'"
)
def main(unnamed: bool, album: str):
"""Find photos with manually added faces and add them to an album in Photos."""
photosdb = PhotosDB(verbose=print)
photos = photosdb.photos()
if unnamed:
# Currently, osxphotos doesn't provide API access to manually added faces with no associated person
# So need to query the database directly
photos_version = photosdb.photos_version
asset_table = _DB_TABLE_NAMES[photos_version]["ASSET"]
asset_fk = _DB_TABLE_NAMES[photos_version]["DETECTED_FACE_ASSET_FK"]
results = photosdb.execute(
f""" SELECT {asset_table}.ZUUID
FROM {asset_table}
INNER JOIN ZDETECTEDFACE
ON {asset_table}.Z_PK = {asset_fk}
WHERE ZDETECTEDFACE.ZMANUAL = 1 AND ZDETECTEDFACE.ZPERSON IS NULL;
"""
)
uuids = [r[0] for r in results]
manual_faces = photosdb.photos(uuid=uuids)
print(f"Found {len(manual_faces)} photos with unnamed manually added faces")
else:
manual_faces = [p for p in photos for f in p.face_info if f.manual]
print(f"Found {len(manual_faces)} photos with manually added faces")
if album is None:
album = "Manual Faces"
print(f"Adding photos to album '{album}'")
album = PhotosAlbum(album)
album.add_list(manual_faces)
if __name__ == "__main__":
main() |
Beta Was this translation helpful? Give feedback.
-
|
Thank you so much, I will try it now, this is one thing bothering me for years. Osxphotosis is incredible and have helped me out so much fixing my old Libraies, can't thank you enough, you are the best! |
Beta Was this translation helpful? Give feedback.
I decided this might actually be useful for me too so I whipped up a script that will find the top 10 unnamed faces and add them to albums automatically: