#
# Licensed Materials - Property of IBM
#
# (c) Copyright IBM Corp. 2007-2008
#
from __future__ import print_function
import sys
import unittest
import ibm_db
import config
from testfunctions import IbmDbTestFunctions
class IbmDbTestCase(unittest.TestCase):
def test_047_FetchTupleMany_06(self):
obj = IbmDbTestFunctions()
obj.assert_expect(self.run_test_047)
def run_test_047(self):
conn = ibm_db.connect(config.database, config.user, config.password)
server = ibm_db.server_info( conn )
if (server.DBMS_NAME[0:3] == 'IDS'):
result = ibm_db.exec_immediate(conn, "SELECT empno, photo_format, photo_format from emp_photo")
else:
result = ibm_db.exec_immediate(conn, "SELECT empno, photo_format, length(PICTURE) from emp_photo")
row = ibm_db.fetch_tuple(result)
while ( row ):
if (row[1] == 'gif'):
print("
\n" % (row[0], row[1]))
if (row[1] != 'xwd'):
print("%s - %s - %s bytes\n
" % (row[0], row[1], row[0], row[1], row[2]))
row = ibm_db.fetch_tuple(result)
#__END__
#__LUW_EXPECTED__
#000130 - jpg - 15398 bytes
#
000130 - png - 10291 bytes
#
000140 - jpg - 15398 bytes
#
000140 - png - 10291 bytes
#
000150 - jpg - 15398 bytes
#
000150 - png - 10291 bytes
#
000190 - jpg - 15398 bytes
#
000190 - png - 10291 bytes
#
#__ZOS_EXPECTED__
#000130 - jpg - 15398 bytes
#
000130 - png - 10291 bytes
#
000140 - jpg - 15398 bytes
#
000140 - png - 10291 bytes
#
000150 - jpg - 15398 bytes
#
000150 - png - 10291 bytes
#
000190 - jpg - 15398 bytes
#
000190 - png - 10291 bytes
#
#__SYSTEMI_EXPECTED__
#000130 - jpg - 15398 bytes
#
000130 - png - 10291 bytes
#
000140 - jpg - 15398 bytes
#
000140 - png - 10291 bytes
#
000150 - jpg - 15398 bytes
#
000150 - png - 10291 bytes
#
000190 - jpg - 15398 bytes
#
000190 - png - 10291 bytes
#
#__IDS_EXPECTED__
#000130 - jpg - jpg bytes
#
000130 - png - png bytes
#
000140 - jpg - jpg bytes
#
000140 - png - png bytes
#
000150 - jpg - jpg bytes
#
000150 - png - png bytes
#
000190 - jpg - jpg bytes
#
000190 - png - png bytes
#