open-hea forwarding message

[celia petty]

Hi
The message sent by Dave (below) should have gone to everyone last week-failure  was due to a glitch at the EfD end which is now sorted.
In future, notice of the Friday IRC meeting  will go to all committers and everyone will receive a transcript of the discussion.
We appreciate the time you're giving to this project. Let us know if we (non developers in EfD ) can do anything more to facilitate/support
The next IRC chat will be on Friday, 3pm (UK) - details are here
http://code.google.com/p/open-ihm/wiki/IrcChats

Celia, Wolf (EfD)

---------- Forwarded message ----------
From: Dave Haynes <da...@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...@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