# HG changeset patch # User catherine@localhost # Date 1211229924 14400 # Node ID b336d049cac7d9c9c4f3f33562035518b255a55e # Parent a7be838c4ad5eed150256c9c4c2638b0e4844942 bugs found during gcoug talk prep diff -r a7be838c4ad5 -r b336d049cac7 README.txt --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/README.txt Mon May 19 16:45:24 2008 -0400 @@ -0,0 +1,51 @@ +SQLPython is an open-source command-line environment for interacting with an +Oracle database. It is designed as an alternative to Oracle's SQL*Plus. + +Installing +---------- + +Debian/Ubuntu:: + + $ sudo apt-get install python python-dev python-setuptools + $ sudo easy_install cx_Oracle + $ sudo easy_install -UZ sqlpython + +Windows: +Download and run executable installers from:: + + http://www.python.org (Python language) + http://cx-oracle.sourceforge.net/ (cx_Oracle) + http://pypi.python.org/pypi/sqlpython (sqlpython) + +Other: +Python is typically already installed. You'll need its +development package (python-dev); then easy_install +cx_Oracle and sqlpython as per Debian. + +Using +----- + +Use sqlpython more or less as you would use SQL*Plus. + +Read the help. Experiment with UNIX-style and postgresql-style +commands. + +Modifying +--------- + +Modify mysqlpy.py; add `do_mycommand(self, arg)` methods to the +mysqlpy class to add your own commands. Use `self.stdout.write(txt)` +in place of `print txt` to make sure your output can be redirected +into text files or the paste buffer with `>` and `>>`. + +Contributing +------------ + +Development trunk is available from:: + + http://www.assembla.com/wiki/show/sqlpython + +Bugs and suggestions can be filed at:: + + http://www.assembla.com/spaces/sqlpython/tickets + diff -r a7be838c4ad5 -r b336d049cac7 setup.py --- a/setup.py Thu May 15 17:37:54 2008 -0400 +++ b/setup.py Mon May 19 16:45:24 2008 -0400 @@ -16,6 +16,7 @@ author_email="luca.canali@cern.ch", url="https://twiki.cern.ch/twiki/bin/view/PSSGroup/SqlPython", packages=find_packages(), + include_package_data=True, install_requires=['pyparsing','cmd2','cx_Oracle'], keywords = 'client oracle database', license = 'MIT', diff -r a7be838c4ad5 -r b336d049cac7 sqlpyPlus.py --- a/sqlpyPlus.py Thu May 15 17:37:54 2008 -0400 +++ b/sqlpyPlus.py Mon May 19 16:45:24 2008 -0400 @@ -882,12 +882,6 @@ result.append('%s/%s' % (object_type, object_name)) self.stdout.write('\n'.join(result) + '\n') - - if options.has_key('insensitive'): - searchfor = "LOWER(text)" - arg = arg.lower() - - def do_cat(self, arg): targets = arg.split() for target in targets: