def confirm(self, ticket):
'Confirm changes'
# Send feedback
candidate = confirmPersonCandidate(ticket)
# If the candidate exists,
if candidate:
# Set
messageCode = 'updated' if candidate.person_id else 'created'
# Delete expired or similar candidates
Session.execute(model.person_candidates_table.delete().where((model.PersonCandidate.when_expired < datetime.datetime.utcnow()) | (model.PersonCandidate.username == candidate.username) | (model.PersonCandidate.nickname == candidate.nickname) | (model.PersonCandidate.email == candidate.email)))
Session.commit()
# If the candidate does not exist,
else:
# Set
messageCode = 'expired'
# Return
return redirect(url('person_login', url='/', messageCode=messageCode))
def confirm(self, ticket):
'Confirm changes'
# Send feedback
candidate = confirmPersonCandidate(ticket)
# If the candidate exists,
if candidate:
# Set
messageCode = 'updated' if candidate.person_id else 'created'
# Delete expired or similar candidates
Session.execute(model.person_candidates_table.delete().where(
(model.PersonCandidate.when_expired <
datetime.datetime.utcnow())
| (model.PersonCandidate.username == candidate.username)
| (model.PersonCandidate.nickname == candidate.nickname)
| (model.PersonCandidate.email == candidate.email)))
Session.commit()
# If the candidate does not exist,
else:
# Set
messageCode = 'expired'
# Return
return redirect(url('person_login', url='/', messageCode=messageCode))
def getSRID(proj4):
'Convert proj4 to srid'
# Simplify
proj4Simplified = simplifyProj4(proj4)
if not proj4Simplified:
raise model.GeoRegistryError('Must specify valid proj4 spatial reference')
# For each spatial reference,
for proj4Standard, srid in Session.execute('SELECT proj4text, srid FROM spatial_ref_sys'):
# Skip empty proj4s
if not proj4Standard.strip():
continue
# If we have a match,
if simplifyProj4(proj4Standard) == proj4Simplified:
return srid
# If we have no matches, raise exception
raise model.GeoRegistryError('Could not recognize proj4 spatial reference')
def tearDown(self):
Session.execute(model.feature_tags_table.delete())
Session.execute(model.features_table.delete())
Session.execute(model.tags_table.delete())
Session.commit()
except ValueError:
abort(
400,
'Could not parse simplified=%s as an integer' % simplified)
# If simplification is desired,
if simplified:
# If a bounding box is specified,
if bbox:
# Convert bounding box to a metric coordinate system
try:
multiPoint = shapely.wkb.loads(
str(
Session.execute(
geoalchemy.functions.wkb(
geoalchemy.functions.transform(
geoalchemy.WKTSpatialElement(
'MULTIPOINT(%s %s, %s %s)' %
(minY, minX, maxY, maxX),
srid), 3857))).fetchone()[0]))
except sa.exc.InternalError:
Session.rollback()
y1, x1, y2, x2 = -20037508.34, -20037508.34, 20037508.34, 20037508.34
else:
y1, x1 = multiPoint.geoms[0].coords[0]
y2, x2 = multiPoint.geoms[1].coords[0]
metersPerPixel = min(abs(x2 - x1), abs(y2 - y1)) / 256.
# If a bounding box is not specified,
else:
metersPerPixel = 0.2
# Define transformation in a metric coordinate system
simplify = lambda x: sa.func.ST_SimplifyPreserveTopology(
def tearDown(self):
Session.execute(model.feature_tags_table.delete())
Session.execute(model.features_table.delete())
Session.execute(model.tags_table.delete())
Session.commit()
# Return
return '\n'.join(str(x.id) for x in features)
def delete(self):
'Delete features'
# Authenticate via personID or key
personID = h.getPersonIDViaKey()
if not personID:
abort(401, 'Please log in or provide a valid key')
# Load featureIDs
featureIDs = request.params.get('featureIDs', '').splitlines()
if not featureIDs:
abort(400, 'Must specify at least one featureID in featureIDs')
# Make sure that the user has write access to the given featureIDs
try:
model.getWritableFeatures(featureIDs, personID)
except model.GeoRegistryError, error:
abort(400, str(error))
# Update timestamps for each tag
for tag in Session.query(model.Tag).join(model.Tag.features).filter(
model.Feature.id.in_(featureIDs)):
tag.updateTimestamp()
# Delete
Session.execute(
model.feature_tags_table.delete(
model.feature_tags_table.c.feature_id.in_(featureIDs)))
Session.execute(
model.features_table.delete(
model.features_table.c.id.in_(featureIDs)))
Session.commit()
# If a bounding box is not specified,
else:
restrict = lambda x: x
# Load simplified
simplified = request.params.get('simplified', 1)
try:
simplified = int(simplified)
except ValueError:
abort(400, 'Could not parse simplified=%s as an integer' % simplified)
# If simplification is desired,
if simplified:
# If a bounding box is specified,
if bbox:
# Convert bounding box to a metric coordinate system
try:
multiPoint = shapely.wkb.loads(str(Session.execute(geoalchemy.functions.wkb(geoalchemy.functions.transform(geoalchemy.WKTSpatialElement('MULTIPOINT(%s %s, %s %s)' % (minY, minX, maxY, maxX), srid), 3857))).fetchone()[0]))
except sa.exc.InternalError:
Session.rollback()
y1, x1, y2, x2 = -20037508.34, -20037508.34, 20037508.34, 20037508.34
else:
y1, x1 = multiPoint.geoms[0].coords[0]
y2, x2 = multiPoint.geoms[1].coords[0]
metersPerPixel = min(abs(x2 - x1), abs(y2 - y1)) / 256.
# If a bounding box is not specified,
else:
metersPerPixel = 0.2
# Define transformation in a metric coordinate system
simplify = lambda x: sa.func.ST_SimplifyPreserveTopology(geoalchemy.functions.transform(x, 3857), metersPerPixel)
# If simplification is not desired,
else:
simplify = lambda x: x
# Update timestamps for each tag
for tag in tags:
tag.updateTimestamp()
# Commit
Session.commit()
# Return
return '\n'.join(str(x.id) for x in features)
def delete(self):
'Delete features'
# Authenticate via personID or key
personID = h.getPersonIDViaKey()
if not personID:
abort(401, 'Please log in or provide a valid key')
# Load featureIDs
featureIDs = request.params.get('featureIDs', '').splitlines()
if not featureIDs:
abort(400, 'Must specify at least one featureID in featureIDs')
# Make sure that the user has write access to the given featureIDs
try:
model.getWritableFeatures(featureIDs, personID)
except model.GeoRegistryError, error:
abort(400, str(error))
# Update timestamps for each tag
for tag in Session.query(model.Tag).join(model.Tag.features).filter(model.Feature.id.in_(featureIDs)):
tag.updateTimestamp()
# Delete
Session.execute(model.feature_tags_table.delete(model.feature_tags_table.c.feature_id.in_(featureIDs)))
Session.execute(model.features_table.delete(model.features_table.c.id.in_(featureIDs)))
Session.commit()