SQLPython

SQLPython is a SQL command-line client designed with extensibility and personalization in mind.

Scope

SQLPython is a command line tool written in python with the following goals:

• emulate Oracle's sqlplus basic functionalities in python
• allow easy extensions to sqlplus functionalities leveraging python's class inheritance
• allow to consolidate custom sql scripts into new SQLPython commands
• allow to jump out the sql environment into python to post process query result sets
• new: sqlpython originally developed as an Oracle CLI, is being extended for more DB platforms

NEWS

• join sqlpython google group if you want to contribute to development and testing.
• sqlpython can be installed from the cheese shop:
  • find the latest version: http://pypi.python.org/pypi?%3Aaction=search&term=sqlpython&submit=search

• How-to install:
  • install python 2.6
  • install cx_oracle from: http://cx-oracle.sourceforge.net
  • Download ez_setup.py from http://peak.telecommunity.com/dist/ez_setup.py
  • Install setuptools: python ez_setup.py
  • install with: easy_install sqlpython
    • example for windows, python 2.6: python Scripts\easy_install-2.6-script.py sqlpython

Author: Luca Canali
Co-author and main developer currently: Catherine Devlin
Feedback to: luca.canali -at- cern.ch, http://canali.web.cern.ch/canali
Latest version on this wiki: 1.3.0, ChangeLog
Current version: 1.6.5.1, May 2009 (see pipy.python.org)

How to get started (applies only to legacy version 1.3.0):

Dependencies: python 2.2 or higher, cx_Oracle, and Oracle client.
Download, untar and start with ./run (or from the python command line with 'import mysqlpy'). Click this link to download SQLpython source:

• https://twiki.cern.ch/twiki/pub/PSSGroup/SqlPython/sqlpython.tar

Files:

• README, description and basic instructions
• sqlpython.py - the core module, lean implementation of the main sqlplus functionalities in python
• sqlpyPlus.py - extention to sqlpython
• mysqlpy.py - Extention with custom functionality (dba-oriented) and default entry-point for sqlpython. See header file.
• run - jump-start shell script