From 07163593ee29b60b688205af14433588e42c6498 Mon Sep 17 00:00:00 2001 From: Elrond Date: Fri, 16 Mar 2012 18:13:46 +0100 Subject: Create function to search media by slug. Searching media by slug is easy on mongo. But doing the joins in sqlalchemy is not as nice. So created a function for doing it. Well, and create the same function for mongo, so that it also works. --- mediagoblin/db/sql/util.py | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'mediagoblin/db/sql/util.py') diff --git a/mediagoblin/db/sql/util.py b/mediagoblin/db/sql/util.py index efb0fafe..60024b28 100644 --- a/mediagoblin/db/sql/util.py +++ b/mediagoblin/db/sql/util.py @@ -294,6 +294,15 @@ def check_media_slug_used(dummy_db, uploader_id, slug, ignore_m_id): return does_exist +def media_entries_for_tag_slug(dummy_db, tag_slug): + return MediaEntry.query \ + .join(MediaEntry.tags_helper) \ + .join(MediaTag.tag_helper) \ + .filter( + (MediaEntry.state == u'processed') + & (Tag.slug == tag_slug)) + + def clean_orphan_tags(): q1 = Session.query(Tag).outerjoin(MediaTag).filter(MediaTag.id==None) for t in q1: -- cgit v1.2.3