re: Model consistency check

[Rainer Döbele <do...@esteam.de>]

Hi Jan,

good point. Unfortunately no, I'm afraid there is currently no consistency check.
But I agree that this is a good idea and that it would be a useful additional feature.
We will put it on our task list unless you want to go ahead and implement it yourself and contribute it to our project.

In the CodeGenerator project you will find an example of how to obtain database metadata and map it to our data types.
This might be a good start point.

Regards
Rainer

> from: Jan Glaubitz [mailto:jan@glaubitz.org]
> to: user@empire-db.apache.org
> re: Model consistency check
> 
> Hello,
> 
> I want to validate the consistency of my DB schema against my empire-db
> schema on application startup.
> 
> It would be nice to be able to check:
> 
> - Tables (names, primary keys)
> - Columns (names, data types, size)
> - Existence foreign keys
> - Existence of indexes
> 
> Is this already possible with empire-db? Is there samplecode available?
> 
> - jan