Exemple #1
0
def import_students(request):
    status = []
    if request.method == 'POST':
        # Convert JSON data to Python object
        data = json.loads(request.raw_post_data)

        validate_credentials(request,
                             settings.API_ALLOWED_HOSTS,
                             settings.API_KEY,
                             data[0]['api_key'])

        # Load users into local database using utility method
        stats = load_users(data[0]['students'], ['Students'])

        status.append('Received %d student records' % stats[0])
        status.append('Updated %d user objects' % stats[1])
        status.append('Created %d user objects' % stats[2])
        if len(stats[3]) > 0:
           status.append('Student records in error:')
           for item in stats[3]:
               status.append(item)
        if len(stats[4]) > 0:
           status.append('Student records with improperly formatted json string in additional_data:')
           for item in stats[4]:
               status.append(item)
    else:
        status.append('Invalid request')

    return HttpResponse('\n'.join(status), mimetype='text/plain')
def import_students(request):
    status = []
    if request.method == "POST":
        # Convert JSON data to Python object
        data = json.loads(request.raw_post_data)

        validate_credentials(request, settings.API_ALLOWED_HOSTS, settings.API_KEY, data[0]["api_key"])

        # Load users into local database using utility method
        stats = load_users(data[0]["students"], ["Students"])

        status.append("Received %d student records" % stats[0])
        status.append("Updated %d user objects" % stats[1])
        status.append("Created %d user objects" % stats[2])
    else:
        status.append("Invalid request")

    return HttpResponse("\n".join(status), mimetype="text/plain")
def import_sections(request):
    status = []
    if request.method == "POST":
        # Convert JSON data to Python object
        data = json.loads(request.raw_post_data)

        validate_credentials(request, settings.API_ALLOWED_HOSTS, settings.API_KEY, data[0].get("api_key", ""))

        # Redefine data variable to the actual section list
        data = data[0]["sections"]

        # Let's keep a count of how many new and updated objects we have
        sections_updated = 0
        sections_created = 0

        # Grab all existing sections and users as well as their associated
        # objects from the database
        all_sections = Section.objects.filter(term=settings.CURRENT_TERM, year=settings.CURRENT_YEAR)
        all_users = UserProfile.objects.filter(user__groups__name="Instructors").select_related()

        for s in data:
            # Get the existing section object or create a new one
            new_section = False
            try:
                section = all_sections.filter(prefix=s["prefix"], number=s["number"], section=s["section"])[0]
            except IndexError:
                section = Section(
                    prefix=s["prefix"], number=s["number"], section=s["section"], term=s["term"], year=s["year"]
                )
                new_section = True

            # Increment counter for appropriate operation type
            if new_section:
                sections_created += 1
            else:
                sections_updated += 1

            # Only update metadata for section if changed
            if section.title != s["title"] or section.credit_hours != s["credit_hours"]:
                section.title = s["title"]
                section.credit_hours = s["credit_hours"]

                section.save()
            elif new_section:
                section.save()

            # Clear existing instructors and add up-to-date list of
            # instructors to section
            section.instructors.clear()
            for i in s["instructors"]:
                instructor_exists = True
                try:
                    instructor = all_users.filter(id_number=i)[0].user
                except IndexError:
                    status.append("Instructor (ID number %s) " "does not exist" % i)
                    instructor_exists = False

                if instructor_exists:
                    section.instructors.add(instructor)

        status.append("Received %d section records" % len(data))
        status.append("Updated %d section objects" % sections_updated)
        status.append("Created %d section objects" % sections_created)
    else:
        status.append("Invalid request")

    return HttpResponse("\n".join(status), mimetype="text/plain")
def import_enrollments(request):
    status = []
    if request.method == "POST":
        # Convert JSON data to Python object
        data = json.loads(request.raw_post_data)

        validate_credentials(request, settings.API_ALLOWED_HOSTS, settings.API_KEY, data[0].get("api_key", ""))

        # Redefine data variable to actual enrollment list
        data = data[0]["enrollments"]

        # Let's keep a count of how many new and updated objects we have
        enrollments_updated = 0
        enrollments_created = 0

        # Grab all existing sections, users, and enrollments as well as
        # their associated objects from the database
        all_sections = Section.objects.filter(term=settings.CURRENT_TERM, year=settings.CURRENT_YEAR)
        all_users = UserProfile.objects.filter(user__groups__name="Students").select_related()
        all_enrollments = Enrollment.objects.filter(
            section__term=settings.CURRENT_TERM, section__year__exact=settings.CURRENT_YEAR
        )

        for e in data:
            section_exists = True
            try:
                section = all_sections.filter(prefix=e["prefix"], number=e["number"], section=e["section"])[0]
            except IndexError:
                status.append("Section (%s%s-%s) does not exist" % (e["prefix"], e["number"], e["section"]))
                section_exists = False

            student_exists = True
            try:
                student = all_users.filter(id_number=e["student"])[0].user
            except IndexError:
                status.append("Student (ID number %s) " "does not exist" % e["student"])
                student_exists = False

            if section_exists and student_exists:
                new_enrollment = False
                try:
                    enrollment = all_enrollments.filter(section=section, student=student)[0]
                except IndexError:
                    enrollment = Enrollment(student=student, section=section)
                    new_enrollment = True

                if new_enrollment:
                    enrollments_created += 1
                else:
                    enrollments_updated += 1

                # Only update metadata for enrollment if changed
                if enrollment.status != e["status"]:
                    enrollment.status = e["status"]
                    enrollment.save()
                elif new_enrollment:
                    enrollment.save()

        status.append("Received %d enrollment records" % len(data))
        status.append("Updated %d enrollment objects" % enrollments_updated)
        status.append("Created %d enrollment objects" % enrollments_created)
    else:
        status.append("Invalid request")

    return HttpResponse("\n".join(status), mimetype="text/plain")
Exemple #5
0
def import_enrollments(request):
    status = []
    if request.method == 'POST':
        # Convert JSON data to Python object
        data = json.loads(request.raw_post_data)

        validate_credentials(request,
                             settings.API_ALLOWED_HOSTS,
                             settings.API_KEY,
                             data[0].get('api_key', ''))

        # Redefine data variable to actual enrollment list
        data = data[0]['enrollments']

        # Let's keep a count of how many new and updated objects we have
        enrollments_updated = 0
        enrollments_created = 0

        # Grab all existing sections, users, and enrollments as well as
        # their associated objects from the database
        existing_sections = get_existing_sections(settings.CURRENT_TERM,
                                                  settings.CURRENT_YEAR)

        id_numbers = []
        for e in data:
            id_numbers.append(e['student'])

        existing_users = get_existing_users(['Students'], id_numbers)
        existing_enrollments = get_existing_enrollments(settings.CURRENT_TERM,
                                                        settings.CURRENT_YEAR)

        for e in data:
            key = '%s%s-%s-%s-%d' % (e['prefix'],
                                     e['number'],
                                     e['section'],
                                     e['term'],
                                     int(e['year']))
            section = existing_sections.get(key)

            section_exists = True
            if not section:
                status.append('Section (%s%s-%s) does not exist' % (
                    e['prefix'],
                    e['number'],
                    e['section']))
                section_exists = False

            student = existing_users.get(e['student'])

            student_exists = True
            if not student:
                status.append('Student (ID number %s) '
                              'does not exist' % e['student'])
                student_exists = False

            if section_exists and student_exists:
                key = '%s-%s%s-%s-%s-%d' % (e['student'],
                                            e['prefix'],
                                            e['number'],
                                            e['section'],
                                            e['term'],
                                            int(e['year']))
                enrollment = existing_enrollments.get(key)

                new_enrollment = False
                if not enrollment:
                    enrollment = Enrollment(student=student, section=section)
                    new_enrollment = True

                if new_enrollment:
                    enrollments_created += 1
                else:
                    enrollments_updated += 1


                # Only update metadata for enrollment if changed
                if enrollment.status != e['status']:
                    enrollment.status = e['status']
                    enrollment.save()
                elif new_enrollment:
                    enrollment.save()

        status.append('Received %d enrollment records' % len(data))
        status.append('Updated %d enrollment objects' % enrollments_updated)
        status.append('Created %d enrollment objects' % enrollments_created)
    else:
        status.append('Invalid request')

    return HttpResponse('\n'.join(status), mimetype='text/plain')
Exemple #6
0
def import_sections(request):
    status = []
    if request.method == 'POST':
        # Convert JSON data to Python object
        data = json.loads(request.raw_post_data)

        validate_credentials(request,
                             settings.API_ALLOWED_HOSTS,
                             settings.API_KEY,
                             data[0].get('api_key', ''))

        # Redefine data variable to the actual section list
        data = data[0]['sections']

        # Let's keep a count of how many new and updated objects we have
        sections_updated = 0
        sections_created = 0

        # Grab all existing sections and users as well as their associated
        # objects from the database
        existing_sections = get_existing_sections(settings.CURRENT_TERM,
                                                  settings.CURRENT_YEAR)

        id_numbers = []
        for s in data:
            for i in s['instructors']:
                id_numbers.append(i)

        existing_users = get_existing_users(['Instructors'], id_numbers)

        for s in data:
            # Get the existing section object or create a new one
            key = '%s%s-%s-%s-%d' % (s['prefix'],
                                     s['number'],
                                     s['section'],
                                     s['term'],
                                     int(s['year']))
            section = existing_sections.get(key)

            new_section = False
            if not section:
                section = Section(prefix=s['prefix'],
                                  number=s['number'],
                                  section=s['section'],
                                  term=s['term'],
                                  year=s['year'])
                new_section = True

            # Increment counter for appropriate operation type
            if new_section:
                sections_created += 1
            else:
                sections_updated += 1

            # Only update metadata for section if changed
            if (section.title != s['title']
                or section.credit_hours != s['credit_hours']):
                section.title= s['title']
                section.credit_hours = s['credit_hours']

                section.save()
            elif new_section:
                section.save()

            # Clear existing instructors and add up-to-date list of
            # instructors to section
            section.instructors.clear()
            for i in s['instructors']:
                instructor = existing_users.get(i)

                instructor_exists = True
                if not instructor:
                    status.append('Instructor (ID number %s) '
                                  'does not exist' % i)
                    instructor_exists = False

                if instructor_exists:
                    section.instructors.add(instructor)


        status.append('Received %d section records' % len(data))
        status.append('Updated %d section objects' % sections_updated)
        status.append('Created %d section objects' % sections_created)
    else:
        status.append('Invalid request')

    return HttpResponse('\n'.join(status), mimetype='text/plain')