Forum OpenACS Q&A: perl script to automatically create new object type sql/plpgsql

Collapse
1: perl script to automatically create new object type sql/plpgsql
Posted by Mark Aufflick on 09/21/08 01:47 PM
I'm a pretty lazy person. I have a beard so I don't have to shave. Similarly, I didn't want to ever have to write a create-*.sql package by hand again, so I wrote a perl script to do it for me.

You write your create table sql, and this script will do the rest.

Full documentation (including sample output) is at : http://svn.pumptheory.com/cgi-bin/pod2html.cgi?path=openacs/scripts/oacs-create-type.pl

You can download the script at : http://svn.pumptheory.com/repos/trunk/openacs/scripts/oacs-create-type.pl

Don't look too carefully at the code, it's a little messy but it does the trick.

Collapse
2: Re: perl script to automatically create new object type sql/plpgsql (response to 1)
Posted by Mark Aufflick on 09/21/08 01:49 PM
I forgot to mention, the docs also include an emacs lisp function that allows you to expand your create table into a full package in an emacs buffer.

I also forgot to say that this is postgres specific. Writing an oracle version is an exercise left to the reader.

Collapse
3: Re: perl script to automatically create new object type sql/plpgsql (response to 1)
Posted by Joany Maria Princy on 08/30/10 09:51 AM
this is not a reply,

Hi Friends


I want to add a new form, for that we have to mention the OBJECT_ID and OBJECT_TYPE

Please how to create a new one ,please help me in this