Advertisement
Guest User

Untitled

a guest
Jan 22nd, 2017
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. for each in StationIds:
  2. c.execute("SELECT"
  3. "AVG(SkewA),AVG(SkewB)"
  4. "FROM (SkewA,SkewB"
  5. "FROM Results WHERE Station1ID='%s' AND Year<='%s' AND Workday<'%s' ORDER BY Workday DESC LIMIT 14)" %
  6. (each['Station1ID'],YeaR,each['Workday']))
  7. Station1Data = c.fetchall()
  8. for each in StationIds:
  9. c.execute("SELECT"
  10. "AVG(SkewC),AVG(SkewD)"
  11. "FROM (SkewC,SkewD"
  12. "FROM Results WHERE Station2ID='%s' AND Year<='%s' AND Workday<'%s' ORDER BY Workday DESC LIMIT 14)" %
  13. (each['Station2ID'],YeaR,each['Workday']))
  14. Station2Data = c.fetchall()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement