#
#  Licensed Materials - Property of IBM
#
#  (c) Copyright IBM Corp. 2007-2008
#
# NOTE: IDS requires that you pass the schema name (cannot pass None)

from __future__ import print_function
import sys
import unittest
import ibm_db
import config
from testfunctions import IbmDbTestFunctions

class IbmDbTestCase(unittest.TestCase):

    def test_191_ColumnsTable_02(self):
        obj = IbmDbTestFunctions()
        obj.assert_expectf(self.run_test_191)

    def run_test_191(self):
        conn = ibm_db.connect(config.database, config.user, config.password)
        server = ibm_db.server_info( conn )

        if conn:
            if (server.DBMS_NAME[0:3] == 'IDS'):
                result = ibm_db.columns(conn,None,config.user,"emp_photo");
            else:
                result = ibm_db.columns(conn,None,None,"EMP_PHOTO");

            i = 0
            row = ibm_db.fetch_both(result)
            while ( row ):
                if (server.DBMS_NAME[0:3] == 'IDS'):
                    if ( (row['column_name'] != 'emp_rowid') and (i < 3) ):
                        print("%s,%s,%s,%s\n" % (row['table_schem'],
                        row['table_name'], row['column_name'], row['is_nullable']))
                else :
                    if ( (row['COLUMN_NAME'] != 'EMP_ROWID') and (i < 3) ):
                        print("%s,%s,%s,%s\n" % (row['TABLE_SCHEM'],
                        row['TABLE_NAME'], row['COLUMN_NAME'], row['IS_NULLABLE']))
                i = i + 1
                row = ibm_db.fetch_both(result)
            print("done!")
        else:
            print("no connection: ", ibm_db.conn_errormsg())

#__END__
#__LUW_EXPECTED__
#%s,EMP_PHOTO,EMPNO,NO
#%s,EMP_PHOTO,PHOTO_FORMAT,NO
#%s,EMP_PHOTO,PICTURE,YES
#done!
#__ZOS_EXPECTED__
#%s,EMP_PHOTO,EMPNO,NO
#%s,EMP_PHOTO,PHOTO_FORMAT,NO
#%s,EMP_PHOTO,PICTURE,YES
#done!
#__SYSTEMI_EXPECTED__
#%s,EMP_PHOTO,EMPNO,NO
#%s,EMP_PHOTO,PHOTO_FORMAT,NO
#%s,EMP_PHOTO,PICTURE,YES
#done!
#__IDS_EXPECTED__
#%s,emp_photo,empno,NO
#%s,emp_photo,photo_format,NO
#%s,emp_photo,picture,YES
#done!