The table {election_ballot} should have a unique constraint ('election_id', 'post_id', 'uid'). This would ensure that never can there be more than one vote per person for the same election post.

CommentFileSizeAuthor
#7 election-improve_unqiue_one_vote_per_person-2615078-7-D7.patch989 bytesLiam Morland
#2 election-election_ballot_unique_key-2615078-2-D7.patch843 bytesLiam Morland
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Liam Morland created an issue. See original summary.

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland at University of Waterloo commented
Status: Active » Needs review
FileSize
election-election_ballot_unique_key-2615078-2-D7.patch843 bytes
pjcdawkins’s picture

pjcdawkins CreditAttribution: pjcdawkins commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland at University of Waterloo commented
Assigned: Unassigned » Liam Morland
Status: Closed (fixed) » Active

The constraint should be ('post_id', 'uid').

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland at University of Waterloo commented
Assigned: Liam Morland » Unassigned
Status: Active » Needs review
FileSize
election-improve_unqiue_one_vote_per_person-2615078-7-D7.patch989 bytes
pjcdawkins’s picture

pjcdawkins CreditAttribution: pjcdawkins commented
Status: Needs review » Fixed

Committed - thanks

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.