---------- Forwarded message ----------
From: Dave Haynes <d...@thuswise.co.uk>
Date: 29 October 2012 09:16
Subject: Re: IRC chat today, 3pm UK, 4pm Malawi

On Fri, 26 Oct 2012 10:42:18 +0100
 celia petty <celia.pe...@evidencefordevelopment.org> wrote:
>Today's IRC chat will be at 3pm UK, 4pm Malawi

Thanks for the invite. I'll try to be there today.

If not, here's some quick input for the meeting:

There are three aspects to my recent work.
1. utils/schema-diff.py

This tool compares the schema generated from the sqlalchemy model with a
reference (eg: from mysql-dump). The idea of this is to give your database
architect
assurance that his design is correctly implemented in the model.

This is complete for the moment.

2. tests/test_ingest.py

This is a container for various strands of work. The overall aim is to be
able to write
unit tests against an in-memory database instead of a MySQL instance. The
result
of that will be faster, more repeatable tests.

There are currently issues with ensuring the user's SQLite library supports
foreign
keys and loadable geo extensions. There is also some OS-specific behaviour
which
needs accomodating.

I'd guess it'll be another couple of weeks before I have this fully
resolved.

3. model/unstableschema.py

I am step-by-step building up a sqlqlchemy model which can be verified
against
the tool in 1. As I go, and issues arise, I am writing the tests in 2. The
long term
objective is to have 'unstableschema' eventually get to the point where
everyone
agrees it can be renamed 'schema'. :-)

Kind regards,

Dave Haynes.

================================
Thuswise Ltd.
Suite 4
32 Aubrey Street
Hereford
HR4 0BU
UK

Web: www.thuswise.co.uk