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

queryTileChunk="""
SELECT x,y,type 
FROM tileChunk 
WHERE name=:name
""";

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

queryMoveChunk="""
UPDATE entity 
SET nx=x+:x,ny=y+:y 
WHERE name=:name
""";

def doMoveChunk(name,x,y):
  cur.execute(queryMoveChunk,{"x":x, "y":y, "name":name});