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

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

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
Posted by George Essig on
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