Mercurial > sqlpython

changeset 324:9cbea1d8872e 1.6.4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
version 1.6.4, works with cmd2 0.5.2 for more flexible testing
author Catherine Devlin <catherine.devlin@gmail.com>
date Fri, 03 Apr 2009 13:09:54 -0400
parents b97f1b8cdecd
children 8721372d81be
files setup.py sqlpython/exampleSession.txt sqlpython/mysqlpy.py sqlpython/sqlpython.py
diffstat 4 files changed, 20 insertions(+), 17 deletions(-) [+]
line wrap: on
line diff
--- a/setup.py	Fri Apr 03 08:00:45 2009 -0400
+++ b/setup.py	Fri Apr 03 13:09:54 2009 -0400
@@ -9,7 +9,7 @@
 Operating System :: OS Independent""".splitlines()
 
 setup(name="sqlpython",
-      version="1.7.0",
+      version="1.6.4",
       description="Command-line interface to Oracle",
       long_description="Customizable alternative to Oracle's SQL*PLUS command-line interface",
       author="Luca Canali",
@@ -17,7 +17,7 @@
       url="http://packages.python.org/sqlpython",
       packages=find_packages(),
       include_package_data=True,    
-      install_requires=['pyparsing','cmd2>=0.5.0','cx_Oracle','genshi>=0.5'],
+      install_requires=['pyparsing','cmd2>=0.5.2','cx_Oracle','genshi>=0.5','sqlalchemy'],
       keywords = 'client oracle database',
       license = 'MIT',
       platforms = ['any'],
--- a/sqlpython/exampleSession.txt	Fri Apr 03 08:00:45 2009 -0400
+++ b/sqlpython/exampleSession.txt	Fri Apr 03 13:09:54 2009 -0400
@@ -5,11 +5,13 @@
 privilege (`GRANT RESOURCE TO testschema`).
 
 SQL.No_Connection> connect testschema/testschema@orcl
+0:testschema@orcl> drop table play;
+/.*/
 0:testschema@orcl> CREATE TABLE play (
 >   title   VARCHAR2(40) CONSTRAINT xpk_play PRIMARY KEY,
 >   author  VARCHAR2(40));
 
-Executed (1 rows)
+Executed
 
 0:testschema@orcl> INSERT INTO play VALUES ('Twelfth Night', 'Shakespeare');
 
@@ -49,6 +51,15 @@
 
 2 rows selected.
 
+0:testschema@orcl> ls -l
+
+NAME           STATUS LAST_DDL_TIME
+-------------- ------ -------------------
+INDEX/XPK_PLAY VALID  /[\\d\\- :]*/
+TABLE/PLAY     VALID  /[\\d\\- :]*/
+
+2 rows selected.
+
 0:testschema@orcl> ls table/*
 
 NAME      
--- a/sqlpython/mysqlpy.py	Fri Apr 03 08:00:45 2009 -0400
+++ b/sqlpython/mysqlpy.py	Fri Apr 03 13:09:54 2009 -0400
@@ -1,5 +1,5 @@
 #!/usr/bin/python
-# MySqlPy V1.6.3
+# MySqlPy V1.6.4
 # Author: Luca.Canali@cern.ch
 # 
 #
@@ -14,9 +14,9 @@
 
 class mysqlpy(sqlpyPlus):
     '''
-MySqlPy V1.6.3 - 'sqlplus in python'
+MySqlPy V1.6.4 - 'sqlplus in python'
 Author: Luca.Canali@cern.ch
-Rev: 1.6.3, 30-Mar-09
+Rev: 1.6.4, 03-Apr-09
 
 Companion of SqlPython, a python module that reproduces Oracle's command line within python
 and sqlpyPlus. Major contributions by Catherine Devlin, http://catherinedevlin.blogspot.com
@@ -204,14 +204,6 @@
     
 class TestCase(Cmd2TestCase):
     CmdApp = mysqlpy
-    def setUp(self):
-        Cmd2TestCase.setUp(self)
-        try:
-            sqlalchemy.create_engine('oracle://testschema:testschema@orcl'
-                                 ).connect().connection.cursor().execute(
-                                     'DROP TABLE play')
-        except:
-            pass   
 
 if __name__ == '__main__':
     parser = optparse.OptionParser()
--- a/sqlpython/sqlpython.py	Fri Apr 03 08:00:45 2009 -0400
+++ b/sqlpython/sqlpython.py	Fri Apr 03 13:09:54 2009 -0400
@@ -1,7 +1,7 @@
 #
-# SqlPython V1.7.0
+# SqlPython V1.6.4
 # Author: Luca.Canali@cern.ch, Apr 2006
-# Rev 30-Mar-09
+# Rev 03-Apr-09
 #
 # A python module to reproduce Oracle's command line 'sqlplus-like' within python
 # Intended to allow easy customizations and extentions 
@@ -10,7 +10,7 @@
 
 import cmd2,getpass,binascii,cx_Oracle,re,os
 import sqlpyPlus, sqlalchemy
-__version__ = '1.7.0'    
+__version__ = '1.6.4'    
 
 class sqlpython(cmd2.Cmd):
     '''A python module to reproduce Oracle's command line with focus on customization and extention'''