On Django Queryset

Question

CONSIDER THE MODELS BELOW:

from django.db import models

# Create your models here.

class Artists(models.Model):
AR_SIZE = (
("S", "Small"),
("M", "Medium"),
("L", "Large"),
)
name = models.CharField(max_length=60)
height = models.CharField(max_length=1, choices=AR_SIZE)
img = models.ImageField(upload_to="images/")
des = models.TextField()

def __str__(self):
return str(self.id) + str(self.name)

class Albums(models.Model):
artist = models.ForeignKey(Artists, on_delete=models.CASCADE)
title = models.CharField(max_length=90)
cover = models.ImageField(upload_to="images/cover/")

def __str__(self):
return str(self.artist) + " " + str(self.title)

class Songs(models.Model):
album = models.ForeignKey(Albums, on_delete=models.CASCADE)
s_title = models.CharField(max_length=80)
audio = models.FileField(default='')
runtime = models.CharField(max_length=8)

def __str__(self):
return str(self.album) + " " + str(self.s_title)

SO MY QUESTION IS HOW TO GET THE NAME, ID, OF THE ARTISTS FOR A PARTICULAR SONG? WITHOUT USING RAW SQL
THANKING YOU IN ADVANCE.

Answer 1

artist = Songs.objects.filter(album__artist__name="picasso")

Answer 2

Maybe this way using django orm dunder methods

Answer 3

https://docs.djangoproject.com/en/3.2/topics/db/examples/many_to_one/

This will be if greater help.