コード例 #1
0
ファイル: denorms.py プロジェクト: anentropic/django-denorm
 def get_related_where(self, fk_name, using, type):
     related_where = ["%s=%s.%s" % (self.model._meta.pk.get_attname_column()[1], type, fk_name)]
     related_query = Query(self.manager.related.model)
     for name, value in self.filter.iteritems():
         related_query.add_filter((name, value))
     related_query.add_extra(None, None,
         ["%s=%s.%s" % (self.model._meta.pk.get_attname_column()[1], type, self.manager.related.field.m2m_column_name())],
         None, None, None)
     related_query.add_count_column()
     related_query.clear_ordering(force_empty=True)
     related_query.default_cols = False
     related_filter_where, related_where_params = related_query.get_compiler(using=using,
         connection=connection).as_sql()
     if related_filter_where is not None:
         related_where.append('(' + related_filter_where + ') > 0')
     return related_where, related_where_params
コード例 #2
0
ファイル: denorms.py プロジェクト: jneight/django-denorm
 def get_related_where(self, fk_name, using, type):
     related_where = [
         "%s=%s.%s" %
         (self.model._meta.pk.get_attname_column()[1], type, fk_name)
     ]
     related_query = Query(self.manager.related.model)
     for name, value in self.filter.iteritems():
         related_query.add_filter((name, value))
     related_query.add_extra(None, None, [
         "%s=%s.%s" % (self.model._meta.pk.get_attname_column()[1], type,
                       self.manager.related.field.m2m_column_name())
     ], None, None, None)
     related_query.add_count_column()
     related_query.clear_ordering(force_empty=True)
     related_query.default_cols = False
     related_filter_where, related_where_params = related_query.get_compiler(
         using=using, connection=connection).as_sql()
     if related_filter_where is not None:
         related_where.append('(' + related_filter_where + ') > 0')
     return related_where, related_where_params