iframe-proxy | Sunbelt Computer Software

History

154 lines (137 loc) · 5.85 KB

Raw

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

#------------------------------------------------------------------------------

"""Module for testing LOB (CLOB and BLOB) variables."""

class TestLobVar(BaseTestCase):

def __PerformTest(self, type, inputType):

if type.endswith("CLOB"):

longString = u""

else:

longString = ""

directType = getattr(cx_Oracle, type)

self.cursor.execute(u"truncate table Test%ss" % type)

for i in range(0, 11):

if i > 0:

if type.endswith("CLOB"):

char = unichr(ord('A') + i - 1)

else:

char = chr(ord('A') + i - 1)

longString += char * 25000

elif inputType != directType:

continue

self.cursor.setinputsizes(longString = inputType)

self.cursor.execute(u"""

insert into Test%ss (

IntCol,

%sCol

) values (

:integerValue,

:longString

)""" % (type, type),

integerValue = i,

longString = longString)

self.connection.commit()

self.cursor.execute(u"""

select *

from Test%ss

order by IntCol""" % type)

longString = ""

for row in self.cursor:

integerValue, lob = row

if integerValue == 0:

self.assertEqual(lob.size(), 0)

self.assertEqual(lob.read(), "")

else:

if type.endswith("CLOB"):

char = unichr(ord('A') + integerValue - 1)

prevChar = unichr(ord('A') + integerValue - 2)

actualValue = unicode(lob)

else:

char = chr(ord('A') + integerValue - 1)

prevChar = chr(ord('A') + integerValue - 2)

actualValue = str(lob)

longString += char * 25000

self.assertEqual(lob.size(), len(longString))

self.assertEqual(lob.read(), longString)

self.assertEqual(actualValue, longString)

self.assertEqual(lob.read(len(longString)), char)

if integerValue > 1:

offset = (integerValue - 1) * 25000 - 4

string = prevChar * 5 + char * 5

self.assertEqual(lob.read(offset, 10), string)

def __TestTrim(self, type):

self.cursor.execute(u"truncate table Test%ss" % type)

self.cursor.setinputsizes(longString = getattr(cx_Oracle, type))

longString = "X" * 75000

if type.endswith("CLOB"):

longString = unicode(longString)

self.cursor.execute(u"""

insert into Test%ss (

IntCol,

%sCol

) values (

:integerValue,

:longString

)""" % (type, type),

integerValue = 1,

longString = longString)

self.cursor.execute(u"""

select %sCol

from Test%ss

where IntCol = 1""" % (type, type))

lob, = self.cursor.fetchone()

self.assertEqual(lob.size(), 75000)

lob.trim(25000)

self.assertEqual(lob.size(), 25000)

lob.trim()

self.assertEqual(lob.size(), 0)

def testBLOBCursorDescription(self):

"test cursor description is accurate for BLOBs"

self.cursor.execute(u"select * from TestBLOBs")

self.assertEqual(self.cursor.description,

[ (u'INTCOL', cx_Oracle.NUMBER, 10, None, 9, 0, 0),

(u'BLOBCOL', cx_Oracle.BLOB, None, None, None, None, 0) ])

def testBLOBsDirect(self):

"test binding and fetching BLOB data (directly)"

self.__PerformTest("BLOB", cx_Oracle.BLOB)

def testBLOBsIndirect(self):

"test binding and fetching BLOB data (indirectly)"

self.__PerformTest("BLOB", cx_Oracle.LONG_BINARY)

def testBLOBTrim(self):

"test trimming a BLOB"

self.__TestTrim("BLOB")

def testCLOBCursorDescription(self):

"test cursor description is accurate for CLOBs"

self.cursor.execute(u"select * from TestCLOBs")

self.assertEqual(self.cursor.description,

[ (u'INTCOL', cx_Oracle.NUMBER, 10, None, 9, 0, 0),

(u'CLOBCOL', cx_Oracle.CLOB, None, None, None, None, 0) ])

def testCLOBsDirect(self):

"test binding and fetching CLOB data (directly)"

self.__PerformTest("CLOB", cx_Oracle.CLOB)

def testCLOBsIndirect(self):

"test binding and fetching CLOB data (indirectly)"

self.__PerformTest("CLOB", cx_Oracle.LONG_STRING)

def testCLOBTrim(self):

"test trimming a CLOB"

self.__TestTrim("CLOB")

def testNCLOBCursorDescription(self):

"test cursor description is accurate for NCLOBs"

self.cursor.execute(u"select * from TestNCLOBs")

self.assertEqual(self.cursor.description,

[ (u'INTCOL', cx_Oracle.NUMBER, 10, None, 9, 0, 0),

(u'NCLOBCOL', cx_Oracle.NCLOB, None, None, None, None, 0) ])

def testNCLOBsDirect(self):

"test binding and fetching NCLOB data (directly)"

self.__PerformTest("NCLOB", cx_Oracle.NCLOB)

def testNCLOBsIndirect(self):

"test binding and fetching NCLOB data (indirectly)"

self.__PerformTest("NCLOB", cx_Oracle.LONG_STRING)

def testNCLOBTrim(self):

"test trimming a NCLOB"

self.__TestTrim("NCLOB")

Sunbelt Computer Software

PL/B Language Development and Support

Navigation Menu

Sunbelt Computer Software

PL/B Language Development and Support

FilesExpand file tree

uLobVar.py

Latest commit

History

uLobVar.py

File metadata and controls