- with db.xact():
- rv = db.prepare("SELECT id, type FROM motion WHERE identifier=$1 AND host=$2")(motion, request.host);
- if len(rv) == 0:
- return "Error, Not found", 404
- if not may("vote", rv[0].get("type")):
- return "Forbidden", 403
- p = db.prepare("SELECT deadline > CURRENT_TIMESTAMP FROM motion WHERE identifier = $1 AND host=$2")
- id = rv[0].get("id")
- if not p(motion, request.host)[0][0]:
- return "Error, motion deadline has passed", 500
- p = db.prepare("SELECT * FROM vote WHERE motion_id = $1 AND voter_id = $2")
- rv = p(id, g.voter)
- if len(rv) == 0:
- db.prepare("INSERT INTO vote(motion_id, voter_id, result) VALUES($1,$2,$3)")(id, g.voter, v)
- else:
- db.prepare("UPDATE vote SET result=$3, entered=CURRENT_TIMESTAMP WHERE motion_id=$1 AND voter_id = $2")(id, g.voter, v)
+ p = db.prepare("SELECT * FROM vote WHERE motion_id = $1 AND voter_id = $2")
+ rv = p(id, g.voter)
+ if len(rv) == 0:
+ db.prepare("INSERT INTO vote(motion_id, voter_id, result) VALUES($1,$2,$3)")(id, g.voter, v)
+ else:
+ db.prepare("UPDATE vote SET result=$3, entered=CURRENT_TIMESTAMP WHERE motion_id=$1 AND voter_id = $2")(id, g.voter, v)