def jsonTeacherCrud(request): # Display/Filter is only on GET if request.is_ajax() and request.method == 'GET': id = request.GET.get('id', None) action = request.GET.get('action', None) if (action == "filter"): dictData = Teacher.objects.filter(id=id).values() else: dictData = Teacher.objects.all().values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') # CRUD is only on POST if request.is_ajax() and request.method == 'POST': action = request.POST.get('action', None) #ADD if (action == "add"): codeAfm = request.POST.get('codeAfm', None) codeGrad = request.POST.get('codeGrad', None) codeSpec = request.POST.get('codeSpec', None) surname = request.POST.get('surname', None) name = request.POST.get('name', None) try: record = Teacher( codeAfm=codeAfm, codeGrad=codeGrad, codeSpec=codeSpec, surname=surname, name=name, ).save() #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' msg = "Επιτυχής εισαγωγή εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία εισαγωγής εγγραφής!" helperMessageLog(request, msg, tag='error') dictData = Teacher.objects.filter(id=record.id).values() jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') #DELETE if (action == "delete"): id = request.POST.get('id', None) try: record = Teacher.objects.filter(id=id) record.delete() msg = "Επιτυχής διαγραφή εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία διαγραφής εγγραφής!" helperMessageLog(request, msg, tag='error') return HttpResponse(msg, content_type='application/json') #UPDATE elif (action == "update"): id = request.POST.get('id', None) codeAfm = request.POST.get('codeAfm', None) codeGrad = request.POST.get('codeGrad', None) codeSpec = request.POST.get('codeSpec', None) surname = request.POST.get('surname', None) name = request.POST.get('name', None) try: record = Teacher.objects.filter(id=id) record.update( codeAfm=codeAfm, codeGrad=codeGrad, codeSpec=codeSpec, surname=surname, name=name, ) #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' msg = "Επιτυχής τροποποίηση εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία τροποποίησης εγγραφής!" helperMessageLog(request, msg, tag='error') dictData = record.values() jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') # DEFAULT on View else: dictData = Teacher.objects.all().values() jsonData = json.dumps(list(dictData)) #print jsonData return HttpResponse(jsonData, content_type='application/json')
def jsonFolderCrud(request): dictData = [] # GET * SELECT if request.is_ajax() and request.method == 'GET': action = request.GET.get('action', None) if (action == "filter"): LessonID = request.GET.get('LessonID', None) #dictData = Folder.objects.get(LessonID=LessonID).graders.all().values() #OK dictData = Folder.objects.filter(LessonID=LessonID).values() jsonData = json.dumps(list(dictData)) #print jsonData return HttpResponse(jsonData, content_type='application/json') # POST INS.UPD.DEL if request.is_ajax() and request.method == 'POST': action = request.POST.get('action', None) #INSERT COMMAND (need related LessonID ) | only add C type folders if (action == "add"): # on LessonID LessonID = request.POST.get('LessonID', None) no = request.POST.get('no', None) books = request.POST.get('books', None) #.title() codeType = request.POST.get('codeType', None) #status = request.POST.get('status', None) print 'Data:', no, books, codeType # Apaitoume oi fakeloi na exoun synexomeh arithmisi # akoma kai gia diafortikous typous # px fA/fANA. Ayto to allazoume efkola an theloume # TO kanoume giati volevei sta reports # alliws tha kanoume aali coding ... #no = Lesson.objects.get(id=LessonID).getNextFolderNo(codeType) try: #with transaction.atomic(): lesson = Lesson.objects.get(id=LessonID) no = lesson.getNextFolderNo( -1) # count F(AB) / even for F(ANA) print 'Data(new):', no, books, codeType record = Folder(LessonID_id=LessonID, no=no, books=books, codeType=codeType) record.save() record.codeBarcode = '%04d-%010d' % (int(LessonID), int(record.id)) record.save() # Need to Update Lesson Data HERE aka mum Books, Folders etc. if codeType == '0': # F(A) print "F(A)" #lesson.update(booksAB=booksAB+books, booksABFolders=booksABFolders+1) lesson.booksAB = lesson.booksAB + int(books) lesson.booksABFolders = lesson.booksABFolders + 1 lesson.save() elif codeType == '1': # F(B) #lesson.booksAB += books #lesson.booksABFolders += 1 pass elif codeType == '2': # F(ANA) lesson.booksC = lesson.booksC + int(books) lesson.booksCFolders = lesson.booksCFolders + 1 lesson.save() msg = "Επιτυχής εισαγωγή εγγραφής!" helperMessageLog(request, msg, tag='info') #messages.info(request, msg, fail_silently=True) except DatabaseError: transaction.rollback() msg = "Αδυναμία εισαγωγής εγγραφής!" helperMessageLog(request, msg, tag='error') #messages.error(request, msg, fail_silently=True) #dictData = Lesson.objects.filter(id=record.id).values() #print dictData #jsonData = json.dumps(list(dictData)) jsonData = json.dumps({'msg': msg}) return HttpResponse(jsonData, content_type='application/json') # UPDATE if (action == "update"): id = request.POST.get('id', None) no = request.POST.get('no', None) books = request.POST.get('books', None) codeType = request.POST.get('codeType', None) #lexType = request.POST.get('lexType', None) #CodeStatus = request.POST.get('CodeStatus ', None) #CodeLocation = request.POST.get('CodeLocation', None) #print "FOLDER-UPDATE %s - %s - codeType:%s lexType:%s" %(no, books, codeType, lexType) try: #with transaction.atomic(): record = Folder.objects.filter(id=id) record.update( no=no, books=books, codeType=codeType, ) msg = "Επιτυχής τροποποίηση εγγραφής!" helperMessageLog(request, msg, tag='info') #messages.info(request, msg, fail_silently=True) except DatabaseError: transaction.rollback() msg = "Αδυναμία τροποποίησης εγγραφής!" helperMessageLog(request, msg, tag='error') #messages.error(request, msg, fail_silently=True) #Folder.objects.filter(id=id).update(isCoordinator = helperStr2Bool(isCoordinator), isgraderC = helperStr2Bool(isgraderC), status = status, ) # return Lesson record #dictData = record.values() #jsonData = json.dumps(list(dictData)) jsonData = json.dumps({'msg': msg}) #print jsonData return HttpResponse(jsonData, content_type='application/json') #DELETE COMMAND if (action == "delete"): id = request.POST.get('id', None) try: record = Folder.objects.get(id=id) # update related lesson lesson = Lesson.objects.get(id=record.LessonID.id) print "codeType:%s" % (record.codeType) print "lesson:%d" % (lesson.id) if record.codeType == 0: # F(A) print "delete codeType:%s" % (record.codeType) #lesson.update(booksAB=booksAB+books, booksABFolders=booksABFolders+1) lesson.booksAB = lesson.booksAB - int(record.books) lesson.booksABFolders = lesson.booksABFolders - 1 lesson.save() elif record.codeType == 1: # F(B) pass elif record.codeType == 2: # F(ANA) print "delete codeType:%s" % (record.codeType) lesson.booksC = lesson.booksC - int(record.books) lesson.booksCFolders = lesson.booksCFolders - 1 lesson.save() record.delete() msg = "Επιτυχής διαγραφής Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='info') #messages.info(request, msg, fail_silently=True) except IntegrityError: transaction.rollback() msg = "Αδυναμία διαγραφής Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='error') #messages.error(request, msg, fail_silently=True) jsonData = json.dumps({'msg': msg}) return HttpResponse(jsonData, content_type='application/json') #"Default SELECT(*) " dictData = Folder.objects.all().values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json')
def jsonSpecialtyCrudv0(request): if request.is_ajax() and request.method == 'GET': id = request.GET.get('id', None) action = request.GET.get('action', None) if (action == "filter"): dictData = SchoolToGrade.objects.filter(id=id).values() else: dictData = SchoolToGrade.objects.all().values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') if request.is_ajax() and request.method == 'POST': action = request.POST.get('action', None) #ADD if (action == "add"): code = request.POST.get('code', None) name = request.POST.get('name', None) try: record = Specialty(code=code, name=name) record.save() #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' msg = "Επιτυχής εισαγωγή εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία εισαγωγής εγγραφής!" helperMessageLog(request, msg, tag='error') dictData = Specialty.objects.filter(id=record.id).values() jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') #DELETE if (action == "delete"): id = request.POST.get('id', None) try: record = Specialty.objects.filter(id=id) record.delete() #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' msg = "Επιτυχής διαγραφή εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία διαγραφής εγγραφής!" helperMessageLog(request, msg, tag='error') return HttpResponse(result, content_type='application/json') #UPDATE elif (action == "update"): id = request.POST.get('id', None) code = request.POST.get('code', None) name = request.POST.get('name', None) try: record = Specialty.objects.filter(id=id) record.update( code=code, name=name, ) #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' msg = "Επιτυχής τροποποίηση εγγραφής!" helperMessageLog(request, msg, tag='info') except DatabaseError: transaction.rollback() msg = "Αδυναμία τροποποίησης εγγραφής!" helperMessageLog(request, msg, tag='error') dictData = record.values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') else: dictData = 'POST action Not Found' jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') #raise Http404 # DEFAULT else: dictData = Specialty.objects.all().values() jsonData = json.dumps(list(dictData)) #print jsonData return HttpResponse(jsonData, content_type='application/json')
def jsonLessonCrud(request): #Handle Mesages #messages.success(request, 'All items on this page have free shipping.',fail_silently=False) #messages.warning(request, 'All items on this page have free shipping.',fail_silently=True) #OK # Display on GET if request.is_ajax() and request.method == 'GET': id = request.GET.get('id', None) action = request.GET.get('action', None) if (action == "filter"): dictData = Lesson.objects.filter(id=id).values() else: dictData = Lesson.objects.all().values() #print dictData jsonData = json.dumps(list(dictData)) return HttpResponse(jsonData, content_type='application/json') # CRUD on POST if request.is_ajax() and request.method == 'POST': action = request.POST.get('action', None) #dictData = Lesson.objects.all().values() #ADD if (action == "add"): #Fakeloi 1o 2o xeri (AB) #booksAB = models.IntegerField(default=0, blank=False) #booksABFolders = models.IntegerField(default=0, blank=False) #booksC = request.POST.get('booksC', None) #booksCFolders = request.POST.get('booksCFolders', None) category = request.POST.get('category', None) name = request.POST.get('name', None) type = request.POST.get('type', None) try: record = Folder(category=category, name=name, type=type) record.save() msg = "Επιτυχής εισαγωγή Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='info') except IntegrityError: transaction.rollback() msg = "Αδυναμία εισαγωγής Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='error') #jsonData = json.dumps({'msg': msg}) # return record dictData = Lesson.objects.filter(id=record.id).values() jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') # UPDATE elif (action == "update"): id = request.POST.get('id', None) #Fakeloi 1o 2o xeri (AB) #booksAB booksABFolders booksC = request.POST.get('booksC', None) booksCFolders = request.POST.get('booksCFolders', None) category = request.POST.get('category', None) name = request.POST.get('name', None) type = request.POST.get('type', None) try: #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' record = Lesson.objects.filter(id=id) record.update( booksC=booksC, booksCFolders=booksCFolders, category=category, name=name, type=type, ) msg = "Επιτυχής τροποποίηση Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='info') except IntegrityError: transaction.rollback() msg = "Αδυναμία τροποποίησης Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='error') # return Lesson record dictData = record.values() jsonData = json.dumps(list(dictData)) #print jsonData return HttpResponse(jsonData, content_type='application/json') #DELETE if (action == "delete"): id = request.POST.get('id', None) record = Lesson.objects.filter(id=id) try: #'Αδυναμία εισαγωγής | τροποποίησης | διαγραφής | εγγραφής.' record.delete() msg = "Επιτυχής διαγραφή Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='info') except IntegrityError: transaction.rollback() msg = "Αδυναμία διαγραφής Φακέλου (%s) !" % (record) helperMessageLog(request, msg, tag='error') return HttpResponse(result, content_type='application/json') # else: No POST Default # DEFAULT else: dictData = Lesson.objects.all().values() jsonData = json.dumps(list(dictData)) #print jsonData return HttpResponse(jsonData, content_type='application/json')
def jsonFileCSVImportTeacher(request): responseData = [] status = 'Success' #errorsFound = True if request.is_ajax(): actionP = request.POST.get('action', 'error') filename = request.POST.get('jqxinputFileName', '') #idxName = request.POST.get('jqxinputIdxName', '') #idxFirstRow = request.POST.get('jqxinputFirstRow', '') print actionP, filename #, idxName, idxFirstRow #2.CHECK-IMPORT #3.DO-IMPORT #filename = 'uploads/LessonsCSV.csv' if (actionP == 'checkimport') or (actionP == 'doimport'): ext = filename.split('.')[-1] if ext not in ['xls', 'xlsx', 'csv']: #return "File %s is not CSV, XLS, XLSX" % ( filename) #errorData.append("File %s is not CSV, XLS, XLSX" % (filename) ) raise Http404 dataReader = csv.reader(open(filename, mode='r'), delimiter=',', quotechar='"') next(dataReader, None) # skip the headers (msg, tag) = ('', 'info') for row in dataReader: #exclude 1st row if (len(row) == 0): # skips null lines continue #t = Teacher(name='Βασίλης', surname='Τζουμάκας', codeAfm = '10000000', codeGrad = '02000000', codeSpec = 'ΠΕ19-01',) codeAfm, surname, name, codeSpec, codeGrad, phoneMob, phoneHom = row[ 0], row[1], row[2], row[3], row[4], row[5], row[6], codeAfmIsNull = True if codeAfm == '' else False surnameIsNull = True if surname == '' else False nameIsNull = True if name == '' else False codeGradIsNull = True if codeGrad == '' else False codeSpecIsNull = True if codeSpec == '' else False phoneMobIsNull = True if phoneMob == '' else False phoneHomIsNull = True if phoneHom == '' else False teacherExists = False if Teacher.objects.filter( codeAfm=codeAfm).count() == 0 else True if codeAfmIsNull or codeGradIsNull or nameIsNull or surnameIsNull or teacherExists: (status, tag) = ('error', 'error') else: (status, tag) = ('OK', 'info') if (actionP == 'doimport'): # Now, do Import in DB try: print "TEACHER IMPORT:", codeAfm, surname, name, codeGrad, codeSpec, codeSpec, phoneMob, phoneHom Teacher(codeAfm = codeAfm, codeGrad = codeGrad, codeSpec = codeSpec, surname = surname, name = name,\ phoneMob=phoneMob, phoneHom=phoneHom).save() (status, msg, tag) = ('OK', "Επιτυχής εισαγωγή εγγραφής!", 'info') except DatabaseError: (status, msg, tag) = ('error', "Αδυναμία εισαγωγή εγγραφής!", 'error') responseData.append ( {'codeAfm': codeAfm, 'codeGrad': codeGrad, 'codeSpec': codeSpec, 'surname': surname , 'name': name,\ 'phoneMob':phoneMob, 'phoneHom':phoneHom, 'status': status }) # page ajax helperMessageLog(request, msg, tag) dictData = {'status': status, 'data': responseData} #print dictData jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') else: raise Http404
def jsonFileCSVImportSpecialty(request): responseData = [] status = 'ΟΚ! ΔΕΝ παρουσιάστηκαν Σφάλματα!' #errorsFound = True if request.is_ajax(): actionP = request.POST.get('action', 'error') filename = request.POST.get('jqxinputFileName', '') print actionP, filename #, idxName, idxFirstRow #2.CHECK-IMPORT #3.DO-IMPORT #filename = 'uploads/LessonsCSV.csv' if (actionP == 'checkimport') or (actionP == 'doimport'): ext = filename.split('.')[-1] if ext not in ['xls', 'xlsx', 'csv']: #return "File %s is not CSV, XLS, XLSX" % ( filename) #errorData.append("File %s is not CSV, XLS, XLSX" % (filename) ) raise Http404 dataReader = csv.reader(open(filename, mode='r'), delimiter=',', quotechar='"') next(dataReader, None) # skip the headers (msg, tag) = ('', 'info') for row in dataReader: #exclude 1st row if (len(row) == 0): # skips null lines continue code, name, = row[0], row[1] #print schoolCode, schoolName, schoolDdeCode, schoolDdeName, codeIsNull = True if code == '' else False nameIsNull = True if name == '' else False specialtyExists = False if Specialty.objects.filter( code=code).count() == 0 else True if codeIsNull or nameIsNull or specialtyExists: (status, tag) = ('error', 'error') else: (status, tag) = ('OK', 'info') if (actionP == 'doimport'): # Now, do Import in DB try: Specialty( code=code, name=name, ).save() print "SPECIALTY IMPORT:", code, name (status, msg, tag) = ('OK', "Επιτυχής εισαγωγή εγγραφής!", 'info') except DatabaseError: (status, msg, tag) = ('error', "Αδυναμία εισαγωγή εγγραφής!", 'error') # responseData.append({ 'code': code, 'name': name, 'status': status }) # page ajax helperMessageLog(request, msg, tag) dictData = {'status': status, 'data': responseData} #print dictData jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') else: raise Http404
def jsonFileCSVImportSchoolToGrade(request): responseData = [] status = 'ΟΚ! ΔΕΝ παρουσιάστηκαν Σφάλματα!' #errorsFound = True if request.is_ajax(): actionP = request.POST.get('action', 'error') filename = request.POST.get('jqxinputFileName', '') print actionP, filename #, idxName, idxFirstRow #2.CHECK-IMPORT #3.DO-IMPORT #filename = 'uploads/LessonsCSV.csv' if (actionP == 'checkimport') or (actionP == 'doimport'): ext = filename.split('.')[-1] if ext not in ['xls', 'xlsx', 'csv']: #return "File %s is not CSV, XLS, XLSX" % ( filename) #errorData.append("File %s is not CSV, XLS, XLSX" % (filename) ) raise Http404 dataReader = csv.reader(open(filename, mode='r'), delimiter=',', quotechar='"') next(dataReader, None) # skip the headers (msg, tag) = ('', 'info') for row in dataReader: #exclude 1st row if (len(row) == 0): # skips null lines continue schoolCode, schoolName, schoolType, schoolTypeLex, schoolDdeCode, schoolDdeName, = row[ 0], row[1], row[2], row[3], row[4], row[5] schoolAddress, schoolCity, schoolTk = row[6], row[7], row[8] #print schoolCode, schoolName, schoolDdeCode, schoolDdeName, codeIsNull = True if schoolCode == '' else False nameIsNull = True if schoolName == '' else False ddeCodeIsNull = True if schoolDdeCode == '' else False ddeNameIsNull = True if schoolDdeName == '' else False schoolExists = False if SchoolToGrade.objects.filter( code=schoolCode).count() == 0 else True # Dry run if codeIsNull or nameIsNull or ddeCodeIsNull or schoolExists: (status, tag) = ('error', 'error') #status = 'Παρουσιάστηκαν Σφάλματα!' # grid msg else: (status, tag) = ('OK', 'info') # Import in DB if (actionP == 'doimport'): try: SchoolToGrade( code=schoolCode, name=schoolName, type=schoolType, ddeCode=schoolDdeCode, ddeName=schoolDdeName, address=schoolAddress, city=schoolCity, tk=schoolTk, ).save() print "SCHOOL-TO-GRADE IMPORT:", schoolCode, schoolName, schoolDdeCode, schoolDdeName (status, msg, tag) = ('OK', "Επιτυχής εισαγωγή εγγραφής!", 'info') except DatabaseError: (status, msg, tag) = ('error', "Αδυναμία εισαγωγή εγγραφής!", 'error') #responseData.append ( {'name': schoolName, 'type': lessonType , 'status': status }) responseData.append ( {'code': schoolCode, 'name': schoolName , 'type': schoolType,\ 'ddeCode': schoolDdeCode, 'ddeName': schoolDdeName,\ 'address': schoolAddress, 'city': schoolCity, 'tk': schoolTk, 'status': status }) # page ajax helperMessageLog(request, msg, tag) dictData = {'status': status, 'data': responseData} #print dictData jsonData = json.dumps(dictData) return HttpResponse(jsonData, content_type='application/json') else: raise Http404
def jsonFileCSVImportLesson(request): responseData = [] status = 'Success' #errorsFound = True if request.is_ajax(): actionP = request.POST.get('action', 'error') filename = request.POST.get('jqxinputFileName', '') #idxName = request.POST.get('jqxinputIdxName', '') #idxFirstRow = request.POST.get('jqxinputFirstRow', '') print actionP, filename #, idxName, idxFirstRow #2.CHECK-IMPORT #3.DO-IMPORT #filename = 'uploads/LessonsCSV.csv' if (actionP == 'checkimport') or (actionP == 'doimport'): ext = filename.split('.')[-1] if ext not in ['xls', 'xlsx', 'csv']: #return "File %s is not CSV, XLS, XLSX" % ( filename) #errorData.append("File %s is not CSV, XLS, XLSX" % (filename) ) raise Http404 dataReader = csv.reader(open(filename, mode='r'), delimiter=',', quotechar='"') #dataReader = csv.reader(codecs.open(csv_filepathname, ‘rU’, ‘utf-16’)) next(dataReader, None) # skip the headers (msg, tag) = ('', 'info') for row in dataReader: #exclude 1st row if (len(row) == 0): # skips null lines continue #if row[0] != 'ΜΑΘΗΜΑ': # Ignore header #Lesson(name = lessonName).save() lessonName, lessonCategory, lessonType = row[0], row[1], row[2] nameIsNull = True if lessonName == '' else False categoryIsNull = True if lessonCategory == '' else False typeIsNull = True if lessonType == '' else False # check on Table constraint lessonExists = False if Lesson.objects.filter( name=lessonName, category=lessonCategory, type=lessonType).count() == 0 else True # Dry run if nameIsNull or categoryIsNull or typeIsNull or lessonExists: (status, tag) = ('error', 'error') #responseData.append ( {'name': lessonName, 'type': lessonType , 'status': 'error' }) else: (status, tag) = ('OK', 'info') #responseData.append ( {'name': lessonName, 'type': lessonType , 'status': 'success' }) #msg = msg + ('Lesson (%s) with type (%s) has errors!' %(lessonName, lessonType)) # Import in DB if (actionP == 'doimport'): try: Lesson(name=lessonName, category=lessonCategory, type=lessonType).save() status = 'OK' msg = "Επιτυχής εισαγωγή εγγραφής!" except DatabaseError: (status, tag) = ('error', 'error') responseData.append({ 'name': lessonName, 'category': lessonCategory, 'type': lessonType, 'status': status }) """ if nameIsNull or categoryIsNull or lessonExists: status = 'error' tag = 'error' #msg = msg + ('Lesson (%s) with type (%s) has errors!' %(lessonName, lessonType)) responseData.append ( {'name': lessonName, 'type': lessonType , 'status': 'error' }) else: responseData.append ( {'name': lessonName, 'type': lessonType , 'status': 'success' }) #msg = msg + ('Lesson (%s) with type (%s) has errors!' %(lessonName, lessonType)) if (actionP =='doimport'): # Now, do Import in DB try: Lesson(name = lessonName, category = lessonCategory, type = lessonType).save() msg = "Επιτυχής εισαγωγή εγγραφής!" #helperMessageLog(request, msg, tag='info') except DatabaseError: #msg = "Αδυναμία εισαγωγής εγγραφής!" tag = 'error' msg = msg + ('Αδυναμία εισαγωγής εγγραφής (%s)!' %(lessonName)) #helperMessageLog(request, msg, tag='error') """ helperMessageLog(request, msg, tag) dictData = {'status': status, 'data': responseData} #print dictData jsonData = json.dumps(dictData) #print jsonData return HttpResponse(jsonData, content_type='application/json') else: raise Http404