Schema Spy Publish to site.kuali.org

KULRICE-9615 - Data cannot be retrieved due to an unexpected error

Generating the Schema Spy output

• Install and configure schemaspy.
• Setup your Rice Database for the version you want to run schemaspy on.
• Please see the attached example script: schemaspy2.0.sh for how to create and introduce the offline downloadable zip file of the schemaspy output.
• The schema-spy output is linked to from src/site/docbook/books/database_diagrams.xml http://site.kuali.org/rice/2.1.1/reference/html/portal.html
  • We're not using the version tag for the link to schema spy as it doesn't need to be updated for minor releases if structural database changes haven't been made.

Publishing the output

First time s3cmd setup:

• Install S3cmd
  • Download s3cmd from http://s3tools.org/download
  • unzip ~/Downloads/s3cmd-1.1.0-beta3.zip
  • Make sure s3cmd is in your PATH
• Install GPG
  • On Mac install GPGTools
    • Run GPG Keychain Access to setup your GPG private key
  • On Linux install GPG (apt-get install gnupg)
  • On Windows install GPG4win
• Config s3cmd
  • s3cmd --configure
  • Use the credentials provided
  • Choose any pasword for "encrypted password", for transfer only
  • Save the file to ~/rice.dev.core.s3cfg

Using s3cmd:

• Upload the schemaspy directory for the version of rice using s3cmd (example)
  • s3cmd -c ~/rice.dev.core.s3cfg -r put --acl-public schema_spy_dir s3://site.origin.kuali.org/rice/version/reference/html/schema-spy/
  • see s3cmd --help , -c = config file, -r = recursive
• Check in browser http://s3.amazonaws.com/site.origin.kuali.org/rice/version/reference/html/schema-spy/index.html