mahara-contributors team mailing list archive
-
mahara-contributors team
-
Mailing list archive
-
Message #56995
[Bug 1855630] Re: Mahara map: an index of components
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
References