Run Custom Scripts with SchemaCrawler

README.md

Run Custom Scripts with SchemaCrawler

See docker-compose and mermaid diagrams

How To Generate mermaid diagrams

• Save all the files from this gist into a single directory
• Run docker-compose -f schemacrawler-sqlite-mermaid.yml

How To Run Custom Scripts

• Save all the files from this gist into a single directory
• Run docker-compose -f schemacrawler-sqlite-script.yml

schemacrawler-sqlite-mmd.yml

version: '3.7'

services:

  schemacrawler:
    image: schemacrawler/schemacrawler
    container_name: schemacrawler
    volumes:
      - type: bind
        source: ./target
        target: /home/schcrwlr/testdb
      - type: bind
        source: ./
        target: /home/schcrwlr/share
    entrypoint: ['/opt/schemacrawler/bin/schemacrawler.sh']
    command: --url="jdbc:sqlite:sc.db" --info-level=standard --command=script --script-language=python --script=mermaid.py --output-file=share/db-schema.mmd

schemacrawler-sqlite-script.yml

version: '3.7'

services:

  schemacrawler:
    image: schemacrawler/schemacrawler
    container_name: schemacrawler
    volumes:
      - type: bind
        source: ./target
        target: /home/schcrwlr/testdb
      - type: bind
        source: ./
        target: /home/schcrwlr/share
    entrypoint: ['/opt/schemacrawler/bin/schemacrawler.sh']
    command: --url="jdbc:sqlite:sc.db" --info-level=standard --command=script --script-language=python --script=share/tables.py --output-file=share/db-schema.txt

tables.py

print(catalog.crawlInfo)

for table in catalog.tables:
  print('')
  print(table.fullName)
  for childTable in table.referencingTables:
    print("  [child] " + childTable.fullName)