Changeset 196

Timestamp:

04/15/09 03:11:25 (15 years ago)

Author:

nanardon

Message:

• use new table for ballot value map

File:

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

trunk/lib/Vote/DB/Poll.pm

@@ -711 +711 @@
     my $sth = $self->db->prepare_cached(
         q{
-        update ballot_item set corrected = ? where
-        id in (select id from ballot where poll = ?)
-        and (value = ? or corrected = ?)
-        }
-    );
-
-    $sth->execute($to, $self->voteid, $from, $from) or $self->db->rollback;
+        insert in ballot_map (poll, "from", to) values (?,?,?)
+        }
+    );
+
+    $sth->execute($self->voteid, $from, $to) or $self->db->rollback;
     $self->db->commit;
 }