AutoShell

dfhdfhhdfdfhdhfhfdhdfdhfdhfdfhhdfdfhdhfhdf AutoShell

?? Editing: importData.py

from rest_framework.views import APIView
from rest_framework.decorators import  api_view
from django.contrib.auth.decorators import login_required
from rest_framework.response import Response
from rest_framework import status
from rest_framework import permissions,authentication
from rest_framework import status, generics
from django.db.models import Prefetch
from django.db.models import Q
import io, csv, pandas as pd
from django.db import  transaction
from django.utils import timezone
import ipaddress
import math
from base.baseHelper import session_semester_config
from students.models import Curriculum,Student,Programme,Registration
from django.http import HttpResponse

@login_required(login_url='index')
@api_view(['POST', "GET"])
def load_student(request):
    # reader=''
    # try:
    #     reader = pd.read_csv("C:/Users/PC/Documents/recsom/New folder/loading/student.csv",encoding='latin1')  
    # except Exception as e:
    #     print("@@@@@@@@@@@@@@@@@@@@@@@@@@@")
    #     print(f"Error reading CSV: {e}")
    
    reader = pd.read_csv("C:/Users/PC/Documents/recsom/New folder/loading/New folder/RCM FILES FOR RUN ICT PORTAL/final/newStudents.csv",encoding='latin1')
    
    with transaction.atomic():
        for  _, row in reader.iterrows():
            inst = Student( 
                matric_number = row[0],
                surname=row[1],
                firstname=row[2], othername=row[3],sex=row[4],birth_date=row[5], address=row[6],lga=row[7],
                current_level=row[8],state_origin=row[9],country=row[10],certificate_awarded=row[11],
                programme= Programme.objects.get(id=row[12]),school=row[13],city_resident=row[14],state_resident=row[15],email=row[16])
            
            inst.save()
      
    return Response({'status':'success','message':'Records updated successfully!','data':len(reader)}, status=status.HTTP_200_OK)

@login_required(login_url='index')
@api_view(['POST', "GET"])
def load_curr(request):
 
    reader = pd.read_csv("C:/Users/PC/Documents/recsom/New folder/loading/curr.csv",encoding='latin1')
    
    with transaction.atomic():
        for  _, row in reader.iterrows():
            inst = Curriculum(
                programme=Programme.objects.get(id = row[0]),
                course_code=row[1],
                status=row[2],
                level=row[3],
                semester=row[4],
                course_title=row[5],
                unit=row[6]
                )
            
            inst.save()
      
    return Response({'status':'success','message':'Records updated successfully!','data':len(reader)}, status=status.HTTP_200_OK)

def get_grade_given_score(score):
    # if math.isnan(int(score)):
    if isinstance(score, str) :
        return "F"
    score = int(score)
    if score >= 70 :
          return "A"
    elif score >= 60 and score < 70:
        return "B"
    elif score >= 50 and score < 60:
        return "C"
    elif score >= 45 and score < 50:
        return "D"   
    elif score >= 40 and score < 45:
        return "E"
    elif score < 40:
        return "F"
    else:
        return "F"

@login_required(login_url='index')
@api_view(['POST', "GET"])
def load_registration(request):
    
    reader = pd.read_csv("C:/Users/PC/Documents/recsom/New folder/loading/New folder/RCM FILES FOR RUN ICT PORTAL/final/newReg-2.csv",encoding='latin1')
    settings = session_semester_config()
    issue_list = []
    res_data = []
    stud = [row.matric_number for row in Student.objects.all()]
    with transaction.atomic():
        for  _, row in reader.iterrows():
            val = f'{str(row[6]).strip().upper()}_{str(row[2]).strip().upper()}_{str(row[0]).strip()[0]}_{str(row[1]).strip()}'
            if val in issue_list:
                continue
            else: 
                # _score = str(row[4])
                inst = Registration(
                            semester = str(row[0]).strip()[0], session_id = str(row[1]).strip(), 
                            course_code = str(row[2]).strip().upper(),
                            status= str(row[3]).strip()[0] ,
                            score = str(row[4]), 
                            level = str(row[5]),
                            matric_number_fk= Student.objects.filter(matric_number=str(row[6]).strip().upper()).first(),
                            grade = get_grade_given_score(row[4]), 
                            unit=  str(row[7]).strip()[0], 
                            last_updated_by = request.user )
                inst.save()
                issue_list.append(f'{str(row[6]).strip().upper()}_{str(row[2]).strip().upper()}_{str(row[0]).strip()[0]}_{str(row[1]).strip()}')
            
            # print(f'{str(row[6]).strip().upper()}_{str(row[2]).strip().upper()}_{str(row[0]).strip()[0]}_{str(row[1]).strip()}')

return Response({'status':'success','message':'Records updated successfully!','data':len(reader), 'issue_list':set(issue_list)}, status=status.HTTP_200_OK)

def generate_csv(request):
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="my_csv_file.csv"'

writer = csv.writer(response)
    writer.writerow(['Column 1', 'Column 2', 'Column 3'])  # Write header row
    writer.writerow(['Value 1', 'Value 2', 'Value 3'])  # Write data row

return response

Path:

home / rcmewpjy / recsom / base / LoadDataAPI /

?? Editing: importData.py

Path:

?? Upload