Skip to content

Instantly share code, notes, and snippets.

@evandertino

evandertino/SchemaSpy-v6.md

Forked from nihonzaru/SchemaSpy-v6.md
Created March 9, 2019 18:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save evandertino/b92bf4625a1df4e6f23c02ccf4e5e37c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save evandertino/b92bf4625a1df4e6f23c02ccf4e5e37c to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @takamatsu takamatsu revised this gist Sep 7, 2017. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion SchemaSpy-v6.md
    View file
    Original file line number Diff line number Diff line change
    @@ -25,5 +25,5 @@ http://schemaspy.readthedocs.io/en/latest/started.html#configuration
    $ docker run --rm \
    -v /path-to/schemaspy.properties:/tmp/schemaspy/schemaspy.properties -v \
    -v /path-to/output:/tmp/schemaspy/output -v \
    -d my/schemaspy # another schemaspy-options...
    -d my/schemaspy -hq # another options...
    ```
  2. @takamatsu takamatsu revised this gist Sep 7, 2017. 1 changed file with 0 additions and 1 deletion.
    1 change: 0 additions & 1 deletion SchemaSpy-v6.md
    View file
    Original file line number Diff line number Diff line change
    @@ -7,7 +7,6 @@

    ## Download JDBC

    Download from Oracle
    http://www.oracle.com/technetwork/database/features/jdbc/index.html

    ## Build Docker image
  3. @takamatsu takamatsu renamed this gist Sep 7, 2017. 1 changed file with 0 additions and 0 deletions.
    0 SchemaSpy-v6-Dockerfile → SchemaSpy-v6_Dockerfile
    View file
    File renamed without changes.
  4. @takamatsu takamatsu revised this gist Sep 7, 2017. 2 changed files with 0 additions and 0 deletions.
    0 SchemaSpy-Dockerfile → SchemaSpy-v6-Dockerfile
    View file
    File renamed without changes.
    0 SchemaSpy.md → SchemaSpy-v6.md
    View file
    File renamed without changes.
  5. @takamatsu takamatsu revised this gist Sep 7, 2017. No changes.
  6. @takamatsu takamatsu created this gist Sep 7, 2017.
    20 changes: 20 additions & 0 deletions SchemaSpy-Dockerfile
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,20 @@
    FROM java:openjdk-8u111-jre-alpine

    ENV LC_ALL C

    RUN apk update
    RUN apk add graphviz
    RUN apk add fontconfig
    RUN apk add unzip

    WORKDIR /tmp/schemaspy

    # TODO: Rename to real path
    ADD ./ojdbcXX.jar .

    ADD https://github.com/schemaspy/schemaspy/releases/download/v6.0.0-rc1/schemaspy-6.0.0-rc1.jar .
    ADD https://www.fontsquirrel.com/fonts/download/open-sans ./open-sans.zip
    RUN unzip open-sans.zip -d /usr/share/fonts
    RUN fc-cache -fv

    ENTRYPOINT ["java", "-jar", "schemaspy-6.0.0-rc1.jar"]
    30 changes: 30 additions & 0 deletions SchemaSpy.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,30 @@
    # Usage

    ## Refs

    * http://schemaspy.org/
    * http://schemaspy.sourceforge.net/

    ## Download JDBC

    Download from Oracle
    http://www.oracle.com/technetwork/database/features/jdbc/index.html

    ## Build Docker image

    ```bash
    $ docker build -t my/schemaspy .
    ```

    ## Create schemaspy.properties

    http://schemaspy.readthedocs.io/en/latest/started.html#configuration

    ## Run Docker container (Generate Database info)

    ```bash
    $ docker run --rm \
    -v /path-to/schemaspy.properties:/tmp/schemaspy/schemaspy.properties -v \
    -v /path-to/output:/tmp/schemaspy/output -v \
    -d my/schemaspy # another schemaspy-options...
    ```