Re: [Gnumed-devel] schema verification

[Karsten Hilbert]

On Sat, Oct 22, 2011 at 10:07:10AM +0200, Karsten Hilbert wrote:

> In case someone would like to check one database schema
> against another (say, a "known good" one such as the public
> DB) one would run
> 
>       select gm.concat_table_structure();
> 
> in both databases and compare the output (by, say, piping
> the output into text files and diffing).

In fact, we almost already provide a way to do just that:

        cd gnumed/server/
        ./gm-fingerprint_db.py <database> <gm-dbo-password>

which will create a gm_db-fingerprint.log.

I have enhanced this helper script to include a schema dump
for diffing if desired.

Attached find a fingerprint of my gnumed_v15 database.

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

gm_db-fingerprint.log
Description: Text document