Project

General

Profile

Actions

Bug #4542

open

Feature Request: Import / update metadata from MySQL database

Added by David LeBauer over 14 years ago. Updated about 14 years ago.

Status:
New
Priority:
Immediate
Assignee:
Category:
morpho - general
Target version:
Start date:
11/11/2009
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
4542

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

Actions

Also available in: Atom PDF