Skip to content

Instantly share code, notes, and snippets.

@rejoan
Created September 17, 2015 19:51
Show Gist options
  • Save rejoan/d35e11adc0886ac3ae51 to your computer and use it in GitHub Desktop.
Save rejoan/d35e11adc0886ac3ae51 to your computer and use it in GitHub Desktop.
ps = [[a['id'],a['create_date'],a['name'],a['deadline']] for a in Project.objects.all().values()]
lm = [[Account.objects.values_list('username',flat=True).filter(id=int(b['user_id'])) for b in ProjectMember.objects.select_related().filter(project_id__id=int(a[0])).filter(member_type=1).values()] for a in ps]
nm = [[Account.objects.values_list('username',flat=True).filter(id=int(b['user_id'])) for b in ProjectMember.objects.select_related().filter(project_id__id=int(a[0])).filter(member_type=2).values()] for a in ps]
l = []
k = ['project_id', 'create_date', 'name','deadline', 'leaders','members']
for i in range(0,len(ps)) :
a = ps[i]
a.append(lm[i])
a.append(nm[i])
l.append(dict(zip(k,a)))
#partial code
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment