Forum OpenACS Q&A: PG OACS 5.1.1 Schema Diagrams - PNG, PS, PDF Formats

Collapse
1: PG OACS 5.1.1 Schema Diagrams - PNG, PS, PDF Formats
Posted by George Essig on 08/19/04 06:19 PM
I created schema diagrams for the postgresql openacs 5.1.1 kernel using postgresql_autodoc, graphviz, and photoshop. I uploaded the files to:

https://openacs.org/storage/download/oacs_5_kernel.png?version_id=199110
https://openacs.org/storage/download/oacs_5_kernel.ps?version_id=199112
https://openacs.org/storage/download/oacs_5_kernel.pdf?version_id=199117

I hope this is useful to someone.

George Essig

Collapse
2: Re: PG OACS 5.1.1 Schema Diagrams - PNG, PS, PDF Formats (response to 1)
Posted by Rocael Hernández Rizzardini on 08/19/04 07:29 PM
excellent George!

Very useful indeed.

Can you detail a little how you did this (the steps), then another package owners might take some time to do the same for their packages. Graphics always help a lot.

Collapse
3: Re: PG OACS 5.1.1 Schema Diagrams - PNG, PS, PDF Formats (response to 2)
Posted by George Essig on 08/19/04 08:07 PM
Get graphviz from:

http://www.graphviz.org/

I actually used the SuSE 9.1 RPM.

Get postgresql_autodoc from:

https://github.com/cbbrowne/autodoc

Create a database containing want you want to diagram. 

createdb oacs_5_kernel
createlang plpgsql oacs_5_kernel
psql oacs_5_kernel < ./acs-kernel-create.sql

Use postgresql_autodoc to generate documentation files in html, dia, dot, and xml formats. 

postgresql_autodoc -d oacs_5_kernel -f oacs_5_kernel

Use the graphviz dot command to convert the dot file into png and ps files. 

dot -Tpng -o oacs_5_kernel.png oacs_5_kernel.dot
dot -Tps -o oacs_5_kernel.ps oacs_5_kernel.dot

Used Adobe Photoshop to convert the ps file to pdf. Other utilities like ps2pdf and Adobe distiller truncated the diagram. I don't know why.

I just uploaded the postgresql_autodoc html file to:

https://openacs.org/storage/download/oacs_5_kernel.html?version_id=199144

George Essig