Django model (sql) queries

This is a dump data

posts =leaveRegister.objects.filter(status='') #.values()



----------

geting releted joins

eg:-tables : User, leaveRegister, leaveType
    bs = leaveRegister.objects.all().select_related() #leaveType
    for b in bs:
       
        log.info(b.leaveType.status)
        log.info(b.hrId.username)
        log.info(b.uId.username)
        log.info("----------------------")


------------------dump------
    
    #posts = leaveRegister.objects.order_by('-pub_date')[:5]
    
    #cheese_blog = Blog.objects.get(name="Cheddar Talk")
    
    #posts = leaveRegister.objects.filter(status='' )
    
    #posts = leaveRegister.objects.get(status='' )
    
    posts =leaveRegister.objects.filter(status='') #.values()
    
    #claimed_opponents = User.objects.filter(gameclaim_opponent__me__user=claimer)
    
    #posts=leaveRegister.objects.all().select_related('leaveType')



-----------------------------------

get user by id

u = User.objects.get(request.POST['profile_id'])