|
85
|
1 SQLPython is an open-source command-line environment for interacting with an
|
|
91
|
2 Oracle database. It is designed as an alternative to Oracle's SQL\*Plus.
|
|
85
|
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
|
|
91
|
28 Use sqlpython more or less as you would use SQL\*Plus.
|
|
85
|
29
|
|
|
30 Read the help. Experiment with UNIX-style and postgresql-style
|
|
|
31 commands.
|
|
|
32
|
|
|
33 Modifying
|
|
|
34 ---------
|
|
|
35
|
|
90
|
36 Modify mysqlpy.py; add `do_mycommand(self, arg)`
|
|
|
37 methods to the mysqlpy class to add your own commands.
|
|
|
38
|
|
|
39 Use `self.stdout.write(txt)` in place of `print txt`
|
|
|
40 to make sure your output can be redirected into text
|
|
|
41 files or the paste buffer with `>` and `>>`.
|
|
85
|
42
|
|
|
43 Contributing
|
|
|
44 ------------
|
|
|
45
|
|
|
46 Development trunk is available from::
|
|
|
47
|
|
|
48 http://www.assembla.com/wiki/show/sqlpython
|
|
|
49
|
|
|
50 Bugs and suggestions can be filed at::
|
|
|
51
|
|
|
52 http://www.assembla.com/spaces/sqlpython/tickets
|
|
|
53
|
