search

k-kawa / erd

Simplest DSL to draw ER diagrams executable on any environments
36 stars 2 forks source link

Read and parse dumped SQL file #5

Open k-kawa opened 8 years ago

k-kawa commented 8 years ago

This feature will help me cope with undocumented projects. and it can be so nice if it can export schema data in the erd format

suntong commented 7 years ago

Check out https://github.com/knq/xo for this. The code and functionality is there, waiting for you to take advantage of, :-)

Good initiative and a good start, BTW. :+1:

k-kawa commented 7 years ago

Thanks, @suntong This issues has been abandoned because it was difficult and troublesome more than estimated for me to parse dumped SQLs and support its dialects. But https://github.com/knq/xo gives me a great hint. Loading the dumped SQL into a temporary running database server and accessing its metadata tables seems a good way to cope with its difficulty. I'll consider using the project.

suntong commented 7 years ago

Actually, if I were you, I'd close this and focus on The syntax (#9) instead. That'd be a better option than SQL code.

BTW, I'm starting to work on using knq/xo to generate ER diagrams.