def post(self, challenge_slug):
challenge = get_challenge_or_404(challenge_slug, instance_type=False,
abort_if_inactive=False)
parser = reqparse.RequestParser()
parser.add_argument('run', required=True,
help="Bulk inserts require a Run ID")
parser.add_argument('tasks', type=JsonTasks, required=True,
help="Bulk inserts require tasks")
run = args['run']
tasks = args['tasks'].data
results = []
for t in tasks:
task = Task(challenge.slug, t['id'])
task.instruction = t['text']
task.location = t['location']
task.manifest = t['manifest']
task.run = run
results.append(marshal(task), task_fields)
db.session.add(task)
db.session.flush()
action = Action(task.id, "created")
db.session.add(action)
# This is going to be a bit challenge specific
action = Action(task.id, "available")
db.session.add(action)
db.session.commit()
return jsonify(tasks=results)
def post(self, challenge_slug):
challenge = get_challenge_or_404(challenge_slug, instance_type=False,
abort_if_inactive=False)
parser = reqparse.RequestParser()
parser.add_argument('run', required=True,
help="Bulk inserts require a Run ID")
parser.add_argument('tasks', type=JsonTasks, required=True,
help="Bulk inserts require tasks")
run = args['run']
tasks = args['tasks'].data
results = []
for t in tasks:
task = Task(challenge.slug, t['id'])
task.instruction = t['text']
task.location = t['location']
task.manifest = t['manifest']
task.run = run
results.append(marshal(task), task_fields)
db.session.add(task)
db.session.flush()
action = Action(task.id, "created")
db.session.add(action)
# This is going to be a bit challenge specific
action = Action(task.id, "available")
db.session.add(action)
db.session.commit()
return jsonify(tasks=results)
def load_sampledata(path):
identifier = 0
tasks = []
actions = []
c = Challenge('test')
c.title = 'Just a test challenge'
with open(path, 'rb') as filehandle:
q = json.load(filehandle)
for feature in q['features']:
identifier += 1
coordinates = feature['geometry']['coordinates']
shape = Point(coordinates[0], coordinates[1])
properties = feature['properties']
t = Task('test',identifier)
t.location = dumps(shape)
t.run = 1
a = Action(t.id, "created")
tasks.append(t)
print tasks
feedengine = create_engine('postgresql://*****:*****@localhost/maproulette')
Session = sessionmaker(bind=feedengine)
session = Session()
session.add(c)
session.commit()
for t in tasks:
session.add(t)
for a in actions:
session.add(a)
c.active = True
session.commit()
# generate a unique identifier
identifier = str(uuid.uuid4())
# instantiate the task and register it with challenge 'test'
# Initialize a task with its challenge slug and persistent ID
task = Task(challenge.slug, identifier)
# create two random points not too far apart
p1 = Point(
random.randrange(minx, maxx) + random.random(),
random.randrange(miny, maxy) + random.random())
p2 = Point(
p1.x + (random.random() * random.choice((1, -1)) * 0.01),
p1.y + (random.random() * random.choice((1, -1)) * 0.01))
# create a linestring connecting the two points
# no constructor for linestring from points?
l1 = LineString([(p1.x, p1.y), (p2.x, p2.y)])
# generate some random 'osm ids'
osmids = [random.randrange(1000000, 1000000000) for _ in range(2)]
# add the first point and the linestring to the task's geometries
task.geometries.append(TaskGeometry(osmids[0], p1))
task.geometries.append(TaskGeometry(osmids[1], l1))
# and add the first point as the task's location
task.location = p1
# generate random string for the instruction
task.instruction = ' '.join([random.choice(words.split())
for _ in range(15)])
# add the task to the session
db.session.add(task)
# commit the generated tasks and the challenge to the database.
db.session.commit()
def create_testdata():
"""Creates test data in the database"""
import uuid
import random
from maproulette.models import db, Challenge, Task, TaskGeometry, Action
from shapely.geometry import Point, LineString, box
num_challenges = 10
num_tasks = 100
# the gettysburg address
challenge_help_test = "Sample challenge *help* text"
challenge_instruction_test = "Challenge instruction text"
task_instruction_text = "Task instruction text"
# delete old tasks and challenges
db.session.query(TaskGeometry).delete()
db.session.query(Action).delete()
db.session.query(Task).delete()
db.session.query(Challenge).delete()
db.session.commit()
for i in range(1, num_challenges + 1):
print "Generating Test Challenge #%d" % i
minx = -120
maxx = -40
miny = 20
maxy = 50
challengepoly = None
slug = "test%d" % i
title = "Test Challenge %d" % i
challenge = Challenge(slug, title)
challenge.difficulty = random.choice([1, 2, 3])
challenge.active = True
challenge.blurb = "This is test challenge number %d" % i
challenge.description = "This describes test challenge %d in detail" % i
challenge.help = challenge_help_test
challenge.instruction = challenge_instruction_test
# have bounding boxes for all but the first two challenges.
if i > 2:
minx = random.randrange(-120, -40)
miny = random.randrange(20, 50)
maxx = minx + 1
maxy = miny + 1
challengepoly = box(minx, miny, maxx, maxy)
print "\tChallenge has a bounding box of ", challengepoly
challenge.polygon = challengepoly
db.session.add(challenge)
# add some tasks to the challenge
print "\tGenerating %i tasks for challenge %i" % (num_tasks, i)
# generate NUM_TASKS random tasks
for j in range(num_tasks):
# generate a unique identifier
identifier = str(uuid.uuid4())
# instantiate the task and register it with challenge 'test'
# Initialize a task with its challenge slug and persistent ID
task = Task(challenge.slug, identifier)
# create two random points not too far apart
p1 = Point(random.randrange(minx, maxx) + random.random(), random.randrange(miny, maxy) + random.random())
p2 = Point(
p1.x + (random.random() * random.choice((1, -1)) * 0.01),
p1.y + (random.random() * random.choice((1, -1)) * 0.01),
)
# create a linestring connecting the two points
# no constructor for linestring from points?
l1 = LineString([(p1.x, p1.y), (p2.x, p2.y)])
# generate some random 'osm ids'
osmids = [random.randrange(1000000, 1000000000) for _ in range(2)]
# add the first point and the linestring to the task's geometries
task.geometries.append(TaskGeometry(osmids[0], p1))
task.geometries.append(TaskGeometry(osmids[1], l1))
# and add the first point as the task's location
task.location = p1
# generate random string for the instruction
task.instruction = task_instruction_text
# add the task to the session
db.session.add(task)
# commit the generated tasks and the challenge to the database.
db.session.commit()
