Bug #4542
openFeature Request: Import / update metadata from MySQL database
0%
Description
I am writing to request a feature for Morpho that would facilitate creating and updating metadata from an existing database. I am using MySQL, but I imagine that the feature could be more general.
I would like for it to:
a) query a database to generate relevant metadata
or
b) generate metadata from an SQL CREATE script
For each table
give table name to entityName
Add comments to Description
Make list of attributeNames from column headers
For each attributeName
entityName: is column name
attributeDefinition: state if it is a primary key or foreign key, if foreign key, write foreign key and the name of referenced table
storageType derived from datatype
managementScale/unit/numericDomain/range etc. should be derived from datatype (and data if connected to database)
Thanks!
-David