Python Section_T 예제들

예제 #1

파일: views.py 프로젝트: saditahmid/spm

def assessment(request):
    if request.method == 'POST':
        faculty_id = request.user.username
        course_id = request.POST.get('course-id')
        sectionNo = request.POST.get('section')
        coMarks = request.POST.getlist('coMarks')
        
        section_id = None
        try:
            section_id = Section_T.objects.raw('''
                SELECT *
                FROM mainapp_section_t
                WHERE course_id = '{}' AND sectionNo = {};
            '''.format(course_id, sectionNo))
            section_id = section_id[0].id
        except:
            section_id = None
        
        if section_id is None:
            section = Section_T(sectionNo=sectionNo, course_id=course_id, faculty_id=faculty_id)
            section.save()
            section_id = section.id
            
        for j in range(1, len(coMarks) + 1):
            co_id = CO_T.objects.raw('''
                SELECT *
                FROM mainapp_co_t
                WHERE course_id = '{}' AND coNo = {}
            '''.format(course_id, j))
            assessment = Assessment_T(section_id=section_id, co_id=co_id[0].id, marks=coMarks[j - 1])
            assessment.save()
            
        return redirect('dataentry')

예제 #2

faculty.save()

# Course

for i in datalist:
    course = Course_T(courseID=i[1], program_id='BSc', noOfCredits=3)
    course.save()

# Sections
sections = []
for i in datalist:
    if i[2] not in sections:
        sections.append(i[2])

for i in sections:
    section = Section_T(sectionNo=i, course_id='CSE303', faculty_id='1234')
    section.save()

# Student

student = Student_T(studentID='1820750',
                    fname='Mayabee',
                    lname='Tahsin',
                    department_id='CSE',
                    program_id='BSc')
student.save()

for i in datalist:
    student = Student_T(studentID=i[0], department_id='CSE', program_id='BSc')
    student.save()

예제 #3

# for i in datalist:
#     course = Course_T(courseID=i[1], program_id='BSc', noOfCredits=3)
#     course.save()
course = Course_T(courseNameAll, program_id='BSc', noOfCredits=3)
course.save()

# Sections
sections = []
for i in datalist:
    if i[2] not in sections:
        sections.append(i[2])

for i in sections:
    section = Section_T(sectionNo=i,
                        course_id=courseNameAll,
                        faculty_id=facultyIDNum)
    section.save()

# Student

# student = Student_T(studentID='1820750', fname='Mayabee', lname='Tahsin', department_id='CSE', program_id='BSc')
# student.save()

# for i in datalist:
#     student = Student_T(studentID=i[0], department_id='CSE', program_id='BSc')
#     student.save()

# Enrollment

for i in datalist:

예제 #4

파일: datascript_CSE101.py 프로젝트: saditahmid/spm

# for i in datalist:
#     course = Course_T(courseID=i[1], program_id='BSc', noOfCredits=3)
#     course.save()
course = Course_T('CSE101', program_id='BSc', noOfCredits=3)
course.save()


# Sections
sections = []
for i in datalist:
    if i[2] not in sections:
        sections.append(i[2])

for i in sections:
    section = Section_T(sectionNo=i, course_id='CSE101', faculty_id='4321')
    section.save()


# Student

# student = Student_T(studentID='1820750', fname='Mayabee', lname='Tahsin', department_id='CSE', program_id='BSc')
# student.save()

# for i in datalist:
#     student = Student_T(studentID=i[0], department_id='CSE', program_id='BSc')
#     student.save()


# Enrollment

예제 #5

파일: datascript_CSE104.py 프로젝트: armunalam/spm

# for i in datalist:
#     course = Course_T(courseID=i[1], program_id='BSc', noOfCredits=3)
#     course.save()
course = Course_T('CSE104', program_id='BSc', noOfCredits=3)
course.save()


# Sections
sections = []
for i in datalist:
    if i[2] not in sections:
        sections.append(i[2])

for i in sections:
    section = Section_T(sectionNo=i, course_id='CSE104', faculty_id='1235')
    section.save()


# Student

# student = Student_T(studentID='1820750', fname='Mayabee', lname='Tahsin', department_id='CSE', program_id='BSc')
# student.save()

# for i in datalist:
#     student = Student_T(studentID=i[0], department_id='CSE', program_id='BSc')
#     student.save()


# Enrollment