mORMot Open Source

yogiyang

Member

Registered: 2010-08-18

Posts: 23

Reverse engineer existing database

Hello,

I have plethora of databases created in PostgreSQL, MySql and SQLite. And some of the databases are very large having 280 tables with average 30 fields per table.

Hand coding such large database structures in Mormot is proving to be a nightmare at best.

Is there any utility that can reverse engineer an existing database and build required classes for Mormot?

TIA

Yogi Yang

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Reverse engineer existing database

You have an initial attempt of such class generation in SynDBExplorer.dpr sample.

Perhaps it may be worth enhancing for your purpose.

And... a way to contribute by a pull request?

yogiyang

Member

Registered: 2010-08-18

Posts: 23

Re: Reverse engineer existing database

Hello,

Thanks for the tip. I will give it a close look.