def test_model_file(self): """Test File Model""" folder = Folder(name='test') folder.save() obj = File(name='test', folder=folder) obj.save() self.assertEquals(folder, obj.folder) self.assertNotEquals(obj.id, None) obj.delete()
def convert(request): if request.method=='POST': exfile = str(request.FILES['excelfile'].name) f = File() f.excel = request.FILES['excelfile'] f.save() sheet = pyexcel.get_sheet(file_name=f.excel.name) h=0 while h<3: i=4 if h==0: x=0 else: x=(h*80) while i<124: if h == 0: st=Student2() if h == 1: st=Student3() if h == 2: st=Student4() st.name = sheet[i,x+3] print st.name st.sap_id = sheet[i,x+2] st.s1_name = sheet[1,x+4] st.s1_t_c = sheet[i,x+7] st.s1_t_g = sheet[i,x+9] st.s1_p_c = sheet[i,x+12] st.s1_p_g = sheet[i,x+13] st.s1_l = 4 st.s1_t = 1 st.s2_name = sheet[1,x+15] st.s2_t_c = sheet[i,x+18] st.s2_t_g = sheet[i,x+20] st.s2_p_c = sheet[i,x+23] st.s2_p_g = sheet[i,x+24] st.s2_l = 3 st.s2_p = 1 st.s3_name = sheet[1,x+26] st.s3_t_c = sheet[i,x+29] st.s3_t_g = sheet[i,x+31] st.s3_p_c = sheet[i,x+34] st.s3_p_g = sheet[i,x+35] st.s3_l = 3 st.s3_p = 1 st.s4_name = sheet[1,x+37] st.s4_t_c = sheet[i,x+40] st.s4_t_g = sheet[i,x+42] st.s4_p_c = sheet[i,x+47] st.s4_p_g = sheet[i,x+49] st.s4_l = 5 st.s4_p = 2 st.s5_name = sheet[1,x+51] st.s5_t_c = sheet[i,x+54] st.s5_t_g = sheet[i,x+56] st.s5_p_c = sheet[i,x+61] st.s5_p_g = sheet[i,x+63] st.s5_l = 4 st.s5_p = 2 st.s6_name = sheet[1,x+65] st.s6_t_c = sheet[i,x+68] st.s6_t_g = sheet[i,x+70] st.s6_l = 2 st.s7_name = sheet[1,x+72] st.s7_t_c = sheet[i,x+73] st.s7_t_g = sheet[i,x+74] st.s7_p = 4 st.totalc = 27 st.totalg = sheet[i,x+78] st.gpa = sheet[i,x+79] st.save() i+=1 h+=1 f.delete() return render(request,"convert.html")