schemacrawler / SchemaCrawler

Free database schema discovery and comprehension tool
http://www.schemacrawler.com/
Other
1.6k stars 199 forks source link

output Lints as csv #128

Closed adriens closed 7 years ago

adriens commented 7 years ago

hi Sualeh, is there any proper way to export lint report as csv ? I'd like to play with lint reports from python/R to perform some stats on them ;-p

schemacrawler commented 7 years ago

I will try to give you some sample code.

adriens commented 7 years ago

Great, thanks @sualeh !

adriens commented 7 years ago

Should it be developed as a plugin ?

schemacrawler commented 7 years ago

Yes. Please go ahead and develop a plugin that meets your needs.

adriens commented 7 years ago

OK @sualeh , thanks for your answer, i was not impatient but just wanted to be sure to develop thie feature at the right place ;-p

adriens commented 7 years ago

I guess you can now close this issue ;-p

schemacrawler commented 7 years ago

Well, I have a better idea. You can try this Gist out! https://gist.github.com/sualeh/8cd3df1d4add9b9391875cc7c79ca6c0

schemacrawler commented 7 years ago

@adriens - please let me know how the scripting solution works for you.

adriens commented 7 years ago

Also done with csv plugin see https://github.com/adriens/schemacrawler-csv-plugin

schemacrawler commented 7 years ago

👍 My favorite line is the one that gives you mints!

adriens commented 7 years ago

Fixed, thx @sualeh

schemacrawler commented 7 years ago

I liked it better when you got mints! I like mints. ;-)

adriens commented 7 years ago

For sure, tastes much better !