#
#  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_007_pConnPassingOpts(self):
        obj = IbmDbTestFunctions()
        obj.assert_expect(self.run_test_007)

    def run_test_007(self):
        options1 = {ibm_db.SQL_ATTR_CURSOR_TYPE: ibm_db.SQL_CURSOR_KEYSET_DRIVEN}
        options2 = {ibm_db.SQL_ATTR_CURSOR_TYPE: ibm_db.SQL_CURSOR_FORWARD_ONLY}

        if sys.platform == 'zos':
            conn = ibm_db.pconnect(config.database,'','')
        else:
            conn = ibm_db.pconnect(config.database, config.user, config.password)

        if conn:
            try:
                serverinfo = ibm_db.server_info( conn )
                if (serverinfo.DBMS_NAME[0:3] == 'IDS'):
                    options1 = options2

                stmt = ibm_db.prepare(conn, "SELECT name FROM animals WHERE weight < 10.0", options2)
                ibm_db.execute(stmt)
                data = ibm_db.fetch_both(stmt)
                while ( data ):
                    print (data[0].strip())
                    data = ibm_db.fetch_both(stmt)

                print ("")

                stmt = ibm_db.prepare(conn, "SELECT name FROM animals WHERE weight < 10.0", options1)
                ibm_db.execute(stmt)
                data = ibm_db.fetch_both(stmt)
                while ( data ):
                    print (data[0].strip())
                    data = ibm_db.fetch_both(stmt)
            finally:
                ibm_db.close(conn)
        else:
            print ("Connection failed.")

#__END__
#__LUW_EXPECTED__
#Pook
#Bubbles
#Gizmo
#Rickety Ride
#
#Pook
#Bubbles
#Gizmo
#Rickety Ride
#__ZOS_EXPECTED__
#Pook
#Bubbles
#Gizmo
#Rickety Ride
#
#Pook
#Bubbles
#Gizmo
#Rickety Ride
#__SYSTEMI_EXPECTED__
#Pook
#Bubbles
#Gizmo
#Rickety Ride
#
#Pook
#Bubbles
#Gizmo
#Rickety Ride
#__IDS_EXPECTED__
#Pook
#Bubbles
#Gizmo
#Rickety Ride
#
#Pook
#Bubbles
#Gizmo
#Rickety Ride