#68 add documentation of stored procedures and functions

[Tim]

It would be great if the tool could also add html pages describing stored procedures and views, perhaps extracting some kind of standardised information from formatted comments. (I don't have a any particular format in mind but something similar to how javadoc grabs information from functions in code).

[John Currier]

SchemaSpy already supports extracting view comments via selectViewsSql, selectTableCommentsSql, selectViewCommentsSql, selectColumnCommentsSql or selectViewColumnCommentsSql. If any of these return comments about the view / view columns they'll be presented in the view details.

Stored procedure support would require custom SQL for each type of database. That shouldn't be that difficult, but formatting it would be a project of its own.

Adding html pages as you've suggested would require development of some way to associate an additional page with any schema, table or view. I assume it'd be a relatively simple XML file with either links or embedded content, but dealing with multiple schemas might get hairy.

John

[Tim]

fyi I've started work on a fork of schemaSpy to suit my own needs. you are welcome to pull in anything you like from it into your project

http://repo.or.cz/w/sqlHawk.git

I gave it a different repo name to avoid confusion.

[John Currier]

Have you written an SQL formatter to render the SQL/code in html? The concept shouldn't be that difficult to implement other than the required formatting.

[Tim]

not yet but it's on my todo list :-)
my primary aim is to be able to apply db changes from what's stored on the file system. schemaspy has given me an excellent starting point for doing this.