mahara-contributors team mailing list archive

[Rebecca Blundell <1855630@xxxxxxxxxxxxxxxxxx>]

I found a way to see the database links, which show which tables are
connected and their relationships using some Open Source software called
Schemaspy. http://schemaspy.org/ It saves the database state in a folder
of html files which you can view in your browser.

How to use:

1. Download the latest Schemaspy jar from
https://github.com/schemaspy/schemaspy/releases/

2. Download the PostgreSQL JDBC driver for Java 8 (assuming you're running openJDK 8) from 
https://jdbc.postgresql.org/download.html

3. Put both jars in a directory of your choosing and go to that
directory.

4. Run the following command, changing details as necessary. (The list of commandline arguments for schemaspy is here: https://schemaspy.readthedocs.io/en/latest/configuration/commandline.html)
This command uses schemaspy to map a psql db called mahara-master and output results to a new directory called schemaspy. (This took around 7 mins).

java -jar schemaspy-6.1.0.jar -t pgsql -db mahara-master -host localhost
-u maharauser -p maharapassword -o ./schemaspy -dp postgresql-42.2.9.jar
-vizjs

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1855630

Title:
  Mahara map: an index of components

Status in Mahara:
  New

Bug description:
  Creating a map/library/index of Mahara components to know what things
  mean, what they connect to and how to find them.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1855630/+subscriptions