Untitled

Django using the values method with m2m relationships / filtering m2m tables using django
class Book(models.Model):
    name = models.CharField(max_length=127, blank=False)

class Author(models.Model):
    name = models.CharField(max_length=127, blank=False)
    books = models.ManyToMany(Books)

[{id: 1, name: 'Grisham', books : [{name: 'The Client'},{name: 'The Street Lawyer}], ..]

Author.objects.all().values('name', 'books')

[{id: 1, name: 'Grisham', books :{name: 'The Client'}},{id: 1, name: 'Grisham', books :{name: 'The Street Lawyer'}}]

authors = Authors.objects.all().values('id')
q = Q()
for id in authors:
   q = q | Q(author__id = id)

#m2m author book table.. from my understanding it is
#not accessible in the django QuerySet
author_author_books.filter(q)  #grab all of the book ids and author ids with one query

authors = Author.objects.prefetch_related('books').all()

class BookAuthor(models.Model):
  book = models.ForeignKey(Book)
  author = models.ForeignKey(Author)

class Author(models.Model):
  name = models.CharField(max_length=127, blank=False)
  books = models.ManyToMany(Books, through=BookAuthor)