def getAPoll(self,pollquestion):
connection=dbapi2.connect(current_app.config['dsn'])
cursor=connection.cursor()
cursor.execute("""SELECT VOTENUMBER,CHOICENUMBER FROM POLLS WHERE POLLQUESTION=%s""",(pollquestion,))
temp2=cursor.fetchone()
votenumber=temp2[0]
choicenumber=temp2[1]
poll=Poll(pollquestion,creatorname)
poll.votenumber=votenumber
poll.choicenumber=choicenumber
return poll
def getPoll(self,pollquestion,creatorname):
connection=dbapi2.connect(current_app.config['dsn'])
cursor=connection.cursor()
cursor.execute("""SELECT ID FROM USERS WHERE USERNAME=%s""",(creatorname,))
temp=cursor.fetchone()
creatorid=temp
cursor.execute("""SELECT VOTENUMBER,CHOICENUMBER FROM POLLS WHERE POLLQUESTION=%s AND CREATORID=%s""",(pollquestion,creatorid))
poll=Poll(pollquestion,creatorname)
array=[(temp2[0],temp2[1]) for temp2 in cursor]
for votenumber,choicenumber in array:
poll.votenumber=votenumber
poll.choicenumber=choicenumber
cursor.close()
connection.close()
return poll
