def stu_details(request):
if request.method == 'POST':
if request.POST.get('usn') != None and request.POST.get(
'name') != None and request.POST.get(
'sem') != None and request.POST.get('dept') != None:
print("Hie")
form = Student()
form.USN = request.POST['usn']
form.name = request.POST['name']
form.sem = request.POST['sem']
form.Dept = request.POST['dept']
form.save()
return redirect('accounts:signup')
else:
form = Student
return render(request, 'accounts/student_details.html')
def insertStudents(request):
print("This is the insert Excel page")
connection = sqlite3.connect('students.db')
cursor = connection.cursor()
if request.method == "POST":
data = request.POST.copy()
student=Student()
student.room_no = data.get('room_no')
student.block = data.get('block')
student.name = data.get('name')
student.mob_no = data.get('mob_no')
student.id_no = data.get('id_no')
print(student.room_no)
student.save()
#sql_insert_single = "INSERT INTO students(ROOMNO, BLOCK, STUDENT, MOBILE, ID) VALUES('{0}', '{1}', '{2}', '{3}', '{4}')".format(room_no, block, student, mobile, id)
#cursor.execute(sql_insert_single)
connection.commit()
connection.close()
return render(request, 'insertStudentExcel.html')
def add(request):
if request.method == "POST":
form = request.POST
student = Student()
student.name = form['name']
student.registration_number = form['registration_number']
student.address = form['address']
student.age = form['age']
#1
student.school = School.objects.get(pk=form['school'])
student.save()
return redirect('students:student_detail',student.pk)
schools = School.objects.all()
context = {'schools': schools}
return render(request, 'students/addStudent.html',context)
def student_add(request):
if request.method == 'POST':
form = StudentForm(request.POST)
if form.is_valid():
student = Student()
student.name = form.cleaned_data['student_name']
student.surname = form.cleaned_data['student_surname'],
student.email = form.cleaned_data['student_email'],
student.phone = form.cleaned_data['student_phone'],
student.package = form.cleaned_data['student_package']
student.save()
return redirect('Student_list')
else:
form = StudentForm(initial={
'student_name': '',
'student_surname': '',
'student_email': '',
'student_phone': '',
'student_package': '',
})
return render(request,'students/edit.html', {'form': form})
def addStudent(request):
if request.method == 'GET':
return HttpResponse(render(request, 'add_student.html'))
elif request.method == 'POST':
name = request.POST.get('name')
surname = request.POST.get('surname')
avg_mark = request.POST.get('avg_mark')
group_id = request.POST.get('group_id')
if int(avg_mark) > 9:
group_id = 2
student = Student()
student.name = name
student.surname = surname
student.avg_mark = avg_mark
student.group_id = group_id
student.save()
return redirect('/groups/all')
# _*_ coding: utf-8 _*_
__author__ = 'Yang Haibo'
__date__ = '2020/4/29 11:48'
# 独立使用django的model
import os
import sys
# 当前文件所在目录
pwd = os.path.dirname(os.path.realpath(__file__))
# 获取工程根目录下的backend目录
pwd = os.path.join(os.path.dirname(os.path.dirname(pwd)), 'backend')
sys.path.append(pwd)
os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'dyezweb.settings')
import django
django.setup()
from students.models import Student
from tools.db.data.students_data import raw_data
for student_detail in raw_data:
student = Student()
student.name = student_detail["name"]
student.gender = student_detail["gender"]
