for tile in session_v1.query(tiles).filter(tiles.c.job_id == job.id):
step = max / (2**(tile.zoom - 1))
tb = TileBuilder(step)
geometry = tb.create_square(tile.x, tile.y)
geometry = ST_Transform(shape.from_shape(geometry, 3857), 4326)
task = Task(tile.x, tile.y, tile.zoom, geometry)
task.project_id = project_id
session_v2.add(task)
session_v2.flush()
d = TaskState.__table__.delete(
and_(TaskState.project_id == job.id,
TaskState.task_id == task.id))
session_v2.execute(d)
d = TaskLock.__table__.delete(
and_(TaskLock.project_id == job.id,
TaskLock.task_id == task.id))
session_v2.execute(d)
# initial state
task_state = TaskState()
task_state.date = datetime.datetime(2010, 01, 01)
task_state.task_id = task.id
task_state.project_id = project_id
session_v2.add(task_state)
# initial state
task_lock = TaskLock()
tb = TileBuilder(step)
geometry = tb.create_square(tile.x, tile.y)
geometry = ST_Transform(shape.from_shape(geometry, 3857), 4326)
task = Task(tile.x, tile.y, tile.zoom, geometry)
task.project_id = project_id
session_v2.add(task)
session_v2.flush()
d = TaskState.__table__.delete(
and_(
TaskState.project_id == job.id,
TaskState.task_id == task.id
)
)
session_v2.execute(d)
d = TaskLock.__table__.delete(
and_(
TaskLock.project_id == job.id,
TaskLock.task_id == task.id
)
)
session_v2.execute(d)
# initial state
task_state = TaskState()
task_state.date = datetime.datetime(2010, 01, 01)
task_state.task_id = task.id
task_state.project_id = project_id
session_v2.add(task_state)
