import pyg
from pyg import *

import MySQLdb

con = MySQLdb.connect(host="localhost", user="root", passwd="root",db="ball")
cur = con.cursor();

physiQuery = """
UPDATE ball SET x = x+vx, y = y+vy,
vx = CASE WHEN x+vx>1024 OR x+vx<0 THEN -vx ELSE vx END,
vy = CASE WHEN y+vy>512 OR y+vy<0 THEN -vy ELSE vy END
""";

if __name__ == "__main__":
  while main():
    cur.execute(physiQuery);
    cur.execute("SELECT x,y FROM ball LIMIT 3000");
    lst = [];
    for data in cur.fetchall():
      x,y = data;
      circle(x,y);
    #cur.executemany("UPDATE ball SET x=%s, y=%s, vx=%s, vy=%s WHERE id=%s", lst);
  con.commit();
  cur.close();