[FLYWAY] export schema documentation

Open
#22 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
5/5
Estimated time
Over a week
Newbie friendliness
25/100
Issue type
Documentation
Clarity
Needs clarification
Activity status
Stale
Tech stack
python, sql

Research direction

The issue names no files, tests, or entry points. Read the existing JavaDoc-style schema documentation and clarify whether the project will use database comments with a Python package or retain JavaDoc formatting. Done means the documentation approach and implementation scope for Sphinx/read-the-docs are agreed.

Written by the indexing model from the issue text.

Description

Current schema uses JavaDoc style comment for tables, view, packages, etc. This works as the tables and view and defined direction and updated in place. With flyway, every change is a change.

Proposed mechanism:

  1. Comments on Packages and Types remain (Oracle does not support comments on those objects)
  2. However we move to pydocs
  3. Table/View/Column information will be pull from the database (so comment on ... is '...' should be used)
  4. And a "python package" created

With a python library created that maps to the packages, tables, and view, we can more readily pull the docs into the sphinx read-the-docs system.

Alternative:

  1. Instead of python we can retain the javadoc style formatting and host separately.

However, as PLSQL supports default parameters and Python does as well, this will likely be a cleaner mapping.

Dominant language
Visual Basic 6.0
Stars
4
Forks
8
Avg merge
8d 20h
Merged PRs (30d)
4

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from HydrologicEngineeringCenter/cwms-database

All issues in HydrologicEngineeringCenter/cwms-database

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.