Changeset 195 for trunk/lib/Vote/DB/Ballot.pm

Timestamp:

04/14/09 20:02:56 (15 years ago)

Author:

nanardon

Message:

• start new value mapping method

File:

• trunk/lib/Vote/DB/Ballot.pm (modified) (1 diff)

trunk/lib/Vote/DB/Ballot.pm

@@ -65 +65 @@
 
     my $sth = $self->db->prepare_cached(
-        q{select *, value as v from ballot_item where id = ?}
+        q{
+        select ballot_item.*, value as v,
+        coalesce(ballot_map.to, corrected) as corrected
+        from ballot_item join ballot on ballot.id = ballot_item.id
+        left join ballot_map on ballot_map.poll = ballot.poll and
+        ballot_map.from = ballot_item.value
+        where ballot.id = ?
+        }
     );
     $sth->execute($self->ballotid);