plsql-md-doc icon indicating copy to clipboard operation
plsql-md-doc copied to clipboard

Add ability to parse .sql files like views

Open vitodcampanelli opened this issue 7 years ago • 1 comments

I would like to be able to create documentation for views as well. It would be nice if it would be able to get the fields from the select list or the ability to add the fields manually. I tried to use the template package.md for .sql but all that display is the description. I would like to be able to do something like this:

/**
 * View is used for ..........
 *
 * @field field1 maybe ability to description of field
 * @field field2 maybe ability to description of field
 *
 * @author John Doe
 * @created 23-Nov-2017
 */

Thanks

vitodcampanelli avatar Nov 23 '17 14:11 vitodcampanelli

/**
 * View is used to see the employee details. 
 *
 * @issue #123
 *
 * @field id the primary key
 * @field start_date the employee's start date
 * @field end_date the employee's end date
 *
 * @author John Doe
 * @created 23-Nov-2017
 */
create or replace view v_table
as
select    id,
          start_date,
          end_date
from table
where ....

vitodcampanelli avatar Nov 23 '17 16:11 vitodcampanelli