import sqlite3
con = sqlite3.connect('crawl.db');
cur = con.cursor();

def getTileChunk(chunkName):
  """
  query db for all tile in chunk of given name
  return list of tuple (x,y,tileTypeName)
  """
  queryTileChunk="""
  SELECT x,y,type 
  FROM tileChunk 
  WHERE name=:name
  """;
  cur.execute(queryTileChunk,{"name":name});
  return cur.fetchall();

def doMoveChunk(name,x,y):
  """
  update db and set next relative coordinate for the chunk
  """
  queryMoveChunk="""
  UPDATE entity 
  SET nx=x+:x,ny=y+:y 
  WHERE name=:name
  """;
  cur.execute(queryMoveChunk,{"x":x, "y":y, "name":name});

def cancelMoveChunk():
  pass

def commitChunk():
  pass