Re: [cx-oracletools-users] cx-oracletools-users Digest, Vol 11, Issue 2
Brought to you by:
atuining
From: Marcos O. V. <ml...@es...> - 2009-03-09 02:16:32
|
Thanks for your answer my friend. Very soon , you´ll have news of my person about my work with cx_Oracle regards El sáb, 07-03-2009 a las 12:04 +0000, cx-...@li... escribió: > Send cx-oracletools-users mailing list submissions to > cx-...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users > or, via email, send a message with subject or body 'help' to > cx-...@li... > > You can reach the person managing the list at > cx-...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of cx-oracletools-users digest..." > > > Today's Topics: > > 1. Re: Regards to all members (Anthony Tuininga) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 6 Mar 2009 10:48:26 -0700 > From: Anthony Tuininga <ant...@gm...> > Subject: Re: [cx-oracletools-users] Regards to all members > To: cx-...@li... > Message-ID: > <703...@ma...> > Content-Type: text/plain; charset=ISO-8859-1 > > 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 > > > > ------------------------------ > > ------------------------------------------------------------------------------ > Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open source participation > -Receive a $600 discount off the registration fee with the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > > ------------------------------ > > _______________________________________________ > cx-oracletools-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users > > > End of cx-oracletools-users Digest, Vol 11, Issue 2 > *************************************************** |