search

metarhia / metaschema

Schema definition and validation 💡
https://metarhia.com
MIT License
52 stars 18 forks source link

Back port DDL to JS #374

Open leonpolak opened 3 years ago

leonpolak commented 3 years ago

Is your feature request related to a problem? Please describe. Considering all the great advantages of metaschemas as a single source of truth for db structure, data validation, and so on, I see a huge amount of manual labor in the migration of existing db structures to metarhia. While it should be a simple mechanical task with minimal manual revision afterward.

Describe the solution you'd like I would like to have a DDL files parser. It should take a specified directory with sql (or a single DDL file) and output translated metashema files to the designated directory.

Additional context I do know an expert in SQL parsers that I might ask for help, in case this issue seems actual.

georgolden commented 2 years ago

@leonpolak it would be super helpful, if you can provide SQL samples to work with. It will decrease time to implement this feature significantly. Simply, less time required to create samples by my side.