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'])