Experimental Physics and
Industrial Control System

Benjamin Franksen <[email protected]> · Wed, 13 May 2015 18:52:52 +0200

Am Donnerstag, 23. April 2015, 11:56:01 schrieb Ralph Lange:
> Dear all,
>
> Ages ago I remember there was a tool called 'dbst' that could be used to
> validate DBD/DB setups and that could dump DBs in a sorted, normalized
> way (only non-default value fields, standard indentation) to make them
> easily comparable with diff and such.
>
> Is dbst still around? I suppose there are more recent ways nowadays.
> Perl/Python? Web-Service?
> (I do like the idea of using the same library as the IOC, though...)
>
> What is a good way to do database validation?

We have traditionally used dbst but this is overkill as dbst was (I think)
meant as a command line interface to most of what dbStaticHost offers. So I
wrote an extremely stupid and simple C program I named dbopt that does this:
read a dbd and a db file, write out a new db file, no options, about 10 lines
of code. Validating a db file against a dbd is included as a side effect.

Can put it on our web page if there is interest.

Andrew's comments in a later message seem to suggest that dbStaticHost no
longer exists in 3.15? That would mean dbopt works only with 3.14.

Cheers
Ben
--
"Make it so they have to reboot after every typo." ― Scott Adams

________________________________

Helmholtz-Zentrum Berlin für Materialien und Energie GmbH

Mitglied der Hermann von Helmholtz-Gemeinschaft Deutscher Forschungszentren e.V.

Aufsichtsrat: Vorsitzender Prof. Dr. Dr. h.c. mult. Joachim Treusch, stv. Vorsitzende Dr. Beatrix Vierkorn-Rudolph
Geschäftsführung: Prof. Dr. Anke Rita Kaysser-Pyzalla, Thomas Frederking

Sitz Berlin, AG Charlottenburg, 89 HRB 5583

Postadresse:
Hahn-Meitner-Platz 1
D-14109 Berlin

http://www.helmholtz-berlin.de

Experimental Physics and Industrial Control System

Experimental Physics and
Industrial Control System