liquid_feedback_core

diff lf_update_issue_order.c @ 409:5f24058af0b8
Secondary sorting key for issues in admission phase
author: jbe
date: Mon Oct 14 00:58:38 2013 +0200 (2013-10-14)
parents: 92cdb3af0b54
children: d301dc24b25c
     1.1 --- a/lf_update_issue_order.c	Mon Oct 14 00:23:04 2013 +0200
     1.2 +++ b/lf_update_issue_order.c	Mon Oct 14 00:58:38 2013 +0200
     1.3 @@ -204,7 +204,7 @@
     1.4        fprintf(stderr, "Could not escape literal in memory.\n");
     1.5        abort();
     1.6      }
     1.7 -    if (asprintf(&cmd, "INSERT INTO \"issue_order\" (\"id\", \"order_in_admission_state\") VALUES (%s, %i)", escaped_issue_id, candidates[i].seat) < 0) {
     1.8 +    if (asprintf(&cmd, "INSERT INTO \"issue_order\" (\"id\", \"order_in_admission_state\", \"max_supporter_count\") SELECT %s, %i, max(\"supporter_count\") FROM \"initiative\" WHERE \"issue_id\" = %s", escaped_issue_id, candidates[i].seat, escaped_issue_id) < 0) {
     1.9        fprintf(stderr, "Could not prepare query string in memory.\n");
    1.10        abort();
    1.11      }