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.");
