header("Importing jobs and tasks")
for job in session_v1.query(jobs):
with transaction.manager:
geometry = shapely.wkt.loads(job.geometry)
geometry = ST_Transform(shape.from_shape(geometry, 3857), 4326)
area = Area(geometry)
session_v2.add(area)
project = Project(job.title)
project.id = job.id
project.area = area
project.zoom = job.zoom
project.last_update = job.last_update
project.description = job.description
project.short_description = job.short_description
project.private = job.is_private
project.instructions = job.workflow
project.per_task_instructions = job.task_extra
project.imagery = job.imagery if job.imagery != 'None' else None
project.license_id = job.license_id
project.author_id = users[job.author.encode('utf-8')] \
if job.author else None
project.status = job.status
project.josm_preset = job.josm_preset
if job.featured:
project.priority = 1
header("Importing jobs and tasks")
for job in session_v1.query(jobs):
with transaction.manager:
geometry = shapely.wkt.loads(job.geometry)
geometry = ST_Transform(shape.from_shape(geometry, 3857), 4326)
area = Area(geometry)
session_v2.add(area)
project = Project(job.title)
project.id = job.id
project.area = area
project.zoom = job.zoom
project.last_update = job.last_update
project.description = job.description
project.short_description = job.short_description
project.private = job.is_private
project.instructions = job.workflow
project.per_task_instructions = job.task_extra
project.imagery = job.imagery if job.imagery != 'None' else None
project.license_id = job.license_id
project.author_id = users[job.author.encode('utf-8')] \
if job.author else None
project.status = job.status
project.josm_preset = job.josm_preset
if job.featured:
project.priority = 1
