def addItems(): form = cgi.FieldStorage(); user = users.get_current_user(); sName = form['addon'].value; sName1 = sName.split(" by "); sName2 = sName1[0]; surveyName = sName2.replace("__"," "); rawOptions = form['additems'].value; rawOptions += ','; optionList = rawOptions.split(','); counter = 0; for option in optionList: itemPresent = db.GqlQuery("SELECT * FROM Item WHERE name = :1 AND survey = :2 and owner = :3",option,surveyName,user); counter1 = itemPresent.count(); if (counter1 > 0): counter = counter + 1; if (counter > 0): return render_template('failure.html',message="One or more items that you tried to add are already present in this category.None of the items were added."); else: surveys = db.GqlQuery("SELECT * FROM Survey WHERE name = :1 and owner = :2",surveyName,user); oldItemList = []; oldExpiration =""; for sur in surveys: if (sur.name == surveyName): oldItemList = sur.values; oldExpiration = sur.expiration; for newItems in optionList: oldItemList.append(newItems); newItemList = oldItemList; db.delete(surveys); newSurvey = Survey(name=surveyName,owner=user,values=newItemList,expiration=oldExpiration); newSurvey.put(); for option in optionList: if option: item = Item(name=option); item.survey = surveyName; item.owner = user; search1 = Search(name=option,entityType="item",survey=surveyName,owner=user); item.put(); search1.put(); return render_template('survey_confirmation.html',survey=surveyName,option=optionList);
def addSurvey(): form = cgi.FieldStorage(); user = users.get_current_user(); surveyName = form['sname'].value.strip(); rawOptions = form['options'].value; rawOptions += ','; optionList = rawOptions.split(','); surveyExpireDate = ""; if (form.has_key("dateValue")): expireDate = form['dateValue'].value; expireHour = int(form['hours'].value); expireMinutes = int(form['minutes'].value); expireSeconds = int(form['seconds'].value); rawDate = expireDate.split("/"); month = int(rawDate[0]); day = int(rawDate[1]); year = int(rawDate[2]); surveyExpireDate = datetime.datetime(year,month,day,expireHour,expireMinutes,expireSeconds); else: surveyExpireDate = datetime.datetime(2012,12,30,0,0,0); surveys = db.GqlQuery("SELECT * FROM Survey WHERE name = :1 and owner = :2",surveyName,user); counter = surveys.count(); if (counter == 0): survey = Survey(name=surveyName,expiration=surveyExpireDate); survey.values = optionList; survey.owner = user; survey.put(); search = Search(name=surveyName,entityType="survey",survey=surveyName,owner=user); search.put(); for option in optionList: if option: item = Item(name=option); item.survey = surveyName; item.owner = user; item.put(); search1 = Search(name=option,entityType="item",survey=surveyName,owner=user); search1.put(); return render_template('survey_confirmation.html',survey=surveyName,option=optionList); else: return render_template('failure.html',message="You already have created this survey! Please create a different survey.");