Matt Walker walkermatt

Reading and writing a UTF-8 encoded XML file with Python ElementTree

I've found reading and writing a UTF-8 encoded XML file with Python ElementTree harder than expected so I thought I'd pull together this demo.

The trick is to open the source and destination files with an explicit encoding instead of relying on ElementTree.parse and ElementTree.write.

Naïve Quicksort implementation in Python inspired by Computerphile's Quicksort in 5 lines of code

Load ES module in a html page

Place the files in a directory. Serve the files via a web server such as the built-in python http server. Open index.html in your browser, open the DevTools Console and reload.

FOSS4G 2013 - Ten Years After

Matt Walker [email protected], x.com/_walkermatt

Data

Improved availability and visibility

Open data
- OSM founded almost 10 years prior to FOSS4G 2013
Wide adoption; Humanitarian OSM (hotosm.org)

Download a JSON list of object and write to CSV

Requires Python 3.

Usage

Linux

python3 json_to_csv.py https://gist.githubusercontent.com/walkermatt/19b1108ca9bee94745810f4c39c32165/raw/cities.json /tmp/cities.csv

A

Description	Entity	Preview
A With Acute, Latin Capital Letter	Á	Á
A With Acute, Latin Small Letter	á	á
A With Breve, Latin Small Letter	ă	ă
A With Caron, Latin Small Letter	ǎ	ǎ
A With Circumflex, Latin Capital Letter	Â	Â
A With Circumflex, Latin Small Letter	â	â

Chalice Dev AWS IAM Policy

AWS IAM Policy suitable for assigning to a user developing Chalice applications. Allows the developer sucessfully execute chalice deploy, chalice delete and chalice logs

Derived from comments on chalice/issues/59, extended by trial and error :-)

Subsitute YOUR-AWS-REGION in chalice-dev-iam-policy.json with the region you are deploying to, for example eu-west-1.

AWS profiles

The day the build broke 😔

The tale of a broken build and breaking changes...

And so the story begins...

ol-ishare is built automatically each time a change is committed to the repository
- Formatting of source code is checked (linting)

	import { Parser } from '@robojones/nginx-log-parser';
	import fs from 'fs';
	import { createReadStream } from 'fs';
	import zlib from 'zlib';
	import readline from 'readline';
	import path from 'path';

	async function* processFile(filePath, filter) {
	const extension = path.extname(filePath);
	let readStream;

	-- Raises an exception with `failure_message` if `sql_text` does not throw an exception at all.
	-- If an exception is thrown but it's SQLSTATE doesn't match `expected_sql_state` then that
	-- exception is RE-RAISED
	CREATE OR REPLACE FUNCTION pg_temp.test__throws_exception(sql_text text, expected_sql_state text, failure_message text) RETURNS void AS $$
	DECLARE
	sql_state text;
	BEGIN
	EXECUTE sql_text;
	RAISE EXCEPTION '%', failure_message;
	EXCEPTION WHEN OTHERS THEN GET STACKED DIAGNOSTICS sql_state = RETURNED_SQLSTATE;