|
85
|
1 SQLPython is an open-source command-line environment for interacting with an
|
|
|
2 Oracle database. It is designed as an alternative to Oracle's SQL*Plus.
|
|
|
3
|
|
|
4 Installing
|
|
|
5 ----------
|
|
|
6
|
|
|
7 Debian/Ubuntu::
|
|
|
8
|
|
|
9 $ sudo apt-get install python python-dev python-setuptools
|
|
|
10 $ sudo easy_install cx_Oracle
|
|
|
11 $ sudo easy_install -UZ sqlpython
|
|
|
12
|
|
|
13 Windows:
|
|
|
14 Download and run executable installers from::
|
|
|
15
|
|
|
16 http://www.python.org (Python language)
|
|
|
17 http://cx-oracle.sourceforge.net/ (cx_Oracle)
|
|
|
18 http://pypi.python.org/pypi/sqlpython (sqlpython)
|
|
|
19
|
|
|
20 Other:
|
|
|
21 Python is typically already installed. You'll need its
|
|
|
22 development package (python-dev); then easy_install
|
|
|
23 cx_Oracle and sqlpython as per Debian.
|
|
|
24
|
|
|
25 Using
|
|
|
26 -----
|
|
|
27
|
|
|
28 Use sqlpython more or less as you would use SQL*Plus.
|
|
|
29
|
|
|
30 Read the help. Experiment with UNIX-style and postgresql-style
|
|
|
31 commands.
|
|
|
32
|
|
|
33 Modifying
|
|
|
34 ---------
|
|
|
35
|
|
|
36 Modify mysqlpy.py; add `do_mycommand(self, arg)` methods to the
|
|
|
37 mysqlpy class to add your own commands. Use `self.stdout.write(txt)`
|
|
|
38 in place of `print txt` to make sure your output can be redirected
|
|
|
39 into text files or the paste buffer with `>` and `>>`.
|
|
|
40
|
|
|
41 Contributing
|
|
|
42 ------------
|
|
|
43
|
|
|
44 Development trunk is available from::
|
|
|
45
|
|
|
46 http://www.assembla.com/wiki/show/sqlpython
|
|
|
47
|
|
|
48 Bugs and suggestions can be filed at::
|
|
|
49
|
|
|
50 http://www.assembla.com/spaces/sqlpython/tickets
|
|
|
51
|
