Re: [GeneX-dev] Re: ERWin File on website

[Hilmar L. <la...@gn...>]

Quoting "Jason E. Stewart" <ja...@op...>:

> 
> All the DB interfaces are created to be SQL generic. Instead of having
> a bunch of hard-coded SQL ('SELECT foo FROM bar WHERE baz="NAN"') I
> created an SQL abstraction layer using three functions
> create_select_sql(), create_insert_sql(), and
> create_update_sql(). With these you can plug in backends for any
> relational DB to produce the SQL you need. 
> 

Is this framework already available already? If so, from the GeneX repository
or MAGEstk?

I'm trying to reverse engineer the ERD, unsuccessful so far. ERwin would
not reverse engineer from SQL, and doesn't have an idea about Postgres.
My next idea was port to Oracle, and reverse engineer with Designer.

Can the tool framework you mentioned reverse engineer from SQL DDL?

BTW the DDL I was able to dump did not contain FK constraints (bad for reverse 
engineering). Was I missing something, or does the schema not contain FK
constraints? (If the latter, was this a design decision?)


     -hilmar
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: la...@gn...
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------