def test_to_archive(self):
outing = Outing(
document_id=1, activities=['skitouring'],
elevation_max=1200,
locales=[
OutingLocale(
id=2, lang='en', title='A', description='abc',
route_description='...'),
OutingLocale(
id=3, lang='fr', title='B', description='bcd',
route_description='...'),
]
)
outing_archive = outing.to_archive()
self.assertIsNone(outing_archive.id)
self.assertEqual(outing_archive.document_id, outing.document_id)
self.assertEqual(
outing_archive.activities, outing.activities)
self.assertEqual(outing_archive.elevation_max, outing.elevation_max)
archive_locals = outing.get_archive_locales()
self.assertEqual(len(archive_locals), 2)
locale = outing.locales[0]
locale_archive = archive_locals[0]
self.assertIsNot(locale_archive, locale)
self.assertIsNone(locale_archive.id)
self.assertEqual(locale_archive.lang, locale.lang)
self.assertEqual(locale_archive.title, locale.title)
self.assertEqual(locale_archive.description, locale.description)
self.assertEqual(
locale_archive.route_description, locale.route_description)
def _add_test_data(self):
self.waypoint = Waypoint(waypoint_type='summit', elevation=2203)
self.locale_en = WaypointLocale(lang='en',
title='Mont Granier',
description='...',
access='yep')
self.waypoint.locales.append(self.locale_en)
self.waypoint.geometry = DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)')
self.session.add(self.waypoint)
self.waypoint_with_topic = Waypoint(waypoint_type='summit',
elevation=2203)
document_topic = DocumentTopic(topic_id=1)
self.locale_en_with_topic = WaypointLocale(
lang='en',
title='Mont Granier',
description='...',
access='yep',
document_topic=document_topic)
self.waypoint_with_topic.locales.append(self.locale_en_with_topic)
self.waypoint_with_topic.geometry = DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)')
self.session.add(self.waypoint_with_topic)
self.image = Image(filename='image.jpg',
activities=['paragliding'],
height=1500,
image_type='collaborative')
self.image_locale_en = DocumentLocale(lang='en',
title='',
description='')
self.image.locales.append(self.image_locale_en)
self.image.geometry = DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)')
self.session.add(self.image)
self.outing = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(
lang='en',
title='Mont Granier / skitouring')
])
self.session.add(self.outing)
self.session.flush()
for user_id in (self.global_userids['contributor'],
self.global_userids['contributor2']):
self.session.add(
Association(parent_document_id=user_id,
parent_document_type=USERPROFILE_TYPE,
child_document_id=self.outing.document_id,
child_document_type=OUTING_TYPE))
self.session.flush()
def setUp(self):
BaseTestRest.setUp(self)
waypoint = Waypoint(
waypoint_type='summit', elevation=2000,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)')
)
outing = Outing(
activities=['skitouring'],
date_start=date(2016, 1, 1),
date_end=date(2016, 1, 1),
geometry=DocumentGeometry(geom='SRID=3857;POINT(0 0)')
)
article = Article(
categories=['site_info'],
activities=['hiking'],
article_type='collab'
)
for lang in default_langs:
locale = OutingLocale(lang=lang, title=f'Title in {lang}')
outing.locales.append(locale)
locale = DocumentLocale(lang=lang, title=f'Title in {lang}')
article.locales.append(locale)
locale = WaypointLocale(lang=lang, title=f'Title in {lang}')
waypoint.locales.append(locale)
self.session.add(article)
self.session.add(outing)
self.session.add(waypoint)
self.session.flush()
fill_index(self.session)
# make sure the search index is built
force_search_index()
contributor_id = self.global_userids['contributor']
for lang in default_langs:
self.session.add(DocumentChange(
time=datetime(2016, 1, 1, 12, 0, 0),
user_id=contributor_id, change_type='created',
document_id=waypoint.document_id,
document_type=WAYPOINT_TYPE, user_ids=[contributor_id],
langs=[lang]
))
self.session.flush()
def test_update_cache_version_associations_removed_route_outing(self):
waypoint1 = Waypoint(waypoint_type='summit')
waypoint2 = Waypoint(waypoint_type='summit')
waypoint3 = Waypoint(waypoint_type='summit')
waypoint_unrelated = Waypoint(waypoint_type='summit')
route = Route(activities=['skitouring'])
outing = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 2, 1),
date_end=datetime.date(2016, 2, 1))
self.session.add_all([
waypoint1, waypoint2, waypoint3, waypoint_unrelated, route, outing
])
self.session.flush()
self.session.add(Association.create(waypoint1, route))
self.session.add(Association.create(waypoint2, waypoint1))
self.session.add(Association.create(waypoint3, waypoint2))
self.session.flush()
update_cache_version_associations([], [{
'parent_id': route.document_id,
'parent_type': ROUTE_TYPE,
'child_id': outing.document_id,
'child_type': OUTING_TYPE
}])
cache_version1 = self.session.query(CacheVersion).get(
waypoint1.document_id)
cache_version2 = self.session.query(CacheVersion).get(
waypoint2.document_id)
cache_version3 = self.session.query(CacheVersion).get(
waypoint3.document_id)
cache_version_route = self.session.query(CacheVersion).get(
route.document_id)
cache_version_outing = self.session.query(CacheVersion).get(
outing.document_id)
cache_version_untouched = self.session.query(CacheVersion).get(
waypoint_unrelated.document_id)
self.assertEqual(cache_version1.version, 2)
self.assertEqual(cache_version2.version, 2)
self.assertEqual(cache_version3.version, 2)
self.assertEqual(cache_version_route.version, 2)
self.assertEqual(cache_version_outing.version, 2)
self.assertEqual(cache_version_untouched.version, 1)
def test_update_cache_version_user(self):
""" Test that outings are invalidated if an user name changes.
"""
outing = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 2, 1),
date_end=datetime.date(2016, 2, 1))
user_profile = UserProfile()
self.session.add_all([outing, user_profile])
self.session.flush()
self.session.add(Association.create(user_profile, outing))
self.session.flush()
update_cache_version(user_profile)
cache_version_user_profile = self.session.query(CacheVersion).get(
user_profile.document_id)
cache_version_outing = self.session.query(CacheVersion).get(
outing.document_id)
self.assertEqual(cache_version_outing.version, 2)
self.assertEqual(cache_version_user_profile.version, 2)
def test_update_cache_version_outing(self):
outing = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 2, 1),
date_end=datetime.date(2016, 2, 1))
route1 = Route(activities=['skitouring'])
route2 = Route(activities=['skitouring'])
waypoint1 = Waypoint(waypoint_type='summit')
waypoint2 = Waypoint(waypoint_type='summit')
waypoint_unrelated = Waypoint(waypoint_type='summit')
self.session.add_all(
[outing, waypoint1, waypoint2, waypoint_unrelated, route1, route2])
self.session.flush()
self.session.add(Association.create(route1, outing))
self.session.add(Association.create(waypoint1, route1))
self.session.add(Association.create(route2, outing))
self.session.add(Association.create(waypoint2, waypoint1))
self.session.flush()
update_cache_version(outing)
cache_version_outing = self.session.query(CacheVersion).get(
outing.document_id)
cache_version_route1 = self.session.query(CacheVersion).get(
route1.document_id)
cache_version_route2 = self.session.query(CacheVersion).get(
route2.document_id)
cache_version_wp1 = self.session.query(CacheVersion).get(
waypoint1.document_id)
cache_version_wp2 = self.session.query(CacheVersion).get(
waypoint2.document_id)
cache_version_untouched = self.session.query(CacheVersion).get(
waypoint_unrelated.document_id)
self.assertEqual(cache_version_outing.version, 2)
self.assertEqual(cache_version_route1.version, 2)
self.assertEqual(cache_version_route2.version, 2)
self.assertEqual(cache_version_wp1.version, 2)
self.assertEqual(cache_version_wp2.version, 2)
self.assertEqual(cache_version_untouched.version, 1)
def _add_test_data(self):
self.xreport1 = Xreport(activities=['hiking'],
event_type=['stone_fall'])
self.locale_en = XreportLocale(lang='en',
title='Lac d\'Annecy',
place='some place descrip. in english')
self.locale_fr = XreportLocale(lang='fr',
title='Lac d\'Annecy',
place='some place descrip. in french')
self.xreport1.locales.append(self.locale_en)
self.xreport1.locales.append(self.locale_fr)
self.session.add(self.xreport1)
self.session.flush()
user_id = self.global_userids['contributor']
DocumentRest.create_new_version(self.xreport1, user_id)
self.xreport1_version = self.session.query(DocumentVersion). \
filter(DocumentVersion.document_id ==
self.xreport1.document_id). \
filter(DocumentVersion.lang == 'en').first()
user_id3 = self.global_userids['contributor3']
self.session.add(
Association(parent_document_id=user_id3,
parent_document_type=USERPROFILE_TYPE,
child_document_id=self.xreport1.document_id,
child_document_type=XREPORT_TYPE))
self.xreport2 = Xreport(activities=['hiking'],
event_type=['avalanche'],
nb_participants=5)
self.session.add(self.xreport2)
self.xreport3 = Xreport(activities=['hiking'],
event_type=['avalanche'],
nb_participants=5)
self.session.add(self.xreport3)
self.xreport4 = Xreport(activities=['hiking'],
event_type=['avalanche'],
nb_participants=5,
nb_impacted=5,
age=50)
self.xreport4.locales.append(
DocumentLocale(lang='en', title='Lac d\'Annecy'))
self.xreport4.locales.append(
DocumentLocale(lang='fr', title='Lac d\'Annecy'))
self.session.add(self.xreport4)
self.article2 = Article(categories=['site_info'],
activities=['hiking'],
article_type='collab')
self.session.add(self.article2)
self.session.flush()
self.image2 = Image(filename='image2.jpg',
activities=['paragliding'],
height=1500)
self.session.add(self.image2)
self.session.flush()
self.waypoint1 = Waypoint(waypoint_type='summit', elevation=2203)
self.session.add(self.waypoint1)
self.waypoint2 = Waypoint(
waypoint_type='climbing_outdoor',
elevation=2,
rock_types=[],
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.session.add(self.waypoint2)
self.session.flush()
self.outing3 = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 2, 1),
date_end=datetime.date(2016, 2, 2))
self.session.add(self.outing3)
self.route3 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=500,
height_diff_down=500,
durations='1')
self.session.add(self.route3)
self.session.flush()
self.session.add(
Association.create(parent_document=self.outing3,
child_document=self.xreport1))
self.session.add(
Association.create(parent_document=self.route3,
child_document=self.xreport1))
self.session.flush()
def _add_test_data(self):
self.waypoint = Waypoint(waypoint_type='summit', elevation=2203)
self.locale_en = WaypointLocale(lang='en',
title='Mont Granier',
description='...',
access='yep')
self.locale_fr = WaypointLocale(lang='fr',
title='Mont Granier',
description='...',
access='ouai')
self.waypoint.locales.append(self.locale_en)
self.waypoint.locales.append(self.locale_fr)
self.waypoint.geometry = DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)')
self.session.add(self.waypoint)
self.session.flush()
user_id = self.global_userids['contributor']
DocumentRest.create_new_version(self.waypoint, user_id)
self.waypoint_version = self.session.query(DocumentVersion). \
filter(DocumentVersion.document_id == self.waypoint.document_id). \
filter(DocumentVersion.lang == 'en').first()
self.waypoint2 = Waypoint(
waypoint_type='climbing_outdoor',
elevation=2,
rock_types=[],
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.session.add(self.waypoint2)
self.waypoint3 = Waypoint(
waypoint_type='summit',
elevation=3,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.session.add(self.waypoint3)
self.waypoint4 = Waypoint(
waypoint_type='summit',
elevation=4,
protected=True,
geometry=DocumentGeometry(geom='SRID=3857;POINT(659775 5694854)'))
self.waypoint4.locales.append(
WaypointLocale(lang='en',
title='Mont Granier',
description='...',
access='yep'))
self.waypoint4.locales.append(
WaypointLocale(lang='fr',
title='Mont Granier',
description='...',
access='ouai'))
self.session.add(self.waypoint4)
self.waypoint5 = Waypoint(
waypoint_type='summit',
elevation=3,
redirects_to=self.waypoint.document_id,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint5.locales.append(
WaypointLocale(lang='en',
title='Mont Granier',
description='...',
access='yep'))
self.session.add(self.waypoint5)
self.session.flush()
DocumentRest.create_new_version(self.waypoint4,
self.global_userids['contributor'])
DocumentRest.create_new_version(self.waypoint5,
self.global_userids['contributor'])
# add some associations
self.route1 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1',
main_waypoint_id=self.waypoint.document_id)
self.route1.locales.append(
RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
title_prefix='Mont Blanc :',
gear='paraglider'))
self.session.add(self.route1)
self.session.flush()
self.route2 = Route(redirects_to=self.route1.document_id,
activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1',
main_waypoint_id=self.waypoint.document_id)
self.route3 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1')
self.route3.locales.append(
RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
title_prefix='Mont Blanc :',
gear='paraglider'))
self.session.add(self.route2)
self.session.add(self.route3)
self.session.flush()
self.session.add(
Association(parent_document_id=self.waypoint.document_id,
child_document_id=self.waypoint4.document_id))
self.session.add(
Association(parent_document_id=self.waypoint.document_id,
child_document_id=self.waypoint5.document_id))
self.session.add(
Association(parent_document_id=self.waypoint.document_id,
child_document_id=self.route1.document_id))
self.session.add(
Association(parent_document_id=self.waypoint.document_id,
child_document_id=self.route2.document_id))
self.session.add(
Association(parent_document_id=self.waypoint4.document_id,
child_document_id=self.route3.document_id))
self.outing1 = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 3),
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.session.add(self.outing1)
self.session.flush()
self.session.add(
Association(parent_document_id=self.route1.document_id,
child_document_id=self.outing1.document_id))
self.outing2 = Outing(redirects_to=self.outing1.document_id,
activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.outing3 = Outing(activities=['skitouring'],
date_start=datetime.date(2015, 12, 31),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.session.add(self.outing2)
self.session.add(self.outing3)
self.session.flush()
self.session.add(
Association(parent_document_id=self.route1.document_id,
child_document_id=self.outing2.document_id))
self.session.add(
Association(parent_document_id=self.route3.document_id,
child_document_id=self.outing3.document_id))
# add a map
topo_map = TopoMap(
code='3232ET',
editor='IGN',
scale='25000',
locales=[DocumentLocale(lang='fr', title='Belley')],
geometry=DocumentGeometry(
geom_detail=
'SRID=3857;POLYGON((611774.917032556 5706934.10657514,611774.917032556 5744215.5846397,642834.402570357 5744215.5846397,642834.402570357 5706934.10657514,611774.917032556 5706934.10657514))'
) # noqa
)
self.session.add(topo_map)
self.session.flush()
self.session.add(
TopoMap(
redirects_to=topo_map.document_id,
code='3232ET',
editor='IGN',
scale='25000',
locales=[DocumentLocale(lang='fr', title='Belley')],
geometry=DocumentGeometry(
geom_detail=
'SRID=3857;POLYGON((611774.917032556 5706934.10657514,611774.917032556 5744215.5846397,642834.402570357 5744215.5846397,642834.402570357 5706934.10657514,611774.917032556 5706934.10657514))'
) # noqa
))
# add areas
self.area1 = Area(
area_type='range',
geometry=DocumentGeometry(
geom_detail=
'SRID=3857;POLYGON((611774.917032556 5706934.10657514,611774.917032556 5744215.5846397,642834.402570357 5744215.5846397,642834.402570357 5706934.10657514,611774.917032556 5706934.10657514))' # noqa
))
self.area2 = Area(area_type='range',
locales=[DocumentLocale(lang='fr', title='France')])
self.session.add_all([self.area1, self.area2])
self.session.add(
AreaAssociation(document=self.waypoint, area=self.area2))
self.session.flush()
def _add_test_data(self):
self.route = Route(
activities=['skitouring'], elevation_max=1500, elevation_min=700,
height_diff_up=800, height_diff_down=800, durations='1')
self.locale_en = RouteLocale(
lang='en', title='Mont Blanc from the air', description='...',
gear='paraglider', title_prefix='Main waypoint title',
document_topic=DocumentTopic(topic_id=1))
self.locale_fr = RouteLocale(
lang='fr', title='Mont Blanc du ciel', description='...',
gear='paraglider')
self.route.locales.append(self.locale_en)
self.route.locales.append(self.locale_fr)
self.route.geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)'
)
self.session.add(self.route)
self.session.flush()
user_id = self.global_userids['contributor']
DocumentRest.create_new_version(self.route, user_id)
self.route_version = self.session.query(DocumentVersion). \
filter(DocumentVersion.document_id == self.route.document_id). \
filter(DocumentVersion.lang == 'en').first()
self.article1 = Article(categories=['site_info'],
activities=['hiking'],
article_type='collab')
self.session.add(self.article1)
self.session.flush()
self._add_association(Association.create(
parent_document=self.route,
child_document=self.article1), user_id)
self.book1 = Book(activities=['hiking'],
book_types=['biography'])
self.session.add(self.book1)
self.session.flush()
self._add_association(Association.create(
parent_document=self.book1,
child_document=self.route), user_id)
self.route2 = Route(
activities=['skitouring'], elevation_max=1500, elevation_min=700,
height_diff_up=800, height_diff_down=800, durations='1',
locales=[
RouteLocale(
lang='en', title='Mont Blanc from the air',
description='...', gear='paraglider'),
RouteLocale(
lang='fr', title='Mont Blanc du ciel', description='...',
gear='paraglider')]
)
self.session.add(self.route2)
self.session.flush()
DocumentRest.create_new_version(self.route2, user_id)
self.route3 = Route(
activities=['skitouring'], elevation_max=1500, elevation_min=700,
height_diff_up=500, height_diff_down=500, durations='1',
locales=[
RouteLocale(
lang='en', title='Mont Blanc from the air',
description='...', gear='paraglider'),
RouteLocale(
lang='fr', title='Mont Blanc du ciel', description='...',
gear='paraglider')]
)
self.route3.geometry = DocumentGeometry(geom='SRID=3857;POINT(0 0)')
self.session.add(self.route3)
self.session.flush()
DocumentRest.create_new_version(self.route3, user_id)
self.route4 = Route(
activities=['rock_climbing'], elevation_max=1500,
elevation_min=700, height_diff_up=500, height_diff_down=500,
durations='1', climbing_outdoor_type='single')
self.route4.locales.append(RouteLocale(
lang='en', title='Mont Blanc from the air', description='...',
gear='paraglider'))
self.route4.locales.append(RouteLocale(
lang='fr', title='Mont Blanc du ciel', description='...',
gear='paraglider'))
self.session.add(self.route4)
# add some associations
self.waypoint = Waypoint(
waypoint_type='climbing_outdoor', elevation=4,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint.locales.append(WaypointLocale(
lang='en', title='Mont Granier 1 (en)', description='...',
access='yep', access_period='yapa'))
self.waypoint.locales.append(WaypointLocale(
lang='fr', title='Mont Granier 1 (fr)', description='...',
access='ouai', access_period='yapa'))
self.session.add(self.waypoint)
self.waypoint2 = Waypoint(
waypoint_type='summit', elevation=4,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint2.locales.append(WaypointLocale(
lang='en', title='Mont Granier 2 (en)', description='...',
access='yep'))
self.session.add(self.waypoint2)
self.session.flush()
self._add_association(Association.create(
parent_document=self.route,
child_document=self.route4), user_id)
self._add_association(Association.create(
parent_document=self.route4,
child_document=self.route), user_id)
self._add_association(Association.create(
parent_document=self.waypoint,
child_document=self.route), user_id)
# add a map
topo_map = TopoMap(
code='3232ET', editor='IGN', scale='25000',
locales=[
DocumentLocale(lang='fr', title='Belley')
],
geometry=DocumentGeometry(geom_detail='SRID=3857;POLYGON((635900 5723600, 635900 5723700, 636000 5723700, 636000 5723600, 635900 5723600))') # noqa
)
self.session.add(topo_map)
self.session.flush()
self.session.add(TopoMapAssociation(
document=self.route, topo_map=topo_map))
self.outing1 = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
public_transport=True,
locales=[
OutingLocale(
lang='en', title='...', description='...',
weather='sunny')
]
)
self.session.add(self.outing1)
self.session.flush()
self._add_association(Association.create(
parent_document=self.route,
child_document=self.outing1), user_id)
self.outing2 = Outing(
redirects_to=self.outing1.document_id,
activities=['skitouring'], date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(
lang='en', title='...', description='...',
weather='sunny')
]
)
self.session.add(self.outing2)
self.session.flush()
self._add_association(Association.create(
parent_document=self.route,
child_document=self.outing2), user_id)
self.session.flush()
# add areas
self.area1 = Area(
area_type='range',
geometry=DocumentGeometry(
geom_detail='SRID=3857;POLYGON((635900 5723600, 635900 5723700, 636000 5723700, 636000 5723600, 635900 5723600))' # noqa
)
)
self.area2 = Area(
area_type='range',
locales=[
DocumentLocale(lang='fr', title='France')
]
)
self.session.add_all([self.area1, self.area2])
self.session.flush()
def _add_test_data(self):
user_id = self.global_userids['contributor']
self.waypoint1 = Waypoint(waypoint_type='summit', elevation=2203)
self.session.add(self.waypoint1)
self.waypoint2 = Waypoint(waypoint_type='summit', elevation=200)
self.session.add(self.waypoint2)
self.session.flush()
self.waypoint3 = Waypoint(waypoint_type='summit',
elevation=200,
redirects_to=self.waypoint1.document_id)
self.session.add(self.waypoint3)
self.route1 = Route(activities=['skitouring'])
self.session.add(self.route1)
self.session.add(self.waypoint2)
self.route2 = Route(activities=['skitouring'])
self.session.add(self.route2)
self.image1 = Image(filename='image.jpg',
locales=[
DocumentLocale(lang='en',
title='Mont Blanc from the air')
])
self.session.add(self.image1)
self.session.flush()
DocumentRest.create_new_version(self.image1, user_id)
self.article1 = Article(
categories=['site_info'],
activities=['hiking'],
article_type='collab',
locales=[DocumentLocale(lang='en', title='Lac d\'Annecy')])
self.session.add(self.article1)
self.session.flush()
DocumentRest.create_new_version(self.article1, user_id)
self.article2 = Article(
categories=['site_info'],
activities=['hiking'],
article_type='personal',
locales=[DocumentLocale(lang='en', title='Lac d\'Annecy')])
self.session.add(self.article2)
self.session.flush()
DocumentRest.create_new_version(self.article2, user_id)
self.report1 = Xreport(
activities=['hiking'],
locales=[XreportLocale(lang='en', title='Lac d\'Annecy')])
self.session.add(self.report1)
self.session.flush()
DocumentRest.create_new_version(self.report1, user_id)
self.outing = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1))
self.session.add(self.outing)
self.session.flush()
self.session.add(
Association(parent_document_id=user_id,
parent_document_type=USERPROFILE_TYPE,
child_document_id=self.outing.document_id,
child_document_type=OUTING_TYPE))
update_feed_document_create(self.outing, user_id)
self.session.flush()
# create a 2nd feed entry for the outing
feed_change = self.get_feed_change(self.outing.document_id)
user_id = self.global_userids['moderator']
feed_change2 = feed_change.copy()
feed_change2.change_type = 'added_photos'
feed_change2.user_id = user_id
feed_change2.user_ids = list(
set(feed_change.user_ids).union([user_id]))
self.session.add(feed_change2)
self.session.flush()
def setUp(self): # noqa
super(BaseFeedTestRest, self).setUp()
self._prefix = '/feed'
self.waypoint1 = Waypoint(
waypoint_type='summit', elevation=2000,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(
lang='fr', title='Dent de Crolles',
description='...',
summary='La Dent de Crolles')
])
self.session.add(self.waypoint1)
self.waypoint2 = Waypoint(
waypoint_type='summit', elevation=4985,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(
lang='en', title='Mont Blanc',
description='...',
summary='The heighest point in Europe')
])
self.session.add(self.waypoint2)
self.route = Route(
activities=['skitouring'], elevation_max=1500, elevation_min=700,
locales=[
RouteLocale(
lang='fr', title='Mont Blanc du ciel',
description='...', summary='Ski')
])
self.session.add(self.route)
self.outing = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1), frequentation='overcrowded',
locales=[
OutingLocale(
lang='en', title='Mont Blanc : Face N!',
description='...', weather='sunny'),
OutingLocale(
lang='fr', title='Mont Blanc : Face N !',
description='...', weather='beau')
]
)
self.session.add(self.outing)
self.area1 = Area(
area_type='range',
locales=[
DocumentLocale(lang='fr', title='France')
]
)
self.area2 = Area(
area_type='range',
locales=[
DocumentLocale(lang='fr', title='Suisse')
]
)
self.session.add_all([self.area1, self.area2])
self.session.flush()
contributor_id = self.global_userids['contributor']
contributor2_id = self.global_userids['contributor2']
self.session.add(DocumentChange(
time=datetime.datetime(2016, 1, 1, 12, 0, 0),
user_id=contributor_id, change_type='created',
document_id=self.waypoint1.document_id,
document_type=WAYPOINT_TYPE, user_ids=[contributor_id],
area_ids=[self.area1.document_id]
))
self.session.add(DocumentChange(
time=datetime.datetime(2016, 1, 1, 12, 0, 0),
user_id=contributor2_id, change_type='created',
document_id=self.waypoint2.document_id,
document_type=WAYPOINT_TYPE, user_ids=[contributor2_id],
area_ids=[self.area2.document_id]
))
self.session.add(DocumentChange(
time=datetime.datetime(2016, 1, 1, 12, 1, 0),
user_id=contributor_id, change_type='created',
document_id=self.route.document_id,
document_type=ROUTE_TYPE, user_ids=[contributor_id],
activities=['hiking'],
area_ids=[self.area1.document_id, self.area2.document_id]
))
self.session.add(DocumentChange(
time=datetime.datetime(2016, 1, 1, 12, 2, 0),
user_id=contributor_id, change_type='created',
document_id=self.outing.document_id,
document_type=OUTING_TYPE,
user_ids=[contributor_id, contributor2_id],
activities=['skitouring']
))
self.session.flush()
def _add_test_data(self):
user_id = self.global_userids['contributor']
self.image = Image(filename='image.jpg',
activities=['paragliding'],
height=1500,
image_type='collaborative')
self.locale_en = DocumentLocale(
lang='en',
title='Mont Blanc from the air',
description='...',
document_topic=DocumentTopic(topic_id=1))
self.locale_fr = DocumentLocale(lang='fr',
title='Mont Blanc du ciel',
description='...')
self.image.locales.append(self.locale_en)
self.image.locales.append(self.locale_fr)
self.image.geometry = DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)')
self.session.add(self.image)
self.session.flush()
self.article1 = Article(categories=['site_info'],
activities=['hiking'],
article_type='collab')
self.session.add(self.article1)
self.session.flush()
self._add_association(
Association.create(parent_document=self.article1,
child_document=self.image), user_id)
self.book1 = Book(activities=['hiking'], book_types=['biography'])
self.session.add(self.book1)
self.session.flush()
self._add_association(
Association.create(parent_document=self.book1,
child_document=self.image), user_id)
DocumentRest.create_new_version(self.image, user_id)
self.image_version = self.session.query(DocumentVersion). \
filter(DocumentVersion.document_id == self.image.document_id). \
filter(DocumentVersion.lang == 'en').first()
self.image2 = Image(filename='image2.jpg',
activities=['paragliding'],
height=1500)
self.session.add(self.image2)
self.image3 = Image(filename='image3.jpg',
activities=['paragliding'],
height=1500)
self.session.add(self.image3)
self.image4 = Image(filename='image4.jpg',
activities=['paragliding'],
height=1500,
image_type='personal')
self.image4.locales.append(
DocumentLocale(lang='en',
title='Mont Blanc from the air',
description='...'))
self.image4.locales.append(
DocumentLocale(lang='fr',
title='Mont Blanc du ciel',
description='...'))
self.session.add(self.image4)
self.session.flush()
DocumentRest.create_new_version(self.image3,
self.global_userids['contributor2'])
DocumentRest.create_new_version(self.image4, user_id)
self._add_association(
Association.create(parent_document=self.image,
child_document=self.image2), user_id)
self.waypoint = Waypoint(
waypoint_type='summit',
elevation=4,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint.locales.append(
WaypointLocale(lang='en',
title='Mont Granier (en)',
description='...',
access='yep'))
self.session.add(self.waypoint)
self.session.flush()
update_feed_document_create(self.waypoint, user_id)
self.session.flush()
self.area = Area(area_type='range',
locales=[DocumentLocale(lang='fr', title='France')])
self.session.add(self.area)
self.session.flush()
self._add_association(Association.create(self.area, self.image),
user_id)
self.session.flush()
self.outing1 = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.session.add(self.outing1)
self.session.flush()
self._add_association(
Association.create(parent_document=self.outing1,
child_document=self.image), user_id)
self._add_association(
Association(parent_document_id=self.global_userids['contributor'],
parent_document_type=USERPROFILE_TYPE,
child_document_id=self.outing1.document_id,
child_document_type=OUTING_TYPE), user_id)
update_feed_document_create(self.outing1, user_id)
self.session.flush()
def _add_test_data(self):
_, date_now = es_sync.get_status(self.session)
es_sync.mark_as_updated(self.session, date_now)
self.waypoint1 = Waypoint(
document_id=71171,
waypoint_type='summit',
elevation=2000,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='fr',
title='Mont Granier',
description='...',
summary='Le Mont [b]Granier[/b]'),
WaypointLocale(lang='en',
title='Mont Granier',
description='...',
summary='The Mont Granier')
])
self.waypoint2 = Waypoint(
document_id=71172,
waypoint_type='summit',
elevation=4985,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='en',
title='Mont Blanc',
description='...',
summary='The heighest point in Europe')
])
self.route1 = Route(document_id=71173,
activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1',
locales=[
RouteLocale(lang='en',
title='Face N',
description='...',
gear='paraglider',
title_prefix='Mont Blanc')
])
self.waypoint3 = Waypoint(
document_id=71174,
redirects_to=71171,
waypoint_type='summit',
elevation=4985,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='en',
title='Mont Blanc',
description='...',
summary='The heighest point in Europe')
])
self.outing1 = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.session.add_all([
self.waypoint1, self.waypoint2, self.waypoint3, self.route1,
self.outing1
])
self.session.flush()
user_id = self.global_userids['contributor']
DocumentRest.create_new_version(self.waypoint1, user_id)
DocumentRest.create_new_version(self.waypoint2, user_id)
DocumentRest.create_new_version(self.waypoint3, user_id)
DocumentRest.create_new_version(self.route1, user_id)
DocumentRest.create_new_version(self.outing1, user_id)
association_wr = Association.create(self.waypoint1, self.route1)
association_ww = Association.create(self.waypoint2, self.waypoint1)
association_ro = Association.create(self.route1, self.outing1)
user = self.session.query(UserProfile).get(
self.global_userids['contributor'])
association_uo = Association.create(user, self.outing1)
self.session.add_all([
association_wr, association_ww, association_ro, association_uo,
association_wr.get_log(user_id),
association_ww.get_log(user_id),
association_ro.get_log(user_id),
association_uo.get_log(user_id)
])
self.session.flush()
def _add_test_data(self):
self.route = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1')
self.locale_en = RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
gear='paraglider',
title_prefix='Main waypoint title')
self.locale_fr = RouteLocale(lang='fr',
title='Mont Blanc du ciel',
description='...',
gear='paraglider')
self.route.locales.append(self.locale_en)
self.route.locales.append(self.locale_fr)
self.route.geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.session.add(self.route)
self.session.flush()
user_id = self.global_userids['contributor']
DocumentRest.create_new_version(self.route, user_id)
self.route_version = self.session.query(DocumentVersion). \
filter(DocumentVersion.document_id == self.route.document_id). \
filter(DocumentVersion.lang == 'en').first()
self.route2 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1',
locales=[
RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
gear='paraglider'),
RouteLocale(lang='fr',
title='Mont Blanc du ciel',
description='...',
gear='paraglider')
])
self.session.add(self.route2)
self.session.flush()
DocumentRest.create_new_version(self.route2, user_id)
self.route3 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=500,
height_diff_down=500,
durations='1')
self.session.add(self.route3)
self.route4 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=500,
height_diff_down=500,
durations='1')
self.route4.locales.append(
RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
gear='paraglider'))
self.route4.locales.append(
RouteLocale(lang='fr',
title='Mont Blanc du ciel',
description='...',
gear='paraglider'))
self.session.add(self.route4)
# add a map
self.session.add(
TopoMap(
code='3232ET',
editor='IGN',
scale='25000',
locales=[DocumentLocale(lang='fr', title='Belley')],
geometry=DocumentGeometry(
geom_detail=
'SRID=3857;POLYGON((635900 5723600, 635900 5723700, 636000 5723700, 636000 5723600, 635900 5723600))'
) # noqa
))
# add some associations
self.waypoint = Waypoint(
waypoint_type='summit',
elevation=4,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint.locales.append(
WaypointLocale(lang='en',
title='Mont Granier (en)',
description='...',
access='yep'))
self.waypoint.locales.append(
WaypointLocale(lang='fr',
title='Mont Granier (fr)',
description='...',
access='ouai'))
self.session.add(self.waypoint)
self.waypoint2 = Waypoint(
waypoint_type='summit',
elevation=4,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint2.locales.append(
WaypointLocale(lang='en',
title='Mont Granier (en)',
description='...',
access='yep'))
self.session.add(self.waypoint2)
self.session.flush()
self.session.add(
Association(parent_document_id=self.route.document_id,
child_document_id=self.route4.document_id))
self.session.add(
Association(parent_document_id=self.route4.document_id,
child_document_id=self.route.document_id))
self.session.add(
Association(parent_document_id=self.waypoint.document_id,
child_document_id=self.route.document_id))
self.outing1 = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.session.add(self.outing1)
self.session.flush()
self.session.add(
Association(parent_document_id=self.route.document_id,
child_document_id=self.outing1.document_id))
self.outing2 = Outing(redirects_to=self.outing1.document_id,
activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.session.add(self.outing2)
self.session.flush()
self.session.add(
Association(parent_document_id=self.route.document_id,
child_document_id=self.outing2.document_id))
self.session.flush()
# add areas
self.area1 = Area(
area_type='range',
geometry=DocumentGeometry(
geom_detail=
'SRID=3857;POLYGON((635900 5723600, 635900 5723700, 636000 5723700, 636000 5723600, 635900 5723600))' # noqa
))
self.area2 = Area(area_type='range',
locales=[DocumentLocale(lang='fr', title='France')])
self.session.add_all([self.area1, self.area2])
self.session.flush()
def setUp(self): # noqa
super(TestDocumentDeleteRest, self).setUp()
self._prefix = '/documents/delete/'
user_id = self.global_userids['contributor']
self.waypoint1 = Waypoint(
waypoint_type='summit',
elevation=2000,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='fr',
title='Dent de Crolles',
description='...',
summary='La Dent de Crolles')
])
self.session.add(self.waypoint1)
self.waypoint2 = Waypoint(
waypoint_type='summit',
elevation=4985,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='en',
title='Mont Blanc',
description='...',
document_topic=DocumentTopic(topic_id=1),
summary='The heighest point in Europe')
])
self.session.add(self.waypoint2)
self.waypoint3 = Waypoint(
waypoint_type='summit',
elevation=3,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint3.locales.append(
WaypointLocale(lang='en',
title='Mont Granier',
description='...',
access='yep',
document_topic=DocumentTopic(topic_id=2)))
self.waypoint3.locales.append(
WaypointLocale(lang='fr',
title='Mont Granier',
description='...',
access='ouai',
document_topic=DocumentTopic(topic_id=3)))
self.session.add(self.waypoint3)
self.session.flush()
self.waypoint4 = Waypoint(
waypoint_type='summit',
elevation=3,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint4.locales.append(
WaypointLocale(lang='en', title='Mont Ventoux', description='...'))
self.session.add(self.waypoint4)
self.session.flush()
DocumentRest.create_new_version(self.waypoint1, user_id)
update_feed_document_create(self.waypoint1, user_id)
DocumentRest.create_new_version(self.waypoint2, user_id)
update_feed_document_create(self.waypoint2, user_id)
DocumentRest.create_new_version(self.waypoint3, user_id)
update_feed_document_create(self.waypoint3, user_id)
DocumentRest.create_new_version(self.waypoint4, user_id)
update_feed_document_create(self.waypoint4, user_id)
self.session.flush()
route1_geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.route1 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1',
main_waypoint_id=self.waypoint1.document_id,
geometry=route1_geometry)
self.route1.locales.append(
RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
title_prefix='Mont Blanc :',
gear='paraglider'))
self.session.add(self.route1)
route2_geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.route2 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1',
geometry=route2_geometry)
self.route2.locales.append(
RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
title_prefix='Mont Blanc :',
gear='paraglider',
document_topic=DocumentTopic(topic_id=4)))
self.session.add(self.route2)
self.session.flush()
self._add_association(self.waypoint1, self.route1)
self._add_association(self.waypoint2, self.route2)
self.session.flush()
route3_geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.route3 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations='1',
geometry=route3_geometry)
self.route3.locales.append(
RouteLocale(lang='en',
title='Mont Blanc from the air',
description='...',
title_prefix='Mont Blanc :',
gear='paraglider',
document_topic=DocumentTopic(topic_id=5)))
self.session.add(self.route3)
self.session.flush()
DocumentRest.create_new_version(self.route1, user_id)
update_feed_document_create(self.route1, user_id)
DocumentRest.create_new_version(self.route2, user_id)
update_feed_document_create(self.route2, user_id)
DocumentRest.create_new_version(self.route3, user_id)
update_feed_document_create(self.route3, user_id)
self._add_association(self.waypoint1, self.route3)
self._add_association(self.waypoint2, self.route3)
self._add_association(self.waypoint3, self.route3)
self._add_tag(self.route3)
self.session.flush()
outing1_geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.outing1 = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
geometry=outing1_geometry,
locales=[
OutingLocale(
lang='en',
title='...',
description='...',
weather='sunny',
document_topic=DocumentTopic(topic_id=6))
])
self.session.add(self.outing1)
self.session.flush()
DocumentRest.create_new_version(self.outing1, user_id)
update_feed_document_create(self.outing1, user_id)
self._add_association(self.route1, self.outing1)
self.session.flush()
outing1b_geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.outing1b = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
geometry=outing1b_geometry,
redirects_to=self.outing1.document_id,
locales=[
OutingLocale(lang='en',
title='...',
description='...',
weather='sunny')
])
self.session.add(self.outing1b)
self.session.flush()
DocumentRest.create_new_version(self.outing1b, user_id)
self.session.flush()
outing2_geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.outing2 = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
geometry=outing2_geometry,
locales=[
OutingLocale(
lang='en',
title='...',
description='...',
weather='sunny',
document_topic=DocumentTopic(topic_id=7))
])
self.session.add(self.outing2)
self.session.flush()
DocumentRest.create_new_version(self.outing2, user_id)
update_feed_document_create(self.outing2, user_id)
self._add_association(self.route2, self.outing2)
self._add_association(self.route3, self.outing2)
self.session.flush()
self.article1 = Article(
activities=['skitouring'],
categories=['gear'],
article_type='personal',
locales=[
DocumentLocale(lang='en',
title='Some article',
description='Some content',
document_topic=DocumentTopic(topic_id=8))
])
self.session.add(self.article1)
self.session.flush()
DocumentRest.create_new_version(self.article1, user_id)
update_feed_document_create(self.article1, user_id)
self.session.flush()
self.article1.locales[0].title = 'Some other article title'
article1_lang = self.article1.locales[0].lang
self.session.flush()
DocumentRest.update_version(self.article1, user_id, 'new title',
[UpdateType.LANG], [article1_lang])
self.session.flush()
self._add_association(self.route2, self.article1)
self._add_association(self.outing2, self.article1)
self.session.flush()
self.article2 = Article(activities=['skitouring'],
categories=['gear'],
article_type='personal',
locales=[
DocumentLocale(lang='en',
title='Some other article',
description='Some content')
])
self.session.add(self.article2)
self.session.flush()
# Make the article older than 24h old
written_at = datetime.datetime(2016, 1, 1, 0, 0, 0)
DocumentRest.create_new_version(self.article2, user_id, written_at)
update_feed_document_create(self.article2, user_id)
self.session.flush()
self.book1 = Book(activities=['skitouring'],
book_types=['biography'],
locales=[
DocumentLocale(
lang='en',
title='Some book',
description='Some content',
document_topic=DocumentTopic(topic_id=9))
])
self.session.add(self.book1)
self.session.flush()
DocumentRest.create_new_version(self.book1, user_id)
update_feed_document_create(self.book1, user_id)
self._add_association(self.book1, self.route2)
self._add_association(self.book1, self.route3)
self.session.flush()
self.xreport1 = Xreport(
event_activity='alpine_climbing',
event_type='stone_ice_fall',
locales=[
XreportLocale(lang='en',
title='Lac d\'Annecy',
place='some place descrip. in english',
document_topic=DocumentTopic(topic_id=10)),
XreportLocale(lang='fr',
title='Lac d\'Annecy',
place='some place descrip. in french',
document_topic=DocumentTopic(topic_id=11))
])
self.session.add(self.xreport1)
self.session.flush()
DocumentRest.create_new_version(self.xreport1, user_id)
update_feed_document_create(self.xreport1, user_id)
self._add_association(self.outing2, self.xreport1)
self._add_association(self.route3, self.xreport1)
self.session.flush()
self.image1 = Image(filename='image1.jpg',
activities=['paragliding'],
height=1500,
image_type='collaborative',
locales=[
DocumentLocale(
lang='en',
title='Mont Blanc from the air',
description='...',
document_topic=DocumentTopic(topic_id=12))
])
self.session.add(self.image1)
self.session.flush()
DocumentRest.create_new_version(self.image1, user_id)
self._add_association(self.outing1, self.image1)
self._add_association(self.route3, self.image1)
self._add_association(self.waypoint3, self.image1)
self.session.flush()
update_feed_images_upload(
[self.image1],
[{
'filename': 'image1.jpg',
'activities': ['paragliding'],
'image_type': 'collaborative',
'height': 1500,
'locales': [{
'lang': 'en',
'title': 'Mont Blanc from the air'
}],
'associations': {
'outings': [{
'document_id': self.outing1.document_id
}],
'routes': [{
'document_id': self.route3.document_id
}],
'waypoints': [{
'document_id': self.waypoint3.document_id
}]
}
}], user_id)
self.image1.filename = 'image1.1.jpg'
self.session.flush()
DocumentRest.update_version(self.image1, user_id, 'changed filename',
[UpdateType.FIGURES], [])
self.session.flush()
self.topo_map1 = TopoMap(
code='3232ET',
editor='IGN',
scale='25000',
locales=[DocumentLocale(lang='fr', title='Belley')],
geometry=DocumentGeometry(
geom_detail=
'SRID=3857;POLYGON((611774.917032556 5706934.10657514,611774.917032556 5744215.5846397,642834.402570357 5744215.5846397,642834.402570357 5706934.10657514,611774.917032556 5706934.10657514))'
) # noqa
)
self.session.add(self.topo_map1)
self.session.flush()
self.session.add(
TopoMapAssociation(document=self.waypoint2,
topo_map=self.topo_map1))
self.session.add(
TopoMapAssociation(document=self.waypoint3,
topo_map=self.topo_map1))
self.session.add(
TopoMapAssociation(document=self.route2, topo_map=self.topo_map1))
self.session.add(
TopoMapAssociation(document=self.route3, topo_map=self.topo_map1))
self.session.flush()
self.area1 = Area(
area_type='range',
geometry=DocumentGeometry(
geom_detail=
'SRID=3857;POLYGON((611774.917032556 5706934.10657514,611774.917032556 5744215.5846397,642834.402570357 5744215.5846397,642834.402570357 5706934.10657514,611774.917032556 5706934.10657514))' # noqa
))
self.session.add(self.area1)
self.session.flush()
self.session.add(
AreaAssociation(document=self.waypoint2, area=self.area1))
self.session.add(
AreaAssociation(document=self.waypoint3, area=self.area1))
self.session.add(AreaAssociation(document=self.route2,
area=self.area1))
self.session.add(AreaAssociation(document=self.route3,
area=self.area1))
self.session.flush()
def test_fill_index(self):
"""Tests that documents are inserted into the ElasticSearch index.
"""
self.session.add(
Waypoint(document_id=71171,
waypoint_type='summit',
elevation=2000,
quality='medium',
access_time='15min',
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='fr',
title='Mont Granier',
description='...',
summary='Le Mont [b]Granier[/b]'),
WaypointLocale(lang='en',
title='Mont Granier',
description='...',
summary='The Mont Granier')
]))
self.session.add(
Waypoint(document_id=71172,
waypoint_type='summit',
elevation=4985,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='en',
title='Mont Blanc',
description='...',
summary='The heighest point in Europe')
]))
self.session.add(
Route(document_id=71173,
activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800,
durations=['1'],
locales=[
RouteLocale(lang='en',
title='Face N',
description='...',
gear='paraglider',
title_prefix='Mont Blanc')
]))
self.session.add(
Waypoint(document_id=71174,
redirects_to=71171,
waypoint_type='summit',
elevation=4985,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='en',
title='Mont Blanc',
description='...',
summary='The heighest point in Europe')
]))
self.session.add(
Outing(document_id=71175,
activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
frequentation='overcrowded',
locales=[
OutingLocale(lang='en',
title='Mont Blanc : Face N !',
description='...',
weather='sunny')
]))
self.session.add(
Article(document_id=71176,
categories=['site_info'],
activities=['hiking'],
article_type='collab',
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'),
locales=[
DocumentLocale(lang='en',
title='Lac d\'Annecy',
description='...',
summary=''),
DocumentLocale(lang='fr',
title='Lac d\'Annecy',
description='...',
summary='')
]))
self.session.flush()
self.session.add(
Book(document_id=71177,
activities=['hiking'],
book_types=['biography'],
author='Denis Dainat',
publication_date='',
locales=[
DocumentLocale(lang='fr',
title='Escalades au Thaurac',
description='...',
summary=''),
DocumentLocale(lang='en',
title='Escalades au Thaurac',
description='...',
summary='')
]))
self.session.flush()
self.session.add(
Xreport(document_id=71178,
event_type='person_fall',
event_activity='skitouring',
nb_participants=10,
elevation=1500,
date=datetime.date(2016, 1, 1),
locales=[
XreportLocale(lang='en',
title='Death in the mountains',
description='...',
place='some place description')
]))
self.session.flush()
# fill the ElasticSearch index
fill_index(self.session)
waypoint1 = SearchWaypoint.get(id=71171)
self.assertIsNotNone(waypoint1)
self.assertEqual(waypoint1.title_en, 'Mont Granier')
self.assertEqual(waypoint1.title_fr, 'Mont Granier')
# self.assertEqual(waypoint1.summary_fr, 'Le Mont Granier ')
self.assertEqual(waypoint1.doc_type, 'w')
self.assertEqual(waypoint1.quality, 2)
self.assertEqual(waypoint1.access_time, 3)
self.assertAlmostEqual(waypoint1.geom[0], 5.71288994)
self.assertAlmostEqual(waypoint1.geom[1], 45.64476395)
waypoint2 = SearchWaypoint.get(id=71172)
self.assertIsNotNone(waypoint2)
self.assertEqual(waypoint2.title_en, 'Mont Blanc')
self.assertIsNone(waypoint2.title_fr)
self.assertEqual(waypoint2.doc_type, 'w')
route = SearchRoute.get(id=71173)
self.assertIsNotNone(route)
self.assertEqual(route.title_en, 'Mont Blanc : Face N')
self.assertIsNone(route.title_fr)
self.assertEqual(route.doc_type, 'r')
self.assertEqual(route.durations, [0])
outing = SearchOuting.get(id=71175)
self.assertIsNotNone(outing)
self.assertEqual(outing.title_en, 'Mont Blanc : Face N !')
self.assertIsNone(outing.title_fr)
self.assertEqual(outing.doc_type, 'o')
self.assertEqual(outing.frequentation, 3)
article = SearchArticle.get(id=71176)
self.assertIsNotNone(article)
self.assertEqual(article.title_en, 'Lac d\'Annecy')
self.assertEqual(article.title_fr, 'Lac d\'Annecy')
self.assertEqual(article.doc_type, 'c')
book = SearchBook.get(id=71177)
self.assertIsNotNone(book)
self.assertEqual(book.title_en, 'Escalades au Thaurac')
self.assertEqual(book.title_fr, 'Escalades au Thaurac')
self.assertEqual(book.doc_type, 'b')
self.assertEqual(book.book_types, ['biography'])
xreport = SearchXreport.get(id=71178)
self.assertIsNotNone(xreport)
self.assertEqual(xreport.title_en, 'Death in the mountains')
self.assertEqual(xreport.doc_type, 'x')
# merged document is ignored
self.assertIsNone(SearchWaypoint.get(id=71174, ignore=404))
# check that the sync. status was updated
last_update, _ = es_sync.get_status(self.session)
self.assertIsNotNone(last_update)
def _add_test_data(self):
self.contributor = self.session.query(User).get(
self.global_userids['contributor'])
self.contributor2 = self.session.query(User).get(
self.global_userids['contributor2'])
DocumentRest.create_new_version(self.contributor.profile,
self.contributor.id)
ml = Mailinglist(
listname='avalanche',
user_id=self.contributor.id,
email=self.contributor.email)
self.session.add(ml)
area = Area(
area_type='range',
locales=[DocumentLocale(lang='fr', title='Chartreuse')],
geometry=DocumentGeometry(
geom_detail='SRID=3857;POLYGON((668518.249382151 5728802.39591739,668518.249382151 5745465.66808356,689156.247019149 5745465.66808356,689156.247019149 5728802.39591739,668518.249382151 5728802.39591739))' # noqa
)
)
self.session.add(area)
self.session.add(AreaAssociation(
document=self.contributor.profile, area=area))
self.session.flush()
self.map1 = TopoMap(
code='3232ET', editor='IGN', scale='25000',
locales=[
DocumentLocale(lang='fr', title='Belley')
],
geometry=DocumentGeometry(geom_detail='SRID=3857;POLYGON((611774.917032556 5706934.10657514,611774.917032556 5744215.5846397,642834.402570357 5744215.5846397,642834.402570357 5706934.10657514,611774.917032556 5706934.10657514))') # noqa
)
self.session.add(self.map1)
self.session.flush()
self.session.add(TopoMapAssociation(
document=self.contributor.profile,
topo_map=self.map1))
self.session.flush()
self.waypoint1 = Waypoint(
waypoint_type='summit', elevation=2203,
locales=[WaypointLocale(lang='en', title='Mont Granier')],
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'))
self.session.add(self.waypoint1)
self.session.flush()
DocumentRest.create_new_version(self.waypoint1, self.contributor.id)
update_feed_document_create(self.waypoint1, self.contributor.id)
route1_geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)',
geom='SRID=3857;POINT(635961 5723624)')
self.route1 = Route(
activities=['skitouring'], geometry=route1_geometry)
self.route1.locales.append(RouteLocale(
lang='en', title='Mont Blanc from the air', description='...',
title_prefix='Mont Blanc :', gear='paraglider'))
self.session.add(self.route1)
self.session.flush()
DocumentRest.create_new_version(self.route1, self.contributor.id)
update_feed_document_create(self.route1, self.contributor.id)
self.session.add(Association.create(
parent_document=self.waypoint1,
child_document=self.route1))
self.outing1 = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1), elevation_max=1500,
locales=[OutingLocale(lang='en', title='foo')],
geometry=DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)' # noqa
)
)
self.session.add(self.outing1)
self.session.flush()
DocumentRest.create_new_version(self.outing1, self.contributor.id)
update_feed_document_create(self.outing1, self.contributor.id)
self.outing2 = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1), elevation_max=1500,
locales=[OutingLocale(lang='en', title='foo')],
geometry=DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)' # noqa
)
)
self.session.add(self.outing2)
self.session.flush()
DocumentRest.create_new_version(self.outing2, self.contributor.id)
update_feed_document_create(self.outing2, self.contributor.id)
self.session.add(Association(
parent_document_id=self.contributor.id,
parent_document_type=USERPROFILE_TYPE,
child_document_id=self.outing1.document_id,
child_document_type=OUTING_TYPE))
self.session.add(Association(
parent_document_id=self.contributor.id,
parent_document_type=USERPROFILE_TYPE,
child_document_id=self.outing2.document_id,
child_document_type=OUTING_TYPE))
self.session.add(Association(
parent_document_id=self.contributor2.id,
parent_document_type=USERPROFILE_TYPE,
child_document_id=self.outing2.document_id,
child_document_type=OUTING_TYPE))
self.session.add(DocumentTag(
document_id=self.route1.document_id, document_type=ROUTE_TYPE,
user_id=self.contributor.id))
self.session.add(DocumentTagLog(
document_id=self.route1.document_id, document_type=ROUTE_TYPE,
user_id=self.contributor.id, is_creation=True))
self.session.flush()
def setUp(self):
super(TestChangesDocumentRest, self).setUp()
self._prefix = '/documents/changes'
contributor_id = self.global_userids['contributor']
self.waypoint1 = Waypoint(
waypoint_type='summit',
elevation=2000,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='fr',
title='Dent de Crolles',
description='...',
summary='La Dent de Crolles')
])
self.session.add(self.waypoint1)
self.session.flush()
DocumentRest.create_new_version(self.waypoint1, contributor_id)
self.session.flush()
self.waypoint2 = Waypoint(
waypoint_type='summit',
elevation=4985,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='en',
title='Mont Blanc',
description='...',
summary='The heighest point in Europe')
])
self.session.add(self.waypoint2)
self.session.flush()
DocumentRest.create_new_version(self.waypoint2, contributor_id)
self.session.flush()
self.waypoint3 = Waypoint(
waypoint_type='summit',
elevation=4985,
redirects_to=self.waypoint1.document_id,
geometry=DocumentGeometry(geom='SRID=3857;POINT(635956 5723604)'),
locales=[
WaypointLocale(lang='en',
title='Mont Blanc',
description='...',
summary='The heighest point in Europe')
])
self.session.add(self.waypoint3)
self.session.flush()
DocumentRest.create_new_version(self.waypoint3, contributor_id)
self.session.flush()
self.route1 = Route(activities=['skitouring'],
elevation_max=1500,
elevation_min=700,
main_waypoint_id=self.waypoint1.document_id,
locales=[
RouteLocale(lang='fr',
title='Mont Blanc du ciel',
description='...',
summary='Ski')
])
self.session.add(self.route1)
self.session.flush()
DocumentRest.create_new_version(self.route1, contributor_id)
self.session.flush()
self.outing = Outing(activities=['skitouring'],
date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1),
elevation_max=1500,
elevation_min=700,
height_diff_up=800,
height_diff_down=800)
self.session.add(self.outing)
self.session.flush()
DocumentRest.create_new_version(self.outing, contributor_id)
self.session.flush()
self.profile2 = UserProfile(categories=['amateur'])
self.session.add(self.profile2)
self.session.flush()
version_count = self.session.query(DocumentVersion).count()
self.assertEqual(4, version_count)
hist_meta_count = self.session.query(HistoryMetaData).count()
self.assertEqual(5, hist_meta_count)
def _add_test_data(self):
self.outing = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 1, 1),
date_end=datetime.date(2016, 1, 1), elevation_max=1500,
elevation_min=700, height_diff_up=800, height_diff_down=800
)
self.locale_en = OutingLocale(
lang='en', title='Mont Blanc from the air', description='...',
weather='sunny')
self.locale_fr = OutingLocale(
lang='fr', title='Mont Blanc du ciel', description='...',
weather='grand beau')
self.outing.locales.append(self.locale_en)
self.outing.locales.append(self.locale_fr)
self.outing.geometry = DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)')
self.session.add(self.outing)
self.session.flush()
user_id = self.global_userids['contributor']
DocumentRest.create_new_version(self.outing, user_id)
self.outing_version = self.session.query(DocumentVersion). \
filter(DocumentVersion.document_id == self.outing.document_id). \
filter(DocumentVersion.lang == 'en').first()
self.outing2 = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 2, 1),
date_end=datetime.date(2016, 2, 1)
)
self.session.add(self.outing2)
self.outing3 = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 2, 1),
date_end=datetime.date(2016, 2, 2)
)
self.session.add(self.outing3)
self.outing4 = Outing(
activities=['skitouring'], date_start=datetime.date(2016, 2, 1),
date_end=datetime.date(2016, 2, 3)
)
self.outing4.locales.append(OutingLocale(
lang='en', title='Mont Granier (en)', description='...'))
self.outing4.locales.append(OutingLocale(
lang='fr', title='Mont Granier (fr)', description='...'))
self.session.add(self.outing4)
self.waypoint = Waypoint(
waypoint_type='summit', elevation=4,
geometry=DocumentGeometry(
geom='SRID=3857;POINT(635956 5723604)'))
self.waypoint.locales.append(WaypointLocale(
lang='en', title='Mont Granier (en)', description='...',
access='yep'))
self.waypoint.locales.append(WaypointLocale(
lang='fr', title='Mont Granier (fr)', description='...',
access='ouai'))
self.session.add(self.waypoint)
self.image = Image(filename='20160101-00:00:00.jpg')
self.image.locales.append(DocumentLocale(lang='en', title='...'))
self.session.add(self.image)
self.session.flush()
# add some associations
self.route = Route(
activities=['skitouring'], elevation_max=1500, elevation_min=700,
height_diff_up=800, height_diff_down=800, durations='1',
geometry=DocumentGeometry(
geom_detail='SRID=3857;LINESTRING(635956 5723604, 635966 5723644)', # noqa
geom='SRID=3857;POINT(635961 5723624)'
))
self.route.locales.append(RouteLocale(
lang='en', title='Mont Blanc from the air', description='...',
gear='paraglider', title_prefix='Main waypoint title'))
self.route.locales.append(RouteLocale(
lang='fr', title='Mont Blanc du ciel', description='...',
gear='paraglider'))
self.session.add(self.route)
self.session.flush()
self.session.add(Association(
parent_document_id=self.waypoint.document_id,
child_document_id=self.route.document_id))
self.session.add(Association(
parent_document_id=self.route.document_id,
child_document_id=self.outing.document_id))
self.session.add(Association(
parent_document_id=user_id,
child_document_id=self.outing.document_id))
self.session.add(Association(
parent_document_id=self.outing.document_id,
child_document_id=self.image.document_id))
self.session.flush()