[sage-support] Re: Database Connection
On Jul 1, 2009, at 1:47 AM, Aleksey Gogolev wrote: Hello! I need to operate on a statistical data in the sage notebook. But before I do that I need to get this data from the Oracle DB. Is there a way to get data from DB? Cann't find the answer manually :( Any help would be appreciated. Try searching for a way to do it from Python--it's not unlikely someone's already written a package to do so. Alternatively, see if you can export the data as a text file and then parse it (again, using all that Python has to offer). - Robert --~--~-~--~~~---~--~~ To post to this group, send email to sage-support@googlegroups.com To unsubscribe from this group, send email to sage-support-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sage-support URLs: http://www.sagemath.org -~--~~~~--~~--~--~---
[sage-support] Re: Database Connection
On Wed, Jul 1, 2009 at 10:58 AM, Robert
Bradshawrober...@math.washington.edu wrote:
On Jul 1, 2009, at 1:47 AM, Aleksey Gogolev wrote:
Hello!
I need to operate on a statistical data in the sage notebook. But
before I do that I need to get this data from the Oracle DB. Is there
a way to get data from DB?
Cann't find the answer manually :( Any help would be appreciated.
Try searching for a way to do it from Python--it's not unlikely
someone's already written a package to do so. Alternatively, see if
you can export the data as a text file and then parse it (again,
using all that Python has to offer).
Indeed, Googling
oracle db python
yields numerous hits. The first hit has this example, which
obviously requires first installing some package:
import cx_Oracle
connstr='scott/tiger'
conn = cx_Oracle.connect(connstr)
curs = conn.cursor()
curs.arraysize=50
curs.execute('select 2+2 aaa ,3*3 from dual')
print curs.description
print curs.fetchone()
conn.close()
William
--~--~-~--~~~---~--~~
To post to this group, send email to sage-support@googlegroups.com
To unsubscribe from this group, send email to
sage-support-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sage-support
URLs: http://www.sagemath.org
-~--~~~~--~~--~--~---
[sage-support] Re: Database Connection
Thanks!
2009/7/1 William Stein wst...@gmail.com:
On Wed, Jul 1, 2009 at 10:58 AM, Robert
Bradshawrober...@math.washington.edu wrote:
On Jul 1, 2009, at 1:47 AM, Aleksey Gogolev wrote:
Hello!
I need to operate on a statistical data in the sage notebook. But
before I do that I need to get this data from the Oracle DB. Is there
a way to get data from DB?
Cann't find the answer manually :( Any help would be appreciated.
Try searching for a way to do it from Python--it's not unlikely
someone's already written a package to do so. Alternatively, see if
you can export the data as a text file and then parse it (again,
using all that Python has to offer).
Indeed, Googling
oracle db python
yields numerous hits. The first hit has this example, which
obviously requires first installing some package:
import cx_Oracle
connstr='scott/tiger'
conn = cx_Oracle.connect(connstr)
curs = conn.cursor()
curs.arraysize=50
curs.execute('select 2+2 aaa ,3*3 from dual')
print curs.description
print curs.fetchone()
conn.close()
William
--~--~-~--~~~---~--~~
To post to this group, send email to sage-support@googlegroups.com
To unsubscribe from this group, send email to
sage-support-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sage-support
URLs: http://www.sagemath.org
-~--~~~~--~~--~--~---
