A piece of software for viewing graphs of UK election results. Warning: bodged together during a hackathon
This software works on both Windows and Linux machines. It might work on MacOS but I don't own a Mac so I couldn't test it. Just download the zip file from the Releases section and extract it to its own folder. Then run Election.jar from inside the folder it is in
You will need installed on your machine:
- Java 8
- Python 3
- Open up the database with DB Browser for SQLite
- Open the 'Con' table to add the consituency name and electorate. Note the CON_ID value for later
- Open the 'Results15' table and make as many new records as there were parties standing, fill in the 'Con_ID' field with the value from earlier Note: other than the parties listed in the 'Party' table, no other parties can be added. Please use the 'Other' entry if you need more parties than those provided
- For each party standing, take their 'Party_ID' from the 'Party' table and enter it into the 'Party_ID' of the 'Results15' table. Then enter the number of votes that party got in that election
- Repeat steps 3 and 4 for the 'Results17' table
- Press 'Write Changes'
- Open up the database with DB Browser for SQLite
- Open the 'Party' table and make a new record
- Fill in 'Party_ID' with a new, unique value. 'Name' should be the official party name. 'Short_Name' should be a 2 - 5 character abreviation of the party name in upper case (Eg. Conservative is shortened to CON). The three Colour coloumns should contains an RGB colour to represent that party.
- Press 'Write Changes'
- Drop down list on main menu currently limited by height of the screen and has no scroll bar