def district_submit(request):
    if not request.user.is_authenticated:
        raise Http404
    state_id = request.POST['state_id']
    state = State.objects.get(id=state_id)
    safe_state = re.sub(' ', '', state.name)
    try:
        if request.POST.get('id'):
            d = District(request.POST['id'])
        else:
            d = District()
        d.code = request.POST['code']
        d.name = request.POST['name']
        d.state_id = state_id
        d.save()

        s = School()
        s.name = 'Multiple Schools'
        s.district = d
        s.code = 'pepper' + safe_state + str(request.POST['code'])
        s.save()
    except Exception as e:
        db.transaction.rollback()
        return HttpResponse(json.dumps({'success': False,'error':'%s' % e}))
    return HttpResponse(json.dumps({'success': True}))
def import_school_submit(request):
    if request.method == 'POST':
        f=request.FILES['file']
        district_id=request.POST.get('district_id')
        count_success=0
        try:
            # --- THIS FAILS ON SING COLUMN CVS ---
            # dialect = csv.Sniffer().sniff(f.read(1024), delimiters=";,\t",quotechar='\n')
            # f.seek(0)
            # r=csv.reader(f,dialect)
            r=csv.reader(f,delimiter='\t', quotechar='|', quoting=csv.QUOTE_MINIMAL)
            for i,line in enumerate(r):
                exist=validate_school_cvs_line(line,district_id)
                school_name=line[SCHOOL_CSV_COL_NAME]
                school_code=line[SCHOOL_CSV_COL_CODE]
                school = School()
                school.name=school_name
                school.code=school_code
                school.district_id=district_id
                school.save()
                count_success=count_success+1
            # commit when all lines imported
            db.transaction.commit()
            # success information
            message={"success": True,
                "message":"Success! %s school(s) imported." % (count_success),
                "count_success":count_success
                }
        except Exception as e:
            db.transaction.rollback()
            # failure information
            message={'success': False,'error':'Import error: %s. At cvs line: %s, Nothing impored.' % (e,count_success+1)}
    return HttpResponse(json.dumps(message))
Exemple #3
0
def school_submit(request):
    if not request.user.is_authenticated:
        raise Http404
    try:
        if request.POST.get("id"):
            d = School(request.POST["id"])
        else:
            d = School()
        d.name = request.POST["name"]
        d.district_id = request.POST["district_id"]
        d.save()
    except Exception as e:
        db.transaction.rollback()
        return HttpResponse(json.dumps({"success": False, "error": "%s" % e}))
    return HttpResponse(json.dumps({"success": True}))
def school_submit(request):
    if not request.user.is_authenticated:
        raise Http404
    try:
        if request.POST.get('id'):
            d=School(request.POST['id'])
        else:
            d=School()
        d.name=request.POST['name']
        d.code=request.POST['code']
        d.district_id=request.POST['district_id']
        d.save()
    except Exception as e:
        db.transaction.rollback()
        return HttpResponse(json.dumps({'success': False,'error':'%s' % e}))
    return HttpResponse(json.dumps({'success': True}))
def import_district_submit(request):
    message = {"success": True}

    if request.method == 'POST':
        f = request.FILES['file']
        count_success = 0
        try:
            r = csv.reader(f, delimiter='\t', quotechar='|', quoting=csv.QUOTE_MINIMAL)
            for i, line in enumerate(r):
                state_name = line[DISTRICT_CSV_COL_STATE_NAME]
                state_id = State.objects.get(name=state_name).id
                safe_state = re.sub(' ', '', state_name)

                validate_district_cvs_line(line)
                d = District()
                d.code = line[DISTRICT_CSV_COL_CODE]
                d.name = line[DISTRICT_CSV_COL_NAME]
                d.state_id = state_id
                d.save()

                s = School()
                s.name = 'Multiple Schools'
                s.district = d
                s.code = 'pepper' + safe_state + str(line[DISTRICT_CSV_COL_CODE])
                s.save()

                count_success += 1

            db.transaction.commit()
            message = {"success": True,
                       "message": "Success! %s district(s) imported." % count_success,
                       "count_success": count_success
                       }
        except Exception as e:

            db.transaction.rollback()
            message = {'success': False,
                       'error': 'Import error: %s. At cvs line: %s, Nothing imported.' % (e, count_success + 1)
                       }

    return HttpResponse(json.dumps(message))