I'm pleased to announce the initial release of OraPIG,
the Oracle Python Interface Generator.

OraPIG generates Python wrapper classes for Oracle packages.

If you use Oracle and Python, this might be a pretty useful
package for you. Download it and let us know what
you think!

(and special thanks to everyone that helped me out with
all of my tedious data dictionary queries a while back, I
hope this package shows it wasn't a total waste of
your time!)

Cheers,
Mark

Download and docs: http://code.google.com/p/orapig

----------------

Quick Example: Suppose you have a package called tiny
with a single procedure p:

create or replace package tiny
as
procedure p(x in number);
end tiny;

OraPIG will generate a wrapper class that will allow you to
use the package without having to use the various database
calls. Instead, the wrapper class will be instantiated and
called just like any other Python class:

class Tiny:
def __init__(self,curs): # instantiate class with a cursor
...
def p(self,x): # call procedure p(x)
...

Here's how it's used:

import cx_Oracle
import tiny
conn = cx_Oracle.connect('scott/tiger')
curs = conn.cursor()

mytiny = tiny.Tiny(curs)
mytiny.p(2) # call a procedure
curs.commit() # not done automatically

--
Mark Harrison
Pixar Animation Studios

mh (AT) pixar (DOT) com wrote:
And we'd be pleased if you behaved like a member of our
community and didn't insult us wit spam in violation of
this group's charter.

You can post your commercial / promotional materials to
c.d.o.marketplace. But here all you are doing is getting
those who might be interested angry by showing us
disrespect. Your post, if allowed, invites every spammer
on the planet to post here too.

Your apology would be greatly appreciated.

Thank you.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

mh (AT) pixar (DOT) com wrote:
And we'd be pleased if you behaved like a member of our
community and didn't insult us wit spam in violation of
this group's charter.

You can post your commercial / promotional materials to
c.d.o.marketplace. But here all you are doing is getting
those who might be interested angry by showing us
disrespect. Your post, if allowed, invites every spammer
on the planet to post here too.

Your apology would be greatly appreciated.

Thank you.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

mh (AT) pixar (DOT) com wrote:
And we'd be pleased if you behaved like a member of our
community and didn't insult us wit spam in violation of
this group's charter.

You can post your commercial / promotional materials to
c.d.o.marketplace. But here all you are doing is getting
those who might be interested angry by showing us
disrespect. Your post, if allowed, invites every spammer
on the planet to post here too.

Your apology would be greatly appreciated.

Thank you.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

mh (AT) pixar (DOT) com wrote:
And we'd be pleased if you behaved like a member of our
community and didn't insult us wit spam in violation of
this group's charter.

You can post your commercial / promotional materials to
c.d.o.marketplace. But here all you are doing is getting
those who might be interested angry by showing us
disrespect. Your post, if allowed, invites every spammer
on the planet to post here too.

Your apology would be greatly appreciated.

Thank you.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

DA Morgan <damorgan (AT) psoug (DOT) org> wrote:
Hmm, my intention in posting was just to say Thanks
to the people here (including you -- thanks again!!)
who helped me figure out the data dictionary stuff
and to let them know that I'm passing along what I've
learned from them to other people. (That's why there's
the special callout at the bottom of the message.)

I don't interpret the message as a violation of the charter,
which says in point 3

"The posting of commercial message, messages intended
to promote the sale of a product or service are expressly
forbidden in this group. Please restrict commercial messages to
comp.database.oracle.marketplace"

and in point 6

"Avoid SPAM or commercial messages"

these from: http://unixadmintalk.com/f35/cfv-com...q-post-274104/

Since the message was not a commercial message or promoting
the sale of a product or service, I didn't feel that .marketplace
was the appropriate venue. And, since I was especially trying
to say thanks to the denizens of .misc, I felt this was the
appropriate group.

Anyways, apologies all around and thanks again for the help!

--
Mark Harrison
Pixar Animation Studios

DA Morgan <damorgan (AT) psoug (DOT) org> wrote:
Hmm, my intention in posting was just to say Thanks
to the people here (including you -- thanks again!!)
who helped me figure out the data dictionary stuff
and to let them know that I'm passing along what I've
learned from them to other people. (That's why there's
the special callout at the bottom of the message.)

I don't interpret the message as a violation of the charter,
which says in point 3

"The posting of commercial message, messages intended
to promote the sale of a product or service are expressly
forbidden in this group. Please restrict commercial messages to
comp.database.oracle.marketplace"

and in point 6

"Avoid SPAM or commercial messages"

these from: http://unixadmintalk.com/f35/cfv-com...q-post-274104/

Since the message was not a commercial message or promoting
the sale of a product or service, I didn't feel that .marketplace
was the appropriate venue. And, since I was especially trying
to say thanks to the denizens of .misc, I felt this was the
appropriate group.

Anyways, apologies all around and thanks again for the help!

--
Mark Harrison
Pixar Animation Studios

DA Morgan <damorgan (AT) psoug (DOT) org> wrote:
Hmm, my intention in posting was just to say Thanks
to the people here (including you -- thanks again!!)
who helped me figure out the data dictionary stuff
and to let them know that I'm passing along what I've
learned from them to other people. (That's why there's
the special callout at the bottom of the message.)

I don't interpret the message as a violation of the charter,
which says in point 3

"The posting of commercial message, messages intended
to promote the sale of a product or service are expressly
forbidden in this group. Please restrict commercial messages to
comp.database.oracle.marketplace"

and in point 6

"Avoid SPAM or commercial messages"

these from: http://unixadmintalk.com/f35/cfv-com...q-post-274104/

Since the message was not a commercial message or promoting
the sale of a product or service, I didn't feel that .marketplace
was the appropriate venue. And, since I was especially trying
to say thanks to the denizens of .misc, I felt this was the
appropriate group.

Anyways, apologies all around and thanks again for the help!

--
Mark Harrison
Pixar Animation Studios

DA Morgan <damorgan (AT) psoug (DOT) org> wrote:
Hmm, my intention in posting was just to say Thanks
to the people here (including you -- thanks again!!)
who helped me figure out the data dictionary stuff
and to let them know that I'm passing along what I've
learned from them to other people. (That's why there's
the special callout at the bottom of the message.)

I don't interpret the message as a violation of the charter,
which says in point 3

"The posting of commercial message, messages intended
to promote the sale of a product or service are expressly
forbidden in this group. Please restrict commercial messages to
comp.database.oracle.marketplace"

and in point 6

"Avoid SPAM or commercial messages"

these from: http://unixadmintalk.com/f35/cfv-com...q-post-274104/

Since the message was not a commercial message or promoting
the sale of a product or service, I didn't feel that .marketplace
was the appropriate venue. And, since I was especially trying
to say thanks to the denizens of .misc, I felt this was the
appropriate group.

Anyways, apologies all around and thanks again for the help!

--
Mark Harrison
Pixar Animation Studios

mh (AT) pixar (DOT) com wrote:

Thank you for your prompt reply.

What bothered me was the:
"I'm pleased to announce the initial release of" which read
not a thank you but as a promotion.

But the fact that you have done the right think is really
appreciated and I am sure will win you friends in the
community.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org