0.0.5 • Published 4 years ago

dblookup-markdown v0.0.5

Weekly downloads
7
License
MIT
Repository
github
Last release
4 years ago

dblookup-markdown

The easiest way to document your Database schema.


This package will generate Markdown that beautifully renders your Database schema in an easily explorable document.

$ npm install dblookup-markdown -g

Usage

Command Line API

Installing the package adds a dblookup-markdown script. Point it at a schema and the output will be written to stdout.

The schema may be retrieved from a Database endpoint:

$ dblookup-markdown "Data Source=SERVER\INSTANCE;Initial Catalog=Demo;Persist Security Info=True;User ID=APP_Demo;password=XXXXX" > lookup.md

…or update existing file:

$ dblookup-markdown "Data Source=SERVER\INSTANCE;Initial Catalog=Demo;Persist Security Info=True;User ID=APP_Demo;password=XXXXX" -u "./lookup.md"

If --update-file is given, the generated Markdown will be output to the given file between the <!-- START dblookup-markdown --> and <!-- END dblookup-markdown --> comment markers instead of printed to STDOUT. If the file does not exist, it will be created (and will include the comment markers for future updates).

Options

$ dblookup-markdown --help

Usage: dblookup-markdown [options] <connectionString>

Output a Markdown document 

Options:

  --update-file <file>   Markdown document to update (between comment markers) or
                         create (if the file does not exist)

Output

Database Demo

AddressType

Lookup Table For Address Types

IdAddress type
1Customer
2CustomerContact
3Supplier
4DeliveryAddress

Application

Lookup table to Identify application

IdName
1Unknown
2SAS
3Warehouse
4Warehouse Mobile
5Sales
6Accounts
7Buildroom
8OnePortal
9Calendar