[Zope-Checkins] CVS: Products/DCOracle2/test - test15.py:1.1.2.1 common.py:1.4.4.1 procdef.sql:1.11.4.1 test9.py:1.9.4.1

[Matthew T. Kromer]

Update of /cvs-repository/Products/DCOracle2/test
In directory cvs.zope.org:/tmp/cvs-serv29837/test

Modified Files:
      Tag: dco2-object-branch
	common.py procdef.sql test9.py 
Added Files:
      Tag: dco2-object-branch
	test15.py 
Log Message:
Fix some TABLE OF problems for Origin systems


=== Added File Products/DCOracle2/test/test15.py ===

# This assumes that the procdef.sql script has been run
#
# test input manual bindings for TABLE OF VARCHAR2
#


import DCOracle2
import common
import sys

#r = sys.stdin.read()

db = DCOracle2.connect(common.getConnectionString())
c = db.cursor()
#bao = db.BindingArray(10, 64, 'SQLT_STR')

#print len(bao)

#c.execute("begin :1 := emp_actions.find(7902); end;", bao)

#print len(bao)
#print bao[0]

bao = db.BindingArray(10,20,'SQLT_STR')
bao[0] = 'Mary'
bao[1] = 'Had'
bao[2] = 'A'
bao[3] = 'Little'
bao[4] = 'Lamb'

print c.execute("begin emp_actions.taketab(:1); end;", bao)

print c.procedures.emp_actions.taketab(bao)


print c.procedures.emp_actions.taketab(['Mary','had','a','little','lamb'])


=== Products/DCOracle2/test/common.py 1.4 => 1.4.4.1 ===
     "fizzle.mi.org":  "scott/tiger@bane",
     "sidhe.mi.org":     "scott/tiger@sidhe",
-    "djinn.digicool.com":  "scott/tiger"
+    "djinn.digicool.com":  "scott/tiger",
+    "djinn.zope.com":  "scott/tiger"
 }
 
 


=== Products/DCOracle2/test/procdef.sql 1.11 => 1.11.4.1 ===
 create or replace package EMP_ACTIONS as
 	type ref_cursor is ref cursor;
-	type string_tab is varray(20) of varchar2;
+	type string_tab is table of varchar2(20) index by binary_integer;
 
 	function FIND (
 		EMPID integer


=== Products/DCOracle2/test/test9.py 1.9 => 1.9.4.1 ===
 d = db.describe('emp_actions')
 
+print db.decodedesc(d); sys.exit(0)
+
+
 #pprint(db.collapsedesc(d))
 
 e = db.describe('emp')