def setUp(self):
# create base values to test db representations
self.now = datetime.datetime.utcnow()
# create a school to satisfy course requirements
self.school = School()
self.school.name = 'Marshall College'
self.school.save()
# create a course to test relationships
self.course = Course()
self.course.school = self.school
self.course.name = u'Archaeology 101'
self.course.save()
# override Course.save() appending an ID to the slug
self.course.slug = u'archaeology-101'
self.course.save()
# create a note to test against
self.note = Note()
self.note.course = self.course
self.note.name = u"Lecture notes concerning the use of therefore ∴"
self.note.category = Note.LECTURE_NOTES
self.note.uploaded_at = self.now
self.note.text = "This is the plaintext version of a note. It's pretty cool. Alpaca."
self.note.save()
def setup(self):
# create base values to test db representations
self.now = datetime.datetime.utcnow()
# create a school to satisfy course requirements
self.school = School()
self.school.name = 'Marshall College'
self.school.save()
# create a course to test relationships
self.course = Course()
self.course.school = self.school
self.course.name = u'Archaeology 101'
self.course.save()
# override Course.save() appending an ID to the slug
self.course.slug = u'archaeology-101'
self.course.save()
# create a note to test against
self.note = Note()
self.note.course = self.course
self.note.name = u"Lecture notes concerning the use of therefore ∴"
#self.note.slug := do not set for test_remake_slug() behavior
self.note.file_type = 'doc'
self.note.uploaded_at = self.now
self.note.save()
def setUp(self):
self.school = School(name='Northeastern University')
self.school.save()
self.course = Course(name='Intro to Advanced Study',
school=self.school)
self.course.save()
self.client = Client()
def setUp(self):
# create base values to test db representations
self.now = datetime.datetime.utcnow()
# create a school to satisfy course requirements
self.school = School()
self.school.name = 'Marshall College'
self.school.save()
# create a course to test relationships
self.course = Course()
self.course.school = self.school
self.course.name = u'Archaeology 101'
self.course.save()
# override Course.save() appending an ID to the slug
self.course.slug = u'archaeology-101'
self.course.save()
self.user1 = User(username='******')
self.user1.save()
self.user2 = User(username='******')
self.user2.save()
# create a note to test against
self.note = Note()
self.note.course = self.course
self.note.name = u"Lecture notes concerning the use of therefore ∴"
self.note.text = "This is the plaintext version of a note. It's pretty cool."
self.note.user = self.user1
self.note.save()
self.request1 = HttpRequest()
self.request1.user = self.user1
self.request1.method = 'POST'
self.request1.META = {'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest'}
self.request1.session = SessionStore()
self.request2 = HttpRequest()
self.request2.user = self.user2
self.request2.method = 'POST'
self.request2.META = {'HTTP_X_REQUESTED_WITH': 'XMLHttpRequest'}
self.request2.session = SessionStore()
def handle(self, *args, **kwargs):
if len(args) < 1:
self.stdout.write('Provide a filename\n')
return
filename = args[0]
school_dicts = self.parse_school_csv(filename)
self.stdout.write('Importing from list of %d schools\n' %
len(school_dicts))
count = 0
for d in school_dicts:
if 'institution_id' not in d or not d['institution_id']:
print d
raise Exception(
'Error: School does not have an institution_id!')
try:
school = School.objects.get(usde_id=d['institution_id'])
except School.DoesNotExist:
school = School()
#print d['institution_id']
#print d['institution_name']
count += 1
school.name = d['institution_name']
school.location = d['institution_city'] + ', ' + d[
'institution_state']
school.url = d['institution_web_address']
school.usde_id = d['institution_id']
school.save()
self.stdout.write('Imported %d NEW unique schools\n' % count)
