def post(self, event_slug=None):
configuration = customer_configuration.get_configuration(self.request)
original_master = fusion_tables.select_first(configuration['master table'], condition="'event slug' = '%s'" % event_slug)[0]
data = self.request.POST['data']
master = json.loads(data)
master['location slug'] = location_slug(master)
# check if the new location is in use, if so, reuse it's location slug
same_location_condition = "ST_INTERSECTS('latitude', CIRCLE(LATLNG(%f,%f),2))" % (round(float(master['latitude']), 5), round(float(master['longitude']), 5)) # 3 meter
same_location = fusion_tables.select_first(configuration['master table'], condition=same_location_condition)
if same_location:
logging.info("Using the location slug of an existing location [%s] instead of [%s]" % (same_location[0]['location slug'], master['location slug']))
master['location slug'] = same_location[0]['location slug']
else:
base_location_slug = location_slug(master)
logging.info("This is a new location [%s]" % base_location_slug)
master['location slug'] = base_location_slug
# add (1) or (2) or etc... to the location slug if it's already in use
while fusion_tables.select_first(configuration['master table'], condition="'location slug' = '%s'" % master['location slug']):
logging.info("Adding (1), (2),... to location slug [%s] because it already existed." % master['location slug'])
counter = 1 if 'counter' not in locals() else counter + 1
master['location slug'] = base_location_slug + '-(' + str(counter) + ')'
if master['location slug'] != original_master['location slug']:
# otherwise the old location and event remains visible because the FT layer cannot filter them out
logging.info("Starting task on queue for deleting old versions of moved event %s" % original_master['event slug'])
taskqueue.add(method="GET", url='/sync/old_version_of_updated_events/%s?id=%s' % (original_master['event slug'], configuration['id']))
master['state'] = 'updated'
master['sequence'] = int(original_master['sequence']) + 1
master['entry date'] = original_master['entry date']
master['update date'] = datetime.today().strftime(FUSION_TABLE_DATE_TIME_FORMAT)
master['update after sync'] = 'true' # this will trigger sync_old_version_of_updated_events()
master['renewal date'] = (datetime.today() + timedelta(days=30 * 6)).strftime(FUSION_TABLE_DATE_TIME_FORMAT)
master['event slug'] = original_master['event slug']
master['hashtags'] = ','.join(["#%s#" % slugify(tag) for tag in extract_hash_tags(master['description'])])
master['rowid'] = original_master['rowid']
fusion_tables.update_with_implicit_rowid(configuration['master table'], master)
sync.sync_updated_events(configuration, condition="'event slug' = '%s'" % master['event slug'])
logging.info("LIST_OF_UPDATED_ROWS [%s] [%s] %s" % (configuration['id'], master['update date'], data))
sender = 'info@%s.appspotmail.com' % (app_id)
message = mail.EmailMessage(sender=sender, to="*****@*****.**")
message.subject = "Event updated in MapTiming %s" % configuration['title']
message.body = "http://%s.maptiming.com#event/%s" % (configuration['id'], master['event slug'])
logging.info("Sending mail from %s: %s - %s" % (sender, message.subject, message.body))
message.send()
# return the web-page content
self.response.out.write(master['event slug'])
return
def post(self):
configuration = customer_configuration.get_configuration(self.request)
data = self.request.POST['data']
master = json.loads(data)
# check if the location is in use, if so, reuse it's location slug
same_location_condition = "ST_INTERSECTS('latitude', CIRCLE(LATLNG(%f,%f),2))" % (round(float(master['latitude']), 5), round(float(master['longitude']), 5)) # 3 meter
same_location = fusion_tables.select_first(configuration['master table'], condition=same_location_condition)
if same_location:
logging.info("Using the location slug of an existing location [%s] instead of [%s]" % (same_location[0]['location slug'], master['location slug']))
master['location slug'] = same_location[0]['location slug']
else:
base_location_slug = location_slug(master)
logging.info("This is a new location [%s]" % base_location_slug)
master['location slug'] = base_location_slug
# add (1) or (2) or etc... to the location slug if it's already in use
while fusion_tables.select_first(configuration['master table'], condition="'location slug' = '%s'" % master['location slug']):
logging.info("Adding (1), (2),... to location slug [%s] because it already existed." % master['location slug'])
counter = 1 if 'counter' not in locals() else counter + 1
master['location slug'] = base_location_slug + '-(' + str(counter) + ')'
master['state'] = 'new'
master['sequence'] = 1
master['entry date'] = datetime.today().strftime(FUSION_TABLE_DATE_TIME_FORMAT)
master['update date'] = datetime.today().strftime(FUSION_TABLE_DATE_TIME_FORMAT)
master['renewal date'] = (datetime.today() + timedelta(days=30 * 6)).strftime(FUSION_TABLE_DATE_TIME_FORMAT)
base_event_slug = event_slug(master)
master['event slug'] = base_event_slug
# add (1) or (2) or etc... to the event slug if it's already in use
while fusion_tables.select_first(configuration['master table'], condition="'event slug' = '%s'" % master['event slug']):
counter = 1 if 'counter' not in locals() else counter + 1
master['event slug'] = base_event_slug + '-(' + str(counter) + ')'
# hashtags
master['hashtags'] = ','.join(["#%s#" % slugify(tag) for tag in extract_hash_tags(master['description'])])
fusion_tables.insert(configuration['master table'], master)
sync.sync_new_events(configuration, condition="'event slug' = '%s'" % master['event slug'])
logging.info("LIST_OF_ADDED_ROWS [%s] [%s] %s" % (configuration['id'], master['update date'], data))
sender = 'info@%s.appspotmail.com' % (app_id)
message = mail.EmailMessage(sender=sender, to="*****@*****.**")
message.subject = "New event added to MapTiming %s" % configuration['title']
message.body = "http://%s.maptiming.com#event/%s" % (configuration['id'], master['event slug'])
logging.info("Sending mail from %s: %s - %s" % (sender, message.subject, message.body))
message.send()
# return the web-page content
self.response.out.write(master['event slug'])
return
def get(self, now=datetime.datetime.strftime(datetime.datetime.now(), DATE_TIME_FORMAT), location_slug=None):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
localization = get_localization()
condition = "start >= '%s'" % now
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
# query on location
condition += " AND 'location slug' = '%s'" % location_slug
# sort by datetime slug
condition += " ORDER BY 'datetime slug'"
no_results_message = ''
data = fusion_tables.select(configuration['slave table'], condition=condition)
if not data:
no_results_message = 'Geen activiteiten voldoen aan de zoekopdracht.'
condition = "'location slug' = '%s'" % location_slug # search without time filter
data = fusion_tables.select_first(configuration['slave table'], condition)
if not data:
# TODO what if the location's events have been deleted?
logging.error("No events found for location (%s)" % condition)
raise webapp2.abort(404)
qr_url = self.request.url
url = qr_url.replace('/qr/location/','/all/location/')
template = jinja_environment.get_template('qr.html')
content = template.render(
configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
url=url,
localization=localization[language]
)
# return the web-page content
self.response.out.write(content)
return
def get(self,
location_slug=None,
timeframe=None,
tags=None,
hashtags=None):
now = self.request.get("now")
if not now:
now = datetime.datetime.strftime(
datetime.datetime.now(),
DATE_TIME_FORMAT) # fallback to server time
configuration = customer_configuration.get_configuration(self.request)
localization = get_localization()
# detect language and use configuration as default
language = get_language(self.request, configuration)
# calculate midnight, midnight1 and midnight 7 based on now
now_p = datetime.datetime.strptime(now, DATE_TIME_FORMAT)
midnight_p = datetime.datetime.combine(
now_p + datetime.timedelta(days=1), datetime.time.min)
midnight1_p = datetime.datetime.combine(
now_p + datetime.timedelta(days=2), datetime.time.min)
midnight7_p = datetime.datetime.combine(
now_p + datetime.timedelta(days=8), datetime.time.min)
midnight = datetime.datetime.strftime(midnight_p, DATE_TIME_FORMAT)
midnight1 = datetime.datetime.strftime(midnight1_p, DATE_TIME_FORMAT)
midnight7 = datetime.datetime.strftime(midnight7_p, DATE_TIME_FORMAT)
# query on timeframe
if timeframe == 'now':
# start < now and end > now
condition = "start <= '" + now + "' and end >= '" + now + "'"
elif timeframe == 'today':
# end > now and start < midnight
condition = "end >= '" + now + "' and start <= '" + midnight + "'"
elif timeframe == 'tomorrow':
# end > midnight and start < midnight + 1 day
condition = "end >= '" + midnight + "' and start <= '" + midnight1 + "'"
elif timeframe == 'week':
# end > now and start < midnight + 7 days
condition = "end >= '" + now + "' and start <= '" + midnight7 + "'"
else: # 'all' and other timeframes are interpreted as 'all'
# end > now
condition = "end >= '" + now + "'"
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
# query on tags
if tags:
tags_p = tags.split(',')
for tag in tags_p:
condition += " AND tags CONTAINS '#" + tag + "#'"
# tags in the fusion table are surrounded by hash characters to avoid
# confusion if one tag would be a substring of another tag
# query on hashtags
if hashtags:
hashtags_p = hashtags.split(',')
for hashtag in hashtags_p:
condition += " AND hashtags CONTAINS '#" + hashtag + "#'"
# query on location
condition += " AND 'location slug' = '" + location_slug + "'"
# sort by datetime slug
condition += " ORDER BY 'datetime slug'"
no_results_message = ''
data = fusion_tables.select(configuration['slave table'],
condition=condition)
if not data:
no_results_message = localization[
configuration['language']]['no-results']
condition = "'location slug' = '" + location_slug + "'" # search without timeframe or tags filter
data = fusion_tables.select_first(configuration['slave table'],
condition=condition)
if not data:
# TODO what if the location's events have been deleted?
# is foreseen: fallback to query on event_slug only
logging.error("No events found for location (%s)" % condition)
raise webapp2.abort(404)
template = jinja_environment.get_template('location.html')
content = template.render(configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
localization=localization[language])
# return the web-page content
self.response.out.write(content)
return
def post(self, event_slug=None):
configuration = customer_configuration.get_configuration(self.request)
original_master = fusion_tables.select_first(
configuration['master table'],
condition="'event slug' = '%s'" % event_slug)[0]
data = self.request.POST['data']
master = json.loads(data)
master['location slug'] = location_slug(master)
# check if the new location is in use, if so, reuse it's location slug
same_location_condition = "ST_INTERSECTS('latitude', CIRCLE(LATLNG(%f,%f),2))" % (
round(float(master['latitude']),
5), round(float(master['longitude']), 5)) # 3 meter
same_location = fusion_tables.select_first(
configuration['master table'], condition=same_location_condition)
if same_location:
logging.info(
"Using the location slug of an existing location [%s] instead of [%s]"
% (same_location[0]['location slug'], master['location slug']))
master['location slug'] = same_location[0]['location slug']
else:
base_location_slug = location_slug(master)
logging.info("This is a new location [%s]" % base_location_slug)
master['location slug'] = base_location_slug
# add (1) or (2) or etc... to the location slug if it's already in use
while fusion_tables.select_first(
configuration['master table'],
condition="'location slug' = '%s'" %
master['location slug']):
logging.info(
"Adding (1), (2),... to location slug [%s] because it already existed."
% master['location slug'])
counter = 1 if 'counter' not in locals() else counter + 1
master['location slug'] = base_location_slug + '-(' + str(
counter) + ')'
if master['location slug'] != original_master['location slug']:
# otherwise the old location and event remains visible because the FT layer cannot filter them out
logging.info(
"Starting task on queue for deleting old versions of moved event %s"
% original_master['event slug'])
taskqueue.add(method="GET",
url='/sync/old_version_of_updated_events/%s?id=%s' %
(original_master['event slug'], configuration['id']))
master['state'] = 'updated'
master['sequence'] = int(original_master['sequence']) + 1
master['entry date'] = original_master['entry date']
master['update date'] = datetime.today().strftime(
FUSION_TABLE_DATE_TIME_FORMAT)
master[
'update after sync'] = 'true' # this will trigger sync_old_version_of_updated_events()
master['renewal date'] = (
datetime.today() +
timedelta(days=30 * 6)).strftime(FUSION_TABLE_DATE_TIME_FORMAT)
master['event slug'] = original_master['event slug']
master['hashtags'] = ','.join([
"#%s#" % slugify(tag)
for tag in extract_hash_tags(master['description'])
])
master['rowid'] = original_master['rowid']
fusion_tables.update_with_implicit_rowid(configuration['master table'],
master)
sync.sync_updated_events(configuration,
condition="'event slug' = '%s'" %
master['event slug'])
logging.info("LIST_OF_UPDATED_ROWS [%s] [%s] %s" %
(configuration['id'], master['update date'], data))
sender = 'info@%s.appspotmail.com' % (app_id)
message = mail.EmailMessage(sender=sender,
to="*****@*****.**")
message.subject = "Event updated in MapTiming %s" % configuration[
'title']
message.body = "http://%s.maptiming.com#event/%s" % (
configuration['id'], master['event slug'])
logging.info("Sending mail from %s: %s - %s" %
(sender, message.subject, message.body))
message.send()
# return the web-page content
self.response.out.write(master['event slug'])
return
def post(self):
configuration = customer_configuration.get_configuration(self.request)
data = self.request.POST['data']
master = json.loads(data)
# check if the location is in use, if so, reuse it's location slug
same_location_condition = "ST_INTERSECTS('latitude', CIRCLE(LATLNG(%f,%f),2))" % (
round(float(master['latitude']),
5), round(float(master['longitude']), 5)) # 3 meter
same_location = fusion_tables.select_first(
configuration['master table'], condition=same_location_condition)
if same_location:
logging.info(
"Using the location slug of an existing location [%s] instead of [%s]"
% (same_location[0]['location slug'], master['location slug']))
master['location slug'] = same_location[0]['location slug']
else:
base_location_slug = location_slug(master)
logging.info("This is a new location [%s]" % base_location_slug)
master['location slug'] = base_location_slug
# add (1) or (2) or etc... to the location slug if it's already in use
while fusion_tables.select_first(
configuration['master table'],
condition="'location slug' = '%s'" %
master['location slug']):
logging.info(
"Adding (1), (2),... to location slug [%s] because it already existed."
% master['location slug'])
counter = 1 if 'counter' not in locals() else counter + 1
master['location slug'] = base_location_slug + '-(' + str(
counter) + ')'
master['state'] = 'new'
master['sequence'] = 1
master['entry date'] = datetime.today().strftime(
FUSION_TABLE_DATE_TIME_FORMAT)
master['update date'] = datetime.today().strftime(
FUSION_TABLE_DATE_TIME_FORMAT)
master['renewal date'] = (
datetime.today() +
timedelta(days=30 * 6)).strftime(FUSION_TABLE_DATE_TIME_FORMAT)
base_event_slug = event_slug(master)
master['event slug'] = base_event_slug
# add (1) or (2) or etc... to the event slug if it's already in use
while fusion_tables.select_first(configuration['master table'],
condition="'event slug' = '%s'" %
master['event slug']):
counter = 1 if 'counter' not in locals() else counter + 1
master['event slug'] = base_event_slug + '-(' + str(counter) + ')'
# hashtags
master['hashtags'] = ','.join([
"#%s#" % slugify(tag)
for tag in extract_hash_tags(master['description'])
])
fusion_tables.insert(configuration['master table'], master)
sync.sync_new_events(configuration,
condition="'event slug' = '%s'" %
master['event slug'])
logging.info("LIST_OF_ADDED_ROWS [%s] [%s] %s" %
(configuration['id'], master['update date'], data))
sender = 'info@%s.appspotmail.com' % (app_id)
message = mail.EmailMessage(sender=sender,
to="*****@*****.**")
message.subject = "New event added to MapTiming %s" % configuration[
'title']
message.body = "http://%s.maptiming.com#event/%s" % (
configuration['id'], master['event slug'])
logging.info("Sending mail from %s: %s - %s" %
(sender, message.subject, message.body))
message.send()
# return the web-page content
self.response.out.write(master['event slug'])
return
def get(self, location_slug=None, timeframe=None, tags=None, hashtags=None):
now = self.request.get("now")
if not now:
now = datetime.datetime.strftime(datetime.datetime.now(), DATE_TIME_FORMAT) # fallback to server time
configuration = customer_configuration.get_configuration(self.request)
localization = get_localization()
# detect language and use configuration as default
language = get_language(self.request, configuration)
# calculate midnight, midnight1 and midnight 7 based on now
now_p = datetime.datetime.strptime(now, DATE_TIME_FORMAT)
midnight_p = datetime.datetime.combine(now_p + datetime.timedelta(days=1), datetime.time.min)
midnight1_p = datetime.datetime.combine(now_p + datetime.timedelta(days=2), datetime.time.min)
midnight7_p = datetime.datetime.combine(now_p + datetime.timedelta(days=8), datetime.time.min)
midnight = datetime.datetime.strftime(midnight_p, DATE_TIME_FORMAT)
midnight1 = datetime.datetime.strftime(midnight1_p, DATE_TIME_FORMAT)
midnight7 = datetime.datetime.strftime(midnight7_p, DATE_TIME_FORMAT)
# query on timeframe
if timeframe == 'now':
# start < now and end > now
condition = "start <= '" + now + "' and end >= '" + now + "'"
elif timeframe == 'today':
# end > now and start < midnight
condition = "end >= '" + now + "' and start <= '" + midnight + "'"
elif timeframe == 'tomorrow':
# end > midnight and start < midnight + 1 day
condition = "end >= '" + midnight + "' and start <= '" + midnight1 + "'"
elif timeframe == 'week':
# end > now and start < midnight + 7 days
condition = "end >= '" + now + "' and start <= '" + midnight7 + "'"
else: # 'all' and other timeframes are interpreted as 'all'
# end > now
condition = "end >= '" + now + "'"
# apply commercial limit
limit = customer_configuration.get_limit(self.request)
if limit:
condition += " AND 'start' < '%s'" % limit
# query on tags
if tags:
tags_p = tags.split(',')
for tag in tags_p:
condition += " AND tags CONTAINS '#" + tag + "#'"
# tags in the fusion table are surrounded by hash characters to avoid
# confusion if one tag would be a substring of another tag
# query on hashtags
if hashtags:
hashtags_p = hashtags.split(',')
for hashtag in hashtags_p:
condition += " AND hashtags CONTAINS '#" + hashtag + "#'"
# query on location
condition += " AND 'location slug' = '" + location_slug + "'"
# sort by datetime slug
condition += " ORDER BY 'datetime slug'"
no_results_message = ''
data = fusion_tables.select(configuration['slave table'], condition=condition)
if not data:
no_results_message = localization[configuration['language']]['no-results']
condition = "'location slug' = '" + location_slug + "'" # search without timeframe or tags filter
data = fusion_tables.select_first(configuration['slave table'], condition=condition)
if not data:
# TODO what if the location's events have been deleted?
# is foreseen: fallback to query on event_slug only
logging.error("No events found for location (%s)" % condition)
raise webapp2.abort(404)
template = jinja_environment.get_template('location.html')
content = template.render(
configuration=configuration,
data=data,
date_time_reformat=date_time_reformat,
no_results_message=no_results_message,
localization=localization[language]
)
# return the web-page content
self.response.out.write(content)
return
def get(self,
edit_mode='new',
event_slug=None,
location_slug=None,
latitude=None,
longitude=None,
zoom=None,
tags=None,
hashtags=None):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
event = [{}]
event_default = 'false'
location_default = 'false'
coordinates_default = 'false'
tags_default = 'false'
hashtags_default = 'false'
if event_slug:
event = fusion_tables.select_first(
configuration['master table'],
condition="'event slug' = '%s'" % event_slug)
event_default = 'true'
if location_slug:
event = fusion_tables.select_first(
configuration['master table'],
condition="'location slug' = '%s'" % location_slug)
location_default = 'true'
if latitude and longitude and not event_slug and not location_slug:
event[0]['latitude'] = latitude
event[0]['longitude'] = longitude
event[0]['zoom'] = zoom # zoom is not in a normal event object !
coordinates_default = 'true'
if tags and not event_slug:
event[0]['tags'] = ','.join(["#%s#" % t for t in tags.split(',')])
tags_default = 'true'
if hashtags and not event_slug:
event[0]['hashtags'] = ','.join(
["#%s#" % h for h in hashtags.split(',')])
hashtags_default = 'true'
if edit_mode == 'new':
if event_slug:
title = "edit-new-event-based-on-original"
else:
title = "edit-new-event-from-scratch"
else:
title = "update-event"
localization = get_localization()
template = jinja_environment.get_template('editor.html')
content = template.render(
configuration=configuration,
# note that event is a [{}] !
event_json=json.dumps(event)
if event else '[0]', # check map.html and gmaps.js why
event_default=event_default,
location_default=location_default,
coordinates_default=coordinates_default,
tags_default=tags_default,
hashtags_default=hashtags_default,
title=title,
edit_mode=edit_mode,
slugify=slugify,
language=language,
localization=localization[language])
# return the web-page content
self.response.out.write(content)
return
def get(
self,
edit_mode="new",
event_slug=None,
location_slug=None,
latitude=None,
longitude=None,
zoom=None,
tags=None,
hashtags=None,
):
configuration = customer_configuration.get_configuration(self.request)
# detect language and use configuration as default
language = get_language(self.request, configuration)
event = [{}]
event_default = "false"
location_default = "false"
coordinates_default = "false"
tags_default = "false"
hashtags_default = "false"
if event_slug:
event = fusion_tables.select_first(
configuration["master table"], condition="'event slug' = '%s'" % event_slug
)
event_default = "true"
if location_slug:
event = fusion_tables.select_first(
configuration["master table"], condition="'location slug' = '%s'" % location_slug
)
location_default = "true"
if latitude and longitude and not event_slug and not location_slug:
event[0]["latitude"] = latitude
event[0]["longitude"] = longitude
event[0]["zoom"] = zoom # zoom is not in a normal event object !
coordinates_default = "true"
if tags and not event_slug:
event[0]["tags"] = ",".join(["#%s#" % t for t in tags.split(",")])
tags_default = "true"
if hashtags and not event_slug:
event[0]["hashtags"] = ",".join(["#%s#" % h for h in hashtags.split(",")])
hashtags_default = "true"
if edit_mode == "new":
if event_slug:
title = "edit-new-event-based-on-original"
else:
title = "edit-new-event-from-scratch"
else:
title = "update-event"
localization = get_localization()
template = jinja_environment.get_template("editor.html")
content = template.render(
configuration=configuration,
# note that event is a [{}] !
event_json=json.dumps(event) if event else "[0]", # check map.html and gmaps.js why
event_default=event_default,
location_default=location_default,
coordinates_default=coordinates_default,
tags_default=tags_default,
hashtags_default=hashtags_default,
title=title,
edit_mode=edit_mode,
slugify=slugify,
language=language,
localization=localization[language],
)
# return the web-page content
self.response.out.write(content)
return
