Re: Fwd: Re: Volunteers for the membership committee

[Vincent Untz <vuntz gnome org>]

Hi,

Did anybody look at this?
(it'd be nice to have the code working before the voting period ;-))

Vincent

Le samedi 16 mai 2009, à 18:46 +0200, Vincent Untz a écrit :
> -- 
> Les gens heureux ne sont pas pressés.

> Date: Mon, 04 May 2009 09:35:24 +0200
> From: Dave Neary <dneary free fr>
> To: Vincent Untz <vuntz gnome org>
> CC: Bruno Boaventura <brunoboaventura gmail com>,
>       Diego Escalante Urrelo <diegoe gnome org>,
>       Baris Cicek <baris teamforce name tr>
> Subject: Re: Volunteers for the membership committee
>
> Hi,
>
> Vincent Untz wrote:
> > Well, that fairly trivial to do, I think. The wml stuff we have is
> > actually just a simple sed rule to replace the header and foot of the
> > page.
>
> I know - one of the problems is that I've set an onLoad() function on
> the page body, and some JavaScript functions in the header, for step 2
> of the election process that builds the list of candidates in
> Javascript, and the sed rule adds all of that to the top of the page.
>
> > Maybe you can send your code to the membership committee if you need
> > help?
>
> Glad to!
>
> svn co https://garage.maemo.org/svn/maemo2midgard/maemo-elections
>
> Everything you need is in the "vote" directory, and I may have made some
> changes to "scripts" too - diff'll tell you if there's anything
> important (it was mostly to get around a different version of
> Mail::Internet on the Maemo server, iirc).
>
> The database changes are mostly minor, the DB schema is described in
> files/election_db.txt.
>
> Again, IIRC, the main changes were:
>  * Use a generic "electorate" table, rather than "foundation_members" -
> this is maemo-specific.
>  * Name fields everywhere - no select * from
>  * Semantics change: "choice_nb" in the "elections" table means "number
> of seats available in the election", not "number of choices a person can
> make"
>  * Election results are no longer generated on the fly. You store an
> HTML segment in the "result" field of the "election_results" table
> (primary key: election_id, foreign to elections.id)
>  * New column in election_votes table: preference. One voter (anon_id)
> can vote for several choices, and they will have a different preference
> each.
>
> Everything else is backwards-compatible - you can migrate old votes to
> the new database by setting "preference" to 1 by default (alter table
> add column works fine), and you can get the results of old elections
> easily enough if necessary - there are only 5 old elections in the
> database, there were even fewer for Maemo, you just need to generate the
> results by hand, save to html, and "insert into results values..."
>
> Hopefully this is sufficient to get you started! If there's any other
> info you need, shout.
>
> Cheers,
> Dave.
>
> -- 
> Dave Neary
> dneary free fr
> Tel: +33 9 51 13 46 45
> Cell: +33 6 77 01 92 13


-- 
Les gens heureux ne sont pas pressés.