def test_model_name_lower(self):
self.assertEqual(TripTemplate.model_name_lower(), 'triptemplate')
# Should also work for deferred models, which are dynamically created
mommy.make(TripTemplate)
triptemplate = TripTemplate.objects.defer('name').get()
self.assertEqual(triptemplate.model_name_lower(), 'triptemplate')
def test_model_name_lower(self):
self.assertEqual(TripTemplate.model_name_lower(), "triptemplate")
# Should also work for deferred models, which are dynamically created
mommy.make(TripTemplate)
triptemplate = TripTemplate.objects.defer("name").get()
self.assertEqual(triptemplate.model_name_lower(), "triptemplate")
def migrate_triptemplates():
connection = setup_connection()
sql = 'SELECT * FROM ft2014_triptemplate;'
for row in connection.execute(sql):
pickup_id = row['pickup_transportationstop_id']
if pickup_id is None:
pickup_id = walk_to_lodge_transport_stop().id
introduction = row['desc_introduction']
if introduction is None:
introduction = ''
day1 = row['desc_day1']
if day1 is None:
day1 = ''
day2 = row['desc_day2']
if day2 is None:
day2 = ''
day3 = row['desc_day3']
if day3 is None:
day3 = ''
conclusion = row['desc_conclusion']
if conclusion is None:
conclusion = ''
revision_notes = row['desc_revision']
if revision_notes is None:
revision_notes = ''
campsite1_id = row['night1_tripcampsite_id']
campsite2_id = row['night2_tripcampsite_id']
# template is missing campsite
if campsite1_id is None and campsite2_id is None and row['name'] == '939':
campsite = Campsite.objects.get(name='Beaver Brook Shelter')
print(campsite)
campsite1_id = campsite.id
campsite2_id = campsite.id
triptemplate = TripTemplate(
id=row['id'],
name=row['name'],
triptype_id=row['triptype_id'],
max_trippees=row['maximum_trippees'],
non_swimmers_allowed=row['non_swimmers_allowed'],
dropoff_id=row['dropoff_transportationstop_id'],
pickup_id=pickup_id,
return_route_id=row['return_transportationroute_id'],
campsite1_id=campsite1_id,
campsite2_id=campsite2_id,
description_summary=row['desc_summary'],
description_introduction=introduction,
description_day1=day1,
description_day2=day2,
description_day3=day3,
description_conclusion=conclusion,
revision_notes=revision_notes,
trips_year=trips_year())
triptemplate.save()
print('Added triptemplate ' + str(triptemplate))
def migrate_triptemplates():
connection = setup_connection()
sql = 'SELECT * FROM ft2014_triptemplate;'
for row in connection.execute(sql):
pickup_id = row['pickup_transportationstop_id']
if pickup_id is None:
pickup_id = walk_to_lodge_transport_stop().id
introduction = row['desc_introduction']
if introduction is None:
introduction = ''
day1 = row['desc_day1']
if day1 is None:
day1 = ''
day2 = row['desc_day2']
if day2 is None:
day2 = ''
day3 = row['desc_day3']
if day3 is None:
day3 = ''
conclusion = row['desc_conclusion']
if conclusion is None:
conclusion = ''
revision_notes = row['desc_revision']
if revision_notes is None:
revision_notes = ''
campsite1_id = row['night1_tripcampsite_id']
campsite2_id = row['night2_tripcampsite_id']
# template is missing campsite
if campsite1_id is None and campsite2_id is None and row[
'name'] == '939':
campsite = Campsite.objects.get(name='Beaver Brook Shelter')
print(campsite)
campsite1_id = campsite.id
campsite2_id = campsite.id
triptemplate = TripTemplate(
id=row['id'],
name=row['name'],
triptype_id=row['triptype_id'],
max_trippees=row['maximum_trippees'],
non_swimmers_allowed=row['non_swimmers_allowed'],
dropoff_id=row['dropoff_transportationstop_id'],
pickup_id=pickup_id,
return_route_id=row['return_transportationroute_id'],
campsite1_id=campsite1_id,
campsite2_id=campsite2_id,
description_summary=row['desc_summary'],
description_introduction=introduction,
description_day1=day1,
description_day2=day2,
description_day3=day3,
description_conclusion=conclusion,
revision_notes=revision_notes,
trips_year=trips_year(),
)
triptemplate.save()
print('Added triptemplate ' + str(triptemplate))
