def insertUnique(self,request): #This method is just a reference in order for you to reuse this code in order to insert unique entries in the DB college = CollegeDb(name = 'NITK',student_sup='Anirudh',collegeId='NITK-123') college_key = college.put() query = CollegeDb.query() profile = Profile(name = 'RJJ', email = '*****@*****.**', phone = '7760532293', password = '******', pid = '1234', isAlumni='N', collegeId= college_key) profileret = Profile.query(Profile.pid == profile.pid).fetch(1) print("A is ", profileret) if profileret: print("Not inserting") else : print("Inserting") profile_key = profile.put()
def createCollege(requestentity=None): newCollege = CollegeDb() query = CollegeDb.query() print "The data got on querying is ", query, " type is ", type(query), "\n" count = 0 names = [] location = [] """profile = Profile(name = 'RJJ', email = '*****@*****.**', phone = '7760532293', password = '******', pid = '1234', isAlumni='N', collegeId= 'NIoTK') profile_key = profile.put() """ for records in query: print "The name of the college is ", records.name, " and location is ", records.location names.append(records.name) location.append(records.location) count += 1 # print "\n" print "count is, ", count collegeName = "" if requestentity: for field in ("name", "abbreviation", "location", "student_sup", "alumni_sup"): val = getattr(requestentity, field) if field == "name": collegeName = getattr(requestentity, field).strip() if val: val = val.strip() print ("Value is", val) setattr(newCollege, field, str(val)) # Now setting the attributes not recieved from the front-end. setattr(newCollege, "student_count", 0) setattr(newCollege, "group_count", 0) newlist = [] setattr(newCollege, "group_list", newlist) # Making CollegeId newString = "" newString = collegeName[0] for x in xrange(len(collegeName)): if collegeName[x] == " ": newString += collegeName[x + 1] setattr(newCollege, "collegeId", newString) print (newCollege) flag = 0 for var in xrange(count): if newCollege.name == names[var] and newCollege.location == location[var]: flag = 1 if flag: print "Sorry already existing record" else: print "Unique" newCollege.put() return newCollege
def createCollege(requestentity=None): newCollege = CollegeDb() query = CollegeDb.query() print "The data got on querying is " , query , " type is ", type(query), "\n" count = 0 names = [] location = [] """profile = Profile(name = 'RJJ', email = '*****@*****.**', phone = '7760532293', password = '******', pid = '1234', isAlumni='N', collegeId= 'NIoTK') profile_key = profile.put() """ for records in query: print"The name of the college is ", records.name , " and location is " , records.location names.append(records.name) location.append(records.location) count += 1 #print "\n" print "count is, " , count collegeName = "" if requestentity: for field in ('name','abbreviation','location','student_sup','alumni_sup','email'): val = getattr(requestentity, field) if field == "name": collegeName = getattr(requestentity, field).strip() if val: val = val.strip() print("Value is",val) setattr(newCollege, field, str(val)) #Now setting the attributes not recieved from the front-end. setattr(newCollege, 'student_count', 0) setattr(newCollege, 'group_count', 0) newlist = [] setattr(newCollege, 'group_list', newlist) setattr(newCollege,'sup_emailId',requestentity.email) # Making CollegeId newString = "" newString = collegeName[0] for x in xrange(len(collegeName)): if(collegeName[x]==' '): newString+=collegeName[x+1] setattr(newCollege, 'collegeId', newString) print(newCollege) flag = 0 for var in xrange(count): if(newCollege.name==names[var] and newCollege.location==location[var]): flag=1 if(flag): print "Sorry already existing record" else: print "Unique" email = getattr(requestentity, "email") phone = getattr(requestentity, "phone") if(getattr(requestentity, "student_sup")==None): isAlumni = "Yes" person_name = getattr(requestentity, "alumni_sup") else: isAlumni = "No" person_name = getattr(requestentity, "student_sup") collegeId = newCollege.put() profile = Profile(name = person_name , email = email, phone = phone, isAlumni=isAlumni, collegeId= collegeId) profile.superadmin.append(collegeId) key1 = profile.put() return newCollege