cx-oracle-users

[cx-oracle-users] Distinguishing between select and update/delete/insert

[Mihai I. <mi...@re...>]

Hi,

Is there a way one can prepare a query and determine its type?
(select/update/insert/delete).

The reason: executemany() only applies to update/insert/delete. I have a
module that executes queries passed in by the user, and gets the bind params
from a .csv file. It would be nice to know when I can use execute vs.
executemany. It also helps to know if one has to fetch a result set (in case
of a select) or not do anything (for insert/update/delete).

I know in OCI you can check the type by comparing to OCI_STMT_SELECT et al -
is the statement type somewhat exposed at the Python level?

Thanks,
Misa

Re: [cx-oracle-users] Distinguishing between select and update/delete/insert

[Mihai I. <mi...@re...>]

On Wed, Jan 11, 2006 at 06:55:03PM -0500, Mihai Ibanescu wrote:
> Hi,
> 
> Is there a way one can prepare a query and determine its type?
> (select/update/insert/delete).
> 
> The reason: executemany() only applies to update/insert/delete. I have a
> module that executes queries passed in by the user, and gets the bind params
> from a .csv file. It would be nice to know when I can use execute vs.
> executemany. It also helps to know if one has to fetch a result set (in case
> of a select) or not do anything (for insert/update/delete).
> 
> I know in OCI you can check the type by comparing to OCI_STMT_SELECT et al -
> is the statement type somewhat exposed at the Python level?

... to reply to myself, exposing self->satementType as set by 
Cursor_GetStatementType to python, that's kind of what I'm looking for. I
don't see it done, would others find it to be valuable?

It would probably require a new read-only attribute of a Cursor object
exposed, and a bunch of constants OCI_STMT_* defined.

Misa

Re: [cx-oracle-users] Distinguishing between select and update/delete/insert

[Anthony T. <ant...@gm...>]

Actually, if all you want to distinguish between is queries and
non-queries there is an easier way. Simply ask for cursor.description
-- the value returned is None in only two cases. 1) no statement
executed and 2) the statement executed is not a query. Seems to fit
the bill, don't you think?

On 1/11/06, Mihai Ibanescu <mi...@re...> wrote:
> On Wed, Jan 11, 2006 at 06:55:03PM -0500, Mihai Ibanescu wrote:
> > Hi,
> >
> > Is there a way one can prepare a query and determine its type?
> > (select/update/insert/delete).
> >
> > The reason: executemany() only applies to update/insert/delete. I have =
a
> > module that executes queries passed in by the user, and gets the bind p=
arams
> > from a .csv file. It would be nice to know when I can use execute vs.
> > executemany. It also helps to know if one has to fetch a result set (in=
 case
> > of a select) or not do anything (for insert/update/delete).
> >
> > I know in OCI you can check the type by comparing to OCI_STMT_SELECT et=
 al -
> > is the statement type somewhat exposed at the Python level?
>
> ... to reply to myself, exposing self->satementType as set by
> Cursor_GetStatementType to python, that's kind of what I'm looking for. I
> don't see it done, would others find it to be valuable?
>
> It would probably require a new read-only attribute of a Cursor object
> exposed, and a bunch of constants OCI_STMT_* defined.
>
> Misa
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=3D7637&alloc_id=3D16865&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>