Re: [cx-oracletools-users] Regards to all members

On Thu, Mar 5, 2009 at 7:05 PM, Marcos Ortiz Valmaseda
<ml...@es...> wrote:
> Firstly, regards to all members of the list.
> I write to you because I´m developing a Python aplication to be efective a
> Oracle migration to PostgreSQL compatible schema and I´m using many tools
> developed by Anthony Tuininga, especificaly cx_Oracle 5.0 and cx_OracleTools
> and I need to know what is the result of the DumpData.py module and the
> ExportData.py.

ExportData will dump the data into a pickle type format that another
Python program could read but is designed for use by the paired tool
called ImportData. If you are interested in using it for your own
purposes then read the source code and ask me questions if you run
stuck. However if you're converting your own data you could simply
write your own code using cx_Oracle with the source of cx_OracleTools
as a guide if that's helpful. cx_OracleTools is meant to be generic,
though, so it may not help you as much as you might like.

DumpData will dump the data as SQL statements that could be executed
by SQL*Plus, for example. Its intended for tables that contain a small
number of rows where someone might wish to

> My aplication use the Python language on the core of the same and one
> version is developed with Qt4 and the second with Python module
> python-newt,excellent for to the development work with text-mode
> aplications.
>
> 2-  I need more examples of the cx_OracleTools use

Using these at the command line? Or something else? All of the tools
have the --help option which will give you details on all of the
arguments and options and a description of each.

> 3-  When you build a Connection Object with the cx_Oracle module, the sintax
> is very easy, but you can pass many options to the constructor. ¿Which
> options I can pass? and please send a example.

Most of the options are only needed for specialty situations. The
simplest is the following:

connection = cx_Oracle.Connection("user/password@tnsentry")

In other words, the same connect string format used by SQL*Plus. If
you want more details on the other options, look at the supplied
documentation for cx_Oracle.

Anthony