Skip to content

Instantly share code, notes, and snippets.

View henare's full-sized avatar

Henare Degan henare

151 followers · 374 following
View GitHub Profile
@henare
henare / aph_2011-03-24.xml
Last active December 16, 2015 18:49
Differences between APH XML versions and OpenAustralia's parsing of it
...
<debateinfo>
<title>CARBON PRICING</title>
<page.no>3130</page.no>
<type>Miscellaneous</type>
</debateinfo>
<subdebate.1>
<subdebateinfo>
<title>Report from Main Committee</title>
<page.no>3130</page.no>
@henare
henare / upgrading_alaveteli_themes.md
Last active December 14, 2015 12:39
Alaveteli Theme Upgrade Checks

Alaveteli Theme Upgrade Checks

RAILS_ROOT/RAILS_ENV

Example

Check your theme for instances of:

  • RAILS_ROOT replace with Rails.root
  • RAILS_ENV replace with Rails.env
@henare
henare / election_leafets_pull_request_10_migration.sql
Created January 22, 2013 03:48
Overall migration for election_leaflets pull request #10: https://github.com/openaustralia/electionleaflets/pull/10
ALTER TABLE election ADD enabled TINYINT(1) DEFAULT 0 NOT NULL;
UPDATE election SET enabled = 1;
ALTER TABLE `party_election` CHANGE `party_election_id` `party_election_id` INT( 11 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE `australian_postcode` ENGINE = InnoDB;
ALTER TABLE `constituency` ENGINE = InnoDB;
ALTER TABLE `constituency_election` ENGINE = InnoDB;
@henare
henare / change_australian_postcodes_to_innodb.sql
Created January 22, 2013 02:18
ALTER TABLE `australian_postcode` ENGINE = InnoDB
@henare
henare / change_party_election_auto_increment_party_election_id.sql
Created January 22, 2013 01:46
ALTER TABLE `party_election` CHANGE `party_election_id` `party_election_id` INT( 11 ) NOT NULL AUTO_INCREMENT;
@henare
henare / change_constituency_and_constituency_election_to_innodb.sql
Created January 22, 2013 01:19
ALTER TABLE `constituency` ENGINE = InnoDB;
ALTER TABLE `constituency_election` ENGINE = InnoDB;
@henare
henare / gist:3809386
Created October 1, 2012 03:57
2012-10-01 Modem Status
2012-09-30 10:22:46 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:23:46 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:24:46 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:25:46 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:26:47 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:27:47 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:28:50 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:29:54 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:30:56 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
2012-09-30 10:31:59 +1000: Online. Bandwidth: 1248/128. Margin: 12/12
@henare
henare / gist:3791268
Created September 26, 2012 23:28
2012-09-27 Modem Status
2012-09-26 10:00:42 +1000: Online. Bandwidth: 1063/216. Margin: 11/14
2012-09-26 10:01:42 +1000: Online. Bandwidth: 1063/216. Margin: 12/14
2012-09-26 10:02:43 +1000: Online. Bandwidth: 1063/216. Margin: 12/14
2012-09-26 10:03:43 +1000: Online. Bandwidth: 1063/216. Margin: 11/14
2012-09-26 10:04:43 +1000: Online. Bandwidth: 1063/216. Margin: 11/14
2012-09-26 10:05:43 +1000: Online. Bandwidth: 1063/216. Margin: 11/14
2012-09-26 10:06:44 +1000: Online. Bandwidth: 1063/216. Margin: 11/14
2012-09-26 10:07:44 +1000: Online. Bandwidth: 1063/216. Margin: 12/14
2012-09-26 10:08:44 +1000: Online. Bandwidth: 1063/216. Margin: 13/13
2012-09-26 10:09:44 +1000: Online. Bandwidth: 1063/216. Margin: 13/13
@henare
henare / holidays.rb
Created September 23, 2012 04:57
Add remaining 2012 holidays to Alaveteli
holidays = [
{:day => '2012-10-01', :description => 'Labor Day (NSW ACT SA), Queen\'s birthday (QLD WA)'},
{:day => '2012-10-08', :description => 'Family and Community Day (ACT)'},
{:day => '2012-11-06', :description => 'Melbourne Cup (VIC)'},
{:day => '2012-12-24', :description => 'Christmas Eve (SA)'},
{:day => '2012-12-25', :description => 'Christmas Day'},
{:day => '2012-12-26', :description => 'Boxing Day'},
{:day => '2012-12-31', :description => 'New Years Eve (SA)'}
]
@henare
henare / gist:3741194
Created September 18, 2012 04:06
One liner to download, compile and install system-wide mySociety's run-with-lockfile
wget https://raw.github.com/mysociety/theyworkforyou/master/scripts/run-with-lockfile.c && gcc run-with-lockfile.c -o run-with-lockfile && sudo mv run-with-lockfile /usr/bin && sudo chown root:root /usr/bin/run-with-lockfile && rm run-with-lockfile.c