Guest User

Untitled

a guest
Feb 28th, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. def conker(parser):
  2. import pymssql
  3. con = pymssql.connect(user="d", password="d", host="d", database="d");
  4. cur = con.cursor();
  5. borrow = settings.RGROUP_ID;
  6. # cur.execute("SELECT * FROM View_Papers WHERE (ResearchGroupID =%s and Year = '2006' ) " % borrow );
  7. cur.execute("SELECT * FROM View_Papers ");
  8. dog = cur.fetchall();
  9. bongo = "";
  10. title = "";
  11. cat = "";
  12. list2 = [];
  13. for x in dog:
  14. if x[1] != bongo:
  15. if bongo != "":
  16. list1 = [cat, title, num7, num8, num9, num10, num11, num12, num13]
  17. list2.append(list1)
  18. cat = ""
  19. title = x[6]
  20. num7 = x[7]
  21. num8 = x[8]
  22. num9 = x[9]
  23. num10 = x[10]
  24. num11 = x[11]
  25. num12 = x[12]
  26. num13 = x[13]
  27. cat += x[3]
  28. if x[5] != None:
  29. cat += ", "
  30. cat += x[5]
  31. cat += ". "
  32. bongo = x[1]
  33. else:
  34. cat += x[3]
  35. if x[5] != None:
  36. cat += ", "
  37. cat += x[5]
  38. list1 = [cat, title, num7, num8, num9, num10, num11, num12, num13]
  39. list2.append(list1)
  40. return render_to_response('publications/rdpapersnow.html', {'dog': list2, })
Add Comment
Please, Sign In to add comment